diff options
Diffstat (limited to 'sql/mysql/patch-pagelinks-target_id.sql')
| -rw-r--r-- | sql/mysql/patch-pagelinks-target_id.sql | 8 |
1 files changed, 8 insertions, 0 deletions
diff --git a/sql/mysql/patch-pagelinks-target_id.sql b/sql/mysql/patch-pagelinks-target_id.sql new file mode 100644 index 000000000000..7039e2777f78 --- /dev/null +++ b/sql/mysql/patch-pagelinks-target_id.sql @@ -0,0 +1,8 @@ +-- This file is automatically generated using maintenance/generateSchemaChangeSql.php. +-- Source: maintenance/abstractSchemaChanges/patch-pagelinks-target_id.json +-- Do not modify this file directly. +-- See https://www.mediawiki.org/wiki/Manual:Schema_changes +ALTER TABLE /*_*/pagelinks +ADD pl_target_id BIGINT UNSIGNED DEFAULT NULL; +CREATE INDEX pl_target_id ON /*_*/pagelinks (pl_target_id, pl_from); +CREATE INDEX pl_backlinks_namespace_target_id ON /*_*/pagelinks ( pl_from_namespace, pl_target_id, pl_from );
\ No newline at end of file |