DROP TABLE IF EXISTS web_keograms;

CREATE TABLE `web_keograms` ( 
`id` INT AUTO_INCREMENT PRIMARY KEY,
`location` char(3) NOT NULL DEFAULT '', 
`imager` char(3) NOT NULL DEFAULT '', 
`field_of_view` char(3) NOT NULL DEFAULT '', 
`filter` int(11) NOT NULL DEFAULT 0, 
`frame_rate` real NOT NULL DEFAULT '0.0', 
`start_date` datetime NOT NULL DEFAULT '0000-00-00 00:00',
`end_date` datetime NOT NULL DEFAULT '0000-00-00 00:00',
`data_flag` tinyint(1) NOT NULL DEFAULT 1
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

INSERT INTO `web_keograms` VALUES 
('NULL', 'PKR', 'THA', 'ASC', '5577', '3.3', '2011-09-26 10:00', '2011-09-26 14:00', '1'), 
('NULL', 'PKR', 'THA', 'ASC', '5577', '3.3', '2011-09-27 9:00', '2011-09-27 14:00', '1'), 
('NULL', 'PKR', 'THA', 'ASC', '5577', '3.3', '2011-09-28 5:00', '2011-09-28 14:00', '1'), 
('NULL', 'PKR', 'THA', 'ASC', '5577', '3.3', '2011-09-29 7:00', '2011-09-29 12:00', '1'), 
('NULL', 'PKR', 'THA', 'ASC', '5577', '3.3', '2011-10-01 8:00', '2011-10-01 13:00', '1'), 
('NULL', 'PKR', 'THA', 'ASC', '5577', '3.3', '2011-10-02 5:00', '2011-10-02 11:00', '1'), 
('NULL', 'PKR', 'THA', 'ASC', '5577', '3.3', '2011-10-04 6:00', '2011-10-04 14:00', '1'), 
('NULL', 'PKR', 'THA', 'ASC', '5577', '3.3', '2011-10-05 6:00', '2011-10-05 15:00', '1'), 
('NULL', 'PKR', 'THA', 'ASC', '5577', '3.3', '2011-10-06 11:00', '2011-10-06 15:00', '1'), 
('NULL', 'PKR', 'THA', 'ASC', '5577', '3.3', '2011-10-07 6:00', '2011-10-07 10:00', '1'), 
('NULL', 'PKR', 'THA', 'ASC', '5577', '3.3', '2011-10-08 10:00', '2011-10-08 15:00', '1'), 
('NULL', 'PKR', 'THA', 'ASC', '5577', '3.3', '2011-10-09 4:00', '2011-10-09 15:00', '1'), 
('NULL', 'PKR', 'THA', 'ASC', '5577', '3.3', '2011-10-13 7:00', '2011-10-13 12:00', '1'), 
('NULL', 'PKR', 'THA', 'ASC', '5577', '3.3', '2011-10-15 13:00', '2011-10-15 15:00', '1'), 
('NULL', 'PKR', 'THA', 'ASC', '5577', '3.3', '2011-10-21 3:00', '2011-10-21 14:00', '1'), 
('NULL', 'PKR', 'THA', 'ASC', '5577', '3.3', '2011-10-22 3:00', '2011-10-22 16:00', '1'), 
('NULL', 'PKR', 'THA', 'ASC', '5577', '3.3', '2011-10-25 8:00', '2011-10-25 12:00', '1'), 
('NULL', 'PKR', 'THA', 'ASC', '5577', '3.3', '2011-10-26 9:00', '2011-10-26 12:00', '1'), 
('NULL', 'PKR', 'THA', 'ASC', '5577', '3.3', '2011-10-27 11:00', '2011-10-27 13:00', '1'), 
('NULL', 'PKR', 'THA', 'ASC', '5577', '3.3', '2011-10-27 15:00', '2011-10-27 16:00', '1'), 
('NULL', 'PKR', 'THA', 'ASC', '5577', '3.3', '2011-11-02 3:00', '2011-11-02 16:00', '1'), 
('NULL', 'PKR', 'THA', 'ASC', '5577', '3.3', '2011-11-03 3:00', '2011-11-03 16:00', '1'), 
('NULL', 'PKR', 'THA', 'ASC', '5577', '3.3', '2011-11-04 10:00', '2011-11-04 15:00', '1'), 
('NULL', 'PKR', 'THA', 'ASC', '5577', '3.3', '2011-11-15 7:00', '2011-11-15 16:00', '1'), 
('NULL', 'PKR', 'THA', 'ASC', '5577', '3.3', '2011-11-16 3:00', '2011-11-16 16:00', '1'), 
('NULL', 'PKR', 'THA', 'ASC', '5577', '3.3', '2011-11-17 3:00', '2011-11-17 16:00', '1'), 
('NULL', 'PKR', 'THA', 'ASC', '5577', '3.3', '2011-11-19 3:00', '2011-11-19 16:00', '1'), 
('NULL', 'PKR', 'THA', 'ASC', '5577', '3.3', '2011-11-20 3:00', '2011-11-20 16:00', '1'), 
('NULL', 'PKR', 'THA', 'ASC', '5577', '3.3', '2011-11-21 3:00', '2011-11-21 16:00', '1'), 
('NULL', 'PKR', 'THA', 'ASC', '5577', '3.3', '2011-11-22 3:00', '2011-11-22 16:00', '1'), 
('NULL', 'PKR', 'THA', 'ASC', '5577', '3.3', '2011-11-23 3:00', '2011-11-23 17:00', '1'), 
('NULL', 'PKR', 'THA', 'ASC', '5577', '3.3', '2011-11-24 3:00', '2011-11-24 17:00', '1'), 
('NULL', 'PKR', 'THA', 'ASC', '5577', '3.3', '2011-11-27 7:00', '2011-11-27 17:00', '1'), 
('NULL', 'PKR', 'THA', 'ASC', '5577', '3.3', '2011-11-28 14:00', '2011-11-28 17:00', '1'), 
('NULL', 'PKR', 'THA', 'ASC', '5577', '3.3', '2011-11-29 3:00', '2011-11-29 17:00', '1'), 
('NULL', 'PKR', 'THA', 'ASC', '5577', '3.3', '2011-11-30 16:00', '2011-11-30 17:00', '1'), 
('NULL', 'PKR', 'THA', 'ASC', '5577', '3.3', '2011-12-01 2:00', '2011-12-01 18:00', '1'), 
('NULL', 'PKR', 'THA', 'ASC', '5577', '3.3', '2011-12-03 7:00', '2011-12-03 16:00', '1'), 
('NULL', 'PKR', 'THA', 'ASC', '5577', '3.3', '2011-12-11 11:00', '2011-12-11 13:00', '1'), 
('NULL', 'PKR', 'THA', 'ASC', '5577', '3.3', '2011-12-18 9:00', '2011-12-18 13:00', '1'), 
('NULL', 'PKR', 'THA', 'ASC', '5577', '3.3', '2011-12-19 8:00', '2011-12-19 10:00', '1'), 
('NULL', 'PKR', 'THA', 'ASC', '5577', '3.3', '2011-12-20 2:00', '2011-12-20 7:00', '1'), 
('NULL', 'PKR', 'THA', 'ASC', '5577', '3.3', '2011-12-21 11:00', '2011-12-21 14:00', '1'), 
('NULL', 'PKR', 'THA', 'ASC', '5577', '3.3', '2011-12-22 2:00', '2011-12-22 18:00', '1'), 
('NULL', 'PKR', 'THA', 'ASC', '5577', '3.3', '2011-12-24 9:00', '2011-12-24 11:00', '1'), 
('NULL', 'PKR', 'THA', 'ASC', '5577', '3.3', '2012-01-01 12:00', '2012-01-01 14:00', '1'), 
('NULL', 'PKR', 'THA', 'ASC', '5577', '3.3', '2012-01-03 2:00', '2012-01-03 18:00', '1'), 
('NULL', 'PKR', 'THA', 'ASC', '5577', '3.3', '2012-01-04 7:00', '2012-01-04 11:00', '1'), 
('NULL', 'PKR', 'THA', 'ASC', '5577', '3.3', '2012-01-05 10:00', '2012-01-05 18:00', '1'), 
('NULL', 'PKR', 'THA', 'ASC', '5577', '3.3', '2012-01-07 2:00', '2012-01-07 18:00', '1'), 
('NULL', 'PKR', 'THA', 'ASC', '5577', '3.3', '2012-01-10 10:00', '2012-01-10 14:00', '1'), 
('NULL', 'PKR', 'THA', 'ASC', '5577', '3.3', '2012-01-14 8:00', '2012-01-14 12:00', '1'), 
('NULL', 'PKR', 'THA', 'ASC', '5577', '3.3', '2012-01-15 2:00', '2012-01-15 18:00', '1'), 
('NULL', 'PKR', 'THA', 'ASC', '5577', '3.3', '2012-01-16 10:00', '2012-01-16 18:00', '1'), 
('NULL', 'PKR', 'THA', 'ASC', '5577', '3.3', '2012-01-17 2:00', '2012-01-17 18:00', '1'), 
('NULL', 'PKR', 'THA', 'ASC', '5577', '3.3', '2012-01-18 2:00', '2012-01-18 18:00', '1'), 
('NULL', 'PKR', 'THA', 'ASC', '5577', '3.3', '2012-01-19 2:00', '2012-01-19 18:00', '1'), 
('NULL', 'PKR', 'THA', 'ASC', '5577', '3.3', '2012-01-20 2:00', '2012-01-20 18:00', '1'), 
('NULL', 'PKR', 'THA', 'ASC', '5577', '3.3', '2012-01-21 2:00', '2012-01-21 18:00', '1'), 
('NULL', 'PKR', 'THA', 'ASC', '5577', '3.3', '2012-01-22 8:00', '2012-01-22 18:00', '1'), 
('NULL', 'PKR', 'THA', 'ASC', '5577', '3.3', '2012-01-23 8:00', '2012-01-23 13:00', '1'), 
('NULL', 'PKR', 'THA', 'ASC', '5577', '3.3', '2012-01-24 8:00', '2012-01-24 11:00', '1'), 
('NULL', 'PKR', 'THA', 'ASC', '5577', '3.3', '2012-01-24 15:00', '2012-01-24 18:00', '1'), 
('NULL', 'PKR', 'THA', 'ASC', '5577', '3.3', '2012-01-25 15:00', '2012-01-25 18:00', '1'), 
('NULL', 'PKR', 'THA', 'ASC', '5577', '3.3', '2012-01-26 00:00', '2012-01-26 00:00', '1'), 
('NULL', 'PKR', 'THA', 'ASC', '5577', '3.3', '2012-01-27 8:00', '2012-01-27 18:00', '1'), 
('NULL', 'PKR', 'THA', 'ASC', '5577', '3.3', '2012-01-28 2:00', '2012-01-28 18:00', '1'), 
('NULL', 'PKR', 'THA', 'ASC', '5577', '3.3', '2012-01-29 10:00', '2012-01-29 14:00', '1'), 
('NULL', 'PKR', 'THA', 'ASC', '5577', '3.3', '2012-01-30 00:00', '2012-01-30 00:00', '0'), 
('NULL', 'PKR', 'THA', 'ASC', '5577', '3.3', '2012-01-31 14:00', '2012-01-31 17:00', '1'), 
('NULL', 'PKR', 'THA', 'ASC', '5577', '3.3', '2012-02-01 8:00', '2012-02-01 16:00', '1'), 
('NULL', 'PKR', 'THA', 'ASC', '5577', '3.3', '2012-02-02 00:00', '2012-02-02 00:00', '0'), 
('NULL', 'PKR', 'THA', 'ASC', '5577', '3.3', '2012-02-25 8:00', '2012-02-25 11:00', '1'), 
('NULL', 'PKR', 'THA', 'ASC', '5577', '3.3', '2012-02-26 00:00', '2012-02-26 00:00', '0'), 
('NULL', 'PKR', 'THA', 'ASC', '5577', '3.3', '2012-02-27 00:00', '2012-02-27 00:00', '0'), 
('NULL', 'PKR', 'THA', 'ASC', '5577', '3.3', '2012-02-28 7:00', '2012-02-28 11:00', '1'), 
('NULL', 'PKR', 'THA', 'ASC', '5577', '3.3', '2012-02-29 8:00', '2012-02-29 13:00', '1'), 
('NULL', 'PKR', 'THA', 'ASC', '5577', '3.3', '2012-03-01 6:00', '2012-03-01 16:00', '1'), 
('NULL', 'PKR', 'THA', 'ASC', '5577', '3.3', '2012-03-02 4:00', '2012-03-02 16:00', '1'), 
('NULL', 'PKR', 'THA', 'ASC', '5577', '3.3', '2012-03-03 5:00', '2012-03-03 16:00', '1'), 
('NULL', 'PKR', 'THA', 'ASC', '5577', '3.3', '2012-03-04 7:00', '2012-03-04 16:00', '1'), 
('NULL', 'PKR', 'THA', 'ASC', '5577', '3.3', '2012-03-05 6:00', '2012-03-05 16:00', '1'), 
('NULL', 'PKR', 'THA', 'ASC', '5577', '3.3', '2012-03-06 00:00', '2012-03-06 00:00', '0'), 
('NULL', 'PKR', 'THA', 'ASC', '5577', '3.3', '2012-03-07 6:00', '2012-03-07 10:00', '1'), 
('NULL', 'PKR', 'THA', 'ASC', '5577', '3.3', '2012-03-08 10:00', '2012-03-08 16:00', '1'), 
('NULL', 'PKR', 'THA', 'ASC', '5577', '3.3', '2012-03-09 13:00', '2012-03-09 16:00', '1'), 
('NULL', 'PKR', 'THA', 'ASC', '5577', '3.3', '2012-03-10 5:00', '2012-03-10 16:00', '1'), 
('NULL', 'PKR', 'THA', 'ASC', '5577', '3.3', '2012-03-11 8:00', '2012-03-11 15:00', '1'), 
('NULL', 'PKR', 'THA', 'ASC', '5577', '3.3', '2012-03-12 8:00', '2012-03-12 16:00', '1'), 
('NULL', 'PKR', 'THA', 'ASC', '5577', '3.3', '2012-03-13 5:00', '2012-03-13 16:00', '1'), 
('NULL', 'PKR', 'THA', 'ASC', '5577', '3.3', '2012-03-14 8:00', '2012-03-14 16:00', '1'), 
('NULL', 'PKR', 'THA', 'ASC', '5577', '3.3', '2012-03-15 7:00', '2012-03-15 16:00', '1'), 
('NULL', 'PKR', 'THA', 'ASC', '5577', '3.3', '2012-03-16 5:00', '2012-03-16 16:00', '1'), 
('NULL', 'PKR', 'THA', 'ASC', '5577', '3.3', '2012-03-17 5:00', '2012-03-17 16:00', '1'), 
('NULL', 'PKR', 'THA', 'ASC', '5577', '3.3', '2012-03-18 11:00', '2012-03-18 13:00', '1'), 
('NULL', 'PKR', 'THA', 'ASC', '5577', '3.3', '2012-03-19 8:00', '2012-03-19 15:00', '1'), 
('NULL', 'PKR', 'THA', 'ASC', '5577', '3.3', '2012-03-20 00:00', '2012-03-20 00:00', '0'), 
('NULL', 'PKR', 'THA', 'ASC', '5577', '3.3', '2012-03-21 8:00', '2012-03-21 15:00', '1'), 
('NULL', 'PKR', 'THA', 'ASC', '5577', '3.3', '2012-03-22 5:00', '2012-03-22 15:00', '1'), 
('NULL', 'PKR', 'THA', 'ASC', '5577', '3.3', '2012-03-23 8:00', '2012-03-23 14:00', '1'), 
('NULL', 'PKR', 'THA', 'ASC', '5577', '3.3', '2012-03-24 00:00', '2012-03-24 00:00', '0'), 
('NULL', 'PKR', 'THA', 'ASC', '5577', '3.3', '2012-03-25 10:00', '2012-03-25 12:00', '1'), 
('NULL', 'PKR', 'THA', 'ASC', '5577', '3.3', '2012-03-26 00:00', '2012-03-26 00:00', '0'), 
('NULL', 'PKR', 'THA', 'ASC', '5577', '3.3', '2012-03-27 8:00', '2012-03-27 14:00', '1'), 
('NULL', 'PKR', 'THA', 'ASC', '5577', '3.3', '2012-03-28 6:00', '2012-03-28 14:00', '1'), 
('NULL', 'PKR', 'THA', 'ASC', '5577', '3.3', '2012-03-29 00:00', '2012-03-29 00:00', '0'), 
('NULL', 'PKR', 'THA', 'ASC', '5577', '3.3', '2012-03-30 8:00', '2012-03-30 11:00', '1'), 
('NULL', 'PKR', 'THA', 'ASC', '5577', '3.3', '2012-03-31 00:00', '2012-03-31 00:00', '0'), 
('NULL', 'PKR', 'THA', 'ASC', '5577', '3.3', '2012-04-01 11:00', '2012-04-01 13:00', '1'), 
('NULL', 'PKR', 'THA', 'ASC', '5577', '3.3', '2012-04-02 6:00', '2012-04-02 14:00', '1'), 
('NULL', 'PKR', 'THA', 'ASC', '5577', '3.3', '2012-04-03 9:00', '2012-04-03 13:00', '1'), 
('NULL', 'PKR', 'THA', 'ASC', '5577', '3.3', '2012-04-04 11:00', '2012-04-04 13:00', '1'), 
('NULL', 'PKR', 'THA', 'ASC', '5577', '3.3', '2012-04-05 6:00', '2012-04-05 14:00', '1'), 
('NULL', 'PKR', 'THA', 'ASC', '5577', '3.3', '2012-04-06 00:00', '2012-04-06 00:00', '0'), 
('NULL', 'PKR', 'THA', 'ASC', '5577', '3.3', '2012-04-07 6:00', '2012-04-07 13:00', '1'), 
('NULL', 'PKR', 'THA', 'ASC', '5577', '3.3', '2012-04-08 00:00', '2012-04-08 00:00', '0'), 
('NULL', 'PKR', 'THA', 'ASC', '5577', '3.3', '2012-04-09 00:00', '2012-04-09 00:00', '0'), 
('NULL', 'PKR', 'THA', 'ASC', '5577', '3.3', '2012-04-10 00:00', '2012-04-10 00:00', '0'), 
('NULL', 'PKR', 'THA', 'ASC', '5577', '3.3', '2012-04-11 9:00', '2012-04-11 12:00', '1'), 
('NULL', 'PKR', 'THA', 'ASC', '5577', '3.3', '2012-04-12 6:00', '2012-04-12 13:00', '1'), 
('NULL', 'PKR', 'THA', 'ASC', '5577', '3.3', '2012-04-13 6:00', '2012-04-13 12:00', '1'), 
('NULL', 'PKR', 'THA', 'ASC', '5577', '3.3', '2012-04-14 7:00', '2012-04-14 10:00', '1'), 
('NULL', 'PKR', 'THA', 'ASC', '5577', '3.3', '2012-04-15 9:00', '2012-04-15 13:00', '1'), 
('NULL', 'PKR', 'THA', 'ASC', '5577', '3.3', '2012-04-16 9:00', '2012-04-16 12:00', '1'), 
('NULL', 'PKR', 'THA', 'ASC', '5577', '3.3', '2012-04-17 7:00', '2012-04-17 13:00', '1'), 
('NULL', 'PKR', 'THA', 'ASC', '5577', '3.3', '2012-04-18 7:00', '2012-04-18 13:00', '1'), 
('NULL', 'PKR', 'THA', 'ASC', '5577', '3.3', '2012-04-19 00:00', '2012-04-19 00:00', '0'), 
('NULL', 'PKR', 'THA', 'ASC', '5577', '3.3', '2012-04-20 7:00', '2012-04-20 13:00', '1'), 
('NULL', 'PKR', 'THA', 'ASC', '5577', '3.3', '2012-04-21 00:00', '2012-04-21 00:00', '0'), 
('NULL', 'PKR', 'THA', 'ASC', '5577', '3.3', '2012-04-22 00:00', '2012-04-22 00:00', '0'), 
('NULL', 'PKR', 'THA', 'ASC', '5577', '3.3', '2012-04-24 7:00', '2012-04-24 12:00', '1'), 
('NULL', 'PKR', 'THA', 'ASC', '5577', '3.3', '2012-04-25 7:00', '2012-04-25 12:00', '1'), 
('NULL', 'PKR', 'THA', 'ASC', '5577', '3.3', '2012-04-26 7:00', '2012-04-26 12:00', '1'), 
('NULL', 'PKR', 'THA', 'ASC', '5577', '3.3', '2012-04-27 8:00', '2012-04-27 12:00', '1'), 
('NULL', 'PKR', 'THA', 'ASC', '5577', '3.3', '2012-04-28 8:00', '2012-04-28 12:00', '1'), 
('NULL', 'PKR', 'THA', 'ASC', '5577', '3.3', '2012-04-29 8:00', '2012-04-29 12:00', '1'), 
('NULL', 'PKR', 'THA', 'ASC', '5577', '3.3', '2012-04-30 8:00', '2012-04-30 12:00', '1'), 
('NULL', 'PKR', 'THA', 'ASC', '5577', '3.3', '2012-05-01 00:00', '2012-05-01 00:00', '0'), 
('NULL', 'PKR', 'THA', 'ASC', '5577', '3.3', '2012-05-02 00:00', '2012-05-02 00:00', '0');
