('2015-05-16 07:28:44','C006'),('2015-05-16 07:54:25','V0812'),('2015-05-16 08:04:52','C106'),('2015-05-16 09:35:52','R21B01LK'),('2015-05-16 09:35:55','R21B02LK'),('2015-05-16 09:35:56','A2109'),('2015-05-16 09:35:57','R21B18LK'),('2015-05-16 09:35:58','R21B19LK'),('2015-05-16 09:35:59','R21B19LK'),('2015-05-16 09:36:00','R21B19LK'),('2015-05-16 09:36:01','R21B01LK'),('2015-05-16 09:36:05','R21B02LK'),('2015-05-16 09:36:06','A2109'),('2015-05-16 09:36:07','R21B03LK'),('2015-05-16 09:38:35','R21B06LK'),('2015-05-16 09:42:04','V0800'),('2015-05-16 10:29:20','C006'),('2015-05-16 10:31:30','C106'),('2015-05-16 11:27:09','C006'),('2015-05-16 11:38:02','C106'),('2015-05-16 12:04:28','C006'),('2015-05-16 13:22:14','C106'),('2015-05-16 13:22:44','C102'),('2015-05-16 13:37:54','C006'),('2015-05-16 14:14:12','C103'),('2015-05-16 14:19:17','C003'),('2015-05-16 14:21:59','C106'),('2015-05-16 14:37:14','C103'),('2015-05-16 14:42:42','C003'),('2015-05-16 15:17:37','C002'),('2015-05-16 15:27:16','C006'),('2015-05-16 15:36:55','C106'),('2015-05-16 16:33:23','C006'),('2015-05-16 16:49:41','C106'),('2015-05-16 17:10:11','C102'),('2015-05-16 17:14:57','C103'),('2015-05-16 17:22:35','C003'),('2015-05-16 17:27:36','C103'),('2015-05-16 17:31:36','C006'),('2015-05-16 17:32:55','C003'),('2015-05-16 17:52:08','C106'),('2015-05-16 18:18:06','C002'),('2015-05-16 20:06:29','C006'),('2015-05-16 20:07:23','C106'),('2015-05-16 20:07:38','A0603'),('2015-05-16 20:22:06','E01'),('2015-05-16 20:25:03','C006'),('2015-05-16 22:04:54','C106'),('2015-05-16 23:04:33','V0600'),('2015-05-16 23:21:51','C006'),('2015-05-16 23:25:32','C106'),('2015-05-16 23:33:20','C102'),('2015-05-16 23:33:42','C103'),('2015-05-16 23:38:55','C003'),('2015-05-16 23:43:23','O201'),('2015-05-16 23:45:05','O200'),('2015-05-16 23:48:06','C002'),('2015-05-16 23:54:29','V0801'),('2015-05-16 23:54:39','C006'),('2016-11-01 00:03:39','C006'),('2016-11-01 00:30:15','A0600'),('2016-11-01 00:30:18','C106'),('2016-11-01 00:45:53','C006'),('2016-11-01 03:00:06','E03'),('2016-11-01 05:05:07','C106'),('2016-11-01 05:27:39','C006'),('2016-11-01 05:53:06','R29M01SC'),('2016-11-01 06:23:06','E02'),('2016-11-01 06:58:12','O201'),('2016-11-01 06:58:13','O201'),('2016-11-01 07:51:55','C106'),('2016-11-01 07:52:51','V0601'),('2016-11-01 08:36:50','A0600'),('2016-11-01 09:49:38','O130'),('2016-11-01 09:49:42','O131'),('2016-11-01 09:49:47','O130'),('2016-11-01 09:53:09','C006'),('2016-11-01 10:33:06','C106'),('2016-11-01 10:48:27','C006'),('2016-11-01 10:59:20','C106'),('2016-11-01 11:23:19','C006'),('2016-11-01 11:28:41','C106'),('2016-11-01 11:45:40','C006'),('2016-11-01 11:57:42','C106'),('2016-11-01 12:13:02','C006'),('2016-11-01 13:25:19','C106'),('2016-11-01 14:13:33','C006'),('2016-11-01 15:53:06','C106'),('2016-11-01 16:21:06','O200'),('2016-11-01 18:04:06','E01'),('2016-11-01 18:08:50','V0601'),('2016-11-01 19:15:04','C102'),('2016-11-01 19:15:35','C103'),('2016-11-01 19:15:38','C109'),('2016-11-01 19:16:04','O161'),('2016-11-01 19:16:19','V0901'),('2016-11-01 19:20:39','C003'),('2016-11-01 20:55:06','V0602'),('2016-11-01 20:55:26','A0501'),('2016-11-01 21:19:42','A0900'),('2016-11-01 21:20:29','C103'),('2016-11-01 21:25:37','C003'),('2016-11-01 21:28:27','C009'),('2016-11-01 21:50:25','C002'),('2016-11-01 21:59:32','C006'),('2016-11-01 22:03:47','C106'),('2016-11-01 22:58:35','A0600'),('2016-11-01 23:25:22','C006'),('2016-11-01 23:30:19','C106'),('2016-11-01 23:57:57','V0500'),('2016-11-02 00:06:56','O201'),('2016-11-02 00:12:37','C006'),('2016-11-02 03:00:06','E03'),('2016-11-02 03:42:18','O160'),('2016-11-02 05:54:06','R29M01SC'),('2016-11-02 06:24:06','E02'),('2016-11-02 07:47:08','C106'),('2016-11-02 07:49:54','V0601'),('2016-11-02 08:03:22','O130'),('2016-11-02 08:28:39','O100'),('2016-11-02 08:31:05','O101'),('2016-11-02 08:36:15','V0600'),('2016-11-02 08:55:04','C006'),('2016-11-02 08:55:59','C106'),('2016-11-02 09:04:04','C102'),('2016-11-02 09:04:21','C101'),('2016-11-02 09:04:23','C110'),('2016-11-02 09:05:03','V0101'),('2016-11-02 09:22:56','O070'),('2016-11-02 09:23:35','O071'),('2016-11-02 09:23:58','O070'),('2016-11-02 09:28:55','C006'),('2016-11-02 09:29:44','C106'),('2016-11-02 09:39:42','O071'),('2016-11-02 09:44:45','C002'),('2016-11-02 09:45:04','O070'),('2016-11-02 09:45:54','C006'),('2016-11-02 09:50:16','O071'),('2016-11-02 09:52:44','O070'),('2016-11-02 09:55:04','O071'),('2016-11-02 10:01:58','A0100'),('2016-11-02 10:02:40','C102'),('2016-11-02 10:03:35','C106'),('2016-11-02 10:10:37','C001'),('2016-11-02 10:11:31','C010'),('2016-11-02 10:45:44','C006'),('2016-11-02 10:48:13','C002'),('2016-11-02 10:50:07','C106'),('2016-11-02 11:07:47','C006'),('2016-11-02 12:18:37','C106'),('2016-11-02 13:22:55','O070'),('2016-11-02 14:30:41','C006'),('2016-11-02 15:37:17','C106'),('2016-11-02 16:02:25','C006'),('2016-11-02 16:46:40','C106'),('2016-11-02 17:43:30','C006'),('2016-11-02 17:50:40','C106'),('2016-11-02 18:03:06','E01'),('2016-11-02 18:29:31','V0601'),('2016-11-02 19:50:21','C102'),('2016-11-02 19:50:49','C103'),('2016-11-02 19:50:53','C109'),('2016-11-02 19:52:34','O161'),('2016-11-02 19:52:56','V0201'),('2016-11-02 19:54:05','O160'),('2016-11-02 19:56:08','C003'),('2016-11-02 19:59:01','C009'),('2016-11-02 20:01:59','A0600'),('2016-11-02 20:02:18','V0602'),('2016-11-02 22:28:58','O200'),('2016-11-03 00:45:10','V0600'),('2016-11-03 00:46:42','A0200'),('2016-11-03 01:01:57','C006'),('2016-11-03 01:10:10','C002'),('2016-11-03 03:00:06','E03'),('2016-11-03 05:55:06','R29M01SC'),('2016-11-03 06:25:06','E02'),('2016-11-03 07:13:44','O201'),('2016-11-03 07:13:45','O201'),('2016-11-03 07:26:15','C106'),('2016-11-03 07:36:15','V0601'),('2016-11-03 08:38:07','V0600'),('2016-11-03 09:11:03','C006'),('2016-11-03 09:24:00','C106'),('2016-11-03 09:26:27','C102'),('2016-11-03 09:27:04','C101'),('2016-11-03 09:27:06','C110'),('2016-11-03 09:27:42','V0101'),('2016-11-03 09:41:37','C006'),('2016-11-03 09:45:08','O070'),('2016-11-03 09:50:30','C002'),('2016-11-03 10:00:04','O071'),('2016-11-03 10:05:22','O070'),('2016-11-03 10:06:00','O071'),('2016-11-03 10:07:15','O070'),('2016-11-03 10:10:48','O071'),('2016-11-03 10:11:26','V0100'),('2016-11-03 10:11:52','C102'),('2016-11-03 10:12:20','C106'),('2016-11-03 10:19:45','C001'),('2016-11-03 10:20:36','C010'),('2016-11-03 10:42:00','C006'),('2016-11-03 10:50:03','C002'),('2016-11-03 11:18:18','O130'),('2016-11-03 11:18:26','O131'),('2016-11-03 11:18:32','O130'),('2016-11-03 11:30:29','C106'),('2016-11-03 11:40:49','V0601'),('2016-11-03 12:10:53','V0600'),('2016-11-03 12:26:12','C006'),('2016-11-03 15:28:12','C106'),('2016-11-03 15:43:39','C006'),('2016-11-03 15:51:23','C106'),('2016-11-03 16:44:10','C006'),('2016-11-03 18:02:06','E01'),('2016-11-03 18:56:15','C106'),('2016-11-03 18:58:13','C102'),('2016-11-03 18:58:34','C103'),('2016-11-03 18:58:39','C109'),('2016-11-03 19:08:14','V0603'),('2016-11-03 19:08:27','C003'),('2016-11-03 19:08:28','C103'),('2016-11-03 19:15:35','C003'),('2016-11-03 19:18:17','O100'),('2016-11-03 19:18:36','C009'),('2016-11-03 19:20:43','O101'),('2016-11-03 19:27:07','V0600'),('2016-11-03 19:39:41','C103'),('2016-11-03 19:39:45','C109'),('2016-11-03 19:42:21','O181'),('2016-11-03 19:42:34','V0902'),('2016-11-03 19:44:48','C003'),('2016-11-03 19:51:52','O180'),('2016-11-03 20:16:35','C006'),('2016-11-03 20:28:38','C106'),('2016-11-03 20:36:51','A0601'),('2016-11-03 20:53:59','C002'),('2016-11-03 21:03:59','V0600'),('2016-11-03 21:05:38','O181'),('2016-11-03 21:05:39','O181'),('2016-11-03 21:10:09','O180'),('2016-11-03 21:44:29','V0602'),('2016-11-03 22:15:23','C102'),('2016-11-03 22:15:25','C103'),('2016-11-03 22:20:30','C003'),('2016-11-03 22:23:23','C009'),('2016-11-03 22:39:01','C002'),('2016-11-03 22:56:38','A0601'),('2016-11-03 23:20:32','C006'),('2016-11-03 23:44:18','C106'),('2016-11-03 23:44:22','A0600'),('2015-05-17 02:23:48','V0800'),('2015-05-17 03:00:06','E03'),('2015-05-17 04:00:06','R29M01SC'),('2015-05-17 04:30:06','E02'),('2015-05-17 07:12:24','O110'),('2015-05-17 07:12:25','O111'),('2015-05-17 08:59:36','V0803'),('2015-05-17 09:16:02','C106'),('2015-05-17 09:31:18','C006'),('2015-05-17 09:36:17','C106'),('2015-05-17 11:41:27','V0800'),('2015-05-17 11:41:28','A0800'),('2015-05-17 13:07:27','C102'),('2015-05-17 13:11:26','C103'),('2015-05-17 13:16:52','C003'),('2015-05-17 13:33:36','C006'),('2015-05-17 13:36:31','C106'),('2015-05-17 13:41:02','V0608'),('2015-05-17 13:58:28','O161'),('2015-05-17 13:58:45','A1000'),('2015-05-17 13:58:57','V0202'),('2015-05-17 13:59:19','V0201'),('2015-05-17 13:59:22','V0203'),('2015-05-17 14:05:04','C103'),('2015-05-17 14:05:06','C109'),('2015-05-17 14:05:42','O181'),('2015-05-17 14:05:53','V0902'),('2015-05-17 14:05:54','A0902'),('2015-05-17 14:08:39','O180'),('2015-05-17 14:10:10','C003'),('2015-05-17 14:31:28','V0600'),('2015-05-17 14:34:15','O181'),('2015-05-17 14:34:17','O181'),('2015-05-17 14:34:37','C103'),('2015-05-17 14:35:39','O160'),('2015-05-17 14:44:13','V0602'),('2015-05-17 14:45:22','C003'),('2015-05-17 14:49:40','C009'),('2015-05-17 15:17:24','O161'),('2015-05-17 16:34:30','C103'),('2015-05-17 16:34:33','C109'),('2015-05-17 16:39:36','C003'),('2015-05-17 16:45:28','C103'),('2015-05-17 16:50:33','C003'),('2015-05-17 16:56:06','C103'),('2015-05-17 16:57:17','O180'),('2015-05-17 17:01:11','O181'),('2015-05-17 17:01:13','O181'),('2015-05-17 17:02:48','A0900'),('2015-05-17 17:03:42','V0200'),('2015-05-17 17:05:22','O180'),('2015-05-17 17:08:07','C003'),('2015-05-17 17:11:00','C009'),('2015-05-17 17:15:06','V0601'),('2015-05-17 17:30:37','C002'),('2015-05-17 17:33:39','V0600'),('2015-05-17 20:23:06','E01'),('2015-05-17 21:19:36','V0803'),('2015-05-17 21:52:43','O201'),('2015-05-17 21:55:31','O200'),('2015-05-17 22:04:27','C006'),('2015-05-17 22:16:28','V0801'),('2015-05-17 22:50:56','O110'),('2015-05-17 22:51:39','O111'),('2015-05-17 23:56:44','A0800'),('2016-11-04 00:03:41','O070'),('2016-11-04 00:03:42','O071'),('2016-11-04 00:05:21','C006'),('2016-11-04 03:00:06','E03'),('2016-11-04 05:57:06','R29M01SC'),('2016-11-04 06:27:06','E02'),('2016-11-04 07:48:29','C106'),('2016-11-04 07:49:49','V0601'),('2016-11-04 08:02:53','V0600'),('2016-11-04 09:12:48','C102'),('2016-11-04 09:13:12','C101'),('2016-11-04 09:13:15','C110'),('2016-11-04 09:13:34','A0101'),('2016-11-04 09:30:06','O070'),('2016-11-04 09:30:53','O071'),('2016-11-04 09:31:28','O070'),('2016-11-04 09:32:52','O071'),('2016-11-04 09:34:50','O070'),('2016-11-04 09:36:44','O071'),('2016-11-04 09:38:41','O070'),('2016-11-04 09:49:53','O071'),('2016-11-04 09:53:33','V0100'),('2016-11-04 10:02:07','C001'),('2016-11-04 10:02:53','C010'),('2016-11-04 10:17:37','C002'),('2016-11-04 10:23:07','C102'),('2016-11-04 10:29:25','C002'),('2016-11-04 12:04:27','C102'),('2016-11-04 12:20:08','C103'),('2016-11-04 12:28:35','C006'),('2016-11-04 12:29:02','C109'),('2016-11-04 12:30:06','C003'),('2016-11-04 12:33:17','C103'),('2016-11-04 12:33:32','C116'),('2016-11-04 12:41:40','C016'),('2016-11-04 12:45:54','C101'),('2016-11-04 12:45:56','C110'),('2016-11-04 12:50:11','C003'),('2016-11-04 12:53:06','C009'),('2016-11-04 12:55:42','C106'),('2016-11-04 13:13:54','C001'),('2016-11-04 13:14:48','C010'),('2016-11-04 13:22:29','C006'),('2016-11-04 13:29:27','C002'),('2016-11-04 13:49:43','O200'),('2016-11-04 13:49:44','O201'),('2016-11-04 15:03:55','C106'),('2016-11-04 15:35:08','C006'),('2016-11-04 15:40:51','C106'),('2016-11-04 16:11:11','C006'),('2016-11-04 16:18:29','C106'),('2016-11-04 17:44:38','C006'),('2016-11-04 18:01:06','E01'),('2016-11-04 18:22:38','C106'),('2016-11-04 19:00:48','C006'),('2016-11-04 19:01:37','C106'),('2016-11-04 19:20:19','C006'),('2016-11-04 21:17:46','C106'),('2016-11-04 21:33:35','C006'),('2016-11-04 21:38:10','C106'),('2016-11-04 22:51:14','C006'),('2016-11-04 23:33:46','C106'),('2016-11-04 23:51:40','R20B04LK'),('2016-11-04 23:51:41','A2008'),('2016-11-04 23:51:43','R20B03LK'),('2016-11-04 23:51:45','R20B05LK'),('2016-11-04 23:51:47','A2000'),('2015-05-18 03:00:06','E03'),('2015-05-18 03:59:06','R29M01SC'),('2015-05-18 04:29:06','E02'),('2015-05-18 05:53:29','C106'),('2015-05-18 06:23:08','C006'),('2015-05-18 07:04:18','C106'),('2015-05-18 07:22:35','A0601'),('2015-05-18 07:43:11','O100'),('2015-05-18 08:03:00','O101'),('2015-05-18 08:03:09','V0600'),('2015-05-18 08:32:21','C102'),('2015-05-18 08:32:42','C101'),('2015-05-18 08:32:44','C110'),('2015-05-18 08:43:59','C010'),('2015-05-18 08:48:15','C001'),('2015-05-18 08:49:19','C002'),('2015-05-18 08:51:55','C006'),('2015-05-18 09:11:51','C106'),('2015-05-18 09:17:16','C102'),('2015-05-18 09:33:01','C002'),('2015-05-18 11:15:12','C006'),('2015-05-18 12:22:44','C106'),('2015-05-18 14:38:02','C006'),('2015-05-18 15:27:45','C106'),('2015-05-18 15:55:17','C006'),('2015-05-18 17:09:11','C106'),('2015-05-18 19:02:28','V0601'),('2015-05-18 19:02:50','V0600'),('2015-05-18 19:56:24','V0601'),('2015-05-18 20:24:06','E01'),('2015-05-18 20:32:59','C006'),('2015-05-18 20:36:40','C106'),('2015-05-18 20:37:29','C102'),('2015-05-18 20:38:02','C110'),('2015-05-18 20:43:24','C101'),('2015-05-18 20:44:52','O160'),('2015-05-18 20:48:44','C103'),('2015-05-18 20:48:47','C109'),('2015-05-18 20:54:06','C003'),('2015-05-18 20:57:00','C009'),('2015-05-18 21:01:25','V0600'),('2015-05-18 21:02:08','C010'),('2015-05-18 21:06:23','C001'),('2015-05-18 21:26:22','C101'),('2015-05-18 21:34:11','C110'),('2015-05-18 21:40:28','A0803'),('2015-05-18 21:41:14','V0808'),('2015-05-18 21:50:47','C006'),('2015-05-18 21:54:29','C010'),('2015-05-18 21:58:43','C001'),('2015-05-18 22:00:02','C002'),('2015-05-18 22:00:08','C102'),('2015-05-18 22:00:09','C106'),('2015-05-18 22:14:26','O201'),('2015-05-18 22:15:31','C006'),('2015-05-18 22:17:16','A0800'),('2015-05-18 22:18:27','C002'),('2015-05-18 22:22:02','O200'),('2015-05-18 22:36:56','A0801'),('2015-05-18 23:25:25','O110'),('2015-05-18 23:32:15','O111'),('2016-11-05 00:02:22','C006'),('2016-11-05 03:00:06','E03'),('2016-11-05 05:58:06','R29M01SC'),('2016-11-05 06:28:06','E02'),('2016-11-05 10:03:06','C106'),('2016-11-05 10:29:49','C006'),('2016-11-05 11:05:17','C106'),('2016-11-05 11:26:53','O200'),('2016-11-05 11:26:58','O201'),('2016-11-05 11:40:46','C006'),('2016-11-05 11:57:12','C106'),('2016-11-05 12:19:37','V0603'),('2016-11-05 13:03:04','A0600'),('2016-11-05 13:34:41','C006'),('2016-11-05 13:47:26','O200'),('2016-11-05 13:47:28','O201'),('2016-11-05 15:22:49','C106'),('2016-11-05 15:28:54','C102'),('2016-11-05 15:29:40','C103'),('2016-11-05 15:29:43','C109'),('2016-11-05 15:35:35','C003'),('2016-11-05 15:43:45','C006'),('2016-11-05 15:58:10','C002'),('2016-11-05 16:07:18','C102'),('2016-11-05 16:07:19','R02M02--'),('2016-11-05 16:08:00','C106'),('2016-11-05 16:12:25','C003'),('2016-11-05 16:15:20','C009'),('2016-11-05 17:18:13','C002'),('2016-11-05 17:51:46','V0603'),('2016-11-05 17:52:02','V0604'),('2016-11-05 17:52:24','V0600'),('2016-11-05 17:52:30','V0605'),('2016-11-05 17:52:33','V0600'),('2016-11-05 17:52:43','V0603'),('2016-11-05 17:52:45','V0600'),('2016-11-05 17:52:48','V0605'),('2016-11-05 18:00:06','E01'),('2016-11-05 18:30:14','V0600'),('2016-11-05 19:20:47','C102'),('2016-11-05 19:21:30','C103'),('2016-11-05 19:33:37','C003'),('2016-11-05 19:45:28','C103'),('2016-11-05 19:50:51','C003'),('2016-11-05 20:31:33','A0605'),('2016-11-05 20:54:49','C103'),('2016-11-05 21:07:09','C003'),('2016-11-05 21:11:39','C103'),('2016-11-05 21:18:57','C003'),('2016-11-05 21:45:52','C006'),('2016-11-05 21:52:49','C106'),('2016-11-05 21:53:29','C002'),('2016-11-05 21:56:08','C102'),('2016-11-05 21:56:22','C103'),('2016-11-05 21:59:04','V0601'),('2016-11-05 22:02:51','C003'),('2015-05-19 01:30:51','V0800'),('2015-05-19 03:00:06','E03'),('2015-05-19 03:58:06','R29M01SC'),('2015-05-19 04:28:06','E02'),('2015-05-19 06:49:12','C106'),('2015-05-19 07:04:45','V0601'),('2015-05-19 07:40:16','A0600'),('2015-05-19 09:05:53','C006'),('2015-05-19 09:21:18','C106'),('2015-05-19 09:44:52','C006'),('2015-05-19 11:34:30','V1106'),('2015-05-19 11:34:43','V1100'),('2015-05-19 11:34:57','V1103'),('2015-05-19 12:56:48','C106'),('2015-05-19 13:31:05','C006'),('2015-05-19 15:12:05','C106'),('2015-05-19 15:16:01','V1100'),('2015-05-19 16:05:36','C006'),('2015-05-19 16:24:17','C106'),('2015-05-19 16:44:42','C006'),('2015-05-19 17:10:11','C106'),('2015-05-19 17:15:48','C102'),('2015-05-19 17:16:06','C101'),('2015-05-19 17:25:06','C110'),('2015-05-19 17:58:16','C010'),('2015-05-19 18:02:21','C001'),('2015-05-19 18:04:34','C101'),('2015-05-19 18:04:42','C110'),('2015-05-19 18:15:42','C010'),('2015-05-19 18:19:44','C001'),('2015-05-19 18:50:49','V0603'),('2015-05-19 18:56:03','V0601'),('2015-05-19 19:33:53','V0600'),('2015-05-19 19:52:07','C002'),('2015-05-19 20:02:38','V0603'),('2015-05-19 20:19:34','C102'),('2015-05-19 20:19:48','C101'),('2015-05-19 20:25:06','E01'),('2015-05-19 20:46:31','C001'),('2015-05-19 21:45:48','V0803'),('2015-05-19 21:47:52','V0600'),('2015-05-19 21:52:16','V0603'),('2015-05-19 21:52:20','V0601'),('2015-05-19 21:54:47','O110'),('2015-05-19 21:56:43','O111'),('2015-05-19 22:01:20','V0600'),('2015-05-19 22:02:51','O110'),('2015-05-19 22:03:10','O111'),('2015-05-19 22:18:29','C006'),('2015-05-19 22:21:13','C002'),('2015-05-19 22:25:33','C106'),('2015-05-19 22:25:36','V0603'),('2015-05-19 22:25:37','A0603'),('2015-05-19 22:27:01','V0801'),('2015-05-19 22:40:55','C006'),('2015-05-19 22:43:47','C106'),('2015-05-19 22:46:11','O110'),('2015-05-19 22:47:27','O111'),('2015-05-19 22:54:48','A0600'),('2015-05-19 23:10:09','C006'),('2016-11-06 01:03:16','C002'),('2016-11-06 01:04:44','C006'),('2016-11-06 01:20:28','C106'),('2016-11-06 01:20:29','V0600'),('2016-11-06 01:36:53','C006'),('2016-11-06 02:45:21','O090'),('2016-11-06 02:45:22','O091'),('2016-11-06 03:00:06','E03'),('2016-11-06 04:59:06','R29M01SC'),('2016-11-06 05:29:06','E02'),('2016-11-06 08:42:47','C106'),('2016-11-06 08:57:04','V0505'),('2016-11-06 09:12:03','C006'),('2016-11-06 09:42:12','A0500'),('2016-11-06 09:45:10','C106'),('2016-11-06 10:09:24','C006'),('2016-11-06 10:21:19','C106'),('2016-11-06 12:08:50','C006'),('2016-11-06 13:05:46','C106'),('2016-11-06 13:29:04','V2514'),('2016-11-06 13:38:37','A0601'),('2016-11-06 13:39:25','A0600'),('2016-11-06 13:43:47','C102'),('2016-11-06 13:44:02','C103'),('2016-11-06 13:44:06','C109'),('2016-11-06 13:49:45','C003'),('2016-11-06 13:52:40','C009'),('2016-11-06 14:01:02','C006'),('2016-11-06 14:08:17','C002'),('2016-11-06 14:09:01','C106'),('2016-11-06 14:24:18','C006'),('2016-11-06 14:49:58','C106'),('2016-11-06 14:51:37','V0601'),('2016-11-06 15:54:47','A0501'),('2016-11-06 15:57:50','V0603'),('2016-11-06 16:17:59','V0500'),('2016-11-06 16:18:26','C102'),('2016-11-06 16:48:32','O130'),('2016-11-06 16:48:35','O131'),('2016-11-06 16:48:36','O130'),('2016-11-06 16:48:37','O131'),('2016-11-06 16:58:06','E01'),('2016-11-06 17:19:57','V0501'),('2016-11-06 19:04:59','V0600'),('2016-11-06 19:06:54','V0500'),('2016-11-06 19:06:55','A0500'),('2016-11-06 19:26:06','C006'),('2016-11-06 19:30:51','C002'),('2016-11-06 21:30:16','C106'),('2016-11-06 21:51:33','C102'),('2016-11-06 21:51:58','C103'),('2016-11-06 21:58:24','C003'),('2016-11-06 21:58:34','V0601'),('2016-11-06 21:59:23','V0600'),('2016-11-06 21:59:26','V0601'),('2016-11-06 22:01:30','V0602'),('2016-11-06 22:24:44','O200'),('2016-11-06 22:38:02','C006'),('2016-11-06 22:42:48','C002'),('2016-11-06 22:49:04','C106'),('2016-11-06 22:50:19','C102'),('2016-11-06 22:58:25','V0601'),('2016-11-06 23:43:03','C002'),('2015-05-20 00:33:49','O130'),('2015-05-20 00:33:50','O131'),('2015-05-20 03:00:06','E03'),('2015-05-20 03:57:06','R29M01SC'),('2015-05-20 04:06:23','V0800'),('2015-05-20 04:27:06','E02'),('2015-05-20 07:08:24','C106'),('2015-05-20 07:23:38','C006'),('2015-05-20 07:41:10','C106'),('2015-05-20 07:42:54','A0601'),('2015-05-20 08:06:33','A0600'),('2015-05-20 09:31:47','C102'),('2015-05-20 09:33:27','C101'),('2015-05-20 09:34:24','A0101'),('2015-05-20 09:51:14','C002'),('2015-05-20 09:53:37','C006'),('2015-05-20 10:04:38','A0100'),('2015-05-20 10:05:38','C102'),('2015-05-20 10:06:04','C106'),('2015-05-20 10:20:38','C001'),('2015-05-20 10:23:51','C006'),('2015-05-20 10:25:49','C002'),('2015-05-20 11:24:30','C106'),('2015-05-20 11:39:42','C006'),('2015-05-20 14:25:22','C106'),('2015-05-20 14:57:42','C006'),('2015-05-20 15:17:48','C106'),('2015-05-20 15:34:29','C006'),('2015-05-20 15:46:21','C106'),('2015-05-20 16:17:47','C006'),('2015-05-20 16:33:13','C106'),('2015-05-20 16:33:55','C102'),('2015-05-20 16:34:17','C101'),('2015-05-20 16:39:17','C002'),('2015-05-20 16:41:27','C110'),('2015-05-20 17:10:33','C102'),('2015-05-20 17:19:13','C010'),('2015-05-20 17:23:08','C001'),('2015-05-20 17:48:01','C002'),('2015-05-20 17:53:16','C006'),('2015-05-20 18:44:50','C106'),('2015-05-20 19:06:59','V0603'),('2015-05-20 19:07:42','V0600'),('2015-05-20 19:07:45','V0603'),('2015-05-20 19:11:34','C102'),('2015-05-20 19:12:23','C101'),('2015-05-20 19:26:57','V0601'),('2015-05-20 19:43:01','C001'),('2015-05-20 19:52:03','C002'),('2015-05-20 19:57:47','A0803'),('2015-05-20 20:03:57','V0802'),('2015-05-20 20:16:55','O110'),('2015-05-20 20:16:56','O111'),('2015-05-20 20:20:39','A0600'),('2015-05-20 20:26:06','E01'),('2015-05-20 20:35:58','C006'),('2015-05-20 21:10:38','V0801'),('2015-05-20 22:45:51','O110'),('2015-05-20 22:47:27','O111'),('2016-11-07 00:09:54','C006'),('2016-11-07 00:25:43','C106'),('2016-11-07 00:25:51','V0600'),('2016-11-07 00:41:51','C006'),('2016-11-07 03:00:06','E03'),('2016-11-07 05:00:06','R29M01SC'),('2016-11-07 05:30:06','E02'),('2016-11-07 07:47:38','C106'),('2016-11-07 07:49:46','V2500'),('2016-11-07 07:49:47','A2500'),('2016-11-07 08:24:50','V0601'),('2016-11-07 08:46:12','A0600'),('2016-11-07 10:28:45','C102'),('2016-11-07 10:29:38','C101'),('2016-11-07 10:29:40','C110'),('2016-11-07 10:30:03','V0101'),('2016-11-07 10:42:53','C006'),('2016-11-07 10:47:23','O070'),('2016-11-07 10:52:22','C002'),('2016-11-07 10:59:39','O071'),('2016-11-07 11:04:14','O070'),('2016-11-07 11:12:33','O071'),('2016-11-07 11:18:41','V0100'),('2016-11-07 11:18:42','A0100'),('2016-11-07 11:19:17','C102'),('2016-11-07 11:19:34','C103'),('2016-11-07 11:20:30','C106'),('2016-11-07 11:25:10','C003'),('2016-11-07 11:27:15','C001'),('2016-11-07 11:28:07','C010'),('2016-11-07 11:43:22','C002'),('2016-11-07 11:56:14','C102'),('2016-11-07 11:57:11','C103'),('2016-11-07 12:03:01','C003'),('2016-11-07 12:05:44','C006'),('2016-11-07 12:20:56','C002'),('2016-11-07 12:21:12','C106'),('2016-11-07 12:36:33','C006'),('2016-11-07 13:03:26','C106'),('2016-11-07 13:42:29','C006'),('2016-11-07 13:54:11','C106'),('2016-11-07 16:10:25','C006'),('2016-11-07 16:57:06','E01'),('2016-11-07 17:03:12','C106'),('2016-11-07 17:03:40','C102'),('2016-11-07 17:56:34','C103'),('2016-11-07 18:12:30','C003'),('2016-11-07 18:34:22','C006'),('2016-11-07 18:41:12','C002'),('2016-11-07 19:10:57','C106'),('2016-11-07 19:39:19','V0601'),('2016-11-07 22:02:56','V0600'),('2016-11-07 22:42:45','A0501'),('2016-11-07 22:50:44','V0602'),('2016-11-07 23:50:21','V0600'),('2015-05-21 00:00:20','C106'),('2015-05-21 00:24:30','V0800'),('2015-05-21 00:31:27','C006'),('2015-05-21 00:33:35','O110'),('2015-05-21 00:34:51','O111'),('2015-05-21 03:00:06','E03'),('2015-05-21 03:56:06','R29M01SC'),('2015-05-21 04:26:06','E02'),('2015-05-21 06:56:08','C106'),('2015-05-21 07:20:51','V0803'),('2015-05-21 07:30:29','C006'),('2015-05-21 07:37:07','V0801'),('2015-05-21 07:43:49','A0800'),('2015-05-21 07:53:29','C106'),('2015-05-21 11:51:01','V0601'),('2015-05-21 11:59:10','O100'),('2015-05-21 12:00:44','O101'),('2015-05-21 12:33:53','C006'),('2015-05-21 12:44:47','C106'),('2015-05-21 12:44:48','A0600'),('2015-05-21 13:00:39','C006'),('2015-05-21 14:15:07','C106'),('2015-05-21 15:20:07','C006'),('2015-05-21 15:28:57','C106'),('2015-05-21 15:45:23','C006'),('2015-05-21 15:47:52','C106'),('2015-05-21 16:11:19','C006'),('2015-05-21 16:21:39','C106'),('2015-05-21 20:04:22','V0603'),('2015-05-21 20:27:06','E01'),('2015-05-21 21:02:17','C102'),('2015-05-21 21:02:34','C101'),('2015-05-21 21:15:31','C001'),('2015-05-21 21:17:13','C006'),('2015-05-21 21:18:44','V0803'),('2015-05-21 21:21:03','C002'),('2015-05-21 21:28:59','C106'),('2015-05-21 21:29:05','V0600'),('2015-05-21 21:45:23','C006'),('2015-05-21 22:11:19','V0801'),('2015-05-21 23:45:46','C106'),('2016-11-08 00:11:07','C006'),('2016-11-08 01:50:36','A0500'),('2016-11-08 01:51:03','C106'),('2016-11-08 01:58:14','O201'),('2016-11-08 01:58:15','O201'),('2016-11-08 02:01:17','O200'),('2016-11-08 02:07:03','C006'),('2016-11-08 03:00:06','E03'),('2016-11-08 05:02:06','R29M01SC'),('2016-11-08 05:32:06','E02'),('2016-11-08 07:31:47','C106'),('2016-11-08 08:20:25','C006'),('2016-11-08 08:39:35','C106'),('2016-11-08 09:22:56','V0601'),('2016-11-08 09:27:07','V0600'),('2016-11-08 09:59:30','C006'),('2016-11-08 10:00:09','C106'),('2016-11-08 10:30:35','C102'),('2016-11-08 10:31:31','C101'),('2016-11-08 10:31:33','C110'),('2016-11-08 10:31:42','A0101'),('2016-11-08 10:36:30','C002'),('2016-11-08 10:45:04','C006'),('2016-11-08 10:47:45','O070'),('2016-11-08 11:03:33','O071'),('2016-11-08 11:08:57','O070'),('2016-11-08 11:10:41','O071'),('2016-11-08 11:10:50','C010'),('2016-11-08 11:13:10','O070'),('2016-11-08 11:13:30','O071'),('2016-11-08 11:13:55','V0100'),('2016-11-08 11:14:02','C110'),('2016-11-08 11:14:11','C102'),('2016-11-08 11:15:03','C106'),('2016-11-08 11:22:07','C001'),('2016-11-08 11:23:00','C010'),('2016-11-08 11:39:57','C006'),('2016-11-08 11:44:25','C002'),('2016-11-08 11:59:40','C106'),('2016-11-08 12:15:05','C006'),('2016-11-08 13:51:34','C106'),('2016-11-08 14:27:30','C006'),('2016-11-08 14:54:04','C106'),('2016-11-08 15:09:33','C006'),('2016-11-08 15:19:38','C106'),('2016-11-08 16:07:21','C006'),('2016-11-08 16:51:39','C106'),('2016-11-08 16:52:36','C102'),('2016-11-08 16:52:58','C103'),('2016-11-08 16:56:06','E01'),('2016-11-08 17:21:11','C109'),('2016-11-08 17:23:20','C006'),('2016-11-08 17:23:52','C101'),('2016-11-08 17:23:54','C110'),('2016-11-08 17:27:51','O031'),('2016-11-08 17:28:03','A1011'),('2016-11-08 17:28:44','C003'),('2016-11-08 17:31:40','C009'),('2016-11-08 17:31:41','O030'),('2016-11-08 17:35:01','C106'),('2016-11-08 17:35:52','V0601'),('2016-11-08 17:37:23','C001'),('2016-11-08 17:39:53','C101'),('2016-11-08 17:43:08','C103'),('2016-11-08 17:51:44','C003'),('2016-11-08 17:54:59','C001'),('2016-11-08 18:07:59','O031'),('2016-11-08 18:08:56','A0600'),('2016-11-08 18:13:10','O030'),('2016-11-08 18:19:29','C010'),('2016-11-08 18:19:31','A1000'),('2016-11-08 18:19:36','C110'),('2016-11-08 18:19:44','C101'),('2016-11-08 18:27:51','C001'),('2016-11-08 18:32:44','C010'),('2016-11-08 19:47:48','V0603'),('2016-11-08 20:10:36','A0600'),('2016-11-08 20:39:06','O090'),('2016-11-08 20:39:31','V0602'),('2016-11-08 21:00:23','O091'),('2016-11-08 21:03:24','O090'),('2016-11-08 21:13:06','O091'),('2016-11-08 21:14:18','O090'),('2016-11-08 21:21:55','O091'),('2016-11-08 21:22:10','O090'),('2016-11-08 21:25:28','O091'),('2016-11-08 21:26:34','O090'),('2016-11-08 21:27:56','O091'),('2016-11-08 21:28:30','O090'),('2016-11-08 21:30:16','O091'),('2016-11-08 23:01:45','C002'),('2016-11-08 23:38:29','A0501'),('2015-05-22 00:05:14','C006'),('2015-05-22 00:14:28','V0800'),('2015-05-22 03:00:06','E03'),('2015-05-22 03:55:06','R29M01SC'),('2015-05-22 04:25:06','E02'),('2015-05-22 07:01:12','C106'),('2015-05-22 08:34:58','O120'),('2015-05-22 08:34:59','O121'),('2015-05-22 08:47:40','C006'),('2015-05-22 08:57:23','C106'),('2015-05-22 09:23:00','C006'),('2015-05-22 09:24:50','C106'),('2015-05-22 09:40:23','C006'),('2015-05-22 09:41:38','C106'),('2015-05-22 10:00:13','C006'),('2015-05-22 10:00:37','C106'),('2015-05-22 10:43:26','C006'),('2015-05-22 10:54:06','C106'),('2015-05-22 12:50:07','C102'),('2015-05-22 12:55:22','C002'),('2015-05-22 13:10:27','C102'),('2015-05-22 13:23:50','C103'),('2015-05-22 13:25:29','C006'),('2015-05-22 13:29:37','C106'),('2015-05-22 13:30:04','C109'),('2015-05-22 13:39:52','C116'),('2015-05-22 13:44:13','C003'),('2015-05-22 13:45:04','C016'),('2015-05-22 13:47:07','C009'),('2015-05-22 13:48:34','C103'),('2015-05-22 13:50:26','C116'),('2015-05-22 13:51:45','C109'),('2015-05-22 13:54:07','C006'),('2015-05-22 13:55:40','C101'),('2015-05-22 13:56:37','C016'),('2015-05-22 14:00:01','C003'),('2015-05-22 14:00:28','C110'),('2015-05-22 14:02:56','C009'),('2015-05-22 14:14:33','C002'),('2015-05-22 14:29:51','C106'),('2015-05-22 14:39:04','C102'),('2015-05-22 14:47:55','C010'),('2015-05-22 14:51:29','C001'),('2015-05-22 15:01:51','C006'),('2015-05-22 15:04:09','C002'),('2015-05-22 15:22:37','C106'),('2015-05-22 15:38:31','C006'),('2015-05-22 16:33:28','C106'),('2015-05-22 17:04:06','V0603'),('2015-05-22 17:17:40','V0600'),('2015-05-22 17:28:41','C102'),('2015-05-22 17:29:05','C101'),('2015-05-22 17:38:19','C010'),('2015-05-22 17:41:55','C001'),('2015-05-22 17:43:29','C006'),('2015-05-22 17:45:55','C106'),('2015-05-22 17:47:11','C002'),('2015-05-22 18:50:45','C102'),('2015-05-22 18:52:25','C101'),('2015-05-22 19:05:26','C001'),('2015-05-22 19:47:26','C002'),('2015-05-22 20:28:06','E01'),('2015-05-22 20:32:02','C102'),('2015-05-22 20:32:36','C110'),('2015-05-22 20:32:45','C101'),('2015-05-22 20:42:30','C103'),('2015-05-22 20:50:14','C006'),('2015-05-22 20:50:56','C010'),('2015-05-22 20:51:57','O161'),('2015-05-22 20:52:07','V0203'),('2015-05-22 20:54:41','C001'),('2015-05-22 21:09:15','F166.78.107.36:A0411'),('2015-05-22 21:22:46','C106'),('2015-05-22 21:34:52','C003'),('2015-05-22 21:38:06','C006'),('2015-05-22 21:43:47','C106'),('2015-05-22 21:43:48','O160'),('2015-05-22 21:45:01','O161'),('2015-05-22 21:45:09','A0200'),('2015-05-22 22:08:03','C006'),('2015-05-22 22:10:15','C002'),('2015-05-22 22:12:29','C106'),('2015-05-22 22:31:28','C006'),('2015-05-22 23:52:21','O171'),('2015-05-22 23:53:42','C106'),('2016-11-09 01:59:19','V0500'),('2016-11-09 02:03:55','O201'),('2016-11-09 02:06:28','O200'),('2016-11-09 03:00:06','E03'),('2016-11-09 03:07:02','V0600'),('2016-11-09 03:22:21','C006'),('2016-11-09 05:03:06','R29M01SC'),('2016-11-09 05:33:06','E02'),('2016-11-09 07:57:59','C106'),('2016-11-09 07:58:26','V0601'),('2016-11-09 09:45:54','V0600'),('2016-11-09 10:06:45','C102'),('2016-11-09 10:07:36','C103'),('2016-11-09 10:09:08','C101'),('2016-11-09 10:09:10','C110'),('2016-11-09 10:09:46','A0101'),('2016-11-09 10:13:40','C003'),('2016-11-09 10:18:09','C006'),('2016-11-09 10:23:11','C002'),('2016-11-09 10:24:15','O070'),('2016-11-09 10:27:39','O071'),('2016-11-09 10:30:35','O070'),('2016-11-09 10:32:38','O071'),('2016-11-09 10:34:09','O070'),('2016-11-09 10:34:50','O071'),('2016-11-09 10:34:55','O070'),('2016-11-09 10:35:34','O071'),('2016-11-09 10:35:43','O070'),('2016-11-09 10:36:21','O071'),('2016-11-09 10:36:26','O070'),('2016-11-09 10:37:15','O071'),('2016-11-09 10:48:35','V0100'),('2016-11-09 10:48:44','C102'),('2016-11-09 10:56:41','C001'),('2016-11-09 11:01:28','C010'),('2016-11-09 11:02:59','C002'),('2016-11-09 11:04:57','C106'),('2016-11-09 11:21:24','C006'),('2016-11-09 11:47:09','C106'),('2016-11-09 11:47:11','V0601'),('2016-11-09 12:03:20','V0600'),('2016-11-09 12:03:21','A0600'),('2016-11-09 12:50:37','C006'),('2016-11-09 12:54:17','C106'),('2016-11-09 14:50:05','C006'),('2016-11-09 15:30:00','C106'),('2016-11-09 15:45:31','C006'),('2016-11-09 15:47:50','C106'),('2016-11-09 16:20:20','C006'),('2016-11-09 16:26:15','C106'),('2016-11-09 16:44:26','C006'),('2016-11-09 16:52:50','C106'),('2016-11-09 16:53:31','C102'),('2016-11-09 16:55:06','E01'),('2016-11-09 17:17:45','C006'),('2016-11-09 17:35:37','C103'),('2016-11-09 17:40:43','C003'),('2016-11-09 17:45:56','C106'),('2016-11-09 18:09:55','C103'),('2016-11-09 18:15:32','C003'),('2016-11-09 18:28:53','C006'),('2016-11-09 18:33:40','C106'),('2016-11-09 19:12:27','C002'),('2016-11-09 19:12:36','C102'),('2016-11-09 19:34:22','C002'),('2016-11-09 19:41:45','C006'),('2016-11-09 19:50:46','C102'),('2016-11-09 19:57:36','C003'),('2016-11-09 20:03:56','C103'),('2016-11-09 20:09:01','C003'),('2016-11-09 20:09:53','C106'),('2016-11-09 20:22:11','C002'),('2016-11-09 20:22:12','R02M01--'),('2016-11-09 20:46:26','C006'),('2016-11-09 22:22:49','C106'),('2016-11-09 22:36:12','V0602'),('2016-11-09 22:39:24','V0614'),('2016-11-09 22:42:43','V0602'),('2016-11-09 23:08:29','C102'),('2016-11-09 23:08:45','C103'),('2016-11-09 23:16:23','C003'),('2016-11-09 23:24:09','C006'),('2016-11-09 23:30:30','C002'),('2016-11-09 23:31:13','C106'),('2016-11-09 23:31:41','V0601'),('2015-05-23 00:14:08','C006'),('2015-05-23 00:31:58','C106'),('2015-05-23 00:33:12','A0400'),('2015-05-23 00:41:11','O170'),('2015-05-23 00:48:09','V0801'),('2015-05-23 00:54:47','C006'),('2015-05-23 02:24:00','O160'),('2015-05-23 02:42:09','V0800'),('2015-05-23 03:00:06','E03'),('2015-05-23 03:55:06','R29M01SC'),('2015-05-23 04:25:06','E02'),('2015-05-23 04:35:23','O120'),('2015-05-23 04:35:24','O110'),('2015-05-23 08:17:40','C106'),('2015-05-23 08:17:53','V0608'),('2015-05-23 09:30:15','V0600'),('2015-05-23 09:31:25','V0803'),('2015-05-23 10:33:06','V0808'),('2015-05-23 10:41:50','V0608'),('2015-05-23 10:41:51','A0615'),('2015-05-23 11:06:51','C006'),('2015-05-23 11:06:57','V0800'),('2015-05-23 11:07:20','C106'),('2015-05-23 12:00:50','V0600'),('2015-05-23 12:00:51','A0600'),('2015-05-23 12:41:01','C006'),('2015-05-23 13:07:17','C106'),('2015-05-23 13:09:54','A0603'),('2015-05-23 14:49:43','V0608'),('2015-05-23 14:57:49','V0503'),('2015-05-23 15:33:48','V0600'),('2015-05-23 16:25:28','V0500'),('2015-05-23 16:49:34','C006'),('2015-05-23 17:02:14','C106'),('2015-05-23 18:22:20','C006'),('2015-05-23 18:26:08','C106'),('2015-05-23 20:17:33','C006'),('2015-05-23 20:29:06','E01'),('2015-05-23 20:48:40','C106'),('2015-05-23 21:09:12','C006'),('2015-05-23 21:53:22','V0801'),('2015-05-23 22:18:36','V0800'),('2015-05-23 22:19:40','C106'),('2015-05-23 22:20:04','C102'),('2015-05-23 22:20:20','C103'),('2015-05-23 22:24:08','V0601'),('2015-05-23 22:25:35','C003'),('2015-05-23 22:37:55','C002'),('2015-05-23 23:15:08','V0600'),('2015-05-23 23:18:52','O201'),('2015-05-23 23:23:30','O200'),('2015-05-23 23:31:33','C006'),('2016-11-10 00:05:36','C006'),('2016-11-10 00:13:20','V0600'),('2016-11-10 00:13:23','C106'),('2016-11-10 00:29:03','C006'),('2016-11-10 03:00:06','E03'),('2016-11-10 05:04:06','R29M01SC'),('2016-11-10 05:34:06','E02'),('2016-11-10 07:35:41','C106'),('2016-11-10 07:51:09','C006'),('2016-11-10 08:14:50','C106'),('2016-11-10 10:39:20','C102'),('2016-11-10 10:39:38','C101'),('2016-11-10 10:39:39','C110'),('2016-11-10 10:41:12','V0101'),('2016-11-10 10:52:18','C006'),('2016-11-10 10:53:45','C010'),('2016-11-10 10:55:50','O070'),('2016-11-10 10:57:33','C002'),('2016-11-10 10:57:50','O071'),('2016-11-10 11:00:24','O070'),('2016-11-10 11:00:25','O071'),('2016-11-10 11:40:59','C110'),('2016-11-10 11:41:02','V0100'),('2016-11-10 11:41:12','C102'),('2016-11-10 11:41:44','C106'),('2016-11-10 11:49:09','C001'),('2016-11-10 11:53:44','C010'),('2016-11-10 11:57:20','C006'),('2016-11-10 12:00:37','C002'),('2016-11-10 13:10:24','C106'),('2016-11-10 13:12:16','V0601'),('2016-11-10 13:35:27','V0600'),('2016-11-10 13:50:52','C006'),('2016-11-10 13:54:35','C106'),('2016-11-10 14:10:45','C006'),('2016-11-10 15:12:25','C106'),('2016-11-10 15:59:08','C006'),('2016-11-10 16:49:32','C106'),('2016-11-10 16:54:06','E01'),('2016-11-10 18:23:58','C006'),('2016-11-10 18:33:27','C106'),('2016-11-10 18:50:12','C006'),('2016-11-10 18:52:43','C106'),('2016-11-10 19:23:44','C006'),('2016-11-10 20:09:51','C106'),('2016-11-10 20:11:46','V0603'),('2016-11-10 20:23:20','V0600'),('2016-11-10 20:23:21','A0600'),('2016-11-10 20:40:07','V0601'),('2016-11-10 21:02:08','V0600'),('2016-11-10 22:08:13','A0501'),('2016-11-10 23:13:05','C006'),('2015-05-24 00:04:17','C106'),('2015-05-24 00:14:52','O201'),('2015-05-24 00:17:27','O200'),('2015-05-24 00:21:21','O201'),('2015-05-24 00:21:31','V0801'),('2015-05-24 00:22:40','C006'),('2015-05-24 00:24:15','O200'),('2015-05-24 01:55:51','O201'),('2015-05-24 01:55:52','O201'),('2015-05-24 01:56:19','A0800'),('2015-05-24 01:58:28','O200'),('2015-05-24 03:00:06','E03'),('2015-05-24 03:54:06','R29M01SC'),('2015-05-24 04:24:06','E02'),('2015-05-24 07:35:23','A0503'),('2015-05-24 07:43:21','V0508'),('2015-05-24 08:45:16','V0801'),('2015-05-24 08:53:20','V0503'),('2015-05-24 09:03:09','C106'),('2015-05-24 09:49:42','A0800'),('2015-05-24 10:23:34','V0500'),('2015-05-24 10:42:11','C006'),('2015-05-24 11:14:53','C106'),('2015-05-24 11:51:37','C006'),('2015-05-24 13:09:17','C106'),('2015-05-24 13:25:44','C006'),('2015-05-24 13:35:03','C106'),('2015-05-24 13:41:23','V0801'),('2015-05-24 13:51:32','C102'),('2015-05-24 13:52:22','C103'),('2015-05-24 13:52:25','C109'),('2015-05-24 13:54:21','R01B03LK'),('2015-05-24 13:54:23','R01B19LK'),('2015-05-24 13:54:24','R01B19LK'),('2015-05-24 13:54:25','R01B19LK'),('2015-05-24 13:54:26','R01B19LK'),('2015-05-24 13:54:27','R01B19LK'),('2015-05-24 13:54:29','C101'),('2015-05-24 13:55:15','A0102'),('2015-05-24 13:57:34','R01B03LK'),('2015-05-24 13:58:11','C003'),('2015-05-24 14:01:06','C009'),('2015-05-24 14:06:42','C006'),('2015-05-24 14:10:39','C002'),('2015-05-24 14:20:15','C106'),('2015-05-24 14:36:36','C006'),('2015-05-24 14:50:33','V0100'),('2015-05-24 14:51:04','C102'),('2015-05-24 14:51:33','V0800'),('2015-05-24 14:51:45','C106'),('2015-05-24 15:03:04','C001'),('2015-05-24 15:11:20','C002'),('2015-05-24 15:31:23','C006'),('2015-05-24 16:10:15','C106'),('2015-05-24 16:10:35','C102'),('2015-05-24 16:10:50','C103'),('2015-05-24 16:10:53','C109'),('2015-05-24 16:11:10','O181'),('2015-05-24 16:11:12','O181'),('2015-05-24 16:11:23','V0912'),('2015-05-24 16:12:02','V0902'),('2015-05-24 16:12:06','A0920'),('2015-05-24 16:12:14','V0908'),('2015-05-24 16:15:55','C003'),('2015-05-24 16:16:37','O180'),('2015-05-24 16:28:03','C002'),('2015-05-24 16:28:35','V0603'),('2015-05-24 16:54:42','C006'),('2015-05-24 17:01:44','C106'),('2015-05-24 17:17:47','C006'),('2015-05-24 17:22:17','O181'),('2015-05-24 17:22:19','O181'),('2015-05-24 18:02:51','C106'),('2015-05-24 18:04:03','C102'),('2015-05-24 18:04:22','C103'),('2015-05-24 18:10:38','C003'),('2015-05-24 18:21:58','C006'),('2015-05-24 18:22:48','C002'),('2015-05-24 18:25:32','A0900'),('2015-05-24 18:26:17','V0912'),('2015-05-24 18:26:32','V0908'),('2015-05-24 18:26:36','V0912'),('2015-05-24 18:27:22','V0908'),('2015-05-24 18:27:25','V0912'),('2015-05-24 18:27:33','V0908'),('2015-05-24 18:27:39','V0912'),('2015-05-24 18:27:58','V0908'),('2015-05-24 18:28:04','V0912'),('2015-05-24 18:30:16','V0908'),('2015-05-24 18:30:22','V0912'),('2015-05-24 18:31:02','V0908'),('2015-05-24 18:31:05','V0912'),('2015-05-24 18:31:06','A0920'),('2015-05-24 18:31:19','A0900'),('2015-05-24 18:31:33','C102'),('2015-05-24 18:31:34','C103'),('2015-05-24 18:31:58','C106'),('2015-05-24 18:32:03','A0600'),('2015-05-24 18:33:52','O180'),('2015-05-24 18:36:40','C003'),('2015-05-24 18:39:34','C009'),('2015-05-24 18:49:30','C006'),('2015-05-24 18:50:36','C002'),('2015-05-24 20:30:06','E01'),('2015-05-24 20:44:55','C106'),('2015-05-24 21:48:59','R27B01LK'),('2015-05-24 21:49:00','V1302'),('2015-05-24 21:49:01','R27B06LK'),('2015-05-24 21:49:02','R27B05LK'),('2015-05-24 21:49:03','R27B04LK'),('2015-05-24 21:49:04','R27B03LK'),('2015-05-24 21:49:05','R27B02LK'),('2015-05-24 21:49:24','R27B06LK'),('2015-05-24 21:49:25','A1300'),('2015-05-24 21:56:19','O140'),('2015-05-24 21:56:20','O141'),('2015-05-24 22:04:11','C006'),('2015-05-24 22:08:33','C106'),('2015-05-24 22:14:56','V0801'),('2015-05-24 22:39:15','C006'),('2016-11-11 00:07:49','C106'),('2016-11-11 00:08:47','V0500'),('2016-11-11 00:24:55','C006'),('2016-11-11 03:00:06','E03'),('2016-11-11 05:05:06','R29M01SC'),('2016-11-11 05:35:06','E02'),('2016-11-11 08:04:06','C106'),('2016-11-11 08:22:45','O201'),('2016-11-11 08:25:23','O200'),('2016-11-11 08:36:39','C006'),('2016-11-11 08:55:39','C106'),('2016-11-11 10:00:55','C102'),('2016-11-11 10:01:09','C101'),('2016-11-11 10:01:10','C110'),('2016-11-11 10:01:38','V0101'),('2016-11-11 10:15:56','O070'),('2016-11-11 10:16:37','C006'),('2016-11-11 10:17:35','C010'),('2016-11-11 10:18:31','O071'),('2016-11-11 10:18:57','C002'),('2016-11-11 10:21:14','O070'),('2016-11-11 10:34:13','O071'),('2016-11-11 10:37:22','V0100'),('2016-11-11 10:37:51','C102'),('2016-11-11 10:39:24','C106'),('2016-11-11 10:45:48','C001'),('2016-11-11 10:53:20','A0601'),('2016-11-11 10:57:30','C002'),('2016-11-11 13:01:11','A0600'),('2016-11-11 13:33:08','C006'),('2016-11-11 13:36:29','C106'),('2016-11-11 13:58:06','C102'),('2016-11-11 14:03:55','C002'),('2016-11-11 15:36:48','C102'),('2016-11-11 15:50:17','C103'),('2016-11-11 15:51:22','C006'),('2016-11-11 16:00:44','C109'),('2016-11-11 16:02:04','C003'),('2016-11-11 16:04:32','C103'),('2016-11-11 16:07:53','C116'),('2016-11-11 16:12:27','C003'),('2016-11-11 16:12:28','C103'),('2016-11-11 16:13:01','C016'),('2016-11-11 16:14:57','C106'),('2016-11-11 16:19:57','C101'),('2016-11-11 16:20:00','C110'),('2016-11-11 16:24:41','C003'),('2016-11-11 16:27:36','C009'),('2016-11-11 16:42:09','C006'),('2016-11-11 16:53:06','E01'),('2016-11-11 16:58:30','C106'),('2016-11-11 16:59:28','C001'),('2016-11-11 17:03:51','C010'),('2016-11-11 17:04:23','V0603'),('2016-11-11 17:51:26','A0600'),('2016-11-11 18:20:05','C006'),('2016-11-11 18:21:15','C002'),('2016-11-11 18:58:41','O100'),('2016-11-11 19:38:45','C102'),('2016-11-11 19:39:05','C103'),('2016-11-11 19:39:08','C109'),('2016-11-11 19:42:20','C106'),('2016-11-11 19:44:09','C003'),('2016-11-11 19:48:16','C103'),('2016-11-11 19:48:53','O101'),('2016-11-11 19:53:21','C003'),('2016-11-11 19:56:16','C009'),('2016-11-11 20:15:35','C103'),('2016-11-11 20:15:39','C109'),('2016-11-11 20:19:16','O181'),('2016-11-11 20:19:17','O181'),('2016-11-11 20:19:18','O181'),('2016-11-11 20:19:20','O181'),('2016-11-11 20:19:38','V0902'),('2016-11-11 20:23:42','C003'),('2016-11-11 20:26:19','O180'),('2016-11-11 20:38:34','R27B04LK'),('2016-11-11 20:39:06','R27B05LK'),('2016-11-11 20:39:14','R27B03LK'),('2016-11-11 20:48:50','C006'),('2016-11-11 20:49:43','R27B06LK'),('2016-11-11 20:51:24','C002'),('2016-11-11 20:52:44','C106'),('2016-11-11 21:27:39','O100'),('2016-11-11 21:27:40','O101'),('2016-11-11 21:30:28','C006'),('2016-11-11 21:47:04','O181'),('2016-11-11 21:47:05','O181'),('2016-11-11 23:31:13','I18R09M01--'),('2016-11-11 23:31:25','I18R09M03--'),('2016-11-11 23:36:05','O180'),('2016-11-11 23:37:58','C106'),('2016-11-11 23:48:58','C102'),('2016-11-11 23:56:18','C003'),('2016-11-11 23:59:14','C009'),('2015-05-25 03:00:06','E03'),('2015-05-25 03:53:06','R29M01SC'),('2015-05-25 04:12:29','V0800'),('2015-05-25 04:23:06','E02'),('2015-05-25 07:48:17','V0808'),('2015-05-25 08:26:29','O201'),('2015-05-25 08:27:50','C106'),('2015-05-25 08:31:23','O200'),('2015-05-25 09:25:43','V0800'),('2015-05-25 10:00:43','C102'),('2015-05-25 10:01:06','C116'),('2015-05-25 10:06:59','C103'),('2015-05-25 10:12:05','C003'),('2015-05-25 10:12:28','C016'),('2015-05-25 10:24:26','C002'),('2015-05-25 10:35:21','C006'),('2015-05-25 10:54:43','C106'),('2015-05-25 11:01:53','C102'),('2015-05-25 11:03:12','C101'),('2015-05-25 11:04:16','V0101'),('2015-05-25 11:20:01','C002'),('2015-05-25 11:37:28','C102'),('2015-05-25 11:45:56','C116'),('2015-05-25 11:48:55','C103'),('2015-05-25 11:54:01','C003'),('2015-05-25 12:02:32','C016'),('2015-05-25 12:06:24','C116'),('2015-05-25 12:11:36','C103'),('2015-05-25 12:11:39','C109'),('2015-05-25 12:18:30','C016'),('2015-05-25 12:21:32','C003'),('2015-05-25 12:23:07','C103'),('2015-05-25 12:28:12','C003'),('2015-05-25 12:31:05','C009'),('2015-05-25 12:46:10','V0100'),('2015-05-25 12:46:50','C116'),('2015-05-25 12:58:37','C001'),('2015-05-25 13:13:24','C103'),('2015-05-25 13:20:25','C003'),('2015-05-25 13:26:50','C016'),('2015-05-25 14:23:18','V0603'),('2015-05-25 14:40:03','C002'),('2015-05-25 14:43:06','O100'),('2015-05-25 14:43:07','O101'),('2015-05-25 14:50:35','V0502'),('2015-05-25 14:51:34','V0500'),('2015-05-25 15:05:40','A0600'),('2015-05-25 15:17:14','V0815'),('2015-05-25 15:17:15','A0819'),('2015-05-25 15:18:42','V0800'),('2015-05-25 15:40:05','C006'),('2015-05-25 16:47:18','C106'),('2015-05-25 17:17:33','C006'),('2015-05-25 17:41:16','C106'),('2015-05-25 18:09:29','C006'),('2015-05-25 18:12:57','C106'),('2015-05-25 18:28:11','C006'),('2015-05-25 18:53:00','C106'),('2015-05-25 19:32:28','C006'),('2015-05-25 19:43:43','C106'),('2015-05-25 19:58:23','V0603'),('2015-05-25 20:31:06','E01'),('2015-05-25 20:42:14','V0803'),('2015-05-25 20:45:07','V0601'),('2015-05-25 20:57:45','V0600'),('2015-05-25 21:22:31','C006'),('2015-05-25 21:59:45','C106'),('2015-05-25 22:15:59','C006'),('2015-05-25 22:49:09','V0801'),('2016-11-12 00:09:05','C002'),('2016-11-12 00:21:02','A0601'),('2016-11-12 01:43:55','C006'),('2016-11-12 02:25:17','V0600'),('2016-11-12 02:25:19','C106'),('2016-11-12 02:40:59','C006'),('2016-11-12 03:00:06','E03'),('2016-11-12 05:07:06','R29M01SC'),('2016-11-12 05:37:06','E02'),('2016-11-12 08:17:55','O130'),('2016-11-12 08:17:59','O131'),('2016-11-12 08:18:04','O130'),('2016-11-12 08:32:10','C106'),('2016-11-12 08:34:04','O130'),('2016-11-12 08:34:09','O131'),('2016-11-12 08:34:39','O130'),('2016-11-12 08:34:44','O131'),('2016-11-12 08:34:47','O130'),('2016-11-12 08:41:35','O130'),('2016-11-12 08:41:36','O131'),('2016-11-12 08:41:39','O130'),('2016-11-12 08:43:46','O130'),('2016-11-12 09:02:36','O131'),('2016-11-12 09:02:37','O130'),('2016-11-12 09:30:39','C102'),('2016-11-12 09:30:55','C101'),('2016-11-12 09:30:57','C110'),('2016-11-12 09:31:16','V0101'),('2016-11-12 09:45:17','O070'),('2016-11-12 09:48:32','C002'),('2016-11-12 09:57:22','O071'),('2016-11-12 10:01:36','O070'),('2016-11-12 10:03:10','O071'),('2016-11-12 10:04:06','O070'),('2016-11-12 10:06:37','O071'),('2016-11-12 10:06:44','V0100'),('2016-11-12 10:06:51','C102'),('2016-11-12 10:15:19','C001'),('2016-11-12 10:19:34','C010'),('2016-11-12 10:25:06','C002'),('2016-11-12 10:30:27','C006'),('2016-11-12 11:05:46','C106'),('2016-11-12 11:36:11','C006'),('2016-11-12 12:05:14','C106'),('2016-11-12 12:14:53','C102'),('2016-11-12 12:15:06','C101'),('2016-11-12 12:15:08','C110'),('2016-11-12 12:15:29','O031'),('2016-11-12 12:15:43','A1011'),('2016-11-12 12:19:55','O030'),('2016-11-12 12:28:01','C001'),('2016-11-12 12:32:16','C010'),('2016-11-12 12:32:17','A1000'),('2016-11-12 12:44:54','C002'),('2016-11-12 12:45:33','C006'),('2016-11-12 13:02:47','C106'),('2016-11-12 13:13:20','C102'),('2016-11-12 13:14:16','O140'),('2016-11-12 13:14:24','O020'),('2016-11-12 13:15:08','O051'),('2016-11-12 13:15:09','O061'),('2016-11-12 13:15:22','O021'),('2016-11-12 13:15:23','O091'),('2016-11-12 13:15:24','O090'),('2016-11-12 13:15:25','O041'),('2016-11-12 13:15:38','O141'),('2016-11-12 13:15:39','O101'),('2016-11-12 13:15:40','O100'),('2016-11-12 13:15:41','O101'),('2016-11-12 13:15:42','O070'),('2016-11-12 13:15:47','O130'),('2016-11-12 13:26:01','C103'),('2016-11-12 13:33:14','C003'),('2016-11-12 13:47:37','C103'),('2016-11-12 13:52:42','C003'),('2016-11-12 14:41:26','C002'),('2016-11-12 15:57:32','C102'),('2016-11-12 15:57:48','C101'),('2016-11-12 15:57:50','C110'),('2016-11-12 15:58:23','O031'),('2016-11-12 15:58:36','A1011'),('2016-11-12 16:01:22','O030'),('2016-11-12 16:03:38','O031'),('2016-11-12 16:05:53','C001'),('2016-11-12 16:06:15','O030'),('2016-11-12 16:08:57','O031'),('2016-11-12 16:09:06','C101'),('2016-11-12 16:17:12','C001'),('2016-11-12 16:21:24','C010'),('2016-11-12 16:21:26','A1000'),('2016-11-12 16:27:51','C002'),('2016-11-12 16:31:32','C006'),('2016-11-12 16:52:06','E01'),('2016-11-12 17:28:21','O140'),('2016-11-12 17:29:39','O141'),('2016-11-12 18:32:15','O030'),('2016-11-12 18:32:16','O031'),('2016-11-12 19:06:14','C106'),('2016-11-12 19:43:24','O030'),('2016-11-12 19:43:30','O031'),('2016-11-12 19:52:14','C006'),('2016-11-12 19:57:00','C106'),('2016-11-12 20:41:28','C102'),('2016-11-12 20:42:02','C101'),('2016-11-12 20:42:13','A1011'),('2016-11-12 20:44:58','O030'),('2016-11-12 20:47:32','C103'),('2016-11-12 20:55:14','C001'),('2016-11-12 20:59:22','C010'),('2016-11-12 20:59:23','A1000'),('2016-11-12 21:02:03','C003'),('2016-11-12 21:04:47','C103'),('2016-11-12 21:09:55','C003'),('2016-11-12 21:24:23','C002'),('2016-11-12 22:10:09','C006'),('2016-11-12 22:13:12','C106'),('2016-11-12 22:28:29','C102'),('2016-11-12 22:28:44','C103'),('2016-11-12 22:34:39','C003'),('2016-11-12 23:12:28','C002'),('2016-11-12 23:52:36','O201'),('2016-11-12 23:52:37','O201'),('2016-11-12 23:53:23','C006'),('2016-11-12 23:55:15','O200'),('2016-11-12 23:56:57','C106'),('2015-05-26 00:44:07','V0800'),('2015-05-26 03:00:06','E03'),('2015-05-26 03:53:06','R29M01SC'),('2015-05-26 04:23:06','E02'),('2015-05-26 07:38:40','C106'),('2015-05-26 09:02:10','C006'),('2015-05-26 09:05:41','C106'),('2015-05-26 10:02:05','C102'),('2015-05-26 10:02:29','C103'),('2015-05-26 10:02:31','C109'),('2015-05-26 10:02:59','C101'),('2015-05-26 10:03:12','V0101'),('2015-05-26 10:07:48','C003'),('2015-05-26 10:10:41','C009'),('2015-05-26 10:19:39','C002'),('2015-05-26 10:40:02','V0100'),('2015-05-26 10:40:25','C102'),('2015-05-26 10:45:13','C006'),('2015-05-26 10:52:09','C001'),('2015-05-26 10:57:17','C106'),('2015-05-26 12:01:56','C002'),('2015-05-26 13:00:57','A1103'),('2015-05-26 13:09:58','C006'),('2015-05-26 15:09:16','V1100'),('2015-05-26 15:10:59','C106'),('2015-05-26 15:24:52','V0603'),('2015-05-26 15:45:27','V0600'),('2015-05-26 16:32:02','V0801'),('2015-05-26 16:32:43','V0800'),('2015-05-26 16:32:51','A0801'),('2015-05-26 16:33:22','V0800'),('2015-05-26 18:09:56','V0602'),('2015-05-26 18:11:43','V0503'),('2015-05-26 19:07:53','C102'),('2015-05-26 19:08:39','C116'),('2015-05-26 19:09:20','C103'),('2015-05-26 19:15:20','C003'),('2015-05-26 19:25:23','C006'),('2015-05-26 19:27:49','C103'),('2015-05-26 19:28:34','C106'),('2015-05-26 19:33:01','C003'),('2015-05-26 19:52:13','C016'),('2015-05-26 20:24:53','A0500'),('2015-05-26 20:25:14','C002'),('2015-05-26 20:25:24','C102'),('2015-05-26 20:27:35','V0808'),('2015-05-26 20:31:06','E01'),('2015-05-26 20:46:13','C002'),('2015-05-26 20:59:39','C006'),('2015-05-26 20:59:44','C106'),('2015-05-26 21:12:07','V0803'),('2015-05-26 21:35:57','C102'),('2015-05-26 21:36:49','C101'),('2015-05-26 21:44:44','C110'),('2015-05-26 21:46:52','V0600'),('2015-05-26 22:05:56','C006'),('2015-05-26 22:06:46','C002'),('2015-05-26 22:17:45','C102'),('2015-05-26 22:20:11','C106'),('2015-05-26 22:26:27','C010'),('2015-05-26 22:29:22','C001'),('2015-05-26 22:38:35','C002'),('2015-05-26 22:39:37','C006'),('2016-11-13 00:09:47','O201'),('2016-11-13 00:12:33','O200'),('2016-11-13 00:52:45','C006'),('2016-11-13 03:00:06','E03'),('2016-11-13 05:08:06','R29M01SC'),('2016-11-13 05:38:06','E02'),('2016-11-13 08:13:01','C106'),('2016-11-13 09:10:45','C006'),('2016-11-13 12:30:16','C106'),('2016-11-13 12:52:04','C006'),('2016-11-13 13:01:58','C106'),('2016-11-13 13:10:41','V0603'),('2016-11-13 13:56:10','V0600'),('2016-11-13 14:28:10','V0603'),('2016-11-13 15:46:59','C006'),('2016-11-13 16:44:03','C106'),('2016-11-13 16:51:22','A0600'),('2016-11-13 16:52:06','E01'),('2016-11-13 16:49:23','C006'),('2016-11-13 16:49:34','C106'),('2016-11-13 17:13:17','C006'),('2016-11-13 18:26:59','C106'),('2016-11-13 18:53:48','C006'),('2016-11-13 20:26:58','C106'),('2016-11-13 20:48:37','C006'),('2016-11-13 21:03:43','C106'),('2016-11-13 21:09:57','V0602'),('2016-11-13 21:34:20','V0601'),('2016-11-13 21:34:48','V0600'),('2016-11-13 21:47:12','A0501'),('2016-11-13 22:39:50','C006'),('2015-05-27 02:31:27','O110'),('2015-05-27 02:33:52','O111'),('2015-05-27 03:00:06','E03'),('2015-05-27 03:03:00','V0800'),('2015-05-27 03:52:06','R29M01SC'),('2015-05-27 04:22:06','E02'),('2015-05-27 07:02:58','V0808'),('2015-05-27 07:34:09','V0800'),('2015-05-27 07:37:01','C106'),('2015-05-27 09:18:43','C102'),('2015-05-27 09:46:21','C006'),('2015-05-27 09:51:16','C002'),('2015-05-27 09:53:58','C106'),('2015-05-27 10:33:11','C006'),('2015-05-27 11:14:33','C106'),('2015-05-27 11:45:30','C006'),('2015-05-27 11:53:05','C106'),('2015-05-27 12:10:59','C006'),('2015-05-27 12:51:47','C106'),('2015-05-27 13:07:00','C006'),('2015-05-27 13:30:05','C106'),('2015-05-27 13:51:46','C006'),('2015-05-27 13:54:31','C106'),('2015-05-27 15:05:27','C006'),('2015-05-27 15:09:54','C106'),('2015-05-27 15:25:08','C006'),('2015-05-27 15:58:36','C106'),('2015-05-27 16:09:07','C102'),('2015-05-27 16:09:42','C116'),('2015-05-27 16:20:32','C103'),('2015-05-27 16:20:48','C110'),('2015-05-27 16:25:13','C016'),('2015-05-27 16:25:36','C003'),('2015-05-27 16:39:37','C010'),('2015-05-27 16:42:15','C001'),('2015-05-27 16:55:57','C110'),('2015-05-27 16:55:58','C101'),('2015-05-27 17:35:30','C116'),('2015-05-27 17:43:11','C016'),('2015-05-27 18:00:16','V0603'),('2015-05-27 18:00:47','C116'),('2015-05-27 18:05:59','C016'),('2015-05-27 18:09:04','C001'),('2015-05-27 18:09:56','C010'),('2015-05-27 18:21:20','A0600'),('2015-05-27 19:01:47','C002'),('2015-05-27 19:05:33','C006'),('2015-05-27 19:10:34','C106'),('2015-05-27 19:17:52','O110'),('2015-05-27 19:17:53','O111'),('2015-05-27 19:28:39','C006'),('2015-05-27 19:35:55','C106'),('2015-05-27 19:47:36','V0603'),('2015-05-27 20:32:06','E01'),('2015-05-27 20:49:15','A0600'),('2015-05-27 20:49:29','V0603'),('2015-05-27 20:51:22','V0801'),('2015-05-27 21:11:38','C006'),('2015-05-27 21:15:43','O201'),('2015-05-27 21:15:44','O201'),('2015-05-27 21:20:27','O200'),('2015-05-27 21:48:44','C106'),('2015-05-27 21:48:54','V0600'),('2015-05-27 22:17:58','C006'),('2016-11-14 00:17:40','A0500'),('2016-11-14 00:18:35','C106'),('2016-11-14 00:26:32','O201'),('2016-11-14 00:26:33','O201'),('2016-11-14 00:29:12','O200'),('2016-11-14 00:34:15','C006'),('2016-11-14 03:00:06','E03'),('2016-11-14 05:09:06','R29M01SC'),('2016-11-14 05:39:06','E02'),('2016-11-14 05:44:29','C106'),('2016-11-14 06:01:25','C006'),('2016-11-14 07:46:54','C106'),('2016-11-14 08:47:29','C006'),('2016-11-14 08:59:03','C106'),('2016-11-14 09:16:42','C006'),('2016-11-14 09:19:23','C106'),('2016-11-14 09:36:40','C006'),('2016-11-14 11:15:27','C106'),('2016-11-14 11:27:55','C102'),('2016-11-14 11:28:07','C101'),('2016-11-14 11:28:08','R01M02--'),('2016-11-14 11:28:09','C110'),('2016-11-14 11:28:30','V0101'),('2016-11-14 11:37:58','C006'),('2016-11-14 11:42:00','O070'),('2016-11-14 11:43:27','O071'),('2016-11-14 11:45:24','C002'),('2016-11-14 11:46:08','O070'),('2016-11-14 11:47:58','O071'),('2016-11-14 11:49:55','O070'),('2016-11-14 11:49:56','O071'),('2016-11-14 11:50:21','O070'),('2016-11-14 11:51:19','O071'),('2016-11-14 11:51:36','O070'),('2016-11-14 12:04:01','O071'),('2016-11-14 12:07:32','O070'),('2016-11-14 12:14:46','O071'),('2016-11-14 12:18:13','V0100'),('2016-11-14 12:18:22','C102'),('2016-11-14 12:19:12','C106'),('2016-11-14 12:26:20','C001'),('2016-11-14 12:30:15','C010'),('2016-11-14 12:35:56','C002'),('2016-11-14 12:39:44','C006'),('2016-11-14 12:51:47','C106'),('2016-11-14 16:10:02','C006'),('2016-11-14 16:13:32','C106'),('2016-11-14 16:51:06','E01'),('2016-11-14 17:09:25','C102'),('2016-11-14 17:10:19','C103'),('2016-11-14 17:28:24','C003'),('2016-11-14 18:16:02','C006'),('2016-11-14 18:17:40','C002'),('2016-11-14 19:06:55','C106'),('2016-11-14 19:25:26','C006'),('2016-11-14 19:42:26','C106'),('2016-11-14 20:12:45','V0601'),('2016-11-14 20:58:52','V0600'),('2016-11-14 21:42:57','V0501'),('2016-11-14 22:03:45','C006'),('2016-11-14 23:13:21','C106'),('2016-11-14 23:28:37','C006'),('2015-05-28 02:29:43','C106'),('2015-05-28 02:33:58','A0800'),('2015-05-28 02:47:59','C006'),('2015-05-28 03:00:06','E03'),('2015-05-28 03:51:06','R29M01SC'),('2015-05-28 04:21:06','E02'),('2015-05-28 07:35:36','C106'),('2015-05-28 07:50:46','V0601'),('2015-05-28 08:06:24','V0600'),('2015-05-28 09:13:37','C006'),('2015-05-28 09:21:55','C106'),('2015-05-28 09:43:40','C102'),('2015-05-28 09:45:11','C103'),('2015-05-28 09:57:48','C109'),('2015-05-28 10:00:44','C101'),('2015-05-28 10:00:47','C110'),('2015-05-28 10:04:56','C003'),('2015-05-28 10:07:52','C009'),('2015-05-28 10:09:48','C010'),('2015-05-28 10:12:24','C001'),('2015-05-28 10:19:14','C006'),('2015-05-28 10:22:00','C106'),('2015-05-28 10:22:05','C002'),('2015-05-28 10:22:11','C102'),('2015-05-28 11:04:31','C006'),('2015-05-28 11:06:53','C106'),('2015-05-28 11:12:00','C002'),('2015-05-28 11:23:31','C006'),('2015-05-28 12:03:34','C106'),('2015-05-28 12:52:40','C006'),('2015-05-28 13:01:43','C106'),('2015-05-28 13:19:24','C006'),('2015-05-28 14:01:39','C106'),('2015-05-28 14:34:09','C006'),('2015-05-28 15:23:26','C106'),('2015-05-28 15:55:05','C006'),('2015-05-28 16:01:44','C106'),('2015-05-28 16:02:41','C102'),('2015-05-28 16:05:01','C103'),('2015-05-28 16:10:23','C109'),('2015-05-28 16:11:17','C003'),('2015-05-28 16:12:05','C103'),('2015-05-28 16:18:09','C003'),('2015-05-28 16:19:36','C103'),('2015-05-28 16:21:02','C009'),('2015-05-28 16:24:40','C003'),('2015-05-28 16:51:38','O220'),('2015-05-28 17:07:42','C006'),('2015-05-28 17:15:24','C002'),('2015-05-28 17:40:02','C106'),('2015-05-28 19:25:25','A0803'),('2015-05-28 20:24:10','C102'),('2015-05-28 20:24:32','C116'),('2015-05-28 20:33:06','E01'),('2015-05-28 20:38:52','C103'),('2015-05-28 20:43:45','C016'),('2015-05-28 20:45:31','C003'),('2015-05-28 20:58:08','V0800'),('2015-05-28 21:14:33','O171'),('2015-05-28 21:14:34','O171'),('2015-05-28 21:14:51','V0512'),('2015-05-28 21:14:56','V0508'),('2015-05-28 21:15:00','V0512'),('2015-05-28 21:15:04','V0507'),('2015-05-28 21:15:08','V0512'),('2015-05-28 21:32:04','A0801'),('2015-05-28 22:06:29','C002'),('2015-05-28 22:21:34','O170'),('2015-05-28 22:28:50','V0500'),('2015-05-28 22:46:47','C006'),('2016-11-15 00:18:43','A0500'),('2016-11-15 03:00:06','E03'),('2016-11-15 05:10:06','R29M01SC'),('2016-11-15 05:40:06','E02'),('2016-11-15 06:59:49','C106'),('2016-11-15 07:02:01','V0601'),('2016-11-15 07:33:04','O100'),('2016-11-15 07:34:09','O101'),('2016-11-15 07:41:29','V0600'),('2016-11-15 08:50:03','C006'),('2016-11-15 09:04:45','C106'),('2016-11-15 09:34:07','C102'),('2016-11-15 09:36:41','C101'),('2016-11-15 09:36:43','C110'),('2016-11-15 09:37:04','V0101'),('2016-11-15 09:41:36','C002'),('2016-11-15 09:48:45','C006'),('2016-11-15 09:50:47','O070'),('2016-11-15 10:12:24','O071'),('2016-11-15 10:18:17','O070'),('2016-11-15 10:19:09','O071'),('2016-11-15 10:19:18','O070'),('2016-11-15 10:22:52','O071'),('2016-11-15 10:30:16','A0100'),('2016-11-15 10:33:31','C102'),('2016-11-15 10:41:30','C001'),('2016-11-15 10:45:14','C010'),('2016-11-15 10:46:29','C106'),('2016-11-15 10:50:45','C002'),('2016-11-15 11:12:01','C006'),('2016-11-15 11:31:06','C106'),('2016-11-15 11:46:27','C006'),('2016-11-15 11:57:42','C106'),('2016-11-15 12:14:40','C006'),('2016-11-15 12:25:59','C106'),('2016-11-15 13:12:01','C006'),('2016-11-15 13:14:58','C106'),('2016-11-15 13:32:21','C006'),('2016-11-15 13:47:57','C106'),('2016-11-15 14:53:15','C102'),('2016-11-15 14:56:30','C103'),('2016-11-15 15:04:41','C003'),('2016-11-15 15:16:53','C002'),('2016-11-15 15:17:58','C006'),('2016-11-15 15:27:03','C106'),('2016-11-15 15:43:44','C006'),('2016-11-15 15:51:38','C106'),('2016-11-15 16:50:06','E01'),('2016-11-15 17:38:52','V0601'),('2016-11-15 20:56:30','O201'),('2016-11-15 20:56:31','O201'),('2016-11-15 20:58:10','O100'),('2016-11-15 20:59:09','O200'),('2016-11-15 20:59:57','O101'),('2016-11-15 21:14:34','C006'),('2016-11-15 21:29:43','C106'),('2016-11-15 21:45:06','C006'),('2016-11-15 21:53:48','C106'),('2016-11-15 22:20:02','C006'),('2016-11-15 22:51:51','C106'),('2016-11-15 23:07:04','C006'),('2015-05-29 01:08:36','A0800'),('2015-05-29 03:00:06','E03'),('2015-05-29 03:51:06','R29M01SC'),('2015-05-29 04:21:06','E02'),('2015-05-29 06:56:46','C106'),('2015-05-29 06:58:57','V0803'),('2015-05-29 07:03:50','C102'),('2015-05-29 07:08:33','O161'),('2015-05-29 07:09:54','V0912'),('2015-05-29 07:10:06','V0908'),('2015-05-29 07:10:18','A0914'),('2015-05-29 07:10:21','V0912'),('2015-05-29 07:10:54','A0900'),('2015-05-29 07:16:54','C006'),('2015-05-29 07:17:33','C116'),('2015-05-29 07:17:44','C103'),('2015-05-29 07:17:45','C109'),('2015-05-29 07:20:09','O160'),('2015-05-29 07:22:44','C016'),('2015-05-29 07:23:16','C003'),('2015-05-29 07:25:29','C106'),('2015-05-29 07:26:10','C009'),('2015-05-29 07:26:43','V0602'),('2015-05-29 07:27:38','A0600'),('2015-05-29 07:28:10','O171'),('2015-05-29 07:28:11','O171'),('2015-05-29 07:31:11','O170'),('2015-05-29 07:32:50','V0608'),('2015-05-29 07:33:15','A0600'),('2015-05-29 07:33:17','A0603'),('2015-05-29 07:33:24','A0600'),('2015-05-29 07:33:25','V0600'),('2015-05-29 07:33:29','V0608'),('2015-05-29 07:33:38','V0600'),('2015-05-29 07:34:19','V0508'),('2015-05-29 07:35:02','C103'),('2015-05-29 07:35:40','V0801'),('2015-05-29 07:39:11','A0800'),('2015-05-29 07:43:32','C003'),('2015-05-29 07:49:28','V0608'),('2015-05-29 08:08:37','A0500'),('2015-05-29 08:11:21','H'),('2015-05-29 08:11:24','O081'),('2015-05-29 08:11:25','O141'),('2015-05-29 08:11:26','O091'),('2015-05-29 08:12:34','O161'),('2015-05-29 08:34:10','C103'),('2015-05-29 08:39:15','C003'),('2015-05-29 08:41:26','C109'),('2015-05-29 08:42:04','C103'),('2015-05-29 08:47:09','C003'),('2015-05-29 08:50:01','C009'),('2015-05-29 08:56:48','C116'),('2015-05-29 09:06:23','O160'),('2015-05-29 09:07:05','O171'),('2015-05-29 09:07:07','O171'),('2015-05-29 09:07:46','O161'),('2015-05-29 09:12:27','O170'),('2015-05-29 09:13:16','O171'),('2015-05-29 09:13:18','O171'),('2015-05-29 09:32:13','O170'),('2015-05-29 09:33:58','O171'),('2015-05-29 09:38:36','A0920'),('2015-05-29 09:38:50','V0908'),('2015-05-29 09:45:22','I17G07'),('2015-05-29 09:45:25','A2211'),('2015-05-29 09:45:29','I17G09'),('2015-05-29 09:45:37','A0400'),('2015-05-29 09:45:47','A1800'),('2015-05-29 09:45:48','I17G09'),('2015-05-29 09:46:05','I17G09'),('2015-05-29 09:46:23','I17G07'),('2015-05-29 09:46:24','A0411'),('2015-05-29 09:46:27','A2511'),('2015-05-29 09:46:31','I17G09'),('2015-05-29 09:46:40','I17G09'),('2015-05-29 09:46:50','A0400'),('2015-05-29 09:47:00','I17G09'),('2015-05-29 09:47:09','I17G08'),('2015-05-29 09:47:35','V0600'),('2015-05-29 09:47:51','I17G09'),('2015-05-29 09:52:29','C106'),('2015-05-29 09:53:21','O170'),('2015-05-29 09:54:28','O171'),('2015-05-29 09:54:51','V0912'),('2015-05-29 09:55:02','O160'),('2015-05-29 09:57:53','O161'),('2015-05-29 10:04:37','C103'),('2015-05-29 10:06:44','A0900'),('2015-05-29 10:06:52','C109'),('2015-05-29 10:12:47','C003'),('2015-05-29 10:15:03','C009'),('2015-05-29 10:16:35','O170'),('2015-05-29 10:16:40','O171'),('2015-05-29 10:16:51','O170'),('2015-05-29 10:17:28','O191'),('2015-05-29 10:17:38','O190'),('2015-05-29 10:19:16','O191'),('2015-05-29 10:20:10','O190'),('2015-05-29 10:21:00','C016'),('2015-05-29 10:26:27','O201'),('2015-05-29 10:26:57','C103'),('2015-05-29 10:27:04','C109'),('2015-05-29 10:28:49','O181'),('2015-05-29 10:29:22','O180'),('2015-05-29 10:30:33','C101'),('2015-05-29 10:30:53','C110'),('2015-05-29 10:31:36','O031'),('2015-05-29 10:31:49','O030'),('2015-05-29 10:33:08','O031'),('2015-05-29 10:34:07','C116'),('2015-05-29 10:34:41','C003'),('2015-05-29 10:35:50','O030'),('2015-05-29 10:37:36','C009'),('2015-05-29 10:38:20','C103'),('2015-05-29 10:38:32','C109'),('2015-05-29 10:39:17','C016'),('2015-05-29 10:39:58','O160'),('2015-05-29 10:41:52','C010'),('2015-05-29 10:44:51','C001'),('2015-05-29 10:48:10','C003'),('2015-05-29 10:51:04','C009'),('2015-05-29 11:32:00','C103'),('2015-05-29 11:32:24','O200'),('2015-05-29 11:37:03','C109'),('2015-05-29 11:38:19','C003'),('2015-05-29 11:38:35','C103'),('2015-05-29 11:38:52','C116'),('2015-05-29 11:45:56','C006'),('2015-05-29 11:48:07','C016'),('2015-05-29 11:52:37','C101'),('2015-05-29 11:56:00','C110'),('2015-05-29 11:56:34','C003'),('2015-05-29 11:59:30','C009'),('2015-05-29 12:18:42','C103'),('2015-05-29 12:23:48','C003'),('2015-05-29 12:31:45','C103'),('2015-05-29 12:33:13','C109'),('2015-05-29 12:40:22','C010'),('2015-05-29 12:41:17','C009'),('2015-05-29 12:42:44','C001'),('2015-05-29 12:44:02','C106'),('2015-05-29 12:46:49','C003'),('2015-05-29 13:07:01','C103'),('2015-05-29 13:12:04','C003'),('2015-05-29 13:12:59','C101'),('2015-05-29 13:17:50','C103'),('2015-05-29 13:21:17','C116'),('2015-05-29 13:32:18','C010'),('2015-05-29 13:32:49','C003'),('2015-05-29 13:34:41','C001'),('2015-05-29 13:42:27','C016'),('2015-05-29 13:57:37','C116'),('2015-05-29 13:58:39','O201'),('2015-05-29 13:58:52','O200'),('2015-05-29 14:00:42','O201'),('2015-05-29 14:02:47','C016'),('2015-05-29 14:06:14','O200'),('2015-05-29 14:06:21','O201'),('2015-05-29 14:21:15','C002'),('2015-05-29 14:21:38','C102'),('2015-05-29 14:21:47','C103'),('2015-05-29 14:21:52','C109'),('2015-05-29 14:24:27','C101'),('2015-05-29 14:24:29','C110'),('2015-05-29 14:29:19','C003'),('2015-05-29 14:31:13','F166.78.107.36:V0204'),('2015-05-29 14:32:14','C009'),('2015-05-29 14:32:31','F166.78.107.36:V0202'),('2015-05-29 14:33:32','C010'),('2015-05-29 14:33:42','A0200'),('2015-05-29 14:35:32','V0601'),('2015-05-29 14:35:54','C001'),('2015-05-29 14:36:28','V0600'),('2015-05-29 14:45:36','O200'),('2015-05-29 14:45:43','O201'),('2015-05-29 14:48:42','O200'),('2015-05-29 14:48:50','O201'),('2015-05-29 14:49:20','V0602'),('2015-05-29 14:49:44','V0612'),('2015-05-29 14:49:51','A0600'),('2015-05-29 15:08:38','V0604'),('2015-05-29 15:08:55','V0600'),('2015-05-29 15:09:47','C101'),('2015-05-29 15:09:51','C110'),('2015-05-29 15:10:17','C103'),('2015-05-29 15:10:24','C109'),('2015-05-29 15:12:46','I20G07'),('2015-05-29 15:12:48','A0411'),('2015-05-29 15:12:50','A0611'),('2015-05-29 15:14:02','I20G09'),('2015-05-29 15:14:16','A0400'),('2015-05-29 15:15:06','I20G06'),('2015-05-29 15:15:25','I20G08'),('2015-05-29 15:18:27','C003'),('2015-05-29 15:18:54','C010'),('2015-05-29 15:19:21','C103'),('2015-05-29 15:21:15','C001'),('2015-05-29 15:23:36','C116'),('2015-05-29 15:25:22','V0603'),('2015-05-29 15:30:08','I20G07'),('2015-05-29 15:30:09','A0411'),('2015-05-29 15:30:10','A1811'),('2015-05-29 15:30:11','A2511'),('2015-05-29 15:34:56','I20G09'),('2015-05-29 15:35:12','A0400'),('2015-05-29 15:38:45','C003'),('2015-05-29 15:41:20','C103'),('2015-05-29 15:42:09','C101'),('2015-05-29 15:42:10','C110'),('2015-05-29 15:46:52','C003'),('2015-05-29 15:49:46','C009'),('2015-05-29 15:51:11','C010'),('2015-05-29 15:53:31','C001'),('2015-05-29 16:05:40','V0501'),('2015-05-29 16:26:00','V0600'),('2015-05-29 16:26:03','A0602'),('2015-05-29 16:26:20','A0603'),('2015-05-29 16:31:12','V0600'),('2015-05-29 16:35:30','C101'),('2015-05-29 16:35:46','C110'),('2015-05-29 16:35:47','V0508'),('2015-05-29 16:48:12','C001'),('2015-05-29 17:02:00','V0500'),('2015-05-29 17:05:09','O200'),('2015-05-29 17:07:30','C101'),('2015-05-29 17:34:10','C010'),('2015-05-29 17:36:34','C001'),('2015-05-29 18:18:46','V0603'),('2015-05-29 18:47:03','O161'),('2015-05-29 18:47:59','O160'),('2015-05-29 18:51:39','C103'),('2015-05-29 18:52:52','C101'),('2015-05-29 18:52:53','R01B01LK'),('2015-05-29 18:53:01','C110'),('2015-05-29 18:57:42','C003'),('2015-05-29 19:15:49','C016'),('2015-05-29 19:18:59','C010'),('2015-05-29 19:21:19','C001'),('2015-05-29 19:50:56','C006'),('2015-05-29 19:53:25','C002'),('2015-05-29 20:13:31','C106'),('2015-05-29 20:15:36','V0802'),('2015-05-29 20:29:44','C006'),('2015-05-29 20:34:06','E01'),('2015-05-29 20:35:11','V0808'),('2015-05-29 20:35:56','V0800'),('2015-05-29 20:39:04','C106'),('2015-05-29 20:39:26','V0608'),('2015-05-29 21:00:19','V0602'),('2015-05-29 21:02:50','V0803'),('2015-05-29 23:11:34','O100'),('2015-05-29 23:19:20','O101'),('2015-05-29 23:24:24','V0600'),('2015-05-29 23:42:29','V0801'),('2015-05-29 23:45:27','C006'),('2016-11-16 00:09:55','V0600'),('2016-11-16 00:09:58','C106'),('2016-11-16 00:25:41','C006'),('2016-11-16 03:00:06','E03'),('2016-11-16 05:12:06','R29M01SC'),('2016-11-16 05:42:06','E02'),('2016-11-16 07:14:05','C106'),('2016-11-16 07:14:51','V0601'),('2016-11-16 08:01:08','A0600'),('2016-11-16 09:20:41','C102'),('2016-11-16 09:20:56','C101'),('2016-11-16 09:20:58','C110'),('2016-11-16 09:21:24','A0101'),('2016-11-16 09:33:46','C006'),('2016-11-16 09:34:46','O070'),('2016-11-16 09:37:51','C002'),('2016-11-16 10:03:31','C010'),('2016-11-16 10:25:33','O071'),('2016-11-16 10:25:59','A0100'),('2016-11-16 10:26:07','C110'),('2016-11-16 10:26:16','C102'),('2016-11-16 10:26:37','C106'),('2016-11-16 10:34:12','C001'),('2016-11-16 10:37:44','C010'),('2016-11-16 10:43:20','C002'),('2016-11-16 11:23:09','C006'),('2016-11-16 11:45:47','C106'),('2016-11-16 12:02:12','C006'),('2016-11-16 13:29:17','C106'),('2016-11-16 13:30:51','V0601'),('2016-11-16 14:09:10','C006'),('2016-11-16 14:13:14','C106'),('2016-11-16 14:14:18','V0600'),('2016-11-16 14:37:02','C006'),('2016-11-16 15:01:06','C106'),('2016-11-16 15:49:35','C006'),('2016-11-16 15:52:19','C106'),('2016-11-16 16:20:51','C006'),('2016-11-16 16:49:06','E01'),('2016-11-16 17:07:59','C106'),('2016-11-16 17:28:04','C006'),('2016-11-16 17:40:54','C106'),('2016-11-16 18:15:08','C102'),('2016-11-16 18:15:32','C103'),('2016-11-16 18:21:14','C003'),('2016-11-16 18:52:43','C002'),('2016-11-16 19:43:50','V0605'),('2016-11-16 19:43:53','V0600'),('2016-11-16 19:44:00','V0605'),('2016-11-16 20:32:42','O100'),('2016-11-16 20:35:08','O101'),('2016-11-16 20:39:16','O100'),('2016-11-16 20:41:40','O101'),('2016-11-16 21:07:37','V0600'),('2016-11-16 21:07:41','V0601'),('2016-11-16 21:27:18','A0600'),('2016-11-16 22:06:22','V0601'),('2016-11-16 22:25:51','C006'),('2016-11-16 22:43:19','C106'),('2016-11-16 22:59:40','C006'),('2016-11-16 23:26:45','V0600'),('2016-11-16 23:26:47','C106'),('2016-11-16 23:42:08','C006'),('2015-05-30 03:00:06','E03'),('2015-05-30 03:50:06','R29M01SC'),('2015-05-30 04:20:06','E02'),('2015-05-30 06:57:46','A0800'),('2015-05-30 08:07:11','O110'),('2015-05-30 08:07:15','O111'),('2015-05-30 08:09:08','V0808'),('2015-05-30 09:26:05','C106'),('2015-05-30 10:10:56','V0800'),('2015-05-30 10:30:43','C006'),('2015-05-30 11:14:30','C106'),('2015-05-30 11:36:43','C102'),('2015-05-30 11:37:38','C110'),('2015-05-30 11:39:41','V0101'),('2015-05-30 11:58:20','C010'),('2015-05-30 12:00:49','C002'),('2015-05-30 12:23:33','V0100'),('2015-05-30 12:23:44','C110'),('2015-05-30 12:23:50','C102'),('2015-05-30 12:32:42','C010'),('2015-05-30 12:34:54','C001'),('2015-05-30 12:47:49','C002'),('2015-05-30 12:48:59','C006'),('2015-05-30 12:56:32','C106'),('2015-05-30 13:17:58','C102'),('2015-05-30 13:18:16','C116'),('2015-05-30 13:18:46','C103'),('2015-05-30 13:26:16','C101'),('2015-05-30 13:30:11','C016'),('2015-05-30 13:30:17','C003'),('2015-05-30 13:40:13','C103'),('2015-05-30 13:42:44','C109'),('2015-05-30 13:48:59','C010'),('2015-05-30 13:50:14','C003'),('2015-05-30 13:51:09','C001'),('2015-05-30 13:52:22','C103'),('2015-05-30 13:57:44','C101'),('2015-05-30 13:57:45','C110'),('2015-05-30 13:58:58','C003'),('2015-05-30 14:02:58','C009'),('2015-05-30 14:16:50','C006'),('2015-05-30 14:20:07','C103'),('2015-05-30 14:25:12','C003'),('2015-05-30 14:26:13','C103'),('2015-05-30 14:34:42','C106'),('2015-05-30 14:36:13','C003'),('2015-05-30 14:38:40','C010'),('2015-05-30 14:42:02','C103'),('2015-05-30 14:42:06','C001'),('2015-05-30 15:03:33','C109'),('2015-05-30 15:05:34','C101'),('2015-05-30 15:05:35','C110'),('2015-05-30 15:05:51','R01B03LK'),('2015-05-30 15:10:21','C003'),('2015-05-30 15:12:58','V0108'),('2015-05-30 15:13:11','C009'),('2015-05-30 15:14:31','V0100'),('2015-05-30 15:31:24','C010'),('2015-05-30 15:33:36','C001'),('2015-05-30 15:52:55','V0403'),('2015-05-30 16:01:16','V0400'),('2015-05-30 16:02:36','C002'),('2015-05-30 16:29:58','C102'),('2015-05-30 16:30:38','C116'),('2015-05-30 16:32:45','C103'),('2015-05-30 16:52:28','C003'),('2015-05-30 16:53:48','C103'),('2015-05-30 17:01:39','C003'),('2015-05-30 17:02:08','C103'),('2015-05-30 17:02:11','C109'),('2015-05-30 17:02:36','O181'),('2015-05-30 17:03:14','V0904'),('2015-05-30 17:04:51','O180'),('2015-05-30 17:05:34','O181'),('2015-05-30 17:07:24','C003'),('2015-05-30 17:08:25','C103'),('2015-05-30 17:08:37','O180'),('2015-05-30 17:19:14','C003'),('2015-05-30 17:22:41','C016'),('2015-05-30 17:23:21','C006'),('2015-05-30 17:30:15','C106'),('2015-05-30 17:31:57','V3001'),('2015-05-30 17:32:10','C103'),('2015-05-30 17:37:14','C003'),('2015-05-30 17:39:03','C116'),('2015-05-30 17:43:21','C103'),('2015-05-30 17:44:24','C016'),('2015-05-30 17:48:26','C003'),('2015-05-30 17:53:42','C103'),('2015-05-30 17:55:46','C116'),('2015-05-30 18:00:55','C016'),('2015-05-30 18:01:00','C003'),('2015-05-30 18:04:58','C103'),('2015-05-30 18:08:43','C116'),('2015-05-30 18:11:28','C101'),('2015-05-30 18:13:53','C016'),('2015-05-30 18:14:29','C003'),('2015-05-30 18:20:45','C010'),('2015-05-30 18:21:00','C103'),('2015-05-30 18:21:05','C116'),('2015-05-30 18:22:56','C001'),('2015-05-30 18:26:06','C003'),('2015-05-30 18:26:17','C016'),('2015-05-30 18:26:58','C103'),('2015-05-30 18:32:06','C003'),('2015-05-30 18:35:00','C009'),('2015-05-30 18:42:00','O161'),('2015-05-30 18:42:29','V0203'),('2015-05-30 18:44:34','C006'),('2015-05-30 18:47:32','O160'),('2015-05-30 18:51:51','O161'),('2015-05-30 18:52:00','A0200'),('2015-05-30 18:52:51','O160'),('2015-05-30 18:53:54','C106'),('2015-05-30 19:00:33','V3000'),('2015-05-30 19:02:18','V0602'),('2015-05-30 19:51:33','C103'),('2015-05-30 19:56:51','C003'),('2015-05-30 19:57:02','V0600'),('2015-05-30 20:20:10','C002'),('2015-05-30 20:33:21','C006'),('2015-05-30 20:35:06','E01'),('2015-05-30 21:43:03','C106'),('2015-05-30 21:58:52','C006'),('2015-05-30 22:30:01','C106'),('2015-05-30 23:01:45','A0801'),('2015-05-30 23:04:57','C006');
/*!40000 ALTER TABLE `controlSystemLog` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `controlSystemOther`
--

DROP TABLE IF EXISTS `controlSystemOther`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `controlSystemOther` (
  `name` varchar(30) NOT NULL DEFAULT 'Another Action',
  `WLSIP` varchar(100) NOT NULL DEFAULT '@beep`',
  `rooms_pertaining_to` varchar(255) DEFAULT NULL
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `controlSystemOther`
--

LOCK TABLES `controlSystemOther` WRITE;
/*!40000 ALTER TABLE `controlSystemOther` DISABLE KEYS */;
INSERT INTO `controlSystemOther` VALUES ('Paging Enabled?','@paging`{currRoom}`{disabled|enabled}','1.2.3.4.5.6.8.10.11.12.13.14.15.16.17.18.19.20.21.22.23.24.25.27'),('BF Sitting Video Game','@bfSittingVG`1','2');
/*!40000 ALTER TABLE `controlSystemOther` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `controlSystemRelay`
--

DROP TABLE IF EXISTS `controlSystemRelay`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `controlSystemRelay` (
  `index` int(11) NOT NULL,
  `name` varchar(30) NOT NULL,
  `rooms_pertaining_to` varchar(255) DEFAULT NULL,
  KEY `index` (`index`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `controlSystemRelay`
--

LOCK TABLES `controlSystemRelay` WRITE;
/*!40000 ALTER TABLE `controlSystemRelay` DISABLE KEYS */;
/*!40000 ALTER TABLE `controlSystemRelay` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `event`
--

DROP TABLE IF EXISTS `event`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `event` (
  `index` int(2) NOT NULL,
  `name` varchar(25) NOT NULL DEFAULT 'Nothing',
  `LSIP_when` varchar(250) NOT NULL DEFAULT 'F',
  `LSIP_exc` varchar(250) NOT NULL DEFAULT 'F',
  `LSIP_main` varchar(10000) NOT NULL DEFAULT '@doNothing`',
  PRIMARY KEY (`index`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `event`
--

LOCK TABLES `event` WRITE;
/*!40000 ALTER TABLE `event` DISABLE KEYS */;
INSERT INTO `event` VALUES (1,'Sunset','A0-30','F','@singleLight`85`100`2~@singleLight`87`100`2~@singleLight`92`100`2~@singleLight`93`100`2~@singleLight`94`100`2~@singleLight`95`100`2~@singleLight`96`100`2~@singleLight`97`100`2~@singleLight`114`100`2'),(2,'Sunrise','A1-30','F','@singleLight`85`0`2~@singleLight`86`0`2~@singleLight`87`0`2~@singleLight`92`0`2~@singleLight`93`0`2~@singleLight`94`0`2~@singleLight`95`0`2~@singleLight`96`0`2~@singleLight`97`0`2~@singleLight`114`0`2'),(3,'Late Night','T03:00','F','@singleLight`86`00`2~@singleLight`93`00`2~@singleLight`97`00`2');
/*!40000 ALTER TABLE `event` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `floor`
--

DROP TABLE IF EXISTS `floor`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `floor` (
  `index` tinyint(4) NOT NULL,
  `name` varchar(30) NOT NULL,
  PRIMARY KEY (`index`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `floor`
--

LOCK TABLES `floor` WRITE;
/*!40000 ALTER TABLE `floor` DISABLE KEYS */;
INSERT INTO `floor` VALUES (1,'Lower Basement'),(2,'Basement'),(3,'First Floor'),(4,'Second Floor'),(5,'Outside');
/*!40000 ALTER TABLE `floor` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `keypad`
--

DROP TABLE IF EXISTS `keypad`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `keypad` (
  `addr` varchar(20) NOT NULL,
  `brand` varchar(10) NOT NULL DEFAULT 'Lutron_HW',
  `buttons` varchar(4) NOT NULL DEFAULT '6+2'
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `keypad`
--

LOCK TABLES `keypad` WRITE;
/*!40000 ALTER TABLE `keypad` DISABLE KEYS */;
INSERT INTO `keypad` VALUES ('256','Lutron_QS','6+2'),('89','Lutron_QS','6+2'),('83','Lutron_QS','6+2'),('94','Lutron_QS','6+2'),('85','Lutron_QS','6+2'),('322','Lutron_QS','6+2'),('318','Lutron_QS','6+2'),('317','Lutron_QS','6+2'),('297','Lutron_QS','6+2'),('298','Lutron_QS','6+2'),('299','Lutron_QS','6+2'),('300','Lutron_QS','6+2'),('301','Lutron_QS','6+2'),('307','Lutron_QS','6+2'),('308','Lutron_QS','6+2'),('309','Lutron_QS','6+2'),('310','Lutron_QS','6+2'),('302','Lutron_QS','6+2'),('303','Lutron_QS','6+2'),('305','Lutron_QS','6+2'),('306','Lutron_QS','6+2'),('311','Lutron_QS','6+2'),('312','Lutron_QS','6+2'),('313','Lutron_QS','6+2'),('314','Lutron_QS','6+2'),('315','Lutron_QS','6+2'),('319','Lutron_QS','6+2'),('320','Lutron_QS','6+2'),('321','Lutron_QS','6+2'),('323','Lutron_QS','6+2'),('324','Lutron_QS','6+2'),('350','Lutron_QS','6+2');
/*!40000 ALTER TABLE `keypad` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `light`
--

DROP TABLE IF EXISTS `light`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `light` (
  `index` smallint(6) NOT NULL AUTO_INCREMENT,
  `room` tinyint(2) NOT NULL DEFAULT '1',
  `addr` varchar(16) NOT NULL DEFAULT '[0:0:0:0]',
  `name` varchar(35) NOT NULL DEFAULT 'New Light',
  `type` varchar(15) NOT NULL DEFAULT 'Dimmer',
  `shade` tinyint(1) NOT NULL DEFAULT '0',
  `maplocX` smallint(3) NOT NULL DEFAULT '999',
  `maplocY` smallint(3) NOT NULL DEFAULT '999',
  PRIMARY KEY (`index`)
) ENGINE=MyISAM AUTO_INCREMENT=159 DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `light`
--

LOCK TABLES `light` WRITE;
/*!40000 ALTER TABLE `light` DISABLE KEYS */;
INSERT INTO `light` VALUES (1,16,'230','Far Downlights','Dimmer',0,220,231),(2,16,'231','Near Downlights','Dimmer',0,217,35),(3,28,'98','Lamp Outlets','Dimmer',0,258,239),(4,28,'99','Fireplace Downlights','Dimmer',0,156,172),(5,28,'100','Bath Toilet','Dimmer',0,147,2),(6,28,'101','Shower Downlights','Dimmer',0,34,98),(7,28,'102','Bath Sconces','Dimmer',0,239,53),(8,28,'224',' Bath Ceiling Fixture','Dimmer',0,313,0),(9,28,'225','Fan','Fan',0,43,10),(10,3,'226','Stair Hall Downlights','Dimmer',0,397,304),(11,3,'227','Stair Hall Sconces','Dimmer',0,302,303),(12,2,'232','Bar Downlights','Dimmer',0,58,37),(13,2,'233','Bar Cabinet','Dimmer',0,145,37),(14,2,'234','Bar Under Cabinet Lights xxx','Dimmer',0,999,999),(15,2,'236','Center Downlights','Dimmer',0,134,161),(16,2,'237','Soffit','Dimmer',0,316,160),(17,3,'238','Ceiling Fixture xxx','Dimmer',0,295,123),(18,3,'265','Counter Downlights','Dimmer',0,403,119),(19,0,'266','Display Case Lights ??','Dimmer',0,999,999),(20,9,'239','Ceiling Downlights','Dimmer',0,270,142),(21,9,'240','Sconces','Dimmer',0,291,54),(22,9,'241','Step Lights','Dimmer',0,299,229),(23,9,'242','Sofit Downlights','Dimmer',0,192,233),(24,9,'295','Blackout Shade','Shade',1,197,10),(25,3,'243','Wine Cellar Ceiling','Dimmer',0,301,225),(26,3,'244','Wine Cellar Downlights','Dimmer',0,202,226),(27,3,'263','Wine Cellar Hall','Dimmer',0,202,303),(28,28,'272','Bed Hall','Dimmer',0,408,58),(29,2,'270','Play Room Lights','Dimmer',0,0,278),(30,9,'274','Theater Hall Downlights','Dimmer',0,207,307),(31,10,'245','Fluorescents Far','Switch',0,296,133),(32,27,'201','Master Toilet','Dimmer',0,211,113),(33,10,'264','Downlights','Dimmer',0,131,243),(34,1,'247','Downlights','Dimmer',0,189,89),(35,1,'248','Toilet Downlights','Dimmer',0,216,233),(36,1,'249','Bath Sconces','Dimmer',0,129,209),(37,1,'250','Bath Downlights','Dimmer',0,109,307),(38,1,'251','Bath Fan','Switch',0,45,252),(39,1,'268','Shower Downlights','Dimmer',0,198,307),(40,4,'158','Ceiling Fixture','Dimmer',0,115,196),(41,4,'159','Downlights','Dimmer',0,111,121),(42,4,'287','Cigar Exhaust','Switch',0,212,143),(43,25,'146','Ceiling Fixture','Dimmer',0,170,134),(44,25,'147','Library Downlights W','Dimmer',0,84,82),(45,25,'148','Library Downlights E','Dimmer',0,258,86),(46,25,'149','Library Sconces W n/a','Dimmer',0,76,195),(47,25,'150','Library Sconces E n/a','Dimmer',0,255,184),(48,5,'136','Window Downlights','Dimmer',0,212,5),(49,5,'137','Corner Downlights','Dimmer',0,139,252),(50,5,'138','Ceiling Fixture','Dimmer',0,219,146),(51,5,'139','Rear Downlights','Dimmer',0,370,256),(52,5,'140','Fireplace Downlights','Dimmer',0,31,166),(53,7,'143','Gallery Downlights','Dimmer',0,320,189),(54,7,'144','Gallery Ceiling','Dimmer',0,235,137),(55,7,'145','Gallery Sconces','Dimmer',0,135,162),(56,7,'151','PR Sconces','Dimmer',0,405,5),(57,7,'152','PR Ceiling Fixture','Dimmer',0,311,7),(58,7,'153','PR Fan','Switch',0,327,113),(59,25,'160','Bar Downlights','Dimmer',0,389,196),(60,25,'161','Bar Under Cabinet','Dimmer',0,327,267),(61,23,'133','Ceiling Fixture','Dimmer',0,184,180),(62,23,'134','Fireplace','Dimmer',0,55,145),(63,23,'135','Downlights','Dimmer',0,229,84),(64,23,'283','Lamp Outlets','Dimmer',0,279,259),(65,6,'128','Breakfast Downlights','Dimmer',0,114,0),(66,6,'129','Breakfast Sconces','Dimmer',0,31,50),(67,6,'126','Fireplace Lights','Dimmer',0,0,185),(68,6,'127','Sitting Downlights','Dimmer',0,99,190),(69,24,'154','Butler Downlights','Dimmer',0,206,20),(70,6,'275','Pantry Undercabinet','Dimmer',0,408,235),(71,24,'156','Butler Ceiling Fixture','Dimmer',0,298,19),(72,24,'157','Butler Undercabinet','Dimmer',0,387,0),(73,24,'288','Butler Uppercabinet','Dimmer',0,116,0),(74,24,'130','Downlights','Dimmer',0,217,260),(75,24,'131','Ceiling Fixtures','Dimmer',0,196,155),(76,24,'132','Sconce n/a','Dimmer',0,315,135),(77,6,'111','Downlights','Dimmer',0,195,153),(78,6,'112','Island Ceiling Fixture','Dimmer',0,294,152),(79,6,'113','Downlights Above Sink','Dimmer',0,288,68),(80,6,'114','Sconces','Dimmer',0,329,235),(81,6,'115','Kitchen Undercabinet','Dimmer',0,210,68),(82,6,'277','Kitchen Uppercabinet','Dimmer',0,247,235),(83,7,'117','Back Hall Downlights','Dimmer',0,409,153),(84,17,'116','Downlights','Dimmer',0,150,152),(85,18,'124','Covered Porch Downlights','Dimmer',0,407,36),(86,18,'281','BBQ Flood','Dimmer',0,318,37),(87,18,'118','Garage Sconces','Dimmer',0,421,177),(88,7,'120','PR 2 Ceiling Fixture','Dimmer',0,84,302),(89,7,'121','PR 2 Fan','Switch',0,85,232),(90,7,'280','PR 2 Sconces','Dimmer',0,4,177),(91,6,'123','Pantry Downlights','Dimmer',0,408,135),(92,18,'142','Backyard Sconces','Dimmer',0,120,31),(93,18,'292','Backyard Landscape','Dimmer',0,10,6),(94,18,'279','Mudroom Entry Ceiling Fixture','Dimmer',0,346,263),(95,18,'285','Front Porch Sconce','Dimmer',0,79,245),(96,18,'286','Front Porch Downlight','Dimmer',0,167,246),(97,18,'293','Front Landscape','Dimmer',0,0,307),(98,9,'276','Popcorn Lights','Dimmer',0,365,307),(99,27,'202','Tub Downlights','Dimmer',0,313,46),(100,27,'203','Ceiling Fixture','Dimmer',0,318,135),(101,27,'204','Shower Hall Downlight','Dimmer',0,206,234),(102,27,'205','Sconce','Dimmer',0,321,276),(103,27,'206','Fan','Switch',0,209,44),(104,27,'208','Shower Downlights','Dimmer',0,114,131),(105,14,'207','Downlights','Dimmer',0,236,224),(106,14,'209','Sconces','Dimmer',0,119,97),(107,14,'210','Ceiling Fixture','Dimmer',0,178,162),(108,15,'211','Ceiling Fixture','Dimmer',0,238,205),(109,15,'212','Downlights','Dimmer',0,225,120),(110,12,'197','Downlights','Dimmer',0,182,210),(111,12,'198','Window Downlight','Dimmer',0,158,10),(112,12,'199','Fireplace Downlight','Dimmer',0,266,109),(113,12,'200','Outlets','Switch',0,100,108),(114,18,'196','Balcony Sconces','Dimmer',0,212,51),(115,8,'192','Ceiling Fixture','Dimmer',0,266,189),(116,8,'193','Sconces n/a','Dimmer',0,313,76),(117,20,'155','Bath Sconces','Dimmer',0,79,214),(118,8,'195','Downlights','Dimmer',0,169,266),(119,29,'60','N Hall Downlights','Dimmer',0,404,160),(120,29,'178','N Hall Sconce','Dimmer',0,300,154),(121,29,'179','Main Downlights','Dimmer',0,179,156),(122,29,'180','N Stair Ceiling','Dimmer',0,321,227),(123,29,'181','Foyer Downlights','Dimmer',0,59,258),(124,29,'184','Side Hall Downlights','Dimmer',0,0,113),(125,22,'183','Main Foyer Fixture','Dimmer',0,182,191),(126,19,'189','Bath Downlights','Dimmer',0,144,75),(127,19,'188','Bath Sconce','Dimmer',0,224,42),(128,19,'190','Shower Downlights','Dimmer',0,67,33),(129,19,'191','Bath Fan','Switch',0,145,0),(130,19,'185','Main Downlights','Dimmer',0,233,154),(131,19,'186','Ceiling Fixture','Dimmer',0,185,236),(132,19,'187','Outlets','Switch',0,102,167),(133,20,'174','Bath Downlights','Dimmer',0,186,278),(134,20,'176','Shower Downlights','Dimmer',0,0,280),(135,20,'177','Bath Fan','Switch',0,94,307),(136,20,'171','Main Downlights','Dimmer',0,161,63),(137,20,'172','Ceiling Fixture','Dimmer',0,244,123),(138,20,'173','Outlets','Switch',0,199,207),(139,21,'162','Window Downlights','Dimmer',0,408,62),(140,21,'163','Main Downlights','Dimmer',0,169,53),(141,21,'165','Outlets','Switch',0,151,183),(142,21,'166','Ceiling Fixtures','Dimmer',0,280,128),(143,21,'167','Bath Downlights','Dimmer',0,336,219),(144,21,'168','Bath Sconce','Dimmer',0,246,218),(145,21,'169','Shower Downlights','Dimmer',0,339,298),(146,21,'170','Bath Fan','Switch',0,247,300),(147,21,'290','Bed Sconces','Dimmer',0,284,18),(148,3,'326','Display Case','Dimmer',0,287,33),(149,10,'246','Fluorescents Near','Switch',0,152,139),(150,29,'182','Hall Sconces Master','Dimmer',0,63,180),(151,22,'332','Lamp','Dimmer',0,116,101),(152,25,'334','Desk Lamp','Dimmer',0,162,215),(153,5,'336','Couch Lamps','Dimmer',0,335,152),(154,5,'338','Fireplace Lamp','Dimmer',0,44,279),(155,6,'282','Picture Down Light','Dimmer',0,166,230),(156,30,'347','In-Ceiling','Dimmer',0,342,158),(157,30,'344','Sconces','Dimmer',0,178,298),(158,30,'349','Chandelier','Dimmer',0,194,155);
/*!40000 ALTER TABLE `light` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `lightScene`
--

DROP TABLE IF EXISTS `lightScene`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `lightScene` (
  `addr` varchar(20) NOT NULL,
  `slot` int(2) NOT NULL,
  `name` varchar(30) NOT NULL,
  KEY `addr` (`addr`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `lightScene`
--

LOCK TABLES `lightScene` WRITE;
/*!40000 ALTER TABLE `lightScene` DISABLE KEYS */;
INSERT INTO `lightScene` VALUES ('316',3,'Dim'),('316',1,'Bright'),('322',5,' '),('318',4,'Off'),('305',4,'Off'),('317',2,'Medium'),('317',1,'Bright'),('318',2,'Medium'),('322',4,'Off'),('297',2,'Medium'),('298',2,'Medium'),('297',1,'Bright'),('298',1,'Bright'),('299',1,'Bright'),('300',2,'Medium'),('301',2,'Medium'),('307',2,'Medium'),('308',4,'Off'),('310',2,'Medium'),('310',1,'Bright'),('300',1,'Bright'),('301',1,'Bright'),('307',1,'Bright'),('308',3,'Dim'),('309',3,'Dim'),('316',2,'Medium'),('305',3,'Dim'),('305',2,'Medium'),('318',3,'Dim'),('318',1,'Bright'),('302',2,'Medium'),('302',1,'Bright'),('309',4,'Off'),('309',2,'Medium'),('309',1,'Bright'),('308',2,'Medium'),('308',1,'Bright'),('298',3,'Dim'),('298',4,'Off'),('301',3,'Dim'),('301',4,'Off'),('300',3,'Dim'),('300',4,'Off'),('297',3,'Dim'),('297',4,'Off'),('303',4,'Off'),('305',1,'Bright'),('306',1,'Bright'),('311',1,'Bright'),('312',2,'Medium'),('312',1,'Bright'),('313',1,'Bright'),('314',1,'Bright'),('319',1,'Bright'),('320',1,'Bright'),('321',1,'Bright'),('323',1,'Bright'),('324',1,'Bright'),('299',2,'Medium'),('299',3,'Dim'),('299',4,'Off'),('302',3,'Dim'),('302',4,'Off'),('303',3,'Dim'),('303',2,'Medium'),('303',1,'Bright'),('306',2,'Medium'),('306',3,'Dim'),('306',4,'Off'),('307',3,'Dim'),('307',4,'Off'),('310',3,'Dim'),('310',4,'Off'),('311',2,'Medium'),('311',3,'Dim'),('311',4,'Off'),('312',3,'Dim'),('312',4,'Off'),('313',2,'Medium'),('313',3,'Dim'),('313',4,'Off'),('314',2,'Medium'),('314',3,'Dim'),('314',4,'Off'),('316',4,'Off'),('315',4,'Off'),('315',3,'Dim'),('315',2,'Medium'),('318',6,' '),('319',2,'Medium'),('319',3,'Dim'),('319',4,'Off'),('320',2,'Medium'),('320',3,'Dim'),('320',4,'Off'),('321',2,'Medium'),('321',3,'Dim'),('321',4,'Off'),('322',3,'Dim'),('322',2,'Medium'),('322',1,'Bright'),('323',2,'Medium'),('323',3,'Dim'),('323',4,'Off'),('324',2,'Medium'),('324',3,'Dim'),('324',4,'Off'),('322',6,' '),('317',3,'Dim'),('317',4,'Off'),('315',1,'Bright'),('350',1,'Bright'),('350',2,'Medium'),('350',3,'Dim'),('350',4,'Off');
/*!40000 ALTER TABLE `lightScene` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `localSrc`
--

DROP TABLE IF EXISTS `localSrc`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `localSrc` (
  `room` smallint(2) NOT NULL DEFAULT '0',
  `vi` smallint(2) NOT NULL DEFAULT '0',
  `tv_input` smallint(2) NOT NULL DEFAULT '0',
  `amp_input` varchar(20) NOT NULL DEFAULT '',
  `desc` varchar(30) NOT NULL
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `localSrc`
--

LOCK TABLES `localSrc` WRITE;
/*!40000 ALTER TABLE `localSrc` DISABLE KEYS */;
INSERT INTO `localSrc` VALUES (9,0,71,'BD','Theater Default'),(9,99,11,'SAT','Theater Game'),(9,98,32,'DVD','Theater Aux');
/*!40000 ALTER TABLE `localSrc` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `mode`
--

DROP TABLE IF EXISTS `mode`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `mode` (
  `room` int(11) NOT NULL,
  `slot` int(11) NOT NULL,
  `local` tinyint(1) NOT NULL DEFAULT '1',
  `name` varchar(25) NOT NULL,
  `LSIP_when` varchar(250) DEFAULT NULL,
  `LSIP_exc` varchar(250) NOT NULL DEFAULT 'F',
  `LSIP_main` varchar(10000) NOT NULL,
  `override` tinyint(1) NOT NULL DEFAULT '0'
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `mode`
--

LOCK TABLES `mode` WRITE;
/*!40000 ALTER TABLE `mode` DISABLE KEYS */;
INSERT INTO `mode` VALUES (1,6,0,'Away','','F','',0),(2,6,0,'Away','','F','',0),(3,6,0,'Away','','F','',0),(4,6,0,'Away','','F','',0),(5,6,0,'Away','','F','',0),(6,6,0,'Away','','F','',0),(7,6,0,'Away','','F','',0),(8,6,0,'Away','','F','',0),(9,6,0,'Away','','F','',0),(10,6,0,'Away','','F','',0),(11,6,0,'Away','','F','',0),(12,6,0,'Away','','F','',0),(13,6,0,'Away','','F','',0),(14,6,0,'Away','','F','',0),(15,6,0,'Away','','F','',0),(16,6,0,'Away','','F','',0),(17,6,0,'Away','','F','',0),(18,6,0,'Away','','F','',0),(19,6,0,'Away','','F','',0),(20,6,0,'Away','','F','',0),(21,6,0,'Away','','F','',0),(22,6,0,'Away','','F','',0),(23,6,0,'Away','','F','',0),(24,6,0,'Away','','F','',0),(25,6,0,'Away','','F','',0),(26,6,0,'Away','','F','',0),(27,6,0,'Away','','F','',0),(1,1,1,'Leave','','F','@roomLightScene`1`4~@videoSrc`1`0~@paging`1`1',0),(10,1,1,'Leave','','F','@roomLightScene`10`4~@audioSrc`10`0~@paging`10`1',0),(16,1,1,'Leave','','F','@roomLightScene`16`4~@videoSrc`16`0',0),(2,1,1,'Leave','','F','@roomLightScene`2`4~@videoSrc`2`0~@audioSrc`2`0~@paging`2`0',0),(3,1,1,'Leave','','F','@singleLight`10`0`2~@singleLight`11`0`2~@singleLight`17`0`2~@singleLight`18`0`2~@doNothing`0`2~@singleLight`25`0`2~@singleLight`26`0`2~@singleLight`27`0`0~@doNothing`0`2~@singleLight`148`0`2~@audioSrc`3`0',0),(9,1,1,'Leave','','F','@roomLightScene`9`4~@singleLight`24`100`0~@videoSrc`9`0',0),(26,1,1,'Leave','','F','',0),(4,1,1,'Leave','','F','',0),(5,1,1,'Leave','','F','',0),(6,1,1,'Leave','','F','@roomLightScene`6`4~@videoSrc`6`0~@audioSrc`6`0',0),(7,1,1,'Leave','','F','',0),(17,1,1,'Leave','','F','',0),(18,1,1,'Leave','','F','',0),(22,1,1,'Leave','','F','',0),(23,1,1,'Leave','','F','',0),(24,1,1,'Leave','','F','',0),(25,1,1,'Leave','','F','',0),(27,1,1,'Leave','','F','',0),(8,1,1,'Leave','','F','',0),(11,1,1,'Leave','','F','',0),(12,1,1,'Leave','','F','',0),(13,1,1,'Leave','','F','@roomLightScene`13`4~@videoSrc`13`0',0),(14,1,1,'Leave','','F','',0),(15,1,1,'Leave','','F','',0),(19,1,1,'Leave','','F','',0),(20,1,1,'Leave','','F','',0),(21,1,1,'Leave','','F','',0),(9,2,1,'Enter','','F','@roomLightScene`9`1',0),(2,2,1,'Enter','','F','@roomLightScene`2`1~@paging`2`0',0),(1,2,1,'Enter','','F','@singleLight`34`100`2~@paging`1`1',0),(10,2,1,'Enter','','F','@roomLightScene`10`1~@paging`10`1',0),(9,3,1,'Movie On','','F','@singleLight`20`0`25~@singleLight`21`0`25~@singleLight`22`100`0~@singleLight`23`0`25~@singleLight`30`25`25~@singleLight`98`100`2~@singleLight`24`0`0~@videoSrc`9`9',0),(9,4,1,'Movie Off','','F','@roomLightScene`9`2~@singleLight`24`100`0~@videoSrc`9`0~@audioSrc`9`0',0),(2,5,1,'Game','','F','@paging`2`0~@bfSittingVG`1',0),(1,7,0,'1st Floor Party On','','F','@roomLightScene`1`1~@singleLight`34`100`2~@singleLight`35`100`2~@singleLight`36`100`2~@singleLight`37`100`2~@singleLight`38`100`0~@singleLight`39`100`2',0),(2,7,0,'1st Floor Party On','','F','@roomLightScene`2`1~@singleLight`12`100`2~@singleLight`13`100`2~@singleLight`14`100`2~@singleLight`15`100`2~@singleLight`16`100`2~@singleLight`29`100`2~@audioSrc`2`5',0),(3,7,0,'1st Floor Party On','','F','@roomLightScene`3`1~@singleLight`10`100`2~@singleLight`11`100`2~@singleLight`17`100`2~@singleLight`18`100`2~@singleLight`25`100`2~@singleLight`26`100`2~@singleLight`27`100`2~@singleLight`148`100`2',0),(4,7,0,'1st Floor Party On','','F','@singleLight`40`100`2~@singleLight`41`100`2~@singleLight`42`0`0~@audioSrc`4`5',0),(5,7,0,'1st Floor Party On','','F','@singleLight`48`100`2~@singleLight`49`100`2~@singleLight`50`100`2~@singleLight`51`100`2~@singleLight`52`100`2~@singleLight`153`100`2~@singleLight`154`100`2~@audioSrc`5`5',0),(6,7,0,'1st Floor Party On','','F','@singleLight`65`100`2~@singleLight`66`100`2~@singleLight`67`100`2~@singleLight`68`100`2~@singleLight`70`100`2~@singleLight`77`100`2~@singleLight`78`100`2~@singleLight`79`100`2~@singleLight`80`100`2~@singleLight`81`100`2~@singleLight`82`100`2~@singleLight`91`100`2~@audioSrc`6`5',0),(7,7,0,'1st Floor Party On','','F','@singleLight`53`100`2~@singleLight`54`100`2~@singleLight`55`100`2~@singleLight`56`100`2~@singleLight`57`100`2~@singleLight`58`100`0~@singleLight`83`100`2~@singleLight`88`100`2~@singleLight`89`100`0~@singleLight`90`100`2',0),(8,7,0,'1st Floor Party On','','F','',0),(9,7,0,'1st Floor Party On','','F','@singleLight`20`100`2~@singleLight`21`100`2~@singleLight`22`100`2~@singleLight`23`100`2~@singleLight`30`100`2~@singleLight`98`100`2',0),(10,7,0,'1st Floor Party On','','F','@roomLightScene`10`1~@singleLight`31`100`0~@singleLight`33`100`2~@singleLight`149`100`0',0),(11,7,0,'1st Floor Party On','','F','',0),(12,7,0,'1st Floor Party On','','F','@singleLight`110`100`2~@singleLight`111`100`2~@singleLight`112`100`2',0),(13,7,0,'1st Floor Party On','','F','',0),(14,7,0,'1st Floor Party On','','F','',0),(15,7,0,'1st Floor Party On','','F','',0),(16,7,0,'1st Floor Party On','','F','@singleLight`1`100`2~@singleLight`2`100`2',0),(17,7,0,'1st Floor Party On','','F','',0),(18,7,0,'1st Floor Party On','','F','@audioSrc`18`5',0),(19,7,0,'1st Floor Party On','','F','@singleLight`129`0`0',0),(20,7,0,'1st Floor Party On','','F','',0),(21,7,0,'1st Floor Party On','','F','@singleLight`139`100`2~@singleLight`143`100`2',0),(22,7,0,'1st Floor Party On','','F','@singleLight`125`100`2~@singleLight`151`100`2~@audioSrc`22`5',0),(23,7,0,'1st Floor Party On','','F','@singleLight`61`100`2~@singleLight`62`100`2~@singleLight`63`100`2~@singleLight`64`100`2~@audioSrc`23`5',0),(24,7,0,'1st Floor Party On','','F','@singleLight`69`100`2~@singleLight`71`100`2~@singleLight`72`100`2~@singleLight`73`100`2~@singleLight`74`100`2~@singleLight`75`100`2~@singleLight`76`100`2~@audioSrc`24`5',0),(25,7,0,'1st Floor Party On','','F','@singleLight`43`100`2~@singleLight`44`100`2~@singleLight`45`100`2~@singleLight`46`100`2~@singleLight`47`100`2~@singleLight`59`100`2~@singleLight`60`100`2~@singleLight`152`100`2~@audioSrc`25`5',0),(26,7,0,'1st Floor Party On','','F','',0),(27,7,0,'1st Floor Party On','','F','',0),(28,7,0,'1st Floor Party On','','F','@singleLight`3`100`2~@singleLight`4`100`2~@singleLight`5`100`2~@singleLight`6`100`2~@singleLight`7`100`2~@singleLight`8`100`2~@singleLight`9`100`2~@singleLight`28`100`2',0),(29,7,0,'1st Floor Party On','','F','@singleLight`119`100`2~@singleLight`120`100`2~@singleLight`121`100`2~@singleLight`122`100`2~@singleLight`123`100`2~@singleLight`124`100`2~@singleLight`150`100`2',0),(1,8,0,'Goodnight','','F','@singleLight`34`0`2~@singleLight`35`0`2~@singleLight`36`0`2~@singleLight`37`0`2~@singleLight`38`0`0~@singleLight`39`0`2~@videoSrc`1`0~@audioSrc`1`0',0),(2,8,0,'Goodnight','','F','@singleLight`12`0`2~@singleLight`13`0`2~@singleLight`14`0`2~@singleLight`15`0`2~@singleLight`16`0`2~@videoSrc`2`0~@audioSrc`2`0',0),(3,8,0,'Goodnight','','F','@singleLight`10`0`2~@singleLight`11`0`2~@singleLight`17`0`2~@singleLight`18`0`2~@singleLight`25`0`2~@singleLight`26`0`2~@singleLight`27`0`0~@singleLight`148`0`2~@audioSrc`3`0',0),(4,8,0,'Goodnight','','F','@singleLight`40`0`2~@singleLight`41`0`2~@singleLight`42`0`0~@videoSrc`4`0~@audioSrc`4`0',0),(5,8,0,'Goodnight','','F','@singleLight`48`0`2~@singleLight`49`0`2~@singleLight`50`0`2~@singleLight`51`0`2~@singleLight`52`0`2~@videoSrc`5`0~@audioSrc`5`0',0),(6,8,0,'Goodnight','','F','@singleLight`65`0`2~@singleLight`66`0`2~@singleLight`67`0`2~@singleLight`68`0`2~@singleLight`77`0`2~@singleLight`78`0`2~@singleLight`79`0`2~@singleLight`80`0`2~@singleLight`81`0`2~@singleLight`82`0`2~@singleLight`91`0`2~@videoSrc`6`0~@audioSrc`6`0',0),(7,8,0,'Goodnight','','F','@singleLight`56`0`2~@singleLight`57`0`2~@singleLight`58`0`0~@singleLight`83`0`2~@singleLight`88`0`2~@singleLight`89`0`0~@singleLight`90`0`2',0),(8,8,0,'Goodnight','','F','@singleLight`115`0`2~@singleLight`116`0`2~@singleLight`118`0`2~@videoSrc`8`0~@audioSrc`8`0',0),(9,8,0,'Goodnight','','F','@roomLightScene`9`4~@singleLight`20`0`2~@singleLight`21`0`2~@singleLight`22`0`2~@singleLight`23`0`2~@singleLight`30`0`2~@singleLight`98`0`2~@videoSrc`9`0~@audioSrc`9`0',0),(10,8,0,'Goodnight','','F','@singleLight`31`0`0~@singleLight`33`0`2~@singleLight`149`0`0~@audioSrc`10`0',0),(11,8,0,'Goodnight','','F','@videoSrc`11`0~@audioSrc`11`0',0),(12,8,0,'Goodnight','','F','@singleLight`110`0`2~@singleLight`111`0`2~@singleLight`112`0`2~@singleLight`113`0`0~@videoSrc`12`0~@audioSrc`12`0',0),(13,8,0,'Goodnight','','F','@videoSrc`13`0~@audioSrc`13`0',0),(14,8,0,'Goodnight','','F','@singleLight`105`0`2~@singleLight`106`0`2~@singleLight`107`0`2~@audioSrc`14`0',0),(15,8,0,'Goodnight','','F','@singleLight`108`0`2~@singleLight`109`0`2~@audioSrc`15`0',0),(16,8,0,'Goodnight','','F','@roomLightScene`16`4~@singleLight`1`0`2~@singleLight`2`0`2~@audioSrc`16`0',0),(17,8,0,'Goodnight','','F','@singleLight`84`0`2~@audioSrc`17`0',0),(18,8,0,'Goodnight','','F','@audioSrc`18`0',0),(19,8,0,'Goodnight','','F','@singleLight`126`75`2~@audioSrc`19`0',0),(20,8,0,'Goodnight','','F','@singleLight`117`0`2~@singleLight`133`0`2~@singleLight`134`0`2~@singleLight`135`0`0~@singleLight`136`0`2~@singleLight`137`0`2~@singleLight`138`0`0~@audioSrc`20`0',0),(21,8,0,'Goodnight','','F','@singleLight`139`0`2~@singleLight`140`0`2~@singleLight`141`0`0~@singleLight`142`0`2~@singleLight`143`0`2~@singleLight`144`0`2~@singleLight`145`0`2~@singleLight`146`0`0~@singleLight`147`0`2~@audioSrc`21`0',0),(22,8,0,'Goodnight','','F','@singleLight`125`0`2~@audioSrc`22`0',0),(23,8,0,'Goodnight','','F','@singleLight`61`0`2~@singleLight`62`0`2~@singleLight`63`0`2~@singleLight`64`0`2~@audioSrc`23`0',0),(24,8,0,'Goodnight','','F','@singleLight`74`0`2~@singleLight`75`0`2~@singleLight`76`0`2~@audioSrc`24`0',0),(25,8,0,'Goodnight','','F','@singleLight`43`0`2~@singleLight`44`0`2~@singleLight`45`0`2~@singleLight`46`0`2~@singleLight`47`0`2~@singleLight`59`0`2~@singleLight`60`0`2~@videoSrc`25`0~@audioSrc`25`0',0),(26,8,0,'Goodnight','','F','',0),(27,8,0,'Goodnight','','F','@singleLight`32`0`2~@singleLight`99`0`2~@singleLight`100`0`2~@singleLight`101`0`2~@singleLight`102`0`2~@singleLight`103`0`0~@singleLight`104`0`2~@videoSrc`27`0~@audioSrc`27`0',0),(28,8,0,'Goodnight','','F','@singleLight`3`0`2~@singleLight`4`0`2~@singleLight`5`0`2~@singleLight`6`0`2~@singleLight`7`0`2~@singleLight`8`0`2~@singleLight`9`0`2~@singleLight`28`0`2',0),(29,8,0,'Goodnight','','F','@singleLight`119`20`2~@singleLight`120`20`2~@singleLight`121`20`2~@singleLight`122`0`2~@singleLight`123`20`2~@singleLight`124`20`2',0),(1,9,0,'1st Floor Party Off','','F','@singleLight`34`0`2~@singleLight`35`0`2~@singleLight`36`0`2~@singleLight`37`0`2~@singleLight`38`0`0~@singleLight`39`0`2~@videoSrc`1`0~@audioSrc`1`0',0),(2,9,0,'1st Floor Party Off','','F','@singleLight`12`0`2~@singleLight`13`0`2~@singleLight`14`0`2~@singleLight`15`0`2~@singleLight`16`0`2~@singleLight`29`0`2~@videoSrc`2`0~@audioSrc`2`0',0),(3,9,0,'1st Floor Party Off','','F','@singleLight`10`0`2~@singleLight`11`0`2~@singleLight`17`0`2~@singleLight`18`0`2~@singleLight`25`0`2~@singleLight`26`0`2~@singleLight`27`0`2~@singleLight`148`0`2~@audioSrc`3`0',0),(4,9,0,'1st Floor Party Off','','F','@audioSrc`4`0',0),(5,9,0,'1st Floor Party Off','','F','@singleLight`48`100`2~@singleLight`49`100`2~@singleLight`50`100`2~@singleLight`51`100`2~@singleLight`52`100`2~@singleLight`153`100`2~@singleLight`154`100`2~@audioSrc`5`0',0),(6,9,0,'1st Floor Party Off','','F','@singleLight`65`100`2~@singleLight`66`100`2~@singleLight`67`100`2~@singleLight`68`100`2~@singleLight`70`100`2~@singleLight`77`100`2~@singleLight`78`100`2~@singleLight`79`100`2~@singleLight`80`100`2~@singleLight`81`100`2~@singleLight`82`100`2~@singleLight`91`100`2~@audioSrc`6`0',0),(7,9,0,'1st Floor Party Off','','F','@singleLight`53`100`2~@singleLight`54`100`2~@singleLight`55`100`2~@singleLight`58`0`0~@singleLight`83`100`2~@singleLight`89`0`0',0),(8,9,0,'1st Floor Party Off','','F','@audioSrc`8`0',0),(9,9,0,'1st Floor Party Off','','F','@singleLight`20`0`2~@singleLight`21`0`2~@singleLight`22`0`2~@singleLight`23`0`2~@singleLight`30`0`2~@singleLight`98`0`2~@videoSrc`9`0~@audioSrc`9`0',0),(10,9,0,'1st Floor Party Off','','F','@singleLight`31`0`0~@singleLight`33`0`2~@singleLight`149`0`0~@audioSrc`10`0',0),(11,9,0,'1st Floor Party Off','','F','@audioSrc`11`0',0),(12,9,0,'1st Floor Party Off','','F','@singleLight`110`100`2~@singleLight`111`100`2~@singleLight`112`100`2~@singleLight`113`100`0~@audioSrc`12`0',0),(13,9,0,'1st Floor Party Off','','F','@audioSrc`13`0',0),(14,9,0,'1st Floor Party Off','','F','@audioSrc`14`0',0),(15,9,0,'1st Floor Party Off','','F','@audioSrc`15`0',0),(16,9,0,'1st Floor Party Off','','F','@singleLight`1`0`2~@singleLight`2`0`2~@videoSrc`16`0~@audioSrc`16`0',0),(17,9,0,'1st Floor Party Off','','F','@audioSrc`17`0',0),(18,9,0,'1st Floor Party Off','','F','@audioSrc`18`0',0),(19,9,0,'1st Floor Party Off','','F','@audioSrc`19`0',0),(20,9,0,'1st Floor Party Off','','F','@audioSrc`20`0',0),(21,9,0,'1st Floor Party Off','','F','@audioSrc`21`0',0),(22,9,0,'1st Floor Party Off','','F','@singleLight`125`100`2~@singleLight`151`100`2~@audioSrc`22`0',0),(23,9,0,'1st Floor Party Off','','F','@singleLight`61`0`2~@singleLight`62`0`2~@singleLight`63`0`2~@singleLight`64`0`2~@audioSrc`23`0',0),(24,9,0,'1st Floor Party Off','','F','@singleLight`69`0`2~@singleLight`71`0`2~@singleLight`72`0`2~@singleLight`73`0`2~@singleLight`74`0`2~@singleLight`75`0`2~@singleLight`76`0`2~@audioSrc`24`0',0),(25,9,0,'1st Floor Party Off','','F','@singleLight`43`0`2~@singleLight`44`0`2~@singleLight`45`0`2~@singleLight`46`0`2~@singleLight`47`0`2~@singleLight`59`0`2~@singleLight`60`0`2~@singleLight`152`0`2~@audioSrc`25`0',0),(26,9,0,'1st Floor Party Off','','F','',0),(27,9,0,'1st Floor Party Off','','F','@audioSrc`27`0',0),(28,9,0,'1st Floor Party Off','','F','@singleLight`3`0`2~@singleLight`4`0`2~@singleLight`5`0`2~@singleLight`6`0`2~@singleLight`7`0`2~@singleLight`8`0`2~@singleLight`9`0`2~@singleLight`28`0`2',0),(29,9,0,'1st Floor Party Off','','F','',0),(13,2,1,'Dave Shower','','F','@roomLightScene`13`1~@videoSrc`13`2~@changeChannel`2`2`173',0),(28,1,1,'Leave','','F','@singleLight`5`0`2~@singleLight`6`0`2~@singleLight`7`0`2~@singleLight`8`0`2~@singleLight`9`0`2',0),(8,2,1,'Sleep Temp','','F','@roomTemp`13`67`70`3`A',0),(8,3,1,'Wake Temp','','F','@roomTemp`13`68`76`0`A',0),(16,2,1,'Enter','','F','@roomLightScene`16`1',0),(6,2,1,'Enter','','F','@roomLightScene`6`2',0),(5,2,1,'Anna TV','','F','@videoSrc`5`3~@changeChannel`2`3`197',0),(29,1,1,'Morning lights','A1-90','F','@singleLight`119`0`2~@singleLight`120`0`2~@singleLight`121`0`2~@singleLight`122`0`2~@singleLight`123`0`2~@singleLight`124`0`2~@singleLight`150`0`2',0),(30,1,1,'Enter','','F','@roomLightScene`30`2',0),(30,2,1,'Leave','','F','@roomLightScene`30`4~@audioSrc`30`0',0);
/*!40000 ALTER TABLE `mode` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `modeLog`
--

DROP TABLE IF EXISTS `modeLog`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `modeLog` (
  `when` datetime NOT NULL,
  `who` varchar(25) NOT NULL,
  `room` int(11) NOT NULL,
  `slot` int(11) NOT NULL,
  `what` varchar(35) NOT NULL
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `modeLog`
--

LOCK TABLES `modeLog` WRITE;
/*!40000 ALTER TABLE `modeLog` DISABLE KEYS */;
INSERT INTO `modeLog` VALUES ('2012-07-18 10:25:53','mpullin',9,1,'Actions changed'),('2012-07-18 10:26:48','mpullin',9,2,'Actions changed'),('2012-07-18 10:45:15','mpullin',9,1,'Actions changed'),('2012-07-18 10:45:28','mpullin',9,2,'Actions changed'),('2012-07-18 10:46:35','mpullin',2,1,'Actions changed'),('2012-07-18 10:50:14','mpullin',2,2,'Actions changed'),('2012-07-18 10:50:38','mpullin',3,1,'Actions changed'),('2012-07-18 10:52:36','mpullin',1,1,'Actions changed'),('2012-07-18 10:52:44','mpullin',1,1,'Actions changed'),('2012-07-18 10:52:54','mpullin',1,2,'Actions changed'),('2012-07-18 10:53:31','mpullin',10,1,'Actions changed'),('2012-07-19 09:11:00','mkrenger',10,1,'Actions changed'),('2012-07-19 09:12:23','mkrenger',10,2,'Actions changed'),('2012-07-19 09:12:59','mkrenger',10,1,'Actions changed'),('2012-07-19 09:13:17','mkrenger',10,2,'Actions changed'),('2012-07-19 09:37:46','mkrenger',10,1,'Actions changed'),('2012-07-19 10:20:25','mkrenger',10,1,'Actions changed'),('2012-07-19 10:58:06','mkrenger',10,2,'Actions changed'),('2012-07-19 10:58:25','mkrenger',10,1,'Actions changed'),('2012-07-19 12:34:15','mkrenger',10,2,'Actions changed'),('2012-07-23 11:20:34','mpullin',1,1,'Actions changed'),('2012-07-23 11:20:46','mpullin',1,2,'Actions changed'),('2012-08-01 09:59:19','mkrenger',9,3,'Renamed: Movie'),('2012-08-01 15:33:51','mkrenger',9,1,'Actions changed'),('2012-08-01 16:07:42','mkrenger',9,3,'Actions changed'),('2012-08-01 16:07:57','mkrenger',9,3,'Renamed: Movie On'),('2012-08-01 16:09:05','mkrenger',9,4,'Actions changed'),('2012-08-01 16:09:20','mkrenger',9,4,'Actions changed'),('2012-08-01 16:09:40','mkrenger',9,3,'Actions changed'),('2012-08-01 16:13:34','mkrenger',9,3,'Actions changed'),('2012-08-01 16:15:07','mkrenger',9,4,'Actions changed'),('2012-08-01 16:32:36','mkrenger',9,3,'Actions changed'),('2012-08-02 12:28:22','mpullin',2,5,'Actions changed'),('2012-08-02 12:28:38','mpullin',2,2,'Actions changed'),('2012-08-02 12:28:50','mpullin',2,1,'Actions changed'),('2012-08-02 12:35:45','mpullin',2,5,'Actions changed'),('2012-08-02 15:45:04','mkrenger',9,3,'Actions changed'),('2012-08-02 15:46:23','mkrenger',9,3,'Actions changed'),('2012-08-02 15:52:37','mkrenger',9,3,'Actions changed'),('2012-08-02 15:53:44','mkrenger',9,4,'Actions changed'),('2012-08-03 12:29:02','mpullin',2,5,'Deleted'),('2012-08-03 17:41:58','mpullin',10,2,'Actions changed'),('2012-08-03 17:42:14','mpullin',10,1,'Actions changed'),('2012-08-03 17:42:33','mpullin',10,1,'Actions changed'),('2012-08-03 17:42:41','mpullin',10,2,'Actions changed'),('2012-08-03 17:42:58','mpullin',1,2,'Actions changed'),('2012-08-03 17:43:06','mpullin',1,1,'Actions changed'),('2012-08-03 17:43:26','mpullin',1,1,'Actions changed'),('2012-08-03 17:44:23','mpullin',2,2,'Actions changed'),('2012-08-03 17:44:47','mpullin',2,2,'Actions changed'),('2012-08-03 17:49:25','mpullin',1,2,'Actions changed'),('2012-08-03 17:49:37','mpullin',1,1,'Actions changed'),('2012-08-03 17:49:53','mpullin',2,2,'Actions changed'),('2012-08-03 17:50:03','mpullin',2,1,'Actions changed'),('2012-08-03 17:50:26','mpullin',3,1,'Actions changed'),('2012-08-03 17:50:54','mpullin',9,2,'Actions changed'),('2012-08-03 17:51:31','mpullin',9,1,'Actions changed'),('2012-08-03 18:31:11','mpullin',10,2,'Actions changed'),('2012-08-03 18:31:45','mpullin',10,1,'Actions changed'),('2012-08-03 18:32:02','mpullin',1,2,'Actions changed'),('2012-08-03 18:32:28','mpullin',1,1,'Actions changed'),('2012-08-03 18:32:52','mpullin',2,2,'Actions changed'),('2012-08-03 18:33:14','mpullin',2,1,'Actions changed'),('2012-08-03 18:33:37','mpullin',2,5,'Actions changed'),('2012-08-03 18:34:13','mpullin',9,2,'Actions changed'),('2012-08-03 18:34:29','mpullin',9,1,'Actions changed'),('2012-08-03 18:35:11','mpullin',10,1,'Actions changed'),('2012-08-03 18:37:54','mpullin',3,1,'Actions changed'),('2012-08-03 18:40:40','mpullin',3,1,'Actions changed'),('2012-08-03 18:40:55','mpullin',2,2,'Actions changed'),('2012-08-03 18:41:10','mpullin',2,1,'Actions changed'),('2012-08-06 11:23:37','mkrenger',9,1,'Actions changed'),('2012-08-06 11:23:57','mkrenger',9,2,'Actions changed'),('2012-08-06 12:44:05','mkrenger',1,8,'Actions changed'),('2012-08-06 12:45:04','mkrenger',1,7,'Renamed: 1st Floor Party Mode'),('2012-08-06 12:51:45','mkrenger',1,7,'Actions changed'),('2012-08-06 13:03:23','mkrenger',1,8,'Actions changed'),('2012-08-06 13:06:27','mkrenger',1,7,'Actions changed'),('2012-08-06 13:08:27','mkrenger',22,2,'Deleted'),('2012-08-06 15:08:38','mkrenger',1,7,'Actions changed'),('2012-08-06 15:09:36','mkrenger',1,7,'Renamed: 1st Floor Party On'),('2012-08-06 15:15:16','mkrenger',1,9,'Actions changed'),('2012-08-06 15:17:18','mkrenger',1,8,'Actions changed'),('2012-08-06 16:07:19','mkrenger',10,2,'Actions changed'),('2012-08-06 16:14:20','mkrenger',1,8,'Actions changed'),('2012-08-06 16:19:46','mkrenger',1,8,'Actions changed'),('2012-08-06 17:06:16','mkrenger',1,8,'Actions changed'),('2012-08-06 17:29:08','mkrenger',1,10,'Deleted'),('2012-08-07 09:38:33','mkrenger',2,1,'Actions changed'),('2012-08-07 09:38:44','mkrenger',2,2,'Actions changed'),('2012-08-07 09:41:02','mkrenger',9,1,'Actions changed'),('2012-08-07 09:41:15','mkrenger',9,2,'Actions changed'),('2012-08-07 10:43:02','mkrenger',9,2,'Actions changed'),('2012-08-07 10:49:04','mkrenger',9,1,'Actions changed'),('2012-08-07 10:49:16','mkrenger',9,2,'Actions changed'),('2012-08-07 10:50:21','mkrenger',9,3,'Actions changed'),('2012-08-07 10:53:19','mkrenger',9,2,'Actions changed'),('2012-08-07 10:53:37','mkrenger',9,2,'Actions changed'),('2012-08-07 10:54:15','mkrenger',9,1,'Actions changed'),('2012-08-07 11:42:17','mkrenger',2,2,'Actions changed'),('2012-08-07 11:42:33','mkrenger',2,1,'Actions changed'),('2012-08-07 11:43:31','mkrenger',1,2,'Actions changed'),('2012-08-07 11:43:44','mkrenger',1,1,'Actions changed'),('2012-08-07 11:44:15','mkrenger',10,1,'Actions changed'),('2012-08-07 12:40:04','mpullin',9,2,'Actions changed'),('2012-08-07 16:14:44','mkrenger',9,3,'Actions changed'),('2012-08-07 16:15:01','mkrenger',9,4,'Actions changed'),('2012-08-07 17:23:06','mkrenger',10,1,'Actions changed'),('2012-08-07 17:23:56','mkrenger',1,1,'Actions changed'),('2012-08-07 17:25:22','mkrenger',2,1,'Actions changed'),('2012-08-07 17:27:23','mkrenger',9,3,'Actions changed'),('2012-08-07 17:27:42','mkrenger',9,3,'Actions changed'),('2012-08-07 17:35:34','mkrenger',9,1,'Actions changed'),('2012-08-08 08:32:36','jplatt',9,4,'Actions changed'),('2012-08-31 10:14:16','mkrenger',9,1,'Actions changed'),('2012-08-31 10:17:25','mkrenger',1,8,'Actions changed'),('2012-08-31 10:53:10','mkrenger',9,3,'Actions changed'),('2012-08-31 10:53:46','mkrenger',9,4,'Actions changed'),('2012-08-31 15:52:57','mkrenger',2,4,'Deleted'),('2012-09-05 08:49:22','dbraun',2,1,'Actions changed'),('2012-09-05 08:58:32','dbraun',2,0,'Reordered Modes'),('2012-09-05 09:05:11','dbraun',1,7,'Override: 0'),('2012-09-05 21:22:04','dbraun',13,2,'Actions changed'),('2012-09-09 21:51:49','dbraun',13,1,'Actions changed'),('2012-09-11 14:33:47','mkrenger',28,1,'Renamed: Bath On'),('2012-09-11 14:37:27','mkrenger',28,2,'Actions changed'),('2012-09-11 14:37:56','mkrenger',28,1,'Actions changed'),('2012-09-11 14:42:12','mkrenger',28,2,'Actions changed'),('2012-09-11 14:47:56','mkrenger',28,2,'Actions changed'),('2012-09-11 14:59:02','mkrenger',28,2,'Actions changed'),('2012-09-11 15:02:02','mkrenger',28,2,'Actions changed'),('2012-09-11 15:04:51','mkrenger',28,2,'Actions changed'),('2012-09-11 15:07:11','mkrenger',28,2,'Actions changed'),('2012-09-11 15:26:25','mkrenger',28,2,'Actions changed'),('2012-09-11 15:26:34','mkrenger',28,2,'Deleted'),('2012-09-11 15:36:47','mpullin',28,1,'Renamed: Leave'),('2012-09-11 15:37:40','mpullin',28,1,'Actions changed'),('2012-09-12 17:10:22','mkrenger',13,1,'Actions changed'),('2012-09-12 17:22:45','mkrenger',13,1,'Actions changed'),('2012-09-16 15:07:28','dbraun',1,7,'Actions changed'),('2012-11-06 22:12:22','dbraun',8,2,'Actions changed'),('2012-11-06 22:13:09','dbraun',8,3,'Actions changed'),('2012-11-06 22:13:21','dbraun',8,2,'Renamed: Sleep Temp'),('2012-11-06 22:13:32','dbraun',8,3,'Renamed: Wake Temp'),('2012-11-07 16:20:41','mkrenger',16,2,'Actions changed'),('2012-11-07 16:21:10','mkrenger',16,1,'Actions changed'),('2012-11-07 16:51:03','mkrenger',6,2,'Actions changed'),('2012-11-07 16:52:39','mkrenger',6,2,'Actions changed'),('2012-11-08 06:59:55','dbraun',8,3,'Actions changed'),('2012-11-08 15:00:24','mkrenger',6,1,'Actions changed'),('2012-11-08 15:00:39','mkrenger',6,1,'Actions changed'),('2012-11-08 15:01:03','mkrenger',6,2,'Actions changed'),('2012-11-11 23:16:02','dbraun',5,2,'Actions changed'),('2013-01-03 14:38:17','mpullin',6,1,'Actions changed'),('2013-02-05 22:27:27','mkrenger',2,2,'Actions changed'),('2013-02-07 17:40:26','mkrenger',1,2,'Actions changed'),('2013-02-07 17:46:00','mkrenger',1,1,'Actions changed'),('2013-04-12 21:53:04','dbraun',1,7,'Actions changed'),('2013-04-12 21:59:26','dbraun',1,9,'Actions changed'),('2013-06-21 22:20:17','dbraun',29,1,'Actions changed'),('2013-06-21 22:21:07','dbraun',29,1,'Schedule changed'),('2013-06-21 22:21:30','dbraun',29,1,'Actions changed'),('2013-09-29 18:38:39','dbraun',1,7,'Actions changed'),('2013-12-05 19:07:37','mkrenger',6,3,'Deleted'),('2013-12-05 19:08:32','mkrenger',30,1,'Actions changed'),('2013-12-05 19:09:03','mkrenger',30,2,'Actions changed'),('2013-12-06 15:43:22','mkrenger',30,2,'Actions changed'),('2014-12-12 13:34:02','mlandis',1,8,'Actions changed'),('2014-12-12 13:36:00','mlandis',1,8,'Actions changed'),('2014-12-12 13:37:40','mlandis',1,8,'Actions changed'),('2014-12-12 13:40:05','mlandis',1,8,'Actions changed'),('2014-12-12 13:40:49','mlandis',1,8,'Actions changed'),('2014-12-12 13:41:18','mlandis',1,8,'Actions changed'),('2014-12-12 13:41:44','mlandis',1,8,'Actions changed'),('2014-12-12 13:42:16','mlandis',1,8,'Actions changed'),('2015-03-17 01:46:58','dbraun',1,7,'Actions changed'),('2015-05-29 14:45:52','mlandis',1,6,'Actions changed'),('2015-05-29 20:36:34','mkrenger',1,7,'Actions changed');
/*!40000 ALTER TABLE `modeLog` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `monitoring`
--

DROP TABLE IF EXISTS `monitoring`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `monitoring` (
  `index` smallint(6) NOT NULL,
  `name` varchar(50) DEFAULT 'Something',
  `type` varchar(1) NOT NULL,
  `addr` varchar(15) NOT NULL,
  `sub_addr` varchar(100) DEFAULT NULL,
  KEY `index` (`index`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `monitoring`
--

LOCK TABLES `monitoring` WRITE;
/*!40000 ALTER TABLE `monitoring` DISABLE KEYS */;
/*!40000 ALTER TABLE `monitoring` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `monitoringLog`
--

DROP TABLE IF EXISTS `monitoringLog`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `monitoringLog` (
  `when` datetime NOT NULL,
  `what` smallint(6) NOT NULL,
  `data` varchar(10) NOT NULL DEFAULT '0'
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `monitoringLog`
--

LOCK TABLES `monitoringLog` WRITE;
/*!40000 ALTER TABLE `monitoringLog` DISABLE KEYS */;
/*!40000 ALTER TABLE `monitoringLog` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `occupancySensor`
--

DROP TABLE IF EXISTS `occupancySensor`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `occupancySensor` (
  `index` int(11) NOT NULL,
  `name` varchar(30) NOT NULL DEFAULT 'A Sensor',
  `LSIP_Occ` varchar(256) NOT NULL DEFAULT '{[@doNothing`]}',
  `LSIP_Unocc` varchar(256) NOT NULL DEFAULT '{[@doNothing`]}'
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `occupancySensor`
--

LOCK TABLES `occupancySensor` WRITE;
/*!40000 ALTER TABLE `occupancySensor` DISABLE KEYS */;
INSERT INTO `occupancySensor` VALUES (1,'Exercise Sensor','{&L0101,!G07..[@roomLiv`01`02]}','{&!L0101.,!G07..[@roomLiv`01`01]}'),(2,'Sports Court Sensor','{&L0110,!G07..[@roomLiv`10`02]}','{&!L0110.,!G07..[@roomLiv`10`01]}'),(3,'Theater Sensor','{&L0109,!G07..[@roomLiv`09`02]@singleLight`22`100`0}','{L0109[@singleLight`22`0`0]!G07.[@roomLiv`09`01]}'),(4,'BF Sitting Sensor','{&L0102,!G07..[@roomLiv`02`02]}','{&!L0102.,!G07..[@roomLiv`02`01]}'),(5,'Golf Sim Sensor','{[@roomLiv`16`02]}','{[@roomLiv`16`01]}'),(6,'Game Room Sensor','{[@singleLight`29`100`0~@singleLight`28`100`0]}','{[@singleLight`29`0`0]}'),(7,'Kitchen Sensor','{!U.[@roomLightScene`6`2]}','{[@roomLightScene`6`4]}');
/*!40000 ALTER TABLE `occupancySensor` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `phone`
--

DROP TABLE IF EXISTS `phone`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `phone` (
  `mac_addr` varchar(12) NOT NULL DEFAULT '1A1A1A1A1A1A',
  `ip_addr` varchar(15) NOT NULL DEFAULT '10.1.10.94',
  `model_name` varchar(20) NOT NULL DEFAULT 'snom820',
  `install_loc` varchar(30) NOT NULL DEFAULT 'Somewhere',
  `default_room` int(11) NOT NULL DEFAULT '1',
  `rooms_control` varchar(255) NOT NULL DEFAULT '1.2.3',
  `house_control` tinyint(1) NOT NULL DEFAULT '1',
  `mutes_audio` tinyint(1) NOT NULL DEFAULT '1',
  `obeys_dnd` tinyint(1) NOT NULL DEFAULT '1'
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `phone`
--

LOCK TABLES `phone` WRITE;
/*!40000 ALTER TABLE `phone` DISABLE KEYS */;
/*!40000 ALTER TABLE `phone` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `room`
--

DROP TABLE IF EXISTS `room`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `room` (
  `index` int(11) NOT NULL,
  `floor` int(11) NOT NULL DEFAULT '1',
  `name` varchar(25) NOT NULL,
  `ao` tinyint(4) DEFAULT NULL,
  `vo` tinyint(4) DEFAULT NULL,
  `tstat` tinyint(4) DEFAULT NULL,
  `vol_TURNON` smallint(3) NOT NULL DEFAULT '50',
  `vol_MAX` smallint(3) NOT NULL DEFAULT '85',
  `lutron_LightKP` varchar(20) DEFAULT NULL,
  `lutron_LSIPKP` varchar(20) DEFAULT NULL,
  `lutron_ShadeKP` varchar(20) DEFAULT NULL,
  `ao_pan` smallint(6) NOT NULL DEFAULT '0',
  `ao_eq` varchar(50) NOT NULL DEFAULT '0 0 0 0 0 0 0 0 0 0',
  `maplocX` smallint(3) NOT NULL DEFAULT '999',
  `maplocY` smallint(3) NOT NULL DEFAULT '999',
  `occupancy_sensor` smallint(6) NOT NULL DEFAULT '0',
  `amp` smallint(2) NOT NULL DEFAULT '0',
  PRIMARY KEY (`index`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `room`
--

LOCK TABLES `room` WRITE;
/*!40000 ALTER TABLE `room` DISABLE KEYS */;
INSERT INTO `room` VALUES (1,1,'Exercise Room',1,1,17,15,85,'298','256',NULL,0,'0 0 0 0 0 0 0 0 0 0',234,138,1,0),(2,2,'Basement Sitting',2,3,3,15,95,'301',NULL,NULL,0,'0 0 0 0 0 0 0 0 0 0',363,110,4,0),(3,2,'Billiards Room',2,NULL,3,15,85,'303',NULL,NULL,0,'0 0 0 0 0 0 0 0 0 0',480,110,6,0),(4,3,'Screen Porch',3,5,19,15,85,'307',NULL,NULL,0,'0 0 0 0 0 0 0 0 0 0',29,51,0,0),(5,3,'Family Room',4,7,10,15,95,'308',NULL,NULL,0,'0 0 0 0 0 0 0 0 0 0',175,61,0,0),(6,3,'Kitchen/Sitting',5,8,6,15,85,'309',NULL,NULL,0,'0 0 0 0 0 0 0 0 0 0',385,90,7,0),(7,3,'1F Halls',NULL,NULL,5,50,85,'310',NULL,NULL,0,'0 0 0 0 0 0 0 0 0 0',156,160,0,0),(8,4,'Master Bedroom',6,10,13,15,95,'317',NULL,NULL,0,'0 0 0 0 0 0 0 0 0 0',349,50,0,0),(9,2,'Theater',7,13,4,50,100,'300',NULL,NULL,0,'0 0 0 0 0 0 0 0 0 0',196,91,3,1),(10,1,'Sports Court',8,NULL,1,15,85,'297',NULL,NULL,0,'0 0 0 0 0 0 0 0 0 0',408,140,2,0),(11,4,'Laundry Room',9,11,NULL,15,85,NULL,NULL,NULL,0,'0 0 0 0 0 0 0 0 0 0',488,103,0,0),(12,4,'Master Sitting',10,9,13,15,85,'318',NULL,NULL,0,'0 0 0 0 0 0 0 0 0 0',248,108,0,0),(13,4,'Master Shower',18,12,13,15,85,'315',NULL,NULL,0,'-100 -75 -75 -85 -85 -85 -90 -85 -80 -110',84,21,0,0),(14,4,'Dressing Room',10,NULL,13,15,85,'319',NULL,NULL,0,'0 0 0 0 0 0 0 0 0 0',132,201,0,0),(15,4,'Her Closet',10,NULL,16,15,85,'320',NULL,NULL,0,'0 0 0 0 0 0 0 0 0 0',142,293,0,0),(16,2,'Golf Sim',11,14,3,15,90,'305',NULL,NULL,0,'0 0 0 0 0 0 0 0 0 0',357,249,5,0),(17,3,'Garage',12,NULL,9,15,85,'311',NULL,NULL,0,'0 0 0 0 0 0 0 0 0 0',672,169,0,0),(18,5,'Exterior',13,NULL,NULL,15,95,'299',NULL,NULL,0,'0 0 0 0 0 0 0 0 0 0',491,320,0,0),(19,4,'Matthew\'s Room',14,NULL,11,15,85,'321','83',NULL,0,'0 0 0 0 0 0 0 0 0 0',349,279,0,0),(20,4,'Nicholas\' Room',15,NULL,15,15,85,'322','89',NULL,0,'0 0 0 0 0 0 0 0 0 0',648,46,0,0),(21,4,'Anna\'s Room',16,NULL,14,15,85,'323','94',NULL,0,'0 0 0 0 0 0 0 0 0 0',661,185,0,0),(22,3,'Foyer',17,NULL,7,15,85,'312',NULL,NULL,0,'0 0 0 0 0 0 0 0 0 0',237,263,0,0),(23,3,'Living Room',17,NULL,7,15,85,'313',NULL,NULL,0,'0 0 0 0 0 0 0 0 0 0',139,304,0,0),(24,3,'Dining Room',17,NULL,7,15,85,'314',NULL,NULL,0,'0 0 0 0 0 0 0 0 0 0',343,290,0,0),(25,3,'Library/Office',19,6,8,15,85,'316','0','0',0,'0 0 0 0 0 0 0 0 0 0',29,166,0,0),(26,2,'Equipment Room',NULL,NULL,18,50,85,'0',NULL,NULL,0,'0 0 0 0 0 0 0 0 0 0',649,305,0,0),(27,4,'Master Bathroom',10,NULL,13,15,85,'302','85',NULL,0,'0 0 0 0 0 0 0 0 0 0',154,109,0,0),(28,2,'Guest Suite',NULL,NULL,2,15,85,'306',NULL,NULL,0,'0 0 0 0 0 0 0 0 0 0',149,287,0,0),(29,4,'2F Halls',NULL,NULL,12,50,85,'324',NULL,NULL,0,'0 0 0 0 0 0 0 0 0 0',389,176,0,0),(30,3,'Nicholle\'s Office',20,15,20,15,85,'350','0','0',0,'0 0 0 0 0 0 0 0 0 0',631,2,0,0);
/*!40000 ALTER TABLE `room` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `securityEvent`
--

DROP TABLE IF EXISTS `securityEvent`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `securityEvent` (
  `index` int(11) NOT NULL,
  `name` varchar(32) NOT NULL DEFAULT 'Event',
  `partition` int(11) NOT NULL DEFAULT '1',
  `event_data` varchar(8) NOT NULL DEFAULT '1000:???',
  `LSIP` varchar(75) NOT NULL
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `securityEvent`
--

LOCK TABLES `securityEvent` WRITE;
/*!40000 ALTER TABLE `securityEvent` DISABLE KEYS */;
/*!40000 ALTER TABLE `securityEvent` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `securityKeypad`
--

DROP TABLE IF EXISTS `securityKeypad`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `securityKeypad` (
  `index` int(11) NOT NULL,
  `name` varchar(32) NOT NULL DEFAULT 'Keypad',
  `partition` int(11) NOT NULL DEFAULT '1',
  PRIMARY KEY (`index`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `securityKeypad`
--

LOCK TABLES `securityKeypad` WRITE;
/*!40000 ALTER TABLE `securityKeypad` DISABLE KEYS */;
/*!40000 ALTER TABLE `securityKeypad` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `securityPartition`
--

DROP TABLE IF EXISTS `securityPartition`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `securityPartition` (
  `index` int(11) NOT NULL,
  `name` varchar(30) NOT NULL DEFAULT 'Main'
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `securityPartition`
--

LOCK TABLES `securityPartition` WRITE;
/*!40000 ALTER TABLE `securityPartition` DISABLE KEYS */;
/*!40000 ALTER TABLE `securityPartition` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `securityUser`
--

DROP TABLE IF EXISTS `securityUser`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `securityUser` (
  `index` int(3) NOT NULL,
  `name` varchar(30) NOT NULL DEFAULT 'Username',
  `myLivSystem_user` int(11) DEFAULT NULL,
  KEY `index` (`index`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `securityUser`
--

LOCK TABLES `securityUser` WRITE;
/*!40000 ALTER TABLE `securityUser` DISABLE KEYS */;
/*!40000 ALTER TABLE `securityUser` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `securityZone`
--

DROP TABLE IF EXISTS `securityZone`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `securityZone` (
  `index` int(11) NOT NULL,
  `partition` tinyint(4) NOT NULL DEFAULT '1',
  `name` varchar(40) NOT NULL,
  `type` tinyint(4) NOT NULL DEFAULT '0',
  `LSIP` varchar(100) NOT NULL,
  `floor` int(11) NOT NULL DEFAULT '1',
  `maplocX` smallint(3) NOT NULL DEFAULT '999',
  `maplocY` smallint(3) NOT NULL DEFAULT '999',
  PRIMARY KEY (`index`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `securityZone`
--

LOCK TABLES `securityZone` WRITE;
/*!40000 ALTER TABLE `securityZone` DISABLE KEYS */;
INSERT INTO `securityZone` VALUES (1,1,'Screen Porch',1,'',3,999,999),(2,1,'Library Window',3,'',3,0,187),(3,1,'Master Sitting Window',3,'',4,265,81),(4,1,'Matthew Doors',1,'',4,376,360),(5,1,'Dining Window',3,'',3,376,360),(6,1,'Breakfast Window',3,'',3,372,0),(7,1,'Library Doors',1,'',3,37,151),(8,1,'Master Bed Windows',3,'',4,405,75),(9,1,'Anna Bathroom Windows',3,'',4,678,304),(10,1,'Billiards Windows',3,'',2,488,54),(12,1,'His Closet',3,'',4,464,116),(14,1,'Master Bed Windows',3,'',4,344,73),(15,1,'Exercise Window',3,'',1,263,74),(16,1,'Matthew Windows',3,'',4,421,321),(17,1,'Kitchen Window',3,'',3,485,56),(18,1,'Mud Room Windows',3,'',3,470,284),(20,1,'Living Room Windows',3,'',3,156,360),(22,1,'Hall to Garage',1,'',3,622,263),(23,1,'Anna Window',3,'',4,999,999),(24,1,'Mud Room Door',1,'',3,581,323),(25,1,'Family Room Window',3,'',3,201,36),(26,1,'Laundry Window?',3,'',4,535,99),(27,1,'Front Door',1,'',3,245,346),(28,1,'Master Bath Door',3,'',4,234,147),(29,1,'Family Door W',1,'',3,114,73),(30,1,'Family Door NW',1,'',3,147,47),(31,1,'Family Door NE',1,'',3,265,54),(32,1,'Master Bed Balcony',1,'',4,359,6),(33,1,'Garage Left Up',0,'',3,999,999),(34,1,'Nicholas Window',3,'',4,999,999),(35,1,'Master Bath Window',3,'',4,207,81),(37,1,'Garage Right Up',0,'',3,999,999),(38,1,'Garage Left Down',0,'',3,999,999),(39,1,'Garage Center Up',0,'',3,999,999),(40,1,'Nicholas Window',3,'',4,643,45),(41,1,'Breakfast Door E',1,'',3,321,20),(42,1,'Breakfast Door W',1,'',3,420,25),(43,1,'Guest Bed Window',3,'',2,100,300),(44,1,'Her Closet Window',3,'',4,170,360),(45,1,'Garage Right Down',0,'',3,999,999),(46,1,'Garage Center Down',0,'',3,999,999),(47,1,'Theater Window',3,'',2,213,39),(48,1,'Her Closet Window',3,'',4,123,267),(49,1,'Theater Glass',4,'',2,208,98),(50,1,'Guest Bed Glass',4,'',2,170,267),(51,1,'Library Glass',4,'',3,23,223),(52,1,'Kitchen Glass',4,'',3,452,65),(53,1,'Mud Hall Glass',4,'',3,534,278),(54,1,'Family Room Glass',4,'',3,166,79),(55,1,'Breakfast Glass',4,'',3,371,49),(56,1,'Garage Glass',4,'',3,663,64),(57,1,'Billiards Glass',4,'',2,492,105),(58,1,'Guest Bed Glass',4,'',2,170,340),(59,1,'Exercise Glass',4,'',1,268,134),(60,1,'Dining Room Glass',4,'',3,361,320),(61,1,'Living Room Glass',4,'',3,172,319),(62,1,'Garage Hall Motion',2,'',3,595,137),(63,1,'Foyer Motion',2,'',3,299,321),(64,1,'Basement Stair Motion',2,'',2,543,205),(65,1,'2F Hall Motion',2,'',4,539,220),(66,1,'Exercise Motion',2,'',1,312,225),(67,1,'Upper Foyer Motion',2,'',4,197,233),(68,1,'Library Hall Motion',2,'',3,141,194),(69,1,'Family Room Motion',2,'',3,190,128),(70,1,'Garage East Window',3,'',3,679,328),(36,1,'PR 2 Window',3,'',3,567,51),(76,1,'Screen Porch GB',4,'',3,56,56),(78,1,'Nicholle\'s Office GB',4,'',3,640,5),(79,1,'Nicholle\'s Office DC',1,'',3,560,5),(77,1,'Nicholle\'s Office WC',0,'',3,710,5),(73,1,'Screen Porch WC',3,'',3,27,107);
/*!40000 ALTER TABLE `securityZone` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `shadeScene`
--

DROP TABLE IF EXISTS `shadeScene`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `shadeScene` (
  `addr` varchar(20) NOT NULL,
  `slot` int(2) NOT NULL,
  `name` varchar(30) NOT NULL
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `shadeScene`
--

LOCK TABLES `shadeScene` WRITE;
/*!40000 ALTER TABLE `shadeScene` DISABLE KEYS */;
/*!40000 ALTER TABLE `shadeScene` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `system`
--

DROP TABLE IF EXISTS `system`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `system` (
  `project_name` varchar(30) DEFAULT NULL,
  `max_localModes` tinyint(4) NOT NULL DEFAULT '5',
  `max_globalModes` tinyint(4) NOT NULL DEFAULT '10',
  `max_livEvents` int(4) NOT NULL DEFAULT '5',
  `max_lights` int(3) NOT NULL DEFAULT '100',
  `max_securityZones` int(3) NOT NULL DEFAULT '50',
  `max_climateZones` int(3) NOT NULL DEFAULT '25',
  `max_water` int(3) NOT NULL DEFAULT '15',
  `override_default` tinyint(1) NOT NULL DEFAULT '0',
  `location` varchar(35) DEFAULT NULL,
  `location_lat` decimal(10,6) NOT NULL DEFAULT '41.837050',
  `location_long` decimal(10,6) NOT NULL DEFAULT '87.684960',
  `zipcode` varchar(5) NOT NULL,
  `controlSystem_TYPE` varchar(16) NOT NULL DEFAULT 'AMX',
  `climate_TYPE` varchar(6) NOT NULL DEFAULT 'APRIL',
  `controlSystem_ADDR` varchar(25) NOT NULL DEFAULT '69.211.168.243',
  `install_date` varchar(20) DEFAULT NULL,
  `version` int(1) NOT NULL DEFAULT '2',
  `HVAC_deadband` tinyint(1) NOT NULL DEFAULT '3',
  `energy_URL` varchar(50) DEFAULT NULL,
  `calendar_URL` varchar(120) DEFAULT NULL,
  `tigerpaw` int(4) DEFAULT NULL,
  `sandbox_mode` tinyint(1) NOT NULL DEFAULT '1'
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `system`
--

LOCK TABLES `system` WRITE;
/*!40000 ALTER TABLE `system` DISABLE KEYS */;
INSERT INTO `system` VALUES ('The Braun Residence',5,10,15,175,75,25,15,0,'Lake Forest, IL',42.224720,-87.832285,'60045','AMX','APRIL','so5042.dyndns.org',NULL,3,3,NULL,NULL,5042,0);
/*!40000 ALTER TABLE `system` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `themes`
--

DROP TABLE IF EXISTS `themes`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `themes` (
  `index` tinyint(2) NOT NULL,
  `file_name` varchar(15) DEFAULT 'none',
  `english_name` varchar(15) DEFAULT NULL,
  PRIMARY KEY (`index`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `themes`
--

LOCK TABLES `themes` WRITE;
/*!40000 ALTER TABLE `themes` DISABLE KEYS */;
INSERT INTO `themes` VALUES (1,'bluegreen','Blue-Green'),(2,'greenbay','Packers'),(3,'clouds','Clouds'),(4,'drops','Drops'),(5,'leaf','Leaf'),(6,'royal','Blue Wallpaper'),(7,'waves','Blue Wave'),(8,'wood','Wood'),(9,'grass','Blades of Grass');
/*!40000 ALTER TABLE `themes` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `ui`
--

DROP TABLE IF EXISTS `ui`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `ui` (
  `index` int(11) NOT NULL DEFAULT '1',
  `device_number` varchar(12) NOT NULL DEFAULT '10000',
  `model_name` varchar(20) NOT NULL DEFAULT 'Touchpanel',
  `wifi` tinyint(1) NOT NULL DEFAULT '1',
  `install_loc` varchar(30) NOT NULL DEFAULT 'Somewhere',
  `default_room` int(11) NOT NULL DEFAULT '1',
  `rooms_control` varchar(255) NOT NULL DEFAULT '1.2.3',
  `house_control` tinyint(1) NOT NULL DEFAULT '1',
  `security_control` tinyint(1) NOT NULL DEFAULT '1',
  `settings_control` tinyint(1) NOT NULL DEFAULT '1',
  `caller_id_control` tinyint(1) NOT NULL DEFAULT '1'
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `ui`
--

LOCK TABLES `ui` WRITE;
/*!40000 ALTER TABLE `ui` DISABLE KEYS */;
INSERT INTO `ui` VALUES (1,'10001','MXD-1000',0,'Master Bed inwall',8,'1.2.3.4.5.6.7.8.9.10.11.12.13.14.15.16.17.18.19.20.21.22.23.24.25.26.27.28.29.30',1,1,1,1),(2,'10002','MXD-1000',0,'Mud Room inwall',7,'1.2.3.4.5.6.7.8.9.10.11.12.13.14.15.16.17.18.19.20.21.22.23.24.25.26.27.28.29.30',1,1,1,1),(3,'10003','iPad',1,'Exercise iPad',1,'1.2.3.4.5.6.7.8.9.10.11.12.13.14.15.16.17.18.19.20.21.22.23.24.25.26.27.28.29.30',1,1,1,1),(4,'10004','MXD-700',0,'Basement Sitting inwall',2,'1.2.3.4.5.6.7.8.9.10.11.12.13.14.15.16.17.18.19.20.21.22.23.24.25.26.27.28.29.30',1,1,1,1),(5,'10005','MXD-700',0,'1F Sitting inwall',6,'1.2.3.4.5.6.7.8.9.10.11.12.13.14.15.16.17.18.19.20.21.22.23.24.25.26.27.28.29.30',1,1,1,1),(6,'10006','NXD-500i',0,'Rack',26,'1.2.3.4.5.6.7.8.9.10.11.12.13.14.15.16.17.18.19.20.21.22.23.24.25.26.27.28.29.30',1,1,1,1),(7,'10041','MIO-R4',0,'Exercise R4',1,'1',0,0,1,1),(8,'10042','MIO-R4',0,'Screen Porch R4',4,'4',0,0,1,1),(9,'10043','MIO-R4',0,'Family Room R4',5,'5',0,0,1,1),(10,'10044','MIO-R4',0,'1F Sitting R4',6,'6',0,0,1,1),(11,'10045','MIO-R4',0,'Master Bed R4',8,'8',0,0,1,1),(12,'10046','MIO-R4',0,'Master Sitting R4',12,'12',0,0,1,1),(13,'10047','MIO-R4',0,'Laundry Room R4',11,'11',0,0,1,1),(14,'10048','MIO-R4',0,'Library R4',25,'25',0,0,1,1),(15,'10091','U1',0,'Shower RTI',13,'13',0,0,0,0),(16,'11001','iPad',1,'Billiards iPad',2,'1.2.3.4.5.6.7.8.9.10.11.12.13.14.15.16.17.18.19.20.21.22.23.24.25.26.27.28.29.30',1,1,1,1),(17,'11002','iPad',1,'Family Room iPad',5,'1.2.3.4.5.6.7.8.9.10.11.12.13.14.15.16.17.18.19.20.21.22.23.24.25.26.27.28.29.30',1,1,1,1),(18,'11003','iPad',1,'Theater iPad',9,'1.2.3.4.5.6.7.8.9.10.11.12.13.14.15.16.17.18.19.20.21.22.23.24.25.26.27.28.29.30',1,1,1,1),(19,'11004','iPad',1,'Library iPad',25,'1.2.3.4.5.6.7.8.9.10.11.12.13.14.15.16.17.18.19.20.21.22.23.24.25.26.27.28.29.30',1,1,1,1),(20,'11005','iPad',1,'Master Bath iPad',27,'1.2.3.4.5.6.7.8.9.10.11.12.13.14.15.16.17.18.19.20.21.22.23.24.25.26.27.28.29.30',1,1,1,1),(21,'10030','NXV-300',0,'Virtual TP',26,'1.2.3.4.5.6.7.8.9.10.11.12.13.14.15.16.17.18.19.20.21.22.23.24.25.26.27.28.29.30',1,1,1,1),(22,'10049','MIO-R4',0,'Nicholle\'s Office R4',30,'30',0,0,1,1),(23,'10007','MXD-700',1,'Nicholle\'s Office Inwall',30,'1.2.3.4.5.6.7.8.9.10.11.12.13.14.15.16.17.18.19.20.21.22.23.24.25.26.27.28.29.30',1,1,1,1);
/*!40000 ALTER TABLE `ui` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `videoAvail`
--

DROP TABLE IF EXISTS `videoAvail`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `videoAvail` (
  `src` tinyint(4) NOT NULL,
  `room` tinyint(4) NOT NULL
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `videoAvail`
--

LOCK TABLES `videoAvail` WRITE;
/*!40000 ALTER TABLE `videoAvail` DISABLE KEYS */;
INSERT INTO `videoAvail` VALUES (15,1),(15,2),(15,4),(15,5),(15,6),(15,8),(15,11),(15,12),(15,27),(15,25),(14,1),(14,2),(14,4),(14,5),(14,6),(14,8),(14,11),(14,12),(14,27),(14,25),(13,1),(13,2),(13,4),(13,5),(13,6),(13,8),(16,9),(13,11),(13,12),(13,27),(13,25),(12,1),(12,2),(12,4),(12,5),(12,6),(12,8),(15,9),(12,11),(12,12),(12,27),(12,25),(11,1),(11,2),(11,4),(11,5),(11,6),(11,8),(14,9),(11,11),(11,12),(11,27),(11,25),(10,1),(10,2),(10,4),(10,5),(10,6),(10,8),(13,9),(10,11),(10,12),(10,27),(10,25),(9,25),(15,13),(9,12),(9,11),(9,9),(9,8),(9,6),(9,5),(9,4),(9,2),(9,1),(8,1),(8,2),(8,4),(8,5),(8,6),(8,8),(8,9),(8,11),(8,12),(8,27),(8,25),(7,1),(7,2),(7,4),(7,5),(7,6),(7,8),(7,9),(7,11),(7,12),(7,27),(7,25),(6,1),(6,2),(6,4),(6,5),(6,6),(6,8),(6,9),(6,11),(6,12),(6,27),(6,25),(5,1),(5,2),(5,4),(5,5),(5,6),(5,8),(5,9),(5,11),(5,12),(5,27),(5,25),(4,1),(4,2),(4,4),(4,5),(4,6),(4,8),(4,9),(4,11),(4,12),(4,27),(4,25),(3,1),(3,2),(3,4),(3,5),(3,6),(3,8),(3,9),(3,11),(3,12),(3,27),(3,25),(2,1),(2,2),(2,4),(2,5),(2,6),(2,8),(2,9),(2,11),(2,12),(2,27),(2,25),(1,25),(14,13),(1,12),(1,11),(1,9),(1,8),(1,6),(1,5),(1,4),(1,2),(13,13),(12,13),(11,13),(10,13),(9,13),(8,13),(7,13),(6,13),(5,13),(4,13),(3,13),(2,13),(1,13),(1,1),(1,16),(2,16),(3,16),(4,16),(5,16),(6,16),(7,16),(8,16),(9,16),(10,16),(11,16),(12,16),(13,16),(14,16),(15,16),(15,30),(14,30),(13,30),(12,30),(11,30),(10,30),(9,30),(8,30),(7,30),(6,30),(5,30),(4,30),(3,30),(2,30),(1,30);
/*!40000 ALTER TABLE `videoAvail` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `videoChannel`
--

DROP TABLE IF EXISTS `videoChannel`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `videoChannel` (
  `type` varchar(10) NOT NULL,
  `value` smallint(7) NOT NULL,
  `name` varchar(10) NOT NULL,
  `sort` tinyint(1) NOT NULL DEFAULT '9',
  `description` varchar(40) DEFAULT NULL
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `videoChannel`
--

LOCK TABLES `videoChannel` WRITE;
/*!40000 ALTER TABLE `videoChannel` DISABLE KEYS */;
INSERT INTO `videoChannel` VALUES ('DIRECTV',2,'2',2,'WBBM'),('DIRECTV',5,'5',2,'WMAQ'),('DIRECTV',7,'7',2,'WLS'),('DIRECTV',9,'9',2,'WGN '),('DIRECTV',11,'11',2,'WTTW'),('DIRECTV',13,'13',2,'WOCK'),('DIRECTV',20,'20',2,'WYCC'),('DIRECTV',23,'23',2,'WWME'),('DIRECTV',26,'26',2,'WCIU'),('DIRECTV',32,'32',2,'WFLD'),('DIRECTV',38,'38',2,'ION '),('DIRECTV',44,'44',2,'WSNS'),('DIRECTV',50,'50',2,'WPWR'),('DIRECTV',56,'56',2,'WYIN'),('DIRECTV',60,'60',2,'WXFT'),('DIRECTV',62,'62',2,'WJYS'),('DIRECTV',70,'70',2,'HBO HD '),('DIRECTV',71,'71',2,'Showtime HD '),('DIRECTV',72,'72',2,'ESPN2HD '),('DIRECTV',73,'73',2,'ESPNHD '),('DIRECTV',74,'74',2,'Universal HD '),('DIRECTV',75,'75',2,'TNT HD '),('DIRECTV',76,'76',2,'HD Theater '),('DIRECTV',77,'77',2,'HD Lineup Information '),('DIRECTV',78,'78',2,'HDNet Movies '),('DIRECTV',79,'79',2,'HDNet '),('DIRECTV',80,'80',2,'CBS East HD '),('DIRECTV',82,'82',2,'NBC East HD '),('DIRECTV',86,'86',2,'ABC East HD '),('DIRECTV',88,'88',2,'FOX East HD '),('DIRECTV',89,'89',2,'Cable Response Television '),('DIRECTV',100,'100',2,'Pay-per-view previews '),('DIRECTV',101,'101',2,'The 101 '),('DIRECTV',101,'101',2,'The 101 HD '),('DIRECTV',102,'102',2,'DirecTV News Mix '),('DIRECTV',103,'103',2,'Songs of Praise'),('DIRECTV',104,'104',2,'DirecTV Sports Mix '),('DIRECTV',105,'105',2,'DirecTV Mix Information Channel '),('DIRECTV',110,'110',2,'DirecTV Game Lounge '),('DIRECTV',111,'111',2,'Access Magazine Offer '),('DIRECTV',112,'112',2,'DirecTV Basics '),('DIRECTV',114,'114',2,'DirecTV Customer Support '),('DIRECTV',200,'200',2,'Watch Pay Per View Previews Here! '),('DIRECTV',202,'202',2,'CNN '),('DIRECTV',202,'202',2,'CNN HD '),('DIRECTV',204,'204',2,'HLN '),('DIRECTV',205,'205',2,'DirecTV Sports Mix '),('DIRECTV',206,'206',2,'ESPN '),('DIRECTV',206,'206',2,'ESPN HD '),('DIRECTV',207,'207',2,'ESPNEWS '),('DIRECTV',207,'207',2,'ESPNEWS HD '),('DIRECTV',208,'208',2,'ESPN Classic '),('DIRECTV',209,'209',2,'ESPN2 '),('DIRECTV',209,'209',2,'ESPN2 HD '),('DIRECTV',210,'210',2,'ESPN Alternate '),('DIRECTV',211,'211',2,'ESPN2 Alternate '),('DIRECTV',212,'212',2,'NFL Network '),('DIRECTV',212,'212',2,'NFL Network HD '),('DIRECTV',213,'213',2,'MLB Network '),('DIRECTV',213,'213',2,'MLB Network HD '),('DIRECTV',215,'215',2,'NHL Network '),('DIRECTV',215,'215',2,'NHL Network HD '),('DIRECTV',217,'217',2,'Tennis Channel '),('DIRECTV',217,'217',2,'Tennis Channel HD '),('DIRECTV',218,'218',2,'The Golf Channel '),('DIRECTV',218,'218',2,'The Golf Channel HD '),('DIRECTV',221,'221',2,'WIZE '),('DIRECTV',222,'222',2,'DTV '),('DIRECTV',223,'223',2,'Celebrity Shopping Network '),('DIRECTV',224,'224',2,'Direct Shopping Network'),('DIRECTV',225,'225',2,'Paid Programming '),('DIRECTV',226,'226',2,'Liquidation Channel '),('DIRECTV',227,'227',2,'Paid Programming '),('DIRECTV',228,'228',2,'Gem Shopping Network '),('DIRECTV',229,'229',2,'HGTV '),('DIRECTV',229,'229',2,'HGTV HD '),('DIRECTV',230,'230',2,'DIY Network '),('DIRECTV',231,'231',2,'Food Network '),('DIRECTV',231,'231',2,'Food Network HD '),('DIRECTV',232,'232',2,'Fine Living '),('DIRECTV',233,'233',2,'Gems TV '),('DIRECTV',235,'235',2,'Style Network '),('DIRECTV',236,'236',2,'E! '),('DIRECTV',237,'237',2,'TV Guide Network '),('DIRECTV',238,'238',2,'ReelzChannel '),('DIRECTV',240,'240',2,'HSN '),('DIRECTV',241,'241',2,'Spike '),('DIRECTV',241,'241',2,'Spike HD '),('DIRECTV',242,'242',2,'USA Network '),('DIRECTV',242,'242',2,'USA Network HD '),('DIRECTV',243,'243',2,'Cable Response Television '),('DIRECTV',244,'244',2,'Sci Fi '),('DIRECTV',244,'244',2,'Sci Fi HD '),('DIRECTV',245,'245',2,'TNT '),('DIRECTV',245,'245',2,'TNT HD '),('DIRECTV',246,'246',2,'Tru TV '),('DIRECTV',247,'247',2,'TBS '),('DIRECTV',247,'247',2,'TBS HD '),('DIRECTV',248,'248',2,'FX '),('DIRECTV',248,'248',2,'FX HD '),('DIRECTV',249,'249',2,'Comedy Central '),('DIRECTV',250,'250',2,'Fox Reality '),('DIRECTV',251,'251',2,'Oxygen '),('DIRECTV',252,'252',2,'Lifetime '),('DIRECTV',253,'253',2,'Lifetime Movie Network '),('DIRECTV',254,'254',2,'AMC '),('DIRECTV',255,'255',2,'MGM HD '),('DIRECTV',256,'256',2,'TCM '),('DIRECTV',257,'257',2,'Chiller '),('DIRECTV',258,'258',2,'Fox Movie Channel '),('DIRECTV',259,'259',2,'Universal HD '),('DIRECTV',260,'260',2,'WE tv '),('DIRECTV',261,'261',2,'FitTV '),('DIRECTV',262,'262',2,'SOAPnet '),('DIRECTV',263,'263',2,'Game Lounge '),('DIRECTV',264,'264',2,'BBC America '),('DIRECTV',265,'265',2,'A&E '),('DIRECTV',265,'265',2,'A&E HD '),('DIRECTV',266,'266',2,'bio. '),('DIRECTV',266,'266',2,'bio. HD '),('DIRECTV',267,'267',2,'Smithsonian Channel HD '),('DIRECTV',268,'268',2,'Interactive Response Television '),('DIRECTV',269,'269',2,'History '),('DIRECTV',269,'269',2,'History HD '),('DIRECTV',271,'271',2,'History International '),('DIRECTV',272,'272',2,'Logo '),('DIRECTV',273,'273',2,'Bravo '),('DIRECTV',273,'273',2,'Bravo HD '),('DIRECTV',274,'274',2,'Ovation TV '),('DIRECTV',275,'275',2,'Crime & Investigation Network HD '),('DIRECTV',276,'276',2,'National Geographic Channel '),('DIRECTV',276,'276',2,'National Geographic Channel HD '),('DIRECTV',277,'277',2,'Travel Channel '),('DIRECTV',278,'278',2,'Discovery Channel '),('DIRECTV',278,'278',2,'Discovery Channel HD '),('DIRECTV',279,'279',2,'Discovery Health Channel '),('DIRECTV',280,'280',2,'TLC '),('DIRECTV',280,'280',2,'TLC HD '),('DIRECTV',281,'281',2,'HD Theater '),('DIRECTV',282,'282',2,'Animal Planet '),('DIRECTV',282,'282',2,'Animal Planet HD '),('DIRECTV',283,'283',2,'NASA TV '),('DIRECTV',284,'284',2,'Science Channel '),('DIRECTV',284,'284',2,'Science Channel HD '),('DIRECTV',285,'285',2,'Investigation Discovery '),('DIRECTV',286,'286',2,'Planet Green '),('DIRECTV',286,'286',2,'Planet Green HD '),('DIRECTV',287,'287',2,'Military Channel '),('DIRECTV',289,'289',2,'Game Lounge '),('DIRECTV',290,'290',2,'Disney Channel East '),('DIRECTV',290,'290',2,'Disney Channel HD East '),('DIRECTV',291,'291',2,'Disney Channel West '),('DIRECTV',292,'292',2,'Toon Disney '),('DIRECTV',292,'292',2,'Toon Disney HD '),('DIRECTV',293,'293',2,'BabyFirst TV '),('DIRECTV',294,'294',2,'Discovery Kids '),('DIRECTV',295,'295',2,'PBS KIDS Sprout '),('DIRECTV',296,'296',2,'Cartoon Network East '),('DIRECTV',296,'296',2,'Cartoon Network HD East '),('DIRECTV',297,'297',2,'Cartoon Network West '),('DIRECTV',298,'298',2,'Boomerang '),('DIRECTV',299,'299',2,'Nickelodeon East '),('DIRECTV',299,'299',2,'Nickelodeon HD East '),('DIRECTV',300,'300',2,'Nickelodeon West '),('DIRECTV',301,'301',2,'Noggin '),('DIRECTV',302,'302',2,'Nicktoons Network '),('DIRECTV',303,'303',2,'The N '),('DIRECTV',304,'304',2,'TV Land '),('DIRECTV',305,'305',2,'ION '),('DIRECTV',306,'306',2,'HDNet '),('DIRECTV',307,'307',2,'WGN America '),('DIRECTV',308,'308',2,'Sleuth '),('DIRECTV',309,'309',2,'GSN '),('DIRECTV',310,'310',2,'G4 '),('DIRECTV',311,'311',2,'ABC Family '),('DIRECTV',311,'311',2,'ABC Family HD '),('DIRECTV',312,'312',2,'Hallmark Channel '),('DIRECTV',313,'313',2,'Jewelry Television '),('DIRECTV',314,'314',2,'Cable Response Television '),('DIRECTV',315,'315',2,'Paid Programming '),('DIRECTV',316,'316',2,'ShopNBC '),('DIRECTV',317,'317',2,'QVC '),('DIRECTV',318,'318',2,'BUY '),('DIRECTV',319,'319',2,'Paid Programming '),('DIRECTV',320,'320',2,'VALUEnow '),('DIRECTV',321,'321',2,'Buy Plus '),('DIRECTV',322,'322',2,'Corner Store TV '),('DIRECTV',323,'323',2,'Uplift TV '),('DIRECTV',324,'324',2,'America\'s Auction Network '),('DIRECTV',325,'325',2,'Artists and Fans Network '),('DIRECTV',326,'326',2,'GAC '),('DIRECTV',327,'327',2,'CMT '),('DIRECTV',327,'327',2,'CMT HD '),('DIRECTV',328,'328',2,'TV One '),('DIRECTV',329,'329',2,'BET '),('DIRECTV',330,'330',2,'BET J '),('DIRECTV',331,'331',2,'MTV '),('DIRECTV',331,'331',2,'MTV HD '),('DIRECTV',332,'332',2,'Palladia '),('DIRECTV',333,'333',2,'MTV2 '),('DIRECTV',335,'335',2,'VH1 '),('DIRECTV',335,'335',2,'VH1 HD '),('DIRECTV',337,'337',2,'VH1 Classic '),('DIRECTV',338,'338',2,'Gospel Music Channel '),('DIRECTV',339,'339',2,'Fuse '),('DIRECTV',340,'340',2,'Infomercials '),('DIRECTV',345,'345',2,'RFD-TV '),('DIRECTV',350,'350',2,'C-SPAN '),('DIRECTV',351,'351',2,'C-SPAN2 '),('DIRECTV',352,'352',2,'DirecTV News Mix '),('DIRECTV',353,'353',2,'Bloomberg Television '),('DIRECTV',355,'355',2,'CNBC '),('DIRECTV',355,'355',2,'CNBC HD+ '),('DIRECTV',356,'356',2,'MSNBC '),('DIRECTV',357,'357',2,'CNBC World '),('DIRECTV',358,'358',2,'Current TV '),('DIRECTV',359,'359',2,'Fox Business Network '),('DIRECTV',359,'359',2,'Fox Business Network HD '),('DIRECTV',360,'360',2,'Fox News Channel '),('DIRECTV',360,'360',2,'Fox News Channel HD '),('DIRECTV',362,'362',2,'The Weather Channel '),('DIRECTV',362,'362',2,'The Weather Channel HD '),('DIRECTV',364,'364',2,'INSP '),('DIRECTV',365,'365',2,'GOD TV '),('DIRECTV',367,'367',2,'World Harvest Television '),('DIRECTV',369,'369',2,'Daystar '),('DIRECTV',370,'370',2,'EWTN '),('DIRECTV',371,'371',2,'The Church Channel '),('DIRECTV',372,'372',2,'Trinity Broadcasting Network '),('DIRECTV',373,'373',2,'Word Network '),('DIRECTV',374,'374',2,'BYU Television '),('DIRECTV',375,'375',2,'Link TV '),('DIRECTV',376,'376',2,'CTN '),('DIRECTV',377,'377',2,'Tri-State Christian Television '),('DIRECTV',378,'378',2,'National Religious Broadcasters '),('DIRECTV',401,'401',2,'Shop Latino TV '),('DIRECTV',402,'402',2,'Univision (east) '),('DIRECTV',403,'403',2,'Univision (west) '),('DIRECTV',404,'404',2,'Galavisi?n '),('DIRECTV',405,'405',2,'Mega TV '),('DIRECTV',406,'406',2,'Telemundo (east) '),('DIRECTV',407,'407',2,'Telemundo (west) '),('DIRECTV',408,'408',2,'TV Chile '),('DIRECTV',409,'409',2,'TV Venezuela '),('DIRECTV',410,'410',2,'Mun2 '),('DIRECTV',411,'411',2,'Telef? Internacional '),('DIRECTV',412,'412',2,'Mexicanal '),('DIRECTV',413,'413',2,'Discovery en Espa?ol '),('DIRECTV',414,'414',2,'WAPA America '),('DIRECTV',415,'415',2,'ONCE M?xico '),('DIRECTV',416,'416',2,'MTV Tr3s '),('DIRECTV',417,'417',2,'Caracol TV '),('DIRECTV',418,'418',2,'Mexico 22 '),('DIRECTV',419,'419',2,'CNN en Espa?ol '),('DIRECTV',420,'420',2,'SUR Mexico '),('DIRECTV',421,'421',2,'Canella/Cable Response Spanish '),('DIRECTV',422,'422',2,'Cine Estelar '),('DIRECTV',423,'423',2,'Cine Latino '),('DIRECTV',424,'424',2,'Cine Nostalgia '),('DIRECTV',425,'425',2,'Fox Sports en Espa?ol '),('DIRECTV',426,'426',2,'GOL TV '),('DIRECTV',427,'427',2,'TyC Sports '),('DIRECTV',428,'428',2,'CATV '),('DIRECTV',429,'429',2,'TeleCentro '),('DIRECTV',430,'430',2,'Latinoamerica TV '),('DIRECTV',431,'431',2,'Telefutura '),('DIRECTV',432,'432',2,'ESPN Deportes '),('DIRECTV',434,'434',2,'Television Dominicana '),('DIRECTV',435,'435',2,'De Todo '),('DIRECTV',436,'436',2,'Discovery en Espa?ol '),('DIRECTV',438,'438',2,'Ecuavisa Internacional '),('DIRECTV',439,'439',2,'SUR Peru '),('DIRECTV',440,'440',2,'V-Me '),('DIRECTV',441,'441',2,'Azteca America '),('DIRECTV',442,'442',2,'Azteca Mexico '),('DIRECTV',443,'443',2,'History en Espa?ol '),('DIRECTV',460,'460',2,'TVE Internacional '),('DIRECTV',461,'461',2,'HITN '),('DIRECTV',450,'450',2,'TVB Jade 1 '),('DIRECTV',451,'451',2,'TVB Jade 2 '),('DIRECTV',453,'453',2,'China Movie Channel '),('DIRECTV',454,'454',2,'CCTV-4 '),('DIRECTV',500,'500',2,'DTV '),('DIRECTV',501,'501',2,'HBO (east) '),('DIRECTV',501,'501',2,'HBO HD (east) '),('DIRECTV',502,'502',2,'HBO2 (east) '),('DIRECTV',503,'503',2,'HBO Signature '),('DIRECTV',504,'504',2,'HBO (west) '),('DIRECTV',504,'504',2,'HBO HD (west) '),('DIRECTV',505,'505',2,'HBO2 (west) '),('DIRECTV',507,'507',2,'HBO Family (east) '),('DIRECTV',508,'508',2,'HBO Family (west) '),('DIRECTV',511,'511',2,'HBO Latino '),('DIRECTV',512,'512',2,'Cinemax (east) '),('DIRECTV',512,'512',2,'Cinemax HD (east) '),('DIRECTV',513,'513',2,'MoreMax '),('DIRECTV',514,'514',2,'Cinemax (west) '),('DIRECTV',514,'514',2,'Cinemax HD (west) '),('DIRECTV',518,'518',2,'Starz Kids & Family HD '),('DIRECTV',519,'519',2,'Starz Comedy HD '),('DIRECTV',520,'520',2,'Starz (east) '),('DIRECTV',520,'520',2,'Starz HD (east) '),('DIRECTV',521,'521',2,'Starz (west) '),('DIRECTV',521,'521',2,'Starz HD (west) '),('DIRECTV',522,'522',2,'Starz Edge '),('DIRECTV',522,'522',2,'Starz Edge HD '),('DIRECTV',523,'523',2,'Starz InBlack '),('DIRECTV',526,'526',2,'Encore (east) '),('DIRECTV',527,'527',2,'Encore (west) '),('DIRECTV',528,'528',2,'Encore Love '),('DIRECTV',529,'529',2,'Encore Westerns '),('DIRECTV',530,'530',2,'Encore Mystery '),('DIRECTV',531,'531',2,'Encore Drama '),('DIRECTV',532,'532',2,'Encore Action '),('DIRECTV',533,'533',2,'Encore WAM '),('DIRECTV',537,'537',2,'Showtime (east) '),('DIRECTV',537,'537',2,'Showtime HD (east) '),('DIRECTV',538,'538',2,'Showtime 2 '),('DIRECTV',538,'538',2,'Showtime 2 HD '),('DIRECTV',539,'539',2,'Showcase '),('DIRECTV',539,'539',2,'Showcase HD '),('DIRECTV',540,'540',2,'Showtime (west) '),('DIRECTV',540,'540',2,'Showtime HD (west) '),('DIRECTV',542,'542',2,'Showtime Extreme '),('DIRECTV',542,'542',2,'Showtime Extreme HD '),('DIRECTV',544,'544',2,'The Movie Channel (east) '),('DIRECTV',544,'544',2,'The Movie Channel HD (east) '),('DIRECTV',545,'545',2,'The Movie Channel (west) '),('DIRECTV',547,'547',2,'Flix '),('DIRECTV',549,'549',2,'Sundance Channel '),('DIRECTV',550,'550',2,'IFC '),('DIRECTV',552,'552',2,'HDNet Movies '),('DIRECTV',589,'589',2,'Playboy TV '),('DIRECTV',590,'590',2,'Playboy TV '),('DIRECTV',591,'591',2,'Adult PPV: Buy 6 Channel Block '),('DIRECTV',592,'592',2,'Adult PPV: Buy 6 Channel Block '),('DIRECTV',593,'593',2,'Club Erotix 6 channel ordering info '),('DIRECTV',594,'594',2,'TEN Clips '),('DIRECTV',595,'595',2,'REAL '),('DIRECTV',596,'596',2,'Juicy Network '),('DIRECTV',597,'597',2,'Fresh! '),('DIRECTV',598,'598',2,'Spice:Xcess '),('DIRECTV',599,'599',2,'Hustler TV '),('DIRECTV',601,'601',2,'NBA TV '),('DIRECTV',601,'601',2,'NBA TV HD '),('DIRECTV',602,'602',2,'TVG '),('DIRECTV',603,'603',2,'Versus '),('DIRECTV',603,'603',2,'Versus HD '),('DIRECTV',606,'606',2,'The Outdoor Channel '),('DIRECTV',607,'607',2,'SPEED '),('DIRECTV',607,'607',2,'SPEED HD '),('DIRECTV',608,'608',2,'Pursuit Channel '),('DIRECTV',610,'610',2,'Big Ten Network '),('DIRECTV',610,'610',2,'Big Ten Network HD '),('DIRECTV',613,'613',2,'CBS College Sports Network '),('DIRECTV',613,'613',2,'CBS College Sports Network HD '),('DIRECTV',614,'614',2,'ESPNU '),('DIRECTV',615,'615',2,'Regional Sports Networks Alternate '),('DIRECTV',616,'616',2,'The Mtn. '),('DIRECTV',617,'617',2,'Fox College Sports '),('DIRECTV',618,'618',2,'Fuel TV '),('DIRECTV',618,'618',2,'Fuel TV HD '),('DIRECTV',619,'619',2,'Fox Soccer Channel '),('DIRECTV',620,'620',2,'GOL TV '),('DIRECTV',621,'621',2,'Setanta Sports North America '),('DIRECTV',622,'622',2,'Setanta Sports North America Alternate '),('DIRECTV',624,'624',2,'Fox Sports en Espa?ol '),('DIRECTV',628,'628',2,'NESN '),('DIRECTV',628,'628',2,'NESN HD '),('DIRECTV',630,'630',2,'Comcast Sports Net New England '),('DIRECTV',630,'630',2,'Comcast Sports Net New England HD '),('DIRECTV',631,'631',2,'YES Network '),('DIRECTV',631,'631',2,'YES Network HD '),('DIRECTV',634,'634',2,'MSG '),('DIRECTV',634,'634',2,'MSG HD '),('DIRECTV',635,'635',2,'MSG Plus '),('DIRECTV',635,'635',2,'MSG Plus HD '),('DIRECTV',636,'636',2,'MSG 2 '),('DIRECTV',637,'637',2,'MSG Plus 2 '),('DIRECTV',638,'638',2,'MSG 3 '),('DIRECTV',639,'639',2,'SNY '),('DIRECTV',639,'639',2,'SNY HD '),('DIRECTV',640,'640',2,'MASN '),('DIRECTV',641,'641',2,'MASN 2 '),('DIRECTV',642,'642',2,'Comcast Sports Net Mid-Atlantic '),('DIRECTV',642,'642',2,'Comcast Sports Net Mid-Atlantic HD '),('DIRECTV',643,'643',2,'Comcast SportsNet Mid-Atlantic Plus '),('DIRECTV',644,'644',2,'Fox Sports Tennessee '),('DIRECTV',644,'644-1 ',2,'Fox Sports Tennessee HD '),('DIRECTV',645,'645',2,'Fox Sports Carolinas '),('DIRECTV',646,'646',2,'Fox Sports South '),('DIRECTV',646,'646',2,'Fox Sports South HD '),('DIRECTV',647,'647',2,'Fox Sports South Plus '),('DIRECTV',648,'648',2,'Fox Sports South Plus 2 '),('DIRECTV',649,'649',2,'SportSouth '),('DIRECTV',649,'649',2,'SportSouth HD '),('DIRECTV',650,'650',2,'Regional Sports Networks Alternate '),('DIRECTV',651,'651',2,'Atlanta Braves '),('DIRECTV',652,'652',2,'Regional Sports Networks Alternate '),('DIRECTV',653,'653',2,'Sun Sports '),('DIRECTV',653,'653',2,'Sun Sports HD '),('DIRECTV',654,'654',2,'Fox Sports Florida '),('DIRECTV',655,'655',2,'Fox Sports Florida Plus '),('DIRECTV',656,'656',2,'Sun Sports Plus '),('DIRECTV',659,'659',2,'Fox Sports Pittsburgh '),('DIRECTV',659,'659',2,'Fox Sports Pittsburgh HD '),('DIRECTV',660,'660',2,'Fox Sports Ohio (Cleveland feed) '),('DIRECTV',661,'661',2,'Fox Sports Ohio (Cincinnati feed) '),('DIRECTV',662,'662',2,'SportsTime Ohio '),('DIRECTV',663,'663',2,'Fox Sports Detroit '),('DIRECTV',663,'663',2,'Fox Sports Detroit HD '),('DIRECTV',664,'664',2,'Fox Sports Detroit Plus '),('DIRECTV',665,'665',2,'Comcast Sports Net Chicago '),('DIRECTV',665,'665',2,'Comcast Sports Net Chicago HD '),('DIRECTV',666,'666',2,'Comcast Sports Net Chicago Plus '),('DIRECTV',667,'667',2,'Comcast Sports Net Chicago Plus 2 '),('DIRECTV',668,'668',2,'Fox Sports North '),('DIRECTV',668,'668',2,'Fox Sports North HD '),('DIRECTV',669,'669',2,'Fox Sports Wisconsin '),('DIRECTV',671,'671',2,'Fox Sports Midwest '),('DIRECTV',671,'671',2,'Fox Sports Midwest HD '),('DIRECTV',672,'672',2,'Fox Sports Kansas City '),('DIRECTV',673,'673',2,'Fox Sports Indiana '),('DIRECTV',676,'676',2,'Fox Sports Southwest '),('DIRECTV',676,'676',2,'Fox Sports Southwest HD '),('DIRECTV',677,'677',2,'Fox Sports Southwest Plus '),('DIRECTV',678,'678',2,'Fox Sports Houston '),('DIRECTV',679,'679',2,'Fox Sports Oklahoma '),('DIRECTV',680,'680',2,'Regional Sports Networks Alternate '),('DIRECTV',681,'681',2,'Altitude '),('DIRECTV',682,'682',2,'Altitude 2 '),('DIRECTV',683,'683',2,'Fox Sports Rocky Mountain '),('DIRECTV',683,'683',2,'Fox Sports Rocky Mountain HD '),('DIRECTV',684,'684',2,'Fox Sports Utah '),('DIRECTV',686,'686',2,'Fox Sports Arizona '),('DIRECTV',686,'686',2,'Fox Sports Arizona HD '),('DIRECTV',687,'687',2,'Fox Sports Northwest '),('DIRECTV',687,'687',2,'Fox Sports Northwest HD '),('DIRECTV',688,'688',2,'Fox Sports Northwest Alternate '),('DIRECTV',692,'692',2,'Fox Sports West '),('DIRECTV',692,'692',2,'Fox Sports West HD '),('DIRECTV',693,'693',2,'Regional Sports Alternate '),('DIRECTV',694,'694',2,'Prime Ticket '),('DIRECTV',694,'694',2,'Prime Ticket HD '),('DIRECTV',696,'696',2,'Comcast Sports Net Bay Area '),('DIRECTV',697,'697',2,'Comcast Sports Net Bay Area Plus '),('DIRECTV',698,'698',2,'Comcast Sports Net California '),('DIRECTV',699,'699',2,'Regional Sports Networks Alternate '),('DIRECTV',728,'728',2,'NCAA Basketball on CBS Regional '),('DIRECTV',729,'729',2,'NCAA Basketball on CBS Regional in HD '),('DIRECTV',801,'801',2,'The 40s on 4 '),('DIRECTV',802,'802',2,'The 50s on 5 '),('DIRECTV',803,'803',2,'The 60s on 6 '),('DIRECTV',804,'804',2,'The 70s on 7 '),('DIRECTV',805,'805',2,'The 80s on 8 '),('DIRECTV',806,'806',2,'The 90s on 9 '),('DIRECTV',808,'808',2,'The Roadhouse '),('DIRECTV',809,'809',2,'Prime Country '),('DIRECTV',810,'810',2,'Outlaw Country '),('DIRECTV',811,'811',2,'Willie\'s Place '),('DIRECTV',812,'812',2,'Bluegrass Junction '),('DIRECTV',813,'813',2,'The Village '),('DIRECTV',814,'814',2,'The Highway '),('DIRECTV',816,'816',2,'Top 20 on 20 '),('DIRECTV',817,'817',2,'Pop2k '),('DIRECTV',818,'818',2,'The Pulse '),('DIRECTV',819,'819',2,'Sirius XM Love '),('DIRECTV',820,'820',2,'Escape '),('DIRECTV',821,'821',2,'The Blend '),('DIRECTV',822,'822',2,'Cinemagic '),('DIRECTV',823,'823',2,'On Broadway '),('DIRECTV',824,'824',2,'U-Pop '),('DIRECTV',825,'825',2,'The Heat '),('DIRECTV',826,'826',2,'The Message '),('DIRECTV',827,'827',2,'Praise '),('DIRECTV',828,'828',2,'enLighten '),('DIRECTV',829,'829',2,'Hair Nation '),('DIRECTV',831,'831',2,'Sirius XM U '),('DIRECTV',832,'832',2,'The Spectrum '),('DIRECTV',833,'833',2,'Classic Vinyl '),('DIRECTV',834,'834',2,'Alt Nation '),('DIRECTV',835,'835',2,'Octane '),('DIRECTV',836,'836',2,'The Loft '),('DIRECTV',837,'837',2,'Classic Rewind '),('DIRECTV',838,'838',2,'Lithium '),('DIRECTV',839,'839',2,'First Wave '),('DIRECTV',840,'840',2,'Deep Tracks '),('DIRECTV',841,'841',2,'Liquid Metal '),('DIRECTV',842,'842',2,'Soul Town '),('DIRECTV',843,'843',2,'Heart & Soul '),('DIRECTV',844,'844',2,'The Groove '),('DIRECTV',847,'847',2,'Hip-Hop Nation '),('DIRECTV',848,'848',2,'The Coffee House '),('DIRECTV',849,'849',2,'The Bridge '),('DIRECTV',850,'850',2,'Real Jazz '),('DIRECTV',851,'851',2,'Watercolors '),('DIRECTV',854,'854',2,'B. B. King\'s Bluesville '),('DIRECTV',856,'856',2,'Spa '),('DIRECTV',857,'857',2,'Sirius XM Chill '),('DIRECTV',858,'858',2,'Area '),('DIRECTV',859,'859',2,'BPM '),('DIRECTV',860,'860',2,'The System '),('DIRECTV',862,'862',2,'World Zone '),('DIRECTV',863,'863',2,'The Joint '),('DIRECTV',864,'864',2,'Symphony Hall '),('DIRECTV',866,'866',2,'Sirius XM Pops '),('DIRECTV',867,'867',2,'Radio Disney '),('DIRECTV',868,'868',2,'Kids Place Live '),('DIRECTV',869,'869',2,'Caliente '),('DIRECTV',870,'870',2,'Fiesta Tropical '),('DIRECTV',871,'871',2,'Latin Contemporary '),('DIRECTV',872,'872',2,'Musica De Las Americas '),('DIRECTV',873,'873',2,'Regional Mexican '),('DIRECTV',874,'874',2,'Salsa '),('DIRECTV',875,'875',2,'Hurbano '),('DIRECTV',876,'876',2,'Mariachi '),('DIRECTV',877,'877',2,'Carnaval Brasileiro '),('DIRECTV',878,'878',2,'Rock en Espanol '),('DIRECTV',879,'879',2,'Latin Jazz '),('C-LAKEF',333,'333',1,'XFINITY 3D'),('C-LAKEF',326,'326',1,'BBC America HD'),('C-LAKEF',324,'324',1,'Investigation Discovery HD'),('C-LAKEF',323,'323',1,'H2 HD'),('C-LAKEF',322,'322',1,'HSN HD'),('C-LAKEF',321,'321',1,'Hallmark Channel HD'),('C-LAKEF',320,'320',1,'truTV HD'),('C-LAKEF',319,'319',1,'Turner Classic Movies HD'),('C-LAKEF',318,'318',1,'Headline News HD'),('C-LAKEF',317,'317',1,'MSNBC HD'),('C-LAKEF',308,'308',1,'Showtime Too HD'),('C-LAKEF',305,'305',1,'HBO Latino HD'),('C-LAKEF',304,'304',1,'HBO Zone HD'),('C-LAKEF',300,'300',1,'HBO 2 HD'),('C-LAKEF',299,'299',1,'GMC HD'),('C-LAKEF',298,'298',1,'CMT HD'),('C-LAKEF',297,'297',1,'VH1 HD'),('C-LAKEF',296,'296',1,'MTV HD'),('C-LAKEF',295,'295',1,'BET HD'),('C-LAKEF',294,'294',1,'Comedy Central HD'),('C-LAKEF',293,'293',1,'Travel Channel HD'),('C-LAKEF',290,'290',1,'Spike HD'),('C-LAKEF',289,'289',1,'TV One HD'),('C-LAKEF',288,'288',1,'G4 HD'),('C-LAKEF',287,'287',1,'Style HD'),('C-LAKEF',285,'285',1,'Comcast Info Channel HD'),('C-LAKEF',284,'284',1,'MGM HD'),('C-LAKEF',283,'283',1,'Disney XD HD'),('C-LAKEF',282,'282',1,'QVC HD'),('C-LAKEF',281,'281',1,'WE HD'),('C-LAKEF',280,'280',1,'IFC HD'),('C-LAKEF',279,'279',1,'Fuse HD'),('C-LAKEF',278,'278',1,'Bravo HD'),('C-LAKEF',276,'276',1,'H2'),('C-LAKEF',275,'275',1,'BIO'),('C-LAKEF',274,'274',1,'Military Channel'),('C-LAKEF',273,'273',1,'National Geographic'),('C-LAKEF',272,'272',1,'The Science Channel'),('C-LAKEF',271,'271',1,'Investigation Discovery'),('C-LAKEF',270,'270',1,'Weather Channel HD'),('C-LAKEF',269,'269',1,'BIO HD'),('C-LAKEF',267,'267',1,'FX HD'),('C-LAKEF',266,'266',1,'CNBC HD'),('C-LAKEF',265,'265',1,'Fox News Channel HD'),('C-LAKEF',264,'264',1,'Fox Business Network HD'),('C-LAKEF',263,'263',1,'Encore HD'),('C-LAKEF',262,'262',1,'E! HD'),('C-LAKEF',261,'261',1,'Destination America HD'),('C-LAKEF',260,'260',1,'TV Games'),('C-LAKEF',259,'259',1,'Starz Edge HD'),('C-LAKEF',258,'258',1,'Starz Comedy HD'),('C-LAKEF',257,'257',1,'Starz Kids & Family HD'),('C-LAKEF',256,'256',1,'Big Ten Network HD'),('C-LAKEF',255,'255',1,'Big Ten Network'),('C-LAKEF',254,'254',1,'NFL RedZone HD'),('C-LAKEF',253,'253',1,'ESPN U HD'),('C-LAKEF',251,'251',1,'Nat Geo Wild HD'),('C-LAKEF',250,'250',1,'Cooking Channel HD'),('C-LAKEF',249,'249',1,'DIY HD'),('C-LAKEF',242,'242',1,'The Hub HD'),('C-LAKEF',240,'240',1,'WYCC HD'),('C-LAKEF',239,'239',1,'WMVS (PBS) HD'),('C-LAKEF',238,'238',1,'WCPX (ION) HD'),('C-LAKEF',237,'237',1,'Speed Channel HD'),('C-LAKEF',236,'236',1,'The Tennis Channel HD'),('C-LAKEF',235,'235',1,'NBA TV HD'),('C-LAKEF',234,'234',1,'NHL Network HD'),('C-LAKEF',233,'233',1,'MLB Network HD'),('C-LAKEF',232,'232',1,'CBS College Sports Network HD'),('C-LAKEF',231,'231',1,'ESPNews HD'),('C-LAKEF',230,'230',1,'Trinity Broadcasting'),('C-LAKEF',229,'229',1,'Lifetime Movie Channel HD'),('C-LAKEF',228,'228',1,'Lifetime HD'),('C-LAKEF',227,'227',1,'Hallmark Movie Channel HD'),('C-LAKEF',226,'226',1,'Cartoon Network HD'),('C-LAKEF',225,'225',1,'Nickelodeon HD'),('C-LAKEF',224,'224',1,'Animal Planet HD'),('C-LAKEF',222,'222',1,'Discovery Fit & Health'),('C-LAKEF',221,'221',1,'USA HD'),('C-LAKEF',220,'220',1,'OWN'),('C-LAKEF',219,'219',1,'TBS HD'),('C-LAKEF',218,'218',1,'Discovery HD'),('C-LAKEF',217,'217',1,'ABC 7 Live Well HD'),('C-LAKEF',216,'216',1,'CNN HD'),('C-LAKEF',215,'215',1,'TeenNick'),('C-LAKEF',212,'212',1,'Science Channel HD'),('C-LAKEF',209,'209',1,'Palladia HD'),('C-LAKEF',208,'208',1,'A&E HD'),('C-LAKEF',207,'207',1,'Universal HD'),('C-LAKEF',206,'206',1,'National Geographic HD'),('C-LAKEF',205,'205',1,'Velocity'),('C-LAKEF',204,'204',1,'TNT in HD'),('C-LAKEF',203,'203',1,'ESPN2 HD'),('C-LAKEF',202,'202',1,'HGTV'),('C-LAKEF',201,'201',1,'Destination America'),('C-LAKEF',200,'200',1,'Comcast SportsNet HDTV'),('C-LAKEF',199,'199',1,'Golf HD'),('C-LAKEF',198,'198',1,'ABC Family HD'),('C-LAKEF',197,'197',1,'Disney Channel HD'),('C-LAKEF',196,'196',1,'Starz HD'),('C-LAKEF',195,'195',1,'Cinemax HD'),('C-LAKEF',194,'194',1,'WXFT (Telefutura) HD'),('C-LAKEF',193,'193',1,'WSNS (Telemundo) HD'),('C-LAKEF',192,'192',1,'WGN (CW) HD'),('C-LAKEF',191,'191',1,'WTTW (PBS) HD'),('C-LAKEF',190,'190',1,'WFLD (FOX) HD'),('C-LAKEF',189,'189',1,'WBBM (CBS) HD'),('C-LAKEF',188,'188',1,'WMAQ (NBC) HD'),('C-LAKEF',187,'187',1,'WLS (ABC) HD'),('C-LAKEF',186,'186',1,'HBO HD'),('C-LAKEF',185,'185',1,'Showtime HD'),('C-LAKEF',184,'184',1,'WPWR HD'),('C-LAKEF',183,'183',1,'WCIU HD'),('C-LAKEF',182,'182',1,'WGBO (Univision) HD'),('C-LAKEF',181,'181',1,'Food Network HD'),('C-LAKEF',179,'179',1,'HGTV HD'),('C-LAKEF',177,'177',1,'Syfy HD'),('C-LAKEF',176,'176',1,'TLC HD'),('C-LAKEF',175,'175',1,'History HD'),('C-LAKEF',174,'174',1,'NBC Sports Network HD'),('C-LAKEF',173,'173',1,'ESPN HD'),('C-LAKEF',172,'172',1,'TV One'),('C-LAKEF',171,'171',1,'AMC HD'),('C-LAKEF',169,'169',1,'NFL Network HD'),('C-LAKEF',168,'168',1,'NFL Network'),('C-LAKEF',162,'162',1,'BBC America'),('C-LAKEF',161,'161',1,'GSN'),('C-LAKEF',160,'160',1,'Syfy'),('C-LAKEF',157,'157',1,'Inspiration Network'),('C-LAKEF',154,'154',1,'BBC World News'),('C-LAKEF',153,'153',1,'Smithsonian Channel'),('C-LAKEF',150,'150',1,'Ovation'),('C-LAKEF',149,'149',1,'MoviePlex'),('C-LAKEF',146,'146',1,'CMT'),('C-LAKEF',143,'143',1,'LOGO'),('C-LAKEF',142,'142',1,'MTV Jams'),('C-LAKEF',141,'141',1,'Tr3s: MTV, Musica y Mas'),('C-LAKEF',136,'136',1,'G4'),('C-LAKEF',135,'135',1,'MTV 2'),('C-LAKEF',134,'134',1,'Fuse'),('C-LAKEF',133,'133',1,'The Africa Channel'),('C-LAKEF',132,'132',1,'Nick Too'),('C-LAKEF',131,'131',1,'Hallmark Channel'),('C-LAKEF',130,'130',1,'The HUB'),('C-LAKEF',129,'129',1,'Jewelry Television'),('C-LAKEF',128,'128',1,'Bloomberg'),('C-LAKEF',127,'127',1,'PBS Kids Sprout'),('C-LAKEF',126,'126',1,'Nicktoons Network'),('C-LAKEF',125,'125',1,'Disney Jr'),('C-LAKEF',124,'124',1,'Cooking Channel'),('C-LAKEF',123,'123',1,'Oxygen'),('C-LAKEF',122,'122',1,'Disney XD'),('C-LAKEF',121,'121',1,'DIY'),('C-LAKEF',120,'120',1,'Nick Jr.'),('C-LAKEF',119,'119',1,'EWTN'),('C-LAKEF',118,'118',1,'Style'),('C-LAKEF',116,'116',1,'Weatherscan Local'),('C-LAKEF',113,'113',1,'Cable Marketplace 3'),('C-LAKEF',110,'110',1,'Cable Marketplace 1'),('C-LAKEF',109,'109',1,'SOAPnet'),('C-LAKEF',108,'108',1,'National Geographic Wild'),('C-LAKEF',107,'107',1,'Current'),('C-LAKEF',106,'106',1,'Fox Business Network'),('C-LAKEF',105,'105',1,'CSPAN 3'),('C-LAKEF',104,'104',1,'CSPAN 2'),('C-LAKEF',103,'103',1,'Leased Access'),('C-LAKEF',102,'102',1,'Cable Marketplace 2'),('C-LAKEF',101,'101',1,'Comcast Network 101'),('C-LAKEF',100,'100',1,'Comcast Network 100'),('C-LAKEF',99,'99',1,'TV Guide Network'),('C-LAKEF',95,'95',1,'CSPAN'),('C-LAKEF',89,'89',1,'ShopNBC'),('C-LAKEF',76,'76',1,'NBC Sports Network'),('C-LAKEF',75,'75',1,'TLN'),('C-LAKEF',74,'74',1,'History'),('C-LAKEF',73,'73',1,'Bravo'),('C-LAKEF',72,'72',1,'Galavisión'),('C-LAKEF',71,'71',1,'Big Ten Network'),('C-LAKEF',69,'69',1,'Lifetime'),('C-LAKEF',68,'68',1,'Animal Planet'),('C-LAKEF',65,'65',1,'MSNBC'),('C-LAKEF',64,'64',1,'TV Land'),('C-LAKEF',62,'62',1,'Travel Channel'),('C-LAKEF',61,'61',1,'Food Network'),('C-LAKEF',60,'60',1,'E!'),('C-LAKEF',59,'59',1,'VH1'),('C-LAKEF',58,'58',1,'truTV'),('C-LAKEF',55,'55',1,'CNN'),('C-LAKEF',54,'54',1,'Fox News Channel'),('C-LAKEF',53,'53',1,'CLTV'),('C-LAKEF',52,'52',1,'TNT'),('C-LAKEF',51,'51',1,'USA Network'),('C-LAKEF',50,'50',1,'A&E'),('C-LAKEF',49,'49',1,'TLC'),('C-LAKEF',48,'48',1,'Nickelodeon'),('C-LAKEF',47,'47',1,'Disney Channel'),('C-LAKEF',46,'46',1,'BET'),('C-LAKEF',45,'45',1,'MTV'),('C-LAKEF',43,'43',1,'Spike TV'),('C-LAKEF',42,'42',1,'ESPN2'),('C-LAKEF',41,'41',1,'ESPN'),('C-LAKEF',38,'38',1,'Cartoon Network'),('C-LAKEF',37,'37',1,'Comcast SportsNet Chicago'),('C-LAKEF',36,'36',1,'Headline News'),('C-LAKEF',35,'35',1,'The Weather Channel'),('C-LAKEF',34,'34',1,'AMC'),('C-LAKEF',33,'33',1,'Discovery Channel'),('C-LAKEF',32,'32',1,'TBS'),('C-LAKEF',31,'31',1,'The Golf Channel'),('C-LAKEF',30,'30',1,'Comedy Central'),('C-LAKEF',27,'27',1,'HSN'),('C-LAKEF',25,'25',1,'Comcast Network'),('C-LAKEF',24,'24',1,'CNBC'),('C-LAKEF',23,'23',1,'FX'),('C-LAKEF',22,'22',1,'WXFT'),('C-LAKEF',21,'21',1,'WYIN'),('C-LAKEF',20,'20',1,'WYCC (PBS)'),('C-LAKEF',19,'19',1,'Access'),('C-LAKEF',18,'18',1,'Access'),('C-LAKEF',17,'17',1,'Access'),('C-LAKEF',16,'16',1,'ABC Family'),('C-LAKEF',15,'15',1,'WCPX (ION)'),('C-LAKEF',14,'14',1,'QVC'),('C-LAKEF',13,'13',1,'WCIU, The U'),('C-LAKEF',12,'12',1,'WFLD (FOX)'),('C-LAKEF',11,'11',1,'WTTW (PBS)'),('C-LAKEF',10,'10',1,'WMVS (PBS)'),('C-LAKEF',9,'9',1,'WGN (CW)'),('C-LAKEF',8,'8',1,'WPWR (MNT)'),('C-LAKEF',7,'7',1,'WLS (ABC)'),('C-LAKEF',6,'6',1,'WGBO (UNI)'),('C-LAKEF',5,'5',1,'WMAQ (NBC)'),('C-LAKEF',4,'4',1,'WSNS (TEL)'),('C-LAKEF',3,'3',1,'WJYS'),('C-LAKEF',2,'2',1,'WBBM (CBS)'),('C-LAKEF',1,'1',1,'ON DEMAND'),('C-LAKEF',334,'334',1,'ESPN 3D'),('C-LAKEF',341,'341',1,'NBC Chicago Nonstop'),('C-LAKEF',345,'345',1,'ABC 7 Live Well'),('C-LAKEF',353,'353',1,'Antenna TV (via WGN-DT)'),('C-LAKEF',357,'357',1,'Me-TV'),('C-LAKEF',358,'358',1,'Me-TOO'),('C-LAKEF',359,'359',1,'THIStv'),('C-LAKEF',360,'360',1,'WFBT (via WCIU-DT)'),('C-LAKEF',368,'368',1,'WTTW V-me'),('C-LAKEF',369,'369',1,'WTTW Create'),('C-LAKEF',370,'370',1,'WTTW Prime'),('C-LAKEF',372,'372',1,'WYCC World'),('C-LAKEF',376,'376',1,'WYIN Lakeshore Kids'),('C-LAKEF',385,'385',1,'WJYS2'),('C-LAKEF',386,'386',1,'MCTV (via WJYS-DT)'),('C-LAKEF',389,'389',1,'LATV (via WOCK-DT)'),('C-LAKEF',390,'390',1,'mega tv (via WOCK-DT)'),('C-LAKEF',391,'391',1,'KBC (via WOCK-DT)'),('C-LAKEF',392,'392',1,'AAN - Asian American Network'),('C-LAKEF',393,'393',1,'Azteca America'),('C-LAKEF',394,'394',1,'Exitos TV (via WSNS-DT)'),('C-LAKEF',396,'396',1,'Estrella TV (via WESV)'),('C-LAKEF',397,'397',1,'Polvision (via WPVN)'),('C-LAKEF',401,'401',1,'Fox Soccer Channel'),('C-LAKEF',402,'402',1,'ESPNews'),('C-LAKEF',403,'403',1,'ESPN Classic'),('C-LAKEF',404,'404',1,'NHL Network'),('C-LAKEF',405,'405',1,'ESPNU'),('C-LAKEF',406,'406',1,'Outdoor Channel'),('C-LAKEF',407,'407',1,'Horse Racing TV'),('C-LAKEF',408,'408',1,'Speed Channel'),('C-LAKEF',410,'410',1,'MLB Network'),('C-LAKEF',411,'411',1,'NFL RedZone'),('C-LAKEF',413,'413',1,'FCS Atlantic'),('C-LAKEF',414,'414',1,'FCS Central'),('C-LAKEF',415,'415',1,'FCS Pacific'),('C-LAKEF',416,'416',1,'Sportsman Channel'),('C-LAKEF',417,'417',1,'Tennis Channel'),('C-LAKEF',418,'418',1,'CBS College Sports'),('C-LAKEF',420,'420',1,'SportsNet New York'),('C-LAKEF',421,'421',1,'World Fishing Network'),('C-LAKEF',422,'422',1,'Comcast SportsNet New England'),('C-LAKEF',425,'425',1,'Comcast SportsNet Bay Area'),('C-LAKEF',428,'428',1,'ESPN Goal Line / Buzzer Beater'),('C-LAKEF',439,'439',1,'NBA TV'),('C-LAKEF',471,'471',1,'CMT Pure Country'),('C-LAKEF',472,'472',1,'MTV Hits'),('C-LAKEF',473,'473',1,'VH1 Classic'),('C-LAKEF',474,'474',1,'VH1 Soul'),('C-LAKEF',475,'475',1,'GMC'),('C-LAKEF',481,'481',1,'Centric'),('C-LAKEF',482,'482',1,'Aspire'),('C-LAKEF',484,'484',1,'Great American Country'),('C-LAKEF',485,'485',1,'Daystar Television Network'),('C-LAKEF',486,'486',1,'The Word Network'),('C-LAKEF',487,'487',1,'Retirement Living TV'),('C-LAKEF',489,'489',1,'Military History'),('C-LAKEF',490,'490',1,'Crime & Investigation Network'),('C-LAKEF',501,'501',1,'Turner Classic Movies'),('C-LAKEF',502,'502',1,'WE'),('C-LAKEF',503,'503',1,'Independent Film Channel'),('C-LAKEF',504,'504',1,'Lifetime Movie Network'),('C-LAKEF',505,'505',1,'Sundance Channel'),('C-LAKEF',506,'506',1,'Fox Movie Channel'),('C-LAKEF',507,'507',1,'Reelz Channel'),('C-LAKEF',508,'508',1,'Hallmark Movie Channel'),('C-LAKEF',516,'516',1,'Encore Family'),('C-LAKEF',517,'517',1,'Encore'),('C-LAKEF',519,'519',1,'Encore Love'),('C-LAKEF',521,'521',1,'Encore Suspense'),('C-LAKEF',522,'522',1,'RetroPlex'),('C-LAKEF',523,'523',1,'Encore Western'),('C-LAKEF',527,'527',1,'Encore Drama'),('C-LAKEF',528,'528',1,'IndiePlex'),('C-LAKEF',529,'529',1,'Encore Action'),('C-LAKEF',533,'533',1,'Starz'),('C-LAKEF',535,'535',1,'Starz Edge'),('C-LAKEF',537,'537',1,'Starz in Black'),('C-LAKEF',538,'538',1,'Starz Cinema'),('C-LAKEF',539,'539',1,'Starz Kids & Family'),('C-LAKEF',540,'540',1,'Starz Comedy'),('C-LAKEF',550,'550',1,'HBO East'),('C-LAKEF',551,'551',1,'HBO West'),('C-LAKEF',552,'552',1,'HBO 2'),('C-LAKEF',554,'554',1,'HBO Signature'),('C-LAKEF',556,'556',1,'HBO Family'),('C-LAKEF',558,'558',1,'HBO Latino'),('C-LAKEF',559,'559',1,'HBO Comedy'),('C-LAKEF',560,'560',1,'HBO Zone'),('C-LAKEF',561,'561',1,'Cinemax West'),('C-LAKEF',562,'562',1,'Cinemax East'),('C-LAKEF',564,'564',1,'MoreMax'),('C-LAKEF',566,'566',1,'ActionMax'),('C-LAKEF',567,'567',1,'5StarMax'),('C-LAKEF',575,'575',1,'Showtime'),('C-LAKEF',577,'577',1,'Showtime Too'),('C-LAKEF',579,'579',1,'Showtime Showcase'),('C-LAKEF',581,'581',1,'Showtime Extreme'),('C-LAKEF',583,'583',1,'Showtime Next'),('C-LAKEF',584,'584',1,'Showtime FamilyZone'),('C-LAKEF',585,'585',1,'Showtime Women'),('C-LAKEF',586,'586',1,'FLIX'),('C-LAKEF',597,'597',1,'Galavisión'),('C-LAKEF',603,'603',1,'mun2'),('C-LAKEF',606,'606',1,'Tr3s: MTV, Musica y Mas'),('C-LAKEF',635,'635',1,'nuvoTV'),('C-LAKEF',673,'673',1,'MYX (Filipino)'),('C-LAKEF',877,'877',1,'WLFM Smooth Jazz (Via WCHU)');
/*!40000 ALTER TABLE `videoChannel` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `videoFav`
--

DROP TABLE IF EXISTS `videoFav`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `videoFav` (
  `src` smallint(2) NOT NULL DEFAULT '0',
  `type` varchar(10) NOT NULL,
  `value` int(7) NOT NULL,
  `name` varchar(25) NOT NULL
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `videoFav`
--

LOCK TABLES `videoFav` WRITE;
/*!40000 ALTER TABLE `videoFav` DISABLE KEYS */;
INSERT INTO `videoFav` VALUES (14,'DIRECTV',610,'Big Ten Network'),(14,'DIRECTV',356,'MSNBC'),(14,'DIRECTV',245,'TNT'),(14,'DIRECTV',209,'ESPN2'),(14,'DIRECTV',206,'ESPN'),(14,'DIRECTV',202,'CNN'),(14,'DIRECTV',32,'WFLD'),(14,'DIRECTV',9,'WGN'),(14,'DIRECTV',7,'WLS'),(14,'DIRECTV',2,'WBBM'),(14,'DIRECTV',5,'WMAQ'),(14,'DIRECTV',665,'Comcast Sports Net Chicag'),(13,'DIRECTV',73,'ESPNHD'),(13,'DIRECTV',9,'WGN'),(13,'DIRECTV',5,'WMAQ'),(13,'DIRECTV',2,'WBBM'),(15,'DIRECTV',278,'Discovery Channel'),(2,'C-LAKEF',2,'WBBM (CBS)'),(2,'C-LAKEF',5,'WMAQ (NBC)'),(2,'C-LAKEF',7,'WLS (ABC)'),(2,'C-LAKEF',9,'WGN (CW)'),(13,'DIRECTV',237,'TV Guide Network'),(1,'C-LAKEF',73,'Bravo'),(1,'C-LAKEF',12,'WFLD (FOX)'),(1,'C-LAKEF',2,'WBBM (CBS)'),(15,'DIRECTV',38,'ION'),(15,'DIRECTV',23,'WWME'),(15,'DIRECTV',9,'WGN'),(15,'DIRECTV',2,'WBBM'),(15,'DIRECTV',282,'Animal Planet'),(15,'DIRECTV',290,'Disney Channel East'),(15,'DIRECTV',292,'Toon Disney'),(15,'DIRECTV',296,'Cartoon Network East');
/*!40000 ALTER TABLE `videoFav` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `videoSrc`
--

DROP TABLE IF EXISTS `videoSrc`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `videoSrc` (
  `index` tinyint(2) NOT NULL,
  `vi` tinyint(4) NOT NULL,
  `ai` tinyint(4) DEFAULT NULL,
  `name` varchar(25) NOT NULL,
  `family` varchar(20) NOT NULL,
  `mediaType` varchar(10) DEFAULT NULL,
  `ownPage` tinyint(1) NOT NULL DEFAULT '0',
  `popup` varchar(25) DEFAULT NULL,
  `gain` decimal(3,1) NOT NULL DEFAULT '0.0',
  PRIMARY KEY (`index`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `videoSrc`
--

LOCK TABLES `videoSrc` WRITE;
/*!40000 ALTER TABLE `videoSrc` DISABLE KEYS */;
INSERT INTO `videoSrc` VALUES (1,1,1,'Nicholle\'s DVR','Cable TV','C-LAKEF',0,'Cable DVR',-10.0),(2,2,2,'Dave\'s Cable','Cable TV','C-LAKEF',0,'Cable TV',0.0),(3,3,3,'Kids\' Cable','Cable TV','C-LAKEF',0,'Cable TV',0.0),(4,4,4,'AppleTV 1','AppleTV',NULL,0,'AppleTV',0.0),(5,5,5,'AppleTV 2','AppleTV',NULL,0,'AppleTV',0.0),(6,6,6,'Kitchen Blu-Ray','Blu-Ray',NULL,0,'Blu-Ray',0.0),(7,7,7,'Theater Blu-Ray','Blu-Ray',NULL,0,'Blu-Ray',10.0),(8,8,15,'Global Player','Kaleidescape',NULL,0,'KScape',10.0),(9,12,20,'Theater Player','Kaleidescape',NULL,0,'KScape',10.0),(10,9,0,'Front Door','Camera',NULL,0,'Camera',0.0),(11,10,0,'Mud Room','Camera',NULL,0,'Camera',0.0),(12,11,0,'Composite','Camera',NULL,0,'Camera',0.0),(13,13,14,'Nicholle\'s SAT','Satellite TV','DIRECTV',0,'Satellite DVR',0.0),(14,14,18,'Dave\'s SAT','Satellite TV','DIRECTV',0,'Satellite DVR',0.0),(15,15,19,'Kids\' SAT','Satellite TV','DIRECTV',0,'Satellite DVR',0.0),(16,99,0,'Game','Local Sources',NULL,1,'Local Src',0.0),(17,98,0,'Future Aux','Local Sources',NULL,1,'Local Src',0.0);
/*!40000 ALTER TABLE `videoSrc` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `water`
--

DROP TABLE IF EXISTS `water`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `water` (
  `index` int(11) NOT NULL,
  `room` int(11) NOT NULL,
  `addr` varchar(10) NOT NULL,
  `name` varchar(30) NOT NULL,
  `type` varchar(10) NOT NULL,
  UNIQUE KEY `index` (`index`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `water`
--

LOCK TABLES `water` WRITE;
/*!40000 ALTER TABLE `water` DISABLE KEYS */;
/*!40000 ALTER TABLE `water` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `weather`
--

DROP TABLE IF EXISTS `weather`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `weather` (
  `index` int(11) NOT NULL,
  `description` varchar(35) NOT NULL,
  `site` varchar(15) NOT NULL
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `weather`
--

LOCK TABLES `weather` WRITE;
/*!40000 ALTER TABLE `weather` DISABLE KEYS */;
INSERT INTO `weather` VALUES (1,'My Winter House','MIAMI'),(2,'New York, NY','10010'),(3,'My Summer Place','55987'),(4,'Beverly Hills 90210','90210');
/*!40000 ALTER TABLE `weather` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Dumping events for database 'j3133'
--

--
-- Dumping routines for database 'j3133'
--
/*!40103 SET TIME_ZONE=@OLD_TIME_ZONE */;

/*!40101 SET SQL_MODE=@OLD_SQL_MODE */;
/*!40014 SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS */;
/*!40014 SET UNIQUE_CHECKS=@OLD_UNIQUE_CHECKS */;
/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
/*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */;
/*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;
/*!40111 SET SQL_NOTES=@OLD_SQL_NOTES */;

-- Dump completed on 2025-12-08  0:25:51
