342 -- Added in 1.1.6: Indices for several tables |
342 -- Added in 1.1.6: Indices for several tables |
343 -- The size of 317 is a trial-and-error-produced value based on MySQL's index column size limit |
343 -- The size of 317 is a trial-and-error-produced value based on MySQL's index column size limit |
344 -- of 1000 bytes. It's low like that because of the UTF-8 character set being used. |
344 -- of 1000 bytes. It's low like that because of the UTF-8 character set being used. |
345 ALTER TABLE {{TABLE_PREFIX}}logs ADD INDEX {{TABLE_PREFIX}}logs_page_idx (page_id(317), namespace); |
345 ALTER TABLE {{TABLE_PREFIX}}logs ADD INDEX {{TABLE_PREFIX}}logs_page_idx (page_id(317), namespace); |
346 ALTER TABLE {{TABLE_PREFIX}}logs ADD INDEX {{TABLE_PREFIX}}logs_time_idx (time_id); |
346 ALTER TABLE {{TABLE_PREFIX}}logs ADD INDEX {{TABLE_PREFIX}}logs_time_idx (time_id); |
|
347 ALTER TABLE {{TABLE_PREFIX}}logs ADD INDEX {{TABLE_PREFIX}}logs_action_idx (log_type, action); |
347 ALTER TABLE {{TABLE_PREFIX}}comments ADD INDEX {{TABLE_PREFIX}}comments_page_idx (page_id(317), namespace); |
348 ALTER TABLE {{TABLE_PREFIX}}comments ADD INDEX {{TABLE_PREFIX}}comments_page_idx (page_id(317), namespace); |
|
349 ALTER TABLE {{TABLE_PREFIX}}hits ADD INDEX {{TABLE_PREFIX}}hits_time_idx ( time ); |
|
350 ALTER TABLE {{TABLE_PREFIX}}hits ADD INDEX {{TABLE_PREFIX}}hits_page_idx (page_id(317), namespace); |
|
351 ALTER TABLE {{TABLE_PREFIX}}pages ADD INDEX {{TABLE_PREFIX}}pages_page_idx (urlname(317), namespace); |
|
352 ALTER TABLE {{TABLE_PREFIX}}page_text ADD INDEX {{TABLE_PREFIX}}page_text_page_idx (page_id(317), namespace); |
348 |
353 |
349 -- The default config. Kind of important. |
354 -- The default config. Kind of important. |
350 -- P.S. the allowed_mime_types value is a compressed bitfield. Source for the (rather simple) algo is in functions.php. |
355 -- P.S. the allowed_mime_types value is a compressed bitfield. Source for the (rather simple) algo is in functions.php. |
351 |
356 |
352 INSERT INTO {{TABLE_PREFIX}}config(config_name, config_value) VALUES |
357 INSERT INTO {{TABLE_PREFIX}}config(config_name, config_value) VALUES |