sql/core_setting.sql

diff --git a/sql/core_setting.sql b/sql/core_setting.sql
new file mode 100644 (file)
index 0000000..36966d6
--- /dev/null
+++ b/sql/core_setting.sql
@@ -0,0 +1,17 @@
+CREATE TABLE  core_setting  (
+   id int(11)  NOT NULL AUTO_INCREMENT,
+   PRIMARY KEY (id)
+);
+
+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;
+
+
+
+
+
+