From bc2e7ed06173f959717357bac1d2dfecb9905182 Mon Sep 17 00:00:00 2001
From: marcus <marcus@36083f99-b078-4883-b0ff-0f9b5a30f544>
Date: Mon, 16 Jun 2008 16:58:24 +0000
Subject: 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
---
 engine/schema/mysql.sql | 6 +++---
 1 file changed, 3 insertions(+), 3 deletions(-)

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

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`)
 ) ;
 
 --
-- 
cgit v1.2.3

