enableExtensionProductive(FALSE);
switch (getExtensionMode()) {
- case 'register': // Do stuff when installation is running
+ case 'setup': // Do stuff when installation is running
// Add dependency for ext-earning
addExtensionDependency('earning');
addDropTableSql('forced_ads');
addCreateTableSql('forced_ads', "
`forced_ads_id` BIGINT(20) UNSIGNED NOT NULL AUTO_INCREMENT,
+`forced_ads_provider` ENUM('ADMIN', 'MEMBER', 'API', 'UNKNOWN') NOT NULL DEFAULT 'UNKNOWN',
+`forced_ads_api_type` VARCHAR(255) NULL DEFAULT NULL,
`forced_ads_ad_url` VARCHAR(255) NULL DEFAULT NULL,
`forced_ads_click_url` VARCHAR(255) NOT NULL,
`forced_ads_width` SMALLINT(3) UNSIGNED NULL DEFAULT NULL,
INDEX (`forced_ads_userid`)",
'Forced Ads Data');
+ // - Connection ->ext-network
+ addDropTableSql('forced_network');
+ addCreateTableSql('forced_network', "
+`forced_network_id` BIGINT(20) UNSIGNED NOT NULL AUTO_INCREMENT,
+`forced_ads_id` BIGINT(20) UNSIGNED NOT NULL DEFAULT 0,
+`network_type_id` BIGINT(20) UNSIGNED NOT NULL DEFAULT 0,
+PRIMARY KEY (`forced_network_id`),
+UNIQUE `ads_type` (`forced_ads_id`, `network_type_id`)",
+ 'Forced Campaign Data');
+
// - Campaigns
addDropTableSql('forced_campaigns');
addCreateTableSql('forced_campaigns', "
case 'remove': // Do stuff when removing extension
// SQL commands to run
addDropTableSql('forced_ads');
+ addDropTableSql('forced_network');
addDropTableSql('forced_campaigns');
addDropTableSql('forced_costs');
addDropTableSql('forced_stats');