X-Git-Url: https://git.mxchange.org/?p=mailer.git;a=blobdiff_plain;f=inc%2Fextensions%2Fext-bank.php;h=3c12856dff52b362310ba85fae9acbf7df1cb8c6;hp=9525d3edbbdd6eda9e104845d8e54da118062d1a;hb=3f7f0051c91c54cb691303b9d49fb9cd1a7a4e8c;hpb=9f9d88d5c69948a0306c3d362b42793ae59c8553

diff --git a/inc/extensions/ext-bank.php b/inc/extensions/ext-bank.php
index 9525d3edbb..3c12856dff 100644
--- a/inc/extensions/ext-bank.php
+++ b/inc/extensions/ext-bank.php
@@ -53,7 +53,7 @@ switch (getExtensionMode()) {
 	case 'register': // Do stuff when installation is running
 		// SQL commands to run
 		addDropTableSql('bank_accounts');
-		addCreateTableSql('bank_accounts', "(
+		addCreateTableSql('bank_accounts', "
 `id` BIGINT(20) UNSIGNED NOT NULL AUTO_INCREMENT,
 `userid` BIGINT(20) UNSIGNED NOT NULL DEFAULT 0,
 `account_created` BIGINT(20) UNSIGNED NOT NULL DEFAULT 0,
@@ -77,10 +77,11 @@ UNIQUE KEY (`pin`),
 INDEX `userid_type` (`userid`, `account_type`),
 INDEX (`account_created`),
 INDEX (`account_locked`),
-INDEX (`last_tan_stamp`)
-) ENGINE = {?_TABLE_TYPE?} CHARACTER SET utf8 COLLATE utf8_general_ci COMMENT = 'User bank accounts data'");
+INDEX (`last_tan_stamp`)",
+			'User bank accounts data');
+
 		addDropTableSql('bank_transfers');
-		addCreateTableSql('bank_transfers', "(
+		addCreateTableSql('bank_transfers', "
 `id` BIGINT(20) UNSIGNED NOT NULL AUTO_INCREMENT,
 `to_account_id` BIGINT(20) UNSIGNED NOT NULL DEFAULT 0,
 `from_account_id` BIGINT(20) UNSIGNED NOT NULL DEFAULT 0,
@@ -90,10 +91,11 @@ INDEX (`last_tan_stamp`)
 `transfer_purpose` TINYTEXT,
 PRIMARY KEY (`id`),
 INDEX (`to_account_id`, `from_account_id`),
-INDEX (`day_bookkeeping`, `day_available`)
-) ENGINE = {?_TABLE_TYPE?} CHARACTER SET utf8 COLLATE utf8_general_ci COMMENT = 'Bank user->user transfers'");
+INDEX (`day_bookkeeping`, `day_available`)",
+			'Bank user->user transfers');
+
 		addDropTableSql('bank_packages');
-		addCreateTableSql('bank_packages', "(
+		addCreateTableSql('bank_packages', "
 `id` BIGINT(20) UNSIGNED NOT NULL AUTO_INCREMENT,
 `title` VARCHAR(255) NOT NULL DEFAULT '',
 `description` TINYTEXT,
@@ -110,22 +112,23 @@ INDEX (`day_bookkeeping`, `day_available`)
 `free_account_income` FLOAT(20,5) UNSIGNED NOT NULL DEFAULT 0.00000,
 `free_account_stuff` TINYTEXT null,
 `tan_lock` TINYINT(3) UNSIGNED NOT NULL DEFAULT 0,
-PRIMARY KEY (`id`)
-) ENGINE = {?_TABLE_TYPE?} CHARACTER SET utf8 COLLATE utf8_general_ci COMMENT = 'Bank account packages'");
+PRIMARY KEY (`id`)",
+			'Bank account packages');
+
 		// Free_account_stuff will be a list of columns of the table _bank_packages
 		// what the member shall get for the specified income. output_system_mode
 		// must be extended with the mode you get for free: output_system_mode:LOGIN
 		// should be fine. More than one entry and not DISABLED ;) are not supported.
 		addDropTableSql('bank_tanlist');
-		addCreateTableSql('bank_tanlist', "(
+		addCreateTableSql('bank_tanlist', "
 `id` BIGINT(20) UNSIGNED NOT NULL AUTO_INCREMENT,
 `idx` TINYINT(3) UNSIGNED NOT NULL DEFAULT 0,
 `account_id` BIGINT(20) UNSIGNED NOT NULL DEFAULT 0,
 `tan` VARCHAR(50) NOT NULL DEFAULT '',
 `used` ENUM('Y','N') NOT NULL DEFAULT 'N',
 PRIMARY KEY (`id`),
-UNIQUE (`account_id`, `tan`)
-) ENGINE = {?_TABLE_TYPE?} CHARACTER SET utf8 COLLATE utf8_general_ci COMMENT = 'Bank TAN lists per user'");
+UNIQUE (`account_id`, `tan`)",
+			'Bank TAN lists per user');
 
 		// Admin menu queries
 		addAdminMenuSql('bank', NULL, 'Bank-Accounts', 'Verwalten Sie hier alle Bank-Accounts Ihrer Mitglieder, sowie Angebotspakete und Überweisungen.', 6);