diff options
| -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`)
) ;
--
|