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,
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,
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
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)");