CREATE TABLE `acnt` (
  `id` int(6) NOT NULL auto_increment,
  `first_name` varchar(50) NOT NULL,
  `last_name` varchar(50) NOT NULL,
  `gender` varchar(50) NOT NULL,
  `dob` varchar(50) NOT NULL,
  `address` text NOT NULL,
  `phone` varchar(15) NOT NULL,
  `email` varchar(50) NOT NULL,
  `password` varchar(50) NOT NULL,
  `country` varchar(50) NOT NULL,
  `state` varchar(50) NOT NULL,
  `city` varchar(50) NOT NULL,
  `zip` varchar(15) NOT NULL,
  `account_name` varchar(50) NOT NULL,
  `account_currency` varchar(50) NOT NULL,
  `account_type` varchar(50) NOT NULL,
  `initial_deposit` varchar(50) NOT NULL,
  `occupation` varchar(50) NOT NULL,
  `passport` varchar(50) NOT NULL,
  `next_of_kin_name` varchar(50) NOT NULL,
  `next_of_kin_address` text NOT NULL,
  `next_of_kin_phone` varchar(15) NOT NULL,
  `account_number` varchar(16) NOT NULL,
  `account_pin` varchar(8) NOT NULL,
  `account_status` varchar(10) NOT NULL,
  `sid_serial` varchar(50) NOT NULL,
  `deposit_1` varchar(20) NOT NULL,
  `deposit_2` varchar(20) NOT NULL,
  `deposit_3` varchar(20) NOT NULL,
  `deposit_4` varchar(20) NOT NULL,
  `date_1` varchar(50) NOT NULL,
  `date_2` varchar(50) NOT NULL,
  `date_3` varchar(50) NOT NULL,
  `date_4` varchar(50) NOT NULL,
  `current_balance` varchar(50) NOT NULL,
  `cot_code` varchar(50) NOT NULL,
  `tax_code` varchar(50) NOT NULL,
  `ant_code` varchar(50) NOT NULL,
  `igb_code` varchar(50) NOT NULL,
  PRIMARY KEY  (`id`),
  UNIQUE KEY `id` (`id`)
) ENGINE=MyISAM  DEFAULT CHARSET=latin1 AUTO_INCREMENT=21 ;

