diff options
| author | Savetheinternet <savetheinternet@n0v4.com> | 2011-04-12 21:08:54 +1000 |
|---|---|---|
| committer | Savetheinternet <savetheinternet@n0v4.com> | 2011-04-12 21:08:54 +1000 |
| commit | c596d457112bb3288c0d650884022f72a9d7f35c (patch) | |
| tree | c26e9bcfa138b47641328460235a94b3c5fd035f /install.sql | |
| parent | 614491880fb8b1efa7b6edd9a360af2e35e18af1 (diff) | |
New `capcode` field for posts and custom capcodes (run install.php to upgrade tables)
Diffstat (limited to 'install.sql')
| -rw-r--r-- | install.sql | 5 |
1 files changed, 3 insertions, 2 deletions
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` |