X-Git-Url: https://git.mxchange.org/?a=blobdiff_plain;f=inc%2Fextensions%2Fext-doubler.php;h=5e2416bf71bd2a4021cb051d88bb4fd2cd196b49;hb=cc5c3e1b452c2c6a1ae0b03cd7d3101543870210;hp=255966532692bcbef9b020203d5920a726b6fd83;hpb=c6838f887ab007b0d82ab9d727ba2d30b4bc5a97;p=mailer.git diff --git a/inc/extensions/ext-doubler.php b/inc/extensions/ext-doubler.php index 2559665326..5e2416bf71 100644 --- a/inc/extensions/ext-doubler.php +++ b/inc/extensions/ext-doubler.php @@ -52,18 +52,18 @@ switch (getExtensionMode()) { // Doubler table addExtensionSql("DROP TABLE IF EXISTS `{?_MYSQL_PREFIX?}_doubler`"); addExtensionSql("CREATE TABLE `{?_MYSQL_PREFIX?}_doubler` ( -id BIGINT(20) UNSIGNED NOT NULL AUTO_INCREMENT, -userid BIGINT(20) UNSIGNED NOT NULL DEFAULT 0, -refid BIGINT(20) UNSIGNED NOT NULL DEFAULT 0, -points FLOAT(20,5) UNSIGNED NOT NULL DEFAULT 0.00000, -remote_ip VARCHAR(15) NOT NULL DEFAULT '0.0.0.0', -timemark VARCHAR(10) NOT NULL DEFAULT '', -completed ENUM('Y','N') NOT NULL DEFAULT 'N', -is_ref ENUM('Y','N') NOT NULL DEFAULT 'N', -KEY (refid), -KEY (userid), -PRIMARY KEY (id) -)TYPE=MYISAM"); +`id` BIGINT(20) UNSIGNED NOT NULL AUTO_INCREMENT, +`userid` BIGINT(20) UNSIGNED NOT NULL DEFAULT 0, +`refid` BIGINT(20) UNSIGNED NOT NULL DEFAULT 0, +`points` FLOAT(20,5) UNSIGNED NOT NULL DEFAULT 0.00000, +`remote_ip` VARCHAR(15) NOT NULL DEFAULT '0.0.0.0', +`timemark` VARCHAR(10) NOT NULL DEFAULT '', +`completed` ENUM('Y','N') NOT NULL DEFAULT 'N', +`is_ref` ENUM('Y','N') NOT NULL DEFAULT 'N', +KEY (`refid`), +KEY (`userid`), +PRIMARY KEY (`id`) +)TYPE={?_TABLE_TYPE?}"); // // --- SETTINGS ---