CREATE TABLE IF NOT EXISTS `wc_program_temp` ( `JobRef` varchar(11) DEFAULT NULL, `Area` varchar(255) DEFAULT NULL, `Parish` varchar(255) DEFAULT NULL, `AbbrWorkType` varchar(255) DEFAULT NULL, `WorkType` varchar(255) DEFAULT NULL, `Timing` varchar(255) DEFAULT NULL, `TrafficManagement` varchar(255) DEFAULT NULL, `Location` varchar(120) DEFAULT NULL, `Duration` varchar(15) DEFAULT NULL, `Start` varchar(255) DEFAULT NULL, `Finish` varchar(255) DEFAULT NULL ) ENGINE=MyISAM DEFAULT CHARSET=utf8;