| author | Dan |
| Wed, 26 Aug 2009 13:05:17 -0400 | |
| changeset 1106 | 01315acbc22b |
| 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 |