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 /core/helpers/core_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 'core/helpers/core_installer.php')
| -rw-r--r-- | core/helpers/core_installer.php | 14 |
1 files changed, 7 insertions, 7 deletions
diff --git a/core/helpers/core_installer.php b/core/helpers/core_installer.php index bd2b5186..d1904181 100644 --- a/core/helpers/core_installer.php +++ b/core/helpers/core_installer.php @@ -46,7 +46,7 @@ class core_installer { $db->query("CREATE TABLE `graphics_rules` ( `id` int(9) NOT NULL auto_increment, `priority` int(9) NOT NULL, - `module_name` varchar(255) NOT NULL, + `module_name` varchar(64) NOT NULL, `target` varchar(32) NOT NULL, `operation` varchar(64) NOT NULL, `args` varchar(255) default NULL, @@ -106,7 +106,7 @@ class core_installer { $db->query("CREATE TABLE `modules` ( `id` int(9) NOT NULL auto_increment, - `name` varchar(255) default NULL, + `name` varchar(64) default NULL, `version` int(9) default NULL, PRIMARY KEY (`id`), UNIQUE KEY(`name`)) @@ -114,7 +114,7 @@ class core_installer { $db->query("CREATE TABLE `permissions` ( `id` int(9) NOT NULL auto_increment, - `name` varchar(255) default NULL, + `name` varchar(64) default NULL, `version` int(9) default NULL, PRIMARY KEY (`id`), UNIQUE KEY(`name`)) @@ -128,12 +128,12 @@ class core_installer { ENGINE=InnoDB DEFAULT CHARSET=utf8;"); $db->query("CREATE TABLE `tasks` ( - `callback` varchar(255) default NULL, + `callback` varchar(128) default NULL, `context` text NOT NULL, `done` boolean default 0, `id` int(9) NOT NULL auto_increment, `updated` int(9) default NULL, - `name` varchar(255) default NULL, + `name` varchar(128) default NULL, `percent_complete` int(9) default 0, `state` varchar(32) default NULL, `status` varchar(255) default NULL, @@ -142,8 +142,8 @@ class core_installer { $db->query("CREATE TABLE `vars` ( `id` int(9) NOT NULL auto_increment, - `module_name` varchar(255) NOT NULL, - `name` varchar(255) NOT NULL, + `module_name` varchar(64) NOT NULL, + `name` varchar(64) NOT NULL, `value` text, PRIMARY KEY (`id`), UNIQUE KEY(`module_name`, `name`)) |