jenkins-bot has submitted this change and it was merged. Change subject: Add a campaign to users mapping table to associate specific users to each campaign ......................................................................
Add a campaign to users mapping table to associate specific users to each campaign Bug:T89455 Change-Id: I79b8881466b943ce1ff8d27f118fe2db719a5e88 --- A data/db/migrations/20151302-add-campaign-users-table.sql M data/db/schema.mysql 2 files changed, 24 insertions(+), 0 deletions(-) Approvals: BryanDavis: Looks good to me, approved jenkins-bot: Verified diff --git a/data/db/migrations/20151302-add-campaign-users-table.sql b/data/db/migrations/20151302-add-campaign-users-table.sql new file mode 100644 index 0000000..e902b54 --- /dev/null +++ b/data/db/migrations/20151302-add-campaign-users-table.sql @@ -0,0 +1,14 @@ +-- Bug: T89455 +-- Add campaign-users table to specify which users have access to which campaigns + +DROP TABLE IF EXISTS campaign_users; + +CREATE TABLE IF NOT EXISTS campaign_users ( + campaign_id INT(11) NOT NULL + , user_id INT(11) NOT NULL + , added_by INT(11) + , created_at TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP + , PRIMARY KEY (campaign_id, user_id) + , CONSTRAINT FOREIGN KEY (campaign_id) REFERENCES campaigns(id) ON DELETE CASCADE + , CONSTRAINT FOREIGN KEY (user_id) REFERENCES users(id) ON DELETE CASCADE +) ENGINE=InnoDB DEFAULT CHARACTER SET=utf8 ; \ No newline at end of file diff --git a/data/db/schema.mysql b/data/db/schema.mysql index fe799d0..8209d17 100644 --- a/data/db/schema.mysql +++ b/data/db/schema.mysql @@ -76,3 +76,13 @@ , CONSTRAINT FOREIGN KEY (proposal) REFERENCES proposals(id) ON DELETE CASCADE , CONSTRAINT FOREIGN KEY (reviewer) REFERENCES users(id) ON DELETE RESTRICT ) ENGINE=InnoDB DEFAULT CHARACTER SET=utf8 ; + +CREATE TABLE IF NOT EXISTS campaign_users ( + campaign_id INT(11) NOT NULL + , user_id INT(11) NOT NULL + , added_by INT(11) + , created_at TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP + , PRIMARY KEY (campaign_id, user_id) + , CONSTRAINT FOREIGN KEY (campaign_id) REFERENCES campaigns(id) ON DELETE CASCADE + , CONSTRAINT FOREIGN KEY (user_id) REFERENCES users(id) ON DELETE CASCADE +) ENGINE=InnoDB DEFAULT CHARACTER SET=utf8 ; -- To view, visit https://gerrit.wikimedia.org/r/190480 To unsubscribe, visit https://gerrit.wikimedia.org/r/settings Gerrit-MessageType: merged Gerrit-Change-Id: I79b8881466b943ce1ff8d27f118fe2db719a5e88 Gerrit-PatchSet: 2 Gerrit-Project: wikimedia/iegreview Gerrit-Branch: master Gerrit-Owner: Niharika29 <[email protected]> Gerrit-Reviewer: BryanDavis <[email protected]> Gerrit-Reviewer: Niharika29 <[email protected]> Gerrit-Reviewer: Springle <[email protected]> Gerrit-Reviewer: jenkins-bot <> _______________________________________________ MediaWiki-commits mailing list [email protected] https://lists.wikimedia.org/mailman/listinfo/mediawiki-commits
