// All required tables for this extension:
// - Ads
addDropTableSql('forced_ads');
- addExtensionSql("CREATE TABLE `{?_MYSQL_PREFIX?}_forced_ads` (
+ addCreateTableSql('forced_ads', "(
`forced_ads_id` BIGINT( 20 ) UNSIGNED NOT NULL AUTO_INCREMENT ,
`forced_ads_ad_url` VARCHAR( 255 ) NULL DEFAULT NULL ,
`forced_ads_click_url` VARCHAR( 255 ) NOT NULL ,
// - Campaigns
addDropTableSql('forced_campaigns');
- addExtensionSql("CREATE TABLE `{?_MYSQL_PREFIX?}_forced_campaigns` (
+ addCreateTableSql('forced_campaigns', "(
`forced_campaign_id` BIGINT( 20 ) UNSIGNED NOT NULL AUTO_INCREMENT ,
`forced_campaign_created` TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP ,
`forced_campaign_status` ENUM( 'ACTIVE', 'PENDING', 'EXPIRED', 'LOCKED' ) NOT NULL DEFAULT 'PENDING',
// - Campaigns <-> Ads
addDropTableSql('forced_campaigns_ads');
- addExtensionSql("CREATE TABLE `{?_MYSQL_PREFIX?}_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 ,
// - Campaigns <-> User
addDropTableSql('forced_campaigns_user');
- addExtensionSql("CREATE TABLE `{?_MYSQL_PREFIX?}_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 ,
// - Campaign costs
addDropTableSql('forced_costs');
- addExtensionSql("CREATE TABLE `{?_MYSQL_PREFIX?}_forced_costs` (
+ addCreateTableSql('forced_costs', "(
`forced_costs_id` BIGINT( 20 ) UNSIGNED NOT NULL AUTO_INCREMENT ,
`forced_costs_price_click` FLOAT( 20, 5 ) UNSIGNED NULL DEFAULT NULL ,
`forced_costs_payment_click` FLOAT( 20, 5 ) UNSIGNED NULL DEFAULT NULL ,
// - Campaign Statistics
addDropTableSql('forced_stats');
- addExtensionSql("CREATE TABLE `{?_MYSQL_PREFIX?}_forced_stats` (
+ addCreateTableSql('forced_stats', "(
`forced_stats_id` BIGINT( 20 ) UNSIGNED NOT NULL AUTO_INCREMENT ,
`forced_stats_campaign_id` BIGINT( 20 ) UNSIGNED NULL DEFAULT NULL ,
`forced_stats_user_id` BIGINT( 20 ) UNSIGNED NULL DEFAULT NULL ,