diff options
| author | marcus <marcus@36083f99-b078-4883-b0ff-0f9b5a30f544> | 2008-06-16 16:58:24 +0000 |
|---|---|---|
| committer | marcus <marcus@36083f99-b078-4883-b0ff-0f9b5a30f544> | 2008-06-16 16:58:24 +0000 |
| commit | bc2e7ed06173f959717357bac1d2dfecb9905182 (patch) | |
| tree | 6c37bd7b4ee85f973627a26e7ed3bf943c9ce76f /engine/schema | |
| parent | 4f108879b15e2b25583f56e3fa4a0db2922f0c60 (diff) | |
| download | elgg-bc2e7ed06173f959717357bac1d2dfecb9905182.tar.gz elgg-bc2e7ed06173f959717357bac1d2dfecb9905182.tar.bz2 | |
CLOSED - #26: Lengthing metadata fields
http://trac.elgg.org/elgg/ticket/26
git-svn-id: https://code.elgg.org/elgg/trunk@934 36083f99-b078-4883-b0ff-0f9b5a30f544
Diffstat (limited to 'engine/schema')
| -rw-r--r-- | engine/schema/mysql.sql | 6 |
1 files changed, 3 insertions, 3 deletions
diff --git a/engine/schema/mysql.sql b/engine/schema/mysql.sql index beec6ddfe..c981b0a56 100644 --- a/engine/schema/mysql.sql +++ b/engine/schema/mysql.sql @@ -189,10 +189,10 @@ CREATE TABLE `prefix_metadata` ( -- Meta strings table (avoids storing text strings more than once)
CREATE TABLE `prefix_metastrings` (
`id` int(11) NOT NULL auto_increment,
- `string` varchar(255) NOT NULL,
+ `string` TEXT NOT NULL,
- PRIMARY KEY (`id`),
- UNIQUE KEY (`string`)
+ PRIMARY KEY (`id`), + FULLTEXT KEY `string` (`string`)
) ;
--
|