From 85522832c3c834e6f3a72b2a44823051358f3f26 Mon Sep 17 00:00:00 2001 From: john Date: Tue, 3 Apr 2018 11:21:58 +0800 Subject: [PATCH] sql/core_setting.sql --- sql/core_setting.sql | 17 +++++++++++++++++ 1 file changed, 17 insertions(+) create mode 100644 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; + + + + + + -- 2.39.2