diff options
| author | Savetheinternet <savetheinternet@n0v4.com> | 2010-12-02 20:50:14 +1100 |
|---|---|---|
| committer | Savetheinternet <savetheinternet@n0v4.com> | 2010-12-02 20:50:14 +1100 |
| commit | 3679f2c78b4ad4c4204738ab0739c9aaad88f751 (patch) | |
| tree | 93e7e661a42d1efd363e020fd4e717e13338df08 /templates | |
| parent | 41daaa16b16146fa90461d514f31a90c71d3b402 (diff) | |
SQL table creation template
Diffstat (limited to 'templates')
| -rw-r--r-- | templates/posts.sql | 23 |
1 files changed, 23 insertions, 0 deletions
diff --git a/templates/posts.sql b/templates/posts.sql new file mode 100644 index 00000000..d9c91886 --- /dev/null +++ b/templates/posts.sql @@ -0,0 +1,23 @@ +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(15) 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, + UNIQUE KEY `id` (`id`) +) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;
\ No newline at end of file |