X-Git-Url: http://git.roojs.org/?p=Pman.Core;a=blobdiff_plain;f=sql%2Fcore_setting.sql;h=82f66215f6b0e6b32531c9d08bfc44eb9f4416b2;hp=36966d6c87a391ea656c00bbb139a0d02227ed82;hb=8005ba1b21b6051e322d8e0b74845e0c8421da1d;hpb=fd03e24164d32133205696dd79c769947841b463

diff --git a/sql/core_setting.sql b/sql/core_setting.sql
index 36966d6c..82f66215 100644
--- a/sql/core_setting.sql
+++ b/sql/core_setting.sql
@@ -4,14 +4,17 @@ 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 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 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 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 INDEX lookup_module_name(module, name);
\ No newline at end of file