1 CREATE TABLE cost_centers (
2 id INT(11) NOT NULL AUTO_INCREMENT ,
3 short_name VARCHAR(8) NULL,
8 ALTER TABLE cost_centers CHANGE COLUMN is_active is_active INT(2) NOT NULL DEFAULT 1;
9 ALTER TABLE cost_centers ADD COLUMN is_active INT(2) NOT NULL DEFAULT 1;