author | Dan |
Wed, 13 May 2009 09:39:45 -0400 | |
changeset 967 | a267c5be7963 |
parent 927 | e964577b5fa9 |
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 |
-- Make page_id and namespace column sizes consistent (former bug) |
|
6 |
||
7 |
ALTER TABLE {{TABLE_PREFIX}}comments MODIFY COLUMN page_id varchar(512) NOT NULL, |
|
8 |
MODIFY COLUMN namespace varchar(16) NOT NULL; |
|
9 |
||
10 |
ALTER TABLE {{TABLE_PREFIX}}logs MODIFY COLUMN page_id varchar(512) NOT NULL, |
|
11 |
MODIFY COLUMN namespace varchar(16) NOT NULL; |
|
12 |
||
13 |
ALTER TABLE {{TABLE_PREFIX}}page_text MODIFY COLUMN page_id varchar(512) NOT NULL; |
|
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
|
14 |
|
831 | 15 |
ALTER TABLE {{TABLE_PREFIX}}pages MODIFY COLUMN urlname varchar(512) NOT NULL; |
16 |
||
17 |
ALTER TABLE {{TABLE_PREFIX}}hits MODIFY COLUMN page_id varchar(512) NOT NULL, |
|
18 |
MODIFY COLUMN namespace varchar(16) NOT NULL; |
|
19 |
||
20 |
ALTER TABLE {{TABLE_PREFIX}}acl MODIFY COLUMN page_id varchar(512), |
|
21 |
MODIFY COLUMN namespace varchar(16); |
|
22 |
||
23 |
ALTER TABLE {{TABLE_PREFIX}}page_group_members MODIFY COLUMN page_id varchar(512) NOT NULL, |
|
24 |
MODIFY COLUMN namespace varchar(16) NOT NULL; |
|
25 |
||
26 |
ALTER TABLE {{TABLE_PREFIX}}tags MODIFY COLUMN page_id varchar(512) NOT NULL, |
|
27 |
MODIFY COLUMN namespace varchar(16) NOT NULL; |
|
927 | 28 |
|
29 |
-- Added in 1.1.6: Indices for several tables |
|
30 |
-- The size of 317 is a trial-and-error-produced value based on MySQL's index column size limit |
|
31 |
-- of 1000 bytes. It's low like that because of the UTF-8 character set being used. |
|
32 |
||
33 |
@ALTER TABLE {{TABLE_PREFIX}}logs ADD INDEX {{TABLE_PREFIX}}logs_page_idx (page_id(317), namespace); |
|
34 |
@ALTER TABLE {{TABLE_PREFIX}}logs ADD INDEX {{TABLE_PREFIX}}logs_time_idx (time_id); |
|
35 |
@ALTER TABLE {{TABLE_PREFIX}}logs ADD INDEX {{TABLE_PREFIX}}logs_action_idx (log_type, action); |
|
36 |
@ALTER TABLE {{TABLE_PREFIX}}comments ADD INDEX {{TABLE_PREFIX}}comments_page_idx (page_id(317), namespace); |
|
37 |
@ALTER TABLE {{TABLE_PREFIX}}hits ADD INDEX {{TABLE_PREFIX}}hits_time_idx ( time ); |
|
38 |
@ALTER TABLE {{TABLE_PREFIX}}hits ADD INDEX {{TABLE_PREFIX}}hits_page_idx (page_id(317), namespace); |
|
39 |
@ALTER TABLE {{TABLE_PREFIX}}pages ADD INDEX {{TABLE_PREFIX}}pages_page_idx (urlname(317), namespace); |
|
40 |
@ALTER TABLE {{TABLE_PREFIX}}page_text ADD INDEX {{TABLE_PREFIX}}page_text_page_idx (page_id(317), namespace); |
|
41 |