summaryrefslogtreecommitdiff
path: root/install.sql
diff options
context:
space:
mode:
authorFredrick Brennan <admin@8chan.co>2015-03-29 09:18:14 +0800
committerczaks <marcin@6irc.net>2016-05-06 16:03:55 +0200
commit95b1e103cb9f349d7d82dca071636d5cde855ead (patch)
tree34e863a732d57a38adfe295a767423377f3c6b79 /install.sql
parent7911c374e86ef8fa69c4545867b9d9d3de12d5c6 (diff)
Edit static pages commit
Diffstat (limited to 'install.sql')
-rw-r--r--install.sql20
1 files changed, 19 insertions, 1 deletions
diff --git a/install.sql b/install.sql
index 024cb349..720e4ed5 100644
--- a/install.sql
+++ b/install.sql
@@ -245,7 +245,7 @@ CREATE TABLE IF NOT EXISTS `search_queries` (
`ip` varchar(39) NOT NULL,
`time` int(11) NOT NULL,
`query` text NOT NULL
-) ENGINE=MyISAM DEFAULT CHARSET=utf8;
+) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4;
-- --------------------------------------------------------
@@ -297,6 +297,24 @@ CREATE TABLE IF NOT EXISTS `ban_appeals` (
KEY `ban_id` (`ban_id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4 AUTO_INCREMENT=1 ;
+-- --------------------------------------------------------
+
+--
+-- Table structure for table `pages`
+--
+
+CREATE TABLE `pages` (
+ `id` int(11) NOT NULL AUTO_INCREMENT,
+ `board` varchar(255) DEFAULT NULL,
+ `name` varchar(255) NOT NULL,
+ `title` varchar(255) DEFAULT NULL,
+ `type` varchar(255) DEFAULT NULL,
+ `content` text,
+ PRIMARY KEY (`id`),
+ UNIQUE KEY `u_pages` (`name`,`board`)
+) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4;
+
+>>>>>>> 12fa8ec... Edit static pages commit
/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
/*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */;
/*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;