MyISAM/InnoDB support added

[mailer.git] / inc / extensions / ext-bank.php

diff --git a/inc/extensions/ext-bank.php b/inc/extensions/ext-bank.php
index 0e8f7593992fadce0b2866aaec7bc5fa4ba63c92..b245c1595a91a16b21a8b3fc52d59d56ffff8af3 100644 (file)
--- a/inc/extensions/ext-bank.php
+++ b/inc/extensions/ext-bank.php
@@ -73,7 +73,7 @@ INDEX `uid_type` (uid, account_type),
 INDEX (account_created),
 INDEX (account_locked),
 INDEX (last_tan_stamp)
 INDEX (account_created),
 INDEX (account_locked),
 INDEX (last_tan_stamp)

-) TYPE=MyISAM");
+) TYPE={!_TABLE_TYPE!}");

        ADD_SQL("DROP TABLE IF EXISTS `{!_MYSQL_PREFIX!}_bank_transfers`");
        ADD_SQL("CREATE TABLE `{!_MYSQL_PREFIX!}_bank_transfers` (
 id BIGINT(20) UNSIGNED NOT NULL AUTO_INCREMENT,
        ADD_SQL("DROP TABLE IF EXISTS `{!_MYSQL_PREFIX!}_bank_transfers`");
        ADD_SQL("CREATE TABLE `{!_MYSQL_PREFIX!}_bank_transfers` (
 id BIGINT(20) UNSIGNED NOT NULL AUTO_INCREMENT,


@@ -86,7 +86,7 @@ transfer_purpose TINYTEXT,
 PRIMARY KEY (id),
 INDEX (to_account_id, from_account_id),
 INDEX (day_bookkeeping, day_available)
 PRIMARY KEY (id),
 INDEX (to_account_id, from_account_id),
 INDEX (day_bookkeeping, day_available)

-) TYPE=MyISAM");
+) TYPE={!_TABLE_TYPE!}");

        ADD_SQL("DROP TABLE IF EXISTS `{!_MYSQL_PREFIX!}_bank_packages`");
        ADD_SQL("CREATE TABLE `{!_MYSQL_PREFIX!}_bank_packages` (
 id BIGINT(20) UNSIGNED NOT NULL AUTO_INCREMENT,
        ADD_SQL("DROP TABLE IF EXISTS `{!_MYSQL_PREFIX!}_bank_packages`");
        ADD_SQL("CREATE TABLE `{!_MYSQL_PREFIX!}_bank_packages` (
 id BIGINT(20) UNSIGNED NOT NULL AUTO_INCREMENT,


@@ -106,7 +106,7 @@ 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)
 free_account_stuff TINYTEXT null,
 tan_lock TINYINT(3) UNSIGNED NOT NULL DEFAULT 0,
 PRIMARY KEY (id)

-) TYPE=MyISAM");
+) TYPE={!_TABLE_TYPE!}");

        // 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
        // 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


@@ -120,7 +120,7 @@ tan VARCHAR(50) NOT NULL DEFAULT '',
 used ENUM('Y','N') NOT NULL DEFAULT 'N',
 PRIMARY KEY (id),
 UNIQUE (account_id, tan)
 used ENUM('Y','N') NOT NULL DEFAULT 'N',
 PRIMARY KEY (id),
 UNIQUE (account_id, tan)

-) TYPE=MyISAM");
+) TYPE={!_TABLE_TYPE!}");

 
        // Admin menu queries
        ADD_SQL("INSERT INTO `{!_MYSQL_PREFIX!}_admin_menu` (`action`,`what`,`title`,`descr`,`sort`) VALUES ('bank', NULL, 'Bank-Accounts','Verwalten Sie hier alle Bank-Accounts Ihrer Mitglieder, sowie Angebotspakete und Überweisungen.', 6)");
 
        // Admin menu queries
        ADD_SQL("INSERT INTO `{!_MYSQL_PREFIX!}_admin_menu` (`action`,`what`,`title`,`descr`,`sort`) VALUES ('bank', NULL, 'Bank-Accounts','Verwalten Sie hier alle Bank-Accounts Ihrer Mitglieder, sowie Angebotspakete und Überweisungen.', 6)");