summaryrefslogtreecommitdiff
path: root/www/wiki/maintenance/sqlite/archives/patch-module_deps-fix-pk.sql
diff options
context:
space:
mode:
Diffstat (limited to 'www/wiki/maintenance/sqlite/archives/patch-module_deps-fix-pk.sql')
-rw-r--r--www/wiki/maintenance/sqlite/archives/patch-module_deps-fix-pk.sql16
1 files changed, 16 insertions, 0 deletions
diff --git a/www/wiki/maintenance/sqlite/archives/patch-module_deps-fix-pk.sql b/www/wiki/maintenance/sqlite/archives/patch-module_deps-fix-pk.sql
new file mode 100644
index 00000000..73bcbe23
--- /dev/null
+++ b/www/wiki/maintenance/sqlite/archives/patch-module_deps-fix-pk.sql
@@ -0,0 +1,16 @@
+CREATE TABLE /*_*/module_deps_tmp (
+ -- Module name
+ md_module varbinary(255) NOT NULL,
+ -- Module context vary (includes skin and language; called "md_skin" for legacy reasons)
+ md_skin varbinary(32) NOT NULL,
+ -- JSON blob with file dependencies
+ md_deps mediumblob NOT NULL,
+ PRIMARY KEY (md_module,md_skin)
+) /*$wgDBTableOptions*/;
+
+INSERT INTO /*_*/module_deps_tmp
+ SELECT * FROM /*_*/module_deps;
+
+DROP TABLE /*_*/module_deps;
+
+ALTER TABLE /*_*/module_deps_tmp RENAME TO /*_*/module_deps; \ No newline at end of file