author | Dan |
Tue, 05 Jan 2010 09:50:25 -0500 | |
changeset 1200 | 0f94802001ee |
parent 831 | 45e887f23282 |
permissions | -rw-r--r-- |
831 | 1 |
ALTER TABLE {{TABLE_PREFIX}}users ADD COLUMN password_salt varchar(40) NOT NULL DEFAULT ''; |
2 |
ALTER TABLE {{TABLE_PREFIX}}pages ADD COLUMN page_format varchar(16) NOT NULL DEFAULT 'wikitext'; |
|
3 |
ALTER TABLE {{TABLE_PREFIX}}logs ADD COLUMN page_format varchar(16) NOT NULL DEFAULT 'wikitext'; |
|
4 |
||
5 |
-- |
|
6 |
-- Make page_id and namespace column sizes consistent (former bug) |
|
7 |
-- Yes, this is a PITA in PostgreSQL. |
|
8 |
-- |
|
9 |
||
10 |
-- comments |
|
11 |
ALTER TABLE {{TABLE_PREFIX}}comments ADD COLUMN page_id_new varchar(512) NOT NULL DEFAULT ''; |
|
12 |
UPDATE {{TABLE_PREFIX}}comments SET page_id_new = page_id; |
|
13 |
ALTER TABLE {{TABLE_PREFIX}}comments DROP page_id; |
|
14 |
ALTER TABLE {{TABLE_PREFIX}}comments RENAME page_id_new TO page_id; |
|
15 |
||
16 |
ALTER TABLE {{TABLE_PREFIX}}comments ADD COLUMN namespace_new varchar(16) NOT NULL DEFAULT ''; |
|
17 |
UPDATE {{TABLE_PREFIX}}comments SET namespace_new = namespace; |
|
18 |
ALTER TABLE {{TABLE_PREFIX}}comments DROP namespace; |
|
19 |
ALTER TABLE {{TABLE_PREFIX}}comments RENAME namespace_new TO namespace; |
|
20 |
||
21 |
-- logs |
|
22 |
ALTER TABLE {{TABLE_PREFIX}}logs ADD COLUMN page_id_new varchar(512) NOT NULL DEFAULT ''; |
|
23 |
UPDATE {{TABLE_PREFIX}}logs SET page_id_new = page_id; |
|
24 |
ALTER TABLE {{TABLE_PREFIX}}logs DROP page_id; |
|
25 |
ALTER TABLE {{TABLE_PREFIX}}logs RENAME page_id_new TO page_id; |
|
26 |
||
27 |
ALTER TABLE {{TABLE_PREFIX}}logs ADD COLUMN namespace_new varchar(16) NOT NULL DEFAULT ''; |
|
28 |
UPDATE {{TABLE_PREFIX}}logs SET namespace_new = namespace; |
|
29 |
ALTER TABLE {{TABLE_PREFIX}}logs DROP namespace; |
|
30 |
ALTER TABLE {{TABLE_PREFIX}}logs RENAME namespace_new TO namespace; |
|
31 |
||
32 |
-- page_text |
|
33 |
ALTER TABLE {{TABLE_PREFIX}}page_text ADD COLUMN page_id_new varchar(512) NOT NULL DEFAULT ''; |
|
34 |
UPDATE {{TABLE_PREFIX}}page_text SET page_id_new = page_id; |
|
35 |
ALTER TABLE {{TABLE_PREFIX}}page_text DROP page_id; |
|
36 |
ALTER TABLE {{TABLE_PREFIX}}page_text RENAME page_id_new TO page_id; |
|
37 |
||
38 |
-- pages |
|
39 |
ALTER TABLE {{TABLE_PREFIX}}pages ADD COLUMN urlname_new varchar(512) NOT NULL DEFAULT ''; |
|
40 |
UPDATE {{TABLE_PREFIX}}pages SET urlname_new = urlname; |
|
41 |
ALTER TABLE {{TABLE_PREFIX}}pages DROP urlname; |
|
42 |
ALTER TABLE {{TABLE_PREFIX}}pages RENAME urlname_new TO urlname; |
|
801
eb8b23f11744
Two big commits in one day I know, but redid password storage to use HMAC-SHA1. Consolidated much AES processing to three core methods in session that should handle everything automagically. Installation works; upgrades should. Rebranded as 1.1.6.
Dan
parents:
diff
changeset
|
43 |
|
831 | 44 |
-- hits |
45 |
ALTER TABLE {{TABLE_PREFIX}}hits ADD COLUMN page_id_new varchar(512) NOT NULL DEFAULT ''; |
|
46 |
UPDATE {{TABLE_PREFIX}}hits SET page_id_new = page_id; |
|
47 |
ALTER TABLE {{TABLE_PREFIX}}hits DROP page_id; |
|
48 |
ALTER TABLE {{TABLE_PREFIX}}hits RENAME page_id_new TO page_id; |
|
49 |
||
50 |
ALTER TABLE {{TABLE_PREFIX}}hits ADD COLUMN namespace_new varchar(16) NOT NULL DEFAULT ''; |
|
51 |
UPDATE {{TABLE_PREFIX}}hits SET namespace_new = namespace; |
|
52 |
ALTER TABLE {{TABLE_PREFIX}}hits DROP namespace; |
|
53 |
ALTER TABLE {{TABLE_PREFIX}}hits RENAME namespace_new TO namespace; |
|
54 |
||
55 |
-- acl |
|
56 |
ALTER TABLE {{TABLE_PREFIX}}acl ADD COLUMN page_id_new varchar(512) DEFAULT NULL; |
|
57 |
UPDATE {{TABLE_PREFIX}}acl SET page_id_new = page_id; |
|
58 |
ALTER TABLE {{TABLE_PREFIX}}acl DROP page_id; |
|
59 |
ALTER TABLE {{TABLE_PREFIX}}acl RENAME page_id_new TO page_id; |
|
60 |
||
61 |
ALTER TABLE {{TABLE_PREFIX}}acl ADD COLUMN namespace_new varchar(16) DEFAULT NULL; |
|
62 |
UPDATE {{TABLE_PREFIX}}acl SET namespace_new = namespace; |
|
63 |
ALTER TABLE {{TABLE_PREFIX}}acl DROP namespace; |
|
64 |
ALTER TABLE {{TABLE_PREFIX}}acl RENAME namespace_new TO namespace; |
|
65 |
||
66 |
-- page_group_members |
|
67 |
ALTER TABLE {{TABLE_PREFIX}}page_group_members ADD COLUMN page_id_new varchar(512) NOT NULL DEFAULT ''; |
|
68 |
UPDATE {{TABLE_PREFIX}}page_group_members SET page_id_new = page_id; |
|
69 |
ALTER TABLE {{TABLE_PREFIX}}page_group_members DROP page_id; |
|
70 |
ALTER TABLE {{TABLE_PREFIX}}page_group_members RENAME page_id_new TO page_id; |
|
71 |
||
72 |
ALTER TABLE {{TABLE_PREFIX}}page_group_members ADD COLUMN namespace_new varchar(16) NOT NULL DEFAULT ''; |
|
73 |
UPDATE {{TABLE_PREFIX}}page_group_members SET namespace_new = namespace; |
|
74 |
ALTER TABLE {{TABLE_PREFIX}}page_group_members DROP namespace; |
|
75 |
ALTER TABLE {{TABLE_PREFIX}}page_group_members RENAME namespace_new TO namespace; |
|
76 |
||
77 |
-- tags |
|
78 |
ALTER TABLE {{TABLE_PREFIX}}tags ADD COLUMN page_id_new varchar(512) NOT NULL DEFAULT ''; |
|
79 |
UPDATE {{TABLE_PREFIX}}tags SET page_id_new = page_id; |
|
80 |
ALTER TABLE {{TABLE_PREFIX}}tags DROP page_id; |
|
81 |
ALTER TABLE {{TABLE_PREFIX}}tags RENAME page_id_new TO page_id; |
|
82 |
||
83 |
ALTER TABLE {{TABLE_PREFIX}}tags ADD COLUMN namespace_new varchar(16) NOT NULL DEFAULT ''; |
|
84 |
UPDATE {{TABLE_PREFIX}}tags SET namespace_new = namespace; |
|
85 |
ALTER TABLE {{TABLE_PREFIX}}tags DROP namespace; |
|
86 |
ALTER TABLE {{TABLE_PREFIX}}tags RENAME namespace_new TO namespace; |