- // - 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
- 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') NULL DEFAULT NULL,
-PRIMARY KEY ( `forced_id` ),
-UNIQUE `forced_campaign_user` ( `forced_campaign_id`, `forced_user_id`, `forced_user_type` ),
-INDEX ( `forced_user_id` )",
- 'Forced Campaigns<->User');
-