TRUNCATE TABLE `task`; INSERT INTO `task` VALUES (1, 1, 'A', 'beta testing', 'Urgent: go to the toilets before you wet your pants', '', 0, '2005-10-20 05:18:59', '2005-10-20 08:24:29', '2005-10-20'); INSERT INTO `task` VALUES (2, 3, 'W', 'beta testing', 'check it all, test it all, write a report', '', 2, '2005-10-20 05:19:29', '2005-10-20 05:19:29', '2005-10-20'); INSERT INTO `task` VALUES (3, 3, 'H', 'housecleaning', 'flush the toilets now that you''re done', '', 0, '2005-10-20 05:20:53', '2005-10-20 05:29:38', '2005-10-20'); INSERT INTO `task` VALUES (4, 2, 'H', 'housecleaning', 'check the toilets before guests arrive', '', 0, '2005-10-20 05:21:18', '2005-10-20 05:29:34', '2005-10-21'); INSERT INTO `task` VALUES (5, 3, 'W', 'beta testing', 'test it again, just to make sure', '', 0, '2005-10-20 05:21:49', '2005-10-20 05:21:49', '2005-10-21'); INSERT INTO `task` VALUES (6, 1, 'W', 'prospect', 'write down list of potential clients you could call', '', 5, '2005-10-20 05:22:41', '2005-10-20 05:39:58', '2005-10-21'); INSERT INTO `task` VALUES (7, 4, 'P', 'prospect', 'call the clients on the list', '', 0, '2005-10-20 05:23:06', '2005-10-20 05:23:06', '2005-10-21'); INSERT INTO `task` VALUES (8, 3, 'W', 'beta testing', 'burn the report, start all over again', '', 0, '2005-10-20 05:23:41', '2005-10-20 05:23:41', '2005-10-22'); INSERT INTO `task` VALUES (9, 4, 'H', 'housecleaning', 'it''s vacuum cleaning day!', '', 0, '2005-10-20 05:24:11', '2005-10-20 05:29:28', '2005-10-23'); INSERT INTO `task` VALUES (10, 2, 'W', 'beta testing', 'deploy the beta version without any more testings', '', 0, '2005-10-20 05:24:58', '2005-10-20 05:25:05', '2005-10-26'); INSERT INTO `task` VALUES (11, 3, 'W', 'website', 'draw sketches of whatever goes through your mind', '', 1, '2005-10-20 05:25:48', '2005-10-20 05:26:34', '2005-10-27'); INSERT INTO `task` VALUES (12, 1, 'W', 'website', 'think about what will this website be all about', '', 0, '2005-10-20 05:26:58', '2005-10-20 05:32:39', '9999-00-00'); INSERT INTO `task` VALUES (13, 5, 'H', 'housecleaning', 'wipe out the dust out of your desk', '', 0, '2005-10-20 05:29:22', '2005-10-20 05:29:22', '9999-00-00'); INSERT INTO `task` VALUES (14, 1, 'P', 'client #1', 'kiss his ass, and try not to be smart', '', 0, '2005-10-20 05:30:54', '2005-10-20 05:30:54', '2005-10-28'); INSERT INTO `task` VALUES (15, 2, 'W', 'website', 'review your drawings, and smoke ''em', '', 0, '2005-10-20 05:31:47', '2005-10-20 05:31:47', '2005-10-28'); INSERT INTO `task` VALUES (16, 3, 'W', 'website', 'draw some more now that you''re off your head', '', 0, '2005-10-20 05:32:12', '2005-10-20 05:32:12', '2005-10-28'); INSERT INTO `task` VALUES (17, 3, 'P', 'client #1', 'call to say hello and ask about his wife and kids', '', 0, '2005-10-20 05:33:20', '2005-10-20 05:33:20', '2005-10-29');