From 7a5007f929a241c318325fa29a62e162a2b78bfa Mon Sep 17 00:00:00 2001
From: marcus <marcus@36083f99-b078-4883-b0ff-0f9b5a30f544>
Date: Fri, 5 Dec 2008 12:05:59 +0000
Subject: Closes #611: Made name field longer

git-svn-id: https://code.elgg.org/elgg/trunk@2506 36083f99-b078-4883-b0ff-0f9b5a30f544
---
 engine/schema/mysql.sql | 6 ++++--
 1 file changed, 4 insertions(+), 2 deletions(-)

(limited to 'engine/schema/mysql.sql')

diff --git a/engine/schema/mysql.sql b/engine/schema/mysql.sql
index 59f11357b..391cad46e 100644
--- a/engine/schema/mysql.sql
+++ b/engine/schema/mysql.sql
@@ -307,10 +307,12 @@ CREATE TABLE `prefix_datalists` (
 CREATE TABLE `prefix_private_settings` (
 	`id` INT NOT NULL auto_increment,
 	`entity_guid` INT NOT NULL ,
-	`name` VARCHAR( 32 ) NOT NULL ,
+	`name` varchar(128) NOT NULL ,
 	`value` TEXT NOT NULL ,
 	PRIMARY KEY ( `id` ) ,
-	UNIQUE KEY ( `entity_guid` , `name` )
+	UNIQUE KEY ( `entity_guid` , `name` ),
+	KEY `name` (`name`),
+	KEY `value` (`value`)
 ) ENGINE = MYISAM  DEFAULT CHARSET=utf8;
 
 -- System log
-- 
cgit v1.2.3

