| author | Dan |
| Sat, 11 Jul 2009 20:28:03 -0400 | |
| changeset 1054 | e6b14d33ac55 |
| 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;
|