- $SQLs[] = "DROP TABLE IF EXISTS "._MYSQL_PREFIX."_doubler";
- $SQLs[] = "CREATE TABLE "._MYSQL_PREFIX."_doubler (
-id bigint(20) not null auto_increment,
-userid bigint(20) not null default '0',
-refid bigint(20) not null default '0',
-points double(20,5) 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',
+ ADD_EXT_SQL("DROP TABLE IF EXISTS `{!_MYSQL_PREFIX!}_doubler`");
+ ADD_EXT_SQL("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',