From: benny <benny@roojs.com>
Date: Wed, 11 Jul 2018 03:16:36 +0000 (+0800)
Subject: sql/cost_centeres.sql
X-Git-Url: http://git.roojs.org/?p=Pman.Core;a=commitdiff_plain;h=56221e5eb05cfbef8965b5e2ada88f133c476856

sql/cost_centeres.sql
---

diff --git a/sql/cost_centeres.sql b/sql/cost_centeres.sql
new file mode 100644
index 00000000..89da40d3
--- /dev/null
+++ b/sql/cost_centeres.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;
+
+
+
+