diff options
author | marcus <marcus@36083f99-b078-4883-b0ff-0f9b5a30f544> | 2008-12-05 12:05:59 +0000 |
---|---|---|
committer | marcus <marcus@36083f99-b078-4883-b0ff-0f9b5a30f544> | 2008-12-05 12:05:59 +0000 |
commit | 7a5007f929a241c318325fa29a62e162a2b78bfa (patch) | |
tree | 5c7d8474471cc319c2f9c02a41773f382654cd38 /engine/schema/mysql.sql | |
parent | 2ec34ab24b4ec17fe28521de36bade6a5fb350a1 (diff) | |
download | elgg-7a5007f929a241c318325fa29a62e162a2b78bfa.tar.gz elgg-7a5007f929a241c318325fa29a62e162a2b78bfa.tar.bz2 |
Closes #611: Made name field longer
git-svn-id: https://code.elgg.org/elgg/trunk@2506 36083f99-b078-4883-b0ff-0f9b5a30f544
Diffstat (limited to 'engine/schema/mysql.sql')
-rw-r--r-- | engine/schema/mysql.sql | 6 |
1 files changed, 4 insertions, 2 deletions
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
|