From 0d77c8b5668800fc16a2d62370f762440d7cf7d8 Mon Sep 17 00:00:00 2001 From: hylom Date: Thu, 6 Oct 2016 22:35:00 +0900 Subject: [PATCH] utils: add db_scripts --- src/utils/db_scripts/sqls/firehose_text.sql | 8 ++++++++ src/utils/db_scripts/sqls/submission_param.sql | 8 ++++++++ 2 files changed, 16 insertions(+) create mode 100644 src/utils/db_scripts/sqls/firehose_text.sql create mode 100644 src/utils/db_scripts/sqls/submission_param.sql diff --git a/src/utils/db_scripts/sqls/firehose_text.sql b/src/utils/db_scripts/sqls/firehose_text.sql new file mode 100644 index 00000000..d7ef8f39 --- /dev/null +++ b/src/utils/db_scripts/sqls/firehose_text.sql @@ -0,0 +1,8 @@ +CREATE TABLE IF NOT EXISTS `firehose_text` ( + `id` int(8) unsigned NOT NULL AUTO_INCREMENT, + `title` varchar(80) DEFAULT NULL, + `introtext` mediumtext, + `bodytext` mediumtext, + `media` mediumtext, + PRIMARY KEY (`id`) +) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 ROW_FORMAT=DYNAMIC diff --git a/src/utils/db_scripts/sqls/submission_param.sql b/src/utils/db_scripts/sqls/submission_param.sql new file mode 100644 index 00000000..7b9ab0a4 --- /dev/null +++ b/src/utils/db_scripts/sqls/submission_param.sql @@ -0,0 +1,8 @@ +CREATE TABLE IF NOT EXISTS `submission_param` ( + `param_id` mediumint(8) unsigned NOT NULL AUTO_INCREMENT, + `subid` mediumint(8) unsigned NOT NULL DEFAULT '0', + `name` varchar(32) NOT NULL DEFAULT '', + `value` mediumtext NOT NULL, + PRIMARY KEY (`param_id`), + UNIQUE KEY `submission_key` (`subid`,`name`) +) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 ROW_FORMAT=DYNAMIC -- 2.11.0