From 938a536d05eca9538ce66dd5cf3d1b500705b523 Mon Sep 17 00:00:00 2001
From: benny <benny@roojs.com>
Date: Fri, 13 Jul 2018 15:01:37 +0800
Subject: [PATCH] MOVED sql/cost_centeres_1.sql to sql/account_code.sql

---
 sql/account_code.sql | 13 +++++++++++++
 1 file changed, 13 insertions(+)
 create mode 100644 sql/account_code.sql

diff --git a/sql/account_code.sql b/sql/account_code.sql
new file mode 100644
index 00000000..89da40d3
--- /dev/null
+++ b/sql/account_code.sql
@@ -0,0 +1,13 @@
+CREATE  TABLE cost_centers (
+  id INT(11) NOT NULL AUTO_INCREMENT ,
+  short_name VARCHAR(8) NULL,
+  name 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;
+
+
+
+
-- 
2.39.2