From 7a5007f929a241c318325fa29a62e162a2b78bfa Mon Sep 17 00:00:00 2001 From: marcus 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