dépôts
/
lhc
/
web
/
wiklou.git
/ blobdiff
commit
grep
author
committer
pickaxe
?
search:
re
summary
|
shortlog
|
log
|
commit
|
commitdiff
|
tree
raw
|
inline
| side by side
Fixup some SELECT * usages in sqlite schema patches
[lhc/web/wiklou.git]
/
maintenance
/
sqlite
/
archives
/
patch-langlinks-fix-pk.sql
diff --git
a/maintenance/sqlite/archives/patch-langlinks-fix-pk.sql
b/maintenance/sqlite/archives/patch-langlinks-fix-pk.sql
index
da096ac
..
ee164cc
100644
(file)
--- a/
maintenance/sqlite/archives/patch-langlinks-fix-pk.sql
+++ b/
maintenance/sqlite/archives/patch-langlinks-fix-pk.sql
@@
-10,12
+10,12
@@
CREATE TABLE /*_*/langlinks_tmp (
PRIMARY KEY (ll_from,ll_lang)
) /*$wgDBTableOptions*/;
PRIMARY KEY (ll_from,ll_lang)
) /*$wgDBTableOptions*/;
-INSERT INTO /*_*/langlinks_tmp
- SELECT
*
FROM /*_*/langlinks;
+INSERT INTO /*_*/langlinks_tmp
(ll_from, ll_lang, ll_title)
+ SELECT
ll_from, ll_lang, ll_title
FROM /*_*/langlinks;
DROP TABLE /*_*/langlinks;
ALTER TABLE /*_*/langlinks_tmp RENAME TO /*_*/langlinks;
-- Index for ApiQueryLangbacklinks
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
+CREATE INDEX /*i*/ll_lang ON /*_*/langlinks (ll_lang, ll_title);