- // - Campaigns <-> Ads
- addDropTableSql('forced_campaigns_ads');
- addCreateTableSql('forced_campaigns_ads', "
-`forced_campaign_ads_id` BIGINT(20) UNSIGNED NOT NULL AUTO_INCREMENT,
-`forced_campaign_id` BIGINT(20) UNSIGNED NULL DEFAULT NULL,
-`forced_ads_id` BIGINT(20) UNSIGNED NULL DEFAULT NULL,
-PRIMARY KEY (`forced_campaign_ads_id`),
-UNIQUE `ads_campaign`(`forced_campaign_id`,`forced_ads_id`)",
- 'Forced Campaigns<->Ads');
-
- // - Campaigns <-> "User" (could be a member, sponsor, admin or "API")
- addDropTableSql('forced_campaigns_user');
- addCreateTableSql('forced_campaigns_user', "
-`forced_id` BIGINT(20) UNSIGNED NOT NULL AUTO_INCREMENT,
-`forced_campaign_id` BIGINT(20) UNSIGNED NULL DEFAULT NULL,
-`forced_user_id` BIGINT(20) UNSIGNED NULL DEFAULT NULL,
-`forced_user_type` ENUM('MEMBER','SPONSOR','ADMIN','API') NOT NULL DEFAULT 'ADMIN',
-PRIMARY KEY (`forced_id`),
-UNIQUE `forced_campaign_user` (`forced_campaign_id`,`forced_user_id`,`forced_user_type`),
-INDEX (`forced_user_id`)",
- 'Forced Campaigns<->User');
-