X-Git-Url: https://git.mxchange.org/?p=mailer.git;a=blobdiff_plain;f=inc%2Fextensions%2Fext-sponsor.php;h=1157f574d5b0d599eba397a6e4efdf5e60705c0a;hp=1eb26e78e76f3982dd95c3834625b7d42c24e50c;hb=ee71bda9cc7d75f090ae2e1a2d05d4903523e112;hpb=0ee25da287821512e09137a752465f09b6e1a799 diff --git a/inc/extensions/ext-sponsor.php b/inc/extensions/ext-sponsor.php index 1eb26e78e7..1157f574d5 100644 --- 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) -)TYPE=MyISAM"); +)TYPE={!_TABLE_TYPE!}"); // // Sponsor orders // @@ -111,7 +111,7 @@ KEY (regid), KEY (aid), KEY (sponsorid), PRIMARY KEY(id) -)TYPE=MyISAM"); +)TYPE={!_TABLE_TYPE!}"); // // 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) -)TYPE=MyISAM"); +)TYPE={!_TABLE_TYPE!}"); // // 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) -)TYPE=MyISAM"); +)TYPE={!_TABLE_TYPE!}"); // // Sponsor menu system (default) // @@ -150,7 +150,7 @@ sort BIGINT(20) UNSIGNED NOT NULL DEFAULT 0, KEY (action), UNIQUE KEY (what), PRIMARY KEY(id) -)TYPE=MyISAM"); +)TYPE={!_TABLE_TYPE!}"); // // 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) -)TYPE=MyISAM"); +)TYPE={!_TABLE_TYPE!}"); // // 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) -)TYPE=MyISAM"); +)TYPE={!_TABLE_TYPE!}"); // // 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) -)TYPE=MyISAM"); +)TYPE={!_TABLE_TYPE!}"); // // Campaigns // @@ -216,7 +216,7 @@ status ENUM('PENDING','ACTIVE','LOCKED') NOT NULL DEFAULT 'PENDING', KEY(aid), KEY(sponsorid), PRIMARY KEY(id) -)TYPE=MyISAM"); +)TYPE={!_TABLE_TYPE!}"); // // Campaigns + URLs + Banner // @@ -232,7 +232,7 @@ KEY(bannerid), KEY(urlid), KEY(campaignid), PRIMARY KEY(id) -)TYPE=MyISAM"); +)TYPE={!_TABLE_TYPE!}"); // // 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) -)TYPE=MyISAM"); +)TYPE={!_TABLE_TYPE!}"); // // 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) -)TYPE=MyISAM"); +)TYPE={!_TABLE_TYPE!}"); // // Default allowed data to display //