From: benny <benny@roojs.com>
Date: Fri, 13 Jul 2018 07:04:50 +0000 (+0800)
Subject: sql/account_code.sql
X-Git-Url: http://git.roojs.org/?p=Pman.Core;a=commitdiff_plain;h=393ae985be1a1ef6369f546afec92667e2681117

sql/account_code.sql
---

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;