From f29aad03a630d623a13a31f417947add92aa81f9 Mon Sep 17 00:00:00 2001
From: Bharat Mediratta <bharat@menalto.com>
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/user/helpers/user_installer.php | 46 ++++++++++++++++-----------------
 1 file changed, 23 insertions(+), 23 deletions(-)

(limited to 'modules/user/helpers')

diff --git a/modules/user/helpers/user_installer.php b/modules/user/helpers/user_installer.php
index e19abc11..8a583211 100644
--- a/modules/user/helpers/user_installer.php
+++ b/modules/user/helpers/user_installer.php
@@ -24,33 +24,33 @@ class user_installer {
 
     if ($version == 0) {
       $db->query("CREATE TABLE IF NOT EXISTS `users` (
-          `id` int(9) NOT NULL auto_increment,
-          `name` varchar(32) NOT NULL,
-          `full_name` varchar(255) NOT NULL,
-          `password` varchar(128) NOT NULL,
-          `login_count` int(10) unsigned NOT NULL DEFAULT 0,
-          `last_login` int(10) unsigned NOT NULL DEFAULT 0,
-          `email` varchar(255) default NULL,
-          `admin` BOOLEAN default 0,
-          `guest` BOOLEAN default 0,
-          PRIMARY KEY (`id`),
-          UNIQUE KEY(`name`))
-        ENGINE=InnoDB DEFAULT CHARSET=utf8;");
+                   `id` int(9) NOT NULL auto_increment,
+                   `name` varchar(32) NOT NULL,
+                   `full_name` varchar(255) NOT NULL,
+                   `password` varchar(64) NOT NULL,
+                   `login_count` int(10) unsigned NOT NULL DEFAULT 0,
+                   `last_login` int(10) unsigned NOT NULL DEFAULT 0,
+                   `email` varchar(64) default NULL,
+                   `admin` BOOLEAN default 0,
+                   `guest` BOOLEAN default 0,
+                   PRIMARY KEY (`id`),
+                   UNIQUE KEY(`name`))
+                 ENGINE=InnoDB DEFAULT CHARSET=utf8;");
 
       $db->query("CREATE TABLE IF NOT EXISTS `groups` (
-          `id` int(9) NOT NULL auto_increment,
-          `name` char(255) default NULL,
-          `special` BOOLEAN default 0,
-          PRIMARY KEY (`id`),
-          UNIQUE KEY(`name`))
-        ENGINE=InnoDB DEFAULT CHARSET=utf8;");
+                   `id` int(9) NOT NULL auto_increment,
+                   `name` char(64) default NULL,
+                   `special` BOOLEAN default 0,
+                   PRIMARY KEY (`id`),
+                   UNIQUE KEY(`name`))
+                 ENGINE=InnoDB DEFAULT CHARSET=utf8;");
 
       $db->query("CREATE TABLE IF NOT EXISTS `groups_users` (
-          `group_id` int(9) NOT NULL,
-          `user_id` int(9) NOT NULL,
-          PRIMARY KEY (`group_id`, `user_id`),
-          UNIQUE KEY(`user_id`, `group_id`))
-        ENGINE=InnoDB DEFAULT CHARSET=utf8;");
+                   `group_id` int(9) NOT NULL,
+                   `user_id` int(9) NOT NULL,
+                   PRIMARY KEY (`group_id`, `user_id`),
+                   UNIQUE KEY(`user_id`, `group_id`))
+                 ENGINE=InnoDB DEFAULT CHARSET=utf8;");
 
       $everybody = group::create("Everybody");
       $everybody->special = true;
-- 
cgit v1.2.3