From: john <john@roojs.com>
Date: Tue, 3 Apr 2018 03:21:58 +0000 (+0800)
Subject: sql/core_setting.sql
X-Git-Url: http://git.roojs.org/?p=Pman.Core;a=commitdiff_plain;h=85522832c3c834e6f3a72b2a44823051358f3f26

sql/core_setting.sql
---

diff --git a/sql/core_setting.sql b/sql/core_setting.sql
new file mode 100644
index 00000000..36966d6c
--- /dev/null
+++ b/sql/core_setting.sql
@@ -0,0 +1,17 @@
+CREATE TABLE  core_setting  (
+   id int(11)  NOT NULL AUTO_INCREMENT,
+   PRIMARY KEY (id)
+);
+
+ALTER TABLE core_setting ADD COLUMN module VARCHAR(64) NOT NULL DEFAULT '';
+ALTER TABLE core_setting ADD COLUMN name VARCHAR(64) NOT NULL DEFAULT '';
+ALTER TABLE core_setting ADD COLUMN description VARCHAR(128) NOT NULL DEFAULT '';
+ALTER TABLE core_setting ADD COLUMN val VARCHAR(128) NOT NULL DEFAULT '';
+ALTER TABLE core_setting ADD COLUMN updated_dt DATE NOT NULL DEFAULT '0000-00-00';
+ALTER TABLE core_setting ADD COLUMN is_encrypt INT(2) NOT NULL DEFAULT 1;
+
+
+
+
+
+