PHP7 fix

[Pman.Core] / sql / core_setting.sql

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