sql/postgres/patch-searchindex-pk-titlelength.sql


1
2
3
4
5
6
7
8
9
10
11
12

-- This file is automatically generated using maintenance/generateSchemaChangeSql.php.
-- Source: sql/abstractSchemaChanges/patch-searchindex-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);