Niharika29 has uploaded a new change for review. https://gerrit.wikimedia.org/r/190480
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(-) git pull ssh://gerrit.wikimedia.org:29418/wikimedia/iegreview refs/changes/80/190480/1 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 4ef5010..83ac0e1 100644 --- a/data/db/schema.mysql +++ b/data/db/schema.mysql @@ -87,3 +87,13 @@ , end_date TIMESTAMP NOT NULL , PRIMARY KEY (id) ) 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: newchange Gerrit-Change-Id: I79b8881466b943ce1ff8d27f118fe2db719a5e88 Gerrit-PatchSet: 1 Gerrit-Project: wikimedia/iegreview Gerrit-Branch: master Gerrit-Owner: Niharika29 <[email protected]> _______________________________________________ MediaWiki-commits mailing list [email protected] https://lists.wikimedia.org/mailman/listinfo/mediawiki-commits
