X-Git-Url: https://git.mxchange.org/?p=mailer.git;a=blobdiff_plain;f=inc%2Fextensions%2Fext-bank.php;h=b3ac7785524d16e32c3c0fd3fedb5d010bf2be55;hp=be1fe1884a7e13f450ab6e0a4346b07d30d41129;hb=be39a7fb887473487fd2c5f8d550aa03b720cb73;hpb=6f8a68c6c5ed9eeae1bf790f5d758c800b5d5d5d diff --git a/inc/extensions/ext-bank.php b/inc/extensions/ext-bank.php index be1fe1884a..b3ac778552 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 (modules.php?module=admin is called) // SQL commands to run addDropTableSql('bank_accounts'); - addExtensionSql("CREATE TABLE `{?_MYSQL_PREFIX?}_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, @@ -80,7 +80,7 @@ INDEX (`account_locked`), INDEX (`last_tan_stamp`) ) ENGINE = {?_TABLE_TYPE?} CHARACTER SET utf8 COLLATE utf8_general_ci COMMENT = 'User bank accounts data'"); addDropTableSql('bank_transfers'); - addExtensionSql("CREATE TABLE `{?_MYSQL_PREFIX?}_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, @@ -93,7 +93,7 @@ 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'"); addDropTableSql('bank_packages'); - addExtensionSql("CREATE TABLE `{?_MYSQL_PREFIX?}_bank_packages` ( + addCreateTableSql('bank_packages', "( `id` BIGINT(20) UNSIGNED NOT NULL AUTO_INCREMENT, `title` VARCHAR(255) NOT NULL DEFAULT '', `description` TINYTEXT, @@ -117,7 +117,7 @@ PRIMARY KEY (`id`) // 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'); - addExtensionSql("CREATE TABLE `{?_MYSQL_PREFIX?}_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,