--
-- Update site setting table with new column
--
SET sql_mode = '';
ALTER TABLE `sps_settings`   
	ADD COLUMN `location_name` VARCHAR(255) NULL AFTER `area_id`,
	ADD COLUMN `supplier_company_name` VARCHAR(255) NULL AFTER `location_name`,
	ADD COLUMN `supplier_company_addrs` VARCHAR(255) NULL AFTER `supplier_company_name`,
	ADD COLUMN `gst_in` VARCHAR(255) NULL AFTER `supplier_company_addrs`,
	ADD COLUMN `pan` VARCHAR(255) NULL AFTER `gst_in`,
	ADD COLUMN `cin` VARCHAR(255) NULL AFTER `pan`,
	ADD COLUMN `hsn_code` VARCHAR(255) NULL AFTER `cin`,
	ADD COLUMN `city_of_supply` VARCHAR(255) NULL AFTER `hsn_code`,
	ADD COLUMN `state_name_code` VARCHAR(255) NULL AFTER `city_of_supply`,
	ADD COLUMN `desc_service` VARCHAR(255) NULL AFTER `state_name_code`,
	ADD COLUMN `prefix_for_invoice` VARCHAR(255) NULL AFTER `desc_service`;

--
-- Update site setting table with new column for property logo and signature logo
--
ALTER TABLE `sps_settings`   
	ADD COLUMN `signature_image` VARCHAR(255) NULL AFTER `prefix_for_invoice`,
	ADD COLUMN `property_logo` VARCHAR(255) NULL AFTER `signature_image`;

--
-- Update table layout table with new column for signature logo
--
ALTER TABLE `sps_ticket_layouts`   
	ADD COLUMN `logo_c` VARCHAR(512) NULL AFTER `logo_b_align`,
	ADD COLUMN `logo_c_position` VARCHAR(11) NOT NULL AFTER `logo_c`,
	ADD COLUMN `logo_c_align` VARCHAR(11) NOT NULL AFTER `logo_c_position`;