aboutsummaryrefslogtreecommitdiffstats
path: root/sql/postgres/patch-searchindex-pk-titlelength.sql
diff options
context:
space:
mode:
Diffstat (limited to 'sql/postgres/patch-searchindex-pk-titlelength.sql')
-rw-r--r--sql/postgres/patch-searchindex-pk-titlelength.sql12
1 files changed, 12 insertions, 0 deletions
diff --git a/sql/postgres/patch-searchindex-pk-titlelength.sql b/sql/postgres/patch-searchindex-pk-titlelength.sql
new file mode 100644
index 000000000000..cee04e5b2aa9
--- /dev/null
+++ b/sql/postgres/patch-searchindex-pk-titlelength.sql
@@ -0,0 +1,12 @@
+-- This file is automatically generated using maintenance/generateSchemaChangeSql.php.
+-- Source: maintenance/abstractSchemaChanges/patch-searchindex-innodb-pk-titlelength.json
+-- Do not modify this file directly.
+-- See https://www.mediawiki.org/wiki/Manual:Schema_changes
+DROP INDEX si_page;
+ALTER TABLE searchindex
+ ALTER si_title
+ DROP DEFAULT;
+ALTER TABLE searchindex
+ ALTER si_title TYPE TEXT;
+ALTER TABLE searchindex
+ ADD PRIMARY KEY (si_page);