NEW TABLE:

| home_user | CREATE TABLE `home_user` (
  `home_user_id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `firstname` varchar(50) NOT NULL,
  `lastname` varchar(50) NOT NULL,
  `emailathome` varchar(100) NOT NULL DEFAULT '',
  `status` enum('disabled','enabled') NOT NULL,
  `regdate` datetime NOT NULL,
  `enddate` datetime NOT NULL,
  `renewdate` datetime NOT NULL,
  `payments` int(10) unsigned NOT NULL,
  `product` varchar(25) NOT NULL,
  `futurepayid` int(10) unsigned NOT NULL,
  `transid` int(10) unsigned NOT NULL,
  `address` varchar(1000) NOT NULL,
  `postcode` varchar(10) NOT NULL,
  `job` varchar(25) NOT NULL,
  `recommended` varchar(50) NOT NULL,
  `failures` int(10) unsigned NOT NULL,
  `mailinglist` enum('yes','no') NOT NULL,
  PRIMARY KEY (`home_user_id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 | 


OLD TABLE:

CREATE TABLE `home_user` (
  `home_user_id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `firstname` varchar(50) NOT NULL,
  `lastname` varchar(50) NOT NULL,
  `emailathome` varchar(100) NOT NULL DEFAULT '',
  `status` enum('disabled','enabled') NOT NULL,
  `regdate` datetime NOT NULL,
  `enddate` datetime NOT NULL,
  `renewdate` datetime NOT NULL,
  `payments` int(10) unsigned NOT NULL,
  `product` varchar(25) NOT NULL,
  `futurepayid` int(10) unsigned NOT NULL,
  `transid` int(10) unsigned NOT NULL,
  `address` varchar(1000) NOT NULL,
  `postcode` varchar(10) NOT NULL,
  `job` varchar(25) NOT NULL,
  `recommended` varchar(50) NOT NULL,
  `failures` int(10) unsigned NOT NULL,
  `mailinglist` enum('yes','no') NOT NULL,
  PRIMARY KEY (`home_user_id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1