- ADD_EXT_SQL("DROP TABLE IF EXISTS `{!_MYSQL_PREFIX!}_user_wernis`");
- ADD_EXT_SQL("CREATE TABLE `{!_MYSQL_PREFIX!}_user_wernis` (
-id BIGINT(20) UNSIGNED NOT NULL AUTO_INCREMENT,
-userid BIGINT(20) UNSIGNED NOT NULL DEFAULT 0,
-wernis_account VARCHAR(255) NOT NULL DEFAULT '',
-wernis_amount FLOAT(20,5) UNSIGNED NOT NULL DEFAULT 0.00000,
-wernis_timestamp VARCHAR(10) NOT NULL DEFAULT 0,
-wernis_type ENUM('IN','OUT','FAILED') NOT NULL DEFAULT 'FAILED',
-wernis_api_message TINYTEXT,
-wernis_api_status VARCHAR(255) NULL DEFAULT NULL,
-KEY(userid),
-PRIMARY KEY(id)
-) TYPE={!_TABLE_TYPE!}");
+ addDropTableSql('user_wernis');
+ addCreateTableSql('user_wernis', "
+`id` BIGINT(20) UNSIGNED NOT NULL AUTO_INCREMENT,
+`userid` BIGINT(20) UNSIGNED NOT NULL DEFAULT 0,
+`wernis_account` VARCHAR(255) NOT NULL DEFAULT '',
+`wernis_amount` FLOAT(20,5) UNSIGNED NOT NULL DEFAULT 0.00000,
+`wernis_timestamp` VARCHAR(10) NOT NULL DEFAULT 0,
+`wernis_type` ENUM('WITHDRAW','PAYOUT','FAILED') NOT NULL DEFAULT 'FAILED',
+`wernis_api_message` TINYTEXT NOT NULL,
+`wernis_api_status` VARCHAR(255) NULL DEFAULT NULL,
+PRIMARY KEY (`id`),
+INDEX (`userid`)",
+ 'Transfered Wernis per user');