1 CREATE TABLE account_code (
2 id INT(11) NOT NULL AUTO_INCREMENT ,
4 description VARCHAR(64) NULL,
5 cost_center INT(11) NULL,
6 accpac VARCHAR(32) NULL,
7 accpac_out VARCHAR(32) NULL,
11 ALTER TABLE account_code CHANGE COLUMN is_active is_active INT(2) NOT NULL DEFAULT 1;
12 ALTER TABLE account_code ADD COLUMN is_active INT(2) NOT NULL DEFAULT 1;