-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) 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) 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) UNSIGNED NOT NULL DEFAULT '0',
+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',