X-Git-Url: https://git.mxchange.org/?p=mailer.git;a=blobdiff_plain;f=inc%2Fextensions%2Fext-doubler.php;h=5e2416bf71bd2a4021cb051d88bb4fd2cd196b49;hp=255966532692bcbef9b020203d5920a726b6fd83;hb=b8c071f12a601619c4c02b9441b3e0e012db6ced;hpb=0bc147b8bab4706803309eab2d8b05042462efe6 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 ---