mediawiki-extensions-Linter/sql/patch-linter-template-tag-fields.sql
sbailey 56567da56f First phase of T175177 database alter table adds two fields
* Adds template and tag name fields to enable better search
   capability to the Linter extension

Bug: T175177
Change-Id: Iac22d99109bb1253f450a64254f50677e3cdefeb
2022-02-03 14:57:17 -08:00

9 lines
541 B
SQL

-- This file is automatically generated using maintenance/generateSchemaChangeSql.php.
-- Source: abstractSchemaChanges/patch-linter-add-template-tag-fields.json
-- Do not modify this file directly.
-- See https://www.mediawiki.org/wiki/Manual:Schema_changes
ALTER TABLE /*_*/linter
ADD linter_template VARBINARY(255) DEFAULT '' NOT NULL,
ADD linter_tag VARBINARY(32) DEFAULT '' NOT NULL;
CREATE INDEX linter_cat_template ON /*_*/linter (linter_cat, linter_template);
CREATE INDEX linter_cat_tag ON /*_*/linter (linter_cat, linter_tag);