X-Git-Url: http://git.roojs.org/?a=blobdiff_plain;f=sql%2Fcore_setting.sql;h=d3956d87f651e153c9f1be4c7111988fd99e8c0d;hb=c1af5e6bb6064e88469651271f4d9aaff34d69c0;hp=36966d6c87a391ea656c00bbb139a0d02227ed82;hpb=85522832c3c834e6f3a72b2a44823051358f3f26;p=Pman.Core

diff --git a/sql/core_setting.sql b/sql/core_setting.sql
index 36966d6c..d3956d87 100644
--- a/sql/core_setting.sql
+++ b/sql/core_setting.sql
@@ -6,12 +6,10 @@ 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 ADD COLUMN val VARCHAR(128) 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