From c596d457112bb3288c0d650884022f72a9d7f35c Mon Sep 17 00:00:00 2001 From: Savetheinternet Date: Tue, 12 Apr 2011 21:08:54 +1000 Subject: New `capcode` field for posts and custom capcodes (run install.php to upgrade tables) --- templates/posts.sql | 9 +++++---- 1 file changed, 5 insertions(+), 4 deletions(-) (limited to 'templates/posts.sql') diff --git a/templates/posts.sql b/templates/posts.sql index b1986aff..d57ee568 100644 --- a/templates/posts.sql +++ b/templates/posts.sql @@ -2,9 +2,10 @@ CREATE TABLE IF NOT EXISTS `posts_{board}` ( `id` int(11) NOT NULL AUTO_INCREMENT, `thread` int(11) DEFAULT NULL, `subject` varchar(40) NOT NULL, - `email` varchar(40) NOT NULL, - `name` varchar(40) NOT NULL, - `trip` varchar(100) DEFAULT NULL, + `email` varchar(30) NOT NULL, + `name` varchar(25) NOT NULL, + `trip` varchar(15) DEFAULT NULL, + `capcode` varchar(50) DEFAULT NULL, `body` text NOT NULL, `time` int(11) NOT NULL, `bump` int(11) DEFAULT NULL, @@ -22,4 +23,4 @@ CREATE TABLE IF NOT EXISTS `posts_{board}` ( `sticky` int(1) NOT NULL, `locked` int(1) NOT NULL, UNIQUE KEY `id` (`id`) -) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ; \ No newline at end of file +) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=12 ; \ No newline at end of file -- cgit v1.3