addCreateTableSql() is now more encapsulated

[mailer.git] / inc / extensions / ext-sponsor.php

diff --git a/inc/extensions/ext-sponsor.php b/inc/extensions/ext-sponsor.php
index 642feef5c7a8cd06b7d28e7b082149dcce7518ff..915d96807f0bad52ccc09961a2224ee4d9e63e89 100644 (file)
--- a/inc/extensions/ext-sponsor.php
+++ b/inc/extensions/ext-sponsor.php
@@ -61,7 +61,7 @@ switch (getExtensionMode()) {
                // Sponsor data
                //
                addDropTableSql('sponsor_data');
-               addCreateTableSql('sponsor_data', "(
+               addCreateTableSql('sponsor_data', "
 `id` BIGINT(20) UNSIGNED NOT NULL AUTO_INCREMENT,
 `company` VARCHAR(255) NOT NULL DEFAULT '',
 `position` VARCHAR(255) NOT NULL DEFAULT '',
@@ -94,16 +94,16 @@ switch (getExtensionMode()) {
 `hash` VARCHAR(32) NULL DEFAULT NULL,
 `last_payment` FLOAT(7,2) UNSIGNED NOT NULL DEFAULT 0.00,
 `last_currency` VARCHAR(255) NOT NULL DEFAULT '€',
-INDEX (`refid`),
-INDEX (`email`),
+PRIMARY KEY (`id`),
 UNIQUE KEY (`hash`),
-PRIMARY KEY (`id`)
-) ENGINE = {?_TABLE_TYPE?} CHARACTER SET utf8 COLLATE utf8_general_ci COMMENT = 'Main sponsor data'");
+INDEX (`refid`),
+INDEX (`email`)",
+                       'Main sponsor data');
                //
                // Sponsor orders
                //
                addDropTableSql('sponsor_orders');
-               addCreateTableSql('sponsor_orders', "(
+               addCreateTableSql('sponsor_orders', "
 `id` BIGINT(20) UNSIGNED NOT NULL AUTO_INCREMENT,
 `sponsor_id` BIGINT(20) UNSIGNED NOT NULL DEFAULT 0,
 `admin_id` BIGINT(20) UNSIGNED NOT NULL DEFAULT 0,
@@ -113,85 +113,85 @@ PRIMARY KEY (`id`)
 `pay_status` ENUM('PENDING','PAYED','UNPAYED','DELETED') NOT NULL DEFAULT 'PENDING',
 `pay_ordered` TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP,
 `pay_done` TIMESTAMP NOT NULL DEFAULT '0000-00-00 00:00',
+PRIMARY KEY (`id`),
 INDEX (`payment_id`),
 INDEX (`regid`),
 INDEX (`admin_id`),
-INDEX (`sponsor_id`),
-PRIMARY KEY (`id`)
-) ENGINE = {?_TABLE_TYPE?} CHARACTER SET utf8 COLLATE utf8_general_ci COMMENT = 'Sponsor orders table'");
+INDEX (`sponsor_id`)",
+                       'Sponsor orders table');
                //
                // Pay-types
                //
                addDropTableSql('sponsor_paytypes');
-               addCreateTableSql('sponsor_paytypes', "(
+               addCreateTableSql('sponsor_paytypes', "
 `id` BIGINT(20) UNSIGNED NOT NULL AUTO_INCREMENT,
 `pay_name` VARCHAR(255) NOT NULL DEFAULT '',
 `pay_rate` FLOAT(20,5) UNSIGNED NOT NULL DEFAULT 0.00000,
 `pay_min_count` BIGINT(20) UNSIGNED NOT NULL DEFAULT 1,
 `pay_currency` VARCHAR(255) NOT NULL DEFAULT '€',
-PRIMARY KEY (`id`)
-) ENGINE = {?_TABLE_TYPE?} CHARACTER SET utf8 COLLATE utf8_general_ci COMMENT = 'Sponsor payment types'");
+PRIMARY KEY (`id`)",
+                       'Sponsor payment types');
                //
                // Points-to-action converting
                //
                addDropTableSql('sponsor_action_convert');
-               addCreateTableSql('sponsor_action_convert', "(
+               addCreateTableSql('sponsor_action_convert', "
 `id` BIGINT(20) UNSIGNED NOT NULL AUTO_INCREMENT,
 `ext_name` VARCHAR(255) NOT NULL DEFAULT 'sponsor',
 `conv_rate` BIGINT(20) UNSIGNED NOT NULL DEFAULT 0,
 `conv_name` VARCHAR(255) NOT NULL DEFAULT 'Mails',
-INDEX (`ext_name`),
-PRIMARY KEY (`id`)
-) ENGINE = {?_TABLE_TYPE?} CHARACTER SET utf8 COLLATE utf8_general_ci COMMENT = 'Points to action convertion data'");
+PRIMARY KEY (`id`),
+INDEX (`ext_name`)",
+                       'Points to action convertion data');
                //
                // Sponsor menu system (default)
                //
                addDropTableSql('sponsor_menu');
-               addCreateTableSql('sponsor_menu', "(
+               addCreateTableSql('sponsor_menu', "
 `id` BIGINT(20) UNSIGNED NOT NULL AUTO_INCREMENT,
 `action` VARCHAR(255) NOT NULL DEFAULT '',
 `what`  VARCHAR(255) NULL DEFAULT NULL,
 `title` VARCHAR(255) NOT NULL DEFAULT '',
 `active` ENUM('Y','N') NOT NULL DEFAULT 'N',
 `sort` BIGINT(20) UNSIGNED NOT NULL DEFAULT 0,
-INDEX (`action`),
+PRIMARY KEY (`id`)
 UNIQUE KEY `action_what` (`action`,`what`),
 UNIQUE KEY (`what`),
-PRIMARY KEY (`id`)
-) ENGINE = {?_TABLE_TYPE?} CHARACTER SET utf8 COLLATE utf8_general_ci COMMENT = 'Sponsor menu'");
+INDEX (`action`)",
+                       'Sponsor menu');
                //
                // Registry for performable actions by your sponsors
                //
                addDropTableSql('sponsor_registry');
-               addCreateTableSql('sponsor_registry', "(
+               addCreateTableSql('sponsor_registry', "
 `id` BIGINT(20) UNSIGNED NOT NULL AUTO_INCREMENT,
 `admin_id` BIGINT(20) UNSIGNED NOT NULL DEFAULT 0,
 `ext_name` VARCHAR(255) NOT NULL DEFAULT 'sponsor',
 `is_active` ENUM('Y','N') NOT NULL DEFAULT 'N',
 `stamp_added` TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP,
+PRIMARY KEY (`id`),
 INDEX (`ext_name`),
-INDEX (`admin_id`),
-PRIMARY KEY (`id`)
-) ENGINE = {?_TABLE_TYPE?} CHARACTER SET utf8 COLLATE utf8_general_ci COMMENT = 'Sponsor action registry'");
+INDEX (`admin_id`)",
+                       'Sponsor action registry');
                //
                // URLs from the sponsors
                //
                addDropTableSql('sponsor_urls');
-               addCreateTableSql('sponsor_urls', "(
+               addCreateTableSql('sponsor_urls', "
 `id` BIGINT(20) UNSIGNED NOT NULL AUTO_INCREMENT,
 `sponsor_id` BIGINT(20) UNSIGNED NOT NULL DEFAULT 0,
 `url` VARCHAR(255) NOT NULL DEFAULT 'http://',
 `title` VARCHAR(255) NOT NULL DEFAULT '',
 `clicks` BIGINT(20) UNSIGNED NOT NULL DEFAULT 0,
 `status` ENUM('PENDING','ACTIVE','LOCKED') NOT NULL DEFAULT 'PENDING',
-INDEX (`sponsor_id`),
-PRIMARY KEY (`id`)
-) ENGINE = {?_TABLE_TYPE?} CHARACTER SET utf8 COLLATE utf8_general_ci COMMENT = 'URLs from all sponsors'");
+PRIMARY KEY (`id`),
+INDEX (`sponsor_id`)",
+                       'URLs from all sponsors');
                //
                // Banners of any size from the sponsors
                //
                addDropTableSql('sponsor_banner');
-               addCreateTableSql('sponsor_banner', "(
+               addCreateTableSql('sponsor_banner', "
 `id` BIGINT(20) UNSIGNED NOT NULL AUTO_INCREMENT,
 `sponsor_id` BIGINT(20) UNSIGNED NOT NULL DEFAULT 0,
 `url` VARCHAR(255) NOT NULL DEFAULT 'http://',
@@ -200,14 +200,14 @@ PRIMARY KEY (`id`)
 `height` INT(7) UNSIGNED NOT NULL DEFAULT 60,
 `views` BIGINT(20) UNSIGNED NOT NULL DEFAULT 0,
 `status` ENUM('PENDING','ACTIVE','LOCKED') NOT NULL DEFAULT 'PENDING',
-INDEX (`sponsor_id`),
-PRIMARY KEY (`id`)
-) ENGINE = {?_TABLE_TYPE?} CHARACTER SET utf8 COLLATE utf8_general_ci COMMENT = 'Banners from all sponsors'");
+PRIMARY KEY (`id`),
+INDEX (`sponsor_id`)",
+                       'Banners from all sponsors');
                //
                // Campaigns
                //
                addDropTableSql('sponsor_campaigns');
-               addCreateTableSql('sponsor_campaigns', "(
+               addCreateTableSql('sponsor_campaigns', "
 `id` BIGINT(20) UNSIGNED NOT NULL AUTO_INCREMENT,
 `sponsor_id` BIGINT(20) UNSIGNED NOT NULL DEFAULT 0,
 `admin_id` BIGINT(20) UNSIGNED NOT NULL DEFAULT 0,
@@ -222,48 +222,48 @@ PRIMARY KEY (`id`)
 `locked_reason` TINYTEXT,
 `locked_timestamp` TIMESTAMP NOT NULL DEFAULT '0000-00-00 00:00',
 `status` ENUM('PENDING','ACTIVE','LOCKED') NOT NULL DEFAULT 'PENDING',
+PRIMARY KEY (`id`),
 INDEX (`admin_id`),
-INDEX (`sponsor_id`),
-PRIMARY KEY (`id`)
-) ENGINE = {?_TABLE_TYPE?} CHARACTER SET utf8 COLLATE utf8_general_ci COMMENT = 'Sponsor campaigns'");
+INDEX (`sponsor_id`)",
+                       'Sponsor campaigns');
                //
                // Campaigns + URLs + Banner
                //
                addDropTableSql('sponsor_campaign_assigns');
-               addCreateTableSql('sponsor_campaign_assigns', "(
+               addCreateTableSql('sponsor_campaign_assigns', "
 `id` BIGINT(20) UNSIGNED NOT NULL AUTO_INCREMENT,
 `campaignid` BIGINT(20) UNSIGNED NOT NULL DEFAULT 0,
 `urlid` BIGINT(20) UNSIGNED NOT NULL DEFAULT 0,
 `bannerid` BIGINT(20) UNSIGNED NOT NULL DEFAULT 0,
 `clicks` BIGINT(20) UNSIGNED NOT NULL DEFAULT 0,
 `views` BIGINT(20) UNSIGNED NOT NULL DEFAULT 0,
+PRIMARY KEY (`id`),
 INDEX (`bannerid`),
 INDEX (`urlid`),
-INDEX (`campaignid`),
-PRIMARY KEY (`id`)
-) ENGINE = {?_TABLE_TYPE?} CHARACTER SET utf8 COLLATE utf8_general_ci COMMENT = 'Campaign+Banner+URL connection data'");
+INDEX (`campaignid`)",
+                       'Campaign+Banner+URL connection data');
                //
                // Allowed data to display (administrative)
                //
                addDropTableSql('sponsor_admin_data');
-               addCreateTableSql('sponsor_admin_data', "(
+               addCreateTableSql('sponsor_admin_data', "
 `id` BIGINT(20) UNSIGNED NOT NULL AUTO_INCREMENT,
 `data_row` VARCHAR(255) NOT NULL DEFAULT '',
 `display` ENUM('Y','N') NOT NULL DEFAULT 'N',
-PRIMARY KEY (`id`)
-) ENGINE = {?_TABLE_TYPE?} CHARACTER SET utf8 COLLATE utf8_general_ci COMMENT = 'Allowed data to display to the admin'");
+PRIMARY KEY (`id`)",
+                       'Allowed data to display to the admin');
                //
                // Allowed data to display (sponsor-side)
                //
                addDropTableSql('sponsor_display_data');
-               addCreateTableSql('sponsor_display_data', "(
+               addCreateTableSql('sponsor_display_data', "
 `id` BIGINT(20) UNSIGNED NOT NULL AUTO_INCREMENT,
 `sponsor_id` BIGINT(20) UNSIGNED NOT NULL DEFAULT 0,
 `data_row` VARCHAR(255) NOT NULL DEFAULT '',
 `display` ENUM('Y','N') NOT NULL DEFAULT 'N',
-INDEX (`sponsor_id`),
-PRIMARY KEY (`id`)
-) ENGINE = {?_TABLE_TYPE?} CHARACTER SET utf8 COLLATE utf8_general_ci COMMENT = 'Data sponsors allowed to see'");
+PRIMARY KEY (`id`),
+INDEX (`sponsor_id`)",
+                       'Data sponsors allowed to see');
                //
                // Default allowed data to display
                //