https://www.mediawiki.org/wiki/Special:Code/MediaWiki/112144
Revision: 112144
Author: reedy
Date: 2012-02-22 20:56:10 +0000 (Wed, 22 Feb 2012)
Log Message:
-----------
Add all index to UploadWizard.sql, then it's easily enableable by using 1 file,
rather than having to use 4 files
Modified Paths:
--------------
trunk/extensions/UploadWizard/UploadWizard.sql
Modified: trunk/extensions/UploadWizard/UploadWizard.sql
===================================================================
--- trunk/extensions/UploadWizard/UploadWizard.sql 2012-02-22 20:37:53 UTC
(rev 112143)
+++ trunk/extensions/UploadWizard/UploadWizard.sql 2012-02-22 20:56:10 UTC
(rev 112144)
@@ -9,9 +9,14 @@
campaign_enabled TINYINT NOT NULL default '0'
) /*$wgDBTableOptions*/;
+CREATE UNIQUE INDEX /*i*/uw_campaigns_name ON /*_*/uw_campaigns
(campaign_name);
+
-- Upload wizard campaign config
CREATE TABLE IF NOT EXISTS /*$wgDBprefix*/uw_campaign_conf (
cc_campaign_id SMALLINT unsigned NOT NULL,
cc_property VARCHAR(255) NULL,
cc_value BLOB NULL
) /*$wgDBTableOptions*/;
+
+CREATE UNIQUE INDEX /*i*/uw_cc_id_property ON /*_*/uw_campaign_conf
(cc_campaign_id,cc_property);
+CREATE INDEX /*i*/uw_cc_property ON /*_*/uw_campaign_conf (cc_property);
\ No newline at end of file
_______________________________________________
MediaWiki-CVS mailing list
[email protected]
https://lists.wikimedia.org/mailman/listinfo/mediawiki-cvs
