author | Dan |
Sat, 07 Jun 2008 12:43:19 -0400 | |
changeset 560 | 8981dcf7d485 |
parent 494 | 6c78cc456091 |
permissions | -rw-r--r-- |
494
6c78cc456091
Added support for upgrading arbitrary previous 1.0.x versions (very experimental)
Dan
parents:
diff
changeset
|
1 |
-- Enano CMS |
6c78cc456091
Added support for upgrading arbitrary previous 1.0.x versions (very experimental)
Dan
parents:
diff
changeset
|
2 |
-- Upgrade schema - Enano 1.0.2 beta 1 - 1.0.2 release |
6c78cc456091
Added support for upgrading arbitrary previous 1.0.x versions (very experimental)
Dan
parents:
diff
changeset
|
3 |
|
6c78cc456091
Added support for upgrading arbitrary previous 1.0.x versions (very experimental)
Dan
parents:
diff
changeset
|
4 |
-- This is really optional, but could reduce confusion if regex page groups get truncated for no apparent reason. |
6c78cc456091
Added support for upgrading arbitrary previous 1.0.x versions (very experimental)
Dan
parents:
diff
changeset
|
5 |
ALTER TABLE {{TABLE_PREFIX}}page_groups MODIFY COLUMN pg_target text DEFAULT NULL; |
6c78cc456091
Added support for upgrading arbitrary previous 1.0.x versions (very experimental)
Dan
parents:
diff
changeset
|
6 |
|
6c78cc456091
Added support for upgrading arbitrary previous 1.0.x versions (very experimental)
Dan
parents:
diff
changeset
|
7 |
-- I have no idea how or why, but the f'ing index didn't get created for who-knows-how-many releases. |
6c78cc456091
Added support for upgrading arbitrary previous 1.0.x versions (very experimental)
Dan
parents:
diff
changeset
|
8 |
-- We'll attempt to create it here, but don't die if it fails |
6c78cc456091
Added support for upgrading arbitrary previous 1.0.x versions (very experimental)
Dan
parents:
diff
changeset
|
9 |
@ALTER TABLE {{TABLE_PREFIX}}page_text ENGINE = MYISAM, COLLATE = utf8_bin, CHARSET = utf8; |
6c78cc456091
Added support for upgrading arbitrary previous 1.0.x versions (very experimental)
Dan
parents:
diff
changeset
|
10 |
ALTER TABLE {{TABLE_PREFIX}}search_index CHARSET = utf8, COLLATE = utf8_bin, MODIFY COLUMN word varchar(64) NOT NULL; |
6c78cc456091
Added support for upgrading arbitrary previous 1.0.x versions (very experimental)
Dan
parents:
diff
changeset
|
11 |
|
6c78cc456091
Added support for upgrading arbitrary previous 1.0.x versions (very experimental)
Dan
parents:
diff
changeset
|
12 |
-- 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) |
6c78cc456091
Added support for upgrading arbitrary previous 1.0.x versions (very experimental)
Dan
parents:
diff
changeset
|
13 |
@DROP TABLE {{TABLE_PREFIX}}search_cache; |
6c78cc456091
Added support for upgrading arbitrary previous 1.0.x versions (very experimental)
Dan
parents:
diff
changeset
|
14 |
|
6c78cc456091
Added support for upgrading arbitrary previous 1.0.x versions (very experimental)
Dan
parents:
diff
changeset
|
15 |
-- Yes, it appears we need pages with names this long after all |
6c78cc456091
Added support for upgrading arbitrary previous 1.0.x versions (very experimental)
Dan
parents:
diff
changeset
|
16 |
ALTER TABLE {{TABLE_PREFIX}}pages MODIFY COLUMN urlname varchar(255), MODIFY COLUMN name varchar(255); |
6c78cc456091
Added support for upgrading arbitrary previous 1.0.x versions (very experimental)
Dan
parents:
diff
changeset
|
17 |
|
6c78cc456091
Added support for upgrading arbitrary previous 1.0.x versions (very experimental)
Dan
parents:
diff
changeset
|
18 |
-- Make page_text a little more efficient to deal with |
6c78cc456091
Added support for upgrading arbitrary previous 1.0.x versions (very experimental)
Dan
parents:
diff
changeset
|
19 |
ALTER TABLE {{TABLE_PREFIX}}page_text MODIFY COLUMN page_id varchar(255), MODIFY COLUMN namespace varchar(63), MODIFY COLUMN page_text longtext; |
6c78cc456091
Added support for upgrading arbitrary previous 1.0.x versions (very experimental)
Dan
parents:
diff
changeset
|
20 |
|
6c78cc456091
Added support for upgrading arbitrary previous 1.0.x versions (very experimental)
Dan
parents:
diff
changeset
|
21 |
-- Now recreate the fulltext index |
6c78cc456091
Added support for upgrading arbitrary previous 1.0.x versions (very experimental)
Dan
parents:
diff
changeset
|
22 |
@CREATE FULLTEXT INDEX {{TABLE_PREFIX}}page_search_idx ON {{TABLE_PREFIX}}page_text(page_id, namespace, page_text); |
6c78cc456091
Added support for upgrading arbitrary previous 1.0.x versions (very experimental)
Dan
parents:
diff
changeset
|
23 |
|
6c78cc456091
Added support for upgrading arbitrary previous 1.0.x versions (very experimental)
Dan
parents:
diff
changeset
|
24 |
-- Addition of new file types |
6c78cc456091
Added support for upgrading arbitrary previous 1.0.x versions (very experimental)
Dan
parents:
diff
changeset
|
25 |
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'; |
6c78cc456091
Added support for upgrading arbitrary previous 1.0.x versions (very experimental)
Dan
parents:
diff
changeset
|
26 |
|
6c78cc456091
Added support for upgrading arbitrary previous 1.0.x versions (very experimental)
Dan
parents:
diff
changeset
|
27 |
-- Reinforcement of "stable release" mentality |
6c78cc456091
Added support for upgrading arbitrary previous 1.0.x versions (very experimental)
Dan
parents:
diff
changeset
|
28 |
@UPDATE {{TABLE_PREFIX}}users SET theme='oxygen', style='bleu' WHERE user_id = 2; |
6c78cc456091
Added support for upgrading arbitrary previous 1.0.x versions (very experimental)
Dan
parents:
diff
changeset
|
29 |