X-Git-Url: http://git.roojs.org/?a=blobdiff_plain;f=sql%2Faccount_code.sql;h=5b47c65c58e6489e6a4b2b42f4b1e18ef35a48ab;hb=393ae985be1a1ef6369f546afec92667e2681117;hp=89da40d3a5121bb8f7b257406f8d4a7ea3754672;hpb=938a536d05eca9538ce66dd5cf3d1b500705b523;p=Pman.Core

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;