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) --- install.sql | 5 +++-- 1 file changed, 3 insertions(+), 2 deletions(-) (limited to 'install.sql') diff --git a/install.sql b/install.sql index a23b9796..3e85de98 100644 --- a/install.sql +++ b/install.sql @@ -185,7 +185,8 @@ CREATE TABLE IF NOT EXISTS `posts_b` ( `subject` varchar(40) NOT NULL, `email` varchar(30) NOT NULL, `name` varchar(25) NOT NULL, - `trip` varchar(100) DEFAULT 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, @@ -203,7 +204,7 @@ CREATE TABLE IF NOT EXISTS `posts_b` ( `sticky` int(1) NOT NULL, `locked` int(1) NOT NULL, UNIQUE KEY `id` (`id`) -) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ; +) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=12 ; -- -- Dumping data for table `posts_b` -- cgit v1.3