DROP TABLE IF EXISTS web_no_keograms;
CREATE TABLE `web_no_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',
`end_date` datetime NOT NULL DEFAULT '0000-00-00',
`data_flag` tinyint(1) NOT NULL DEFAULT 1
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

INSERT INTO `web_no_keograms` VALUES 
(NULL, 'PKR', 'ARI', 'NFC', '6300', '40.7', '2011-09-26 10:00', '2011-09-26 14:00', 1), 
(NULL, 'PKR', 'ARI', 'NFC', '6300', '40.7', '2011-09-27 9:00', '2011-09-27 14:00', 1), 
(NULL, 'PKR', 'ARI', 'NFC', '6300', '40.7', '2011-09-28 5:00', '2011-09-28 14:00', 1), 
(NULL, 'PKR', 'ARI', 'NFC', '6300', '40.7', '2011-09-29 7:00', '2011-09-29 12:00', 1), 
(NULL, 'PKR', 'ARI', 'NFC', '6300', '40.7', '2011-10-01 8:00', '2011-10-01 13:00', 1), 
(NULL, 'PKR', 'ARI', 'NFC', '6300', '40.7', '2011-10-02 5:00', '2011-10-02 11:00', 1), 
(NULL, 'PKR', 'ARI', 'NFC', '6300', '40.7', '2011-10-04 6:00', '2011-10-04 14:00', 1), 
(NULL, 'PKR', 'ARI', 'NFC', '6300', '40.7', '2011-10-05 6:00', '2011-10-05 15:00', 1);

