1 files changed, 13 insertions, 0 deletions
diff --git a/sql/postgres/patch-categorylinks-target_id.sql b/sql/postgres/patch-categorylinks-target_id.sql
new file mode 100644
index 000000000000..53cfb4a92290
--- /dev/null
+++ b/sql/postgres/patch-categorylinks-target_id.sql
@@ -0,0 +1,13 @@
+-- This file is automatically generated using maintenance/generateSchemaChangeSql.php.
+-- Source: sql/abstractSchemaChanges/patch-categorylinks-target_id.json
+-- Do not modify this file directly.
+-- See https://www.mediawiki.org/wiki/Manual:Schema_changes
+ALTER TABLE categorylinks
+  ADD cl_collation_id SMALLINT DEFAULT 0 NOT NULL;
+ALTER TABLE categorylinks
+  ADD cl_target_id BIGINT DEFAULT NULL;
+
+CREATE INDEX cl_sortkey_id ON categorylinks (
+  cl_target_id, cl_type, cl_sortkey,
+  cl_from
+);