DROP Table serialList;

CREATE TABLE `serialList` (
  `serial_number` varchar(24) NOT NULL default '',
  `serial_product` int(12) NOT NULL default '0',
  `serial_member` varchar(12) default NULL,
  `serial_date` date default NULL,
  `serial_status` int(1) NOT NULL default '0',
  PRIMARY KEY  (`serial_number`)
);