sync

[Pman.Core] / sql / core_setting.sql

diff --git a/sql/core_setting.sql b/sql/core_setting.sql
index 36966d6..82f6621 100644 (file)
--- 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