('2019-02-12 22:33:58','R27B01LK'),('2019-02-12 23:37:06','G09S'),('2019-02-12 23:53:06','I01R12M02--'),('2019-02-12 23:53:26','I01R12M03--'),('2019-01-29 00:00:06','E02'),('2019-01-29 01:17:48','O040'),('2019-01-29 01:17:59','O041'),('2019-01-29 06:45:06','G06S'),('2019-01-29 07:15:06','E04'),('2019-01-29 07:51:18','R24B01LK'),('2019-01-29 09:31:44','O040'),('2019-01-29 09:31:54','O041'),('2019-01-29 16:30:06','G08S'),('2019-01-29 16:45:06','E03'),('2019-01-29 17:00:06','E01'),('2019-01-29 17:38:42','R24B03LK'),('2019-01-29 17:45:36','O040'),('2019-01-29 17:45:48','O041'),('2019-01-29 20:05:54','V0202'),('2019-01-29 20:11:21','A0200'),('2019-01-29 20:11:31','V0202'),('2019-01-29 22:56:34','A0200'),('2019-01-29 23:01:43','R20B05LK'),('2019-01-29 23:37:06','G09S'),('2019-01-30 00:00:06','E02'),('2019-01-30 01:59:31','O040'),('2019-01-30 01:59:42','O041'),('2019-01-30 06:45:06','G06S'),('2019-01-30 07:14:06','E04'),('2019-01-30 08:53:33','R24B06LK'),('2019-01-30 09:43:19','R24B06LK'),('2019-01-30 10:14:58','O040'),('2019-01-30 10:15:32','O041'),('2019-01-30 12:53:15','R24B01LK'),('2019-01-30 14:25:10','R24B06LK'),('2019-01-30 16:32:06','G08S'),('2019-01-30 16:47:06','E03'),('2019-01-30 16:59:47','V0202'),('2019-01-30 17:02:06','E01'),('2019-01-30 18:28:00','A0200'),('2019-01-30 18:29:19','O040'),('2019-01-30 18:29:27','O041'),('2019-01-30 19:06:35','R24B01LK'),('2019-01-30 19:13:24','R24B06LK'),('2019-01-30 20:03:05','A0214'),('2019-01-30 22:32:35','R20B05LK'),('2019-01-30 22:54:12','R24B03LK'),('2019-01-30 23:37:06','G09S'),('2019-02-26 00:00:06','E02'),('2019-02-26 03:54:09','O040'),('2019-02-26 03:54:48','O041'),('2019-02-26 06:28:34','R24B06LK'),('2019-02-26 06:33:18','I01G06'),('2019-02-26 06:41:06','E04'),('2019-02-26 06:45:06','G06S'),('2019-02-26 12:09:59','O040'),('2019-02-26 12:10:12','O041'),('2019-02-26 17:05:06','G08S'),('2019-02-26 17:20:06','E03'),('2019-02-26 17:35:06','E01'),('2019-02-26 20:25:24','O040'),('2019-02-26 20:25:39','O041'),('2019-02-26 22:31:19','R20B05LK'),('2019-02-26 22:32:38','R24B01LK'),('2019-02-26 23:37:06','G09S'),('2019-02-26 23:57:14','O010'),('2019-02-26 23:57:59','O011'),('2019-02-27 00:00:06','E02'),('2019-02-27 00:37:46','O010'),('2019-02-27 00:38:16','O011'),('2019-02-27 04:40:54','O040'),('2019-02-27 04:41:02','O041'),('2019-02-27 06:13:26','O010'),('2019-02-27 06:13:55','O011'),('2019-02-27 06:40:06','E04'),('2019-02-27 06:45:06','G06S'),('2019-02-27 07:51:14','R24B06LK'),('2019-02-27 08:03:32','O010'),('2019-02-27 08:03:40','O011'),('2019-02-27 08:04:10','O010'),('2019-02-27 08:04:19','O011'),('2019-02-27 10:05:16','R24B01LK'),('2019-02-27 10:54:14','R26B05LK'),('2019-02-27 11:11:13','R26B05LK'),('2019-02-27 11:13:50','R24B06LK'),('2019-02-27 11:46:50','O010'),('2019-02-27 11:47:02','O011'),('2019-02-27 11:47:40','O010'),('2019-02-27 11:48:14','O011'),('2019-02-27 11:52:16','O010'),('2019-02-27 11:52:25','O011'),('2019-02-27 11:53:01','O010'),('2019-02-27 11:53:18','O011'),('2019-02-27 12:54:48','O040'),('2019-02-27 12:54:56','O041'),('2019-02-27 13:37:06','O010'),('2019-02-27 13:37:40','O011'),('2019-02-27 17:06:06','G08S'),('2019-02-27 17:21:06','E03'),('2019-02-27 17:36:06','E01'),('2019-02-27 18:13:20','O010'),('2019-02-27 18:13:54','O011'),('2019-02-27 19:23:13','V0202'),('2019-02-27 19:33:03','O010'),('2019-02-27 19:36:19','O011'),('2019-02-27 20:00:36','R24B01LK'),('2019-02-27 20:13:11','O010'),('2019-02-27 20:13:20','O011'),('2019-02-27 20:31:14','O010'),('2019-02-27 20:31:24','O011'),('2019-02-27 20:32:25','O010'),('2019-02-27 20:32:33','O011'),('2019-02-27 21:10:12','O040'),('2019-02-27 21:10:47','O041'),('2019-02-27 21:22:06','O010'),('2019-02-27 21:22:15','O011'),('2019-02-27 21:35:02','O010'),('2019-02-27 21:35:11','O011'),('2019-02-27 21:40:48','O010'),('2019-02-27 21:41:37','O011'),('2019-02-27 22:14:05','O010'),('2019-02-27 22:14:18','O011'),('2019-02-27 22:40:57','O010'),('2019-02-27 22:41:06','O011'),('2019-02-27 22:56:13','O010'),('2019-02-27 22:56:31','O011'),('2019-02-27 22:56:37','O010'),('2019-02-27 22:57:17','O010'),('2019-02-27 22:57:36','O011'),('2019-02-27 23:21:26','A0200'),('2019-02-27 23:23:02','R20B05LK'),('2019-02-27 23:37:06','G09S'),('2019-02-27 23:54:31','R24B03LK'),('2019-02-27 23:56:15','R24B01LK'),('2019-02-27 23:58:33','R24B03LK'),('2019-02-28 00:00:06','E02'),('2019-02-28 05:30:33','O040'),('2019-02-28 05:30:43','O041'),('2019-02-28 06:35:26','O010'),('2019-02-28 06:37:08','O011'),('2019-02-28 06:38:06','E04'),('2019-02-28 06:45:06','G06S'),('2019-02-28 08:16:08','R24B01LK'),('2019-02-28 10:22:09','O010'),('2019-02-28 10:22:45','O011'),('2019-02-28 10:25:29','O010'),('2019-02-28 10:25:44','O011'),('2019-02-28 10:26:24','O010'),('2019-02-28 10:28:04','O011'),('2019-02-28 10:28:35','O010'),('2019-02-28 10:29:19','O011'),('2019-02-28 10:55:02','O010'),('2019-02-28 10:55:11','O011'),('2019-02-28 11:00:27','R24B01LK'),('2019-02-28 11:04:41','O010'),('2019-02-28 11:04:56','O011'),('2019-02-28 11:11:02','R24B06LK'),('2019-02-28 11:21:24','O010'),('2019-02-28 11:21:33','O011'),('2019-02-28 11:24:55','O010'),('2019-02-28 11:26:16','O011'),('2019-02-28 11:30:44','R24B06LK'),('2019-02-28 11:35:49','O010'),('2019-02-28 11:35:58','O011'),('2019-02-28 11:46:12','O010'),('2019-02-28 11:46:35','O011'),('2019-02-28 11:57:01','O010'),('2019-02-28 11:57:10','O011'),('2019-02-28 11:59:52','O010'),('2019-02-28 12:00:00','O011'),('2019-02-28 12:14:09','O010'),('2019-02-28 12:14:53','O011'),('2019-02-28 13:28:54','O010'),('2019-02-28 13:29:05','O011'),('2019-02-28 13:34:57','O010'),('2019-02-28 13:35:15','O011'),('2019-02-28 13:36:15','O010'),('2019-02-28 13:36:24','O011'),('2019-02-28 13:36:59','O010'),('2019-02-28 13:37:08','O011'),('2019-02-28 13:37:15','O010'),('2019-02-28 13:37:16','O011'),('2019-02-28 13:37:45','O010'),('2019-02-28 13:37:56','O011'),('2019-02-28 13:38:29','O010'),('2019-02-28 13:38:41','O011'),('2019-02-28 13:38:49','O010'),('2019-02-28 13:39:31','O010'),('2019-02-28 13:40:08','O011'),('2019-02-28 13:40:15','O010'),('2019-02-28 13:40:16','O011'),('2019-02-28 13:40:46','O010'),('2019-02-28 13:41:00','O011'),('2019-02-28 13:41:08','O010'),('2019-02-28 13:41:51','O010'),('2019-02-28 13:42:23','O011'),('2019-02-28 13:42:56','O010'),('2019-02-28 13:43:06','O011'),('2019-02-28 13:43:37','O010'),('2019-02-28 13:43:49','O011'),('2019-02-28 13:44:22','O010'),('2019-02-28 13:44:31','O011'),('2019-02-28 13:45:57','O040'),('2019-02-28 13:45:59','O010'),('2019-02-28 13:46:07','O041'),('2019-02-28 13:46:11','O011'),('2019-02-28 13:46:18','O010'),('2019-02-28 13:46:19','O011'),('2019-02-28 13:46:37','O010'),('2019-02-28 13:47:07','O010'),('2019-02-28 13:47:16','O011'),('2019-02-28 13:47:47','O010'),('2019-02-28 13:47:58','O011'),('2019-02-28 13:48:05','O010'),('2019-02-28 13:48:13','O010'),('2019-02-28 13:48:16','O011'),('2019-02-28 13:48:48','O010'),('2019-02-28 13:48:58','O011'),('2019-02-28 13:49:06','O010'),('2019-02-28 13:49:18','O010'),('2019-02-28 13:49:21','O011'),('2019-02-28 13:50:13','O010'),('2019-02-28 13:50:21','O011'),('2019-02-28 13:50:29','O010'),('2019-02-28 13:50:53','O010'),('2019-02-28 13:51:05','O011'),('2019-02-28 13:51:38','O010'),('2019-02-28 13:52:02','O011'),('2019-02-28 13:52:33','O010'),('2019-02-28 13:53:27','O011'),('2019-02-28 13:59:20','O010'),('2019-02-28 13:59:29','O011'),('2019-02-28 14:14:02','O010'),('2019-02-28 14:14:10','O011'),('2019-02-28 14:29:30','O010'),('2019-02-28 14:29:39','O011'),('2019-02-28 14:44:47','O010'),('2019-02-28 14:44:56','O011'),('2019-02-28 14:51:14','O010'),('2019-02-28 14:51:23','O011'),('2019-02-28 15:02:36','O010'),('2019-02-28 15:02:44','O011'),('2019-02-28 15:12:38','O010'),('2019-02-28 15:12:47','O011'),('2019-02-28 15:13:43','O010'),('2019-02-28 15:13:52','O011'),('2019-02-28 16:12:39','O010'),('2019-02-28 16:12:52','O011'),('2019-02-28 16:23:41','O010'),('2019-02-28 16:23:50','O011'),('2019-02-28 16:30:58','O010'),('2019-02-28 16:31:07','O011'),('2019-02-28 16:35:49','O010'),('2019-02-28 16:35:58','O011'),('2019-02-28 17:07:06','G08S'),('2019-02-28 17:22:06','E03'),('2019-02-28 17:22:58','O010'),('2019-02-28 17:23:07','O011'),('2019-02-28 17:26:39','O010'),('2019-02-28 17:26:48','O011'),('2019-02-28 17:27:29','O010'),('2019-02-28 17:27:38','O011'),('2019-02-28 17:33:26','O010'),('2019-02-28 17:33:35','O011'),('2019-02-28 17:36:51','O010'),('2019-02-28 17:37:00','O011'),('2019-02-28 17:37:06','E01'),('2019-02-28 17:37:34','O010'),('2019-02-28 17:37:46','O011'),('2019-02-28 17:38:21','O010'),('2019-02-28 17:38:30','O011'),('2019-02-28 17:39:03','O010'),('2019-02-28 17:39:12','O011'),('2019-02-28 17:39:19','O010'),('2019-02-28 17:39:20','O011'),('2019-02-28 17:39:52','O010'),('2019-02-28 17:40:07','O011'),('2019-02-28 17:41:38','O010'),('2019-02-28 17:41:47','O011'),('2019-02-28 17:42:17','O010'),('2019-02-28 17:42:29','O011'),('2019-02-28 17:42:37','O010'),('2019-02-28 17:43:07','O010'),('2019-02-28 17:43:29','O011'),('2019-02-28 17:45:03','O010'),('2019-02-28 17:45:11','O011'),('2019-02-28 17:45:43','O010'),('2019-02-28 17:45:51','O011'),('2019-02-28 17:48:38','O010'),('2019-02-28 17:48:47','O011'),('2019-02-28 17:48:54','O010'),('2019-02-28 17:48:55','O011'),('2019-02-28 17:51:09','O010'),('2019-02-28 17:51:18','O011'),('2019-02-28 17:54:11','O010'),('2019-02-28 17:54:20','O011'),('2019-02-28 17:54:27','O010'),('2019-02-28 17:55:04','O010'),('2019-02-28 17:55:19','O011'),('2019-02-28 18:09:02','O010'),('2019-02-28 18:09:11','O011'),('2019-02-28 18:11:37','O010'),('2019-02-28 18:11:46','O011'),('2019-02-28 18:19:09','O010'),('2019-02-28 18:19:18','O011'),('2019-02-28 18:24:00','O010'),('2019-02-28 18:24:09','O011'),('2019-02-28 18:25:05','O010'),('2019-02-28 18:25:14','O011'),('2019-02-28 18:39:36','O010'),('2019-02-28 18:39:45','O011'),('2019-02-28 18:40:42','O010'),('2019-02-28 18:40:54','O011'),('2019-02-28 18:42:03','O010'),('2019-02-28 18:42:18','O011'),('2019-02-28 18:43:13','O010'),('2019-02-28 18:43:26','O011'),('2019-02-28 18:44:09','O010'),('2019-02-28 18:44:20','O011'),('2019-02-28 19:27:21','O010'),('2019-02-28 19:27:30','O011'),('2019-02-28 19:47:33','O010'),('2019-02-28 19:48:31','O011'),('2019-02-28 19:57:00','V0202'),('2019-02-28 20:28:33','A0200'),('2019-02-28 21:59:51','O040'),('2019-02-28 22:00:02','O041'),('2019-02-28 23:12:23','R20B05LK'),('2019-02-28 23:13:04','R24B01LK'),('2019-02-28 23:27:48','R24B03LK'),('2019-02-28 23:37:06','G09S'),('2019-03-01 00:00:06','E02'),('2019-03-01 06:15:16','O040'),('2019-03-01 06:15:26','O041'),('2019-03-01 06:35:06','E04'),('2019-03-01 06:45:06','G06S'),('2019-03-01 09:16:06','R24B01LK'),('2019-03-01 10:28:58','R24B06LK'),('2019-03-01 12:39:53','R05B23LK'),('2019-03-01 13:11:58','R08B23LK'),('2019-03-01 13:18:47','R09B03LK'),('2019-03-01 13:18:48','A0900'),('2019-03-01 13:21:59','R08B02LK'),('2019-03-01 13:22:01','R08B02LK'),('2019-03-01 13:23:03','R27B01LK'),('2019-03-01 13:23:13','R27B02LK'),('2019-03-01 13:23:19','R27B06LK'),('2019-03-01 13:23:23','R27B01LK'),('2019-03-01 13:23:36','R27B02LK'),('2019-03-01 13:23:37','R27B01LK'),('2019-03-01 13:23:39','R27B06LK'),('2019-03-01 13:23:47','R27B01LK'),('2019-03-01 13:23:53','R27B06LK'),('2019-03-01 13:24:06','R27B01LK'),('2019-03-01 13:24:10','R27B06LK'),('2019-03-01 13:28:56','R11B01LK'),('2019-03-01 13:35:37','R20B01LK'),('2019-03-01 13:37:05','R11B06LK'),('2019-03-01 13:37:06','A1100'),('2019-03-01 13:42:27','R26B01LK'),('2019-03-01 14:10:24','R16B01LK'),('2019-03-01 14:29:10','O040'),('2019-03-01 14:29:48','O041'),('2019-03-01 16:47:41','O010'),('2019-03-01 16:48:18','O011'),('2019-03-01 17:09:06','G08S'),('2019-03-01 17:11:36','R24B02LK'),('2019-03-01 17:11:39','R24B02LK'),('2019-03-01 17:11:42','R24B01LK'),('2019-03-01 17:11:46','R24B24LK'),('2019-03-01 17:11:52','R24B23LK'),('2019-03-01 17:11:53','R24B23LK'),('2019-03-01 17:11:56','R24B24LK'),('2019-03-01 17:11:57','R24B24LK'),('2019-03-01 17:11:59','R24B24LK'),('2019-03-01 17:12:01','R24B24LK'),('2019-03-01 17:12:08','R24B23LK'),('2019-03-01 17:12:09','R24B24LK'),('2019-03-01 17:12:12','R24B24LK'),('2019-03-01 17:12:14','R24B24LK'),('2019-03-01 17:14:01','R24B06LK'),('2019-03-01 17:14:09','R24B01LK'),('2019-03-01 17:14:12','R24B03LK'),('2019-03-01 17:14:20','R24B04LK'),('2019-03-01 17:14:25','R24B06LK'),('2019-03-01 17:24:06','E03'),('2019-03-01 17:39:06','E01'),('2019-03-01 18:45:09','V0202'),('2019-03-01 19:06:42','O010'),('2019-03-01 19:06:51','O011'),('2019-03-01 19:14:54','O010'),('2019-03-01 19:15:03','O011'),('2019-03-01 20:17:33','A0200'),('2019-03-01 22:49:30','O040'),('2019-03-01 22:49:40','O041'),('2019-03-01 22:52:46','R20B05LK'),('2019-03-01 23:37:06','G09S'),('2019-03-27 00:00:06','E02'),('2019-03-27 02:15:05','O040'),('2019-03-27 02:15:14','O041'),('2019-03-27 06:45:06','G06S'),('2019-03-27 06:53:06','E04'),('2019-03-27 08:31:47','R24B01LK'),('2019-03-27 08:35:03','O010'),('2019-03-27 08:35:11','O011'),('2019-03-27 08:42:33','O010'),('2019-03-27 08:42:42','O011'),('2019-03-27 08:42:50','O010'),('2019-03-27 08:43:23','O010'),('2019-03-27 08:43:54','O011'),('2019-03-27 08:45:01','O010'),('2019-03-27 08:45:10','O011'),('2019-03-27 09:12:38','R24B06LK'),('2019-03-27 10:00:49','O010'),('2019-03-27 10:00:58','O011'),('2019-03-27 10:07:50','O010'),('2019-03-27 10:07:59','O011'),('2019-03-27 10:23:27','O010'),('2019-03-27 10:23:36','O011'),('2019-03-27 10:24:57','O010'),('2019-03-27 10:25:09','O011'),('2019-03-27 10:27:43','O010'),('2019-03-27 10:27:55','O011'),('2019-03-27 10:30:28','O040'),('2019-03-27 10:31:03','O041'),('2019-03-27 11:03:30','O010'),('2019-03-27 11:03:42','O011'),('2019-03-27 11:04:35','O010'),('2019-03-27 11:04:43','O011'),('2019-03-27 11:18:00','I01G10'),('2019-03-27 11:49:08','O010'),('2019-03-27 11:49:17','O011'),('2019-03-27 11:50:13','O010'),('2019-03-27 11:50:24','O011'),('2019-03-27 11:53:33','O010'),('2019-03-27 11:53:42','O011'),('2019-03-27 11:54:57','O010'),('2019-03-27 11:55:06','O011'),('2019-03-27 12:28:36','O010'),('2019-03-27 12:28:51','O011'),('2019-03-27 13:12:20','O010'),('2019-03-27 13:12:29','O011'),('2019-03-27 13:17:44','O010'),('2019-03-27 13:17:53','O011'),('2019-03-27 14:03:44','O010'),('2019-03-27 14:03:53','O011'),('2019-03-27 14:19:22','O010'),('2019-03-27 14:19:31','O011'),('2019-03-27 14:25:58','O010'),('2019-03-27 14:26:07','O011'),('2019-03-27 14:30:49','O010'),('2019-03-27 14:31:01','O011'),('2019-03-27 14:32:49','O010'),('2019-03-27 14:33:04','O011'),('2019-03-27 14:35:10','O010'),('2019-03-27 14:35:19','O011'),('2019-03-27 14:38:45','O010'),('2019-03-27 14:38:54','O011'),('2019-03-27 14:53:08','O010'),('2019-03-27 14:53:17','O011'),('2019-03-27 17:20:21','V0202'),('2019-03-27 17:20:22','A0202'),('2019-03-27 17:28:18','R24B01LK'),('2019-03-27 17:30:34','R24B06LK'),('2019-03-27 17:47:09','R24B06LK'),('2019-03-27 18:29:49','A0200'),('2019-03-27 18:30:20','O010'),('2019-03-27 18:30:32','O011'),('2019-03-27 18:32:27','I01G08'),('2019-03-27 18:37:06','G08S'),('2019-03-27 18:50:48','O040'),('2019-03-27 18:51:00','O041'),('2019-03-27 18:52:06','E03'),('2019-03-27 19:07:06','E01'),('2019-03-27 19:56:26','V0206'),('2019-03-27 19:58:32','O010'),('2019-03-27 19:58:38','O011'),('2019-03-27 20:43:34','O010'),('2019-03-27 20:43:43','O011'),('2019-03-27 20:49:07','O010'),('2019-03-27 20:49:15','O011'),('2019-03-27 20:50:07','O010'),('2019-03-27 20:50:16','O011'),('2019-03-27 21:03:34','O010'),('2019-03-27 21:03:44','O011'),('2019-03-27 21:04:24','O010'),('2019-03-27 21:04:33','O011'),('2019-03-27 21:05:38','O010'),('2019-03-27 21:05:48','O011'),('2019-03-27 21:13:51','O010'),('2019-03-27 21:14:00','O011'),('2019-03-27 21:25:48','O010'),('2019-03-27 21:26:00','O011'),('2019-03-27 21:26:07','O010'),('2019-03-27 21:26:08','O011'),('2019-03-27 21:37:20','O010'),('2019-03-27 21:37:29','O011'),('2019-03-27 21:38:10','O010'),('2019-03-27 21:39:04','O011'),('2019-03-27 21:39:10','V0202'),('2019-03-27 21:59:34','O010'),('2019-03-27 21:59:43','O011'),('2019-03-27 22:00:19','O010'),('2019-03-27 22:00:28','O011'),('2019-03-27 22:33:36','A0200'),('2019-03-27 22:53:30','O010'),('2019-03-27 22:54:37','O011'),('2019-03-27 23:02:13','R24B01LK'),('2019-03-27 23:14:40','O010'),('2019-03-27 23:15:39','O011'),('2019-03-27 23:35:43','O010'),('2019-03-27 23:36:38','O011'),('2019-03-27 23:37:06','G09S'),('2019-03-27 23:56:42','O010'),('2019-03-27 23:57:37','O011'),('2019-01-31 00:00:06','E02'),('2019-01-31 02:43:10','O040'),('2019-01-31 02:43:22','O041'),('2019-01-31 06:45:06','G06S'),('2019-01-31 07:14:06','E04'),('2019-01-31 08:09:21','R24B01LK'),('2019-01-31 10:37:51','R24B01LK'),('2019-01-31 10:57:07','O040'),('2019-01-31 10:57:18','O041'),('2019-01-31 16:33:06','G08S'),('2019-01-31 16:48:06','E03'),('2019-01-31 17:03:06','E01'),('2019-01-31 18:21:19','R24B06LK'),('2019-01-31 18:21:36','V0202'),('2019-01-31 18:52:19','A0200'),('2019-01-31 19:11:03','O040'),('2019-01-31 19:11:11','O041'),('2019-01-31 20:23:18','R24B01LK'),('2019-01-31 20:23:29','R10B06LK'),('2019-01-31 22:45:15','R16B05LK'),('2019-01-31 23:18:19','R24B03LK'),('2019-01-31 23:37:06','G09S'),('2019-03-28 00:00:06','E02'),('2019-03-28 00:06:37','R24B03LK'),('2019-03-28 00:17:41','O010'),('2019-03-28 00:18:10','O011'),('2019-03-28 00:21:47','O010'),('2019-03-28 00:25:08','O011'),('2019-03-28 00:43:36','O010'),('2019-03-28 00:44:36','O011'),('2019-03-28 01:04:37','O010'),('2019-03-28 01:05:38','O011'),('2019-03-28 01:25:38','O010'),('2019-03-28 01:26:38','O011'),('2019-03-28 01:46:42','O010'),('2019-03-28 01:47:41','O011'),('2019-03-28 02:07:42','O010'),('2019-03-28 02:08:39','O011'),('2019-03-28 02:09:12','O010'),('2019-03-28 02:09:21','O011'),('2019-03-28 02:28:35','O010'),('2019-03-28 02:29:10','O011'),('2019-03-28 02:49:10','O010'),('2019-03-28 02:49:44','O011'),('2019-03-28 03:06:13','O040'),('2019-03-28 03:06:24','O041'),('2019-03-28 03:09:43','O010'),('2019-03-28 03:10:42','O011'),('2019-03-28 03:30:38','O010'),('2019-03-28 03:31:11','O011'),('2019-03-28 03:51:12','O010'),('2019-03-28 03:52:11','O011'),('2019-03-28 04:12:16','O010'),('2019-03-28 04:12:45','O011'),('2019-03-28 04:32:39','O010'),('2019-03-28 04:33:39','O011'),('2019-03-28 04:53:43','O010'),('2019-03-28 04:54:38','O011'),('2019-03-28 05:14:42','O010'),('2019-03-28 05:15:37','O011'),('2019-03-28 05:53:10','O010'),('2019-03-28 05:53:18','O011'),('2019-03-28 05:54:40','O010'),('2019-03-28 05:55:14','O011'),('2019-03-28 06:15:07','O010'),('2019-03-28 06:16:09','O011'),('2019-03-28 06:45:06','G06S'),('2019-03-28 06:51:06','E04'),('2019-03-28 07:07:46','O010'),('2019-03-28 07:08:32','O011'),('2019-03-28 07:28:36','O010'),('2019-03-28 07:29:07','O011'),('2019-03-28 07:49:07','O010'),('2019-03-28 07:50:07','O011'),('2019-03-28 08:11:42','O010'),('2019-03-28 08:12:36','O011'),('2019-03-28 08:18:05','R24B02LK'),('2019-03-28 08:32:31','O010'),('2019-03-28 08:33:03','O011'),('2019-03-28 08:53:03','O010'),('2019-03-28 08:53:32','O011'),('2019-03-28 09:13:29','O010'),('2019-03-28 09:14:32','O011'),('2019-03-28 09:41:27','O010'),('2019-03-28 09:42:01','O011'),('2019-03-28 10:01:58','O010'),('2019-03-28 10:02:30','O011'),('2019-03-28 10:16:34','O010'),('2019-03-28 10:16:44','O011'),('2019-03-28 10:16:51','O010'),('2019-03-28 10:16:52','O011'),('2019-03-28 10:17:24','O010'),('2019-03-28 10:17:58','O011'),('2019-03-28 10:18:35','O010'),('2019-03-28 10:18:44','O011'),('2019-03-28 10:29:42','O010'),('2019-03-28 10:29:51','O011'),('2019-03-28 10:29:59','O010'),('2019-03-28 10:30:32','O010'),('2019-03-28 10:30:48','O011'),('2019-03-28 10:30:55','O010'),('2019-03-28 10:30:56','O011'),('2019-03-28 10:31:03','O010'),('2019-03-28 10:31:06','O011'),('2019-03-28 10:31:11','O010'),('2019-03-28 10:31:12','O011'),('2019-03-28 10:31:42','O010'),('2019-03-28 10:31:59','O011'),('2019-03-28 10:32:32','O010'),('2019-03-28 10:32:48','O011'),('2019-03-28 10:33:21','O010'),('2019-03-28 10:33:33','O011'),('2019-03-28 10:40:15','O010'),('2019-03-28 10:40:30','O011'),('2019-03-28 10:40:37','O010'),('2019-03-28 10:41:09','O010'),('2019-03-28 10:41:40','O011'),('2019-03-28 10:42:07','O010'),('2019-03-28 10:42:08','O011'),('2019-03-28 10:44:20','O010'),('2019-03-28 10:44:33','O011'),('2019-03-28 10:45:55','O010'),('2019-03-28 10:46:13','O011'),('2019-03-28 10:46:46','O010'),('2019-03-28 10:47:04','O011'),('2019-03-28 10:47:35','O010'),('2019-03-28 10:47:49','O011'),('2019-03-28 10:47:50','O010'),('2019-03-28 10:48:00','O011'),('2019-03-28 10:48:07','O010'),('2019-03-28 10:48:08','O011'),('2019-03-28 10:48:40','O010'),('2019-03-28 10:49:01','O011'),('2019-03-28 10:49:09','O010'),('2019-03-28 10:49:41','O010'),('2019-03-28 10:49:51','O011'),('2019-03-28 10:49:58','O010'),('2019-03-28 10:50:31','O010'),('2019-03-28 10:51:46','O011'),('2019-03-28 10:51:53','O010'),('2019-03-28 10:51:54','O011'),('2019-03-28 10:52:21','O010'),('2019-03-28 10:52:24','O011'),('2019-03-28 10:52:38','O010'),('2019-03-28 10:53:11','O010'),('2019-03-28 11:04:14','O011'),('2019-03-28 11:04:21','O010'),('2019-03-28 11:04:22','O011'),('2019-03-28 11:04:54','O010'),('2019-03-28 11:21:37','O040'),('2019-03-28 11:21:49','O041'),('2019-03-28 11:28:15','O011'),('2019-03-28 11:31:10','R24B02LK'),('2019-03-28 11:31:11','R24B06LK'),('2019-03-28 17:03:39','V0202'),('2019-03-28 17:33:42','O010'),('2019-03-28 17:33:52','O011'),('2019-03-28 17:47:22','O010'),('2019-03-28 17:47:31','O011'),('2019-03-28 17:48:20','O010'),('2019-03-28 17:48:29','O011'),('2019-03-28 17:49:04','O010'),('2019-03-28 17:54:48','O011'),('2019-03-28 17:54:49','O011'),('2019-03-28 17:55:21','O010'),('2019-03-28 17:55:38','O011'),('2019-03-28 17:55:46','O010'),('2019-03-28 17:56:32','O010'),('2019-03-28 17:56:54','O011'),('2019-03-28 17:57:32','O010'),('2019-03-28 17:57:47','O011'),('2019-03-28 17:57:55','O010'),('2019-03-28 17:58:32','O010'),('2019-03-28 17:58:53','O011'),('2019-03-28 17:59:27','O010'),('2019-03-28 17:59:36','O011'),('2019-03-28 18:05:38','O010'),('2019-03-28 18:05:48','O011'),('2019-03-28 18:05:55','O010'),('2019-03-28 18:06:24','O010'),('2019-03-28 18:06:28','O011'),('2019-03-28 18:06:35','O010'),('2019-03-28 18:06:36','O011'),('2019-03-28 18:07:09','O010'),('2019-03-28 18:07:24','O011'),('2019-03-28 18:08:04','O010'),('2019-03-28 18:08:20','O011'),('2019-03-28 18:08:27','O010'),('2019-03-28 18:08:28','O011'),('2019-03-28 18:08:59','O010'),('2019-03-28 18:10:55','O011'),('2019-03-28 18:12:45','O010'),('2019-03-28 18:16:10','O011'),('2019-03-28 18:16:18','O010'),('2019-03-28 18:16:51','O010'),('2019-03-28 18:17:12','O011'),('2019-03-28 18:18:36','O010'),('2019-03-28 18:19:13','O011'),('2019-03-28 18:32:16','R24B01LK'),('2019-03-28 18:38:06','G08S'),('2019-03-28 18:50:12','R24B06LK'),('2019-03-28 18:53:06','E03'),('2019-03-28 19:08:06','E01'),('2019-03-28 19:22:36','A0200'),('2019-03-28 19:35:30','O040'),('2019-03-28 19:35:41','O041'),('2019-03-28 20:01:22','V0202'),('2019-03-28 20:21:20','O010'),('2019-03-28 20:21:53','O011'),('2019-03-28 20:22:09','A0214'),('2019-03-28 21:47:21','O010'),('2019-03-28 21:47:30','O011'),('2019-03-28 22:34:50','O010'),('2019-03-28 22:34:59','O011'),('2019-03-28 23:29:15','O010'),('2019-03-28 23:29:23','O011'),('2019-03-28 23:37:06','G09S'),('2019-03-28 23:38:11','O010'),('2019-03-28 23:38:20','O011'),('2019-02-01 00:00:06','E02'),('2019-02-01 03:26:24','O040'),('2019-02-01 03:27:02','O041'),('2019-02-01 06:42:00','R24B01LK'),('2019-02-01 06:45:06','G06S'),('2019-02-01 07:12:06','E04'),('2019-02-01 08:00:17','O030'),('2019-02-01 08:00:44','O031'),('2019-02-01 08:39:07','R24B06LK'),('2019-02-01 10:02:08','I01G10'),('2019-02-01 11:42:15','O040'),('2019-02-01 11:42:26','O041'),('2019-02-01 16:34:06','G08S'),('2019-02-01 16:49:06','E03'),('2019-02-01 17:04:06','E01'),('2019-02-01 19:56:11','O040'),('2019-02-01 19:56:20','O041'),('2019-02-01 23:37:06','G09S'),('2019-03-29 00:00:06','E02'),('2019-03-29 03:50:54','O040'),('2019-03-29 03:51:32','O041'),('2019-03-29 06:45:06','G06S'),('2019-03-29 06:50:06','E04'),('2019-03-29 07:57:48','R24B06LK'),('2019-03-29 08:16:06','R24B01LK'),('2019-03-29 08:33:47','R24B06LK'),('2019-03-29 12:06:44','O040'),('2019-03-29 12:06:57','O041'),('2019-03-29 12:27:41','I01G10'),('2019-03-29 13:02:17','V0202'),('2019-03-29 18:29:15','I01G08'),('2019-03-29 18:39:06','G08S'),('2019-03-29 18:54:06','E03'),('2019-03-29 19:09:06','E01'),('2019-03-29 19:33:35','I01G08'),('2019-03-29 20:20:43','O040'),('2019-03-29 20:20:51','O041'),('2019-03-29 20:25:59','O010'),('2019-03-29 20:26:08','O011'),('2019-03-29 20:35:40','O010'),('2019-03-29 20:37:33','O011'),('2019-03-29 20:37:38','O010'),('2019-03-29 20:38:11','O010'),('2019-03-29 20:38:39','O011'),('2019-03-29 20:39:11','O010'),('2019-03-29 20:41:02','O011'),('2019-03-29 20:41:47','O010'),('2019-03-29 20:41:58','O011'),('2019-03-29 20:48:28','O010'),('2019-03-29 20:48:36','O011'),('2019-03-29 21:00:00','O010'),('2019-03-29 21:00:58','O011'),('2019-03-29 21:36:17','O010'),('2019-03-29 21:36:26','O011'),('2019-03-29 21:42:32','O010'),('2019-03-29 21:42:41','O011'),('2019-03-29 21:47:15','O010'),('2019-03-29 21:47:24','O011'),('2019-03-29 21:48:15','O010'),('2019-03-29 21:49:08','O011'),('2019-03-29 21:51:24','O010'),('2019-03-29 21:52:49','O011'),('2019-03-29 21:55:05','O010'),('2019-03-29 21:55:43','O011'),('2019-03-29 21:56:15','O010'),('2019-03-29 21:56:24','O011'),('2019-03-29 21:59:25','O010'),('2019-03-29 22:00:00','O011'),('2019-03-29 22:19:59','O010'),('2019-03-29 22:20:33','O011'),('2019-03-29 22:24:57','R24B01LK'),('2019-03-29 22:51:20','O010'),('2019-03-29 22:51:28','O011'),('2019-03-29 22:52:31','O010'),('2019-03-29 22:52:43','O011'),('2019-03-29 23:10:09','A0200'),('2019-03-29 23:12:59','R20B05LK'),('2019-03-29 23:25:34','R24B03LK'),('2019-03-29 23:30:08','O010'),('2019-03-29 23:30:42','O011'),('2019-03-29 23:37:06','G09S'),('2019-02-02 00:00:06','E02'),('2019-02-02 04:10:07','O040'),('2019-02-02 04:10:15','O041'),('2019-02-02 06:45:06','G06S'),('2019-02-02 07:11:06','E04'),('2019-02-02 12:25:29','O040'),('2019-02-02 12:25:40','O041'),('2019-02-02 16:35:06','G08S'),('2019-02-02 16:50:06','E03'),('2019-02-02 17:05:06','E01'),('2019-02-02 20:39:24','O040'),('2019-02-02 20:40:00','O041'),('2019-02-02 23:37:06','G09S'),('2019-03-30 00:00:06','E02'),('2019-03-30 04:36:07','O040'),('2019-03-30 04:36:16','O041'),('2019-03-30 06:45:06','G06S'),('2019-03-30 06:48:06','E04'),('2019-03-30 08:04:09','R24B01LK'),('2019-03-30 08:43:52','R24B06LK'),('2019-03-30 09:41:31','R24B06LK'),('2019-03-30 09:56:10','V0203'),('2019-03-30 09:57:32','O010'),('2019-03-30 09:59:23','O011'),('2019-03-30 12:50:00','O040'),('2019-03-30 12:50:10','O041'),('2019-03-30 14:59:40','O010'),('2019-03-30 15:07:11','O011'),('2019-03-30 18:40:06','G08S'),('2019-03-30 18:55:06','E03'),('2019-03-30 19:10:06','E01'),('2019-03-30 21:03:24','O010'),('2019-03-30 21:05:24','O040'),('2019-03-30 21:06:02','O041'),('2019-03-30 22:16:46','O011'),('2019-03-30 22:42:56','A0200'),('2019-03-30 23:37:06','G09S'),('2019-02-03 00:00:06','E02'),('2019-02-03 04:53:45','O040'),('2019-02-03 04:53:54','O041'),('2019-02-03 06:45:06','G06S'),('2019-02-03 07:10:06','E04'),('2019-02-03 13:07:36','O040'),('2019-02-03 13:07:49','O041'),('2019-02-03 16:37:06','G08S'),('2019-02-03 16:52:06','E03'),('2019-02-03 17:07:06','E01'),('2019-02-03 21:23:03','O040'),('2019-02-03 21:23:13','O041'),('2019-02-03 23:37:06','G09S'),('2019-03-31 00:00:06','E02'),('2019-03-31 05:21:14','O040'),('2019-03-31 05:21:25','O041'),('2019-03-31 06:45:06','G06S'),('2019-03-31 06:47:06','E04'),('2019-03-31 09:05:49','V0202'),('2019-03-31 09:11:47','R24B06LK'),('2019-03-31 10:12:23','A0200'),('2019-03-31 11:07:39','A0514'),('2019-03-31 12:30:19','V0202'),('2019-03-31 13:35:07','O040'),('2019-03-31 13:35:21','O041'),('2019-03-31 14:33:48','R20B01LK'),('2019-03-31 14:33:49','R20B01LK'),('2019-03-31 14:33:54','R20B01LK'),('2019-03-31 14:33:56','R20B06LK'),('2019-03-31 17:02:26','R24B06LK'),('2019-03-31 18:20:26','V0203'),('2019-03-31 18:22:30','V0202'),('2019-03-31 18:41:06','G08S'),('2019-03-31 18:56:06','E03'),('2019-03-31 19:01:29','R24B01LK'),('2019-03-31 19:01:30','R24B02LK'),('2019-03-31 19:11:06','E01'),('2019-03-31 20:12:49','A0203'),('2019-03-31 20:13:38','V0203'),('2019-03-31 21:49:02','O040'),('2019-03-31 21:49:14','O041'),('2019-03-31 22:04:21','A0200'),('2019-03-31 23:20:03','R24B03LK'),('2019-03-31 23:37:06','G09S'),('2019-02-04 00:00:06','E02'),('2019-02-04 05:38:29','O040'),('2019-02-04 05:38:40','O041'),('2019-02-04 06:45:06','G06S'),('2019-02-04 07:09:06','E04'),('2019-02-04 13:52:21','O040'),('2019-02-04 13:52:59','O041'),('2019-02-04 16:38:06','G08S'),('2019-02-04 16:53:06','E03'),('2019-02-04 17:08:06','E01'),('2019-02-04 22:06:41','O040'),('2019-02-04 22:06:52','O041'),('2019-02-04 23:37:06','G09S'),('2019-04-01 00:00:06','E02'),('2019-04-01 06:04:25','O040'),('2019-04-01 06:04:38','O041'),('2019-04-01 06:22:09','R24B01LK'),('2019-04-01 06:22:10','R24B02LK'),('2019-04-01 06:45:06','G06S'),('2019-04-01 07:06:17','R24B03LK'),('2019-04-01 07:49:55','R24B06LK'),('2019-04-01 12:43:02','I01G10'),('2019-04-01 12:43:04','A0500'),('2019-04-01 14:19:49','O040'),('2019-04-01 14:20:28','O041'),('2019-04-01 18:42:06','G08S'),('2019-04-01 18:57:06','E03'),('2019-04-01 18:59:21','V0202'),('2019-04-01 19:12:06','E01'),('2019-04-01 22:21:11','R24B01LK'),('2019-04-01 22:24:53','R20B05LK'),('2019-04-01 22:28:27','O030'),('2019-04-01 22:29:14','O031'),('2019-04-01 22:34:14','O040'),('2019-04-01 22:34:22','O041'),('2019-04-01 22:34:53','R24B03LK'),('2019-04-01 22:49:21','O030'),('2019-04-01 22:50:09','O031'),('2019-04-01 23:10:13','O030'),('2019-04-01 23:10:46','O031'),('2019-04-01 23:30:50','O030'),('2019-04-01 23:31:20','O031'),('2019-04-01 23:37:06','G09S'),('2019-04-01 23:51:24','O030'),('2019-04-01 23:51:57','O031'),('2019-02-05 00:00:06','E02'),('2019-02-05 06:20:37','O040'),('2019-02-05 06:20:47','O041'),('2019-02-05 06:45:06','G06S'),('2019-02-05 07:08:06','E04'),('2019-02-05 14:34:33','O040'),('2019-02-05 14:34:42','O041'),('2019-02-05 16:39:06','G08S'),('2019-02-05 16:54:06','E03'),('2019-02-05 17:09:06','E01'),('2019-02-05 22:48:25','O040'),('2019-02-05 22:48:37','O041'),('2019-02-05 23:37:06','G09S'),('2019-04-02 00:00:06','E02'),('2019-04-02 00:31:41','O030'),('2019-04-02 00:32:29','O031'),('2019-04-02 00:52:34','O030'),('2019-04-02 00:53:11','O031'),('2019-04-02 01:19:40','O030'),('2019-04-02 01:19:42','O031'),('2019-04-02 02:16:30','O030'),('2019-04-02 02:17:07','O031'),('2019-04-02 02:37:10','O030'),('2019-04-02 02:38:02','O031'),('2019-04-02 02:58:06','O030'),('2019-04-02 02:58:36','O031'),('2019-04-02 03:18:38','O030'),('2019-04-02 03:19:14','O031'),('2019-04-02 03:39:17','O030'),('2019-04-02 03:39:48','O031'),('2019-04-02 03:59:52','O030'),('2019-04-02 04:00:23','O031'),('2019-04-02 04:20:27','O030'),('2019-04-02 04:20:57','O031'),('2019-04-02 04:40:58','O030'),('2019-04-02 04:41:35','O031'),('2019-04-02 05:01:37','O030'),('2019-04-02 05:02:14','O031'),('2019-04-02 05:22:17','O030'),('2019-04-02 05:22:53','O031'),('2019-04-02 05:42:58','O030'),('2019-04-02 05:43:27','O031'),('2019-04-02 06:03:29','O030'),('2019-04-02 06:03:57','O031'),('2019-04-02 06:23:58','O030'),('2019-04-02 06:24:30','O031'),('2019-04-02 06:43:06','E04'),('2019-04-02 06:45:06','G06S'),('2019-04-02 06:49:38','O040'),('2019-04-02 06:49:47','O041'),('2019-04-02 06:52:49','O030'),('2019-04-02 06:53:35','O031'),('2019-04-02 07:13:39','O030'),('2019-04-02 07:14:10','O031'),('2019-04-02 07:34:13','O030'),('2019-04-02 07:34:45','O031'),('2019-04-02 07:54:49','O030'),('2019-04-02 07:55:22','O031'),('2019-04-02 08:15:24','O030'),('2019-04-02 08:16:15','O031'),('2019-04-02 08:21:56','R24B01LK'),('2019-04-02 08:36:19','O030'),('2019-04-02 08:37:10','O031'),('2019-04-02 08:57:12','O030'),('2019-04-02 08:57:46','O031'),('2019-04-02 09:17:50','O030'),('2019-04-02 09:18:37','O031'),('2019-04-02 09:38:38','O030'),('2019-04-02 09:39:21','O031'),('2019-04-02 09:41:40','I01G10'),('2019-04-02 09:59:26','O030'),('2019-04-02 09:59:56','O031'),('2019-04-02 10:19:58','O030'),('2019-04-02 10:20:32','O031'),('2019-04-02 10:43:56','R25B02LK'),('2019-04-02 10:47:20','R24B02LK'),('2019-04-02 10:49:56','R26B05LK'),('2019-04-02 10:58:07','O030'),('2019-04-02 10:58:33','O031'),('2019-04-02 11:07:13','R24B06LK'),('2019-04-02 13:13:08','R24B06LK'),('2019-04-02 15:05:03','O040'),('2019-04-02 15:05:12','O041'),('2019-04-02 17:24:44','O010'),('2019-04-02 17:24:53','O011'),('2019-04-02 18:43:06','G08S'),('2019-04-02 18:58:06','E03'),('2019-04-02 19:13:06','E01'),('2019-04-02 19:47:37','V0202'),('2019-04-02 20:17:09','A0200'),('2019-04-02 20:17:24','A0214'),('2019-04-02 20:51:54','V0202'),('2019-04-02 20:51:55','A0202'),('2019-04-02 21:04:16','O030'),('2019-04-02 21:04:43','O031'),('2019-04-02 21:43:05','O030'),('2019-04-02 21:43:39','O031'),('2019-04-02 21:52:15','O010'),('2019-04-02 21:52:24','O011'),('2019-04-02 22:59:27','O030'),('2019-04-02 23:00:07','O031'),('2019-04-02 23:15:12','A0200'),('2019-04-02 23:18:56','O040'),('2019-04-02 23:19:06','O041'),('2019-04-02 23:23:34','R24B01LK'),('2019-04-02 23:37:06','G09S'),('2019-04-02 23:42:22','R24B03LK'),('2019-02-06 00:00:06','E02'),('2019-02-06 06:45:06','G06S'),('2019-02-06 07:02:21','O040'),('2019-02-06 07:02:57','O041'),('2019-02-06 07:07:06','E04'),('2019-02-06 15:16:42','O040'),('2019-02-06 15:16:53','O041'),('2019-02-06 16:40:06','G08S'),('2019-02-06 16:55:06','E03'),('2019-02-06 17:10:06','E01'),('2019-02-06 17:59:17','R24B01LK'),('2019-02-06 19:12:44','V0202'),('2019-02-06 21:44:45','A0200'),('2019-02-06 22:52:47','R20B06LK'),('2019-02-06 22:52:52','R20B05LK'),('2019-02-06 23:04:16','R24B03LK'),('2019-02-06 23:32:04','O040'),('2019-02-06 23:32:19','O041'),('2019-02-06 23:37:06','G09S'),('2019-04-03 00:00:06','E02'),('2019-04-03 06:42:06','E04'),('2019-04-03 06:45:06','G06S'),('2019-04-03 07:32:50','O040'),('2019-04-03 07:33:26','O041'),('2019-04-03 08:28:13','R24B02LK'),('2019-04-03 08:28:14','R24B01LK'),('2019-04-03 09:06:47','R24B06LK'),('2019-04-03 12:56:17','R24B06LK'),('2019-04-03 14:34:59','I01G10'),('2019-04-03 14:36:25','R24B06LK'),('2019-04-03 15:47:09','O040'),('2019-04-03 15:47:20','O041'),('2019-04-03 17:24:47','V0202'),('2019-04-03 18:29:24','A0200'),('2019-04-03 18:44:06','G08S'),('2019-04-03 18:58:48','V0202'),('2019-04-03 18:59:03','A0200'),('2019-04-03 18:59:06','E03'),('2019-04-03 18:59:21','V0202'),('2019-04-03 19:14:06','E01'),('2019-04-03 22:26:19','A0200'),('2019-04-03 22:29:26','R24B01LK'),('2019-04-03 22:50:34','R24B03LK'),('2019-04-03 23:37:06','G09S'),('2019-02-07 00:00:06','E02'),('2019-02-07 06:27:00','R24B01LK'),('2019-02-07 06:45:06','G06S'),('2019-02-07 07:07:06','E04'),('2019-02-07 07:21:52','R24B02LK'),('2019-02-07 07:47:29','O040'),('2019-02-07 07:47:42','O041'),('2019-02-07 08:05:55','R24B06LK'),('2019-02-07 10:21:14','R24B01LK'),('2019-02-07 10:34:18','R24B06LK'),('2019-02-07 11:17:06','R26B05LK'),('2019-02-07 11:18:13','R26B05LK'),('2019-02-07 11:18:31','R26B05LK'),('2019-02-07 11:30:09','R24B06LK'),('2019-02-07 16:02:56','O040'),('2019-02-07 16:03:05','O041'),('2019-02-07 16:42:06','G08S'),('2019-02-07 16:57:06','E03'),('2019-02-07 17:12:06','E01'),('2019-02-07 18:26:43','R24B01LK'),('2019-02-07 18:27:45','R24B06LK'),('2019-02-07 22:28:08','R20B05LK'),('2019-02-07 23:37:06','G09S'),('2019-04-04 00:00:06','E02'),('2019-04-04 00:02:34','O040'),('2019-04-04 00:02:47','O041'),('2019-04-04 06:40:06','E04'),('2019-04-04 06:45:06','G06S'),('2019-04-04 07:31:43','R24B01LK'),('2019-04-04 08:16:28','O040'),('2019-04-04 08:16:40','O041'),('2019-04-04 10:44:45','R24B01LK'),('2019-04-04 16:30:21','O040'),('2019-04-04 16:30:33','O041'),('2019-04-04 18:38:20','O030'),('2019-04-04 18:38:48','O031'),('2019-04-04 18:46:06','G08S'),('2019-04-04 19:01:06','E03'),('2019-04-04 19:16:06','E01'),('2019-04-04 20:52:12','A0214'),('2019-04-04 21:44:45','V0202'),('2019-04-04 22:03:14','O010'),('2019-04-04 22:03:23','O011'),('2019-04-04 22:43:17','A0200'),('2019-04-04 22:46:40','R24B01LK'),('2019-04-04 23:02:36','R20B05LK'),('2019-04-04 23:21:18','R24B03LK'),('2019-04-04 23:37:06','G09S'),('2019-02-08 00:00:06','E02'),('2019-02-08 00:18:17','O040'),('2019-02-08 00:18:56','O041'),('2019-02-08 06:45:06','G06S'),('2019-02-08 06:55:36','R24B01LK'),('2019-02-08 07:05:06','E04'),('2019-02-08 07:25:55','R24B06LK'),('2019-02-08 08:24:15','R05B01LK'),('2019-02-08 08:34:09','O040'),('2019-02-08 08:34:21','O041'),('2019-02-08 08:54:48','R05B06LK'),('2019-02-08 08:54:50','A0500'),('2019-02-08 09:14:28','V0103'),('2019-02-08 09:15:12','A0100'),('2019-02-08 09:59:13','I01G10'),('2019-02-08 10:31:02','R24B06LK'),('2019-02-08 16:43:06','G08S'),('2019-02-08 16:48:03','O040'),('2019-02-08 16:48:16','O041'),('2019-02-08 16:58:06','E03'),('2019-02-08 17:13:06','E01'),('2019-02-08 17:18:11','R24B01LK'),('2019-02-08 17:48:38','V0202'),('2019-02-08 23:07:09','R20B05LK'),('2019-02-08 23:32:34','R24B03LK'),('2019-02-08 23:37:06','G09S'),('2019-04-05 00:00:06','E02'),('2019-04-05 00:44:20','O040'),('2019-04-05 00:44:53','O041'),('2019-04-05 06:38:06','E04'),('2019-04-05 06:45:06','G06S'),('2019-04-05 07:55:32','R24B01LK'),('2019-04-05 07:55:34','R24B02LK'),('2019-04-05 08:38:19','R24B06LK'),('2019-04-05 09:00:10','O040'),('2019-04-05 09:00:19','O041'),('2019-04-05 17:14:26','V0202'),('2019-04-05 17:15:18','A0200'),('2019-04-05 17:15:34','O040'),('2019-04-05 17:15:45','O041'),('2019-04-05 18:00:48','V0202'),('2019-04-05 18:47:06','G08S'),('2019-04-05 19:02:06','E03'),('2019-04-05 19:17:06','E01'),('2019-04-05 20:31:43','A0200'),('2019-04-05 20:32:17','A0214'),('2019-04-05 21:09:36','V0202'),('2019-04-05 22:38:59','R24B01LK'),('2019-04-05 22:57:40','A0200'),('2019-04-05 23:37:06','G09S'),('2019-02-09 00:00:06','E02'),('2019-02-09 01:03:26','O040'),('2019-02-09 01:03:39','O041'),('2019-02-09 06:45:06','G06S'),('2019-02-09 07:04:06','E04'),('2019-02-09 07:39:00','R24B01LK'),('2019-02-09 08:38:01','R24B06LK'),('2019-02-09 09:18:15','H'),('2019-02-09 09:18:20','O021'),('2019-02-09 09:24:53','O040'),('2019-02-09 09:25:06','O041'),('2019-02-09 09:26:16','O040'),('2019-02-09 09:27:32','O041'),('2019-02-09 10:48:18','R24B06LK'),('2019-02-09 14:38:59','R24B06LK'),('2019-02-09 16:44:06','G08S'),('2019-02-09 16:59:06','E03'),('2019-02-09 17:14:06','E01'),('2019-02-09 17:41:18','O040'),('2019-02-09 17:41:28','O041'),('2019-02-09 17:43:55','V0202'),('2019-02-09 17:43:56','A0202'),('2019-02-09 17:47:59','R24B01LK'),('2019-02-09 17:48:09','R26B05LK'),('2019-02-09 17:48:29','R26B05LK'),('2019-02-09 17:48:54','R24B06LK'),('2019-02-09 20:53:46','A0200'),('2019-02-09 21:16:33','V0202'),('2019-02-09 21:55:44','A0200'),('2019-02-09 22:11:40','R24B01LK'),('2019-02-09 22:14:53','R20B05LK'),('2019-02-09 22:28:23','R24B03LK'),('2019-02-09 23:37:06','G09S'),('2019-04-06 00:00:06','E02'),('2019-04-06 00:15:45','R24B03LK'),('2019-04-06 01:30:57','O040'),('2019-04-06 01:31:09','O041'),('2019-04-06 02:32:34','O030'),('2019-04-06 02:33:08','O031'),('2019-04-06 03:48:15','O030'),('2019-04-06 03:48:41','O031'),('2019-04-06 05:04:53','O030'),('2019-04-06 05:05:19','O031'),('2019-04-06 06:37:06','E04'),('2019-04-06 06:45:06','G06S'),('2019-04-06 08:46:36','R24B06LK'),('2019-04-06 08:46:50','O030'),('2019-04-06 08:47:12','O031'),('2019-04-06 08:58:23','R24B02LK'),('2019-04-06 09:26:38','O030'),('2019-04-06 09:27:26','O031'),('2019-04-06 09:46:21','O040'),('2019-04-06 09:46:32','O041'),('2019-04-06 12:43:31','V0202'),('2019-04-06 18:00:15','O040'),('2019-04-06 18:00:53','O041'),('2019-04-06 18:48:06','G08S'),('2019-04-06 19:03:06','E03'),('2019-04-06 19:18:06','E01'),('2019-04-06 22:45:58','A0200'),('2019-04-06 22:49:45','R24B01LK'),('2019-04-06 23:05:59','R20B05LK'),('2019-04-06 23:17:23','R24B03LK'),('2019-04-06 23:37:06','G09S'),('2019-02-10 00:00:06','E02'),('2019-02-10 01:56:42','O040'),('2019-02-10 01:56:53','O041'),('2019-02-10 06:00:35','I01G06'),('2019-02-10 06:43:18','R26B01LK'),('2019-02-10 06:43:21','R26B01LK'),('2019-02-10 06:43:28','R25B04LK'),('2019-02-10 06:45:06','G06S'),('2019-02-10 06:49:29','R25B04LK'),('2019-02-10 06:51:08','R24B06LK'),('2019-02-10 07:03:06','E04'),('2019-02-10 07:11:39','R24B01LK'),('2019-02-10 07:36:26','R24B06LK'),('2019-02-10 10:12:07','O040'),('2019-02-10 10:12:17','O041'),('2019-02-10 12:16:03','V0202'),('2019-02-10 13:57:18','R24B06LK'),('2019-02-10 14:11:26','R24B06LK'),('2019-02-10 16:45:06','G08S'),('2019-02-10 17:00:06','E03'),('2019-02-10 17:15:06','E01'),('2019-02-10 18:26:00','O040'),('2019-02-10 18:26:10','O041'),('2019-02-10 19:24:51','R24B01LK'),('2019-02-10 19:26:26','R24B03LK'),('2019-02-10 20:57:45','R24B01LK'),('2019-02-10 20:58:51','R24B06LK'),('2019-02-10 22:43:26','A0200'),('2019-02-10 22:46:13','R24B01LK'),('2019-02-10 23:10:18','R24B03LK'),('2019-02-10 23:10:22','R24B01LK'),('2019-02-10 23:12:54','R24B03LK'),('2019-02-10 23:25:31','R16B05LK'),('2019-02-10 23:37:06','G09S'),('2019-04-07 00:00:06','E02'),('2019-04-07 02:16:05','O040'),('2019-04-07 02:16:18','O041'),('2019-04-07 06:35:06','E04'),('2019-04-07 06:45:06','G06S'),('2019-04-07 09:20:13','R24B01LK'),('2019-04-07 09:20:14','R24B02LK'),('2019-04-07 09:36:59','V0202'),('2019-04-07 10:28:54','A0514'),('2019-04-07 10:31:34','O040'),('2019-04-07 10:31:42','O041'),('2019-04-07 10:41:54','R24B06LK'),('2019-04-07 11:18:27','A0200'),('2019-04-07 13:15:19','V0202'),('2019-04-07 18:45:27','O040'),('2019-04-07 18:45:36','O041'),('2019-04-07 18:45:40','A0200'),('2019-04-07 18:49:06','G08S'),('2019-04-07 19:04:06','E03'),('2019-04-07 19:04:22','R24B01LK'),('2019-04-07 19:15:08','O010'),('2019-04-07 19:15:17','O011'),('2019-04-07 19:19:06','E01'),('2019-04-07 19:19:20','V0202'),('2019-04-07 19:19:28','A0200'),('2019-04-07 19:21:29','R24B06LK'),('2019-04-07 20:45:52','V0202'),('2019-04-07 21:28:59','O010'),('2019-04-07 21:29:11','O011'),('2019-04-07 21:29:15','O010'),('2019-04-07 21:29:16','O011'),('2019-04-07 21:29:23','O010'),('2019-04-07 21:29:24','O011'),('2019-04-07 21:29:54','O010'),('2019-04-07 21:31:22','O011'),('2019-04-07 21:31:24','O010'),('2019-04-07 21:31:54','O010'),('2019-04-07 21:32:38','O011'),('2019-04-07 21:32:44','O010'),('2019-04-07 21:32:45','O011'),('2019-04-07 21:33:11','O010'),('2019-04-07 21:33:18','O011'),('2019-04-07 21:33:54','O010'),('2019-04-07 21:34:45','O011'),('2019-04-07 21:34:51','O010'),('2019-04-07 21:34:52','O011'),('2019-04-07 21:35:15','O010'),('2019-04-07 21:35:18','O011'),('2019-04-07 21:35:37','O010'),('2019-04-07 21:35:38','O011'),('2019-04-07 21:35:43','O011'),('2019-04-07 21:37:05','O010'),('2019-04-07 21:37:14','O011'),('2019-04-07 21:37:50','O010'),('2019-04-07 21:38:00','O011'),('2019-04-07 21:39:00','A0200'),('2019-04-07 21:48:03','O010'),('2019-04-07 21:48:14','O011'),('2019-04-07 21:52:44','O010'),('2019-04-07 21:52:53','O011'),('2019-04-07 21:58:57','O010'),('2019-04-07 21:59:05','O011'),('2019-04-07 21:59:39','O010'),('2019-04-07 22:00:48','O011'),('2019-04-07 22:00:56','O010'),('2019-04-07 22:01:30','O010'),('2019-04-07 22:01:41','O011'),('2019-04-07 22:07:21','O010'),('2019-04-07 22:07:29','O011'),('2019-04-07 22:10:49','O010'),('2019-04-07 22:10:58','O011'),('2019-04-07 22:11:42','O010'),('2019-04-07 22:11:50','O011'),('2019-04-07 22:12:20','O010'),('2019-04-07 22:12:29','O011'),('2019-04-07 22:13:02','O010'),('2019-04-07 22:13:14','O011'),('2019-04-07 22:16:43','R24B01LK'),('2019-04-07 22:33:57','O010'),('2019-04-07 22:34:08','O011'),('2019-04-07 22:34:32','O010'),('2019-04-07 22:35:09','O011'),('2019-04-07 22:55:13','O010'),('2019-04-07 22:56:10','O011'),('2019-04-07 23:16:13','O010'),('2019-04-07 23:17:08','O011'),('2019-04-07 23:37:06','G09S'),('2019-04-07 23:37:08','O010'),('2019-04-07 23:38:11','O011'),('2019-04-07 23:38:43','O010'),('2019-04-07 23:38:51','O011'),('2019-04-07 23:58:14','O010'),('2019-04-07 23:59:12','O011'),('2019-02-13 00:00:06','E02'),('2019-02-13 00:24:09','V0203'),('2019-02-13 00:29:42','V0206'),('2019-02-13 02:09:33','G09'),('2019-02-13 02:10:35','A0209'),('2019-02-13 02:10:48','A0609'),('2019-02-13 02:11:58','A0301'),('2019-02-13 02:12:14','I04G09'),('2019-02-13 03:13:02','O010'),('2019-02-13 03:13:11','O011'),('2019-02-13 04:13:12','O040'),('2019-02-13 04:13:26','O041'),('2019-02-13 05:30:58','O010'),('2019-02-13 06:45:06','G06S'),('2019-02-13 06:59:06','E04'),('2019-02-13 07:51:09','O011'),('2019-02-13 07:52:05','O010'),('2019-02-13 08:39:59','O011'),('2019-02-13 08:40:35','A0214'),('2019-02-13 12:27:06','O040'),('2019-02-13 12:27:20','O041'),('2019-02-13 16:49:06','G08S'),('2019-02-13 17:04:06','E03'),('2019-02-13 17:19:06','E01'),('2019-02-13 20:42:30','O040'),('2019-02-13 20:42:43','O041'),('2019-02-13 23:25:07','I01G09'),('2019-02-13 23:37:06','G09S'),('2019-04-08 00:00:06','E02'),('2019-04-08 00:08:37','R24B03LK'),('2019-04-08 00:14:02','O010'),('2019-04-08 00:14:16','O011'),('2019-04-08 00:14:24','O010'),('2019-04-08 00:14:33','O011'),('2019-04-08 00:19:16','O010'),('2019-04-08 00:20:29','O011'),('2019-04-08 00:40:15','O010'),('2019-04-08 00:41:10','O011'),('2019-04-08 01:01:14','O010'),('2019-04-08 01:02:09','O011'),('2019-04-08 01:22:13','O010'),('2019-04-08 01:23:08','O011'),('2019-04-08 01:43:08','O010'),('2019-04-08 01:44:06','O011'),('2019-04-08 01:44:36','O010'),('2019-04-08 01:44:45','O011'),('2019-04-08 02:04:10','O010'),('2019-04-08 02:04:44','O011'),('2019-04-08 02:24:44','O010'),('2019-04-08 02:25:44','O011'),('2019-04-08 02:26:14','O010'),('2019-04-08 02:26:23','O011'),('2019-04-08 02:45:45','O010'),('2019-04-08 02:46:36','O011'),('2019-04-08 02:59:21','O040'),('2019-04-08 02:59:33','O041'),('2019-04-08 03:06:37','O010'),('2019-04-08 03:07:11','O011'),('2019-04-08 03:27:11','O010'),('2019-04-08 03:28:11','O011'),('2019-04-08 03:48:15','O010'),('2019-04-08 03:49:10','O011'),('2019-04-08 04:09:12','O010'),('2019-04-08 04:09:43','O011'),('2019-04-08 04:29:43','O010'),('2019-04-08 04:30:44','O011'),('2019-04-08 04:50:48','O010'),('2019-04-08 04:51:42','O011'),('2019-04-08 05:11:47','O010'),('2019-04-08 05:12:41','O011'),('2019-04-08 05:32:45','O010'),('2019-04-08 05:33:39','O011'),('2019-04-08 05:53:34','O010'),('2019-04-08 05:54:33','O011'),('2019-04-08 06:14:38','O010'),('2019-04-08 06:15:06','O011'),('2019-04-08 06:34:06','E04'),('2019-04-08 06:35:08','O010'),('2019-04-08 06:35:41','O011'),('2019-04-08 06:45:06','G06S'),('2019-04-08 06:55:41','O010'),('2019-04-08 06:56:18','O011'),('2019-04-08 07:16:15','O010'),('2019-04-08 07:17:09','O011'),('2019-04-08 07:37:04','O010'),('2019-04-08 07:38:04','O011'),('2019-04-08 07:43:09','R24B06LK'),('2019-04-08 07:43:20','O010'),('2019-04-08 07:43:29','O011'),('2019-04-08 07:44:00','O010'),('2019-04-08 07:44:12','O011'),('2019-04-08 07:48:04','R24B01LK'),('2019-04-08 07:57:18','O010'),('2019-04-08 07:57:27','O011'),('2019-04-08 07:57:36','O010'),('2019-04-08 07:58:08','O010'),('2019-04-08 07:58:26','O011'),('2019-04-08 07:58:34','O010'),('2019-04-08 07:59:08','O010'),('2019-04-08 07:59:20','O011'),('2019-04-08 07:59:27','O010'),('2019-04-08 07:59:28','O011'),('2019-04-08 08:00:08','O010'),('2019-04-08 08:01:04','O011'),('2019-04-08 08:01:38','O010'),('2019-04-08 08:01:48','O011'),('2019-04-08 08:02:36','O010'),('2019-04-08 08:02:46','O011'),('2019-04-08 08:03:19','O010'),('2019-04-08 08:03:34','O011'),('2019-04-08 08:03:40','O010'),('2019-04-08 08:03:41','O011'),('2019-04-08 08:04:11','O010'),('2019-04-08 08:04:13','O011'),('2019-04-08 08:05:56','O010'),('2019-04-08 08:06:05','O011'),('2019-04-08 08:09:00','O010'),('2019-04-08 08:09:08','O011'),('2019-04-08 08:17:56','O010'),('2019-04-08 08:18:07','O011'),('2019-04-08 08:18:14','O010'),('2019-04-08 08:18:15','O011'),('2019-04-08 08:18:47','O010'),('2019-04-08 08:18:59','O011'),('2019-04-08 08:20:06','O010'),('2019-04-08 08:20:14','O011'),('2019-04-08 08:32:24','O010'),('2019-04-08 08:32:32','O011'),('2019-04-08 08:36:24','V0202'),('2019-04-08 08:37:13','V0201'),('2019-04-08 08:37:27','V0203'),('2019-04-08 08:37:35','V0202'),('2019-04-08 08:37:40','A0200'),('2019-04-08 09:06:01','O040'),('2019-04-08 09:38:17','O010'),('2019-04-09 13:14:37','H'),('2019-04-09 13:17:46','R08B03LK'),('2019-04-09 13:17:55','R08B04LK'),('2019-04-09 13:18:04','R08B03LK'),('2019-04-09 13:18:14','R08B05LK'),('2019-04-09 13:18:32','R02B05LK'),('2019-04-09 13:18:45','R02B06LK'),('2019-04-09 13:34:11','O021'),('2019-04-09 13:44:24','O020'),('2019-04-09 13:44:32','O021'),('2019-04-09 13:45:39','O020'),('2019-04-09 13:45:47','O021'),('2019-04-09 13:52:05','O020'),('2019-04-09 13:54:34','O021'),('2019-04-09 15:05:16','H'),('2019-04-09 15:06:16','O021'),('2019-04-09 15:07:54','O031'),('2019-04-09 15:09:39','R24B06LK'),('2019-04-09 15:11:02','R05B06LK'),('2019-04-09 18:51:06','G08S'),('2019-04-09 19:06:06','E03'),('2019-04-09 19:21:06','E01'),('2019-04-09 22:50:46','R20B05LK'),('2019-04-09 22:51:30','R24B01LK'),('2019-04-09 23:20:37','R24B03LK'),('2019-04-09 23:37:06','G09S'),('2019-04-09 23:46:04','O010'),('2019-04-10 00:00:06','E02'),('2019-04-10 06:30:06','E04'),('2019-04-10 06:45:06','G06S'),('2019-04-10 08:12:22','R24B06LK'),('2019-04-10 08:21:18','O011'),('2019-04-10 09:51:22','R24B01LK'),('2019-04-10 10:12:58','R26B05LK'),('2019-04-10 10:27:47','R26B05LK'),('2019-04-10 10:32:26','R24B06LK'),('2019-04-10 10:45:02','R24B01LK'),('2019-04-10 10:45:03','R24B02LK'),('2019-04-10 11:09:02','R24B06LK'),('2019-04-10 15:20:08','O030'),('2019-04-10 15:20:52','O031'),('2019-04-10 18:52:06','G08S'),('2019-04-10 19:07:06','E03'),('2019-04-10 19:22:06','E01'),('2019-04-10 22:25:09','R20B05LK'),('2019-04-10 22:47:08','R24B03LK'),('2019-04-10 23:37:06','G09S'),('2019-02-14 00:00:06','E02'),('2019-02-14 04:56:24','O040'),('2019-02-14 04:56:39','O041'),('2019-02-14 06:45:06','G06S'),('2019-02-14 06:58:06','E04'),('2019-02-14 13:10:21','O040'),('2019-02-14 13:10:58','O041'),('2019-02-14 16:19:38','A0600'),('2019-02-14 16:19:56','A0200'),('2019-02-14 16:20:24','A0214'),('2019-02-14 16:50:06','G08S'),('2019-02-14 17:05:06','E03'),('2019-02-14 17:06:04','A2914'),('2019-02-14 17:20:06','E01'),('2019-02-14 18:19:45','A0214'),('2019-02-14 18:21:18','A2900'),('2019-02-14 19:52:45','A2914'),('2019-02-14 20:36:39','A0207'),('2019-02-14 20:37:28','V0203'),('2019-02-14 20:40:58','A0207'),('2019-02-14 20:48:17','A0214'),('2019-02-14 21:30:43','O040'),('2019-02-14 21:30:55','O041'),('2019-02-14 23:37:06','G09S'),('2019-02-14 23:41:03','A0200'),('2019-04-11 00:00:06','E02'),('2019-04-11 06:29:06','E04'),('2019-04-11 06:45:06','G06S'),('2019-04-11 07:32:48','R24B01LK'),('2019-04-11 08:09:07','R05B06LK'),('2019-04-11 10:44:22','O020'),('2019-04-11 10:59:06','R24B01LK'),('2019-04-11 15:24:55','H'),('2019-04-11 15:26:03','O011'),('2019-04-11 15:27:41','O031'),('2019-04-11 15:28:38','O030'),('2019-04-11 15:29:57','O031'),('2019-04-11 18:16:52','O030'),('2019-04-11 18:17:23','O031'),('2019-04-11 18:53:06','G08S'),('2019-04-11 18:58:32','R24B01LK'),('2019-04-11 18:58:36','R24B06LK'),('2019-04-11 18:58:39','R24B01LK'),('2019-04-11 19:04:02','R24B03LK'),('2019-04-11 19:08:06','E03'),('2019-04-11 19:23:06','E01'),('2019-04-11 20:16:55','O030'),('2019-04-11 20:17:23','O031'),('2019-04-11 23:30:13','R24B01LK'),('2019-04-11 23:37:06','G09S'),('2019-04-11 23:51:07','R24B03LK'),('2019-02-15 00:00:06','E02'),('2019-02-15 05:44:34','O040'),('2019-02-15 05:44:46','O041'),('2019-02-15 06:45:06','G06S'),('2019-02-15 06:56:06','E04'),('2019-02-15 09:13:59','A0214'),('2019-02-15 14:00:00','O040'),('2019-02-15 14:00:13','O041'),('2019-02-15 16:52:06','G08S'),('2019-02-15 17:07:06','E03'),('2019-02-15 17:22:06','E01'),('2019-02-15 17:30:11','V0202'),('2019-02-15 17:35:13','R24B01LK'),('2019-02-15 17:40:23','R24B06LK'),('2019-02-15 19:04:41','A0200'),('2019-02-15 22:15:27','O040'),('2019-02-15 22:15:36','O041'),('2019-02-15 23:33:52','R20B05LK'),('2019-02-15 23:34:02','R24B01LK'),('2019-02-15 23:37:06','G09S'),('2019-02-15 23:51:55','R24B03LK'),('2019-04-12 00:00:06','E02'),('2019-04-12 00:48:41','R16B01LK'),('2019-04-12 00:48:47','R20B01LK'),('2019-04-12 00:48:48','R16B01LK'),('2019-04-12 06:27:06','E04'),('2019-04-12 06:45:06','G06S'),('2019-04-12 07:29:13','R24B01LK'),('2019-04-12 07:29:14','R24B02LK'),('2019-04-12 07:36:18','R24B06LK'),('2019-04-12 10:06:11','R24B06LK'),('2019-04-12 12:23:28','H'),('2019-04-12 12:24:31','O011'),('2019-04-12 12:26:03','O031'),('2019-04-12 13:53:02','H'),('2019-04-12 15:44:50','R16B01LK'),('2019-04-12 15:44:54','R16B01LK'),('2019-04-12 15:44:59','R16B01LK'),('2019-04-12 18:54:06','G08S'),('2019-04-12 19:09:06','E03'),('2019-04-12 19:24:06','E01'),('2019-04-12 22:50:54','R16B05LK'),('2019-04-12 22:50:55','G09'),('2019-04-12 22:51:24','R24B01LK'),('2019-04-12 23:06:08','R24B03LK'),('2019-04-12 23:07:30','R24B01LK'),('2019-04-12 23:07:36','R24B03LK'),('2019-04-12 23:37:06','G09S'),('2019-02-16 00:00:06','E02'),('2019-02-16 06:29:18','O040'),('2019-02-16 06:29:57','O041'),('2019-02-16 06:45:06','G06S'),('2019-02-16 06:55:06','E04'),('2019-02-16 08:13:12','R24B01LK'),('2019-02-16 08:13:16','R24B02LK'),('2019-02-16 09:52:13','R24B06LK'),('2019-02-16 14:45:10','O040'),('2019-02-16 14:45:22','O041'),('2019-02-16 14:55:21','V0202'),('2019-02-16 15:06:41','R24B06LK'),('2019-02-16 16:53:06','G08S'),('2019-02-16 17:08:06','E03'),('2019-02-16 17:18:42','R24B01LK'),('2019-02-16 17:20:41','R24B03LK'),('2019-02-16 17:23:06','E01'),('2019-02-16 19:29:09','A0200'),('2019-02-16 21:19:51','R24B01LK'),('2019-02-16 21:21:08','R24B06LK'),('2019-02-16 23:00:36','O040'),('2019-02-16 23:00:48','O041'),('2019-02-16 23:18:08','R20B05LK'),('2019-02-16 23:18:19','R20B05LK'),('2019-02-16 23:18:36','R24B01LK'),('2019-02-16 23:30:20','I01G07'),('2019-02-16 23:33:38','R24B03LK'),('2019-02-16 23:34:29','R16B05LK'),('2019-02-16 23:37:06','G09S'),('2019-04-13 00:00:06','E02'),('2019-04-13 06:26:06','E04'),('2019-04-13 06:45:06','G06S'),('2019-04-13 08:47:18','I01G10'),('2019-04-13 10:20:42','R24B06LK'),('2019-04-13 17:35:12','R24B01LK'),('2019-04-13 17:46:29','R24B06LK'),('2019-04-13 17:47:31','R24B01LK'),('2019-04-13 18:17:40','R24B03LK'),('2019-04-13 18:50:14','I01G08'),('2019-04-13 18:55:06','G08S'),('2019-04-13 19:10:06','E03'),('2019-04-13 19:25:06','E01'),('2019-04-13 23:37:06','G09S'),('2019-02-17 00:00:06','E02'),('2019-02-17 06:45:06','G06S'),('2019-02-17 06:54:06','E04'),('2019-02-17 07:14:33','O040'),('2019-02-17 07:14:43','O041'),('2019-02-17 07:19:43','R24B01LK'),('2019-02-17 07:45:23','R24B02LK'),('2019-02-17 08:03:52','V0202'),('2019-02-17 08:05:43','A0200'),('2019-02-17 08:38:36','R24B06LK'),('2019-02-17 11:55:15','V0202'),('2019-02-17 14:50:39','A0200'),('2019-02-17 15:28:23','O040'),('2019-02-17 15:28:35','O041'),('2019-02-17 16:00:34','V0202'),('2019-02-17 16:54:06','G08S'),('2019-02-17 17:09:06','E03'),('2019-02-17 17:24:06','E01'),('2019-02-17 17:59:56','R24B01LK'),('2019-02-17 18:01:20','R24B03LK'),('2019-02-17 19:06:40','V0201'),('2019-02-17 19:07:47','V0202'),('2019-02-17 21:09:33','V0201'),('2019-02-17 22:14:08','A0200'),('2019-02-17 22:35:09','R24B01LK'),('2019-02-17 23:07:59','R20B05LK'),('2019-02-17 23:19:19','R24B03LK'),('2019-02-17 23:37:06','G09S'),('2019-02-17 23:43:49','O040'),('2019-02-17 23:44:26','O041'),('2019-04-14 00:00:06','E02'),('2019-04-14 00:09:40','R24B03LK'),('2019-04-14 06:24:06','E04'),('2019-04-14 06:45:06','G06S'),('2019-04-14 07:54:20','R24B01LK'),('2019-04-14 08:05:06','R24B06LK'),('2019-04-14 18:56:06','G08S'),('2019-04-14 19:11:06','E03'),('2019-04-14 19:26:06','E01'),('2019-04-14 23:04:42','R20B05LK'),('2019-04-14 23:05:40','R24B01LK'),('2019-04-14 23:24:09','R24B03LK'),('2019-04-14 23:37:06','G09S'),('2019-02-18 00:00:06','E02'),('2019-02-18 06:45:06','G06S'),('2019-02-18 06:53:06','E04'),('2019-02-18 07:47:33','R24B01LK'),('2019-02-18 07:59:41','O040'),('2019-02-18 07:59:50','O041'),('2019-02-18 08:26:41','R24B02LK'),('2019-02-18 09:40:52','R24B06LK'),('2019-02-18 14:11:59','O030'),('2019-02-18 15:04:53','O031'),('2019-02-18 16:15:02','O040'),('2019-02-18 16:15:17','O041'),('2019-02-18 16:55:06','G08S'),('2019-02-18 17:10:06','E03'),('2019-02-18 17:25:06','E01'),('2019-02-18 17:38:34','V0202'),('2019-02-18 18:21:42','R24B01LK'),('2019-02-18 18:24:19','R24B03LK'),('2019-02-18 18:32:31','A0200'),('2019-02-18 19:42:16','V0202'),('2019-02-18 19:42:36','A0200'),('2019-02-18 19:42:58','V0202'),('2019-02-18 19:54:57','A0200'),('2019-02-18 23:13:21','R20B05LK'),('2019-02-18 23:13:23','R24B01LK'),('2019-02-18 23:29:38','R24B03LK'),('2019-02-18 23:37:06','G09S'),('2019-04-15 00:00:06','E02'),('2019-04-15 06:23:06','E04'),('2019-04-15 06:45:06','G06S'),('2019-04-15 07:30:57','R24B01LK'),('2019-04-15 08:45:04','R24B06LK'),('2019-04-15 18:57:06','G08S'),('2019-04-15 19:12:06','E03'),('2019-04-15 19:27:06','E01'),('2019-04-15 23:23:33','R24B01LK'),('2019-04-15 23:26:16','R24B03LK'),('2019-04-15 23:37:06','G09S'),('2019-04-15 23:49:12','R16B05LK'),('2019-02-19 00:00:06','E02'),('2019-02-19 00:30:29','O040'),('2019-02-19 00:30:40','O041'),('2019-02-19 05:52:13','R24B01LK'),('2019-02-19 06:42:21','I01G06'),('2019-02-19 06:45:06','G06S'),('2019-02-19 06:51:06','E04'),('2019-02-19 08:45:55','O040'),('2019-02-19 08:46:05','O041'),('2019-02-19 09:28:25','R24B06LK'),('2019-02-19 10:23:50','I01G10'),('2019-02-19 11:20:16','R24B06LK'),('2019-02-19 16:57:06','G08S'),('2019-02-19 17:01:17','O040'),('2019-02-19 17:01:55','O041'),('2019-02-19 17:12:06','E03'),('2019-02-19 17:27:06','E01'),('2019-02-19 17:29:21','V0202'),('2019-02-19 18:02:59','R24B01LK'),('2019-02-19 19:01:06','A0200'),('2019-02-19 23:12:44','R20B05LK'),('2019-02-19 23:28:42','R24B03LK'),('2019-02-19 23:37:06','G09S'),('2019-04-16 00:00:06','E02'),('2019-04-16 06:21:06','E04'),('2019-04-16 06:45:06','G06S'),('2019-04-16 06:53:52','R24B01LK'),('2019-04-16 07:13:47','R24B03LK'),('2019-04-16 10:54:00','R24B06LK'),('2019-04-16 14:18:34','O010'),('2019-04-16 14:18:43','O011'),('2019-04-16 16:40:28','R16B01LK'),('2019-04-16 16:40:29','R16B01LK'),('2019-04-16 16:40:32','R16B01LK'),('2019-04-16 18:58:06','G08S'),('2019-04-16 19:13:06','E03'),('2019-04-16 19:28:06','E01'),('2019-04-16 22:52:23','R24B01LK'),('2019-04-16 23:15:58','R20B05LK'),('2019-04-16 23:28:19','R24B03LK'),('2019-04-16 23:37:06','G09S'),('2019-02-20 00:00:06','E02'),('2019-02-20 01:17:08','O040'),('2019-02-20 01:17:20','O041'),('2019-02-20 06:45:06','G06S'),('2019-02-20 06:50:06','E04'),('2019-02-20 07:56:17','R24B01LK'),('2019-02-20 07:56:18','R24B02LK'),('2019-02-20 09:32:34','O040'),('2019-02-20 09:32:45','O041'),('2019-02-20 13:05:47','R24B06LK'),('2019-02-20 16:58:06','G08S'),('2019-02-20 17:13:06','E03'),('2019-02-20 17:28:06','E01'),('2019-02-20 17:47:55','O040'),('2019-02-20 17:48:10','O041'),('2019-02-20 23:02:32','R20B05LK'),('2019-02-20 23:03:06','R24B01LK'),('2019-02-20 23:04:03','R16B01LK'),('2019-02-20 23:04:12','R16B02LK'),('2019-02-20 23:14:03','R24B03LK'),('2019-02-20 23:17:05','R24B01LK'),('2019-02-20 23:31:22','R24B03LK'),('2019-02-20 23:37:06','G09S'),('2019-02-20 23:37:16','I03G07'),('2019-04-17 00:00:06','E02'),('2019-04-17 06:20:06','E04'),('2019-04-17 06:45:06','G06S'),('2019-04-17 10:26:29','R16B01LK'),('2019-04-17 10:26:32','R16B01LK'),('2019-04-17 10:27:17','R16B01LK'),('2019-04-17 10:27:27','R16B02LK'),('2019-04-17 10:27:31','R16B02LK'),('2019-04-17 10:28:25','R16B02LK'),('2019-04-17 10:28:32','R16B02LK'),('2019-04-17 10:38:18','H'),('2019-04-17 10:49:12','R24B01LK'),('2019-04-17 10:54:42','R24B01LK'),('2019-04-17 10:54:46','R24B01LK'),('2019-04-17 10:55:34','R24B01LK'),('2019-04-17 10:55:50','R24B01LK'),('2019-04-17 10:56:21','R24B01LK'),('2019-04-17 10:56:28','R24B01LK'),('2019-04-17 10:56:35','R24B01LK'),('2019-04-17 10:56:53','R24B01LK'),('2019-04-17 10:57:19','R24B01LK'),('2019-04-17 10:57:26','R24B01LK'),('2019-04-17 10:59:37','R24B01LK'),('2019-04-17 11:00:11','R24B02LK'),('2019-04-17 11:00:19','R24B02LK'),('2019-04-17 11:03:01','R24B03LK'),('2019-04-17 11:04:03','R24B01LK'),('2019-04-17 11:04:07','R24B03LK'),('2019-04-17 11:05:05','R24B04LK'),('2019-04-17 11:06:49','R24B04LK'),('2019-04-17 11:06:54','R24B04LK'),('2019-04-17 11:07:19','R24B06LK'),('2019-04-17 11:07:34','R24B01LK'),('2019-04-17 11:07:35','R24B04LK'),('2019-04-17 11:07:39','R24B06LK'),('2019-04-17 11:08:08','R24B01LK'),('2019-04-17 11:08:09','R24B04LK'),('2019-04-17 11:08:21','R24B06LK'),('2019-04-17 11:12:15','R26B03LK'),('2019-04-17 11:12:24','R26B04LK'),('2019-04-17 11:12:42','R26B05LK'),('2019-04-17 11:12:50','R26B05LK'),('2019-04-17 12:12:41','O031'),('2019-04-17 12:16:15','R25B01LK'),('2019-04-17 12:16:21','R25B01LK'),('2019-04-17 12:16:27','R25B01LK'),('2019-04-17 12:16:35','R25B02LK'),('2019-04-17 12:16:36','R25B02LK'),('2019-04-17 12:16:44','R25B03LK'),('2019-04-17 12:16:52','R25B04LK'),('2019-04-17 12:16:58','R25B04LK'),('2019-04-17 12:17:07','R25B06LK'),('2019-04-17 12:18:14','R26B01LK'),('2019-04-17 12:19:04','R26B01LK'),('2019-04-17 12:19:11','R26B01LK'),('2019-04-17 12:19:22','R26B01LK'),('2019-04-17 12:19:33','R26B01LK'),('2019-04-17 12:19:36','R25B01LK'),('2019-04-17 12:19:49','R25B06LK'),('2019-04-17 12:19:54','R26B02LK'),('2019-04-17 12:20:04','R25B01LK'),('2019-04-17 12:20:20','R26B01LK'),('2019-04-17 12:20:23','R24B01LK'),('2019-04-17 12:20:26','R24B01LK'),('2019-04-17 12:20:30','R24B01LK'),('2019-04-17 12:20:35','R26B01LK'),('2019-04-17 12:20:44','R26B02LK'),('2019-04-17 12:20:57','R26B02LK'),('2019-04-17 12:21:00','R26B02LK'),('2019-04-17 12:21:37','R26B03LK'),('2019-04-17 12:21:41','R26B03LK'),('2019-04-17 12:22:34','R26B03LK'),('2019-04-17 12:22:36','R26B03LK'),('2019-04-17 12:22:43','R26B02LK'),('2019-04-17 12:22:45','R26B03LK'),('2019-04-17 12:22:47','R26B03LK'),('2019-04-17 12:23:05','R26B03LK'),('2019-04-17 12:23:11','R26B03LK'),('2019-04-17 12:23:53','R26B03LK'),('2019-04-17 12:23:58','R26B03LK'),('2019-04-17 12:24:12','R26B03LK'),('2019-04-17 12:24:14','R26B03LK'),('2019-04-17 12:24:20','R26B03LK'),('2019-04-17 12:24:22','R26B03LK'),('2019-04-17 12:24:24','R26B02LK'),('2019-04-17 12:24:29','R26B02LK'),('2019-04-17 12:24:36','R26B02LK'),('2019-04-17 12:24:38','R26B03LK'),('2019-04-17 12:24:45','R26B01LK'),('2019-04-17 12:24:49','R26B01LK'),('2019-04-17 12:24:56','R26B04LK'),('2019-04-17 12:25:02','R26B04LK'),('2019-04-17 12:25:32','R26B04LK'),('2019-04-17 12:25:35','R26B04LK'),('2019-04-17 12:25:37','R26B04LK'),('2019-04-17 12:26:01','R26B04LK'),('2019-04-17 12:26:04','R26B04LK'),('2019-04-17 12:26:08','R26B04LK'),('2019-04-17 12:26:13','R26B05LK'),('2019-04-17 12:26:49','R26B02LK'),('2019-04-17 12:26:56','R26B04LK'),('2019-04-17 12:27:16','R26B02LK'),('2019-04-17 12:27:33','R26B03LK'),('2019-04-17 12:27:37','R26B03LK'),('2019-04-17 12:30:32','R26B05LK'),('2019-04-17 12:30:36','R26B05LK'),('2019-04-17 12:30:37','O030'),('2019-04-17 12:30:39','O031'),('2019-04-17 12:30:58','R26B05LK'),('2019-04-17 12:31:00','R26B06LK'),('2019-04-17 12:31:02','R26B06LK'),('2019-04-17 13:04:23','R27B01LK'),('2019-04-17 13:04:41','R27B01LK'),('2019-04-17 13:04:56','R27B02LK'),('2019-04-17 13:05:05','R27B02LK'),('2019-04-17 13:05:10','R27B06LK'),('2019-04-17 13:05:14','R27B02LK'),('2019-04-17 13:05:35','R27B01LK'),('2019-04-17 13:05:42','R27B02LK'),('2019-04-17 13:06:26','R27B05LK'),('2019-04-17 13:06:29','R27B06LK'),('2019-04-17 13:46:51','R20B01LK'),('2019-04-17 13:46:56','R20B01LK'),('2019-04-17 13:52:49','R02B06LK'),('2019-04-17 13:53:26','R02B05LK'),('2019-04-17 13:53:29','R02B05LK'),('2019-04-17 13:58:18','R08B05LK'),('2019-04-17 13:58:21','R08B05LK'),('2019-04-17 14:21:09','O011'),('2019-04-17 14:27:33','R24B06LK'),('2019-04-17 14:28:37','R24B06LK'),('2019-04-17 15:16:48','R29B07LK'),('2019-04-17 15:16:49','R29B07LK'),('2019-04-17 16:09:23','I01G10'),('2019-04-17 17:44:41','R24B06LK'),('2019-04-17 18:59:06','G08S'),('2019-04-17 19:14:06','E03'),('2019-04-17 19:29:06','E01'),('2019-04-17 23:16:04','R24B01LK'),('2019-04-17 23:31:30','R16B05LK'),('2019-04-17 23:33:12','R24B03LK'),('2019-04-17 23:34:05','R24B01LK'),('2019-04-17 23:35:27','R24B03LK'),('2019-04-17 23:37:06','G09S'),('2019-02-21 00:00:06','E02'),('2019-02-21 01:13:05','R16B06LK'),('2019-02-21 01:13:06','R16B05LK'),('2019-02-21 01:13:10','R16B05LK'),('2019-02-21 02:03:22','O040'),('2019-02-21 02:03:33','O041'),('2019-02-21 06:45:06','G06S'),('2019-02-21 06:48:06','E04'),('2019-02-21 07:57:30','R24B01LK'),('2019-02-21 08:45:24','R24B02LK'),('2019-02-21 10:15:28','O020'),('2019-02-21 10:18:49','O040'),('2019-02-21 10:19:24','O041'),('2019-02-21 15:46:20','R16B01LK'),('2019-02-21 15:46:22','R16B01LK'),('2019-02-21 15:46:25','R16B01LK'),('2019-02-21 16:59:06','G08S'),('2019-02-21 17:14:06','E03'),('2019-02-21 17:29:06','E01'),('2019-02-21 18:34:35','O040'),('2019-02-21 18:34:51','O041'),('2019-02-21 21:02:00','A0214'),('2019-02-21 22:54:19','R24B01LK'),('2019-02-21 23:37:06','G09S'),('2019-02-21 23:56:11','R24B03LK'),('2019-04-18 00:00:06','E02'),('2019-04-18 06:18:06','E04'),('2019-04-18 06:45:06','G06S'),('2019-04-18 07:58:00','R24B02LK'),('2019-04-18 08:27:42','R24B01LK'),('2019-04-18 08:39:41','I01G07'),('2019-04-18 10:37:04','R24B01LK'),('2019-04-18 19:00:06','G08S'),('2019-04-18 19:15:06','E03'),('2019-04-18 19:30:06','E01'),('2019-04-18 22:41:57','R24B01LK'),('2019-04-18 22:50:20','R24B03LK'),('2019-04-18 23:37:06','G09S'),('2019-02-22 00:00:06','E02'),('2019-02-22 02:50:02','O040'),('2019-02-22 02:50:15','O041'),('2019-02-22 06:45:06','G06S'),('2019-02-22 06:47:06','E04'),('2019-02-22 08:07:02','R24B02LK'),('2019-02-22 08:07:37','R24B01LK'),('2019-02-22 11:03:57','O040'),('2019-02-22 11:04:08','O041'),('2019-02-22 17:00:06','G08S'),('2019-02-22 17:07:42','V0202'),('2019-02-22 17:15:06','E03'),('2019-02-22 17:30:06','E01'),('2019-02-22 17:47:07','R24B01LK'),('2019-02-22 17:59:26','A0200'),('2019-02-22 18:07:13','A0214'),('2019-02-22 19:17:48','O040'),('2019-02-22 19:18:02','O041'),('2019-02-22 23:37:06','G09S'),('2019-02-22 23:37:28','I01G08'),('2019-04-19 00:00:06','E02'),('2019-04-19 06:17:06','E04'),('2019-04-19 06:45:06','G06S'),('2019-04-19 07:22:38','R24B01LK'),('2019-04-19 07:22:39','R24B02LK'),('2019-04-19 07:41:53','R24B03LK'),('2019-04-19 14:35:21','R24B06LK'),('2019-04-19 19:01:06','G08S'),('2019-04-19 19:16:06','E03'),('2019-04-19 19:31:06','E01'),('2019-04-19 22:46:59','R20B05LK'),('2019-04-19 23:10:06','R24B03LK'),('2019-04-19 23:37:06','G09S'),('2019-02-23 00:00:06','E02'),('2019-02-23 00:24:20','R20B05LK'),('2019-02-23 00:41:25','R24B03LK'),('2019-02-23 03:33:15','O040'),('2019-02-23 03:33:52','O041'),('2019-02-23 06:45:06','G06S'),('2019-02-23 06:46:06','E04'),('2019-02-23 11:53:37','O040'),('2019-02-23 11:53:49','O041'),('2019-02-23 12:37:26','V0202'),('2019-02-23 12:59:01','R24B01LK'),('2019-02-23 12:59:03','R24B02LK'),('2019-02-23 13:08:37','A0114'),('2019-02-23 17:01:06','G08S'),('2019-02-23 17:12:20','O030'),('2019-02-23 17:13:09','O031'),('2019-02-23 17:16:06','E03'),('2019-02-23 17:31:06','E01'),('2019-02-23 18:33:52','R24B03LK'),('2019-02-23 20:08:59','O040'),('2019-02-23 20:09:12','O041'),('2019-02-23 21:04:11','A0200'),('2019-02-23 21:04:30','V0202'),('2019-02-23 21:46:40','R24B01LK'),('2019-02-23 21:46:58','R24B04LK'),('2019-02-23 22:24:14','A0200'),('2019-02-23 22:24:25','V0202'),('2019-02-23 22:45:11','A0200'),('2019-02-23 22:54:55','R20B05LK'),('2019-02-23 23:07:00','R25B04LK'),('2019-02-23 23:22:07','R24B03LK'),('2019-02-23 23:37:06','G09S');
/*!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 ('Doorbell Enabled?','@doorbell`{currRoom}`{disabled|enabled}','5.6.7.8.9.10.11.12.13.29'),('Select Doorbell Chime','@doorbellChime`{chime 1|chime 2|chime 3|chime 4|chime 5}',NULL);
/*!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,'Landscape On','A0-15','F','@singleLight`180`100`0~@singleLight`174`100`0'),(2,'Landscape Off','T00:00','F','@singleLight`180`0`0~@singleLight`174`0`0'),(3,'Upstairs Hall Undercab ON','A0-30','F','@singleLight`74`3`2~@singleLight`75`3`2~@singleLight`71`3`2~@singleLight`72`3`2'),(4,'Upstairs Hall Undrcab OFF','A1','F','@singleLight`74`0`2~@singleLight`75`0`2~@singleLight`71`0`2~@singleLight`72`0`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,'Basement'),(2,'First Floor'),(3,'Second Floor');
/*!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',
  `role` varchar(10) DEFAULT NULL
) 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 */;
/*!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=181 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,1,'[1:1:0:5:2]','Center','Dimmer',0,204,144),(2,1,'[1:1:0:7:4]','Front','Dimmer',0,116,144),(3,1,'[1:1:0:2:4]','Rear','Dimmer',0,291,145),(4,1,'[1:1:0:2:3]','Undercabinet','Switch',0,77,24),(5,1,'[1:1:0:3:4]','Track N','Switch',0,208,48),(6,21,'[1:1:1:2:4]','Lights','Dimmer',0,204,145),(7,18,'[1:1:1:2:3]','BF>1F Steplights','Dimmer',0,241,110),(8,18,'[1:1:0:3:2]','Hall North','Dimmer',0,222,147),(9,18,'[1:1:1:2:1]','Hall South','Dimmer',0,219,192),(10,19,'[1:1:0:8:1]','AV Room','Switch',0,80,188),(11,19,'[1:1:1:2:2]','AV Hall','Switch',0,77,77),(12,19,'[1:1:0:8:4]','Elevator Mech','Switch',0,396,90),(13,19,'[1:1:0:5:3]','Mechanical','Switch',0,257,143),(14,5,'[1:1:1:3:4]','Undercabinet Left','Switch',0,81,91),(15,5,'[1:1:1:7:4]','Undercabinet Right','Switch',0,308,90),(16,5,'[1:1:0:8:3]','Ceiling N','Switch',0,206,142),(17,5,'[1:1:0:6:2]','Ceiling S','Switch',0,206,198),(18,0,'[0:0:0:0:0]','delete me','Dimmer',0,999,999),(19,1,'[1:1:0:7:3]','Track S','Switch',0,203,261),(20,20,'[2:1:1:1:1]','Hall E','Dimmer',0,329,192),(32,7,'[1:1:1:8:4]','Water Feature','Dimmer',0,260,286),(21,20,'[2:1:1:1:4]','1F>2F Stairs North','Dimmer',0,271,244),(22,20,'[2:1:1:2:1]','1F>2F Stairs South','Dimmer',0,273,307),(23,20,'[2:1:0:1:2]','1F>2F Sconces','Dimmer',0,149,260),(24,20,'[1:1:0:7:1]','Hall W','Dimmer',0,73,192),(25,20,'[2:1:1:1:3]','Entry','Dimmer',0,199,90),(26,20,'[2:1:1:1:2]','Entry Niche','Dimmer',0,165,195),(27,22,'[2:1:1:2:2]','Ceiling N','Dimmer',0,225,149),(28,22,'[2:1:1:5:3]','Ceiling S','Dimmer',0,221,307),(29,22,'[1:8:1:3]','Boot Dry Fan','Switch',0,269,196),(30,7,'[1:1:0:4:3]','Uplights N','Dimmer',0,172,102),(31,7,'[1:1:0:4:4]','Uplights S','Dimmer',0,172,197),(33,7,'[1:1:0:7:2]','Ground Wash','Switch',0,339,150),(34,8,'[1:1:1:1:3]','Wall S','Dimmer',0,140,273),(35,8,'[2:1:1:5:4]','Table','Dimmer',0,193,177),(36,8,'[2:1:0:4:1]','Table Spots','Dimmer',0,263,178),(37,8,'[1:1:1:6:3]','Uplights E Center','Dimmer',0,318,124),(38,2,'[1:1:0:3:3]','Int/Ext Tree Uplights','Dimmer',0,67,84),(39,2,'[1:1:1:5:2]','Patio','Dimmer',0,112,307),(40,2,'[2:1:1:6:4]','Uplights Corners','Dimmer',0,41,217),(41,2,'[2:1:1:3:4]','Uplights W Center','Dimmer',0,43,154),(42,9,'[2:1:1:6:1]','Ceiling E','Dimmer',0,292,150),(43,9,'[1:1:1:5:4]','Ceiling W','Dimmer',0,121,153),(44,9,'[1:1:1:8:1]','Uplights E','Dimmer',0,369,149),(45,9,'[1:1:0:2:2]','Uplights W','Dimmer',0,43,154),(46,6,'[1:1:1:7:1]','Cove','Dimmer',0,51,28),(47,6,'[1:1:0:4:2]','Ground Wash','Switch',0,104,165),(48,6,'[1:1:1:8:2]','Uplights N','Dimmer',0,320,111),(49,6,'[2:1:1:5:1]','Uplights S','Dimmer',0,320,189),(50,6,'[1:8:1:1]','BBQ Exhaust','Switch',0,306,0),(51,11,'[1:1:1:1:4]','Cove E-W','Dimmer',0,72,143),(52,11,'[1:1:1:1:1]','Cove N-S','Dimmer',0,211,235),(53,11,'[1:1:1:3:2]','Ceiling','Dimmer',0,372,79),(54,11,'[1:1:1:4:4]','Niche','Dimmer',0,2,94),(55,11,'[1:1:1:6:1]','Pendant','Dimmer',0,210,131),(56,12,'[2:1:0:3:1]','Downlights','Dimmer',0,205,222),(57,12,'[2:1:1:2:3]','Pantry Downlights','Dimmer',0,166,0),(58,12,'[2:1:1:2:4]','Pantry Undercabinet','Switch',0,243,0),(59,12,'[2:5:1:4]','Range Light','Dimmer',0,238,98),(60,12,'[1:1:1:6:4]','Desk Undercabs','Dimmer',0,410,145),(61,12,'[1:1:1:4:1]','Undercabinets','Switch',0,315,106),(62,12,'[1:1:1:7:2]','Island Undercabs','Switch',0,206,303),(63,12,'[1:8:1:4]','Range Fan','Switch',0,166,98),(64,17,'[2:1:1:3:1]','Potting Mech','Switch',0,0,149),(65,17,'[1:1:1:6:2]','Garage Lights','Switch',0,207,176),(66,17,'[1:1:0:6:4]','Potting Sink','Switch',0,0,225),(67,3,'[2:1:0:2:4]','Hallway East','Dimmer',0,362,47),(68,3,'[2:1:0:6:4]','Hallway West','Dimmer',0,43,48),(69,25,'[2:1:0:7:4]','Hall E Ceiling E','Dimmer',0,999,999),(70,25,'[2:1:0:8:1]','Hall E Ceiling W','Dimmer',0,999,999),(71,25,'[2:1:0:7:2]','Hall E Floor E','Dimmer',0,999,999),(72,25,'[2:1:0:7:3]','Hall E Floor W','Dimmer',0,999,999),(73,16,'[2:1:0:8:4]','Hall W Ceiling','Dimmer',0,84,22),(74,16,'[2:1:0:8:3]','Hall W Floor E','Dimmer',0,120,84),(75,16,'[2:1:0:8:2]','Hall W Floor W','Dimmer',0,49,83),(76,3,'[2:1:0:7:1]','Sconces','Dimmer',0,202,156),(77,29,'[1:1:1:7:3]','Zone 1','Switch',0,43,167),(78,29,'[1:1:1:1:2]','Zone 2','Switch',0,359,168),(79,29,'[2:1:1:4:3]','Zone 3','Switch',0,256,167),(80,29,'[1:1:1:4:2]','Zone 4','Switch',0,146,166),(81,10,'[2:1:0:1:3]','Ceiling','Dimmer',0,171,77),(82,10,'[1:1:0:6:3]','WC/Shower','Dimmer',0,60,152),(83,10,'[2:1:0:6:2]','Outside N','Dimmer',0,337,80),(84,10,'[2:1:0:6:3]','Outside S','Dimmer',0,344,247),(85,10,'[1:1:0:4:1]','Outside Sconce','Dimmer',0,305,164),(86,10,'[1:8:1:5]','Exhaust Shower','Switch',0,89,219),(87,10,'[2:4:1:1:8]','Exhaust WC','Switch',0,56,78),(88,10,'[1:1:0:1:1]','Mirror Shower','Switch',0,16,219),(89,10,'[1:1:0:8:2]','Vanity','Switch',0,217,163),(90,13,'[2:1:0:1:4]','Ceiling','Dimmer',0,168,145),(91,13,'[2:1:0:2:2]','Hall N','Dimmer',0,263,246),(92,13,'[2:1:0:2:3]','Hall S','Dimmer',0,264,39),(93,13,'[1:8:1:2]','Fan Circ','Fan',0,263,142),(94,14,'[2:1:0:5:1]','Ceiling','Dimmer',0,146,164),(95,14,'[2:5:1:1]','Bath Ceiling','Dimmer',0,120,70),(96,14,'[1:1:1:8:3]','Bath Mirror','Dimmer',0,87,29),(97,14,'[2:1:0:3:2]','Bath Shower','Dimmer',0,220,46),(98,14,'[2:4:1:1:4]','Bath Exhaust','Switch',0,155,29),(99,20,'[2:4:2:3]','Entry L','Shade',1,13,56),(100,20,'[2:4:2:4]','Entry R','Shade',1,398,61),(101,22,'[2:1:1:3:3]','Bath Ceiling','Dimmer',0,239,59),(102,22,'[2:1:1:5:2]','Bath Sconce','Dimmer',0,185,59),(103,22,'[2:4:1:1:5]','Bath Exhaust','Switch',0,203,16),(104,27,'[2:1:1:4:2]','Mirror/Cove','Dimmer',0,258,80),(105,27,'[2:1:1:4:1]','Mirror Up Low','Dimmer',0,256,158),(106,10,'[2:1:0:2:1]','Closet','Dimmer',0,0,1),(107,10,'[1:8:1:6]','3-Way Mirror','Switch',0,0,307),(108,15,'[2:1:0:5:2]','Ceiling','Dimmer',0,265,160),(109,15,'[2:1:0:3:4]','Bath Shower','Dimmer',0,329,46),(110,15,'[2:1:0:3:3]','Bath Mirror','Dimmer',0,195,7),(111,15,'[2:5:1:2]','Bath Ceiling','Dimmer',0,209,65),(112,15,'[2:4:1:2:1]','Bath Exhaust','Switch',0,265,7),(113,4,'[2:1:0:6:1]','Ceiling','Dimmer',0,150,145),(114,4,'[2:1:0:5:4]','Floor Wash','Dimmer',0,227,143),(115,4,'[2:1:0:4:4]','Bath Ceiling','Dimmer',0,20,164),(116,4,'[2:1:0:4:3]','Bath Mirror','Dimmer',0,20,213),(117,4,'[2:4:1:1:7]','Bath Exhaust','Switch',0,21,112),(118,28,'[2:1:0:5:3]','Ceiling','Dimmer',0,172,162),(119,28,'[2:5:1:3]','Bath Ceiling','Dimmer',0,182,58),(120,28,'[2:1:1:3:2]','Bath Mirror','Dimmer',0,224,0),(121,28,'[2:4:1:1:6]','Bath Exhaust','Switch',0,147,0),(122,25,'[1:1:1:5:1]','Bath Ceiling','Dimmer',0,294,110),(123,25,'[1:1:0:5:1]','Bath Sconce','Dimmer',0,358,154),(124,25,'[2:4:1:1:1]','Bath Exhaust','Switch',0,298,208),(125,14,'[2:4:2:22]','Left','Shade',1,177,307),(126,14,'[2:4:2:23]','Right','Shade',1,35,307),(127,15,'[2:4:2:24]','Center','Shade',1,212,307),(128,15,'[2:4:2:25]','Left','Shade',1,298,307),(129,15,'[2:4:2:26]','Right','Shade',1,124,307),(130,28,'[2:4:2:27]','Left','Shade',1,279,307),(131,28,'[2:4:2:28]','Right','Shade',1,140,307),(132,4,'[2:4:2:29]','East Left','Shade',1,265,57),(133,4,'[2:4:2:30]','East Right','Shade',1,265,220),(134,4,'[2:4:2:31]','North Center','Shade',1,126,0),(135,4,'[2:4:2:33]','North Left','Shade',1,32,0),(136,4,'[2:4:2:32]','North Right','Shade',1,219,0),(137,4,'[2:4:2:34]','South Center','Shade',1,128,307),(138,4,'[2:4:2:35]','South Left','Shade',1,219,307),(139,4,'[2:4:2:36]','South Right','Shade',1,38,307),(140,2,'[2:4:2:5]','Lower E Left','Shade',1,336,102),(141,2,'[2:4:2:6]','Lower E Right','Shade',1,339,192),(142,2,'[2:4:2:12]','Upper E Left','Shade',1,407,102),(143,2,'[2:4:2:13]','Upper E Right','Shade',1,409,193),(144,2,'[2:4:2:43]','Upper S 2','Shade',1,329,283),(145,2,'[2:4:2:14]','Upper S 1','Shade',1,401,284),(146,2,'[2:4:2:44]','Upper S 3','Shade',1,258,283),(147,11,'[2:4:2:7]','Shade','Shade',1,209,49),(148,1,'[2:4:2:1]','Left','Shade',1,333,46),(149,1,'[2:4:2:2]','Right','Shade',1,334,255),(150,2,'[2:4:2:9]','Lower W Left','Shade',1,71,200),(151,2,'[2:4:2:8]','Lower W Right','Shade',1,70,103),(152,2,'[2:4:2:45]','Upper S 5','Shade',1,115,283),(153,2,'[2:4:2:18]','Upper S 4','Shade',1,186,283),(154,2,'[2:4:2:17]','Upper S 6','Shade',1,43,283),(155,2,'[2:4:2:16]','Upper W Left','Shade',1,0,199),(156,2,'[2:4:2:15]','Upper W Right','Shade',1,0,103),(157,12,'[2:4:2:11]','Pantry','Shade',1,203,0),(158,9,'[2:4:2:20]','2F Center','Shade',1,207,305),(159,9,'[2:4:2:19]','2F Left','Shade',1,279,305),(160,9,'[2:4:2:21]','2F Right','Shade',1,135,306),(161,9,'[2:4:2:10]','Door','Shade',1,212,240),(162,10,'[2:4:2:37]','Entry','Shade',1,342,0),(163,10,'[2:4:2:38]','Shower','Shade',1,345,307),(164,13,'[2:4:2:42]','North','Shade',1,155,7),(165,13,'[2:4:2:39]','South','Shade',1,158,297),(166,13,'[2:4:2:40]','West Left','Shade',1,85,193),(167,13,'[2:4:2:41]','West Right','Shade',1,87,71),(168,26,'[1:1:0:6:1]','Ceiling','Dimmer',0,168,219),(169,26,'[1:1:0:5:4]','Mirror','Dimmer',0,237,220),(170,26,'[2:4:1:1:2]','Exhaust','Switch',0,219,160),(171,24,'[2:1:0:1:1]','Ceiling','Dimmer',0,206,88),(172,27,'[2:4:1:1:3]','Exhaust','Switch',0,189,46),(173,28,'[2:1:0:4:2]','Bath Shower Downlight','Dimmer',0,93,44),(174,7,'[1:1:0:1:4]','Tree Uplights','Switch',0,413,191),(175,20,'[1:1:0:1:2]','Parking Court','Switch',0,112,0),(176,20,'[1:1:0:1:3]','Front Door','Switch',0,201,0),(177,5,'[1:1:1:4:3]','Entry Hall','Switch',0,420,244),(178,27,'[2:1:1:4:4]','Downlights','Dimmer',0,187,116),(179,13,'[2:1:1:6:3]','Security Lts','Switch',0,12,295),(180,6,'[2:1:1:6:2]','Landscape Lts','Switch',0,17,291);
/*!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 ('[1:6:25]',1,'Court On'),('[1:6:25]',2,'Court Dim'),('[1:6:25]',3,'Outside'),('[1:6:25]',5,'Court Off'),('[1:6:12]',1,'Stairs'),('[1:6:12]',2,'Hall'),('[1:6:12]',3,'Wine Room'),('[1:6:12]',4,'BF All On'),('[1:6:12]',5,'BF All Off'),('[1:8:2:1]',1,'Bright'),('[1:8:2:1]',2,'Medium'),('[1:8:2:1]',3,'Dim'),('[1:8:2:1]',6,'Off'),('[1:8:2:6]',1,'Bright'),('[1:8:2:6]',2,'Medium'),('[1:8:2:6]',3,'Dim'),('[1:8:2:6]',6,'Off'),('[1:8:2:7]',3,'Dim'),('[1:8:2:7]',2,'Medium'),('[1:8:2:7]',1,'Bright'),('[1:8:2:5]',1,'Bright'),('[1:8:2:3]',1,'Bright'),('[1:8:2:3]',2,'Medium'),('[1:8:2:3]',3,'Dim'),('[1:8:2:3]',6,'Off'),('[1:8:2:4]',1,'On'),('[1:8:2:4]',2,'Off'),('[1:8:2:4]',4,'Outside On'),('[1:8:2:4]',5,'Outside Off'),('[1:8:2:10]',1,'Bright'),('[1:8:2:10]',2,'Medium'),('[1:8:2:10]',3,'Dim'),('[1:8:2:10]',6,'Off'),('[1:8:2:5]',6,'Off'),('[1:8:2:13]',1,'Bright'),('[1:8:2:13]',2,'Medium'),('[1:8:2:13]',3,'Dim'),('[1:8:2:13]',6,'Off'),('[1:8:2:9]',3,'Dim'),('[1:8:2:9]',2,'Medium'),('[1:8:2:9]',1,'Bright'),('[1:8:2:12]',1,'Bright'),('[1:8:2:12]',2,'Medium'),('[1:8:2:12]',3,'Dim'),('[1:8:2:12]',6,'Off'),('[1:8:2:11]',1,'On'),('[1:8:2:11]',2,'Off'),('[1:8:2:16]',5,'House Off'),('[1:8:2:16]',4,'House On'),('[1:8:2:16]',3,'Dim'),('[1:8:2:15]',1,'Bright'),('[1:8:2:15]',2,'Medium'),('[1:8:2:15]',3,'Dim'),('[1:8:2:15]',6,'Off'),('[1:8:2:14]',1,'Bright'),('[1:8:2:14]',2,'Medium'),('[1:8:2:14]',3,'Dim'),('[1:8:2:14]',6,'Off'),('[1:5:12]',2,'All Off'),('[1:8:2:21]',4,' '),('[1:8:2:21]',3,'Dim'),('[1:8:2:20]',5,'Bath Off'),('[1:8:2:20]',4,'Bath On'),('[1:8:2:20]',3,'Dim'),('[1:8:2:20]',2,'Medium'),('[1:8:2:20]',1,'Bright'),('[1:8:2:24]',1,'Bright'),('[1:8:2:24]',2,'Medium'),('[1:8:2:24]',3,'Dim'),('[1:8:2:24]',4,'Outside On'),('[1:8:2:24]',5,'Outside Off'),('[1:8:2:24]',6,'Off'),('[1:8:2:23]',3,'Dim'),('[1:8:2:23]',2,'Medium'),('[1:8:2:23]',1,'Bright'),('[1:8:2:17]',3,'Dim'),('[1:8:2:17]',2,'Medium'),('[1:8:2:17]',1,'Bright'),('[1:8:2:17]',4,'Bath On'),('[1:8:2:17]',5,'Bath Off'),('[1:8:2:17]',6,'Off'),('[1:8:2:18]',1,'Bright'),('[1:8:2:18]',2,'Medium'),('[1:8:2:18]',3,'Dim'),('[1:8:2:18]',4,'Bath On'),('[1:8:2:18]',5,'Bath Off'),('[1:8:2:18]',6,'Off'),('[1:5:12]',1,'All On'),('[1:6:28]',6,'Off'),('[1:6:28]',3,'Dim'),('[1:6:28]',2,'Medium'),('[1:6:28]',1,'Bright'),('[1:8:2:16]',2,'Medium'),('[1:8:2:16]',1,'Bright'),('[1:8:2:8]',1,'Bright'),('[1:8:2:8]',2,'Medium'),('[1:8:2:8]',3,'Dim'),('[1:8:2:8]',6,'Off'),('[1:8:2:9]',6,'Off'),('[1:8:2:16]',6,'Off'),('[1:8:2:7]',4,'House On'),('[1:8:2:7]',5,'House Off'),('[1:8:2:7]',6,'Off'),('[1:8:2:21]',2,'Medium'),('[1:8:2:21]',1,'Bright'),('[1:5:13]',2,'All Off'),('[1:5:13]',1,'All On'),('[1:8:2:21]',5,' '),('[1:8:2:21]',6,'Off'),('[1:8:2:20]',6,'Off'),('[1:8:2:23]',4,'Security On'),('[1:8:2:23]',5,'Security Off'),('[1:8:2:23]',6,'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) DEFAULT 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 */;
/*!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,1,1,'Leave','','F','@roomLightScene`1`6~@roomShadeScene`1`1~@videoSrc`1`0~@audioSrc`1`0',0),(5,1,1,'Leave','','F','@roomLightScene`5`6~@audioSrc`5`0',0),(18,1,1,'Leave','','F','@singleLight`7`0`2~@singleLight`8`0`2~@singleLight`9`0`2',0),(21,1,1,'Leave','','F','@roomLightScene`21`6',0),(26,1,1,'Leave','','F','@roomLightScene`26`6',0),(2,1,1,'Leave','','F','@roomLightScene`2`6~@roomShadeScene`2`2~@videoSrc`2`0~@audioSrc`2`0',0),(6,1,1,'Leave','','F','@roomLightScene`6`2~@audioSrc`6`0',0),(7,1,1,'Leave','','F','@roomLightScene`7`2~@audioSrc`7`0',0),(8,1,1,'Leave','','F','@roomLightScene`8`6~@audioSrc`8`0',0),(9,1,1,'Leave','','F','@roomLightScene`9`6~@roomShadeScene`9`2~@audioSrc`9`0',0),(11,1,1,'Leave','','F','@roomLightScene`11`6~@roomShadeScene`11`2~@audioSrc`11`0',0),(12,1,1,'Leave','','F','@roomLightScene`12`6~@singleLight`157`0`0~@audioSrc`12`0',0),(17,1,1,'Leave','','F','@roomLightScene`17`2',0),(19,1,1,'Leave','','F','@singleLight`10`0`0~@singleLight`11`0`0~@singleLight`12`0`0~@singleLight`13`0`0',0),(20,1,1,'Leave','','F','@roomLightScene`20`6~@roomShadeScene`20`2',0),(22,1,1,'Leave','','F','@roomLightScene`22`6',0),(23,1,1,'Leave','','F','',0),(27,1,1,'Leave','','F','@roomLightScene`27`6',0),(3,1,1,'Leave','','F','@roomLightScene`3`6~@videoSrc`3`0~@audioSrc`3`0',0),(4,1,1,'Leave','','F','@roomLightScene`4`4~@roomShadeScene`4`2~@videoSrc`4`0~@audioSrc`4`0',0),(10,1,1,'Leave','','F','@roomLightScene`10`6~@roomShadeScene`10`2~@audioSrc`10`0',0),(13,1,1,'Leave','','F','@roomLightScene`13`6~@roomShadeScene`13`2~@videoSrc`13`0~@audioSrc`13`0',0),(14,1,1,'Leave','','F','@roomLightScene`14`6~@roomShadeScene`14`2',0),(15,1,1,'Leave','','F','@roomLightScene`15`6~@roomShadeScene`15`2',0),(16,1,1,'Leave','','F','@roomLightScene`16`6',0),(24,1,1,'Leave','','F','@singleLight`171`0`2',0),(25,1,1,'Leave','','F','@roomLightScene`25`6',0),(28,1,1,'Leave','','F','@roomLightScene`28`6~@singleLight`118`0`2~@singleLight`119`0`2~@singleLight`120`0`2~@singleLight`121`0`0~@singleLight`173`0`2~@roomShadeScene`28`2',0),(1,10,0,'All Off','','F','@singleLight`1`0`2~@singleLight`2`0`2~@singleLight`3`0`2~@singleLight`4`0`0~@singleLight`5`0`0~@singleLight`19`0`0~@videoSrc`1`0~@audioSrc`1`0',1),(2,10,0,'All Off','','F','@singleLight`38`0`2~@singleLight`39`0`2~@singleLight`40`0`2~@singleLight`41`0`2~@videoSrc`2`0~@audioSrc`2`0',1),(3,10,0,'All Off','','F','@singleLight`67`0`2~@singleLight`68`0`2~@singleLight`76`0`2~@videoSrc`3`0~@audioSrc`3`0',1),(4,10,0,'All Off','','F','@singleLight`113`0`2~@singleLight`114`0`2~@singleLight`115`0`2~@singleLight`116`0`2~@singleLight`117`0`0~@videoSrc`4`0~@audioSrc`4`0',1),(5,10,0,'All Off','','F','@singleLight`14`0`0~@singleLight`15`0`0~@singleLight`16`0`0~@singleLight`17`0`0~@singleLight`177`0`0~@audioSrc`5`0',1),(6,10,0,'All Off','','F','@audioSrc`6`0',1),(7,10,0,'All Off','','F','@audioSrc`7`0',1),(8,10,0,'All Off','','F','@singleLight`34`0`2~@singleLight`35`0`2~@singleLight`36`0`2~@singleLight`37`0`2~@audioSrc`8`0',1),(9,10,0,'All Off','','F','@singleLight`42`0`2~@singleLight`43`0`2~@singleLight`44`0`2~@singleLight`45`0`2~@audioSrc`9`0',1),(10,10,0,'All Off','','F','@singleLight`81`0`2~@singleLight`82`0`2~@singleLight`83`0`2~@singleLight`84`0`2~@singleLight`85`0`2~@singleLight`86`0`0~@singleLight`87`0`0~@singleLight`88`0`0~@singleLight`89`0`0~@singleLight`106`0`2~@singleLight`107`0`0~@audioSrc`10`0',1),(11,10,0,'All Off','','F','@singleLight`51`0`2~@singleLight`52`0`2~@singleLight`53`0`2~@singleLight`54`0`2~@singleLight`55`0`2~@audioSrc`11`0',1),(12,10,0,'All Off','','F','@singleLight`56`0`2~@singleLight`57`0`2~@singleLight`58`0`0~@singleLight`59`0`2~@singleLight`60`0`2~@singleLight`61`0`0~@singleLight`62`0`0~@singleLight`63`0`0~@audioSrc`12`0',1),(13,10,0,'All Off','','F','@singleLight`90`0`2~@singleLight`91`0`2~@singleLight`92`0`2~@videoSrc`13`0~@audioSrc`13`0',1),(14,10,0,'All Off','','F','@roomLightScene`14`6~@singleLight`94`0`2~@singleLight`95`0`2~@singleLight`96`0`2~@singleLight`97`0`2~@singleLight`98`0`0',1),(15,10,0,'All Off','','F','@singleLight`108`0`2~@singleLight`109`0`2~@singleLight`110`0`2~@singleLight`111`0`2~@singleLight`112`0`0',1),(16,10,0,'All Off','','F','@singleLight`73`0`2~@singleLight`74`0`2~@singleLight`75`0`2',1),(17,10,0,'All Off','','F','@singleLight`64`0`0~@singleLight`65`0`0~@singleLight`66`0`0',1),(18,10,0,'All Off','','F','@singleLight`7`0`2~@singleLight`8`0`2~@singleLight`9`0`2',1),(19,10,0,'All Off','','F','@singleLight`10`0`0~@singleLight`11`0`0~@singleLight`12`0`0~@singleLight`13`0`0',1),(20,10,0,'All Off','','F','@singleLight`20`0`2~@singleLight`21`0`2~@singleLight`22`0`2~@singleLight`23`0`2~@singleLight`24`0`2~@singleLight`25`0`2~@singleLight`26`0`2',1),(21,10,0,'All Off','','F','@singleLight`6`0`2',1),(22,10,0,'All Off','','F','@singleLight`27`0`2~@singleLight`28`0`2~@singleLight`101`0`2~@singleLight`102`0`2~@singleLight`103`0`0',1),(23,10,0,'All Off','','F','',1),(24,10,0,'All Off','','F','@singleLight`171`0`2',1),(25,10,0,'All Off','','F','@singleLight`69`0`2~@singleLight`70`0`2~@singleLight`71`0`2~@singleLight`72`0`2~@singleLight`122`0`2~@singleLight`123`0`2~@singleLight`124`0`0',1),(26,10,0,'All Off','','F','@singleLight`168`0`2~@singleLight`169`0`2~@singleLight`170`0`0',1),(27,10,0,'All Off','','F','@singleLight`104`0`2~@singleLight`105`0`2~@singleLight`172`0`0~@singleLight`178`0`2',1),(28,10,0,'All Off','','F','@singleLight`118`0`2~@singleLight`119`0`2~@singleLight`120`0`2~@singleLight`121`0`0~@singleLight`173`0`2',1),(29,13,0,'All Shades Open','','F','',1),(28,13,0,'All Shades Open','','F','@roomShadeScene`28`1',1),(27,13,0,'All Shades Open','','F','',1),(26,13,0,'All Shades Open','','F','',1),(25,13,0,'All Shades Open','','F','',1),(24,13,0,'All Shades Open','','F','',1),(23,13,0,'All Shades Open','','F','',1),(22,13,0,'All Shades Open','','F','',1),(21,13,0,'All Shades Open','','F','',1),(20,13,0,'All Shades Open','','F','@roomShadeScene`20`1',1),(19,13,0,'All Shades Open','','F','',1),(18,13,0,'All Shades Open','','F','',1),(17,13,0,'All Shades Open','','F','',1),(16,13,0,'All Shades Open','','F','',1),(15,13,0,'All Shades Open','','F','@roomShadeScene`15`1',1),(14,13,0,'All Shades Open','','F','@roomShadeScene`14`1',1),(13,13,0,'All Shades Open','','F','@roomShadeScene`13`1',1),(12,13,0,'All Shades Open','','F','',1),(11,13,0,'All Shades Open','','F','@singleLight`147`100`0',1),(10,13,0,'All Shades Open','','F','@roomShadeScene`10`1',1),(9,13,0,'All Shades Open','','F','@roomShadeScene`9`1',1),(8,13,0,'All Shades Open','','F','',1),(7,13,0,'All Shades Open','','F','',1),(6,13,0,'All Shades Open','','F','',1),(5,13,0,'All Shades Open','','F','',1),(4,13,0,'All Shades Open','','F','@roomShadeScene`4`1',1),(3,13,0,'All Shades Open','','F','',1),(1,13,0,'All Shades Open','','F','',1),(2,13,0,'All Shades Open','','F','@roomShadeScene`2`1',1),(29,8,0,'Evening','','F','',1),(28,8,0,'Evening','','F','',1),(27,8,0,'Evening','','F','',1),(26,8,0,'Evening','','F','',1),(25,8,0,'Evening','','F','',1),(24,8,0,'Evening','','F','',1),(23,8,0,'Evening','','F','',1),(22,8,0,'Evening','','F','@singleLight`27`25`2~@singleLight`28`25`2~@singleLight`29`0`0',1),(21,8,0,'Evening','','F','',1),(20,8,0,'Evening','','F','@singleLight`20`50`2~@singleLight`21`50`2~@singleLight`22`50`2~@singleLight`23`50`2~@singleLight`24`50`2~@singleLight`25`50`2~@singleLight`26`50`2~@singleLight`175`100`0~@singleLight`176`100`0',1),(19,8,0,'Evening','','F','',1),(18,8,0,'Evening','','F','',1),(17,8,0,'Evening','','F','@singleLight`64`0`0~@singleLight`65`0`0~@singleLight`66`0`0',1),(16,8,0,'Evening','','F','',1),(15,8,0,'Evening','','F','',1),(14,8,0,'Evening','','F','',1),(13,8,0,'Evening','','F','',1),(12,8,0,'Evening','','F','@singleLight`56`100`2~@singleLight`57`100`2~@singleLight`58`100`0~@singleLight`59`100`2~@singleLight`60`100`2~@singleLight`61`100`0~@singleLight`62`100`0~@singleLight`63`0`0',1),(11,8,0,'Evening','','F','@singleLight`51`29`2~@singleLight`52`28`2~@singleLight`53`29`2~@singleLight`54`21`2~@singleLight`55`28`2',1),(10,8,0,'Evening','','F','',1),(9,8,0,'Evening','','F','@singleLight`42`12`2~@singleLight`43`12`2~@singleLight`44`37`2~@singleLight`45`37`2',1),(8,8,0,'Evening','','F','@singleLight`34`50`2~@singleLight`35`0`2~@singleLight`36`75`2~@singleLight`37`75`2',1),(7,8,0,'Evening','','F','@singleLight`30`100`2~@singleLight`31`100`2~@singleLight`32`100`2~@singleLight`33`100`0~@singleLight`174`100`0',1),(6,8,0,'Evening','','F','@singleLight`46`3`2~@singleLight`47`100`0~@singleLight`48`100`2~@singleLight`49`100`2',1),(5,8,0,'Evening','','F','',1),(4,8,0,'Evening','','F','',1),(3,8,0,'Evening','','F','',1),(2,8,0,'Evening','','F','@singleLight`38`0`2~@singleLight`39`0`2~@singleLight`40`100`2~@singleLight`41`100`2',1),(1,8,0,'Evening','A0-45','F','',1),(28,7,0,'Cloudy Day','','F','',1),(29,7,0,'Cloudy Day','','F','',1),(25,7,0,'Cloudy Day','','F','',1),(26,7,0,'Cloudy Day','','F','',1),(27,7,0,'Cloudy Day','','F','',1),(23,7,0,'Cloudy Day','','F','',1),(24,7,0,'Cloudy Day','','F','',1),(21,7,0,'Cloudy Day','','F','',1),(22,7,0,'Cloudy Day','','F','@singleLight`27`75`2~@singleLight`28`75`2~@singleLight`101`0`2~@singleLight`102`0`2~@singleLight`103`0`0',1),(19,7,0,'Cloudy Day','','F','',1),(20,7,0,'Cloudy Day','','F','@singleLight`20`0`2~@singleLight`21`33`2~@singleLight`22`33`2~@singleLight`23`0`2~@singleLight`24`0`2~@singleLight`25`0`2~@singleLight`26`33`2~@roomShadeScene`20`1~@singleLight`99`100`0~@singleLight`100`100`0',1),(16,7,0,'Cloudy Day','','F','',1),(17,7,0,'Cloudy Day','','F','@singleLight`64`0`0~@singleLight`65`0`0~@singleLight`66`0`0',1),(18,7,0,'Cloudy Day','','F','',1),(11,7,0,'Cloudy Day','','F','',1),(12,7,0,'Cloudy Day','','F','@singleLight`56`75`2~@singleLight`57`75`2~@singleLight`58`100`0~@singleLight`59`0`2~@singleLight`60`100`2~@singleLight`61`100`0~@singleLight`62`100`0~@singleLight`63`0`0',1),(13,7,0,'Cloudy Day','','F','',1),(14,7,0,'Cloudy Day','','F','',1),(15,7,0,'Cloudy Day','','F','',1),(10,7,0,'Cloudy Day','','F','',1),(6,7,0,'Cloudy Day','','F','',1),(7,7,0,'Cloudy Day','','F','',1),(8,7,0,'Cloudy Day','','F','@singleLight`34`75`2~@singleLight`35`0`2~@singleLight`36`75`2~@singleLight`37`75`2',1),(9,7,0,'Cloudy Day','','F','@roomShadeScene`9`1',1),(5,7,0,'Cloudy Day','','F','',1),(4,7,0,'Cloudy Day','','F','',1),(1,7,0,'Cloudy Day','','F','',1),(2,7,0,'Cloudy Day','','F','@singleLight`38`0`2~@singleLight`39`0`2~@singleLight`40`75`2~@singleLight`41`75`2~@roomShadeScene`2`1',1),(3,7,0,'Cloudy Day','','F','',1),(1,3,1,'Clean Up','','F','@roomLightScene`1`6~@singleLight`1`100`2~@singleLight`2`100`2~@singleLight`3`100`2~@singleLight`4`100`0~@singleLight`5`100`0~@singleLight`19`100`0~@roomShadeScene`1`1~@videoSrc`1`0~@audioSrc`1`0',0),(1,4,1,'Read','','F','@singleLight`1`70`2~@singleLight`2`0`2~@singleLight`3`0`2~@singleLight`4`0`0~@singleLight`5`100`0~@singleLight`19`100`0~@roomShadeScene`1`2~@videoSrc`1`0~@audioSrc`1`0',0),(27,9,0,'Bed Time','','F','@roomLightScene`27`6',1),(28,9,0,'Bed Time','','F','',1),(29,9,0,'Bed Time','','F','@roomLightScene`29`2~@singleLight`77`0`0~@singleLight`78`0`0~@singleLight`79`0`0~@singleLight`80`0`0',1),(22,9,0,'Bed Time','','F','@roomLightScene`22`6~@singleLight`27`0`2~@singleLight`28`0`2~@singleLight`101`0`2~@singleLight`102`0`2',1),(23,9,0,'Bed Time','','F','',1),(24,9,0,'Bed Time','','F','@singleLight`171`0`2',1),(25,9,0,'Bed Time','','F','@singleLight`69`0`2~@singleLight`70`0`2~@singleLight`71`3`2~@singleLight`72`3`2~@singleLight`122`0`2~@singleLight`123`0`2~@singleLight`124`0`0',1),(26,9,0,'Bed Time','','F','@roomLightScene`26`6',1),(21,9,0,'Bed Time','','F','@roomLightScene`21`6',1),(18,9,0,'Bed Time','','F','@singleLight`7`0`2~@singleLight`8`0`2~@singleLight`9`0`2',1),(19,9,0,'Bed Time','','F','@singleLight`10`0`0~@singleLight`11`0`0~@singleLight`12`0`0~@singleLight`13`0`0',1),(20,9,0,'Bed Time','','F','@singleLight`20`0`2~@singleLight`21`25`2~@singleLight`22`25`2~@singleLight`23`0`2~@singleLight`24`0`2~@singleLight`25`0`2~@singleLight`26`0`2~@singleLight`175`0`0~@singleLight`176`0`0~@roomShadeScene`20`2',1),(17,9,0,'Bed Time','','F','@roomLightScene`17`2',1),(16,9,0,'Bed Time','','F','@singleLight`73`0`2~@singleLight`74`3`2~@singleLight`75`3`2',1),(12,9,0,'Bed Time','','F','@roomLightScene`12`6',1),(13,9,0,'Bed Time','','F','',1),(14,9,0,'Bed Time','','F','',1),(15,9,0,'Bed Time','','F','',1),(10,9,0,'Bed Time','','F','@roomLightScene`10`3~@singleLight`162`0`0~@singleLight`163`0`0',1),(11,9,0,'Bed Time','','F','@roomLightScene`11`6',1),(7,9,0,'Bed Time','','F','@roomLightScene`7`2',1),(8,9,0,'Bed Time','','F','@roomLightScene`8`6',1),(9,9,0,'Bed Time','','F','@roomLightScene`9`6',1),(4,9,0,'Bed Time','','F','',1),(5,9,0,'Bed Time','','F','@roomLightScene`5`6',1),(6,9,0,'Bed Time','','F','@roomLightScene`6`2',1),(1,9,0,'Bed Time','T23:37','F','@roomLightScene`1`6',1),(2,9,0,'Bed Time','','F','@roomLightScene`2`6~@roomShadeScene`2`6',1),(3,9,0,'Bed Time','','F','@singleLight`67`0`2~@singleLight`68`0`2~@singleLight`76`0`2',1),(1,2,1,'Watch TV','','F','@singleLight`1`60`2~@singleLight`2`20`2~@singleLight`3`80`2~@singleLight`4`0`0~@singleLight`5`0`0~@singleLight`19`0`0~@roomShadeScene`1`2~@videoSrc`1`2',0),(2,3,1,'Upper Shades Open','','F','@singleLight`142`100`0~@singleLight`143`100`0~@singleLight`144`100`0~@singleLight`145`100`0~@singleLight`146`100`0~@singleLight`152`100`0~@singleLight`153`100`0~@singleLight`154`100`0~@singleLight`155`100`0~@singleLight`156`100`0',0),(2,2,1,'Upper Shades Close','','F','@singleLight`142`0`0~@singleLight`143`0`0~@singleLight`144`0`0~@singleLight`145`0`0~@singleLight`146`0`0~@singleLight`152`0`0~@singleLight`153`0`0~@singleLight`154`0`0~@singleLight`155`0`0~@singleLight`156`0`0',0),(29,1,1,'Leave','','F','@roomLightScene`29`2~@audioSrc`29`0',0),(12,3,1,'Ambiance','','F','@singleLight`56`70`2~@singleLight`57`70`2~@singleLight`58`100`0~@singleLight`59`70`2~@singleLight`60`50`2~@singleLight`61`100`0~@singleLight`62`100`0~@audioSrc`12`1',0),(12,2,1,'Cook','','F','@singleLight`56`100`2~@singleLight`57`100`2~@singleLight`58`100`0~@singleLight`59`100`2~@singleLight`60`100`2~@singleLight`61`100`0~@singleLight`62`100`0',0),(12,4,1,'Exhaust On','','F','@singleLight`63`100`0',0),(12,5,1,'Exhaust Off','','F','@singleLight`63`0`0',0),(1,15,0,'All Shades Close','','F','',1),(2,15,0,'All Shades Close','','F','@roomShadeScene`2`2',1),(3,15,0,'All Shades Close','','F','',1),(4,15,0,'All Shades Close','','F','@roomShadeScene`4`2',1),(5,15,0,'All Shades Close','','F','',1),(6,15,0,'All Shades Close','','F','',1),(7,15,0,'All Shades Close','','F','',1),(8,15,0,'All Shades Close','','F','',1),(9,15,0,'All Shades Close','','F','@roomShadeScene`9`2',1),(10,15,0,'All Shades Close','','F','@roomShadeScene`10`2',1),(11,15,0,'All Shades Close','','F','@singleLight`147`0`0',1),(12,15,0,'All Shades Close','','F','',1),(13,15,0,'All Shades Close','','F','@roomShadeScene`13`2',1),(14,15,0,'All Shades Close','','F','@roomShadeScene`14`2',1),(15,15,0,'All Shades Close','','F','@roomShadeScene`15`2',1),(16,15,0,'All Shades Close','','F','',1),(17,15,0,'All Shades Close','','F','',1),(18,15,0,'All Shades Close','','F','',1),(19,15,0,'All Shades Close','','F','',1),(20,15,0,'All Shades Close','','F','@roomShadeScene`20`2',1),(21,15,0,'All Shades Close','','F','',1),(22,15,0,'All Shades Close','','F','',1),(23,15,0,'All Shades Close','','F','',1),(24,15,0,'All Shades Close','','F','',1),(25,15,0,'All Shades Close','','F','',1),(26,15,0,'All Shades Close','','F','',1),(27,15,0,'All Shades Close','','F','',1),(28,15,0,'All Shades Close','','F','@roomShadeScene`28`2',1),(29,15,0,'All Shades Close','','F','',1),(1,6,0,'Sunny Day','T06:45','F','',1),(2,6,0,'Sunny Day','','F','@singleLight`38`0`2~@singleLight`39`0`2~@singleLight`40`33`2~@singleLight`41`0`2~@singleLight`140`100`0~@singleLight`141`100`0~@singleLight`142`100`0~@singleLight`143`100`0~@singleLight`144`100`0~@singleLight`145`100`0~@singleLight`146`100`0~@singleLight`150`100`0~@singleLight`151`100`0~@singleLight`152`100`0~@singleLight`153`100`0~@singleLight`154`100`0~@singleLight`155`100`0~@singleLight`156`100`0',1),(3,6,0,'Sunny Day','','F','',1),(4,6,0,'Sunny Day','','F','',1),(5,6,0,'Sunny Day','','F','',1),(6,6,0,'Sunny Day','','F','',1),(7,6,0,'Sunny Day','','F','',1),(8,6,0,'Sunny Day','','F','@singleLight`34`33`2~@singleLight`35`0`2~@singleLight`36`33`2~@singleLight`37`0`2',1),(9,6,0,'Sunny Day','','F','',1),(10,6,0,'Sunny Day','','F','',1),(11,6,0,'Sunny Day','','F','',1),(12,6,0,'Sunny Day','','F','@singleLight`56`75`2~@singleLight`57`75`2~@singleLight`58`0`0~@singleLight`59`0`2~@singleLight`60`50`2~@singleLight`61`100`0~@singleLight`62`0`0~@singleLight`63`0`0',1),(13,6,0,'Sunny Day','','F','',1),(14,6,0,'Sunny Day','','F','',1),(15,6,0,'Sunny Day','','F','',1),(16,6,0,'Sunny Day','','F','',1),(17,6,0,'Sunny Day','','F','@singleLight`64`0`0~@singleLight`65`0`0~@singleLight`66`0`0',1),(18,6,0,'Sunny Day','','F','',1),(19,6,0,'Sunny Day','','F','',1),(20,6,0,'Sunny Day','','F','@singleLight`20`0`2~@singleLight`21`33`2~@singleLight`22`33`2~@singleLight`23`0`2~@singleLight`24`0`2~@singleLight`25`0`2~@singleLight`26`33`2~@singleLight`99`100`0~@singleLight`100`100`0',1),(21,6,0,'Sunny Day','','F','',1),(22,6,0,'Sunny Day','','F','@singleLight`27`50`2~@singleLight`28`50`2~@singleLight`101`0`2~@singleLight`102`0`2~@singleLight`103`0`0',1),(23,6,0,'Sunny Day','','F','',1),(24,6,0,'Sunny Day','','F','',1),(25,6,0,'Sunny Day','','F','',1),(26,6,0,'Sunny Day','','F','',1),(27,6,0,'Sunny Day','','F','',1),(28,6,0,'Sunny Day','','F','',1),(29,6,0,'Sunny Day','','F','',1),(10,2,1,'Nite','','F','@singleLight`81`10`2~@singleLight`82`10`2~@singleLight`83`0`2~@singleLight`84`0`2~@singleLight`85`0`2~@singleLight`88`0`0~@singleLight`89`0`0~@singleLight`106`0`2~@singleLight`107`0`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 ('2010-10-08 18:11:42','mpullin',1,0,'Actions changed'),('2010-10-29 13:44:13','ewolfram',1,0,'Actions changed'),('2010-11-19 16:13:24','mpullin',11,0,'Actions changed'),('2010-11-19 16:15:50','mpullin',11,0,'Actions changed'),('2010-11-19 16:19:33','mpullin',11,0,'Actions changed'),('2010-11-19 16:20:24','mpullin',11,0,'Actions changed'),('2010-11-19 16:22:48','mpullin',11,0,'Actions changed'),('2010-11-19 16:22:54','mpullin',11,0,'Actions changed'),('2010-11-19 16:24:15','mpullin',11,0,'Actions changed'),('2010-11-19 16:24:25','mpullin',11,0,'Actions changed'),('2010-11-19 16:25:48','mpullin',11,0,'Actions changed'),('2010-11-19 16:35:50','mpullin',11,0,'Actions changed'),('2010-12-06 16:21:04','bdavies',1,0,'Actions changed'),('2010-12-06 16:21:10','bdavies',1,0,'Deleted'),('2010-12-07 17:48:58','mpullin',1,0,'Actions changed'),('2010-12-07 17:50:08','mpullin',1,0,'Actions changed'),('2010-12-13 16:15:01','jplatt',1,0,'Actions changed'),('2010-12-13 16:15:09','jplatt',1,0,'Actions changed'),('2010-12-13 16:15:17','jplatt',1,0,'Renamed: TEST Audio All On'),('2010-12-13 16:16:12','jplatt',1,0,'Actions changed'),('2010-12-13 16:18:11','jplatt',1,0,'Actions changed'),('2010-12-13 16:19:13','jplatt',1,0,'Actions changed'),('2010-12-13 16:22:05','jplatt',1,0,'Actions changed'),('2010-12-13 16:24:32','jplatt',1,0,'Actions changed'),('2010-12-13 16:34:31','jplatt',1,0,'Renamed: TEST All Shades Close'),('2010-12-13 16:48:43','jplatt',1,0,'Override: 1'),('2010-12-13 16:48:50','jplatt',1,0,'Override: 1'),('2010-12-13 16:48:56','jplatt',1,0,'Override: 1'),('2010-12-13 16:49:10','jplatt',1,0,'Override: 1'),('2010-12-13 16:49:15','jplatt',1,0,'Override: 1'),('2010-12-13 16:49:32','jplatt',1,0,'Override: 1'),('2010-12-13 16:49:42','jplatt',1,0,'Override: 1'),('2010-12-13 16:56:56','jplatt',1,0,'Actions changed'),('2010-12-13 17:16:16','bdavies',1,0,'Deleted'),('2010-12-13 17:16:23','bdavies',1,0,'Deleted'),('2010-12-13 17:19:02','mpullin',1,0,'Actions changed'),('2010-12-13 17:19:06','bdavies',1,0,'Actions changed'),('2010-12-13 17:20:33','bdavies',1,0,'Actions changed'),('2010-12-14 09:36:36','jplatt',1,0,'Actions changed'),('2010-12-14 09:37:13','jplatt',1,0,'Actions changed'),('2010-12-14 10:05:27','jplatt',1,0,'Actions changed'),('2010-12-14 10:13:54','jplatt',1,0,'Actions changed'),('2010-12-14 10:14:27','jplatt',12,0,'Actions changed'),('2010-12-14 10:15:03','jplatt',12,0,'Actions changed'),('2010-12-14 10:15:18','jplatt',12,0,'Actions changed'),('2010-12-14 10:15:56','jplatt',12,0,'Actions changed'),('2010-12-14 10:16:52','jplatt',12,0,'Actions changed'),('2010-12-14 10:26:15','jplatt',12,0,'Actions changed'),('2010-12-14 10:26:39','jplatt',12,0,'Actions changed'),('2010-12-14 10:27:39','jplatt',12,0,'Reordered Modes'),('2010-12-14 10:27:46','jplatt',12,0,'Actions changed'),('2010-12-14 10:29:42','jplatt',12,0,'Actions changed'),('2010-12-14 10:29:52','jplatt',12,0,'Renamed: Ambiance'),('2010-12-14 10:30:05','jplatt',12,0,'Actions changed'),('2010-12-14 10:32:05','jplatt',12,0,'Actions changed'),('2010-12-14 18:08:39','bdavies',4,0,'Actions changed'),('2010-12-15 10:16:08','jplatt',2,0,'Actions changed'),('2010-12-15 10:16:18','jplatt',2,0,'Actions changed'),('2010-12-15 10:16:29','jplatt',2,0,'Actions changed'),('2010-12-15 10:16:37','jplatt',2,0,'Actions changed'),('2010-12-15 10:17:19','jplatt',2,0,'Schedule changed'),('2010-12-15 10:17:44','jplatt',2,0,'Schedule changed'),('2010-12-15 13:56:59','[touchpanel]',2,0,'Schedule changed'),('2010-12-15 13:57:30','[touchpanel]',2,0,'Schedule changed'),('2010-12-16 09:48:40','jplatt',1,0,'Actions changed'),('2010-12-16 09:49:26','jplatt',1,0,'Actions changed'),('2010-12-16 09:50:06','jplatt',1,0,'Actions changed'),('2010-12-16 09:50:55','jplatt',1,0,'Actions changed'),('2010-12-16 10:00:15','jplatt',1,0,'Reordered Modes'),('2010-12-16 16:26:16','mpullin',3,0,'Actions changed'),('2010-12-16 16:27:10','mpullin',3,0,'Actions changed'),('2010-12-16 16:28:29','mpullin',4,0,'Actions changed'),('2010-12-16 16:28:58','mpullin',3,0,'Actions changed'),('2010-12-16 16:29:40','mpullin',10,0,'Actions changed'),('2010-12-16 16:30:20','mpullin',13,0,'Actions changed'),('2010-12-16 16:30:41','mpullin',14,0,'Actions changed'),('2010-12-16 16:30:53','mpullin',15,0,'Actions changed'),('2010-12-16 16:31:03','mpullin',16,0,'Actions changed'),('2010-12-16 16:31:18','mpullin',24,0,'Actions changed'),('2010-12-16 16:31:43','mpullin',25,0,'Actions changed'),('2010-12-16 16:31:56','mpullin',28,0,'Actions changed'),('2010-12-16 16:32:11','mpullin',28,0,'Actions changed'),('2010-12-16 16:32:38','mpullin',15,0,'Actions changed'),('2010-12-16 16:32:50','mpullin',14,0,'Actions changed'),('2010-12-16 16:33:04','mpullin',13,0,'Actions changed'),('2010-12-16 16:33:13','mpullin',10,0,'Actions changed'),('2010-12-16 16:33:26','mpullin',4,0,'Actions changed'),('2010-12-16 16:33:59','mpullin',2,0,'Actions changed'),('2010-12-16 16:34:12','mpullin',6,0,'Actions changed'),('2010-12-16 16:34:24','mpullin',7,0,'Actions changed'),('2010-12-16 16:35:10','mpullin',8,0,'Actions changed'),('2010-12-16 16:39:00','mpullin',9,0,'Actions changed'),('2010-12-16 16:40:33','mpullin',11,0,'Actions changed'),('2010-12-16 16:41:15','mpullin',12,0,'Actions changed'),('2010-12-16 16:42:01','mpullin',17,0,'Actions changed'),('2010-12-16 16:42:45','mpullin',20,0,'Actions changed'),('2010-12-16 16:42:58','mpullin',22,0,'Actions changed'),('2010-12-16 16:43:20','mpullin',27,0,'Actions changed'),('2010-12-16 16:43:50','mpullin',1,0,'Actions changed'),('2010-12-16 16:44:18','mpullin',5,0,'Actions changed'),('2010-12-16 16:45:06','mpullin',18,0,'Actions changed'),('2010-12-16 16:45:30','mpullin',21,0,'Actions changed'),('2010-12-16 16:45:49','mpullin',26,0,'Actions changed'),('2010-12-16 16:46:54','mpullin',29,0,'Actions changed'),('2010-12-16 16:51:26','mpullin',19,0,'Actions changed'),('2010-12-16 16:51:39','mpullin',18,0,'Actions changed'),('2010-12-16 16:53:17','mpullin',1,0,'Actions changed'),('2010-12-16 17:22:33','mpullin',1,0,'Actions changed'),('2010-12-16 17:22:49','mpullin',1,0,'Actions changed'),('2010-12-16 17:24:27','mpullin',1,0,'Actions changed'),('2010-12-16 17:25:47','mpullin',1,0,'Actions changed'),('2010-12-16 17:56:12','mpullin',1,0,'Actions changed'),('2010-12-16 17:56:41','mpullin',1,0,'Actions changed'),('2010-12-16 18:02:57','mpullin',1,0,'Actions changed'),('2010-12-16 18:07:39','mpullin',1,0,'Actions changed'),('2010-12-17 15:05:29','jplatt',2,0,'Renamed: Upper Shades Close'),('2010-12-17 15:05:39','jplatt',2,0,'Renamed: Upper Shades Open'),('2010-12-17 15:06:24','jplatt',2,0,'Actions changed'),('2010-12-17 15:06:44','jplatt',2,0,'Actions changed'),('2010-12-20 11:59:05','jplatt',1,0,'Actions changed'),('2010-12-20 11:59:21','jplatt',1,0,'Actions changed'),('2010-12-20 13:29:45','jplatt',2,0,'Schedule Exception Update'),('2010-12-22 12:09:59','jplatt',1,0,'Actions changed'),('2010-12-22 14:06:11','jplatt',0,0,'Reordered Modes'),('2010-12-22 14:06:34','jplatt',0,0,'Reordered Modes'),('2010-12-22 14:06:45','jplatt',1,0,'Deleted'),('2011-01-11 11:49:30','jplatt',1,0,'Deleted'),('2011-01-11 11:49:34','jplatt',1,0,'Deleted'),('2011-01-11 11:49:38','jplatt',1,0,'Deleted'),('2011-01-11 11:49:42','jplatt',1,0,'Deleted'),('2011-01-11 11:49:50','jplatt',1,0,'Deleted'),('2011-01-11 11:49:55','jplatt',1,0,'Deleted'),('2011-01-11 11:50:10','jplatt',1,0,'Override: 1'),('2011-01-11 11:56:53','jplatt',1,0,'Actions changed'),('2011-01-11 11:57:11','jplatt',1,0,'Renamed: Lights TEST Scene'),('2011-01-11 11:59:35','jplatt',1,0,'Actions changed'),('2011-01-11 12:04:07','jplatt',1,0,'Actions changed'),('2011-01-11 12:07:52','jplatt',1,0,'Actions changed'),('2011-01-11 12:11:04','jplatt',1,0,'Actions changed'),('2011-01-11 12:13:54','jplatt',1,0,'Actions changed'),('2011-01-11 12:14:34','jplatt',1,0,'Actions changed'),('2011-01-11 12:15:43','jplatt',1,0,'Actions changed'),('2011-01-11 12:16:15','jplatt',1,0,'Override: 1'),('2011-01-11 12:16:19','jplatt',1,0,'Override: 1'),('2011-01-11 12:16:24','jplatt',1,0,'Override: 1'),('2011-01-11 12:16:42','jplatt',0,0,'Reordered Modes'),('2011-01-11 12:22:21','jplatt',1,0,'Actions changed'),('2011-01-11 12:22:29','jplatt',1,0,'Deleted'),('2011-01-11 12:23:24','jplatt',1,0,'Actions changed'),('2011-01-11 12:23:48','jplatt',1,0,'Renamed: Sunset'),('2011-01-11 12:24:17','jplatt',1,0,'Schedule changed'),('2011-01-11 12:24:25','jplatt',1,0,'Renamed: Evening'),('2011-01-11 12:24:51','jplatt',1,0,'Renamed: Midnight'),('2011-01-11 12:25:07','jplatt',1,0,'Schedule changed'),('2011-01-11 12:25:52','jplatt',1,0,'Actions changed'),('2011-01-11 12:26:09','jplatt',1,0,'Override: 1'),('2011-01-11 12:27:09','jplatt',1,0,'Actions changed'),('2011-01-11 12:27:29','jplatt',1,0,'Actions changed'),('2011-01-11 12:27:54','jplatt',1,0,'Renamed: All Shades Close'),('2011-01-11 12:29:31','jplatt',1,0,'Actions changed'),('2011-01-11 12:29:50','jplatt',1,0,'Actions changed'),('2011-01-11 12:30:10','jplatt',0,0,'Reordered Modes'),('2011-01-11 12:30:52','jplatt',0,0,'Reordered Modes'),('2011-01-13 14:39:08','jplatt',1,0,'Actions changed'),('2011-01-13 14:39:27','jplatt',0,0,'Reordered Modes'),('2011-01-13 15:00:54','jplatt',1,0,'Override: 1'),('2011-03-17 14:13:09','[touchpanel]',1,0,'Schedule changed'),('2011-03-17 22:42:15','[touchpanel]',1,0,'Schedule changed'),('2011-03-17 22:43:20','[touchpanel]',1,0,'Schedule changed'),('2011-03-17 22:43:29','[touchpanel]',1,0,'Schedule changed'),('2011-03-17 22:43:33','[touchpanel]',1,0,'Schedule changed'),('2011-03-18 23:03:40','[touchpanel]',1,0,'Schedule changed'),('2011-03-20 00:01:59','[touchpanel]',1,0,'Schedule changed'),('2011-03-20 00:02:03','[touchpanel]',1,0,'Schedule changed'),('2011-03-20 00:02:12','[touchpanel]',1,0,'Schedule changed'),('2011-03-20 00:28:54','[touchpanel]',1,0,'Schedule changed'),('2011-03-20 00:29:01','[touchpanel]',1,0,'Schedule changed'),('2011-03-23 22:16:38','[touchpanel]',1,0,'Schedule changed'),('2011-03-24 10:10:43','jplatt',1,0,'Override: 1'),('2011-03-24 10:23:13','jplatt',1,0,'Deleted'),('2011-04-19 22:03:22','[touchpanel]',1,0,'Schedule changed'),('2011-04-19 22:03:35','[touchpanel]',1,0,'Schedule changed'),('2011-04-19 22:03:39','[touchpanel]',1,0,'Schedule changed'),('2011-04-19 22:03:45','[touchpanel]',1,0,'Schedule changed'),('2011-05-04 14:16:29','jtuthill',1,0,'Override: 0'),('2011-05-04 20:52:13','jtuthill',1,0,'Renamed: Bed Time'),('2011-05-04 20:59:57','jtuthill',1,0,'Actions changed'),('2011-05-04 22:18:23','[touchpanel]',1,0,'Schedule changed'),('2011-05-04 22:22:26','jtuthill',1,0,'Actions changed'),('2011-05-04 22:24:07','jtuthill',1,0,'Actions changed'),('2011-05-04 22:26:04','jtuthill',1,0,'Actions changed'),('2011-05-05 23:24:19','jtuthill',1,0,'Actions changed'),('2011-05-05 23:27:11','jtuthill',1,0,'Actions changed'),('2011-05-07 01:14:11','[touchpanel]',1,0,'Schedule changed'),('2011-05-07 01:14:17','[touchpanel]',1,0,'Schedule changed'),('2011-05-07 01:17:19','jtuthill',1,0,'Actions changed'),('2011-05-07 01:19:43','jtuthill',28,0,'Actions changed'),('2011-05-07 01:22:04','jtuthill',1,0,'Actions changed'),('2011-05-15 19:43:26','jtuthill',1,0,'Renamed: Family Evening'),('2011-05-15 19:43:50','jtuthill',1,0,'Renamed: Typ Evening'),('2011-05-15 19:58:45','jtuthill',1,0,'Actions changed'),('2011-05-16 19:11:58','jtuthill',1,0,'Actions changed'),('2011-05-16 19:14:15','jtuthill',1,0,'Actions changed'),('2011-05-16 19:15:00','jtuthill',1,0,'Override: 1'),('2011-05-16 19:15:27','jtuthill',1,0,'Schedule changed'),('2011-05-17 18:28:03','[touchpanel]',1,0,'Schedule changed'),('2011-05-20 09:25:10','[touchpanel]',2,0,'Schedule changed'),('2011-05-20 09:25:16','[touchpanel]',2,0,'Schedule changed'),('2011-05-23 23:39:21','[touchpanel]',1,0,'Schedule changed'),('2011-05-23 23:39:31','[touchpanel]',1,0,'Schedule changed'),('2011-06-17 18:13:37','[touchpanel]',1,0,'Schedule changed'),('2011-06-17 18:13:40','[touchpanel]',1,0,'Schedule changed'),('2011-08-06 18:02:23','[touchpanel]',1,0,'Schedule changed'),('2011-08-06 18:02:34','[touchpanel]',1,0,'Schedule changed'),('2011-08-17 15:39:45','jplatt',1,0,'Actions changed'),('2011-08-17 15:44:05','jplatt',1,0,'Actions changed'),('2011-08-17 15:44:13','jplatt',1,0,'Actions changed'),('2011-08-17 15:44:21','jplatt',1,0,'Actions changed'),('2011-08-17 15:44:30','jplatt',1,0,'Actions changed'),('2011-08-17 15:44:35','jplatt',1,0,'Actions changed'),('2011-08-17 15:44:44','jplatt',1,0,'Actions changed'),('2011-08-17 15:44:52','jplatt',1,0,'Actions changed'),('2011-08-18 15:08:41','mpullin',1,0,'Actions changed'),('2011-08-18 15:08:49','mpullin',1,0,'Actions changed'),('2011-08-18 15:08:58','mpullin',1,0,'Actions changed'),('2011-08-18 15:09:09','mpullin',1,0,'Actions changed'),('2011-08-18 15:09:22','mpullin',1,0,'Actions changed'),('2011-08-18 15:09:32','mpullin',1,0,'Actions changed'),('2011-08-18 15:09:45','mpullin',1,0,'Actions changed'),('2011-08-18 15:10:07','mpullin',1,0,'Actions changed'),('2011-08-18 15:10:20','mpullin',1,0,'Actions changed'),('2011-08-18 15:10:29','mpullin',1,0,'Actions changed'),('2011-08-18 15:10:35','mpullin',1,0,'Actions changed'),('2011-08-18 15:10:41','mpullin',1,0,'Actions changed'),('2011-08-18 15:10:46','mpullin',1,0,'Actions changed'),('2011-08-18 15:10:53','mpullin',1,0,'Actions changed'),('2011-09-07 12:15:57','smoscinski',1,0,'Actions changed'),('2011-09-26 20:49:02','[touchpanel]',1,0,'Schedule changed'),('2011-10-09 20:46:29','[touchpanel]',1,0,'Schedule changed'),('2011-10-09 20:46:35','[touchpanel]',1,0,'Schedule changed'),('2011-10-30 16:23:34','[touchpanel]',1,0,'Schedule changed'),('2011-11-26 17:33:23','[touchpanel]',1,0,'Schedule changed'),('2011-12-19 09:43:55','jplatt',1,0,'Actions changed'),('2011-12-20 15:32:45','mpullin',1,0,'Actions changed'),('2011-12-20 15:35:11','mpullin',1,0,'Actions changed'),('2011-12-20 15:36:51','mpullin',1,0,'Actions changed'),('2012-01-12 08:56:19','jtuthill',1,0,'Actions changed'),('2012-01-12 08:57:27','jtuthill',1,0,'Renamed: Typ Daytime'),('2012-01-12 08:58:13','jtuthill',0,0,'Reordered Modes'),('2012-01-12 09:03:32','jtuthill',1,0,'Actions changed'),('2012-01-18 16:06:32','jtuthill',1,0,'Actions changed'),('2012-01-18 16:07:18','jtuthill',1,0,'Actions changed'),('2012-01-18 16:10:52','jtuthill',1,0,'Actions changed'),('2012-01-21 17:34:51','jtuthill',1,0,'Actions changed'),('2012-01-21 17:36:52','jtuthill',1,0,'Renamed: Unused'),('2012-01-21 17:41:01','jtuthill',1,0,'Actions changed'),('2012-01-21 17:41:18','jtuthill',1,0,'Renamed: All Off'),('2012-02-01 18:10:46','[touchpanel]',1,0,'Schedule changed'),('2012-02-01 18:10:50','[touchpanel]',1,0,'Schedule changed'),('2012-02-20 23:02:16','jtuthill',1,0,'Actions changed'),('2012-02-20 23:03:14','jtuthill',1,0,'Actions changed'),('2012-02-20 23:03:38','jtuthill',1,0,'Actions changed'),('2012-02-24 17:51:39','[touchpanel]',1,0,'Schedule changed'),('2012-05-18 00:42:35','[touchpanel]',1,0,'Schedule changed'),('2012-07-20 01:40:02','[touchpanel]',1,0,'Schedule changed'),('2012-07-20 01:40:05','[touchpanel]',1,0,'Schedule changed'),('2012-08-03 07:43:18','[touchpanel]',1,0,'Schedule changed'),('2012-08-16 14:33:52','jtuthill',1,0,'Renamed: Cloudy Day'),('2012-08-16 14:34:08','jtuthill',1,0,'Renamed: Sunny Day'),('2012-08-16 14:36:33','jtuthill',1,0,'Actions changed'),('2012-08-16 14:36:55','jtuthill',1,0,'Renamed: Evening'),('2012-08-16 14:49:49','jtuthill',1,0,'Schedule changed'),('2012-08-16 14:50:39','jtuthill',1,0,'Schedule changed'),('2012-08-16 14:50:59','jtuthill',1,0,'Schedule changed'),('2012-08-16 14:51:46','jtuthill',1,0,'Schedule changed'),('2012-08-16 14:52:09','jtuthill',1,0,'Override: 0'),('2012-08-16 14:52:22','jtuthill',1,0,'Override: 1'),('2012-08-16 14:52:53','jtuthill',1,0,'Schedule Exception Update'),('2012-08-16 14:53:42','jtuthill',1,0,'Schedule changed'),('2012-08-16 14:54:47','jtuthill',1,0,'Schedule changed'),('2012-08-18 08:46:06','jtuthill',0,0,'Reordered Modes'),('2012-08-18 08:46:07','jtuthill',0,0,'Reordered Modes'),('2012-08-18 08:49:13','jtuthill',1,0,'Actions changed'),('2012-08-18 08:57:48','jtuthill',1,0,'Actions changed'),('2012-08-18 08:58:53','jtuthill',1,0,'Actions changed'),('2012-08-20 08:08:47','jtuthill',1,0,'Actions changed'),('2012-08-23 21:09:20','[touchpanel]',1,0,'Schedule changed'),('2012-10-15 22:02:27','jtuthill',10,0,'Actions changed'),('2012-10-15 22:06:05','jtuthill',1,0,'Actions changed'),('2012-10-15 22:11:56','jtuthill',1,0,'Actions changed'),('2012-10-24 07:34:27','jtuthill',1,0,'Actions changed'),('2012-10-24 07:40:10','jtuthill',1,0,'Actions changed'),('2012-10-25 18:59:44','jtuthill',1,0,'Actions changed'),('2012-11-12 07:44:48','jtuthill',1,0,'Actions changed'),('2013-05-10 03:26:57','[touchpanel]',1,0,'Schedule changed'),('2013-05-13 02:41:50','mpullin',1,0,'Actions changed'),('2013-05-13 15:58:00','mpullin',0,0,'Reordered Modes'),('2013-05-13 16:14:07','mpullin',0,0,'Reordered Modes'),('2013-05-13 16:43:18','mpullin',1,9,'Actions changed'),('2013-05-13 16:54:53','mpullin',1,9,'Actions changed'),('2013-05-13 17:04:12','mpullin',1,6,'Actions changed'),('2013-05-16 18:49:57','jplatt',1,0,'Reordered Modes'),('2013-05-16 18:50:07','jplatt',1,2,'Renamed: Watch TV1'),('2013-05-16 18:50:26','jplatt',1,2,'Renamed: Watch TV'),('2013-05-16 23:56:11','jtuthill',1,8,'Schedule changed'),('2013-05-16 23:56:24','jtuthill',1,8,'Schedule changed'),('2013-05-24 10:53:58','jtuthill',1,9,'Schedule changed'),('2013-06-05 19:27:48','mpullin',1,6,'Actions changed'),('2013-06-05 21:02:05','mpullin',1,6,'Actions changed'),('2013-07-24 17:47:59','jtuthill',1,9,'Schedule Exception Update'),('2013-08-06 13:29:51','mpullin',3,1,'Actions changed'),('2013-08-06 14:44:38','jtuthill',1,9,'Schedule Exception Update'),('2013-08-06 14:48:29','jtuthill',1,9,'Actions changed'),('2015-05-07 13:42:52','mlandis',1,6,'Actions changed'),('2015-05-07 14:03:54','mlandis',6,1,'Actions changed'),('2016-02-08 16:00:03','mlandis',10,2,'Actions changed'),('2016-02-08 16:03:41','mlandis',10,2,'Actions changed'),('2016-02-08 16:05:06','mlandis',10,2,'Actions changed'),('2016-02-08 16:13:01','mlandis',10,2,'Actions changed'),('2016-02-08 18:01:32','mlandis',10,2,'Actions changed'),('2016-03-22 14:54:22','jtuthill',1,9,'Actions changed'),('2016-10-22 12:23:10','[touchpanel]',1,7,'Schedule changed'),('2017-01-23 13:26:35','[touchpanel]',1,7,'Schedule changed'),('2017-09-15 04:51:55','[touchpanel]',1,7,'Schedule changed'),('2018-01-11 15:14:58','[touchpanel]',1,7,'Schedule changed'),('2018-01-23 22:23:55','[touchpanel]',1,7,'Schedule changed'),('2018-10-25 22:19:16','[touchpanel]',1,7,'Schedule 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 */;
/*!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,'Entertain Bsmnt',1,1,4,99,99,'[1:8:2:3]',NULL,'[1:8:2:25]',0,'0 0 0 0 0 0 0 0 0 0',297,292,0,0),(2,2,'Family Room',2,2,22,95,95,'[1:8:2:10]','[1:6:20]','[1:8:2:28]',0,'0 0 0 0 0 0 0 0 0 0',999,999,0,0),(3,3,'TV Loft',3,3,12,95,95,'[1:8:2:21]',NULL,NULL,0,'0 0 0 0 0 0 0 0 0 0',999,999,0,0),(4,3,'Guest Lg',4,4,15,99,100,'[1:8:2:20]',NULL,'[1:6:22]',0,'0 0 0 0 0 0 0 0 0 0',999,999,0,0),(5,1,'Work Room',5,NULL,20,50,99,'[1:8:2:5]','[1:6:9]',NULL,0,'0 0 10 10 0 20 60 75 90 100',39,284,0,0),(6,2,'West Patio',6,NULL,NULL,50,95,'[1:5:13]',NULL,NULL,0,'0 30 20 10 0 0 20 30 30 40',999,999,0,0),(7,2,'East Patio',7,NULL,NULL,50,95,'[1:5:12]',NULL,NULL,0,'30 20 10 0 0 0 10 20 30 40',999,999,0,0),(8,2,'Family Dining',NULL,NULL,22,50,85,'[1:8:2:8]','[1:6:27]','[1:8:2:26]',0,'0 0 10 10 0 5 15 20 25 30',999,999,0,0),(9,2,'Music Room',9,NULL,2,50,90,'[1:8:2:13]','[1:6:18]','[1:8:2:29]',0,'0 0 10 10 0 10 20 30 40 50',999,999,0,0),(10,3,'Master Bath',10,NULL,8,50,90,'[1:8:2:24]','[2:6:24]','[1:6:23]',0,'0 70 35 10 0 0 20 30 45 55',999,999,0,0),(11,2,'Formal Dining',11,NULL,1,45,85,'[1:8:2:9]','[1:5:18]',NULL,0,'0 0 0 0 0 0 0 0 0 0',999,999,0,0),(12,2,'Kitchen',NULL,NULL,21,58,95,'[1:8:2:12]',NULL,NULL,0,'55 90 85 55 0 0 50 75 75 90',999,999,0,0),(13,3,'Master Bedroom',14,5,7,50,90,'[1:8:2:23]',NULL,'[1:6:24]',0,'0 40 30 20 0 0 25 40 50 60',999,999,0,0),(14,3,'Jack\'s Bedroom',NULL,NULL,9,50,85,'[1:8:2:17]',NULL,'[1:8:2:30]',0,'0 0 0 0 0 0 0 0 0 0',999,999,0,0),(15,3,'Jori\'s Bedroom',NULL,NULL,10,50,85,'[1:8:2:18]',NULL,'[1:8:2:31]',0,'0 0 0 0 0 0 0 0 0 0',999,999,0,0),(16,3,'2F Hall West',NULL,NULL,11,50,85,'[1:8:2:16]','[2:6:16]',NULL,0,'0 0 0 0 0 0 0 0 0 0',999,999,0,0),(17,2,'Garage',NULL,NULL,17,50,85,'[1:8:2:11]',NULL,NULL,0,'0 0 0 0 0 0 0 0 0 0',999,999,0,0),(18,1,'Bsmnt Hall',NULL,NULL,5,50,85,'[1:8:2:2]',NULL,NULL,0,'0 0 0 0 0 0 0 0 0 0',668,27,0,0),(19,1,'Equipment Room',NULL,NULL,19,50,85,NULL,NULL,NULL,0,'0 0 0 0 0 0 0 0 0 0',999,999,0,0),(20,2,'Entry Hall',NULL,NULL,3,50,85,'[1:8:2:7]','[1:6:32]','[1:5:11]',0,'0 0 0 0 0 0 0 0 0 0',999,999,0,0),(21,1,'Wine Cellar',NULL,NULL,NULL,50,85,'[1:8:2:6]',NULL,NULL,0,'0 0 0 0 0 0 0 0 0 0',303,35,0,0),(22,2,'Powder Mud',NULL,NULL,3,50,85,'[1:8:2:15]',NULL,NULL,0,'0 0 0 0 0 0 0 0 0 0',999,999,0,0),(23,1,'Future Media Room',NULL,NULL,6,50,85,NULL,NULL,NULL,0,'0 0 0 0 0 0 0 0 0 0',999,999,0,0),(24,3,'Laundry',NULL,NULL,13,50,85,'[1:8:2:22]','[2:6:23]',NULL,0,'0 0 0 0 0 0 0 0 0 0',999,999,0,0),(25,3,'2F Hall East',NULL,NULL,16,50,85,'[1:6:28]','[2:6:10]',NULL,0,'0 0 0 0 0 0 0 0 0 0',999,999,0,0),(26,1,'Bath Bsmnt',NULL,NULL,5,50,85,'[1:8:2:1]','[2:6:9]',NULL,0,'0 0 0 0 0 0 0 0 0 0',44,33,0,0),(27,2,'Powder Guest',NULL,NULL,3,50,85,'[1:8:2:14]','[1:5:19]',NULL,0,'0 0 0 0 0 0 0 0 0 0',999,999,0,0),(28,3,'Guest Sm',NULL,NULL,14,50,85,'[1:8:2:18]',NULL,'[1:8:2:32]',0,'0 0 0 0 0 0 0 0 0 0',999,999,0,0),(29,1,'Sports Court',15,NULL,18,50,90,'[1:8:2:4]','[1:6:10]',NULL,0,'0 0 0 10 0 0 0 15 50 65',999,999,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',
  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` tinyint(3) 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,'Unused',0,'',1,999,999),(2,1,'Unused',0,'',1,999,999),(3,1,'Unused',0,'',1,999,999),(4,1,'Unused',0,'',1,999,999),(5,1,'Unused',0,'',1,999,999),(6,1,'Unused',0,'',1,999,999),(7,1,'Unused',0,'',1,999,999),(8,1,'Unused',0,'',1,999,999),(9,1,'Unused',0,'',1,999,999),(10,1,'Door D Glass',0,'',1,999,999),(11,1,'Door D Motion',0,'',1,999,999),(12,1,'Door B Motion',0,'',1,999,999),(13,1,'Door B Glass',0,'',1,999,999),(14,1,'Man Door West DC',0,'',1,999,999),(15,1,'AV Room DC',0,'',1,999,999),(16,1,'Mech Room East CO',0,'',1,999,999),(17,1,'Mech Room CO',0,'',1,999,999),(18,1,'W Basement Glass',0,'',1,999,999),(19,1,'Gym Motion',0,'',1,999,999),(20,1,'Door E Glass',0,'',1,999,999),(21,1,'Door E Motion',0,'',1,999,999),(22,1,'Garage Entry Motion',0,'',1,999,999),(23,1,'West Bmt Door Left',0,'',1,999,999),(24,1,'West Bmt Door Right',0,'',1,999,999),(25,1,'Door C Glass',0,'',1,999,999),(26,1,'Door C Motion',0,'',1,999,999),(27,1,'2F East Motion',0,'',1,999,999),(28,1,'Garage Door 5',0,'',1,999,999),(29,1,'Garage Door 4',0,'',1,999,999),(30,1,'Garage Door 3',0,'',1,999,999),(31,1,'Garage Door 2',0,'',1,999,999),(32,1,'Garage Door 1',0,'',1,999,999),(33,1,'Sliding Door C',0,'',1,999,999),(34,1,'West Bmt CO',0,'',1,999,999),(35,1,'East Deck DC',0,'',1,999,999),(36,1,'West Deck DC',0,'',1,999,999),(37,1,'East Front Door',0,'',1,999,999),(38,1,'East Man Door',0,'',1,999,999),(39,1,'Door A DC',0,'',1,999,999),(40,1,'Door A Glass',0,'',1,999,999),(41,1,'Water Bug',0,'',1,999,999),(42,1,'2F West Motion',0,'',1,999,999),(43,1,'Door A Motion',0,'',1,999,999),(44,1,'Sliding Door D',0,'',1,999,999),(45,1,'Sliding Door B',0,'',1,999,999),(46,1,'Gym South Door',0,'',1,999,999),(47,1,'Gym North Door',0,'',1,999,999),(48,1,'Gym Glass',0,'',1,999,999),(49,1,'Unused',0,'',1,999,999),(50,1,'Unused',0,'',1,999,999),(51,1,'Unused',0,'',1,999,999),(52,1,'Unused',0,'',1,999,999),(53,1,'Unused',0,'',1,999,999),(54,1,'Aux 12VDC Fail',0,'',1,999,999),(55,1,'Wine Room Temp',0,'',1,999,999),(56,1,'Wine Room Humidity',0,'',1,999,999),(57,1,'Elevator Shaft Top',0,'',1,999,999),(58,1,'Mech Room Smoke',0,'',1,999,999),(59,1,'Ent Room West Smoke',0,'',1,999,999),(60,1,'Ent Room East Smoke',0,'',1,999,999),(61,1,'Basement West Wall Smoke',0,'',1,999,999),(62,1,'Elevator Room Heat',0,'',1,999,999),(63,1,'Mech Room Heat',0,'',1,999,999),(64,1,'Basement East Wall Smoke',0,'',1,999,999),(65,1,'BF Mech Heat',0,'',1,999,999),(66,1,'BF Bathrooom Heat',0,'',1,999,999),(67,1,'2F Mech Heat',0,'',1,999,999),(68,1,'Pump Room Heat',0,'',1,999,999),(69,1,'Wine Room Smoke',0,'',1,999,999),(70,1,'Silhouette',0,'',1,999,999);
/*!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 */;
INSERT INTO `shadeScene` VALUES ('[1:8:2:25]',1,'Open'),('[1:8:2:25]',2,'Close'),('[1:8:2:28]',4,'Upper Close'),('[1:8:2:28]',3,'Upper Open'),('[1:8:2:26]',1,'Open'),('[1:8:2:26]',2,'Close'),('[1:8:2:26]',5,'All Open'),('[1:8:2:26]',6,'All Close'),('[1:8:2:29]',1,'Open'),('[1:8:2:29]',2,'Close'),('[1:8:2:27]',1,'Open'),('[1:8:2:27]',2,'Close'),('[1:6:22]',1,'Open'),('[1:6:22]',2,'Close'),('[1:6:23]',1,'Open'),('[1:6:23]',2,'Close'),('[1:8:2:30]',2,'Close'),('[1:8:2:30]',1,'Open'),('[1:6:24]',2,'Close'),('[1:6:24]',1,'Open'),('[1:8:2:31]',1,'Open'),('[1:8:2:31]',2,'Close'),('[1:8:2:32]',1,'Open'),('[1:8:2:32]',2,'Close'),('[1:8:2:28]',2,'All Close'),('[1:8:2:28]',1,'All Open'),('[1:5:11]',1,'All Open'),('[1:5:11]',2,'All Close'),('[1:8:2:28]',5,'Lower Open'),('[1:8:2:28]',6,'Lower Close');
/*!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 ('Tuthill Residence',5,10,5,190,75,25,0,0,'Hinsdale, IL',41.795240,-87.913450,'60620','AMX','MODBUS','j2733.dyndns.org',NULL,2,5,NULL,NULL,2733,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,'jellyfish-800','Jellyfish'),(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','MVP-8400i',1,'Family Room',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',1,1,1,1),(2,'10002','MVP-8400i',1,'Master Bed',13,'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',1,1,1,1),(3,'10003','MVP-5200i',1,'Kitchen',12,'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',1,1,1,1),(4,'10004','NXD-CV7',0,'Vestible 107',17,'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',1,1,1,1),(5,'10041','MIO-R4',0,'Den',3,'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',1,1,1,1),(6,'10042','MIO-R4',0,'Entertainment',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',1,1,1,1),(7,'10043','MIO-R4',1,'Bed 4',4,'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',1,1,1,1),(8,'10061','iPad',1,'iPad 1',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     ',1,1,1,1),(9,'10062','iPad',1,'iPad 2',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     ',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 (7,1),(6,3),(6,4),(6,1),(8,2),(5,3),(5,4),(6,13),(5,1),(6,2),(4,3),(4,4),(5,13),(4,1),(5,2),(3,3),(3,1),(4,13),(3,4),(2,4),(3,13),(2,13),(2,3),(4,2),(3,2),(2,1),(1,1),(1,3),(1,4),(1,13),(2,2),(1,2);
/*!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(25) 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 ('TV',1,'1',1,'ON DEMAND'),('TV',2,'2',1,'WBBM (CBS)'),('TV',3,'3',1,'HSN'),('TV',4,'4',1,'WGBO (UNI)'),('TV',5,'5',1,'WMAQ (NBC)'),('TV',6,'6',1,'Government Access'),('TV',7,'7',1,'WLS (ABC)'),('TV',8,'8',1,'WPWR (MNT)'),('TV',9,'9',1,'WGN (CW)'),('TV',10,'10',1,'WCIU'),('TV',11,'11',1,'WTTW (PBS)'),('TV',12,'12',1,'WFLD (FOX)'),('TV',13,'13',1,'WCPX (ION)'),('TV',14,'14',1,'WSNS (TEL)'),('TV',15,'15',1,'WXFT'),('TV',16,'16',1,'Educational Access'),('TV',17,'17',1,'WJYS'),('TV',18,'18',1,'TV Guide Network'),('TV',19,'19',1,'Public Access'),('TV',20,'20',1,'WYCC (PBS)'),('TV',21,'21',1,'WYIN (PBS)'),('TV',24,'24',1,'Animal Planet'),('TV',26,'26',1,'Fox News Channel'),('TV',28,'28',1,'Spike TV'),('TV',29,'29',1,'MTV'),('TV',30,'30',1,'VH1'),('TV',31,'31',1,'USA Network'),('TV',32,'32',1,'A&E'),('TV',33,'33',1,'ESPN'),('TV',34,'34',1,'ESPN2'),('TV',35,'35',1,'Headline News'),('TV',36,'36',1,'CNN'),('TV',37,'37',1,'Comcast SportsNet Chicago'),('TV',38,'38',1,'CLTV'),('TV',39,'39',1,'CNBC'),('TV',40,'40',1,'The Weather Channel'),('TV',41,'41',1,'AMC'),('TV',42,'42',1,'Comedy Central'),('TV',43,'43',1,'E!'),('TV',44,'44',1,'History'),('TV',45,'45',1,'Lifetime'),('TV',46,'46',1,'Nickelodeon'),('TV',47,'47',1,'Cartoon Network'),('TV',48,'48',1,'Discovery Channel'),('TV',49,'49',1,'TNT'),('TV',50,'50',1,'TBS'),('TV',51,'51',1,'ABC Family'),('TV',52,'52',1,'TLC'),('TV',53,'53',1,'HGTV'),('TV',54,'54',1,'Disney Channel'),('TV',58,'58',1,'FX'),('TV',59,'59',1,'MSNBC'),('TV',60,'60',1,'Food Network'),('TV',61,'61',1,'Travel Channel'),('TV',64,'64',1,'Big Ten Network'),('TV',65,'65',1,'truTV'),('TV',66,'66',1,'BET'),('TV',68,'68',1,'The Golf Channel'),('TV',70,'70',1,'Galavisi¢n (in Berwyn, Brookfield, Cicer'),('TV',72,'72',1,'Speed Channel'),('TV',73,'73',1,'TV Land'),('TV',75,'75',1,'VERSUS'),('TV',89,'89 / 164',1,'ShopNBC'),('TV',95,'95',1,'CSPAN'),('TV',97,'97',1,'QVC'),('TV',98,'98 / 138',1,'TLN'),('TV',100,'100',1,'Comcast Network 100'),('TV',101,'101',1,'Comcast Network 101'),('TV',102,'102',1,'Cable Marketplace 2'),('TV',103,'103',1,'Leased Access'),('TV',104,'104',1,'CSPAN 2'),('TV',105,'105',1,'CSPAN 3'),('TV',106,'106',1,'Fox Business Network'),('TV',107,'107',1,'Current'),('TV',108,'108',1,'National Geographic Wild'),('TV',109,'109',1,'SOAPnet'),('TV',110,'110',1,'Cable Marketplace 1'),('TV',113,'113',1,'Cable Marketplace 3'),('TV',114,'114',1,'Leased Access'),('TV',116,'116',1,'Weatherscan Local'),('TV',118,'118',1,'Style'),('TV',119,'119',1,'EWTN'),('TV',120,'120',1,'Nick Jr.'),('TV',121,'121',1,'DIY'),('TV',122,'122',1,'Disney XD'),('TV',123,'123',1,'Oxygen'),('TV',124,'124',1,'Cooking Channel'),('TV',126,'126',1,'Nicktoons Network'),('TV',127,'127',1,'PBS Kids Sprout'),('TV',128,'128',1,'Bloomberg'),('TV',129,'129 / 159',1,'Jewelry Television'),('TV',130,'130',1,'The Hub'),('TV',131,'131',1,'Hallmark Channel'),('TV',132,'132',1,'Nick Too'),('TV',134,'134',1,'Fuse'),('TV',135,'135',1,'MTV 2'),('TV',136,'136',1,'G4'),('TV',141,'141',1,'Tr3s: MTV, Musica y Mas'),('TV',142,'142',1,'MTV Jams'),('TV',143,'143',1,'LOGO'),('TV',146,'146',1,'CMT'),('TV',149,'149',1,'MoviePlex'),('TV',150,'150',1,'Ovation'),('TV',160,'160',1,'Syfy'),('TV',161,'161',1,'GSN'),('TV',162,'162',1,'BBC America'),('TV',168,'168 / 412',1,'NFL Network'),('TV',169,'169',1,'NFL Network HD'),('TV',171,'171',1,'AMC HD'),('TV',172,'172',1,'TV One'),('TV',173,'173',1,'ESPN HD'),('TV',174,'174',1,'VERSUS HD'),('TV',175,'175',1,'History HD'),('TV',176,'176',1,'TLC HD'),('TV',177,'177',1,'Syfy HD'),('TV',178,'178',1,'CNBC World'),('TV',179,'179',1,'HGTV HD'),('TV',180,'180',1,'Bravo'),('TV',181,'181',1,'Food Network HD'),('TV',182,'182',1,'WGBO (Univision) HD'),('TV',183,'183',1,'WCIU HD'),('TV',184,'184',1,'WPWR HD'),('TV',185,'185',1,'Showtime HD'),('TV',186,'186',1,'HBO HD'),('TV',187,'187',1,'WLS (ABC) HD'),('TV',188,'188',1,'WMAQ (NBC) HD'),('TV',189,'189',1,'WBBM (CBS) HD'),('TV',190,'190',1,'WFLD (FOX) HD'),('TV',191,'191',1,'WTTW (PBS) HD'),('TV',192,'192',1,'WGN (CW) HD'),('TV',193,'193',1,'WSNS (Telemundo) HD'),('TV',194,'194',1,'WXFT (Telefutura) HD'),('TV',195,'195',1,'Cinemax HD'),('TV',196,'196',1,'Starz HD'),('TV',197,'197',1,'Disney Channel HD'),('TV',198,'198',1,'ABC Family HD'),('TV',199,'199',1,'Golf HD'),('TV',200,'200',1,'Comcast SportsNet HDTV'),('TV',201,'201',1,'Planet Green'),('TV',203,'203',1,'ESPN2 HD'),('TV',204,'204',1,'TNT in HD'),('TV',205,'205',1,'HD Theater'),('TV',206,'206',1,'National Geographic HD'),('TV',207,'207',1,'Universal HD'),('TV',208,'208',1,'A&E HD'),('TV',209,'209',1,'Palladia HD'),('TV',212,'212',1,'Science Channel HD'),('TV',215,'215',1,'TeenNick'),('TV',216,'216',1,'CNN HD'),('TV',217,'217',1,'ABC 7 Live Well HD'),('TV',218,'218',1,'Discovery HD'),('TV',219,'219',1,'TBS HD'),('TV',220,'220',1,'Discovery Health'),('TV',221,'221',1,'USA HD'),('TV',222,'222',1,'FitTV'),('TV',223,'223',1,'Me-TV'),('TV',224,'224',1,'Animal Planet HD'),('TV',225,'225',1,'Nickelodeon HD'),('TV',226,'226',1,'Cartoon Network HD'),('TV',228,'228',1,'Lifetime HD'),('TV',230,'230',1,'Trinity Broadcasting'),('TV',231,'231',1,'ESPNews HD'),('TV',232,'232',1,'CBS College Sports Network HD'),('TV',233,'233',1,'MLB Network HD'),('TV',234,'234',1,'NHL Network HD'),('TV',235,'235',1,'NBA TV HD'),('TV',236,'236',1,'The Tennis Channel HD'),('TV',237,'237',1,'Speed Channel HD'),('TV',238,'238',1,'WCPX (ION) HD'),('TV',240,'240',1,'WYCC HD'),('TV',241,'241',1,'WTTW V-me'),('TV',242,'242',1,'WTTW Create'),('TV',243,'243',1,'WTTW Prime'),('TV',244,'244',1,'ABC 7 News Now'),('TV',245,'245',1,'LATV (via WOCK-DT)'),('TV',246,'246',1,'THIStv'),('TV',247,'247',1,'Me-TOO'),('TV',248,'248',1,'WFBT (via WCIU-DT)'),('TV',249,'249',1,'MCTV (via WJYS-DT)'),('TV',250,'250',1,'WYCC World'),('TV',251,'251',1,'Universal Sports'),('TV',252,'252',1,'NBC Plus'),('TV',253,'253',1,'ESPN U HD'),('TV',254,'254',1,'NFL RedZone HD'),('TV',255,'255',1,'Big Ten Network'),('TV',256,'256',1,'Big Ten Network HD'),('TV',257,'257',1,'Starz Kids & Family HD'),('TV',258,'258',1,'Starz Comedy HD'),('TV',259,'259',1,'Starz Edge HD'),('TV',260,'260',1,'TV Games'),('TV',262,'262',1,'E! HD'),('TV',265,'265',1,'Fox News Channel HD'),('TV',267,'267',1,'FX HD'),('TV',270,'270',1,'Weather Channel HD'),('TV',271,'271',1,'Investigation Discovery'),('TV',272,'272',1,'The Science Channel'),('TV',273,'273',1,'National Geographic'),('TV',274,'274',1,'Military Channel'),('TV',275,'275',1,'BIO'),('TV',276,'276',1,'History International'),('TV',285,'285',1,'Comcast Info Channel HD'),('TV',287,'287',1,'Style HD'),('TV',288,'288',1,'G4 HD'),('TV',289,'289',1,'TV One HD'),('TV',290,'290',1,'Spike HD'),('TV',293,'293',1,'Travel Channel HD'),('TV',294,'294',1,'Comedy Central HD'),('TV',295,'295',1,'BET HD'),('TV',296,'296',1,'MTV HD'),('TV',297,'297',1,'VH1 HD'),('TV',298,'298',1,'CMT HD'),('TV',299,'299',1,'GMC HD'),('TV',300,'300',1,'HBO 2 HD'),('TV',301,'301',1,'HBO Comedy HD'),('TV',304,'304',1,'HBO Zone HD'),('TV',305,'305',1,'HBO Latino HD'),('TV',307,'307',1,'ActionMax HD'),('TV',308,'308',1,'Showtime Too HD'),('TV',309,'309',1,'Showtime Showcase HD'),('TV',310,'310',1,'Showtime Extreme HD'),('TV',314,'314',1,'The Movie Channel HD'),('TV',316,'316',1,'5StarMax HD'),('TV',317,'317',1,'MSNBC HD'),('TV',318,'318',1,'Headline News HD'),('TV',319,'319',1,'Turner Classic Movies HD'),('TV',320,'320',1,'truTV HD'),('TV',321,'321',1,'Hallmark Channel HD'),('TV',322,'322',1,'HSN HD'),('TV',323,'323',1,'History International HD'),('TV',324,'324',1,'Investigation Discovery HD'),('TV',333,'333',1,'3D Events Channel'),('TV',334,'334',1,'ESPN 3D'),('TV',338,'338',1,'KBC (via WOCK-DT)'),('TV',401,'401',1,'Fox Soccer Channel'),('TV',402,'402',1,'ESPNews'),('TV',403,'403',1,'ESPN Classic'),('TV',404,'404',1,'NHL Network'),('TV',405,'405',1,'ESPNU'),('TV',406,'406',1,'Outdoor Channel'),('TV',407,'407',1,'Horse Racing TV'),('TV',410,'410',1,'MLB Network'),('TV',411,'411',1,'NFL RedZone'),('TV',413,'413',1,'FCS Atlantic'),('TV',414,'414',1,'FCS Central'),('TV',415,'415',1,'FCS Pacific'),('TV',416,'416',1,'Sportsman Channel'),('TV',417,'417',1,'Tennis Channel'),('TV',418,'418',1,'CBS College Sports'),('TV',439,'439',1,'NBA TV'),('TV',440,'440 - 449',1,'TEAM PPV'),('TV',450,'450',1,'Team PPV HD'),('TV',459,'459',1,'GAMEHD2 PPV'),('TV',460,'460',1,'Game PPV HD'),('TV',461,'461 - 470',1,'GAME PPV'),('TV',471,'471',1,'CMT Pure Country'),('TV',472,'472',1,'MTV Hits'),('TV',473,'473',1,'VH1 Classic'),('TV',474,'474',1,'VH1 Soul'),('TV',475,'475',1,'GMC'),('TV',477,'477 - 480',1,'GAME PPV'),('TV',481,'481',1,'Centric'),('TV',484,'484',1,'Great American Country'),('TV',485,'485',1,'Daystar Television Network'),('TV',486,'486',1,'The Word Network'),('TV',487,'487',1,'Retirement Living TV'),('TV',501,'501',1,'Turner Classic Movies'),('TV',502,'502',1,'WE'),('TV',503,'503',1,'Independent Film Channel'),('TV',504,'504',1,'Lifetime Movie Network'),('TV',505,'505',1,'Sundance Channel'),('TV',506,'506',1,'Fox Movie Channel'),('TV',507,'507',1,'Reelz Channel'),('TV',508,'508',1,'Hallmark Movie Channel'),('TV',516,'516',1,'Encore Wam'),('TV',517,'517',1,'Encore'),('TV',519,'519',1,'Encore Love'),('TV',521,'521',1,'Encore Mystery'),('TV',522,'522',1,'RetroPlex'),('TV',523,'523',1,'Encore Western'),('TV',527,'527',1,'Encore Drama'),('TV',528,'528',1,'IndiePlex'),('TV',529,'529',1,'Encore Action'),('TV',533,'533',1,'Starz'),('TV',535,'535',1,'Starz Edge'),('TV',537,'537',1,'Starz in Black'),('TV',538,'538',1,'Starz Cinema'),('TV',539,'539',1,'Starz Kids & Family'),('TV',540,'540',1,'Starz Comedy'),('TV',543,'543',1,'Playboy TV'),('TV',550,'550',1,'HBO East'),('TV',551,'551',1,'HBO West'),('TV',552,'552',1,'HBO 2'),('TV',554,'554',1,'HBO Signature'),('TV',556,'556',1,'HBO Family'),('TV',558,'558',1,'HBO Latino'),('TV',559,'559',1,'HBO Comedy'),('TV',560,'560',1,'HBO Zone'),('TV',561,'561',1,'Cinemax West'),('TV',562,'562',1,'Cinemax East'),('TV',564,'564',1,'MoreMax'),('TV',566,'566',1,'ActionMax'),('TV',567,'567',1,'5StarMax'),('TV',575,'575',1,'Showtime'),('TV',577,'577',1,'Showtime Too'),('TV',579,'579',1,'Showtime Showcase'),('TV',581,'581',1,'Showtime Extreme'),('TV',583,'583',1,'Showtime Next'),('TV',584,'584',1,'Showtime FamilyZone'),('TV',585,'585',1,'Showtime Women'),('TV',586,'586',1,'FLIX'),('TV',590,'590',1,'The Movie Channel'),('TV',592,'592',1,'The Movie Channel Xtra'),('TV',595,'595',1,'Playboy en Espa¤ol'),('TV',597,'597',1,'Galavisi¢n'),('TV',598,'598',1,'Azteca America'),('TV',599,'599',1,'mega tv (via WOCK-DT)'),('TV',600,'600',1,'VeneMovies'),('TV',601,'601',1,'Discovery en Espa¤ol'),('TV',602,'602',1,'Fox Deportes'),('TV',603,'603',1,'mun2'),('TV',604,'604',1,'CineLatino'),('TV',605,'605',1,'History en Espa¤ol'),('TV',606,'606',1,'Tr3s: MTV, Musica y Mas'),('TV',607,'607',1,'Canal 52MX'),('TV',608,'608',1,'CNN en Espa¤ol'),('TV',609,'609',1,'ESPN Deportes'),('TV',610,'610',1,'CineMexicano'),('TV',611,'611',1,'Caracol TV Internacional'),('TV',612,'612',1,'Ecuavisa'),('TV',613,'613',1,'El Garage'),('TV',614,'614',1,'AYM Sports'),('TV',615,'615',1,'HTV M£sica'),('TV',616,'616',1,'Mexicanal'),('TV',617,'617',1,'Disney XD'),('TV',618,'618',1,'Multimedios TV'),('TV',619,'619',1,'Cultural.es'),('TV',620,'620',1,'Gran Cine'),('TV',621,'621',1,'Canal 24 Horas'),('TV',622,'622',1,'Gol TV en Espa¤ol'),('TV',623,'623',1,'Infinito'),('TV',624,'624',1,'Video Rola'),('TV',625,'625',1,'TV Venezuela'),('TV',626,'626',1,'LaFamilia Network'),('TV',627,'627',1,'TeleF¢rmula'),('TV',628,'628',1,'Canal Sur'),('TV',630,'630',1,'TV Colombia'),('TV',631,'631',1,'TV Chile'),('TV',632,'632',1,'Latele Novela'),('TV',633,'633',1,'TBN Enlace'),('TV',634,'634',1,'Sorpresa'),('TV',635,'635',1,'S¡ TV'),('TV',637,'637',1,'EWTN Espa¤ol'),('TV',638,'638',1,'Cable Noticias'),('TV',639,'639',1,'Mexico 22'),('TV',640,'640',1,'TeleRitmo TV'),('TV',641,'641',1,'Once Mexico'),('TV',642,'642',1,'Mexico TV'),('TV',643,'643',1,'Sur Peru'),('TV',644,'644',1,'TV Dominicana'),('TV',645,'645',1,'Telemicro'),('TV',646,'646',1,'Telefe Internacional'),('TV',647,'647',1,'Util¡sima'),('TV',648,'648',1,'CBTV Michoacan'),('TV',649,'649',1,'HITN-TV'),('TV',650,'650',1,'WAPA Am‚rica'),('TV',651,'651',1,'TVE Internacional'),('TV',652,'652',1,'TeleHit'),('TV',653,'653',1,'Ritmoson'),('TV',654,'654',1,'Bandamax'),('TV',655,'655',1,'De Pelicula'),('TV',656,'656',1,'De Pelicula Clasico'),('TV',660,'660',1,'STAR India News'),('TV',661,'661',1,'STAR ONE'),('TV',662,'662',1,'STAR India GOLD'),('TV',663,'663',1,'STAR India PLUS'),('TV',664,'664',1,'SET Asia'),('TV',665,'665',1,'TV Asia (South Asian)'),('TV',666,'666',1,'Zee TV (South Asian)'),('TV',668,'668',1,'CTI Zhong Tian (Chinese)'),('TV',669,'669',1,'SBTN (Vietnamese)'),('TV',670,'670',1,'TFC (Filipino)'),('TV',671,'671',1,'CCTV 4 (Chinese)'),('TV',674,'674',1,'TV Japan'),('TV',675,'675',1,'TV Polonia'),('TV',676,'676',1,'TVP INFO'),('TV',677,'677',1,'Radio Jedynka'),('TV',678,'678',1,'Radio Trojka'),('TV',679,'679',1,'Raitalia (Italian)'),('TV',680,'680',1,'RTN (Russian)'),('TV',684,'684',1,'ART (Arabic)'),('TV',688,'688',1,'TV5 Monde (French)'),('TV',692,'692 - 694',1,'Comcast Xtra'),('TV',701,'701 - 746',1,'Music Choice'),('TV',829,'829',1,'iN DEMAND PPV HD'),('TV',830,'830 - 832',1,'iN DEMAND PPV'),('TV',833,'833 - 838',1,'ESPN Sports PPV'),('TV',840,'840',1,'Fresh!'),('TV',841,'841',1,'Spice Xcess'),('TV',842,'842',1,'Playboy TV'),('TV',844,'844',1,'Club Jenna'),('TV',845,'845',1,'Penthouse TV'),('TV',900,'900',1,'Cook County Access Channel');
/*!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 */;
/*!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,'DVR 1','DVR','TV',0,'DVR',0.0),(2,2,2,'DVR 2','DVR','TV',0,'DVR',0.0),(3,3,3,'DVR 3','DVR','TV',0,'DVR',0.0),(4,5,4,'Entertainment Blu-Ray','Blu-Ray',NULL,0,'Blu-Ray',0.0),(5,6,5,'Family Blu-Ray','Blu-Ray','',0,'Blu-Ray',0.0),(6,7,6,'TV Loft Blu-Ray','Blu-Ray','',0,'Blu-Ray',0.0),(7,8,11,'Entertainment Game','Local Src',NULL,0,'Local Src',0.0),(8,99,13,'Family Room Game','Local Src',NULL,0,'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 */;
/*!40000 ALTER TABLE `weather` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Dumping events for database 'j2733'
--

--
-- Dumping routines for database 'j2733'
--
/*!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:46
