diff options
| author | Benjamin Southall <applemansigloo@gmail.com> | 2017-09-03 23:39:43 +0900 |
|---|---|---|
| committer | Benjamin Southall <applemansigloo@gmail.com> | 2017-09-03 23:39:43 +0900 |
| commit | 6041e3721659d59119181f29f2be1066c45db616 (patch) | |
| tree | a8d47ea24c37b5dd851d520939e2156cd70f24ac /install.sql | |
| parent | 3f908ebfa46741c30df83d37c8d3b60c444f8bf3 (diff) | |
Add warning without ban, joke capcode support, SC editor support, home link support, table for calender theme / extension, removing boardalias duplicate citations in markup and other features
Diffstat (limited to 'install.sql')
| -rw-r--r-- | install.sql | 15 |
1 files changed, 12 insertions, 3 deletions
diff --git a/install.sql b/install.sql index c7f1b021..c1b3827d 100644 --- a/install.sql +++ b/install.sql @@ -305,8 +305,8 @@ CREATE TABLE IF NOT EXISTS `ban_appeals` ( CREATE TABLE `pages` ( `id` int(11) NOT NULL AUTO_INCREMENT, - `board` varchar(58) CHARACTER SET utf8 DEFAULT NULL, - `name` varchar(255) CHARACTER SET utf8 NOT NULL, + `board` varchar(125) DEFAULT NULL, + `name` varchar(125) NOT NULL, `title` varchar(255) DEFAULT NULL, `type` varchar(255) DEFAULT NULL, `content` text, @@ -321,7 +321,7 @@ CREATE TABLE `pages` ( -- CREATE TABLE `nntp_references` ( - `board` varchar(30) NOT NULL, + `board` varchar(60) NOT NULL, `id` int(11) unsigned NOT NULL, `message_id` varchar(255) CHARACTER SET ascii NOT NULL, `message_id_digest` varchar(40) CHARACTER SET ascii NOT NULL, @@ -333,6 +333,15 @@ CREATE TABLE `nntp_references` ( ) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4; +CREATE TABLE IF NOT EXISTS `calendar_events` ( + `id` int(11) NOT NULL AUTO_INCREMENT, + `title` varchar(255) NOT NULL, + `description` text NOT NULL, + `start` datetime NOT NULL, + `end` datetime NOT NULL, + PRIMARY KEY (`id`) +) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4; + /*!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 */; |