Index: trunk/phase3/maintenance/tables.sql |
— | — | @@ -159,7 +159,8 @@ |
160 | 160 | CREATE INDEX /*i*/ug_group ON /*_*/user_groups (ug_group); |
161 | 161 | |
162 | 162 | -- Stores the groups the user has once belonged to. |
| 163 | +-- The user may still belong these groups (check user_groups). |
| 164 | +-- Users are not autopromoted to groups from which they were removed. |
163 | 165 | CREATE TABLE /*_*/user_former_groups ( |
164 | 166 | -- Key to user_id |
165 | 167 | ufg_user int unsigned NOT NULL default 0, |
— | — | @@ -1439,7 +1440,7 @@ |
1440 | 1441 | ) /*$wgDBTableOptions*/; |
1441 | 1442 | CREATE INDEX /*i*/lc_lang_key ON /*_*/l10n_cache (lc_lang, lc_key); |
1442 | 1443 | |
| 1444 | +-- Table for caching JSON message blobs for the resource loader |
1443 | 1445 | CREATE TABLE /*_*/msg_resource ( |
1444 | 1446 | -- Resource name |
1445 | 1447 | mr_resource varbinary(255) NOT NULL, |
— | — | @@ -1460,8 +1461,8 @@ |
1461 | 1462 | ) /*$wgDBTableOptions*/; |
1462 | 1463 | CREATE UNIQUE INDEX /*i*/mrl_message_resource ON /*_*/msg_resource_links (mrl_message, mrl_resource); |
1463 | 1464 | |
| 1465 | +-- Table caching which local files a module depends on that aren't |
| 1466 | +-- registered directly, used for fast retrieval of file dependency. |
1464 | 1467 | -- Currently only used for tracking images that CSS depends on |
1465 | 1468 | CREATE TABLE /*_*/module_deps ( |
1466 | 1469 | -- Module name |