7 lines
345 B
SQL
7 lines
345 B
SQL
-- Add CTR No and VAT No to companies table
|
|
ALTER TABLE companies ADD COLUMN ctr_no VARCHAR(50) DEFAULT NULL AFTER vat_number;
|
|
ALTER TABLE companies ADD COLUMN vat_no VARCHAR(50) DEFAULT NULL AFTER ctr_no;
|
|
|
|
-- Migrate existing vat_number to vat_no if any
|
|
UPDATE companies SET vat_no = vat_number WHERE vat_no IS NULL AND vat_number IS NOT NULL;
|