| Index: branches/iwtransclusion/phase3/maintenance/archives/patch-globaltemplatelinks.sql |
| — | — | @@ -0,0 +1,31 @@ |
| | 2 | +-- Table tracking interwiki transclusions in the spirit of templatelinks. |
| | 3 | +-- This table tracks transclusions of this wiki's templates on another wiki |
| | 4 | +-- The gtl_from_* fields describe the (remote) page the template is transcluded from |
| | 5 | +-- The gtl_to_* fields describe the (local) template being transcluded |
| | 6 | +CREATE TABLE /*_*/globaltemplatelinks ( |
| | 7 | + -- The wiki ID of the remote wiki |
| | 8 | + gtl_from_wiki varchar(64) NOT NULL, |
| | 9 | + |
| | 10 | + -- The page ID of the calling page on the remote wiki |
| | 11 | + gtl_from_page int unsigned NOT NULL, |
| | 12 | + |
| | 13 | + -- The namespace name of the calling page on the remote wiki |
| | 14 | + -- Needed for display purposes, since the foreign namespace ID doesn't necessarily match a local one |
| | 15 | + gtl_from_namespace varchar(255) NOT NULL, |
| | 16 | + |
| | 17 | + -- The title of the calling page on the remote wiki |
| | 18 | + -- Needed for display purposes |
| | 19 | + gtl_from_title varchar(255) binary NOT NULL, |
| | 20 | + |
| | 21 | + -- The wiki ID of the wiki that hosts the transcluded page |
| | 22 | + gtl_to_wiki varchar(64) NOT NULL, |
| | 23 | + |
| | 24 | + -- The namespace of the transcluded page on that wiki |
| | 25 | + gtl_to_namespace int NOT NULL, |
| | 26 | + |
| | 27 | + -- The title of the transcluded page on that wiki |
| | 28 | + gtl_to_title varchar(255) binary NOT NULL |
| | 29 | +) /*$wgDBTableOptions*/; |
| | 30 | + |
| | 31 | +CREATE UNIQUE INDEX /*i*/gtl_to_from ON /*_*/globaltemplatelinks (gtl_to_wiki, gtl_to_namespace, gtl_to_title, gtl_from_wiki, gtl_from_page); |
| | 32 | +CREATE UNIQUE INDEX /*i*/gtl_from_to ON /*_*/globaltemplatelinks (gtl_from_wiki, gtl_from_page, gtl_to_wiki, gtl_to_namespace, gtl_to_title); |
| Property changes on: branches/iwtransclusion/phase3/maintenance/archives/patch-globaltemplatelinks.sql |
| ___________________________________________________________________ |
| Added: svn:eol-style |
| 1 | 33 | + native |