From f29aad03a630d623a13a31f417947add92aa81f9 Mon Sep 17 00:00:00 2001 From: Bharat Mediratta Date: Tue, 30 Dec 2008 01:37:09 +0000 Subject: Make some columns smaller so that multi-column keys don't exceed 1024 bytes on some systems. --- modules/comment/helpers/comment_installer.php | 28 +++++++++++++-------------- 1 file changed, 14 insertions(+), 14 deletions(-) (limited to 'modules/comment/helpers') diff --git a/modules/comment/helpers/comment_installer.php b/modules/comment/helpers/comment_installer.php index 71b047e5..b38b127c 100644 --- a/modules/comment/helpers/comment_installer.php +++ b/modules/comment/helpers/comment_installer.php @@ -24,20 +24,20 @@ class comment_installer { if ($version == 0) { $db->query("CREATE TABLE IF NOT EXISTS `comments` ( - `id` int(9) NOT NULL auto_increment, - `author` varchar(255) default NULL, - `email` varchar(255) default NULL, - `text` text, - `created` int(9) NOT NULL, - `item_id` int(9) NOT NULL, - `url` varchar(255) default NULL, - `published` tinyint(1) default 1, - `ip_addr` char(15) default NULL, - `user_agent` varchar(255) default NULL, - `spam_signature` varchar(255) default NULL, - `spam_type` char(15) default NULL, - PRIMARY KEY (`id`)) - ENGINE=InnoDB DEFAULT CHARSET=utf8;"); + `id` int(9) NOT NULL auto_increment, + `author` varchar(128) default NULL, + `email` varchar(128) default NULL, + `text` text, + `created` int(9) NOT NULL, + `item_id` int(9) NOT NULL, + `url` varchar(255) default NULL, + `published` boolean default 1, + `ip_addr` char(15) default NULL, + `user_agent` varchar(255) default NULL, + `spam_signature` varchar(255) default NULL, + `spam_type` char(15) default NULL, + PRIMARY KEY (`id`)) + ENGINE=InnoDB DEFAULT CHARSET=utf8;"); module::set_version("comment", 1); } -- cgit v1.2.3