diff options
| author | Bharat Mediratta <bharat@menalto.com> | 2008-12-30 01:37:09 +0000 |
|---|---|---|
| committer | Bharat Mediratta <bharat@menalto.com> | 2008-12-30 01:37:09 +0000 |
| commit | f29aad03a630d623a13a31f417947add92aa81f9 (patch) | |
| tree | 99f434090decd353b51cb73fdbc089ca7452c79c /modules/comment/helpers/comment_installer.php | |
| parent | 79e2c4bd47f34215b7a7f436304e88032f26a5bc (diff) | |
Make some columns smaller so that multi-column keys don't exceed 1024
bytes on some systems.
Diffstat (limited to 'modules/comment/helpers/comment_installer.php')
| -rw-r--r-- | modules/comment/helpers/comment_installer.php | 28 |
1 files changed, 14 insertions, 14 deletions
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); } |