| Index: trunk/extensions/UploadWizard/UploadWizard.sql |
| — | — | @@ -9,9 +9,14 @@ |
| 10 | 10 | campaign_enabled TINYINT NOT NULL default '0' |
| 11 | 11 | ) /*$wgDBTableOptions*/; |
| 12 | 12 | |
| | 13 | +CREATE UNIQUE INDEX /*i*/uw_campaigns_name ON /*_*/uw_campaigns (campaign_name); |
| | 14 | + |
| 13 | 15 | -- Upload wizard campaign config |
| 14 | 16 | CREATE TABLE IF NOT EXISTS /*$wgDBprefix*/uw_campaign_conf ( |
| 15 | 17 | cc_campaign_id SMALLINT unsigned NOT NULL, |
| 16 | 18 | cc_property VARCHAR(255) NULL, |
| 17 | 19 | cc_value BLOB NULL |
| 18 | 20 | ) /*$wgDBTableOptions*/; |
| | 21 | + |
| | 22 | +CREATE UNIQUE INDEX /*i*/uw_cc_id_property ON /*_*/uw_campaign_conf (cc_campaign_id,cc_property); |
| | 23 | +CREATE INDEX /*i*/uw_cc_property ON /*_*/uw_campaign_conf (cc_property); |
| \ No newline at end of file |