diff options
| author | Savetheinternet <savetheinternet@n0v4.com> | 2011-02-16 15:08:17 +1100 |
|---|---|---|
| committer | Savetheinternet <savetheinternet@n0v4.com> | 2011-02-16 15:08:17 +1100 |
| commit | afbd0c6473f864736bacab28035dfd3702c5d231 (patch) | |
| tree | 1f0b9781ce3b8baafc0f38eda11137d597147672 /templates/posts.sql | |
| parent | 392ae5f6e400c23ba0cf1e2a16137e23fb8390ba (diff) | |
| parent | 44d280e120a3c7e1912f101c6ce8f8dfaf963cc8 (diff) | |
merged mod branch
Diffstat (limited to 'templates/posts.sql')
| -rw-r--r-- | templates/posts.sql | 25 |
1 files changed, 25 insertions, 0 deletions
diff --git a/templates/posts.sql b/templates/posts.sql new file mode 100644 index 00000000..f8e1b6fb --- /dev/null +++ b/templates/posts.sql @@ -0,0 +1,25 @@ +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(30) NOT NULL, + `name` varchar(25) NOT NULL, + `trip` varchar(45) DEFAULT NULL, + `body` text NOT NULL, + `time` int(11) NOT NULL, + `bump` int(11) DEFAULT NULL, + `thumb` varchar(50) DEFAULT NULL, + `thumbwidth` int(11) DEFAULT NULL, + `thumbheight` int(11) DEFAULT NULL, + `file` varchar(50) DEFAULT NULL, + `filewidth` int(11) DEFAULT NULL, + `fileheight` int(11) DEFAULT NULL, + `filesize` int(11) DEFAULT NULL, + `filename` varchar(30) DEFAULT NULL, + `filehash` varchar(32) DEFAULT NULL, + `password` varchar(20) DEFAULT NULL, + `ip` varchar(15) NOT NULL, + `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 |