From 66d06015e343607db1f62df76d0a4bae13725513 Mon Sep 17 00:00:00 2001 From: Savetheinternet Date: Thu, 14 Jul 2011 11:18:03 +1000 Subject: made `filehash` TEXT instead of a varchar (fixed maximum length) --- templates/posts.sql | 4 ++-- 1 file changed, 2 insertions(+), 2 deletions(-) (limited to 'templates/posts.sql') diff --git a/templates/posts.sql b/templates/posts.sql index 7aec0612..cf8718d2 100644 --- a/templates/posts.sql +++ b/templates/posts.sql @@ -17,11 +17,11 @@ CREATE TABLE IF NOT EXISTS `posts_{board}` ( `fileheight` int(11) DEFAULT NULL, `filesize` int(11) DEFAULT NULL, `filename` varchar(30) DEFAULT NULL, - `filehash` varchar(40) DEFAULT NULL, + `filehash` text DEFAULT NULL, `password` varchar(20) DEFAULT NULL, `ip` varchar(45) NOT NULL, `sticky` int(1) NOT NULL, `locked` int(1) NOT NULL, `embed` text, 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=1 ; -- cgit v1.3