AndyRussG has uploaded a new change for review.
https://gerrit.wikimedia.org/r/122223
Change subject: WIP Update Campaigns database schema
......................................................................
WIP Update Campaigns database schema
Modifies the tables added in cdcf0bd2ae7e9ad7580b93bd979d0ed3a5c56d69.
Since that schema change hasn't been applied anywhere yet, only one
change (this one) should to be applied.
Change-Id: I422e9eb578d1d701a5422f270b3e87686e0a4df3
---
M sql/CampaignsCampaignTable.sql
1 file changed, 6 insertions(+), 9 deletions(-)
git pull ssh://gerrit.wikimedia.org:29418/mediawiki/extensions/Campaigns
refs/changes/23/122223/1
diff --git a/sql/CampaignsCampaignTable.sql b/sql/CampaignsCampaignTable.sql
index f8be31c..7c5270b 100644
--- a/sql/CampaignsCampaignTable.sql
+++ b/sql/CampaignsCampaignTable.sql
@@ -7,20 +7,17 @@
-- Time the campaign was created
campaign_time_created varbinary(14) NOT NULL,
+ -- Time the campaign ended
+ campaign_time_ended varbinary(14),
+
-- A string to identify the campaign in URLs
- campaign_url_id varchar(255) NOT NULL UNIQUE,
+ campaign_url_key varchar(255) NOT NULL UNIQUE,
-- Name of the campaign
campaign_name varchar(255) NOT NULL UNIQUE,
-- ID of a page about the campaign, foreign key on page.page_id
- campaign_wikipage_id int unsigned,
-
- -- Flag to use only event logging to record participations in this
campaign
- -- (i.e., just log via server-side when an account is created with the
- -- campaign's URL ID in the URL)
- -- Note that MySQL has no native boolean type, it's just a synonym for
this
- campaign_only_event_logging tinyint(1) NOT NULL default false
+ campaign_wikipage_title_text varchar(255)
) /*$wgDBTableOptions*/;
@@ -29,7 +26,7 @@
/*_*/campaigns_campaign (campaign_id);
CREATE UNIQUE INDEX /*i*/campaigns_campaign_url_id ON
- /*_*/campaigns_campaign (campaign_url_id);
+ /*_*/campaigns_campaign (campaign_url_key);
CREATE UNIQUE INDEX /*i*/campaigns_campaign_name ON
/*_*/campaigns_campaign (campaign_name);
--
To view, visit https://gerrit.wikimedia.org/r/122223
To unsubscribe, visit https://gerrit.wikimedia.org/r/settings
Gerrit-MessageType: newchange
Gerrit-Change-Id: I422e9eb578d1d701a5422f270b3e87686e0a4df3
Gerrit-PatchSet: 1
Gerrit-Project: mediawiki/extensions/Campaigns
Gerrit-Branch: wip/editorcampaigns
Gerrit-Owner: AndyRussG <andrew.green...@gmail.com>
_______________________________________________
MediaWiki-commits mailing list
MediaWiki-commits@lists.wikimedia.org
https://lists.wikimedia.org/mailman/listinfo/mediawiki-commits
