Merged in the word_lcase column (finally)
authorDan
Sun, 11 May 2008 21:05:27 -0400
changeset 553 7c7f08825cad
parent 552 400ad5a212a8
child 554 e87390b1f9b0
Merged in the word_lcase column (finally)
install/schemas/upgrade/1.1.3-1.1.4-mysql.sql
--- a/install/schemas/upgrade/1.1.3-1.1.4-mysql.sql	Sun May 11 16:59:45 2008 -0400
+++ b/install/schemas/upgrade/1.1.3-1.1.4-mysql.sql	Sun May 11 21:05:27 2008 -0400
@@ -8,6 +8,8 @@
   PRIMARY KEY ( plugin_id )
 ) ENGINE `MyISAM` CHARACTER SET `utf8` COLLATE `utf8_bin`;
 
+ALTER TABLE {{TABLE_PREFIX}}search_index ADD COLUMN word_lcase varchar(64) NOT NULL;
+
 -- User title
 ALTER TABLE {{TABLE_PREFIX}}users ADD COLUMN user_title varchar(64) DEFAULT NULL;
 ALTER TABLE {{TABLE_PREFIX}}users MODIFY COLUMN user_rank int(12) unsigned DEFAULT NULL;