-- ==============================================================
-- RUN THIS ONE FILE ONCE in phpMyAdmin (wbcorp_webapp).
-- New migrations: 12 (show tare switch) + 13 (company profile / logo).
-- ==============================================================

-- Run once in phpMyAdmin.
-- SuperAdmin switch: print the Tare weight column on the ticket (1 = show, 0 = hide).
ALTER TABLE tblTransaction_Setting ADD COLUMN show_tare_on_ticket TINYINT(1) NOT NULL DEFAULT 1;

-- Run once in phpMyAdmin.
-- Company details printed in the ticket header (address, contact, registration no.) and the company logo (top-left of the ticket).
ALTER TABLE tblCompany
  ADD COLUMN address TEXT NULL,
  ADD COLUMN phone VARCHAR(40) NULL,
  ADD COLUMN email VARCHAR(120) NULL,
  ADD COLUMN reg_no VARCHAR(60) NULL,
  ADD COLUMN logo_path VARCHAR(255) NULL;