7 ---BEGIN 1.0.2b1--- |
7 ---BEGIN 1.0.2b1--- |
8 -- This is really optional, but could reduce confusion if regex page groups get truncated for no apparent reason. |
8 -- This is really optional, but could reduce confusion if regex page groups get truncated for no apparent reason. |
9 ALTER TABLE {{TABLE_PREFIX}}page_groups MODIFY COLUMN pg_target text DEFAULT NULL; |
9 ALTER TABLE {{TABLE_PREFIX}}page_groups MODIFY COLUMN pg_target text DEFAULT NULL; |
10 -- I have no idea how or why, but the f'ing index didn't get created for who-knows-how-many releases. |
10 -- I have no idea how or why, but the f'ing index didn't get created for who-knows-how-many releases. |
11 -- We'll attempt to create it here, but don't die if it fails |
11 -- We'll attempt to create it here, but don't die if it fails |
12 @ALTER TABLE {{TABLE_PREFIX}}page_text ENGINE = MYISAM COLLATE = utf8_bin; |
12 @ALTER TABLE {{TABLE_PREFIX}}page_text ENGINE = MYISAM, COLLATE = utf8_bin, CHARSET = utf8; |
13 @CREATE FULLTEXT INDEX {{TABLE_PREFIX}}page_search_idx ON {{TABLE_PREFIX}}page_text(page_id, namespace, page_text); |
13 @CREATE FULLTEXT INDEX {{TABLE_PREFIX}}page_search_idx ON {{TABLE_PREFIX}}page_text(page_id, namespace, page_text); |
14 ALTER TABLE {{TABLE_PREFIX}}search_index COLLATE = utf8_bin, MODIFY COLUMN word varchar(64) NOT NULL; |
14 ALTER TABLE {{TABLE_PREFIX}}search_index CHARSET = utf8, COLLATE = utf8_bin, MODIFY COLUMN word varchar(64) NOT NULL; |
15 -- The search cache is no longer needed because of the new unified search engine |
15 -- The search cache is no longer needed because of the new unified search engine |
16 @DROP TABLE {{TABLE_PREFIX}}search_cache; |
16 @DROP TABLE {{TABLE_PREFIX}}search_cache; |
17 -- Yes, it appears we need pages with names this long after all |
17 -- Yes, it appears we need pages with names this long after all |
18 ALTER TABLE {{TABLE_PREFIX}}pages MODIFY COLUMN urlname varchar(255), MODIFY COLUMN name varchar(255); |
18 ALTER TABLE {{TABLE_PREFIX}}pages MODIFY COLUMN urlname varchar(255), MODIFY COLUMN name varchar(255); |
19 ALTER TABLE {{TABLE_PREFIX}}page_text MODIFY COLUMN page_id varchar(255); |
19 ALTER TABLE {{TABLE_PREFIX}}page_text MODIFY COLUMN page_id varchar(255); |