ALTER TABLE customers ADD COLUMN tin VARCHAR(20) AFTER gstin;
ALTER TABLE customers ADD COLUMN state_name VARCHAR(100) AFTER tin;
ALTER TABLE customers ADD COLUMN state_code VARCHAR(10) AFTER state_name;
ALTER TABLE customers ADD COLUMN consignee_name VARCHAR(255) AFTER state_code;
ALTER TABLE customers ADD COLUMN consignee_phone VARCHAR(20) AFTER consignee_name;
ALTER TABLE customers ADD COLUMN consignee_email VARCHAR(100) AFTER consignee_phone;
ALTER TABLE customers ADD COLUMN consignee_address TEXT AFTER consignee_email;
ALTER TABLE customers ADD COLUMN consignee_gstin VARCHAR(20) AFTER consignee_address;
ALTER TABLE customers ADD COLUMN consignee_tin VARCHAR(20) AFTER consignee_gstin;
ALTER TABLE customers ADD COLUMN consignee_pan VARCHAR(20) AFTER consignee_tin;
ALTER TABLE customers ADD COLUMN consignee_tan VARCHAR(20) AFTER consignee_pan;
ALTER TABLE customers ADD COLUMN consignee_state_name VARCHAR(100) AFTER consignee_tan;
ALTER TABLE customers ADD COLUMN consignee_state_code VARCHAR(10) AFTER consignee_state_name;