19 lines
586 B
SQL
19 lines
586 B
SQL
-- 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);
|