1 files changed, 18 insertions, 0 deletions
diff --git a/sql/postgres/patch-pagelinks-drop-pl_title.sql b/sql/postgres/patch-pagelinks-drop-pl_title.sql
new file mode 100644
index 000000000000..61330c70bbef
--- /dev/null
+++ b/sql/postgres/patch-pagelinks-drop-pl_title.sql
@@ -0,0 +1,18 @@
+-- This file is automatically generated using maintenance/generateSchemaChangeSql.php.
+-- Source: maintenance/abstractSchemaChanges/patch-pagelinks-drop-pl_title.json
+-- Do not modify this file directly.
+-- See https://www.mediawiki.org/wiki/Manual:Schema_changes
+DROP INDEX pl_namespace;
+DROP INDEX pl_backlinks_namespace;
+ALTER TABLE pagelinks
+  DROP CONSTRAINT pagelinks_pkey;
+ALTER TABLE pagelinks
+  DROP pl_namespace;
+ALTER TABLE pagelinks
+  DROP pl_title;
+ALTER TABLE pagelinks
+  ALTER pl_target_id
+SET
+  NOT NULL;
+ALTER TABLE pagelinks
+  ADD PRIMARY KEY (pl_from, pl_target_id);