- 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");
+ addDropTableSql('doubler');
+ addCreateTableSql('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` BIGINT(10) NOT NULL DEFAULT 0,
+`completed` ENUM('Y','N') NOT NULL DEFAULT 'N',
+`is_ref` ENUM('Y','N') NOT NULL DEFAULT 'N',
+KEY (`refid`),
+KEY (`userid`),
+PRIMARY KEY (`id`)
+) ENGINE = {?_TABLE_TYPE?} CHARACTER SET utf8 COLLATE utf8_general_ci COMMENT = 'User doubler data'");