MyISAM/InnoDB support added

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

diff --git a/inc/extensions/ext-sponsor.php b/inc/extensions/ext-sponsor.php
index 1eb26e78e76f3982dd95c3834625b7d42c24e50c..1157f574d5b0d599eba397a6e4efdf5e60705c0a 100644 (file)
--- a/inc/extensions/ext-sponsor.php
+++ b/inc/extensions/ext-sponsor.php
@@ -91,7 +91,7 @@ last_curr VARCHAR(255) NOT NULL DEFAULT '€',
 KEY(refid),
 KEY(email),
 PRIMARY KEY(id)
 KEY(refid),
 KEY(email),
 PRIMARY KEY(id)

-)TYPE=MyISAM");
+)TYPE={!_TABLE_TYPE!}");

        //
        // Sponsor orders
        //
        //
        // Sponsor orders
        //


@@ -111,7 +111,7 @@ KEY (regid),
 KEY (aid),
 KEY (sponsorid),
 PRIMARY KEY(id)
 KEY (aid),
 KEY (sponsorid),
 PRIMARY KEY(id)

-)TYPE=MyISAM");
+)TYPE={!_TABLE_TYPE!}");

        //
        // Pay-types
        //
        //
        // Pay-types
        //


@@ -123,7 +123,7 @@ 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)
 pay_min_count BIGINT(20) UNSIGNED NOT NULL DEFAULT 1,
 pay_currency VARCHAR(255) NOT NULL DEFAULT '€',
 PRIMARY KEY(id)

-)TYPE=MyISAM");
+)TYPE={!_TABLE_TYPE!}");

        //
        // Points-to-action converting
        //
        //
        // Points-to-action converting
        //


@@ -135,7 +135,7 @@ conv_rate BIGINT(20) UNSIGNED NOT NULL DEFAULT 0,
 conv_name VARCHAR(255) NOT NULL DEFAULT 'Mails',
 KEY (ext_name),
 PRIMARY KEY(id)
 conv_name VARCHAR(255) NOT NULL DEFAULT 'Mails',
 KEY (ext_name),
 PRIMARY KEY(id)

-)TYPE=MyISAM");
+)TYPE={!_TABLE_TYPE!}");

        //
        // Sponsor menu system (default)
        //
        //
        // Sponsor menu system (default)
        //


@@ -150,7 +150,7 @@ sort BIGINT(20) UNSIGNED NOT NULL DEFAULT 0,
 KEY (action),
 UNIQUE KEY (what),
 PRIMARY KEY(id)
 KEY (action),
 UNIQUE KEY (what),
 PRIMARY KEY(id)

-)TYPE=MyISAM");
+)TYPE={!_TABLE_TYPE!}");

        //
        // Registry for performable actions by your sponsors
        //
        //
        // Registry for performable actions by your sponsors
        //


@@ -164,7 +164,7 @@ stamp_added VARCHAR(10) NOT NULL DEFAULT 0,
 KEY(ext_name),
 KEY(aid),
 PRIMARY KEY(id)
 KEY(ext_name),
 KEY(aid),
 PRIMARY KEY(id)

-)TYPE=MyISAM");
+)TYPE={!_TABLE_TYPE!}");

        //
        // URLs from the sponsors
        //
        //
        // URLs from the sponsors
        //


@@ -178,7 +178,7 @@ clicks BIGINT(20) UNSIGNED NOT NULL DEFAULT 0,
 status ENUM('PENDING','ACTIVE','LOCKED') NOT NULL DEFAULT 'PENDING',
 KEY(sponsorid),
 PRIMARY KEY(id)
 status ENUM('PENDING','ACTIVE','LOCKED') NOT NULL DEFAULT 'PENDING',
 KEY(sponsorid),
 PRIMARY KEY(id)

-)TYPE=MyISAM");
+)TYPE={!_TABLE_TYPE!}");

        //
        // Banners of any size from the sponsors
        //
        //
        // Banners of any size from the sponsors
        //


@@ -194,7 +194,7 @@ views BIGINT(20) UNSIGNED NOT NULL DEFAULT 0,
 status ENUM('PENDING','ACTIVE','LOCKED') NOT NULL DEFAULT 'PENDING',
 KEY(sponsorid),
 PRIMARY KEY(id)
 status ENUM('PENDING','ACTIVE','LOCKED') NOT NULL DEFAULT 'PENDING',
 KEY(sponsorid),
 PRIMARY KEY(id)

-)TYPE=MyISAM");
+)TYPE={!_TABLE_TYPE!}");

        //
        // Campaigns
        //
        //
        // Campaigns
        //


@@ -216,7 +216,7 @@ status ENUM('PENDING','ACTIVE','LOCKED') NOT NULL DEFAULT 'PENDING',
 KEY(aid),
 KEY(sponsorid),
 PRIMARY KEY(id)
 KEY(aid),
 KEY(sponsorid),
 PRIMARY KEY(id)

-)TYPE=MyISAM");
+)TYPE={!_TABLE_TYPE!}");

        //
        // Campaigns + URLs + Banner
        //
        //
        // Campaigns + URLs + Banner
        //


@@ -232,7 +232,7 @@ KEY(bannerid),
 KEY(urlid),
 KEY(campaignid),
 PRIMARY KEY(id)
 KEY(urlid),
 KEY(campaignid),
 PRIMARY KEY(id)

-)TYPE=MyISAM");
+)TYPE={!_TABLE_TYPE!}");

        //
        // Allowed data to display (administrative)
        //
        //
        // Allowed data to display (administrative)
        //


@@ -242,7 +242,7 @@ 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)
 data_row VARCHAR(255) NOT NULL DEFAULT '',
 display ENUM('Y','N') NOT NULL DEFAULT 'N',
 PRIMARY KEY(id)

-)TYPE=MyISAM");
+)TYPE={!_TABLE_TYPE!}");

        //
        // Allowed data to display (sponsor-side)
        //
        //
        // Allowed data to display (sponsor-side)
        //


@@ -254,7 +254,7 @@ data_row VARCHAR(255) NOT NULL DEFAULT '',
 display ENUM('Y','N') NOT NULL DEFAULT 'N',
 KEY(sponsorid),
 PRIMARY KEY(id)
 display ENUM('Y','N') NOT NULL DEFAULT 'N',
 KEY(sponsorid),
 PRIMARY KEY(id)

-)TYPE=MyISAM");
+)TYPE={!_TABLE_TYPE!}");

        //
        // Default allowed data to display
        //
        //
        // Default allowed data to display
        //