From 393ae985be1a1ef6369f546afec92667e2681117 Mon Sep 17 00:00:00 2001 From: benny Date: Fri, 13 Jul 2018 15:04:50 +0800 Subject: [PATCH] sql/account_code.sql --- sql/account_code.sql | 13 ++++++++----- 1 file changed, 8 insertions(+), 5 deletions(-) diff --git a/sql/account_code.sql b/sql/account_code.sql index 89da40d3..5b47c65c 100644 --- a/sql/account_code.sql +++ b/sql/account_code.sql @@ -1,12 +1,15 @@ -CREATE TABLE cost_centers ( +CREATE TABLE account_code ( id INT(11) NOT NULL AUTO_INCREMENT , - short_name VARCHAR(8) NULL, - name VARCHAR(32) NULL, + name VARCHAR(8) NULL, + description VARCHAR(64) NULL, + cost_center INT(11) NULL, + accpac VARCHAR(32) NULL, + accpac_out VARCHAR(32) NULL, PRIMARY KEY (id) ); -ALTER TABLE cost_centers CHANGE COLUMN is_active is_active INT(2) NOT NULL DEFAULT 1; -ALTER TABLE cost_centers ADD COLUMN is_active INT(2) NOT NULL DEFAULT 1; +ALTER TABLE account_code CHANGE COLUMN is_active is_active INT(2) NOT NULL DEFAULT 1; +ALTER TABLE account_code ADD COLUMN is_active INT(2) NOT NULL DEFAULT 1; -- 2.39.2