| Index: trunk/phase3/maintenance/tables.sql |
| — | — | @@ -1103,10 +1103,14 @@ |
| 1104 | 1104 | -- The user who performed this action; key to user_id |
| 1105 | 1105 | log_user int unsigned NOT NULL default 0, |
| 1106 | 1106 | |
| | 1107 | + -- Name of the user who performed this action |
| | 1108 | + log_user_text varchar(255) binary NOT NULL default '', |
| | 1109 | + |
| 1107 | 1110 | -- Key to the page affected. Where a user is the target, |
| 1108 | 1111 | -- this will point to the user page. |
| 1109 | 1112 | log_namespace int NOT NULL default 0, |
| 1110 | 1113 | log_title varchar(255) binary NOT NULL default '', |
| | 1114 | + log_page int unsigned NULL, |
| 1111 | 1115 | |
| 1112 | 1116 | -- Freeform text. Interpreted as edit history comments. |
| 1113 | 1117 | log_comment varchar(255) NOT NULL default '', |
| — | — | @@ -1122,6 +1126,8 @@ |
| 1123 | 1127 | CREATE INDEX /*i*/user_time ON /*_*/logging (log_user, log_timestamp); |
| 1124 | 1128 | CREATE INDEX /*i*/page_time ON /*_*/logging (log_namespace, log_title, log_timestamp); |
| 1125 | 1129 | CREATE INDEX /*i*/times ON /*_*/logging (log_timestamp); |
| | 1130 | +CREATE INDEX /*i*/log_user_type_time ON /*_*/logging (log_user, log_type, log_timestamp); |
| | 1131 | +CREATE INDEX /*i*/log_page_id_time ON /*_*/logging (log_page,log_timestamp); |
| 1126 | 1132 | |
| 1127 | 1133 | |
| 1128 | 1134 | CREATE TABLE /*_*/log_search ( |