From 424b1cb9ed7a99e0a9ea8be92a6df76d2736bacb Mon Sep 17 00:00:00 2001 From: marcus Date: Mon, 8 Dec 2008 11:49:56 +0000 Subject: Fixes #615 git-svn-id: https://code.elgg.org/elgg/trunk@2513 36083f99-b078-4883-b0ff-0f9b5a30f544 --- engine/schema/mysql.sql | 2 +- engine/schema/upgrades/2008120501.sql | 2 +- 2 files changed, 2 insertions(+), 2 deletions(-) (limited to 'engine/schema') diff --git a/engine/schema/mysql.sql b/engine/schema/mysql.sql index 391cad46e..9a6efd683 100644 --- a/engine/schema/mysql.sql +++ b/engine/schema/mysql.sql @@ -312,7 +312,7 @@ CREATE TABLE `prefix_private_settings` ( PRIMARY KEY ( `id` ) , UNIQUE KEY ( `entity_guid` , `name` ), KEY `name` (`name`), - KEY `value` (`value`) + KEY `value` (`value` (50)) ) ENGINE = MYISAM DEFAULT CHARSET=utf8; -- System log diff --git a/engine/schema/upgrades/2008120501.sql b/engine/schema/upgrades/2008120501.sql index bd08556ee..dd44b96b0 100644 --- a/engine/schema/upgrades/2008120501.sql +++ b/engine/schema/upgrades/2008120501.sql @@ -6,4 +6,4 @@ ALTER TABLE `prefix_private_settings` DROP KEY `name`; ALTER TABLE `prefix_private_settings` ADD KEY `name` (`name`); ALTER TABLE `prefix_private_settings` DROP KEY `value`; -ALTER TABLE `prefix_private_settings` ADD KEY `value` (`value`); \ No newline at end of file +ALTER TABLE `prefix_private_settings` ADD KEY `value` (`value` (50)); \ No newline at end of file -- cgit v1.2.3