X-Git-Url: https://git.mxchange.org/?p=mailer.git;a=blobdiff_plain;f=inc%2Fmodules%2Fmember%2Fwhat-transfer.php;h=03da5c22f3785c6dec57c1e9f21aff69fa555923;hp=6028b1567f850c6e56c1712106d127cc3f9567af;hb=e8a44f28a734e4796b70a1bc9df353f2466e1846;hpb=ccb18b206e318281763e5b0ea30e5c2b41df785c

diff --git a/inc/modules/member/what-transfer.php b/inc/modules/member/what-transfer.php
index 6028b1567f..03da5c22f3 100644
--- a/inc/modules/member/what-transfer.php
+++ b/inc/modules/member/what-transfer.php
@@ -422,12 +422,12 @@ case "list_all": // List all transactions
 	//
 	// First of all create the temporary table
 	$result = SQL_QUERY("CREATE TEMPORARY TABLE "._MYSQL_PREFIX."_transfers_tmp (
-trans_id varchar(12) not null default '',
-party_uid bigint(20) not null default '0',
-points bigint(20) not null default '0',
-reason varchar(255) not null default '',
-time_trans varchar(10) not null default '0',
-trans_type enum('IN', 'OUT') not null default 'IN',
+trans_id VARCHAR(12) NOT NULL DEFAULT '',
+party_uid BIGINT(20) NOT NULL DEFAULT '0',
+points BIGINT(20) NOT NULL DEFAULT '0',
+reason VARCHAR(255) NOT NULL DEFAULT '',
+time_trans VARCHAR(10) NOT NULL DEFAULT '0',
+trans_type ENUM('IN', 'OUT') NOT NULL DEFAULT 'IN',
 KEY(party_uid)
 ) TYPE=HEAP", __FILE__, __LINE__);