From a2c032a69988e1cec4124a62d15d0d48f099958d Mon Sep 17 00:00:00 2001 From: Alan Knowles Date: Fri, 16 Nov 2018 12:44:11 +0800 Subject: [PATCH] Uncommited changes synced --- sql/core_setting.sql | 10 ++-------- 1 file changed, 2 insertions(+), 8 deletions(-) diff --git a/sql/core_setting.sql b/sql/core_setting.sql index 97881bdd..d3956d87 100644 --- a/sql/core_setting.sql +++ b/sql/core_setting.sql @@ -4,18 +4,12 @@ CREATE TABLE core_setting ( ); 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 CHANGE COLUMN val val TEXT DEFAULT ''; -ALTER TABLE core_setting ADD COLUMN val TEXT NOT NULL DEFAULT ''; - +ALTER TABLE core_setting CHANGE COLUMN val val BLOB DEFAULT ''; +ALTER TABLE core_setting ADD COLUMN val BLOB 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; - ALTER TABLE core_setting ADD COLUMN is_valid INT(2) NOT NULL DEFAULT 0; ALTER TABLE core_setting ADD INDEX lookup_module_name(module, name); \ No newline at end of file -- 2.39.2