1 define mw_prefix='{$wgDBprefix}';
3 CREATE TABLE &mw_prefix.globaltemplatelinks (
4 gtl_from_wiki VARCHAR2(64) NOT NULL,
5 gtl_from_page NUMBER NOT NULL,
6 gtl_from_namespace NUMBER NOT NULL,
7 gtl_from_title VARCHAR2(255) NOT NULL,
8 gtl_to_prefix VARCHAR2(32) NOT NULL,
9 gtl_to_namespace NUMBER NOT NULL,
10 gtl_to_namespacetext VARCHAR2(255) NOT NULL,
11 gtl_to_title VARCHAR2(255) NOT NULL
13 CREATE UNIQUE INDEX &mw_prefix.globaltemplatelinks_u01 ON &mw_prefix.globaltemplatelinks (gtl_to_prefix, gtl_to_namespace, gtl_to_title, gtl_from_wiki, gtl_from_page);
14 CREATE UNIQUE INDEX &mw_prefix.globaltemplatelinks_u02 ON &mw_prefix.globaltemplatelinks (gtl_from_wiki, gtl_from_page, gtl_to_prefix, gtl_to_namespace, gtl_to_title);