A Better Table Structure

-- 
-- Table structure for table `tblBanlist`
-- 

CREATE TABLE `tblBanlist` (
  `fldBL_id` int(11) NOT NULL auto_increment,
  `fldBL_type` enum('0','1') NOT NULL default '0',
  `fldBL_ban` varchar(20) NOT NULL default '',
  `fldBL_began` float NOT NULL default '0',
  `fldBL_ends` float NOT NULL default '0',
  `fldBL_permanent` enum('0','1') NOT NULL default '0',
  `fldBL_banner` bigint(20) NOT NULL default '0',
  `fldBL_info` text NOT NULL,
  PRIMARY KEY  (`fldBL_id`),
  UNIQUE KEY `fldBL_ban` (`fldBL_ban`),
  FULLTEXT KEY `fldBL_info` (`fldBL_info`)
) TYPE=MyISAM AUTO_INCREMENT=1 ;

-- --------------------------------------------------------

-- 
-- Table structure for table `tblLog`
-- 

CREATE TABLE `tblLog` (
  `fldL_id` bigint(20) NOT NULL auto_increment,
  `fldL_user` int(11) NOT NULL default '0',
  `fldL_ip` varchar(15) NOT NULL default '',
  `fldL_dump` text NOT NULL,
  `fldL_date` float NOT NULL default '0',
  PRIMARY KEY  (`fldL_id`),
  FULLTEXT KEY `fldL_dump` (`fldL_dump`)
) TYPE=MyISAM AUTO_INCREMENT=1 ;

-- --------------------------------------------------------

-- 
-- Table structure for table `tblStats`
-- 

CREATE TABLE `tblStats` (
  `fldS_id` bigint(20) NOT NULL auto_increment,
  `fldS_xp` int(11) NOT NULL default '0',
  `fldS_cash` bigint(20) NOT NULL default '0',
  `fldS_cheques` int(11) NOT NULL default '0',
  `fldS_bank` bigint(20) NOT NULL default '0',
  `fldS_deposited` float NOT NULL default '0',
  PRIMARY KEY  (`fldS_id`)
) TYPE=InnoDB AUTO_INCREMENT=1 ;

-- --------------------------------------------------------

-- 
-- Table structure for table `tblUsers`
-- 

CREATE TABLE `tblUsers` (
  `fldU_id` bigint(20) NOT NULL auto_increment,
  `fldU_email` varchar(255) NOT NULL default '',
  `fldU_password` varchar(32) NOT NULL default '',
  `fldU_alias` varchar(20) NOT NULL default '',
  `fldU_type` enum('0','1','2','3') NOT NULL default '0',
  `fldU_status` enum('0','1','2') NOT NULL default '0',
  `fldU_joined` float NOT NULL default '0',
  `fldU_lastlogin` float NOT NULL default '0',
  PRIMARY KEY  (`fldU_id`),
  UNIQUE KEY `fldU_email` (`fldU_email`),
  UNIQUE KEY `fldU_alias` (`fldU_alias`)
) TYPE=MyISAM AUTO_INCREMENT=1 ;