diff options
Diffstat (limited to 'templates/posts.sql')
| -rw-r--r-- | templates/posts.sql | 12 |
1 files changed, 3 insertions, 9 deletions
diff --git a/templates/posts.sql b/templates/posts.sql index c1f491f2..9a47c6ad 100644 --- a/templates/posts.sql +++ b/templates/posts.sql @@ -10,14 +10,8 @@ CREATE TABLE IF NOT EXISTS ``posts_{{ board }}`` ( `body_nomarkup` text, `time` int(11) NOT NULL, `bump` int(11) DEFAULT NULL, - `thumb` varchar(255) DEFAULT NULL, - `thumbwidth` int(11) DEFAULT NULL, - `thumbheight` int(11) DEFAULT NULL, - `file` varchar(255) DEFAULT NULL, - `filewidth` int(11) DEFAULT NULL, - `fileheight` int(11) DEFAULT NULL, - `filesize` int(11) DEFAULT NULL, - `filename` text, + `files` text DEFAULT NULL, + `num_files` int(11) DEFAULT 0, `filehash` text CHARACTER SET ascii, `password` varchar(20) DEFAULT NULL, `ip` varchar(39) CHARACTER SET ascii NOT NULL, @@ -32,4 +26,4 @@ CREATE TABLE IF NOT EXISTS ``posts_{{ board }}`` ( KEY `ip` (`ip`), KEY `list_threads` (`thread`, `sticky`, `bump`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4 AUTO_INCREMENT=1 ; -
\ No newline at end of file + |
