More default values rewritten, UNSIGNED added to many numerical database columns...

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

diff --git a/inc/extensions/ext-bank.php b/inc/extensions/ext-bank.php
index a6f79aedda7f7b9a99f56793608db5b568e3c816..95640968a3c9eb4b84dc35542828f46a99c4c944 100644 (file)
--- a/inc/extensions/ext-bank.php
+++ b/inc/extensions/ext-bank.php
@@ -58,7 +58,7 @@ account_created BIGINT(20) UNSIGNED NOT NULL DEFAULT 0,
 account_locked BIGINT(20) UNSIGNED NOT NULL DEFAULT 0,
 locked_reason TINYTEXT,
 status ENUM('NEW','ACTIVE','LOCKED') NOT NULL DEFAULT 'NEW',
-account_balance DOUBLE(20,5) UNSIGNED NOT NULL DEFAULT 0.00000,
+account_balance FLOAT(20,5) UNSIGNED NOT NULL DEFAULT 0.00000,
 output_mode ENUM('LOGIN','EMAIL','DISABLED'),
 pin VARCHAR(50) NOT NULL DEFAULT '',
 tan_mode ENUM('NORMAL','INDEXED'),
@@ -69,7 +69,7 @@ last_tan VARCHAR(5) NOT NULL DEFAULT '00000',
 last_tan_stamp BIGINT(20) UNSIGNED NOT NULL DEFAULT 0,
 last_tan_purpose TINYTEXT,
 account_type ENUM('CHECK','SAVING') NOT NULL DEFAULT 'CHECK',
-overdraft_credit DOUBLE(20,5) UNSIGNED NOT NULL DEFAULT 0.00000,
+overdraft_credit FLOAT(20,5) UNSIGNED NOT NULL DEFAULT 0.00000,
 PRIMARY KEY (id),
 UNIQUE KEY (pin),
 INDEX `uid_type` (uid, account_type),
@@ -82,7 +82,7 @@ INDEX (last_tan_stamp)
 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,
-points_amount DOUBLE(20,5) UNSIGNED NOT NULL DEFAULT 0.00000,
+points_amount FLOAT(20,5) UNSIGNED NOT NULL DEFAULT 0.00000,
 day_bookkeeping CHAR(4) NOT NULL DEFAULT '0000',
 day_available CHAR(4) NOT NULL DEFAULT '0000',
 transfer_purpose TINYTEXT,
@@ -95,17 +95,17 @@ INDEX (day_bookkeeping, day_available)
 id BIGINT(20) UNSIGNED NOT NULL AUTO_INCREMENT,
 title VARCHAR(255) NOT NULL DEFAULT '',
 description TINYTEXT,
-account_fee DOUBLE(20,5) UNSIGNED NOT NULL DEFAULT 0.00000,
+account_fee FLOAT(20,5) UNSIGNED NOT NULL DEFAULT 0.00000,
 free_transfers INT(7) UNSIGNED NOT NULL DEFAULT 0,
-transfer_fee DOUBLE(20,5) UNSIGNED NOT NULL DEFAULT 0.00000,
+transfer_fee FLOAT(20,5) UNSIGNED 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) UNSIGNED NOT NULL DEFAULT 0,
 interest_plus FLOAT(7,5) UNSIGNED NOT NULL DEFAULT 0.00000,
 interest_minus FLOAT(7,5) UNSIGNED NOT NULL DEFAULT 0.00000,
-first_payment DOUBLE(20,5) UNSIGNED NOT NULL DEFAULT 0.00000,
-free_account_income DOUBLE(20,5) UNSIGNED NOT NULL DEFAULT 0.00000,
+first_payment FLOAT(20,5) UNSIGNED NOT NULL DEFAULT 0.00000,
+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)