diff options
Diffstat (limited to 'www/wiki/maintenance/sqlite/archives/patch-langlinks-fix-pk.sql')
-rw-r--r-- | www/wiki/maintenance/sqlite/archives/patch-langlinks-fix-pk.sql | 21 |
1 files changed, 21 insertions, 0 deletions
diff --git a/www/wiki/maintenance/sqlite/archives/patch-langlinks-fix-pk.sql b/www/wiki/maintenance/sqlite/archives/patch-langlinks-fix-pk.sql new file mode 100644 index 00000000..da096ace --- /dev/null +++ b/www/wiki/maintenance/sqlite/archives/patch-langlinks-fix-pk.sql @@ -0,0 +1,21 @@ +CREATE TABLE /*_*/langlinks_tmp ( + -- page_id of the referring page + ll_from int unsigned NOT NULL default 0, + + -- Language code of the target + ll_lang varbinary(20) NOT NULL default '', + + -- Title of the target, including namespace + ll_title varchar(255) binary NOT NULL default '', + PRIMARY KEY (ll_from,ll_lang) +) /*$wgDBTableOptions*/; + +INSERT INTO /*_*/langlinks_tmp + SELECT * FROM /*_*/langlinks; + +DROP TABLE /*_*/langlinks; + +ALTER TABLE /*_*/langlinks_tmp RENAME TO /*_*/langlinks; + +-- Index for ApiQueryLangbacklinks +CREATE INDEX /*i*/ll_lang ON /*_*/langlinks (ll_lang, ll_title);
\ No newline at end of file |