Deprecated 'replacer' removed. Now we use EL code instead (there are a lot example...

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

diff --git a/inc/extensions/ext-sponsor.php b/inc/extensions/ext-sponsor.php
index f70114da9cb4e5ab967f3165b69bdaee5b5cc407..9213085cd7cef6b30b6efe16977ef1afb6e5c6ca 100644 (file)
--- a/inc/extensions/ext-sponsor.php
+++ b/inc/extensions/ext-sponsor.php
@@ -98,7 +98,7 @@ INDEX (`refid`),
 INDEX (`email`),
 UNIQUE KEY (`hash`),
 PRIMARY KEY (`id`)
-) TYPE={?_TABLE_TYPE?}");
+) ENGINE = {?_TABLE_TYPE?} CHARACTER SET utf8 COLLATE utf8_general_ci");
                //
                // Sponsor orders
                //
@@ -118,7 +118,7 @@ INDEX (`regid`),
 INDEX (`admin_id`),
 INDEX (`sponsor_id`),
 PRIMARY KEY (`id`)
-) TYPE={?_TABLE_TYPE?}");
+) ENGINE = {?_TABLE_TYPE?} CHARACTER SET utf8 COLLATE utf8_general_ci");
                //
                // Pay-types
                //
@@ -130,7 +130,7 @@ PRIMARY KEY (`id`)
 `pay_min_count` BIGINT(20) UNSIGNED NOT NULL DEFAULT 1,
 `pay_currency` VARCHAR(255) NOT NULL DEFAULT '€',
 PRIMARY KEY (`id`)
-) TYPE={?_TABLE_TYPE?}");
+) ENGINE = {?_TABLE_TYPE?} CHARACTER SET utf8 COLLATE utf8_general_ci");
                //
                // Points-to-action converting
                //
@@ -142,7 +142,7 @@ PRIMARY KEY (`id`)
 `conv_name` VARCHAR(255) NOT NULL DEFAULT 'Mails',
 INDEX (`ext_name`),
 PRIMARY KEY (`id`)
-) TYPE={?_TABLE_TYPE?}");
+) ENGINE = {?_TABLE_TYPE?} CHARACTER SET utf8 COLLATE utf8_general_ci");
                //
                // Sponsor menu system (default)
                //
@@ -158,7 +158,7 @@ INDEX (`action`),
 UNIQUE KEY `action_what` (`action`,`what`),
 UNIQUE KEY (`what`),
 PRIMARY KEY (`id`)
-) TYPE={?_TABLE_TYPE?}");
+) ENGINE = {?_TABLE_TYPE?} CHARACTER SET utf8 COLLATE utf8_general_ci");
                //
                // Registry for performable actions by your sponsors
                //
@@ -172,7 +172,7 @@ PRIMARY KEY (`id`)
 INDEX (`ext_name`),
 INDEX (`admin_id`),
 PRIMARY KEY (`id`)
-) TYPE={?_TABLE_TYPE?}");
+) ENGINE = {?_TABLE_TYPE?} CHARACTER SET utf8 COLLATE utf8_general_ci");
                //
                // URLs from the sponsors
                //
@@ -186,7 +186,7 @@ PRIMARY KEY (`id`)
 `status` ENUM('PENDING','ACTIVE','LOCKED') NOT NULL DEFAULT 'PENDING',
 INDEX (`sponsor_id`),
 PRIMARY KEY (`id`)
-) TYPE={?_TABLE_TYPE?}");
+) ENGINE = {?_TABLE_TYPE?} CHARACTER SET utf8 COLLATE utf8_general_ci");
                //
                // Banners of any size from the sponsors
                //
@@ -202,7 +202,7 @@ PRIMARY KEY (`id`)
 `status` ENUM('PENDING','ACTIVE','LOCKED') NOT NULL DEFAULT 'PENDING',
 INDEX (`sponsor_id`),
 PRIMARY KEY (`id`)
-) TYPE={?_TABLE_TYPE?}");
+) ENGINE = {?_TABLE_TYPE?} CHARACTER SET utf8 COLLATE utf8_general_ci");
                //
                // Campaigns
                //
@@ -225,7 +225,7 @@ PRIMARY KEY (`id`)
 INDEX (`admin_id`),
 INDEX (`sponsor_id`),
 PRIMARY KEY (`id`)
-) TYPE={?_TABLE_TYPE?}");
+) ENGINE = {?_TABLE_TYPE?} CHARACTER SET utf8 COLLATE utf8_general_ci");
                //
                // Campaigns + URLs + Banner
                //
@@ -241,7 +241,7 @@ INDEX (`bannerid`),
 INDEX (`urlid`),
 INDEX (`campaignid`),
 PRIMARY KEY (`id`)
-) TYPE={?_TABLE_TYPE?}");
+) ENGINE = {?_TABLE_TYPE?} CHARACTER SET utf8 COLLATE utf8_general_ci");
                //
                // Allowed data to display (administrative)
                //
@@ -251,7 +251,7 @@ PRIMARY KEY (`id`)
 `data_row` VARCHAR(255) NOT NULL DEFAULT '',
 `display` ENUM('Y','N') NOT NULL DEFAULT 'N',
 PRIMARY KEY (`id`)
-) TYPE={?_TABLE_TYPE?}");
+) ENGINE = {?_TABLE_TYPE?} CHARACTER SET utf8 COLLATE utf8_general_ci");
                //
                // Allowed data to display (sponsor-side)
                //
@@ -263,7 +263,7 @@ PRIMARY KEY (`id`)
 `display` ENUM('Y','N') NOT NULL DEFAULT 'N',
 INDEX (`sponsor_id`),
 PRIMARY KEY (`id`)
-) TYPE={?_TABLE_TYPE?}");
+) ENGINE = {?_TABLE_TYPE?} CHARACTER SET utf8 COLLATE utf8_general_ci");
                //
                // Default allowed data to display
                //