equal
deleted
inserted
replaced
23 ALTER TABLE {{TABLE_PREFIX}}page_group_members MODIFY COLUMN page_id varchar(512) NOT NULL, |
23 ALTER TABLE {{TABLE_PREFIX}}page_group_members MODIFY COLUMN page_id varchar(512) NOT NULL, |
24 MODIFY COLUMN namespace varchar(16) NOT NULL; |
24 MODIFY COLUMN namespace varchar(16) NOT NULL; |
25 |
25 |
26 ALTER TABLE {{TABLE_PREFIX}}tags MODIFY COLUMN page_id varchar(512) NOT NULL, |
26 ALTER TABLE {{TABLE_PREFIX}}tags MODIFY COLUMN page_id varchar(512) NOT NULL, |
27 MODIFY COLUMN namespace varchar(16) NOT NULL; |
27 MODIFY COLUMN namespace varchar(16) NOT NULL; |
|
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 |