diff options
Diffstat (limited to 'maintenance/tables.sql')
-rw-r--r-- | maintenance/tables.sql | 10 |
1 files changed, 6 insertions, 4 deletions
diff --git a/maintenance/tables.sql b/maintenance/tables.sql index bf93a232..aa0c7ea9 100644 --- a/maintenance/tables.sql +++ b/maintenance/tables.sql @@ -3,7 +3,9 @@ -- not have to run it by itself unless doing a manual install. -- This is a shared schema file used for both MySQL and SQLite installs. - +-- +-- For more documentation on the database schema, see +-- https://www.mediawiki.org/wiki/Manual:Database_layout -- -- General notes: -- @@ -490,7 +492,7 @@ CREATE TABLE /*_*/pagelinks ( CREATE UNIQUE INDEX /*i*/pl_from ON /*_*/pagelinks (pl_from,pl_namespace,pl_title); CREATE INDEX /*i*/pl_namespace ON /*_*/pagelinks (pl_namespace,pl_title,pl_from); -CREATE INDEX /*i*/pl_backlinks_namespace ON /*_*/pagelinks (pl_namespace,pl_title,pl_from_namespace,pl_from); +CREATE INDEX /*i*/pl_backlinks_namespace ON /*_*/pagelinks (pl_from_namespace,pl_namespace,pl_title,pl_from); -- @@ -512,7 +514,7 @@ CREATE TABLE /*_*/templatelinks ( CREATE UNIQUE INDEX /*i*/tl_from ON /*_*/templatelinks (tl_from,tl_namespace,tl_title); CREATE INDEX /*i*/tl_namespace ON /*_*/templatelinks (tl_namespace,tl_title,tl_from); -CREATE INDEX /*i*/tl_backlinks_namespace ON /*_*/templatelinks (tl_namespace,tl_title,tl_from_namespace,tl_from); +CREATE INDEX /*i*/tl_backlinks_namespace ON /*_*/templatelinks (tl_from_namespace,tl_namespace,tl_title,tl_from); -- @@ -534,7 +536,7 @@ CREATE TABLE /*_*/imagelinks ( CREATE UNIQUE INDEX /*i*/il_from ON /*_*/imagelinks (il_from,il_to); CREATE INDEX /*i*/il_to ON /*_*/imagelinks (il_to,il_from); -CREATE INDEX /*i*/il_backlinks_namespace ON /*_*/imagelinks (il_to,il_from_namespace,il_from); +CREATE INDEX /*i*/il_backlinks_namespace ON /*_*/imagelinks (il_from_namespace,il_to,il_from); -- |