# HG changeset patch
# User Dan
# Date 1195928180 18000
# Node ID a1d0846c4504ee917e6c3d350d875212d2d2f910
# Parent  1201c9412cb61f93e63e0101faa63a3e62009a1b
A couple of minor tweaks to the upgrade schema; tests pending

diff -r 1201c9412cb6 -r a1d0846c4504 upgrade.sql
--- a/upgrade.sql	Sat Nov 24 02:11:43 2007 -0500
+++ b/upgrade.sql	Sat Nov 24 13:16:20 2007 -0500
@@ -9,9 +9,9 @@
 ALTER TABLE {{TABLE_PREFIX}}page_groups MODIFY COLUMN pg_target text DEFAULT NULL;
 -- I have no idea how or why, but the f'ing index didn't get created for who-knows-how-many releases.
 -- We'll attempt to create it here, but don't die if it fails
-@ALTER TABLE {{TABLE_PREFIX}}page_text ENGINE = MYISAM COLLATE = utf8_bin;
+@ALTER TABLE {{TABLE_PREFIX}}page_text ENGINE = MYISAM, COLLATE = utf8_bin, CHARSET = utf8;
 @CREATE FULLTEXT INDEX {{TABLE_PREFIX}}page_search_idx ON {{TABLE_PREFIX}}page_text(page_id, namespace, page_text);
-ALTER TABLE {{TABLE_PREFIX}}search_index COLLATE = utf8_bin, MODIFY COLUMN word varchar(64) NOT NULL;
+ALTER TABLE {{TABLE_PREFIX}}search_index CHARSET = utf8, COLLATE = utf8_bin, MODIFY COLUMN word varchar(64) NOT NULL;
 -- The search cache is no longer needed because of the new unified search engine
 @DROP TABLE {{TABLE_PREFIX}}search_cache;
 -- Yes, it appears we need pages with names this long after all