Editing of bank packages added (updating records not finished!)

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

diff --git a/inc/extensions/ext-bank.php b/inc/extensions/ext-bank.php
index 6eed145160147927cb7c927632d3fa3be6055fb4..982a00ef17ab9466def264375e01f517adbe95db 100644 (file)
--- a/inc/extensions/ext-bank.php
+++ b/inc/extensions/ext-bank.php
@@ -53,24 +53,24 @@ case "register": // Do stuff when installtion is running (modules.php?module=adm
        // SQL commands to run
        $SQLs[] = "DROP TABLE IF EXISTS "._MYSQL_PREFIX."_bank_accounts";
        $SQLs[] = "CREATE TABLE "._MYSQL_PREFIX."_bank_accounts (
-id bigint(20) not null auto_increment,
-uid bigint(20) not null default '0',
-account_created bigint(20) not null default '0',
-account_locked bigint(20) not null default '0',
-locked_reason tinytext,
-status enum('NEW', 'ACTIVE', 'LOCKED') not null default 'NEW',
-account_balance double(20,5) not null default '0.00000',
-output_mode enum('LOGIN', 'EMAIL', 'DISABLED'),
-pin varchar(50) not null default '',
-tan_mode enum('NORMAL', 'INDEXED'),
-tan_list_status enum('PENDING', 'ACTIVE', 'INVALID', 'LOCKED') not null default 'PENDING',
-tan_key varchar(50) not null default '',
-month_transfered bigint(20) not null default '0',
-last_tan varchar(5) not null default '00000',
-last_tan_stamp bigint(20) not null default '0',
-last_tan_purpose tinytext,
-account_type enum('CHECK', 'SAVING') not null default 'CHECK',
-overdraft_credit double(20,5) not null default '0.00000',
+id BIGINT(20) NOT NULL AUTO_INCREMENT,
+uid BIGINT(20) NOT NULL DEFAULT '0',
+account_created BIGINT(20) NOT NULL DEFAULT '0',
+account_locked BIGINT(20) NOT NULL DEFAULT '0',
+locked_reason TINYTEXT,
+status ENUM('NEW', 'ACTIVE', 'LOCKED') NOT NULL DEFAULT 'NEW',
+account_balance DOUBLE(20,5) NOT NULL DEFAULT '0.00000',
+output_mode ENUM('LOGIN', 'EMAIL', 'DISABLED'),
+pin VARCHAR(50) NOT NULL DEFAULT '',
+tan_mode ENUM('NORMAL', 'INDEXED'),
+tan_list_status ENUM('PENDING', 'ACTIVE', 'INVALID', 'LOCKED') NOT NULL DEFAULT 'PENDING',
+tan_key VARCHAR(50) NOT NULL DEFAULT '',
+month_transfered BIGINT(20) NOT NULL DEFAULT '0',
+last_tan VARCHAR(5) NOT NULL DEFAULT '00000',
+last_tan_stamp BIGINT(20) NOT NULL DEFAULT '0',
+last_tan_purpose TINYTEXT,
+account_type ENUM('CHECK', 'SAVING') NOT NULL DEFAULT 'CHECK',
+overdraft_credit DOUBLE(20,5) NOT NULL DEFAULT '0.00000',
 PRIMARY KEY (id),
 UNIQUE KEY (pin),
 INDEX `uid_type` (uid, account_type),
@@ -80,35 +80,35 @@ INDEX (last_tan_stamp)
 ) TYPE=MyISAM";
        $SQLs[] = "DROP TABLE IF EXISTS "._MYSQL_PREFIX."_bank_transfers";
        $SQLs[] = "CREATE TABLE "._MYSQL_PREFIX."_bank_transfers (
-id bigint(20) not null auto_increment,
-to_account_id bigint(20) not null default '0',
-from_account_id bigint(20) not null default '0',
-points_amount double(20,5) not null default '0.00000',
-day_bookkeeping char(4) not null default '0000',
-day_available char(4) not null default '0000',
-transfer_purpose tinytext,
+id BIGINT(20) NOT NULL AUTO_INCREMENT,
+to_account_id BIGINT(20) NOT NULL DEFAULT '0',
+from_account_id BIGINT(20) NOT NULL DEFAULT '0',
+points_amount DOUBLE(20,5) NOT NULL DEFAULT '0.00000',
+day_bookkeeping char(4) NOT NULL DEFAULT '0000',
+day_available char(4) NOT NULL DEFAULT '0000',
+transfer_purpose TINYTEXT,
 PRIMARY KEY (id),
 INDEX (to_account_id, from_account_id),
 INDEX (day_bookkeeping, day_available)
 ) TYPE=MyISAM";
        $SQLs[] = "DROP TABLE IF EXISTS "._MYSQL_PREFIX."_bank_packages";
        $SQLs[] = "CREATE TABLE "._MYSQL_PREFIX."_bank_packages (
-id bigint(20) not null auto_increment,
-title varchar(255) not null default '',
-description tinytext,
-account_fee double(20,5) not null default '0.00000',
-free_transfers int(7) not null default '0',
-transfer_fee double(20,5) not null default '0.00000',
-available varchar(8) not null default '19700101',
-output_system_mode enum('LOGIN', 'EMAIL', 'DISABLED'),
-package_active enum('Y', 'N') not null default 'N',
-free_months_no_fee tinyint(3) not null default '0',
-interest_plus float(7,5) not null default '0.00000',
-interest_minus float(7,5) not null default '0.00000',
-first_payment double(20,5) not null default '0.00000',
-free_account_income double(20,5) not null default '0.00000',
-free_account_stuff tinytext null,
-tan_lock tinyint(3) not null default '0',
+id BIGINT(20) NOT NULL AUTO_INCREMENT,
+title VARCHAR(255) NOT NULL DEFAULT '',
+description TINYTEXT,
+account_fee DOUBLE(20,5) NOT NULL DEFAULT '0.00000',
+free_transfers int(7) NOT NULL DEFAULT '0',
+transfer_fee DOUBLE(20,5) NOT NULL DEFAULT '0.00000',
+available TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP,
+output_system_mode ENUM('LOGIN', 'EMAIL', 'DISABLED'),
+package_active ENUM('Y', 'N') NOT NULL DEFAULT 'N',
+free_months_no_fee TINYINT(3) NOT NULL DEFAULT '0',
+interest_plus float(7,5) NOT NULL DEFAULT '0.00000',
+interest_minus float(7,5) NOT NULL DEFAULT '0.00000',
+first_payment DOUBLE(20,5) NOT NULL DEFAULT '0.00000',
+free_account_income DOUBLE(20,5) NOT NULL DEFAULT '0.00000',
+free_account_stuff TINYTEXT null,
+tan_lock TINYINT(3) NOT NULL DEFAULT '0',
 PRIMARY KEY (id)
 ) TYPE=MyISAM";
        // free_account_stuff will be a list of columns of the table _bank_packages
@@ -117,11 +117,11 @@ PRIMARY KEY (id)
        // should be fine. More than one entry and not DISABLED ;) are not supported.
        $SQLs[] = "DROP TABLE IF EXISTS "._MYSQL_PREFIX."_bank_tanlist";
        $SQLs[] = "CREATE TABLE "._MYSQL_PREFIX."_bank_tanlist (
-id bigint(20) not null auto_increment,
-idx tinyint(3) not null default '0',
-account_id bigint(20) not null default '0',
-tan varchar(50) not null default '',
-used enum('Y', 'N') not null default 'N',
+id BIGINT(20) NOT NULL AUTO_INCREMENT,
+idx TINYINT(3) NOT NULL DEFAULT '0',
+account_id BIGINT(20) 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)
 ) TYPE=MyISAM";