summaryrefslogtreecommitdiff
path: root/www/wiki/maintenance/oracle/archives/patch-externallinks-el_index_60.sql
blob: 39680ef3b4fdc9c54fe05495375286756305f3a6 (plain)
1
2
3
4
5
define mw_prefix='{$wgDBprefix}';

ALTER TABLE &mw_prefix.externallinks ADD el_index_60 VARCHAR2(60);
CREATE INDEX &mw_prefix.externallinks_i04 ON &mw_prefix.externallinks (el_index_60, el_id);
CREATE INDEX &mw_prefix.externallinks_i05 ON &mw_prefix.externallinks (el_from, el_index_60, el_id);