-- Run once in phpMyAdmin.
-- 1) More SuperAdmin "Allow ..." switches (all default ON = nothing changes until you switch one off).
ALTER TABLE tblTransaction_Setting
  ADD COLUMN allow_deduction TINYINT(1) NOT NULL DEFAULT 1,
  ADD COLUMN allow_pricing TINYINT(1) NOT NULL DEFAULT 1,
  ADD COLUMN allow_camera TINYINT(1) NOT NULL DEFAULT 1,
  ADD COLUMN allow_edit_transaction TINYINT(1) NOT NULL DEFAULT 1,
  ADD COLUMN allow_void_transaction TINYINT(1) NOT NULL DEFAULT 1,
  ADD COLUMN allow_email_ticket TINYINT(1) NOT NULL DEFAULT 1;
-- 2) Items can be typed on the weighing screen: an item that is not in the master is kept as text on the line.
ALTER TABLE tblTransaction_Item_Line MODIFY item_id INT NULL, ADD COLUMN item_text VARCHAR(100) NULL;
ALTER TABLE tblTransaction_Weighing ADD COLUMN item_text VARCHAR(100) NULL;