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
Fix SQLite patch-(page|template)links-fix-pk.sql column order
[lhc/web/wiklou.git]
/
maintenance
/
sqlite
/
archives
/
patch-pagelinks-fix-pk.sql
diff --git
a/maintenance/sqlite/archives/patch-pagelinks-fix-pk.sql
b/maintenance/sqlite/archives/patch-pagelinks-fix-pk.sql
index
0e84586
..
40fd51f
100644
(file)
--- a/
maintenance/sqlite/archives/patch-pagelinks-fix-pk.sql
+++ b/
maintenance/sqlite/archives/patch-pagelinks-fix-pk.sql
@@
-13,8
+13,8
@@
CREATE TABLE /*_*/pagelinks_tmp (
PRIMARY KEY (pl_from,pl_namespace,pl_title)
) /*$wgDBTableOptions*/;
PRIMARY KEY (pl_from,pl_namespace,pl_title)
) /*$wgDBTableOptions*/;
-INSERT INTO /*_*/pagelinks_tmp
- SELECT
*
FROM /*_*/pagelinks;
+INSERT INTO /*_*/pagelinks_tmp
(pl_from, pl_from_namespace, pl_namespace, pl_title)
+ SELECT
pl_from, pl_from_namespace, pl_namespace, pl_title
FROM /*_*/pagelinks;
DROP TABLE /*_*/pagelinks;
DROP TABLE /*_*/pagelinks;