ALTER TABLE companies ADD COLUMN pan VARCHAR(20) AFTER gstin;
ALTER TABLE companies ADD COLUMN tan VARCHAR(20) AFTER pan;

ALTER TABLE customers ADD COLUMN pan VARCHAR(20) AFTER gstin;
ALTER TABLE customers ADD COLUMN tan VARCHAR(20) AFTER pan;

ALTER TABLE sales ADD COLUMN customer_pan VARCHAR(20) AFTER customer_gstin;
ALTER TABLE sales ADD COLUMN customer_tan VARCHAR(20) AFTER customer_pan;

ALTER TABLE sales ADD COLUMN consignee_pan VARCHAR(20) AFTER consignee_gstin;
ALTER TABLE sales ADD COLUMN consignee_tan VARCHAR(20) AFTER consignee_pan;