-- MySQL dump 10.13  Distrib 5.5.31, for debian-linux-gnu (x86_64)
--
-- Host: localhost    Database: j5479
-- ------------------------------------------------------
-- Server version	5.5.31-0ubuntu0.12.10.1

/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
/*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
/*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;
/*!40101 SET NAMES utf8 */;
/*!40103 SET @OLD_TIME_ZONE=@@TIME_ZONE */;
/*!40103 SET TIME_ZONE='+00:00' */;
/*!40014 SET @OLD_UNIQUE_CHECKS=@@UNIQUE_CHECKS, UNIQUE_CHECKS=0 */;
/*!40014 SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0 */;
/*!40101 SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='NO_AUTO_VALUE_ON_ZERO' */;
/*!40111 SET @OLD_SQL_NOTES=@@SQL_NOTES, SQL_NOTES=0 */;

--
-- Table structure for table `LSIPKeypad`
--

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

--
-- Dumping data for table `LSIPKeypad`
--

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

--
-- Table structure for table `alertCondition`
--

DROP TABLE IF EXISTS `alertCondition`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `alertCondition` (
  `index` int(11) NOT NULL,
  `msg` varchar(100) NOT NULL,
  `email` varchar(50) DEFAULT NULL,
  `cc` varchar(200) DEFAULT NULL,
  `email_repeat_min` int(4) NOT NULL DEFAULT '1',
  PRIMARY KEY (`index`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `alertCondition`
--

LOCK TABLES `alertCondition` WRITE;
/*!40000 ALTER TABLE `alertCondition` DISABLE KEYS */;
INSERT INTO `alertCondition` VALUES (1,'Master Rebooted.','techservice@rexelectric.com',NULL,5),(11,'Text file corruption','mpullin@integrisys.com',NULL,0);
/*!40000 ALTER TABLE `alertCondition` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `alertLog`
--

DROP TABLE IF EXISTS `alertLog`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `alertLog` (
  `when` datetime NOT NULL,
  `msg` int(11) NOT NULL,
  `str` varchar(50) DEFAULT NULL,
  `sent_email` tinyint(1) NOT NULL DEFAULT '0'
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `alertLog`
--

LOCK TABLES `alertLog` WRITE;
/*!40000 ALTER TABLE `alertLog` DISABLE KEYS */;
INSERT INTO `alertLog` VALUES ('2012-05-03 14:02:06',1,'Compiled 05/03/12 13:13:09',1),('2012-05-03 14:37:26',1,'Compiled 05/03/12 14:36:28',1),('2012-05-03 15:46:48',1,'Compiled 05/03/12 15:45:46',1),('2012-05-03 17:11:04',1,'Compiled 05/03/12 17:10:00',1),('2012-05-03 18:59:48',1,'Compiled 05/03/12 18:58:49',1),('2012-05-04 13:00:33',1,'Compiled 05/04/12 12:59:16',1),('2012-05-17 13:58:53',1,'Compiled 05/17/12 13:57:19',1),('2012-05-17 15:17:15',1,'Compiled 05/17/12 15:15:47',1),('2012-05-17 15:25:02',1,'Compiled 05/17/12 15:23:34',1),('2012-05-17 15:37:35',1,'Compiled 05/17/12 15:35:53',1),('2012-05-17 16:41:40',1,'Compiled 05/17/12 16:39:34',1),('2012-05-18 11:52:21',1,'Compiled 05/18/12 11:50:49',1),('2012-05-18 11:55:46',1,'Compiled 05/18/12 11:53:54',0),('2012-05-29 13:31:14',1,'Compiled 05/18/12 11:53:54',1),('2012-06-01 18:48:37',1,'Compiled 06/01/12 18:43:15',1),('2012-06-01 19:37:30',1,'Compiled 06/01/12 19:35:31',1),('2012-06-01 20:08:34',1,'Compiled 06/01/12 20:06:48',1),('2012-06-01 20:30:58',1,'Compiled 06/01/12 20:29:00',1),('2012-06-01 20:41:51',1,'Compiled 06/01/12 20:40:01',1),('2012-07-25 11:47:05',1,'Compiled 07/25/12 11:45:37',1),('2012-07-25 12:02:40',1,'Compiled 07/25/12 12:00:57',1),('2012-07-25 14:10:56',1,'Compiled 07/25/12 14:09:38',1),('2012-07-25 14:32:51',1,'Compiled 07/25/12 14:31:39',1),('2012-07-25 14:45:30',1,'Compiled 07/25/12 14:44:26',1),('2012-07-25 15:35:20',1,'Compiled 07/25/12 15:33:51',1),('2012-07-25 16:27:16',1,'Compiled 07/25/12 16:26:05',1),('2012-07-25 17:12:40',1,'Compiled 07/25/12 17:11:34',1),('2012-07-25 17:39:58',1,'Compiled 07/25/12 17:38:50',1),('2012-07-25 18:11:58',1,'Compiled 07/25/12 18:10:53',1),('2012-07-25 18:45:30',1,'Compiled 07/25/12 18:44:25',1),('2012-07-25 19:09:07',1,'Compiled 07/25/12 19:07:51',1),('2012-07-31 11:43:34',1,'Compiled 07/31/12 11:41:19',1),('2012-12-19 15:35:29',1,'Compiled 12/19/12 15:34:17',1),('2012-12-19 16:33:22',11,'lights.txt',1),('2013-03-13 20:07:34',1,'Compiled 03/13/13 15:02:28',1),('2013-09-10 15:21:45',1,'Compiled 03/13/13 15:02:28',1),('2013-12-05 17:19:11',1,'Compiled 03/13/13 15:02:28',1),('2014-10-01 13:57:41',1,'Compiled 03/13/13 15:02:28',1),('2015-04-03 13:56:18',1,'Compiled 03/13/13 15:02:28',0),('2015-04-03 14:19:25',1,'Compiled 03/13/13 15:02:28',0),('2015-04-18 18:12:09',1,'Compiled 03/13/13 15:02:28',0),('2015-04-18 18:22:05',1,'Compiled 03/13/13 15:02:28',0),('2015-04-20 13:55:04',1,'Compiled 03/13/13 15:02:28',0),('2015-04-20 14:22:49',1,'Compiled 03/13/13 15:02:28',0),('2015-04-20 15:59:36',1,'Compiled 03/13/13 15:02:28',0),('2015-04-20 17:10:36',1,'Compiled 03/13/13 15:02:28',0),('2015-05-03 11:58:48',1,'Compiled 03/13/13 15:02:28',0),('2015-07-19 16:07:34',1,'Compiled 03/13/13 15:02:28',1),('2015-11-19 22:19:41',1,'Compiled 03/13/13 15:02:28',1),('2015-12-01 19:12:29',1,'Compiled 03/13/13 15:02:28',1),('2015-12-09 19:21:29',1,'Compiled 03/13/13 15:02:28',1),('2016-02-24 17:33:30',1,'Compiled 02/23/16 17:14:56',1),('2016-02-24 17:49:22',1,'Compiled 02/23/16 17:14:56',1),('2016-02-24 18:03:16',1,'Compiled 02/23/16 17:14:56',1),('2016-02-24 18:26:15',1,'Compiled 02/23/16 17:14:56',1),('2016-02-24 18:49:31',1,'Compiled 02/23/16 17:14:56',1),('2016-02-24 18:57:26',1,'Compiled 02/23/16 17:14:56',1),('2016-11-09 20:16:48',1,'Compiled 02/23/16 17:14:56',1),('2016-12-21 16:36:35',1,'Compiled 02/23/16 17:14:56',1),('2017-03-14 14:33:26',1,'Compiled 02/23/16 17:14:56',1),('2017-05-02 19:38:06',1,'Compiled 02/23/16 17:14:56',1),('2017-05-14 19:34:35',1,'Compiled 02/23/16 17:14:56',1),('2017-05-15 12:41:21',1,'Compiled 02/23/16 17:14:56',1),('2017-05-16 20:28:06',1,'Compiled 02/23/16 17:14:56',1),('2017-09-17 14:34:58',1,'Compiled 02/23/16 17:14:56',1),('2018-02-02 18:04:31',1,'Compiled 02/23/16 17:14:56',1),('2018-02-16 16:25:23',1,'Compiled 02/23/16 17:14:56',1),('2018-02-16 16:37:58',1,'Compiled 02/08/18 14:22:46',1),('2018-02-16 17:40:27',1,'Compiled 02/16/18 11:22:18',1),('2018-07-27 21:36:47',1,'Compiled 02/16/18 11:22:18',1),('2018-09-18 15:03:32',1,'Compiled 02/16/18 11:22:18',1),('2018-09-19 20:01:15',1,'Compiled 02/16/18 11:22:18',1),('2018-10-06 20:16:49',1,'Compiled 02/16/18 11:22:18',1),('2019-02-28 23:07:16',1,'Compiled 02/16/18 11:22:18',1),('2019-03-15 18:43:33',1,'Compiled 02/16/18 11:22:18',1),('2019-03-23 18:51:08',1,'Compiled 02/16/18 11:22:18',1),('2019-05-03 16:01:37',1,'Compiled 02/16/18 11:22:18',1),('2019-05-15 15:13:00',1,'Compiled 02/16/18 11:22:18',1),('2019-09-23 17:26:19',1,'Compiled 02/16/18 11:22:18',1),('2019-11-22 15:03:45',1,'Compiled 02/16/18 11:22:18',1),('2019-11-22 15:17:06',1,'Compiled 02/16/18 11:22:18',1),('2019-12-22 17:10:23',1,'Compiled 02/16/18 11:22:18',1),('2019-12-28 17:21:20',1,'Compiled 02/16/18 11:22:18',1),('2019-12-28 17:25:05',1,'Compiled 02/16/18 11:22:18',0),('2019-12-30 18:43:30',1,'Compiled 02/16/18 11:22:18',1),('2020-02-04 16:44:19',1,'Compiled 02/16/18 11:22:18',1),('2020-05-21 15:53:36',1,'Compiled 02/16/18 11:22:18',1),('2020-08-17 15:00:27',1,'Compiled 02/16/18 11:22:18',1),('2020-08-20 20:21:43',1,'Compiled 02/16/18 11:22:18',1),('2020-08-20 20:33:21',1,'Compiled 02/16/18 11:22:18',1),('2020-09-06 12:01:23',1,'Compiled 02/16/18 11:22:18',1),('2020-09-21 00:01:37',1,'Compiled 02/16/18 11:22:18',1),('2020-09-23 19:48:18',1,'Compiled 02/16/18 11:22:18',1),('2020-09-23 19:51:58',1,'Compiled 02/16/18 11:22:18',0),('2020-10-06 20:01:18',1,'Compiled 02/16/18 11:22:18',1),('2020-10-15 17:39:08',1,'Compiled 02/16/18 11:22:18',1);
/*!40000 ALTER TABLE `alertLog` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `audioAvail`
--

DROP TABLE IF EXISTS `audioAvail`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `audioAvail` (
  `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 `audioAvail`
--

LOCK TABLES `audioAvail` WRITE;
/*!40000 ALTER TABLE `audioAvail` DISABLE KEYS */;
INSERT INTO `audioAvail` VALUES (4,5),(1,5),(5,6),(4,6),(4,8),(1,8),(4,3),(1,3),(5,1),(4,1),(4,2),(1,2),(1,4),(4,4),(1,1),(5,2),(5,3),(5,4),(5,5),(2,6),(5,7),(5,8),(1,6);
/*!40000 ALTER TABLE `audioAvail` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `audioChannel`
--

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

--
-- Dumping data for table `audioChannel`
--

LOCK TABLES `audioChannel` WRITE;
/*!40000 ALTER TABLE `audioChannel` DISABLE KEYS */;
INSERT INTO `audioChannel` VALUES ('RCN',853,'Hit List  ',1,'Music  '),('RCN',854,'Hip Hop and R&B  ',1,'Music  '),('RCN',855,'Mix Tape  ',1,'Music  '),('RCN',856,'Dance and Electronica  ',1,'Music  '),('RCN',857,'Rap  ',1,'Music  '),('RCN',858,'Hip Hop Classics  ',1,'Music  '),('RCN',859,'Throwback Jamz  ',1,'Music  '),('RCN',860,'R&B Classics  ',1,'Music  '),('RCN',861,'R&B Soul  ',1,'Music  '),('RCN',862,'Gospel  ',1,'Music  '),('RCN',863,'Reggae  ',1,'Music  '),('RCN',864,'Classic Rock  ',1,'Music  '),('RCN',865,'Retro Rock  ',1,'Music  '),('RCN',866,'Rock  ',1,'Music  '),('RCN',867,'Metal  ',1,'Music  '),('RCN',868,'Alternative  ',1,'Music  '),('RCN',869,'Classic Alternative  ',1,'Music  '),('RCN',870,'Adult Alternative  ',1,'Music  '),('RCN',871,'Soft Rock  ',1,'Music  '),('RCN',872,'Pop Hits  ',1,'Music  '),('RCN',873,'90s  ',1,'Music  '),('RCN',874,'80s  ',1,'Music  '),('RCN',875,'70s  ',1,'Music  '),('RCN',876,'Solid Gold Oldies  ',1,'Music  '),('RCN',877,'Party Favorites  ',1,'Music  '),('RCN',878,'Stage & Screen  ',1,'Music  '),('RCN',879,'Kidz Only  ',1,'Music  '),('RCN',880,'Toddler Tunes  ',1,'Music  '),('RCN',881,'Todays Country  ',1,'Music  '),('RCN',882,'True Country  ',1,'Music  '),('RCN',883,'Classic Country  ',1,'Music  '),('RCN',884,'Contemporary Christian  ',1,'Music  '),('RCN',885,'Sounds of the Season  ',1,'Music  '),('RCN',886,'Soundscapes  ',1,'Music  '),('RCN',887,'Smooth Jazz  ',1,'Music  '),('RCN',888,'Jazz  ',1,'Music  '),('RCN',889,'Blues  ',1,'Music  '),('RCN',890,'Singers & Swing  ',1,'Music  '),('RCN',891,'Easy Listening  ',1,'Music  '),('RCN',892,'Classical Masterpieces  ',1,'Music  '),('RCN',893,'Light Classical  ',1,'Music  '),('RCN',894,'Musica Urbana  ',1,'Music  '),('RCN',895,'Pop Latino  ',1,'Music  '),('RCN',896,'Tropicales  ',1,'Music  '),('RCN',897,'Mexicana  ',1,'Music  ');
/*!40000 ALTER TABLE `audioChannel` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `audioFav`
--

DROP TABLE IF EXISTS `audioFav`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `audioFav` (
  `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 `audioFav`
--

LOCK TABLES `audioFav` WRITE;
/*!40000 ALTER TABLE `audioFav` DISABLE KEYS */;
INSERT INTO `audioFav` VALUES (4,'RCN',891,'Easy Listening'),(4,'RCN',890,'Singers & Swing'),(4,'RCN',889,'Blues'),(4,'RCN',888,'Jazz'),(4,'RCN',887,'Smooth Jazz'),(4,'RCN',886,'Soundscapes'),(4,'RCN',885,'Sounds of the Season'),(4,'RCN',877,'Party Favorites'),(4,'RCN',871,'Soft Rock'),(4,'RCN',870,'Adult Alternative'),(4,'RCN',892,'Classical Masterpieces'),(4,'RCN',893,'Light Classical');
/*!40000 ALTER TABLE `audioFav` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `audioSrc`
--

DROP TABLE IF EXISTS `audioSrc`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `audioSrc` (
  `index` tinyint(2) NOT NULL,
  `ai` tinyint(4) NOT 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 `audioSrc`
--

LOCK TABLES `audioSrc` WRITE;
/*!40000 ALTER TABLE `audioSrc` DISABLE KEYS */;
INSERT INTO `audioSrc` VALUES (1,1,'iPod Dock','',NULL,0,'iPort',0.0),(2,2,'Lounge Cable','','RCN',0,'Cable TV',0.0),(3,7,'Fitness Cable','','RCN',0,'Cable TV',0.0),(4,4,'BGM Cable','','RCN',0,'Cable Audio',0.0),(5,5,'AirPlay','',NULL,0,'AirPlay',0.0);
/*!40000 ALTER TABLE `audioSrc` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `cameraAxis`
--

DROP TABLE IF EXISTS `cameraAxis`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `cameraAxis` (
  `index` int(11) NOT NULL,
  `IP_addr` varchar(15) NOT NULL,
  `name` varchar(25) NOT NULL,
  `number` int(2) NOT NULL,
  `remote_addr` varchar(32) DEFAULT NULL,
  KEY `index` (`index`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `cameraAxis`
--

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

--
-- Table structure for table `climateZone`
--

DROP TABLE IF EXISTS `climateZone`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `climateZone` (
  `index` tinyint(4) NOT NULL,
  `name` varchar(25) NOT NULL,
  `heat_enable` tinyint(1) NOT NULL,
  `cool_enable` tinyint(1) NOT NULL,
  `humid_enable` tinyint(1) NOT NULL DEFAULT '0'
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `climateZone`
--

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

--
-- Table structure for table `controlSystemLog`
--

DROP TABLE IF EXISTS `controlSystemLog`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `controlSystemLog` (
  `when` datetime NOT NULL,
  `what` varchar(32) NOT NULL
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `controlSystemLog`
--

LOCK TABLES `controlSystemLog` WRITE;
/*!40000 ALTER TABLE `controlSystemLog` DISABLE KEYS */;
/*!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 */;
/*!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 */;
/*!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,'10F');
/*!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 */;
INSERT INTO `keypad` VALUES ('[2:6:15]','Lutron_HW','6+2',NULL),('[2:6:16]','Lutron_HW','6+2','Shade'),('[2:6:17]','Lutron_HW','6+2',NULL),('[2:6:18]','Lutron_HW','6+2',NULL),('[2:6:19]','Lutron_HW','6+2',NULL),('[2:6:20]','Lutron_HW','6+2',NULL),('[2:6:21]','Lutron_HW','6+2',NULL),('[2:6:22]','Lutron_HW','6+2',NULL),('[2:6:23]','Lutron_HW','6+2',NULL),('[2:6:24]','Lutron_HW','6+2',NULL),('[2:6:25]','Lutron_HW','6+2',NULL),('[2:6:26]','Lutron_HW','17+2',NULL),('[2:6:8]','Lutron_HW','6+2',NULL);
/*!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=93 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,3,'[2:1:1:6:3]','Lobby to Mail Room','Dimmer',0,999,999),(2,3,'[2:1:4:2]','Grand Salon Entry','Dimmer',0,999,999),(3,3,'[2:1:3:1]','Concierge Emergency Recessed','Dimmer',0,999,999),(4,3,'[2:1:1:1:2]','Concierge Recessed','Dimmer',0,999,999),(5,3,'[2:1:1:1:3]','Gallery South Recessed','Dimmer',0,999,999),(6,3,'[2:1:1:6:1]','Gallery North Recessed','Dimmer',0,999,999),(7,3,'[2:1:1:1:4]','Gallery Mirror Art Light','Dimmer',0,999,999),(8,3,'[2:1:2:3:1]','Sconces','Dimmer',0,999,999),(9,3,'[2:1:1:6:4]','Mum Art Lights','Dimmer',0,999,999),(10,1,'[2:1:1:2:1]','Bar Recessed Lights','Dimmer',0,999,999),(11,1,'[2:1:1:2:3]','Bar Shelf Lights','Dimmer',0,999,999),(12,1,'[2:1:1:2:2]','Bar Island','Dimmer',0,999,999),(13,2,'[2:1:1:3:1]','Recessed','Dimmer',0,999,999),(14,2,'[2:1:1:3:2]','Chandeliers','Dimmer',0,999,999),(15,2,'[2:1:3:4]','Emergency Recessed','Dimmer',0,999,999),(16,2,'[2:1:1:3:4]','Salon to Dining Arch','Dimmer',0,999,999),(17,2,'[2:1:1:3:3]','Art Light','Dimmer',0,999,999),(18,9,'[2:1:2:3:4]','Cove','Dimmer',0,999,999),(19,9,'[2:1:5:1]','Emergency Pendant','Dimmer',0,999,999),(20,9,'[2:1:1:4:1]','Eastwest Pendants','Dimmer',0,999,999),(21,3,'[2:1:1:4:4]','Gallery Recessed','Dimmer',0,999,999),(22,3,'[2:1:4:3]','Gallery Emergency','Dimmer',0,999,999),(23,1,'[2:1:1:5:4]','Fireplace Wall','Dimmer',0,999,999),(24,1,'[2:1:1:5:1]','Recessed','Dimmer',0,999,999),(25,1,'[2:1:4:4]','Emergency Recessed ','Dimmer',0,999,999),(26,1,'[2:1:1:5:2]','Chandelier','Dimmer',0,999,999),(27,3,'[2:1:2:4:4]','Art Light Concierge','Dimmer',0,999,999),(28,3,'[2:1:1:6:1]','Gallery N Recessed','Dimmer',0,999,999),(29,9,'[2:1:4:1]','Emergency','Dimmer',0,999,999),(30,3,'[2:1:1:6:2]','Gallery North Art Light','Dimmer',0,999,999),(31,6,'[2:1:2:3:3]','Wine Cove','Dimmer',0,999,999),(32,6,'[2:1:1:7:2]','Wine Table Pendants ','Dimmer',0,999,999),(33,6,'[2:1:1:4:2]','Terrace','Dimmer',0,999,999),(34,6,'[2:1:1:7:1]','Wine Cabinet Recessed','Dimmer',0,999,999),(35,6,'[2:1:1:7:3]','Recessed','Dimmer',0,999,999),(36,6,'[2:1:2:2:1]','N Recessed Cans','Dimmer',0,999,999),(37,6,'[2:1:5:3]','Emergency Recessed','Dimmer',0,999,999),(38,6,'[2:1:2:2:2]','Art Lights','Dimmer',0,999,999),(39,6,'[2:1:1:7:4]','Cove South','Dimmer',0,999,999),(40,6,'[2:1:2:3:2]','Wine Cabinet LEDs','Dimmer',0,999,999),(41,6,'[2:1:2:1:4]','Billiards Table Pendant','Dimmer',0,999,999),(42,6,'[2:1:2:2:4]','Cove North','Dimmer',0,999,999),(43,3,'[2:1:2:2:3]','Mail Corridor Recessed','Dimmer',0,999,999),(44,3,'[2:1:1:4:3]','Mail Entry Recessed','Dimmer',0,999,999),(45,3,'[2:1:1:1:1]','Mail Emergency Recessed','Dimmer',0,999,999),(46,8,'[2:1:5:2]','Lobby Recessed','Dimmer',0,999,999),(47,8,'[2:1:2:1:2]','Cabinet Recessed','Dimmer',0,999,999),(48,8,'[2:1:2:1:1]','Recessed','Dimmer',0,999,999),(49,8,'[2:1:5:4]','Emergency Recessed','Dimmer',0,999,999),(50,8,'[2:1:2:1:3]','Step Lights','Dimmer',0,999,999),(51,7,'[2:1:3:3]','Spa Corridor Emergency ','Dimmer',0,999,999),(52,7,'[2:1:1:2:4]','Spa Corridor Recessed','Dimmer',0,999,999),(85,10,'[2:1:8:1:4]','Elevator Lobby Art Light','Dimmer',0,999,999),(53,10,'[2:1:8:1:3]','Lobby Cove','Dimmer',0,999,999),(54,10,'[2:1:9:1]','Lobby Chandelier','Dimmer',0,999,999),(55,10,'[2:1:8:1:1]','Lobby Desk Downlights','Dimmer',0,999,999),(56,10,'[2:1:8:1:2]','Lobby Desk Art Light','Dimmer',0,999,999),(57,10,'[2:1:8:2:2]','Fire Panel Recessed','Dimmer',0,999,999),(58,10,'[2:1:9:3]','Fire Panel Emergency Recessed','Dimmer',0,999,999),(60,1,'[2:4:2:7]','East L Drapery','Shade',1,999,999),(61,1,'[2:4:2:6]','East C Drapery','Shade',1,999,999),(62,1,'[2:4:2:8]','East R Drapery','Shade',1,999,999),(63,1,'[2:4:2:10]','South L Drapery','Shade',1,999,999),(64,1,'[2:4:2:9]','South C Drapery','Shade',1,999,999),(65,1,'[2:4:2:11]','South R Drapery','Shade',1,999,999),(66,1,'[2:4:2:1]','Bar Shade','Shade',1,999,999),(67,8,'[2:4:2:13]','Left Shade','Shade',1,999,999),(68,8,'[2:4:2:14]','Right Shade','Shade',1,999,999),(69,2,'[2:4:2:2]','South L Drapery','Shade',1,999,999),(70,2,'[2:4:2:3]','South R Drapery','Shade',1,999,999),(71,2,'[2:4:2:4]','West L Drapery','Shade',1,999,999),(72,2,'[2:4:2:5]','West R Drapery','Shade',1,999,999),(73,6,'[2:4:2:12]','Drapery Track','Shade',1,999,999),(74,5,'[2:4:2:15]','North Wall E','Shade',1,999,999),(75,5,'[2:4:2:16]','North Wall W','Shade',1,999,999),(76,5,'[2:4:2:17]','East Wall','Shade',1,999,999),(77,5,'[2:4:2:18]','Balcony L','Shade',1,999,999),(78,5,'[2:4:2:19]','Balcony R','Shade',1,999,999),(79,9,'[2:4:2:22]','Mail Room S','Shade',1,999,999),(80,9,'[2:4:2:23]','Mail Room C','Shade',1,999,999),(81,9,'[2:4:2:24]','Mail Room N','Shade',1,999,999),(82,1,'[2:4:2:20]','Kitchen Left Shade','Shade',1,999,999),(83,1,'[2:4:2:21]','Kitchen Right Shade','Shade',1,999,999),(59,10,'[2:1:8:2:1]','Elevator Vestibule Chandelier','Dimmer',0,999,999),(84,10,'[2:1:9:2]','Elevator Lobby Em. Recessed','Dimmer',0,999,999),(86,7,'[2:1:2:4:2]','Spa Corridor Art Lights','Dimmer',0,999,999),(87,3,'[2:1:2:4:3]','Concierge Chandelier','Dimmer',0,999,999),(88,3,'[2:1:2:4:4]','Spa Corridor Recessed','Dimmer',0,999,999),(89,2,'[2:1:2:5:1]','Additional Art Lights','Dimmer',0,999,999),(90,2,'[2:1:2:5:2]','Sconces','Dimmer',0,999,999),(91,8,'[2:1:2:5:4]','Presentation Recessed','Dimmer',0,999,999),(92,1,'[2:1:1:5:3]','Art Lights','Dimmer',0,999,999);
/*!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 ('[2:6:21]',1,'Bright'),('[2:6:18]',1,'Bright'),('[2:6:15]',1,'Bright'),('[2:6:24]',1,'Bright'),('[2:6:18]',2,'Med'),('[2:6:18]',3,'Dim'),('[2:6:18]',4,'Off'),('[2:6:15]',2,'Med'),('[2:6:15]',3,'Dim'),('[2:6:15]',4,'Off'),('[2:6:21]',2,'Med'),('[2:6:21]',3,'Dim'),('[2:6:21]',4,'Off'),('[2:6:24]',2,'Med'),('[2:6:24]',3,'Dim'),('[2:6:24]',4,'Off'),('[2:6:26]',1,'Lobby Day'),('[2:6:26]',2,'Lobby Event'),('[2:6:26]',3,'Lobby Night'),('[2:6:8]',1,'Bright');
/*!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 */;
INSERT INTO `localSrc` VALUES (8,99,0,'SAT/CBL','ScreeningRm Cable'),(8,98,0,'BD','ScreeningRm BluRay'),(8,97,0,'GAME','ScreeningRm PC Plate'),(6,96,3,'','Lounge Cable'),(5,95,3,'','Fitness Room Cable');
/*!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','',0),(2,1,1,'Leave','','F','',0),(3,1,1,'Leave','','F','',0),(4,1,1,'Leave','','F','',0),(5,1,1,'Leave','','F','',0),(6,1,1,'Leave','','F','',0),(7,1,1,'Leave','','F','',0),(8,1,1,'Leave','','F','',0),(9,1,1,'Test2','','F','',0);
/*!40000 ALTER TABLE `mode` ENABLE KEYS */;
UNLOCK TABLES;

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

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

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

LOCK TABLES `modeLog` WRITE;
/*!40000 ALTER TABLE `modeLog` DISABLE KEYS */;
INSERT INTO `modeLog` VALUES ('2012-12-19 13:15:28','mpullin',1,1,'Actions changed'),('2012-12-19 13:50:46','jplatt',9,1,'Renamed: Test1'),('2012-12-19 13:51:15','jplatt',9,1,'Renamed: Test2'),('2015-05-07 15:05:46','mlandis',1,1,'Actions changed');
/*!40000 ALTER TABLE `modeLog` ENABLE KEYS */;
UNLOCK TABLES;

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

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

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

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

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

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

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

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

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

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

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

LOCK TABLES `occupancySensor` WRITE;
/*!40000 ALTER TABLE `occupancySensor` DISABLE KEYS */;
/*!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,'Grand Salon',1,NULL,NULL,50,95,'[2:6:18]','0','[2:6:19]',0,'0 0 0 0 0 0 0 0 0 0',154,263,0,0),(2,1,'Dining Room',1,NULL,NULL,75,95,'[2:6:15]',NULL,'[2:6:16]',0,'0 0 0 0 0 0 0 0 0 0',142,109,0,0),(3,1,'Concierge/Gallery',1,NULL,NULL,75,95,'0','0','0',0,'0 0 0 0 0 0 0 0 0 0',343,139,0,0),(4,1,'Locker Rooms',2,NULL,NULL,50,85,NULL,NULL,NULL,0,'0 0 0 0 0 0 0 0 0 0',610,0,0,0),(5,1,'Fitness Room',3,1,NULL,50,85,NULL,NULL,'[2:6:17]',0,'0 0 0 0 0 0 0 0 0 0',582,258,0,0),(6,1,'Billiards Lounge',4,2,NULL,35,99,'[2:6:21]','0','[2:6:22]',0,'0 0 0 0 0 0 0 0 0 0',427,259,0,0),(7,1,'Nail/Spa',7,NULL,NULL,50,85,'0','0','0',0,'0 0 0 0 0 0 0 0 0 0',519,37,0,0),(8,1,'Screening Room',8,3,NULL,40,100,'[2:6:24]','0','[2:6:25]',0,'0 0 0 0 0 0 0 0 0 0',280,277,0,1),(9,1,'Res Elevator Lobby',NULL,NULL,NULL,50,85,'0','0','0',0,'0 0 0 0 0 0 0 0 0 0',471,132,0,0),(10,1,'G Arrival Lobby ',NULL,NULL,NULL,50,85,'[2:6:26]','0','0',0,'0 0 0 0 0 0 0 0 0 0',250,114,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 */;
/*!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 ('[2:6:16]',1,'Open'),('[2:6:17]',1,'Open'),('[2:6:19]',1,'Open'),('[2:6:20]',1,'Open'),('[2:6:22]',1,'Open'),('[2:6:23]',1,'Open'),('[2:6:25]',1,'Open'),('[2:6:16]',2,'Stop'),('[2:6:16]',3,'Close'),('[2:6:17]',2,'Stop'),('[2:6:17]',3,'Close'),('[2:6:19]',2,'Stop'),('[2:6:19]',3,'Close'),('[2:6:22]',2,'Stop'),('[2:6:22]',3,'Close'),('[2:6:25]',2,'Stop'),('[2:6:25]',3,'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 ('Landmark Club',5,10,10,100,50,25,0,0,'Chicago, IL',41.894132,-87.615460,'60611','AMX','APRIL','216.80.73.171',NULL,3,5,NULL,NULL,NULL,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','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','MXT-1000',0,'Lobby 10 inch',3,'1.2.3.4.5.6.7.8.9.10',1,0,1,0),(2,'10002','NXD-435',0,'Lounge',6,'6',0,0,1,0),(3,'10003','NXD-435',0,'Screening Room',8,'8',0,0,1,0);
/*!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 (5,5),(4,6),(3,8),(2,8),(1,8);
/*!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 ('RCN',1,'Video ON DEMAND  ',1,'Video ON DEMAND  '),('RCN',2,'WBBM (CBS)  ',1,'WBBM (CBS)  '),('RCN',3,'HSN  ',1,'HSN  '),('RCN',4,'WYIN  ',1,'WYIN  '),('RCN',5,'WMAQ 5 (NBC)  ',1,'WMAQ 5 (NBC)  '),('RCN',6,'WCIU 26  ',1,'WCIU 26  '),('RCN',7,'WLS 7 (ABC)  ',1,'WLS 7 (ABC)  '),('RCN',8,'WPWR (UPN, My50)  ',1,'WPWR (UPN, My50)  '),('RCN',9,'WGN  ',1,'WGN  '),('RCN',10,'WJYS 62  ',1,'WJYS 62  '),('RCN',11,'WTTW 11 (PBS)  ',1,'WTTW 11 (PBS)  '),('RCN',12,'WFLD (Fox)  ',1,'WFLD (Fox)  '),('RCN',13,'WCPX  ',1,'WCPX  '),('RCN',14,'WWME  ',1,'WWME  '),('RCN',15,'WXFT 60  ',1,'WXFT 60  '),('RCN',16,'WCHU  ',1,'WCHU  '),('RCN',17,'WGBO 66 (Univision)  ',1,'WGBO 66 (Univision)  '),('RCN',18,'WSNS 44 (Telemundo)  ',1,'WSNS 44 (Telemundo)  '),('RCN',19,'CAN TV19  ',1,'CAN TV19  '),('RCN',20,'WYCC 20 (NCE, Chicago)  ',1,'WYCC 20 (NCE, Chicago)  '),('RCN',21,'CAN TV21  ',1,'CAN TV21  '),('RCN',22,'Me Too (WMEU)  ',1,'Me Too (WMEU)  '),('RCN',23,'MUTV 23  ',1,'MUTV 23  '),('RCN',25,'WCW  ',1,'WCW  '),('RCN',27,'CAN TV27  ',1,'CAN TV27  '),('RCN',34,'RCN TV  ',1,'RCN TV  '),('RCN',35,'WFBT  ',1,'WFBT  '),('RCN',36,'CAN TV36  ',1,'CAN TV36  '),('RCN',38,'THIS TV  ',1,'THIS TV  '),('RCN',39,'LATV  ',1,'LATV  '),('RCN',42,'CAN-CALL TV42  ',1,'CAN-CALL TV42  '),('RCN',49,'MUTV  ',1,'MUTV  '),('RCN',50,'NBC Plus  ',1,'NBC Plus  '),('RCN',51,'Universal Sports  ',1,'Universal Sports  '),('RCN',53,'Ebru TV  ',1,'Ebru TV  '),('RCN',95,'Building Management  ',1,'Building Management  '),('RCN',96,'Lobby Camera System  ',1,'Lobby Camera System  '),('RCN',101,'BET  ',1,'BET  '),('RCN',105,'A&E  ',1,'A&E  '),('RCN',106,'Bravo  ',1,'Bravo  '),('RCN',107,'TBS  ',1,'TBS  '),('RCN',108,'TNT  ',1,'TNT  '),('RCN',109,'USA  ',1,'USA  '),('RCN',110,'Spike TV  ',1,'Spike TV  '),('RCN',111,'FX  ',1,'FX  '),('RCN',112,'SYFY  ',1,'SYFY  '),('RCN',113,'Chiller  ',1,'Chiller  '),('RCN',115,'E!  ',1,'E!  '),('RCN',116,'truTV  ',1,'truTV  '),('RCN',117,'Comedy Central  ',1,'Comedy Central  '),('RCN',120,'Animal Planet  ',1,'Animal Planet  '),('RCN',125,'TVOne  ',1,'TVOne  '),('RCN',126,'BBC America  ',1,'BBC America  '),('RCN',129,'Fox Reality  ',1,'Fox Reality  '),('RCN',130,'LOGO  ',1,'LOGO  '),('RCN',140,'Reelz  ',1,'Reelz  '),('RCN',141,'Fox Movie Channel  ',1,'Fox Movie Channel  '),('RCN',142,'AMC  ',1,'AMC  '),('RCN',143,'Turner Classic Movies  ',1,'Turner Classic Movies  '),('RCN',147,'Encore MoviePlex  ',1,'Encore MoviePlex  '),('RCN',148,'Encore RetroPlex  ',1,'Encore RetroPlex  '),('RCN',149,'Encore IndiePlex  ',1,'Encore IndiePlex  '),('RCN',150,'Encore  ',1,'Encore  '),('RCN',151,'Encore Action  ',1,'Encore Action  '),('RCN',152,'Encore Drama  ',1,'Encore Drama  '),('RCN',153,'Encore Love  ',1,'Encore Love  '),('RCN',154,'Encore Mystery  ',1,'Encore Mystery  '),('RCN',155,'Encore Wam  ',1,'Encore Wam  '),('RCN',156,'Encore Westerns  ',1,'Encore Westerns  '),('RCN',158,'IFC  ',1,'IFC  '),('RCN',159,'Sundance Channel  ',1,'Sundance Channel  '),('RCN',160,'MTV  ',1,'MTV  '),('RCN',161,'MTV2  ',1,'MTV2  '),('RCN',162,'MTV Hits  ',1,'MTV Hits  '),('RCN',163,'MTV Jams  ',1,'MTV Jams  '),('RCN',164,'MTV Tr3s  ',1,'MTV Tr3s  '),('RCN',165,'VH1  ',1,'VH1  '),('RCN',166,'VH1 Classic  ',1,'VH1 Classic  '),('RCN',167,'VH1 Soul  ',1,'VH1 Soul  '),('RCN',170,'CMT  ',1,'CMT  '),('RCN',171,'CMT Pure Country  ',1,'CMT Pure Country  '),('RCN',178,'Fuse  ',1,'Fuse  '),('RCN',190,'QVC  ',1,'QVC  '),('RCN',191,'HSN  ',1,'HSN  '),('RCN',192,'Jewelry TV  ',1,'Jewelry TV  '),('RCN',193,'ShopNBC  ',1,'ShopNBC  '),('RCN',195,'Building Management  ',1,'Building Management  '),('RCN',196,'Lobby Camera System  ',1,'Lobby Camera System  '),('RCN',201,'Lifetime Movie Network  ',1,'Lifetime Movie Network  '),('RCN',202,'Lifetime  ',1,'Lifetime  '),('RCN',204,'Lifetime Real Women  ',1,'Lifetime Real Women  '),('RCN',205,'WE  ',1,'WE  '),('RCN',210,'Oxygen  ',1,'Oxygen  '),('RCN',211,'SOAPnet  ',1,'SOAPnet  '),('RCN',212,'Hallmark Channel  ',1,'Hallmark Channel  '),('RCN',215,'Planet Green  ',1,'Planet Green  '),('RCN',216,'DIY Network  ',1,'DIY Network  '),('RCN',217,'FINE LIVING  ',1,'FINE LIVING  '),('RCN',218,'Style  ',1,'Style  '),('RCN',220,'AmericanLife TV Network  ',1,'AmericanLife TV Network  '),('RCN',221,'TV Land  ',1,'TV Land  '),('RCN',222,'ABC Family  ',1,'ABC Family  '),('RCN',224,'Food Network  ',1,'Food Network  '),('RCN',225,'HGTV  ',1,'HGTV  '),('RCN',230,'Galavision  ',1,'Galavision  '),('RCN',240,'Cartoon Network  ',1,'Cartoon Network  '),('RCN',241,'Nickelodeon  ',1,'Nickelodeon  '),('RCN',245,'TeenNick  ',1,'TeenNick  '),('RCN',246,'Nick Too  ',1,'Nick Too  '),('RCN',247,'Nicktoons  ',1,'Nicktoons  '),('RCN',248,'Nick Jr  ',1,'Nick Jr  '),('RCN',249,'Boomerang  ',1,'Boomerang  '),('RCN',250,'Disney Channel  ',1,'Disney Channel  '),('RCN',251,'Disney West  ',1,'Disney West  '),('RCN',252,'Disney XD  ',1,'Disney XD  '),('RCN',255,'Discovery Kids  ',1,'Discovery Kids  '),('RCN',256,'PBS Sprout  ',1,'PBS Sprout  '),('RCN',257,'Qubo  ',1,'Qubo  '),('RCN',260,'EWTN  ',1,'EWTN  '),('RCN',261,'TBN  ',1,'TBN  '),('RCN',262,'Inspirational  ',1,'Inspirational  '),('RCN',263,'The Word  ',1,'The Word  '),('RCN',301,'C-SPAN  ',1,'C-SPAN  '),('RCN',302,'C-SPAN2  ',1,'C-SPAN2  '),('RCN',303,'C-SPAN3  ',1,'C-SPAN3  '),('RCN',305,'CNN  ',1,'CNN  '),('RCN',306,'CNN Headline News  ',1,'CNN Headline News  '),('RCN',310,'CNBC  ',1,'CNBC  '),('RCN',311,'MSNBC  ',1,'MSNBC  '),('RCN',315,'Fox News Channel  ',1,'Fox News Channel  '),('RCN',316,'Fox Business Network  ',1,'Fox Business Network  '),('RCN',320,'The Weather Channel  ',1,'The Weather Channel  '),('RCN',321,'The AccuWeather Channel  ',1,'The AccuWeather Channel  '),('RCN',322,'ABC News Now  ',1,'ABC News Now  '),('RCN',325,'BLOOMBERG TELEVISION  ',1,'BLOOMBERG TELEVISION  '),('RCN',326,'Current TV  ',1,'Current TV  '),('RCN',330,'NASA TV  ',1,'NASA TV  '),('RCN',331,'Pentagon Channel  ',1,'Pentagon Channel  '),('RCN',333,'Travel Channel  ',1,'Travel Channel  '),('RCN',335,'Discovery Channel  ',1,'Discovery Channel  '),('RCN',336,'Discovery Health  ',1,'Discovery Health  '),('RCN',337,'Investigation Discovery  ',1,'Investigation Discovery  '),('RCN',340,'History  ',1,'History  '),('RCN',341,'History International  ',1,'History International  '),('RCN',345,'TLC  ',1,'TLC  '),('RCN',346,'BIO  ',1,'BIO  '),('RCN',348,'Military Channel  ',1,'Military Channel  '),('RCN',350,'National Geographic Chann',1,'National Geographic Chann'),('RCN',351,'Science Channel  ',1,'Science Channel  '),('RCN',360,'NFL RedZone  ',1,'NFL RedZone  '),('RCN',361,'Fox Sports En Espa?ol  ',1,'Fox Sports En Espa?ol  '),('RCN',362,'Fox Soccer Channel  ',1,'Fox Soccer Channel  '),('RCN',363,'ESPN  ',1,'ESPN  '),('RCN',364,'ESPN2  ',1,'ESPN2  '),('RCN',365,'ESPNEWS  ',1,'ESPNEWS  '),('RCN',366,'ESPN Classic  ',1,'ESPN Classic  '),('RCN',368,'ESPNU  ',1,'ESPNU  '),('RCN',370,'Comcast SportsNet  ',1,'Comcast SportsNet  '),('RCN',371,'Comcast SportsNet Plus  ',1,'Comcast SportsNet Plus  '),('RCN',372,'Big Ten Network  ',1,'Big Ten Network  '),('RCN',373,'Big Ten Network (Alternat',1,'Big Ten Network (Alternat'),('RCN',374,'Big Ten Network (Alternat',1,'Big Ten Network (Alternat'),('RCN',375,'Speed  ',1,'Speed  '),('RCN',380,'CBS College Sports  ',1,'CBS College Sports  '),('RCN',381,'The Golf Channel?  ',1,'The Golf Channel?  '),('RCN',382,'VERSUS  ',1,'VERSUS  '),('RCN',383,'FUEL TV  ',1,'FUEL TV  '),('RCN',384,'G4  ',1,'G4  '),('RCN',385,'GolTV  ',1,'GolTV  '),('RCN',386,'HRTV  ',1,'HRTV  '),('RCN',387,'TVG  ',1,'TVG  '),('RCN',388,'NHL  ',1,'NHL  '),('RCN',389,'NFL Network  ',1,'NFL Network  '),('RCN',390,'Tennis Channel  ',1,'Tennis Channel  '),('RCN',391,'MLB Network  ',1,'MLB Network  '),('RCN',392,'NBA Network  ',1,'NBA Network  '),('RCN',400,'HBO  ',1,'HBO  '),('RCN',401,'HBO Family  ',1,'HBO Family  '),('RCN',402,'HBO 2  ',1,'HBO 2  '),('RCN',403,'HBO Signature  ',1,'HBO Signature  '),('RCN',404,'HBO Zone  ',1,'HBO Zone  '),('RCN',405,'HBO Comedy  ',1,'HBO Comedy  '),('RCN',406,'HBO Latino  ',1,'HBO Latino  '),('RCN',410,'Cinemax  ',1,'Cinemax  '),('RCN',411,'MoreMAX  ',1,'MoreMAX  '),('RCN',412,'ThrillerMAX  ',1,'ThrillerMAX  '),('RCN',413,'ActionMAX  ',1,'ActionMAX  '),('RCN',414,'WMAX  ',1,'WMAX  '),('RCN',415,'@MAX  ',1,'@MAX  '),('RCN',416,'5StarMAX  ',1,'5StarMAX  '),('RCN',417,'OMAX  ',1,'OMAX  '),('RCN',419,'Showtime Family Zone  ',1,'Showtime Family Zone  '),('RCN',420,'Showtime  ',1,'Showtime  '),('RCN',421,'Showtime Too  ',1,'Showtime Too  '),('RCN',422,'Showtime Showcase  ',1,'Showtime Showcase  '),('RCN',423,'Showtime Extreme  ',1,'Showtime Extreme  '),('RCN',424,'Showtime Beyond  ',1,'Showtime Beyond  '),('RCN',425,'TMC  ',1,'TMC  '),('RCN',426,'TMC xtra  ',1,'TMC xtra  '),('RCN',427,'Flix  ',1,'Flix  '),('RCN',428,'Showtime Next  ',1,'Showtime Next  '),('RCN',429,'Showtime Women  ',1,'Showtime Women  '),('RCN',430,'Starz  ',1,'Starz  '),('RCN',431,'Starz Kids & Family  ',1,'Starz Kids & Family  '),('RCN',432,'Starz Edge  ',1,'Starz Edge  '),('RCN',433,'Starz Cinema  ',1,'Starz Cinema  '),('RCN',434,'Starz In Black  ',1,'Starz In Black  '),('RCN',435,'Starz Comedy  ',1,'Starz Comedy  '),('RCN',465,'Ebru TV  ',1,'Ebru TV  '),('RCN',469,'ART America (Arabic)  ',1,'ART America (Arabic)  '),('RCN',476,'ITV  ',1,'ITV  '),('RCN',477,'TV Asia (Hindi)  ',1,'TV Asia (Hindi)  '),('RCN',478,'Zee TV (Hindi)  ',1,'Zee TV (Hindi)  '),('RCN',480,'STAR India Gold  ',1,'STAR India Gold  '),('RCN',481,'STAR India Plus  ',1,'STAR India Plus  '),('RCN',482,'STAR India One  ',1,'STAR India One  '),('RCN',484,'TVPOLONIA (Polish)  ',1,'TVPOLONIA (Polish)  '),('RCN',488,'CCTV 4 (Chinese)  ',1,'CCTV 4 (Chinese)  '),('RCN',490,'New Tang Dynasty  ',1,'New Tang Dynasty  '),('RCN',497,'MBC America (Korean)  ',1,'MBC America (Korean)  '),('RCN',498,'TVK24 (Korean)  ',1,'TVK24 (Korean)  '),('RCN',504,'TV JAPAN (Japanese)  ',1,'TV JAPAN (Japanese)  '),('RCN',507,'RAITALIA (Italian)  ',1,'RAITALIA (Italian)  '),('RCN',515,'TV5MONDE (French)  ',1,'TV5MONDE (French)  '),('RCN',521,'Antenna Satellite (Greek)',1,'Antenna Satellite (Greek)'),('RCN',528,'C1R-Russian  ',1,'C1R-Russian  '),('RCN',529,'RTN (Russian)  ',1,'RTN (Russian)  '),('RCN',535,'Filipino Channel (Filipin',1,'Filipino Channel (Filipin'),('RCN',536,'GMA Pinoy TV (Filipino)  ',1,'GMA Pinoy TV (Filipino)  '),('RCN',537,'GMA Life (Filipino)  ',1,'GMA Life (Filipino)  '),('RCN',538,'MYX (Pan Asian)  ',1,'MYX (Pan Asian)  '),('RCN',540,'RTP International (Portug',1,'RTP International (Portug'),('RCN',541,'TV Globo (Portugese)  ',1,'TV Globo (Portugese)  '),('RCN',549,'Setanta Sports  ',1,'Setanta Sports  '),('RCN',550,'De Pel?cula  ',1,'De Pel?cula  '),('RCN',551,'Cine Mexicano  ',1,'Cine Mexicano  '),('RCN',552,'CineLatino  ',1,'CineLatino  '),('RCN',553,'MTV Tr3s  ',1,'MTV Tr3s  '),('RCN',554,'hTV m?sica  ',1,'hTV m?sica  '),('RCN',555,'Telehit  ',1,'Telehit  '),('RCN',556,'Ritmoson Latino  ',1,'Ritmoson Latino  '),('RCN',557,'LaTele Novela  ',1,'LaTele Novela  '),('RCN',558,'Util?sima  ',1,'Util?sima  '),('RCN',560,'Discovery en Espa?ol  ',1,'Discovery en Espa?ol  '),('RCN',561,'Infinito  ',1,'Infinito  '),('RCN',562,'TVEspa?ola International ',1,'TVEspa?ola International '),('RCN',563,'CNN en Espa?ol  ',1,'CNN en Espa?ol  '),('RCN',564,'DocuTVE  ',1,'DocuTVE  '),('RCN',565,'History en Espa?ol  ',1,'History en Espa?ol  '),('RCN',566,'WGBO 66 (Univision)  ',1,'WGBO 66 (Univision)  '),('RCN',567,'WSNS 44 (Telemundo)  ',1,'WSNS 44 (Telemundo)  '),('RCN',568,'WXFT 60  ',1,'WXFT 60  '),('RCN',569,'Galavision  ',1,'Galavision  '),('RCN',570,'ESPN Deportes  ',1,'ESPN Deportes  '),('RCN',571,'Fox Sports En Espa?ol  ',1,'Fox Sports En Espa?ol  '),('RCN',572,'GolTV  ',1,'GolTV  '),('RCN',573,'AYM  ',1,'AYM  '),('RCN',579,'WCHU  ',1,'WCHU  '),('RCN',580,'WAPA  ',1,'WAPA  '),('RCN',581,'Telemicro Internacional  ',1,'Telemicro Internacional  '),('RCN',582,'Caracol TV  ',1,'Caracol TV  '),('RCN',583,'Ecuavisa  ',1,'Ecuavisa  '),('RCN',584,'Once M?xico  ',1,'Once M?xico  '),('RCN',585,'SUR (Somos Latinoamerica)',1,'SUR (Somos Latinoamerica)'),('RCN',586,'Pop Latino  ',1,'Pop Latino  '),('RCN',587,'Mexicana  ',1,'Mexicana  '),('RCN',588,'Musica Urbana  ',1,'Musica Urbana  '),('RCN',589,'Tropicales  ',1,'Tropicales  '),('RCN',590,'Discovery Familia  ',1,'Discovery Familia  '),('RCN',591,'?Sorpresa!  ',1,'?Sorpresa!  '),('RCN',592,'La Familia Cosmovisi?n  ',1,'La Familia Cosmovisi?n  '),('RCN',593,'Toon Disney (SAP)  ',1,'Toon Disney (SAP)  '),('RCN',594,'Boomerang (SAP)  ',1,'Boomerang (SAP)  '),('RCN',602,'WBBM-HD (CBS)  ',1,'WBBM-HD (CBS)  '),('RCN',605,'WMAQ HD (NBC)  ',1,'WMAQ HD (NBC)  '),('RCN',606,'WCIU HD  ',1,'WCIU HD  '),('RCN',607,'WLS-HD (ABC)  ',1,'WLS-HD (ABC)  '),('RCN',608,'WPWR HD (My50)  ',1,'WPWR HD (My50)  '),('RCN',609,'WGN HD  ',1,'WGN HD  '),('RCN',611,'WTTW HD (PBS)  ',1,'WTTW HD (PBS)  '),('RCN',612,'WFLD HD (Fox)  ',1,'WFLD HD (Fox)  '),('RCN',615,'ION HD  ',1,'ION HD  '),('RCN',620,'A&E HD  ',1,'A&E HD  '),('RCN',621,'Bravo HD  ',1,'Bravo HD  '),('RCN',622,'TBS HD  ',1,'TBS HD  '),('RCN',623,'TNT HD  ',1,'TNT HD  '),('RCN',624,'USA HD  ',1,'USA HD  '),('RCN',626,'FX HD  ',1,'FX HD  '),('RCN',628,'Maverick TV HD  ',1,'Maverick TV HD  '),('RCN',629,'G4 HD  ',1,'G4 HD  '),('RCN',630,'SYFY HD  ',1,'SYFY HD  '),('RCN',631,'Animal Planet HD  ',1,'Animal Planet HD  '),('RCN',633,'Cartoon Network HD  ',1,'Cartoon Network HD  '),('RCN',634,'Palladia HD  ',1,'Palladia HD  '),('RCN',635,'Fuse HD  ',1,'Fuse HD  '),('RCN',636,'Wealth TV HD  ',1,'Wealth TV HD  '),('RCN',637,'E! HD  ',1,'E! HD  '),('RCN',638,'WE HD  ',1,'WE HD  '),('RCN',639,'Lifetime HD  ',1,'Lifetime HD  '),('RCN',640,'Lifetime Movie Network HD',1,'Lifetime Movie Network HD'),('RCN',641,'ABC Family HD  ',1,'ABC Family HD  '),('RCN',642,'Food Network HD  ',1,'Food Network HD  '),('RCN',643,'HGTV HD  ',1,'HGTV HD  '),('RCN',645,'Planet Green HD  ',1,'Planet Green HD  '),('RCN',646,'Style HD  ',1,'Style HD  '),('RCN',647,'Disney Channel HD  ',1,'Disney Channel HD  '),('RCN',648,'Disney XD HD  ',1,'Disney XD HD  '),('RCN',650,'CNN HD  ',1,'CNN HD  '),('RCN',651,'CNBC HD  ',1,'CNBC HD  '),('RCN',653,'Fox News HD  ',1,'Fox News HD  '),('RCN',654,'Fox Business Network HD  ',1,'Fox Business Network HD  '),('RCN',655,'The Weather Channel HD  ',1,'The Weather Channel HD  '),('RCN',660,'Travel Channel HD  ',1,'Travel Channel HD  '),('RCN',661,'Discovery Channel HD  ',1,'Discovery Channel HD  '),('RCN',662,'History HD  ',1,'History HD  '),('RCN',663,'TLC HD  ',1,'TLC HD  '),('RCN',664,'BIO HD  ',1,'BIO HD  '),('RCN',665,'Crime & Investigation HD ',1,'Crime & Investigation HD '),('RCN',666,'IFC HD  ',1,'IFC HD  '),('RCN',667,'AMC HD  ',1,'AMC HD  '),('RCN',668,'Encore HD  ',1,'Encore HD  '),('RCN',670,'National Geographic Chann',1,'National Geographic Chann'),('RCN',671,'Science Channel HD  ',1,'Science Channel HD  '),('RCN',680,'ESPNU HD  ',1,'ESPNU HD  '),('RCN',681,'ESPN HD  ',1,'ESPN HD  '),('RCN',682,'ESPN2 HD  ',1,'ESPN2 HD  '),('RCN',683,'ESPNEWS HD  ',1,'ESPNEWS HD  '),('RCN',684,'NFL RedZone HD  ',1,'NFL RedZone HD  '),('RCN',685,'Comcast SportsNet HD  ',1,'Comcast SportsNet HD  '),('RCN',686,'Big Ten Network HD  ',1,'Big Ten Network HD  '),('RCN',687,'Big Ten HD (Alternate 1) ',1,'Big Ten HD (Alternate 1) '),('RCN',688,'Big Ten HD (Alternate 2) ',1,'Big Ten HD (Alternate 2) '),('RCN',689,'Speed HD  ',1,'Speed HD  '),('RCN',690,'NFL Network HD  ',1,'NFL Network HD  '),('RCN',691,'VERSUS HD  ',1,'VERSUS HD  '),('RCN',692,'Tennis Channel HD  ',1,'Tennis Channel HD  '),('RCN',693,'NHL HD  ',1,'NHL HD  '),('RCN',694,'GOLF HD  ',1,'GOLF HD  '),('RCN',695,'MLB Network HD  ',1,'MLB Network HD  '),('RCN',696,'Outdoor Channel HD  ',1,'Outdoor Channel HD  '),('RCN',697,'NBA Network HD  ',1,'NBA Network HD  '),('RCN',700,'HBO HD  ',1,'HBO HD  '),('RCN',701,'HBO Family HD  ',1,'HBO Family HD  '),('RCN',702,'HBO 2 HD  ',1,'HBO 2 HD  '),('RCN',703,'HBO Signature HD  ',1,'HBO Signature HD  '),('RCN',704,'HBO Zone HD  ',1,'HBO Zone HD  '),('RCN',705,'HBO Comedy HD  ',1,'HBO Comedy HD  '),('RCN',706,'HBO Latino HD  ',1,'HBO Latino HD  '),('RCN',710,'Cinemax HD  ',1,'Cinemax HD  '),('RCN',711,'Moremax HD  ',1,'Moremax HD  '),('RCN',712,'ThrillerMAX HD  ',1,'ThrillerMAX HD  '),('RCN',713,'Actionmax HD  ',1,'Actionmax HD  '),('RCN',714,'WMAX HD  ',1,'WMAX HD  '),('RCN',715,'@MAX HD  ',1,'@MAX HD  '),('RCN',716,'5StarMAX HD  ',1,'5StarMAX HD  '),('RCN',717,'Outermax HD  ',1,'Outermax HD  '),('RCN',720,'Showtime HD  ',1,'Showtime HD  '),('RCN',721,'Showtime TOO HD  ',1,'Showtime TOO HD  '),('RCN',722,'Showtime Too (West) HD  ',1,'Showtime Too (West) HD  '),('RCN',723,'Showtime Showcase HD  ',1,'Showtime Showcase HD  '),('RCN',724,'Showtime Showcase (West) ',1,'Showtime Showcase (West) '),('RCN',725,'Showtime Extreme HD  ',1,'Showtime Extreme HD  '),('RCN',726,'TMC HD  ',1,'TMC HD  '),('RCN',727,'TMC Xtra HD  ',1,'TMC Xtra HD  '),('RCN',728,'TMC Xtra (West) HD  ',1,'TMC Xtra (West) HD  '),('RCN',730,'Starz HD  ',1,'Starz HD  '),('RCN',731,'Starz Kids HD  ',1,'Starz Kids HD  '),('RCN',732,'Starz Edge HD  ',1,'Starz Edge HD  '),('RCN',733,'Starz Comedy HD  ',1,'Starz Comedy HD  '),('RCN',750,'Discovery HD Theater  ',1,'Discovery HD Theater  '),('RCN',751,'Smithsonian HD  ',1,'Smithsonian HD  '),('RCN',760,'HDNet  ',1,'HDNet  '),('RCN',761,'HDNet Movies  ',1,'HDNet Movies  '),('RCN',762,'MGM HD  ',1,'MGM HD  '),('RCN',763,'Universal HD  ',1,'Universal HD  '),('RCN',765,'Hallmark Movie Channel HD',1,'Hallmark Movie Channel HD'),('RCN',853,'Hit List  ',1,'Hit List  '),('RCN',854,'Hip Hop and R&B  ',1,'Hip Hop and R&B  '),('RCN',855,'Mix Tape  ',1,'Mix Tape  '),('RCN',856,'Dance and Electronica  ',1,'Dance and Electronica  '),('RCN',857,'Rap  ',1,'Rap  '),('RCN',858,'Hip Hop Classics  ',1,'Hip Hop Classics  '),('RCN',859,'Throwback Jamz  ',1,'Throwback Jamz  '),('RCN',860,'R&B Classics  ',1,'R&B Classics  '),('RCN',861,'R&B Soul  ',1,'R&B Soul  '),('RCN',862,'Gospel  ',1,'Gospel  '),('RCN',863,'Reggae  ',1,'Reggae  '),('RCN',864,'Classic Rock  ',1,'Classic Rock  '),('RCN',865,'Retro Rock  ',1,'Retro Rock  '),('RCN',866,'Rock  ',1,'Rock  '),('RCN',867,'Metal  ',1,'Metal  '),('RCN',868,'Alternative  ',1,'Alternative  '),('RCN',869,'Classic Alternative  ',1,'Classic Alternative  '),('RCN',870,'Adult Alternative  ',1,'Adult Alternative  '),('RCN',871,'Soft Rock  ',1,'Soft Rock  '),('RCN',872,'Pop Hits  ',1,'Pop Hits  '),('RCN',873,'90s  ',1,'90s  '),('RCN',874,'80s  ',1,'80s  '),('RCN',875,'70s  ',1,'70s  '),('RCN',876,'Solid Gold Oldies  ',1,'Solid Gold Oldies  '),('RCN',877,'Party Favorites  ',1,'Party Favorites  '),('RCN',878,'Stage & Screen  ',1,'Stage & Screen  '),('RCN',879,'Kidz Only  ',1,'Kidz Only  '),('RCN',880,'Toddler Tunes  ',1,'Toddler Tunes  '),('RCN',881,'Todays Country  ',1,'Todays Country  '),('RCN',882,'True Country  ',1,'True Country  '),('RCN',883,'Classic Country  ',1,'Classic Country  '),('RCN',884,'Contemporary Christian  ',1,'Contemporary Christian  '),('RCN',885,'Sounds of the Season  ',1,'Sounds of the Season  '),('RCN',886,'Soundscapes  ',1,'Soundscapes  '),('RCN',887,'Smooth Jazz  ',1,'Smooth Jazz  '),('RCN',888,'Jazz  ',1,'Jazz  '),('RCN',889,'Blues  ',1,'Blues  '),('RCN',890,'Singers & Swing  ',1,'Singers & Swing  '),('RCN',891,'Easy Listening  ',1,'Easy Listening  '),('RCN',892,'Classical Masterpieces  ',1,'Classical Masterpieces  '),('RCN',893,'Light Classical  ',1,'Light Classical  '),('RCN',894,'Musica Urbana  ',1,'Musica Urbana  '),('RCN',895,'Pop Latino  ',1,'Pop Latino  '),('RCN',896,'Tropicales  ',1,'Tropicales  '),('RCN',897,'Mexicana  ',1,'Mexicana  '),('RCN',910,'HD Pay-Per-View Events  ',1,'HD Pay-Per-View Events  '),('RCN',911,'Pay-Per-View Events & Mov',1,'Pay-Per-View Events & Mov'),('RCN',912,'Pay-Per-View Events & Mov',1,'Pay-Per-View Events & Mov'),('RCN',913,'Pay-Per-View Events & Mov',1,'Pay-Per-View Events & Mov'),('RCN',915,'Penthouse TV (Adult)  ',1,'Penthouse TV (Adult)  '),('RCN',916,'TENClips (Adult)  ',1,'TENClips (Adult)  '),('RCN',917,'TENBlue (Adult)  ',1,'TENBlue (Adult)  '),('RCN',918,'TENBlox (Adult)  ',1,'TENBlox (Adult)  '),('RCN',919,'TEN Real (Adult)  ',1,'TEN Real (Adult)  '),('RCN',920,'Playboy TV (Adult)  ',1,'Playboy TV (Adult)  '),('RCN',921,'Hot Choice (Adult)  ',1,'Hot Choice (Adult)  '),('RCN',941,'MLB Extra Innings/NHL Cen',1,'MLB Extra Innings/NHL Cen'),('RCN',942,'MLB Extra Innings/NHL Cen',1,'MLB Extra Innings/NHL Cen'),('RCN',943,'MLB Extra Innings/NHL Cen',1,'MLB Extra Innings/NHL Cen'),('RCN',944,'MLB Extra Innings/NHL Cen',1,'MLB Extra Innings/NHL Cen'),('RCN',945,'MLB Extra Innings/NHL Cen',1,'MLB Extra Innings/NHL Cen'),('RCN',946,'MLB Extra Innings/NHL Cen',1,'MLB Extra Innings/NHL Cen'),('RCN',947,'MLB Extra Innings/NHL Cen',1,'MLB Extra Innings/NHL Cen'),('RCN',948,'MLB Extra Innings/NHL Cen',1,'MLB Extra Innings/NHL Cen'),('RCN',949,'MLB Extra Innings/NHL Cen',1,'MLB Extra Innings/NHL Cen'),('RCN',950,'MLB Extra Innings/NHL Cen',1,'MLB Extra Innings/NHL Cen'),('RCN',951,'MLB Extra Innings/NHL Cen',1,'MLB Extra Innings/NHL Cen'),('RCN',952,'MLB Extra Innings/NHL Cen',1,'MLB Extra Innings/NHL Cen'),('RCN',953,'MLB Extra Innings/NHL Cen',1,'MLB Extra Innings/NHL Cen'),('RCN',954,'MLB Extra Innings/NHL Cen',1,'MLB Extra Innings/NHL Cen'),('RCN',955,'Sports Games HD (Seasonal',1,'Sports Games HD (Seasonal'),('RCN',980,'NBA League Pass Previews ',1,'NBA League Pass Previews '),('RCN',981,'NBA League Pass 1  ',1,'NBA League Pass 1  '),('RCN',982,'NBA League Pass 2  ',1,'NBA League Pass 2  '),('RCN',983,'NBA League Pass 3  ',1,'NBA League Pass 3  '),('RCN',984,'NBA League Pass 4  ',1,'NBA League Pass 4  '),('RCN',985,'NBA League Pass 5  ',1,'NBA League Pass 5  '),('RCN',986,'NBA League Pass 6  ',1,'NBA League Pass 6  '),('RCN',987,'NBA League Pass 7  ',1,'NBA League Pass 7  '),('RCN',988,'NBA League Pass 8  ',1,'NBA League Pass 8  '),('RCN',989,'NBA League Pass 9  ',1,'NBA League Pass 9  '),('RCN',998,'Help On Demand  ',1,'Help On Demand  ');
/*!40000 ALTER TABLE `videoChannel` ENABLE KEYS */;
UNLOCK TABLES;

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

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

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

LOCK TABLES `videoFav` WRITE;
/*!40000 ALTER TABLE `videoFav` DISABLE KEYS */;
INSERT INTO `videoFav` VALUES (1,'RCN',654,'Fox Business Network HD'),(1,'RCN',651,'CNBC HD'),(1,'RCN',650,'CNN HD'),(1,'RCN',612,'WFLD HD (Fox)'),(1,'RCN',611,'WTTW HD (PBS)'),(1,'RCN',609,'WGN HD'),(1,'RCN',607,'WLS-HD (ABC)'),(1,'RCN',606,'WCIU HD'),(1,'RCN',605,'WMAQ HD (NBC)'),(1,'RCN',602,'WBBM-HD (CBS)'),(4,'RCN',602,'Family & Kids'),(4,'RCN',605,'Family & Kids'),(4,'RCN',607,'Family & Kids'),(4,'RCN',609,'Family & Kids'),(4,'RCN',611,'Family & Kids'),(4,'RCN',612,'Family & Kids'),(4,'RCN',634,'Arts & Entertainment'),(4,'RCN',650,'News & Information'),(4,'RCN',651,'News & Information'),(4,'RCN',654,'News & Information'),(4,'RCN',681,'Sports'),(4,'RCN',682,'Sports'),(5,'RCN',305,'CNN'),(5,'RCN',108,'TNT'),(5,'RCN',9,'WGN'),(5,'RCN',3,'HSN'),(5,'RCN',2,'WBBM (CBS)'),(1,'RCN',681,'ESPN HD'),(1,'RCN',682,'ESPN2 HD'),(5,'RCN',311,'MSNBC'),(5,'RCN',315,'Fox News Channel'),(5,'RCN',363,'ESPN'),(5,'RCN',364,'ESPN2'),(5,'RCN',365,'ESPNEWS'),(5,'RCN',572,'GolTV'),(5,'RCN',681,'ESPN HD');
/*!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,99,NULL,'Cable Box','','RCN',0,'Cable TV',0.0),(2,98,NULL,'Blu-Ray','',NULL,0,'Blu-Ray',0.0),(3,97,NULL,'PC Plate','',NULL,0,'Local Src',0.0),(4,96,2,'Cable Box','','RCN',0,'Cable TV',0.0),(5,95,3,'Cable Box','','RCN',0,'Cable TV',0.0);
/*!40000 ALTER TABLE `videoSrc` ENABLE KEYS */;
UNLOCK TABLES;

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

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

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

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

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

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

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

LOCK TABLES `weather` WRITE;
/*!40000 ALTER TABLE `weather` DISABLE KEYS */;
INSERT INTO `weather` VALUES (1,'Chicago','60611'),(2,'New York','10010'),(3,'Orlando','32801'),(4,'Los Angeles','90210');
/*!40000 ALTER TABLE `weather` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Dumping events for database 'j5479'
--

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

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

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