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 /templates/posts.sql | |
| parent | 614491880fb8b1efa7b6edd9a360af2e35e18af1 (diff) | |
New `capcode` field for posts and custom capcodes (run install.php to upgrade tables)
Diffstat (limited to 'templates/posts.sql')
| -rw-r--r-- | templates/posts.sql | 9 |
1 files changed, 5 insertions, 4 deletions
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 |