maintenance/archives/patch-externallinks-el_to_path.sql


1
2
3
4
5
6
7
8
9
10

-- This file is automatically generated using maintenance/generateSchemaChangeSql.php.
-- Source: maintenance/abstractSchemaChanges/patch-externallinks-el_to_path.json
-- Do not modify this file directly.
-- See https://www.mediawiki.org/wiki/Manual:Schema_changes
DROP  INDEX el_from ON  /*_*/externallinks;
ALTER TABLE  /*_*/externallinks
ADD  el_to_domain_index VARBINARY(255) DEFAULT '' NOT NULL,
ADD  el_to_path BLOB DEFAULT NULL;
CREATE INDEX el_to_domain_index_to_path ON  /*_*/externallinks (    el_to_domain_index,    el_to_path(60)  );
CREATE INDEX el_from ON  /*_*/externallinks (el_from);