X-Git-Url: https://git.mxchange.org/?a=blobdiff_plain;f=inc%2Fextensions%2Fext-bank.php;h=0d9a836402792a4d3028da430aa1d080c35b1264;hb=4db052cce49f60b6d9cc0f1c06b95cdd99f904ad;hp=80b7e03c9e9bd8d455b12a9cadc2624a86677d89;hpb=307a4e11763f0914e73dc756b219356e1c29ab25;p=mailer.git

diff --git a/inc/extensions/ext-bank.php b/inc/extensions/ext-bank.php
index 80b7e03c9e..0d9a836402 100644
--- 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',
+id BIGINT(20) UNSIGNED NOT NULL AUTO_INCREMENT,
+uid BIGINT(20) UNSIGNED NOT NULL DEFAULT '0',
+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) NOT NULL DEFAULT '0.00000',
+account_balance DOUBLE(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'),
 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',
+month_transfered BIGINT(20) UNSIGNED NOT NULL DEFAULT '0',
 last_tan VARCHAR(5) NOT NULL DEFAULT '00000',
-last_tan_stamp BIGINT(20) NOT NULL DEFAULT '0',
+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) NOT NULL DEFAULT '0.00000',
+overdraft_credit DOUBLE(20,5) UNSIGNED NOT NULL DEFAULT '0.00000',
 PRIMARY KEY (id),
 UNIQUE KEY (pin),
 INDEX `uid_type` (uid, account_type),
@@ -80,12 +80,12 @@ 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',
+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',
+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),
@@ -93,22 +93,22 @@ 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,
+id BIGINT(20) UNSIGNED 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',
+account_fee DOUBLE(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',
 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_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',
 free_account_stuff TINYTEXT null,
-tan_lock TINYINT(3) NOT NULL DEFAULT '0',
+tan_lock TINYINT(3) UNSIGNED NOT NULL DEFAULT '0',
 PRIMARY KEY (id)
 ) TYPE=MyISAM";
 	// free_account_stuff will be a list of columns of the table _bank_packages
@@ -117,9 +117,9 @@ 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',
+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',
 tan VARCHAR(50) NOT NULL DEFAULT '',
 used ENUM('Y', 'N') NOT NULL DEFAULT 'N',
 PRIMARY KEY (id),