X-Git-Url: https://git.heureux-cyclage.org/?a=blobdiff_plain;f=maintenance%2Farchives%2Fpatch-pagelinks.sql;h=cea89b52fba09322eb885e9149ba232bb618c605;hb=13df3d2290ba2836ad14e7de664a2671952c5ddb;hp=7240cff9678d73cf792d00d150135f789410f3b2;hpb=16e1e51d276b8a557fc063c600006494665357ee;p=lhc%2Fweb%2Fwiklou.git diff --git a/maintenance/archives/patch-pagelinks.sql b/maintenance/archives/patch-pagelinks.sql index 7240cff967..cea89b52fb 100644 --- a/maintenance/archives/patch-pagelinks.sql +++ b/maintenance/archives/patch-pagelinks.sql @@ -1,7 +1,7 @@ -- -- Create the new pagelinks table to merge links and brokenlinks data, -- and populate it. --- +-- -- Unlike the old links and brokenlinks, these records will not need to be -- altered when target pages are created, deleted, or renamed. This should -- reduce the amount of severe database frustration that happens when widely- @@ -18,19 +18,19 @@ -- CREATE TABLE /*$wgDBprefix*/pagelinks ( -- Key to the page_id of the page containing the link. - pl_from int(8) unsigned NOT NULL default '0', - + pl_from int unsigned NOT NULL default '0', + -- Key to page_namespace/page_title of the target page. -- The target page may or may not exist, and due to renames -- and deletions may refer to different page records as time -- goes by. pl_namespace int NOT NULL default '0', pl_title varchar(255) binary NOT NULL default '', - + UNIQUE KEY pl_from(pl_from,pl_namespace,pl_title), KEY (pl_namespace,pl_title) -) TYPE=InnoDB; +) /*$wgDBTableOptions*/; -- Import existing-page links