Index: trunk/extensions/CentralNotice/patches/patch-template_autolink.sql |
— | — | @@ -6,3 +6,6 @@ |
7 | 7 | -- Store before and after flag values for logging |
8 | 8 | ALTER TABLE /*$wgDBprefix*/cn_template_log ADD `tmplog_begin_autolink` bool NULL DEFAULT NULL AFTER `tmplog_end_fundraising`; |
9 | 9 | ALTER TABLE /*$wgDBprefix*/cn_template_log ADD `tmplog_end_autolink` bool NULL DEFAULT NULL AFTER `tmplog_begin_autolink`; |
| 10 | + |
| 11 | +-- Add an index for banner names since we sometimes use them for selection |
| 12 | +CREATE INDEX /*i*/tmp_name ON /*_*/cn_templates (tmp_name); |