| changeset 304 | e2cb5f1432c8 |
| parent 279 | 8acd77a6c19d |
| parent 301 | 7e094a04d84e |
| child 326 | ab66d6d1f1f4 |
| 280:dc08c70ca550 | 304:e2cb5f1432c8 |
|---|---|
18 ---BEGIN 1.0.2b1--- |
18 ---BEGIN 1.0.2b1--- |
19 -- This is really optional, but could reduce confusion if regex page groups get truncated for no apparent reason. |
19 -- This is really optional, but could reduce confusion if regex page groups get truncated for no apparent reason. |
20 ALTER TABLE {{TABLE_PREFIX}}page_groups MODIFY COLUMN pg_target text DEFAULT NULL; |
20 ALTER TABLE {{TABLE_PREFIX}}page_groups MODIFY COLUMN pg_target text DEFAULT NULL; |
21 -- I have no idea how or why, but the f'ing index didn't get created for who-knows-how-many releases. |
21 -- I have no idea how or why, but the f'ing index didn't get created for who-knows-how-many releases. |
22 -- We'll attempt to create it here, but don't die if it fails |
22 -- We'll attempt to create it here, but don't die if it fails |
23 @ALTER TABLE {{TABLE_PREFIX}}page_text ENGINE = MYISAM COLLATE = utf8_bin; |
23 @ALTER TABLE {{TABLE_PREFIX}}page_text ENGINE = MYISAM, COLLATE = utf8_bin, CHARSET = utf8; |
24 ALTER TABLE {{TABLE_PREFIX}}search_index CHARSET = utf8, COLLATE = utf8_bin, MODIFY COLUMN word varchar(64) NOT NULL; |
|
25 -- The search cache is no longer needed because of the new unified search engine (it's too f'ing fast to need a cache :-D) |
|
26 @DROP TABLE {{TABLE_PREFIX}}search_cache; |
|
27 -- Yes, it appears we need pages with names this long after all |
|
28 ALTER TABLE {{TABLE_PREFIX}}pages MODIFY COLUMN urlname varchar(255), MODIFY COLUMN name varchar(255); |
|
29 ALTER TABLE {{TABLE_PREFIX}}page_text MODIFY COLUMN page_id varchar(255), MODIFY COLUMN namespace varchar(63), MODIFY COLUMN page_text longtext; |
|
24 @CREATE FULLTEXT INDEX {{TABLE_PREFIX}}page_search_idx ON {{TABLE_PREFIX}}page_text(page_id, namespace, page_text); |
30 @CREATE FULLTEXT INDEX {{TABLE_PREFIX}}page_search_idx ON {{TABLE_PREFIX}}page_text(page_id, namespace, page_text); |
25 ALTER TABLE {{TABLE_PREFIX}}search_index COLLATE = utf8_bin, MODIFY COLUMN word varchar(64) NOT NULL; |
31 UPDATE {{TABLE_PREFIX}}config SET config_value='cbf:len=185;crc=55fb6f14;data=0[1],1[4],0[3],1[1],0[22],1[1],0[16],1[3],0[16],1[1],0[1],1[2],0[6],1[1],0[1],1[1],0[4],1[2],0[3],1[1],0[48],1[2],0[2],1[1],0[4],1[1],0[37]|end' WHERE config_name = 'allowed_mime_types' AND config_value='cbf:len=168;crc=c3dcad3f;data=0[1],1[4],0[3],1[1],0[2],1[1],0[11],1[1],0[7],1[1],0[9],1[1],0[6],1[3],0[10],1[1],0[2],1[2],0[1],1[1],0[1],1[2],0[6],1[3],0[1],1[1],0[2],1[4],0[1],1[2],0[3],1[1],0[4],1[2],0[26],1[5],0[6],1[2],0[2],1[1],0[4],1[1],0[10],1[2],0[1],1[1],0[6]|end'; |
26 -- The search cache is no longer needed because of the new unified search engine |
32 @UPDATE {{TABLE_PREFIX}}users SET theme='oxygen',style='bleu' WHERE user_id = 2; |
27 @DROP TABLE {{TABLE_PREFIX}}search_cache; |
|
28 ---END 1.0.2b1--- |
33 ---END 1.0.2b1--- |
29 ---BEGIN 1.0.1.1--- |
34 ---BEGIN 1.0.1.1--- |
30 ---END 1.0.1.1--- |
35 ---END 1.0.1.1--- |
31 ---BEGIN 1.0.1--- |
36 ---BEGIN 1.0.1--- |
32 ---END 1.0.1--- |
37 ---END 1.0.1--- |