projects
/
Pman.Core
/ commitdiff
commit
grep
author
committer
pickaxe
?
search:
re
summary
|
shortlog
|
log
|
commit
| commitdiff |
tree
raw
|
patch
|
inline
| side by side (parent:
14e5171
)
Uncommited changes synced
author
Alan Knowles
<alan@roojs.com>
Fri, 16 Nov 2018 04:44:11 +0000
(12:44 +0800)
committer
Alan Knowles
<alan@roojs.com>
Fri, 16 Nov 2018 04:44:11 +0000
(12:44 +0800)
sql/core_setting.sql
patch
|
blob
|
history
diff --git
a/sql/core_setting.sql
b/sql/core_setting.sql
index
97881bd
..
d3956d8
100644
(file)
--- 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 module VARCHAR(64) NOT NULL DEFAULT '';
-
ALTER TABLE core_setting ADD COLUMN name 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 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 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_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
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