-- 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 */;
INSERT INTO `event` VALUES (1,'9 PM','T21:00','F','@singleLight`13`45`2~@singleLight`14`45`2~@singleLight`15`45`2~@singleLight`16`45`2~@singleLight`20`0`2~@singleLight`21`45`2~@singleLight`23`45`2'),(2,'11 PM','T23:00','F','@singleLight`13`10`2~@singleLight`14`10`2~@singleLight`15`10`2~@singleLight`16`10`2~@singleLight`20`0`2~@singleLight`21`25`2~@singleLight`22`0`2~@singleLight`23`10`2'),(3,'Midnight','T00:00','F','@singleLight`78`15`2~@singleLight`79`25`2~@singleLight`80`0`2~@singleLight`81`0`2~@singleLight`82`0`2~@singleLight`83`0`2~@singleLight`84`0`2~@singleLight`85`0`2~@singleLight`72`0`2~@singleLight`73`25`2~@singleLight`74`25`2~@singleLight`75`25`2~@singleLight`76`0`2~@singleLight`77`0`2'),(4,'Sunrise','A1+15','F','@singleLight`78`0`2~@singleLight`79`0`2~@singleLight`80`0`2~@singleLight`81`0`2~@singleLight`82`0`2~@singleLight`83`0`2~@singleLight`84`0`2~@singleLight`85`0`2~@singleLight`72`0`2~@singleLight`73`0`2~@singleLight`74`0`2~@singleLight`75`0`2~@singleLight`76`0`2~@singleLight`77`0`2'),(5,'Sunset','A0-15','F','@singleLight`13`100`2~@singleLight`14`100`2~@singleLight`15`100`2~@singleLight`16`100`2~@singleLight`78`80`2~@singleLight`79`80`2~@singleLight`83`100`2~@singleLight`72`80`2~@singleLight`73`70`2~@singleLight`74`80`2~@singleLight`75`100`2~@singleLight`77`100`2~@singleLight`21`65`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 */;
INSERT INTO `keypad` VALUES ('[1:5:13]','Lutron_HW','6+2','Light'),('[1:6:1]','Lutron_HW','6+2','Light'),('[1:5:20]','Lutron_HW','6+2','Light'),('[1:5:21]','Lutron_HW','6+2','Light'),('[1:6:2]','Lutron_HW','6+2','Light'),('[1:6:3]','Lutron_HW','6+2','Light'),('[1:6:6]','Lutron_HW','6+2','Light'),('[1:6:4]','Lutron_HW','6+2','Light'),('[1:6:5]','Lutron_HW','6+2','Light'),('[1:5:15]','Lutron_HW','6+2','Light'),('[1:5:14]','Lutron_HW','6+2','Light'),('[1:5:17]','Lutron_HW','6+2','Light'),('[1:5:18]','Lutron_HW','6+2','Light'),('[1:5:19]','Lutron_HW','6+2','Light'),('[1:5:16]','Lutron_HW','6+2','Light'),('[1:5:27]','Lutron_HW','6+2','Light'),('[1:5:25]','Lutron_HW','6+2','Light'),('[1:5:23]','Lutron_HW','6+2','Light'),('[1:5:28]','Lutron_HW','6+2','Light'),('[1:5:22]','Lutron_HW','6+2','Light'),('[1:5:26]','Lutron_HW','6+2','Light'),('[1:5:29]','Lutron_HW','6+2','Light'),('[1:5:29]','Lutron_HW','6+2','Light'),('[1:5:24]','Lutron_HW','6+2','Light'),('[1:5:1]','Lutron_HW','17+2','Light');
/*!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=88 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,11,'[1:4:2:8:4]','Chandelier','Dimmer',0,196,155),(2,11,'[1:4:2:7:3]','Sink by shower','Dimmer',0,34,154),(3,11,'[1:4:2:7:4]','Sink by toilet','Dimmer',0,366,154),(4,11,'[1:4:2:7:1]','Steam shower','Dimmer',0,38,71),(5,11,'[1:4:2:8:1]','Toilet can','Dimmer',0,368,72),(6,11,'[1:4:2:7:2]','Tub cans','Dimmer',0,201,67),(7,12,'[1:4:2:9:4]','Center cans','Dimmer',0,174,86),(8,12,'[1:4:2:10:2]','Entry cans','Dimmer',0,366,270),(9,12,'[1:4:2:10:1]','Entry chandelier','Dimmer',0,281,269),(10,12,'[1:4:2:9:2]','Entry cove','Dimmer',0,201,267),(11,12,'[1:4:2:9:1]','Fireplace cans','Dimmer',0,114,179),(12,12,'[1:4:2:9:3]','Perimeter cans','Dimmer',0,255,88),(13,20,'[1:4:2:10:3]','Upper foyer cans','Dimmer',0,86,267),(14,20,'[1:4:2:8:3]','Upper foyer sconces','Dimmer',0,170,266),(15,20,'[1:4:2:5:4]','Bed hall cans','Dimmer',0,169,127),(16,20,'[1:4:2:6:2]','Bed hall sconces','Dimmer',0,249,129),(17,21,'[1:4:2:5:2]','Cans','Dimmer',0,183,138),(18,21,'[1:4:2:5:3]','Stairs 1-2','Dimmer',0,275,260),(19,22,'[1:4:2:6:1]','Cans','Dimmer',0,999,999),(20,19,'[1:4:2:12:2]','Foyer cans','Dimmer',0,108,212),(21,19,'[1:4:2:8:2]','Foyer chandelier','Dimmer',0,108,280),(22,19,'[1:4:2:12:1]','Foyer stairs 0-1','Dimmer',0,24,244),(23,19,'[1:4:2:3:1]','Foyer stairs 1-2','Dimmer',0,360,212),(24,19,'[1:4:1:5:2]','Workshop cans','Dimmer',0,360,278),(25,19,'[1:4:1:5:4]','Rear hall cans','Dimmer',0,362,143),(26,3,'[1:4:2:4:4]','Cans','Dimmer',0,203,151),(27,3,'[1:4:2:4:1]','Fireplace sconces','Dimmer',0,321,154),(28,3,'[1:4:2:4:2]','Switched outlets','Dimmer',0,324,37),(29,5,'[1:4:1:11:2]','Chandelier','Dimmer',0,211,91),(30,5,'[1:4:1:7:3]','Cans','Dimmer',0,290,43),(31,5,'[1:4:1:7:1]','Switched outlets','Dimmer',0,134,35),(32,4,'[1:4:1:12:3]','Cans','Dimmer',0,89,131),(33,4,'[1:4:2:1:1]','Fireplace cans','Dimmer',0,219,110),(34,4,'[1:4:2:1:2]','Bookshelves','Dimmer',0,293,178),(35,4,'[1:4:2:1:3]','Switched outlets','Dimmer',0,140,48),(36,15,'[1:4:2:2:2]','Center cans','Dimmer',0,216,210),(37,15,'[1:4:2:2:1]','Fireplace cans','Dimmer',0,135,211),(38,15,'[1:4:2:2:3]','Perimeter cans','Dimmer',0,255,103),(39,15,'[1:4:2:2:4]','Window cans','Dimmer',0,95,96),(40,15,'[1:4:2:3:3]','Floor outlets','Dimmer',0,297,209),(41,15,'[1:4:2:3:2]','Window outlets','Dimmer',0,148,41),(42,19,'[1:4:1:10:3]','Wet bar?','Dimmer',0,198,138),(43,6,'[1:4:1:6:2]','Keeping rm cans','Dimmer',0,200,208),(44,6,'[1:4:1:10:1]','Keeping rm fireplace','Dimmer',0,40,104),(45,6,'[1:4:1:10:2]','Chandelier','Dimmer',0,203,33),(46,7,'[1:4:1:6:3]','Center cans','Dimmer',0,139,142),(47,7,'[1:4:1:9:2]','Sink can','Dimmer',0,203,42),(48,7,'[1:4:1:6:4]','Pendants','Dimmer',0,254,144),(49,7,'[1:4:1:9:1]','Under cabinet ?','Dimmer',0,201,227),(50,5,'[1:4:1:5:1]','Butlers pantry cans','Dimmer',0,233,273),(51,5,'[1:4:1:7:2]','Butlers pantry sconces','Dimmer',0,158,272),(52,5,'[1:4:1:6:1]','Butlers pantry cabinets','Dimmer',0,29,152),(53,8,'[1:4:1:8:1]','Cans','Dimmer',0,142,97),(54,8,'[1:4:1:8:2]','Under cabinets','Dimmer',0,276,212),(55,19,'[1:4:1:9:3]','Screened porch cans','Dimmer',0,367,25),(56,9,'[1:1:1:2:1]','Car area cans','Dimmer',0,250,184),(57,9,'[1:1:1:2:2]','Sport lights','Switch',0,162,183),(58,18,'[1:4:1:2:4]','Foyer cans','Dimmer',0,81,173),(59,18,'[1:4:1:2:3]','Main hall cans','Dimmer',0,208,139),(60,18,'[1:4:1:4:3]','Rear hall cans','Dimmer',0,368,207),(61,18,'[1:4:1:4:2]','Rear cans 0-1','Dimmer',0,367,141),(62,1,'[1:4:1:3:3]','Chandelier','Dimmer',0,194,221),(63,1,'[1:4:1:3:2]','Center cans','Dimmer',0,117,101),(64,1,'[1:4:1:3:4]','Fireplace cans','Dimmer',0,201,102),(65,14,'[1:4:1:1:2]','Center cans','Dimmer',0,216,106),(66,14,'[1:4:1:1:1]','Fireplace cans','Dimmer',0,131,227),(67,16,'[1:4:1:2:1]','Wet bar center cans','Dimmer',0,46,178),(68,16,'[1:4:1:2:2]','Wet bar outer cans','Dimmer',0,124,177),(69,16,'[1:4:1:4:1]','Wine rm pendant','Dimmer',0,158,32),(70,16,'[1:4:1:4:4]','Cans','Dimmer',0,286,172),(71,2,'[1:4:1:1:3]','Cans','Dimmer',0,207,77),(72,13,'[1:4:1:11:1]','Front porch cans','Dimmer',0,82,126),(73,13,'[1:4:2:4:3]','Front porch sconces','Dimmer',0,168,125),(74,13,'[1:4:1:5:3]','Service entry cans','Dimmer',0,248,125),(75,13,'[1:1:1:2:3]','Garage coach lts','Dimmer',0,369,42),(76,13,'[1:1:1:2:4]','Garage flood lts','Dimmer',0,366,114),(77,13,'[1:1:1:1:2]','Front landscape','Dimmer',0,164,263),(78,10,'[1:4:1:9:4]','Rear porch cans','Dimmer',0,193,108),(79,10,'[1:4:1:7:4]','Rear garage coach lt','Dimmer',0,391,147),(80,10,'[1:4:1:12:4]','Cigar porch sconces','Dimmer',0,25,211),(81,10,'[1:4:2:5:1]','Deck sconces','Dimmer',0,373,210),(82,10,'[1:4:2:10:4]','Master balcony cans','Dimmer',0,54,110),(83,10,'[1:1:1:1:3]','Rear landscape','Dimmer',0,197,25),(84,10,'[1:1:1:1:1]','Rear ice rink','Dimmer',0,303,25),(85,10,'[1:1:1:1:4]','Rear flood lts','Dimmer',0,84,25),(86,17,'[1:4:1:3:1]','Cans','Dimmer',0,207,143),(87,26,'[1:4:1:9:3]','Screen Porch Cans','Dimmer',0,209,90);
/*!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:5:13]',4,'Great Rm'),('[1:6:1]',1,'Bright'),('[1:5:20]',1,'Front Exterior'),('[1:5:21]',1,'Rear Exterior'),('[1:6:3]',1,'Master Bed'),('[1:6:6]',1,'Foyer/Hallway'),('[1:6:4]',1,'Reading'),('[1:6:5]',1,'Study'),('[1:5:15]',1,'Biliards'),('[1:5:17]',1,'Family room'),('[1:5:18]',1,'Bright'),('[1:5:19]',1,'Pinball/Bar'),('[1:5:16]',1,'Exercise'),('[1:5:27]',1,'Library'),('[1:5:25]',6,'Outlets'),('[1:5:23]',1,'Living/Foyer/Dining'),('[1:5:28]',1,'Living Room'),('[1:5:22]',1,'Dining Room'),('[1:5:26]',1,'Kitchen/Keeping'),('[1:5:29]',2,'Hallway'),('[1:5:29]',1,'Office'),('[1:5:24]',5,'Butler/Workshop'),('[1:6:2]',6,'Lights Off'),('[1:6:2]',4,'Night Light'),('[1:6:2]',3,'Vanity'),('[1:6:2]',2,'Vestibule'),('[1:6:2]',1,'Master Bath'),('[1:6:3]',2,'Master Bath'),('[1:6:3]',3,'Vestibule'),('[1:6:3]',4,'Bed Off'),('[1:6:3]',5,'Suite On'),('[1:6:3]',6,'Suite Off'),('[1:6:4]',2,'Study'),('[1:6:4]',3,'Deck'),('[1:6:4]',4,'Stairs 1-2'),('[1:6:4]',5,'Hallway'),('[1:5:15]',2,'Foyer'),('[1:5:15]',3,'Family room'),('[1:5:15]',4,'Wet bar'),('[1:5:15]',5,'Lights Off'),('[1:5:17]',2,'TV'),('[1:5:17]',3,'Wet bar'),('[1:5:17]',4,'Foyer'),('[1:5:17]',5,'Lights Off'),('[1:5:16]',2,'Hallway'),('[1:5:16]',3,'To kitchen'),('[1:5:16]',4,'To master bed'),('[1:5:16]',5,'Lights out'),('[1:5:25]',5,'Lights Off'),('[1:5:25]',4,'To kitchen'),('[1:5:25]',3,'Television'),('[1:5:26]',2,'Hallway'),('[1:5:26]',3,'Breakfast'),('[1:5:26]',4,'Kitchen Low'),('[1:5:26]',5,'Area Off'),('[1:5:27]',2,'Foyer'),('[1:5:27]',3,'Cigar Porch'),('[1:5:27]',4,'To kitchen'),('[1:5:27]',5,'Lights Off'),('[1:5:28]',2,'Foyer'),('[1:5:28]',3,'Sconces'),('[1:5:28]',4,'Outlets'),('[1:5:28]',5,'Lights Off'),('[1:5:22]',2,'Dining Low'),('[1:5:22]',3,'Butlers Pantry'),('[1:5:22]',4,'Sconces'),('[1:5:22]',5,'Lights Off'),('[1:5:29]',3,'Kitchen'),('[1:5:29]',4,'Cabinets'),('[1:5:29]',5,'Lights Off'),('[1:5:24]',4,'Exterior'),('[1:5:24]',3,'Stairs'),('[1:5:24]',2,'Flood Lts'),('[1:5:24]',1,'Garage'),('[1:5:19]',2,'Wetbar'),('[1:5:19]',3,'Foyer'),('[1:5:19]',4,'Wine Room'),('[1:5:19]',5,'Area Off'),('[1:5:14]',6,'Basement Off'),('[1:5:14]',5,'Exercise Room'),('[1:5:14]',4,'Playroom'),('[1:5:14]',3,'Billiards'),('[1:5:14]',2,'Family/ Wetbar'),('[1:5:14]',1,'Basement Halls'),('[1:5:18]',2,'Medium'),('[1:5:18]',3,'Dim'),('[1:5:18]',4,'Off'),('[1:5:23]',2,'Library'),('[1:5:23]',3,'Great Room'),('[1:5:23]',4,'Kitch/Keep/Break'),('[1:5:23]',5,'Butler/Workshop'),('[1:5:23]',6,'1st Floor Off'),('[1:5:20]',2,'Flood Lights'),('[1:5:20]',3,'Landscape'),('[1:5:20]',4,'Exterior On'),('[1:5:20]',5,'Exterior Off'),('[1:5:21]',2,'Flood Lights'),('[1:5:21]',3,'Landscape'),('[1:5:21]',4,'Exterior On'),('[1:5:21]',5,'Exterior Off'),('[1:6:6]',2,'Master Suite'),('[1:6:6]',3,'Reading/Study'),('[1:6:6]',4,'2nd Floor Off'),('[1:6:5]',2,'Reading'),('[1:6:5]',3,'Deck'),('[1:6:5]',4,'Stairs 1-2'),('[1:6:5]',5,'Hallway'),('[1:5:13]',3,'Keeping Room Movie'),('[1:5:13]',2,'Breakfast'),('[1:5:13]',1,'Keep/Kit'),('[1:5:24]',6,'1st Floor Off'),('[1:5:25]',2,'Foyer'),('[1:5:25]',1,'Great Room'),('[1:5:1]',4,'Off'),('[1:5:1]',3,'Dim'),('[1:5:1]',2,'Medium'),('[1:5:1]',1,'Bright'),('[1:5:13]',5,'Area 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 */;
INSERT INTO `localSrc` VALUES (12,0,6,'','master bed default'),(12,99,5,'','master bed DVD'),(14,0,3,'CD','bf fam audio'),(14,1,3,'TV','bf fam cable box 1'),(14,97,18,'DVR','bf fam wii'),(14,96,18,'GAME','bf fam xbox'),(14,95,18,'BD','bf fam gameplate'),(14,94,18,'DVD','bf fam bluray'),(14,93,18,'V.AUX','bf fam ps3'),(14,2,3,'TV','bf fam cable box 2'),(14,3,3,'SAT/CBL','bf fam cable 3'),(14,4,3,'SAT/CBL','bf fam appletv'),(14,5,3,'SAT/CBL','bf fam appletv'),(14,6,3,'SAT/CBL','bf fam appletv'),(14,8,3,'SAT/CBL','bf fam great bluray'),(15,0,5,'BD','1f great default'),(15,8,5,'GAME','1f great blu-ray'),(15,98,5,'SAT/CBL','1f great VCR'),(15,1,5,'DVD','1f great cablebox 1'),(15,2,5,'DVD','1f great cablebox 2');
/*!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','@singleLight`62`0`4~@singleLight`63`0`4~@singleLight`64`0`4~@audioSrc`1`0',0),(2,1,1,'Leave','','F','@singleLight`71`0`4~@videoSrc`2`0~@audioSrc`2`0',0),(8,1,1,'Leave','','F','@singleLight`53`0`2~@singleLight`54`0`2~@videoSrc`8`0~@audioSrc`8`0',0),(14,1,1,'Leave','','F','@singleLight`65`0`4~@singleLight`66`0`4~@videoSrc`14`0~@audioSrc`14`0',0),(3,1,1,'Leave','','F','@singleLight`26`0`4~@singleLight`27`0`4~@singleLight`28`0`4~@audioSrc`3`0',0),(4,1,1,'Leave','','F','@singleLight`32`0`4~@singleLight`33`0`4~@singleLight`34`0`4~@singleLight`35`0`4~@videoSrc`4`0~@audioSrc`4`0',0),(5,1,1,'Leave','','F','@singleLight`29`0`4~@singleLight`30`0`4~@singleLight`31`0`4~@singleLight`50`0`4~@singleLight`51`0`4~@singleLight`52`0`4~@audioSrc`5`0',0),(6,1,1,'Leave','','F','@singleLight`43`0`4~@singleLight`44`0`4~@singleLight`45`0`4~@videoSrc`6`0~@audioSrc`6`0',0),(7,1,1,'Leave','','F','',0),(9,1,1,'Leave','','F','',0),(10,1,1,'Leave','','F','',0),(15,1,1,'Leave','','F','@singleLight`36`0`2~@singleLight`37`0`2~@singleLight`38`0`2~@singleLight`39`0`2~@singleLight`40`0`2~@singleLight`41`0`2~@videoSrc`15`0~@audioSrc`15`0',0),(11,1,1,'Leave','','F','@singleLight`1`0`2~@singleLight`2`0`2~@singleLight`3`0`2~@singleLight`4`0`2~@singleLight`5`0`2~@singleLight`6`0`2~@audioSrc`11`0',0),(12,1,1,'Leave','','F','@singleLight`7`0`2~@singleLight`8`0`2~@singleLight`9`0`2~@singleLight`10`0`2~@singleLight`11`0`2~@singleLight`12`0`2~@videoSrc`12`0~@audioSrc`12`0',0),(13,1,1,'Leave','','F','',0),(16,1,1,'Leave','','F','@singleLight`70`0`4~@audioSrc`16`0',0),(17,1,1,'Leave','','F','@singleLight`86`0`4',0),(18,1,1,'Leave','','F','@singleLight`58`0`4~@singleLight`59`0`4~@singleLight`60`0`4~@singleLight`61`0`4~@doNothing`0`4~@doNothing`0`4~@doNothing`0`4',0),(19,1,1,'Leave','','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`42`0`2~@singleLight`55`0`2',0),(24,1,1,'Leave','','F','@audioSrc`24`0',0),(23,1,1,'Leave','','F','@audioSrc`23`0',0),(22,1,1,'Leave','','F','@singleLight`19`0`2',0),(21,1,1,'Leave','','F','@singleLight`17`0`2~@singleLight`18`0`2~@audioSrc`21`0',0),(20,1,1,'Leave','','F','@singleLight`13`0`2~@singleLight`14`0`2~@singleLight`15`0`2~@singleLight`16`0`2',0),(1,13,0,'Away','','F','@singleLight`62`0`2~@singleLight`63`0`2~@singleLight`64`0`2~@audioSrc`1`0',1),(2,13,0,'Away','','F','@singleLight`71`0`2~@videoSrc`2`0~@audioSrc`2`0',1),(3,13,0,'Away','','F','@singleLight`26`0`2~@singleLight`27`0`2~@singleLight`28`0`2~@audioSrc`3`0',1),(4,13,0,'Away','','F','@singleLight`32`0`2~@singleLight`33`0`2~@singleLight`34`0`2~@singleLight`35`0`2~@videoSrc`4`0~@audioSrc`4`0',1),(5,13,0,'Away','','F','@singleLight`29`0`2~@singleLight`30`0`2~@singleLight`31`0`2~@singleLight`50`0`2~@singleLight`51`0`2~@singleLight`52`0`2~@audioSrc`5`0',1),(6,13,0,'Away','','F','@singleLight`43`0`2~@singleLight`44`0`2~@singleLight`45`0`2~@videoSrc`6`0~@audioSrc`6`0',1),(7,13,0,'Away','','F','@singleLight`46`0`2~@singleLight`47`0`2~@singleLight`48`0`2~@singleLight`49`0`2~@audioSrc`7`0',1),(8,13,0,'Away','','F','@singleLight`53`0`2~@singleLight`54`0`2~@videoSrc`8`0~@audioSrc`8`0',1),(9,13,0,'Away','','F','@singleLight`56`0`2~@singleLight`57`0`0',1),(10,13,0,'Away','','F','@audioSrc`10`0',1),(11,13,0,'Away','','F','@singleLight`1`0`2~@singleLight`2`0`2~@singleLight`3`0`2~@singleLight`4`0`2~@singleLight`5`0`2~@singleLight`6`0`2~@audioSrc`11`0',1),(12,13,0,'Away','','F','@singleLight`7`0`2~@singleLight`8`0`2~@singleLight`9`0`2~@singleLight`10`0`2~@singleLight`11`0`2~@singleLight`12`0`2~@videoSrc`12`0~@audioSrc`12`0',1),(13,13,0,'Away','','F','',1),(14,13,0,'Away','','F','@singleLight`65`0`2~@singleLight`66`0`2~@videoSrc`14`0~@audioSrc`14`0',1),(15,13,0,'Away','','F','@singleLight`36`0`2~@singleLight`37`0`2~@singleLight`38`0`2~@singleLight`39`0`2~@singleLight`40`0`2~@singleLight`41`0`2~@videoSrc`15`0~@audioSrc`15`0',1),(16,13,0,'Away','','F','@singleLight`67`0`2~@singleLight`68`0`2~@singleLight`69`0`2~@singleLight`70`0`2~@audioSrc`16`0',1),(17,13,0,'Away','','F','@singleLight`86`0`2',1),(18,13,0,'Away','','F','@singleLight`58`0`2~@singleLight`59`0`2~@singleLight`60`0`2~@singleLight`61`0`2',1),(19,13,0,'Away','','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`42`0`2~@singleLight`55`0`2',1),(20,13,0,'Away','','F','@singleLight`13`0`2~@singleLight`14`0`2~@singleLight`15`0`2~@singleLight`16`0`2',1),(21,13,0,'Away','','F','@singleLight`17`0`2~@singleLight`18`0`2~@audioSrc`21`0',1),(22,13,0,'Away','','F','@singleLight`19`0`2',1),(23,13,0,'Away','','F','@audioSrc`23`0',1),(24,13,0,'Away','','F','@audioSrc`24`0',1),(24,10,0,'Basement Off','','F','',0),(22,10,0,'Basement Off','','F','',0),(20,10,0,'Basement Off','','F','',0),(17,10,0,'Basement Off','','F','@singleLight`86`0`2',0),(18,10,0,'Basement Off','','F','@singleLight`58`0`2~@singleLight`59`0`2~@singleLight`60`0`2~@singleLight`61`0`2',0),(15,10,0,'Basement Off','','F','',0),(13,10,0,'Basement Off','','F','',0),(11,10,0,'Basement Off','','F','',0),(9,10,0,'Basement Off','','F','',0),(5,10,0,'Basement Off','','F','',0),(6,10,0,'Basement Off','','F','',0),(7,10,0,'Basement Off','','F','',0),(2,10,0,'Basement Off','','F','@singleLight`71`0`2~@videoSrc`2`0~@audioSrc`2`0',0),(3,10,0,'Basement Off','','F','',0),(26,9,0,'Floods Off','','F','',0),(23,9,0,'Floods Off','','F','',0),(24,9,0,'Floods Off','','F','',0),(21,9,0,'Floods Off','','F','',0),(18,9,0,'Floods Off','','F','',0),(19,9,0,'Floods Off','','F','',0),(4,9,0,'Floods Off','','F','',0),(1,9,0,'Floods Off','','F','',0),(2,9,0,'Floods Off','','F','',0),(3,9,0,'Floods Off','','F','',0),(10,9,0,'Floods Off','','F','@singleLight`84`0`2~@singleLight`85`0`2',0),(9,9,0,'Floods Off','','F','',0),(14,9,0,'Floods Off','','F','',0),(11,9,0,'Floods Off','','F','',0),(12,9,0,'Floods Off','','F','',0),(13,9,0,'Floods Off','','F','@singleLight`76`0`2',0),(1,6,0,'Daytime','','F','',1),(2,6,0,'Daytime','','F','',1),(3,6,0,'Daytime','','F','',1),(4,6,0,'Daytime','','F','',1),(5,6,0,'Daytime','','F','',1),(6,6,0,'Daytime','','F','@singleLight`43`100`2~@singleLight`44`100`2~@singleLight`45`100`2',1),(7,6,0,'Daytime','','F','@singleLight`46`100`2~@singleLight`47`100`2~@singleLight`48`100`2~@singleLight`49`0`2',1),(8,6,0,'Daytime','','F','',1),(9,6,0,'Daytime','','F','',1),(10,6,0,'Daytime','','F','@singleLight`78`0`2~@singleLight`79`0`2~@singleLight`80`0`2~@singleLight`81`0`2~@singleLight`82`0`2~@singleLight`83`0`2~@singleLight`84`0`2~@singleLight`85`0`2',1),(11,6,0,'Daytime','','F','',1),(12,6,0,'Daytime','','F','@singleLight`7`0`2~@singleLight`8`75`2~@singleLight`9`75`2~@singleLight`10`0`2~@singleLight`11`0`2~@singleLight`12`0`2',1),(13,6,0,'Daytime','','F','@singleLight`72`0`2~@singleLight`73`0`2~@singleLight`74`0`2~@singleLight`75`0`2~@singleLight`76`0`2~@singleLight`77`0`2',1),(14,6,0,'Daytime','','F','',1),(15,6,0,'Daytime','','F','',1),(16,6,0,'Daytime','','F','',1),(17,6,0,'Daytime','','F','',1),(18,6,0,'Daytime','','F','',1),(19,6,0,'Daytime','','F','@singleLight`20`80`2~@singleLight`21`80`2~@singleLight`22`0`2~@singleLight`23`100`2~@singleLight`24`100`2~@singleLight`25`100`2~@singleLight`42`0`2~@singleLight`55`0`2',1),(20,6,0,'Daytime','','F','@singleLight`13`100`2~@singleLight`14`85`2~@singleLight`15`100`2~@singleLight`16`85`2',1),(21,6,0,'Daytime','','F','@singleLight`17`0`2~@singleLight`18`100`2',1),(22,6,0,'Daytime','','F','',1),(23,6,0,'Daytime','','F','',1),(24,6,0,'Daytime','','F','',1),(1,12,0,'Entertain','','F','@audioSrc`1`1',1),(2,12,0,'Entertain','','F','@changeChannel`1`1`939~@audioSrc`2`1',1),(3,12,0,'Entertain','','F','@audioSrc`3`1',1),(4,12,0,'Entertain','','F','@audioSrc`4`1',1),(5,12,0,'Entertain','','F','@audioSrc`5`1',1),(6,12,0,'Entertain','','F','@audioSrc`6`1',1),(7,12,0,'Entertain','','F','@audioSrc`7`11',1),(8,12,0,'Entertain','','F','@audioSrc`8`1',1),(9,12,0,'Entertain','','F','',1),(10,12,0,'Entertain','','F','@audioSrc`10`0',1),(11,12,0,'Entertain','','F','@audioSrc`11`1',1),(12,12,0,'Entertain','','F','@audioSrc`12`1',1),(13,12,0,'Entertain','','F','',1),(14,12,0,'Entertain','','F','@audioSrc`14`1',1),(15,12,0,'Entertain','','F','@audioSrc`15`1~@changeChannel`1`1`947',1),(16,12,0,'Entertain','','F','@audioSrc`16`1',1),(17,12,0,'Entertain','','F','@changeChannel`1`1`947',1),(18,12,0,'Entertain','','F','',1),(19,12,0,'Entertain','','F','',1),(20,12,0,'Entertain','','F','',1),(21,12,0,'Entertain','','F','@audioSrc`21`1',1),(22,12,0,'Entertain','','F','',1),(23,12,0,'Entertain','','F','@audioSrc`23`1',1),(24,12,0,'Entertain','','F','@audioSrc`24`1',1),(25,12,0,'Entertain','','F','',1),(1,7,0,'Goodnight','','F','@singleLight`62`0`2~@singleLight`63`0`2~@singleLight`64`0`2~@audioSrc`1`0',1),(2,7,0,'Goodnight','','F','@singleLight`71`0`2~@videoSrc`2`0~@audioSrc`2`0',1),(3,7,0,'Goodnight','','F','@singleLight`26`0`2~@singleLight`27`0`2~@singleLight`28`0`2~@audioSrc`3`0',1),(4,7,0,'Goodnight','','F','@singleLight`32`0`2~@singleLight`33`0`2~@singleLight`34`0`2~@singleLight`35`0`2~@videoSrc`4`0~@audioSrc`4`0',1),(5,7,0,'Goodnight','','F','@singleLight`29`0`2~@singleLight`30`0`2~@singleLight`31`0`2~@singleLight`50`0`2~@singleLight`51`0`2~@singleLight`52`0`2~@audioSrc`5`0',1),(6,7,0,'Goodnight','','F','@singleLight`43`0`2~@singleLight`44`0`2~@singleLight`45`0`2~@videoSrc`6`0~@audioSrc`6`0',1),(7,7,0,'Goodnight','','F','@singleLight`46`0`2~@singleLight`47`0`2~@singleLight`48`0`2~@singleLight`49`0`2~@audioSrc`7`0',1),(8,7,0,'Goodnight','','F','@singleLight`53`0`2~@singleLight`54`0`2~@videoSrc`8`0~@audioSrc`8`0',1),(9,7,0,'Goodnight','','F','@singleLight`56`0`2~@singleLight`57`0`0~@audioSrc`9`0',1),(10,7,0,'Goodnight','','F','@audioSrc`10`0',1),(11,7,0,'Goodnight','','F','@singleLight`1`0`2~@singleLight`2`0`2~@singleLight`3`0`2~@singleLight`4`0`2~@singleLight`5`0`2~@singleLight`6`0`2~@audioSrc`11`0',1),(12,7,0,'Goodnight','','F','@singleLight`7`0`2~@singleLight`8`0`2~@singleLight`9`0`2~@singleLight`10`0`2~@singleLight`11`0`2~@singleLight`12`0`2~@videoSrc`12`0~@audioSrc`12`0',1),(13,7,0,'Goodnight','','F','',1),(14,7,0,'Goodnight','','F','@singleLight`65`0`2~@singleLight`66`0`2~@videoSrc`14`0~@audioSrc`14`0',1),(15,7,0,'Goodnight','','F','@singleLight`36`0`2~@singleLight`37`0`2~@singleLight`38`0`2~@singleLight`39`0`2~@singleLight`40`0`2~@singleLight`41`0`2~@videoSrc`15`0~@audioSrc`15`0',1),(16,7,0,'Goodnight','','F','@singleLight`67`0`2~@singleLight`68`0`2~@singleLight`69`0`2~@singleLight`70`0`2~@audioSrc`16`0',1),(17,7,0,'Goodnight','','F','@singleLight`86`0`2',1),(18,7,0,'Goodnight','','F','@singleLight`58`0`2~@singleLight`59`0`2~@singleLight`60`0`2~@singleLight`61`0`2',1),(19,7,0,'Goodnight','','F','@singleLight`20`0`2~@singleLight`21`30`2~@singleLight`22`0`2~@singleLight`23`0`2~@singleLight`24`0`2~@singleLight`25`0`2~@singleLight`42`0`2~@singleLight`55`0`2',1),(20,7,0,'Goodnight','','F','@singleLight`13`20`2~@singleLight`14`0`2~@singleLight`15`20`2~@singleLight`16`0`2',1),(21,7,0,'Goodnight','','F','@singleLight`17`0`2~@singleLight`18`0`2~@audioSrc`21`0',1),(22,7,0,'Goodnight','','F','@singleLight`19`0`2',1),(23,7,0,'Goodnight','','F','@audioSrc`23`0',1),(24,7,0,'Goodnight','','F','@audioSrc`24`0',1),(25,7,0,'Goodnight','','F','',1),(6,2,1,'Watch TV','','F','@singleLight`43`20`2~@singleLight`44`50`2~@singleLight`45`0`2~@videoSrc`6`1',0),(25,10,0,'Basement Off','','F','',0),(23,10,0,'Basement Off','','F','',0),(21,10,0,'Basement Off','','F','',0),(19,10,0,'Basement Off','','F','',0),(16,10,0,'Basement Off','','F','@singleLight`67`0`2~@singleLight`68`0`2~@singleLight`69`0`2~@singleLight`70`0`2~@audioSrc`16`0',0),(14,10,0,'Basement Off','','F','@singleLight`65`0`2~@singleLight`66`0`2~@videoSrc`14`0~@audioSrc`14`0',0),(12,10,0,'Basement Off','','F','',0),(10,10,0,'Basement Off','','F','',0),(8,10,0,'Basement Off','','F','',0),(4,10,0,'Basement Off','','F','',0),(1,10,0,'Basement Off','','F','@singleLight`62`0`2~@singleLight`63`0`2~@singleLight`64`0`2~@audioSrc`1`0',0),(25,9,0,'Floods Off','','F','',0),(22,9,0,'Floods Off','','F','',0),(20,9,0,'Floods Off','','F','',0),(17,9,0,'Floods Off','','F','',0),(16,9,0,'Floods Off','','F','',0),(15,9,0,'Floods Off','','F','',0),(5,9,0,'Floods Off','','F','',0),(6,9,0,'Floods Off','','F','',0),(7,9,0,'Floods Off','','F','',0),(8,9,0,'Floods Off','','F','',0),(1,8,0,'Goodnight Lights Only','','F','@singleLight`62`0`2~@singleLight`63`0`2~@singleLight`64`0`2',1),(2,8,0,'Goodnight Lights Only','','F','@singleLight`71`0`2',1),(3,8,0,'Goodnight Lights Only','','F','@singleLight`26`0`2~@singleLight`27`0`2~@singleLight`28`0`2',1),(4,8,0,'Goodnight Lights Only','','F','@singleLight`32`0`2~@singleLight`33`0`2~@singleLight`34`0`2~@singleLight`35`0`2',1),(5,8,0,'Goodnight Lights Only','','F','@singleLight`29`0`2~@singleLight`30`0`2~@singleLight`31`0`2~@singleLight`50`0`2~@singleLight`51`0`2~@singleLight`52`0`2',1),(6,8,0,'Goodnight Lights Only','','F','@singleLight`43`0`2~@singleLight`44`0`2~@singleLight`45`0`2',1),(7,8,0,'Goodnight Lights Only','','F','@singleLight`46`0`2~@singleLight`47`0`2~@singleLight`48`0`2~@singleLight`49`0`2',1),(8,8,0,'Goodnight Lights Only','','F','@singleLight`53`0`2~@singleLight`54`0`2',1),(9,8,0,'Goodnight Lights Only','','F','@singleLight`56`0`2~@singleLight`57`0`0',1),(10,8,0,'Goodnight Lights Only','','F','',1),(11,8,0,'Goodnight Lights Only','','F','@singleLight`1`0`2~@singleLight`2`0`2~@singleLight`3`0`2~@singleLight`4`0`2~@singleLight`5`0`2~@singleLight`6`0`2',1),(12,8,0,'Goodnight Lights Only','','F','@singleLight`7`0`2~@singleLight`8`0`2~@singleLight`9`0`2~@singleLight`10`0`2~@singleLight`11`0`2~@singleLight`12`0`2',1),(13,8,0,'Goodnight Lights Only','','F','',1),(14,8,0,'Goodnight Lights Only','','F','@singleLight`65`0`2~@singleLight`66`0`2',1),(15,8,0,'Goodnight Lights Only','','F','@singleLight`36`0`2~@singleLight`37`0`2~@singleLight`38`0`2~@singleLight`39`0`2~@singleLight`40`0`2~@singleLight`41`0`2',1),(16,8,0,'Goodnight Lights Only','','F','@singleLight`67`0`2~@singleLight`68`0`2~@singleLight`69`0`2~@singleLight`70`0`2',1),(17,8,0,'Goodnight Lights Only','','F','@singleLight`86`0`2',1),(18,8,0,'Goodnight Lights Only','','F','@singleLight`58`0`2~@singleLight`59`0`2~@singleLight`60`0`2~@singleLight`61`0`2',1),(19,8,0,'Goodnight Lights Only','','F','@singleLight`20`0`2~@singleLight`21`30`2~@singleLight`22`0`2~@singleLight`23`0`2~@singleLight`24`0`2~@singleLight`25`0`2~@singleLight`42`0`2~@singleLight`55`0`2',1),(20,8,0,'Goodnight Lights Only','','F','@singleLight`13`20`2~@singleLight`14`0`2~@singleLight`15`20`2~@singleLight`16`0`2',1),(21,8,0,'Goodnight Lights Only','','F','@singleLight`17`0`2~@singleLight`18`0`2',1),(22,8,0,'Goodnight Lights Only','','F','@singleLight`19`0`2',1),(23,8,0,'Goodnight Lights Only','','F','',1),(24,8,0,'Goodnight Lights Only','','F','',1),(25,8,0,'Goodnight Lights Only','','F','',1),(26,10,0,'Basement Off','','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 ('2011-03-24 15:55:50','mpullin',1,0,'Actions changed'),('2011-03-24 15:56:00','mpullin',1,0,'Renamed: Everything Off'),('2011-03-24 15:56:16','mpullin',1,0,'Renamed: Away'),('2011-03-24 16:17:19','mpullin',1,0,'Actions changed'),('2011-03-25 09:51:12','mpullin',1,0,'Actions changed'),('2011-03-28 10:32:26','smoscinski',1,0,'Actions changed'),('2011-03-28 10:35:36','smoscinski',2,0,'Actions changed'),('2011-03-28 10:41:55','smoscinski',14,0,'Actions changed'),('2011-03-28 10:47:52','smoscinski',16,0,'Actions changed'),('2011-03-28 10:48:21','smoscinski',17,0,'Actions changed'),('2011-03-28 10:49:24','smoscinski',18,0,'Actions changed'),('2011-03-28 11:01:32','smoscinski',3,0,'Actions changed'),('2011-03-28 11:05:30','smoscinski',4,0,'Actions changed'),('2011-03-28 11:11:39','smoscinski',5,0,'Actions changed'),('2011-03-28 12:49:41','smoscinski',6,0,'Actions changed'),('2011-03-28 12:51:57','smoscinski',1,0,'Actions changed'),('2011-04-01 13:52:08','mpullin',1,0,'Renamed: Lights Out'),('2011-04-01 13:53:33','mpullin',1,0,'Actions changed'),('2011-04-01 13:55:49','mpullin',1,0,'Actions changed'),('2011-04-01 13:56:21','mpullin',1,0,'Renamed: Daytime'),('2011-04-04 10:21:15','mpullin',8,0,'Actions changed'),('2011-04-04 10:21:28','mpullin',15,0,'Actions changed'),('2011-04-04 10:21:54','mpullin',19,0,'Actions changed'),('2011-04-04 10:22:06','mpullin',11,0,'Actions changed'),('2011-04-04 10:22:18','mpullin',12,0,'Actions changed'),('2011-04-04 10:22:28','mpullin',20,0,'Actions changed'),('2011-04-04 10:22:38','mpullin',21,0,'Actions changed'),('2011-04-04 10:22:45','mpullin',22,0,'Actions changed'),('2011-04-04 10:22:58','mpullin',23,0,'Actions changed'),('2011-04-04 10:23:04','mpullin',24,0,'Actions changed'),('2011-04-13 13:20:14','smoscinski',1,0,'Actions changed'),('2011-04-13 15:00:59','smoscinski',1,0,'Actions changed'),('2011-04-13 15:13:43','smoscinski',1,0,'Actions changed'),('2011-04-13 15:17:09','smoscinski',1,0,'Actions changed'),('2011-04-22 10:24:54','jplatt',1,0,'Override: 1'),('2011-04-22 10:24:59','jplatt',1,0,'Override: 1'),('2011-04-22 10:25:03','jplatt',1,0,'Override: 1'),('2011-04-22 10:25:09','jplatt',1,0,'Override: 1'),('2011-04-22 10:25:13','jplatt',1,0,'Override: 1'),('2011-04-26 12:01:17','smoscinski',1,0,'Actions changed'),('2011-04-26 12:06:56','[touchpanel]',1,0,'Schedule changed'),('2011-05-02 12:20:43','jplatt',1,0,'Deleted'),('2011-05-02 12:20:55','jplatt',0,0,'Reordered Modes'),('2011-05-02 12:21:07','jplatt',0,0,'Reordered Modes'),('2011-05-02 12:21:31','jplatt',0,0,'Reordered Modes'),('2011-05-02 12:21:55','jplatt',1,0,'Deleted'),('2011-05-02 13:42:12','jnolan',1,0,'Actions changed'),('2011-05-02 14:03:41','jnolan',1,0,'Actions changed'),('2011-05-02 14:04:07','jnolan',0,0,'Reordered Modes'),('2011-05-02 14:04:59','jnolan',0,0,'Reordered Modes'),('2011-05-02 14:06:07','jnolan',1,6,'Override: 1'),('2011-05-02 14:07:31','jnolan',6,2,'Actions changed'),('2011-05-02 14:07:48','jnolan',6,1,'Actions changed'),('2011-05-02 14:10:11','jnolan',1,6,'Override: 1'),('2011-05-02 14:17:55','jnolan',6,2,'Actions changed'),('2011-05-02 14:18:41','jnolan',6,2,'Actions changed'),('2011-05-02 14:19:29','jnolan',6,1,'Actions changed'),('2011-05-02 14:21:44','jnolan',6,2,'Actions changed'),('2011-05-19 22:31:18','jnolan',1,6,'Actions changed'),('2011-05-19 22:39:49','jnolan',1,7,'Actions changed'),('2011-05-19 22:40:29','jnolan',1,11,'Renamed: Goodnight Lights Only'),('2011-05-19 22:41:08','jnolan',1,11,'Deleted'),('2011-05-19 22:41:21','jnolan',1,8,'Renamed: Goodnight Lights Only'),('2011-05-19 22:41:41','jnolan',1,8,'Actions changed'),('2011-05-19 22:43:35','jnolan',1,9,'Actions changed'),('2011-05-19 22:45:32','jnolan',1,10,'Actions changed'),('2011-06-14 10:03:53','ewolfram',1,6,'Actions changed'),('2012-04-10 01:25:22','[touchpanel]',1,7,'Schedule changed'),('2012-06-10 00:03:10','[touchpanel]',1,7,'Schedule changed'),('2014-07-24 14:48:56','[touchpanel]',1,6,'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,'Billiards Room',1,NULL,1,40,100,'[1:5:15]',NULL,NULL,0,'10 20 20 10 0 10 30 20 10 0',127,169,0,0),(2,1,'Exercise Room',2,3,1,40,100,'[1:5:16]',NULL,NULL,0,'0 10 20 30 10 0 10 20 20 10',422,18,0,0),(3,2,'Living Room',3,NULL,3,40,100,'[1:5:28]',NULL,NULL,0,'0 0 0 0 0 0 0 0 0 0',124,272,0,0),(4,2,'Library',4,4,3,50,100,'[1:5:27]',NULL,NULL,0,'-40 -20 0 0 -10 0 20 25 35 45',76,184,0,0),(5,2,'Dining Room',5,NULL,4,50,100,'[1:5:22]',NULL,NULL,0,'0 0 0 0 0 0 0 0 0 0',266,223,0,0),(6,2,'Keeping Room',6,6,4,15,100,'[1:5:13]',NULL,NULL,0,'0 0 0 0 0 0 0 0 0 0',268,115,0,0),(7,2,'Kitchen',7,NULL,4,11,100,'[1:5:26]',NULL,NULL,0,'10 20 20 10 0 10 30 20 10 0',372,86,0,0),(8,2,'Office',8,7,4,10,100,'[1:5:29]',NULL,NULL,0,'0 0 0 0 0 0 0 0 0 0',525,127,0,0),(9,2,'Garage',18,NULL,5,50,100,'[1:5:24]',NULL,NULL,0,'0 0 0 0 0 0 0 0 0 0',669,106,0,0),(10,2,'Back Yard',9,NULL,NULL,50,100,'[1:5:21]',NULL,NULL,0,'0 0 0 0 0 0 0 0 0 0',605,0,0,0),(11,3,'Master Bath',10,NULL,6,10,100,'[1:6:2]',NULL,NULL,0,'0 0 0 0 0 0 0 0 0 0',22,134,0,0),(12,3,'Master Bed',11,8,6,3,100,'[1:6:3]',NULL,NULL,0,'0 0 0 0 0 0 0 0 0 0',129,62,0,0),(13,2,'Front Yard',NULL,NULL,NULL,50,85,'[1:5:20]',NULL,NULL,0,'0 0 0 0 0 0 0 0 0 0',663,308,0,0),(14,1,'Family Room',13,1,1,50,100,'[1:5:17]',NULL,NULL,0,'0 0 0 0 0 0 0 0 0 0',220,50,0,1),(15,2,'Great Room',14,5,3,50,100,'[1:5:25]',NULL,NULL,0,'0 0 0 0 0 0 0 0 0 0',139,32,0,2),(16,1,'Pinball/Bar',1,NULL,1,40,100,'[1:5:19]',NULL,NULL,0,'10 20 20 10 0 10 30 20 10 0',384,118,0,0),(17,1,'Playroom',NULL,NULL,1,50,85,'[1:5:18]',NULL,NULL,0,'0 0 0 0 0 0 0 0 0 0',359,222,0,0),(18,1,'BF Common',NULL,NULL,1,50,85,'[1:5:14]',NULL,NULL,0,'0 0 0 0 0 0 0 0 0 0',222,227,0,0),(19,2,'1F Common',NULL,NULL,2,50,85,'[1:5:23]',NULL,NULL,0,'0 0 0 0 0 0 0 0 0 0',368,214,0,0),(20,3,'2F Common',NULL,NULL,7,50,85,'[1:6:6]',NULL,NULL,0,'0 0 0 0 0 0 0 0 0 0',320,168,0,0),(21,3,'Reading Room',12,NULL,7,50,100,'[1:6:4]',NULL,NULL,0,'0 0 0 0 0 0 0 0 0 0',555,135,0,0),(22,3,'Study',NULL,NULL,7,50,85,'[1:6:5]',NULL,NULL,0,'0 0 0 0 0 0 0 0 0 0',648,135,0,0),(23,3,'His Closet',16,NULL,6,50,100,'[1:6:1]',NULL,NULL,0,'0 0 0 0 0 0 0 0 0 0',39,235,0,0),(24,3,'Her Closet',15,NULL,6,50,100,NULL,NULL,NULL,0,'0 0 0 0 0 0 0 0 0 0',127,237,0,0),(25,3,'Guest Room',NULL,NULL,8,50,85,NULL,NULL,NULL,0,'0 0 0 0 0 0 0 0 0 0',628,292,0,0),(26,2,'Screen Porch',17,2,NULL,50,100,'[1:5:1]','0','0',0,'0 0 0 0 0 0 0 0 0 0',482,38,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,'Garage Entry',1,'',2,490,268),(2,1,'Service Entry',1,'',2,467,320),(3,1,'Dining Room',1,'',2,301,279),(4,1,'Front Entry',1,'',2,230,276),(5,1,'Library Door',1,'',2,46,181),(6,1,'Kitchen Dining Door',1,'',2,369,73),(7,1,'Back Patio Door',1,'',2,490,152),(8,1,'2nd Floor Patio Door',1,'',3,596,134),(9,1,'Master Bed Balcony',1,'',3,129,63),(10,1,'Billiards Window 1',3,'',1,125,178),(11,1,'Billiards Window 2',3,'',1,140,162),(12,1,'Billiards Window 3',3,'',1,156,144),(13,1,'Family Rm Window 1',3,'',1,169,75),(14,1,'Family Rm Window 2',3,'',1,179,53),(15,1,'Family Rm Window 3',3,'',1,194,35),(17,1,'Family Rm Window 5',3,'',1,232,11),(18,1,'Family Rm Window 6',3,'',1,252,20),(19,1,'Family Rm Window 7',3,'',1,307,57),(20,1,'Family Rm Window 8',3,'',1,323,72),(31,1,'Service Entry GB',4,'',2,467,287),(37,1,'Kitchen GB',4,'',2,445,96),(38,1,'Back Patio Door GB',4,'',2,487,179),(16,1,'Family Rm Window 4',3,'',1,211,21),(21,1,'Exercise Rm Window 1',3,'',1,413,45),(22,1,'Exercise Rm Window 2',3,'',1,429,32),(23,1,'Exercise Rm Window 3',3,'',1,443,19),(24,1,'Exercise Rm Window 4',3,'',1,460,19),(25,1,'Exercise Rm Window 5',3,'',1,475,30),(26,1,'Exercise Rm Window 6',3,'',1,490,43),(27,1,'Front Stair 0-1 GB',4,'',1,242,287),(28,1,'Billiards GB',4,'',1,158,181),(29,1,'Family Rm GB',4,'',1,244,64),(30,1,'Exercise Rm GB',4,'',1,454,64),(32,1,'Dining Rm GB',4,'',2,337,236),(33,1,'Living Rm',4,'',2,190,314),(34,1,'Library GB',4,'',2,68,145),(35,1,'Great Rm GB',4,'',2,121,55),(36,1,'Kitchen Dining GB',4,'',2,341,31),(39,1,'Office GB',4,'',2,533,151),(40,1,'Back Stairs 1-2 GB',4,'',3,561,284),(41,1,'2nd Floor Patio GB',4,'',3,599,198),(42,1,'Master Bed GB',4,'',3,111,113);
/*!40000 ALTER TABLE `securityZone` ENABLE KEYS */;
UNLOCK TABLES;

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

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

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

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

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

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

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

LOCK TABLES `system` WRITE;
/*!40000 ALTER TABLE `system` DISABLE KEYS */;
INSERT INTO `system` VALUES ('Nolan Residence',5,10,10,100,50,25,15,0,'Winnetka, IL',42.102900,-87.757100,'60093','AMX','APRIL','j3051.dyndns.org',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,'10021','NXD-435',0,'Exercise Room',2,'2',1,1,1,1),(2,'10022','NXD-435',0,'Family Room',14,'14',1,1,1,1),(3,'10023','NXD-435',0,'Reading Room',21,'21',1,1,1,1),(4,'10024','NXD-435',0,'Rear Hall',9,'9',1,1,1,1),(5,'10025','NXD-435',0,'Keeping Room',6,'6',1,1,1,1),(6,'10026','NXD-435',0,'Great Room',15,'15',1,1,1,1),(7,'10027','NXD-435',0,'Foyer',19,'19',1,1,1,1),(8,'10028','NXD-CV7',0,'Master Bath',11,'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',1,1,1,1),(9,'10029','NXD-435',0,'Billiards',1,'1',1,1,1,1),(10,'10041','MIO-R4',0,'Great Room',15,'6.15',1,1,1,1),(11,'10042','MIO-R4',0,'Keeping Room',6,'6.15',1,1,1,1),(12,'10043','MIO-R4',0,'Office',8,'8',1,1,1,1),(13,'10044','MIO-R4',0,'Library',4,'4',1,1,1,1),(14,'10045','MIO-R4',0,'Master Bed',12,'12',1,1,1,1),(15,'10046','MIO-R4',0,'Exercise Room',2,'2',1,1,1,1),(16,'10030','NXD-435',0,'Library',4,'4',1,1,1,1),(17,'11001','iPad',1,'Kitchen',7,'1.2.3.4.5.6.7.8.9.10.11.12.13.14.15.16.17.18.19.20.21.22.23.24.25.26',1,1,1,1),(18,'11002','iPad',1,'Joe\'s iPad',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',1,1,1,1),(19,'11003','iPad',1,'Janet\'s iPad',8,'1.2.3.4.5.6.7.8.9.10.11.12.13.14.15.16.17.18.19.20.21.22.23.24.25.26',1,1,1,1),(20,'11004','iPad',1,'Master Bed',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',1,1,1,1),(21,'10010','NXD-300',0,'Virtual',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',1,1,1,1),(22,'10047','MIO-R4',0,'Family Room',14,'14',1,1,1,1),(23,'10048','MIO-R4',0,'Porch',26,'26',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 (14,14),(13,14),(10,15),(7,2),(7,4),(7,6),(7,8),(12,14),(6,2),(6,4),(6,6),(6,8),(11,14),(7,15),(5,2),(5,6),(5,8),(8,14),(6,15),(5,4),(7,14),(5,15),(4,2),(4,4),(4,6),(4,8),(6,14),(3,2),(3,4),(3,6),(3,8),(5,14),(4,15),(2,2),(2,4),(2,6),(2,8),(3,15),(2,15),(4,14),(3,14),(2,14),(9,12),(7,12),(6,12),(5,12),(4,12),(3,12),(2,12),(1,2),(1,4),(1,6),(1,8),(1,12),(1,14),(1,15),(7,26),(6,26),(5,26),(4,26),(3,26),(2,26),(1,26),(15,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 ('C-WINNETKA',1,'1',2,'ON DEMAND'),('C-WINNETKA',2,'2',2,'WBBM (CBS)'),('C-WINNETKA',3,'3',2,'WJYS'),('C-WINNETKA',4,'4',2,'WSNS (TEL)'),('C-WINNETKA',5,'5',2,'WMAQ (NBC)'),('C-WINNETKA',6,'6',2,'WGBO (UNI)'),('C-WINNETKA',7,'7',2,'WLS (ABC)'),('C-WINNETKA',8,'8',2,'WPWR (MNT)'),('C-WINNETKA',9,'9',2,'WGN (CW)'),('C-WINNETKA',10,'10',2,'Access'),('C-WINNETKA',11,'11',2,'WTTW (PBS)'),('C-WINNETKA',12,'12',2,'WFLD (FOX)'),('C-WINNETKA',13,'13',2,'WCIU, The U'),('C-WINNETKA',14,'14',2,'QVC'),('C-WINNETKA',15,'15',2,'WCPX (ION)'),('C-WINNETKA',16,'16',2,'ABC Family'),('C-WINNETKA',17,'17',2,'Access'),('C-WINNETKA',18,'18',2,'Access'),('C-WINNETKA',19,'19',2,'Access'),('C-WINNETKA',20,'20',2,'WYCC (PBS)'),('C-WINNETKA',22,'22',2,'WXFT'),('C-WINNETKA',23,'23',2,'FX'),('C-WINNETKA',24,'24',2,'CNBC'),('C-WINNETKA',25,'25',2,'C-WINNETKA Network'),('C-WINNETKA',27,'27',2,'HSN'),('C-WINNETKA',30,'30',2,'Comedy Central'),('C-WINNETKA',31,'31',2,'The Golf Channel'),('C-WINNETKA',32,'32',2,'TBS'),('C-WINNETKA',33,'33',2,'Discovery Channel'),('C-WINNETKA',34,'34',2,'AMC'),('C-WINNETKA',35,'35',2,'The Weather Channel'),('C-WINNETKA',36,'36',2,'Headline News'),('C-WINNETKA',37,'37',2,'C-WINNETKA SportsNet Chicago'),('C-WINNETKA',38,'38',2,'Cartoon Network'),('C-WINNETKA',41,'41',2,'ESPN'),('C-WINNETKA',42,'42',2,'ESPN2'),('C-WINNETKA',43,'43',2,'Spike TV'),('C-WINNETKA',45,'45',2,'MTV'),('C-WINNETKA',46,'46',2,'BET'),('C-WINNETKA',47,'47',2,'Disney Channel'),('C-WINNETKA',48,'48',2,'Nickelodeon'),('C-WINNETKA',49,'49',2,'TLC'),('C-WINNETKA',50,'50',2,'A&E'),('C-WINNETKA',51,'51',2,'USA Network'),('C-WINNETKA',52,'52',2,'TNT'),('C-WINNETKA',53,'53',2,'CLTV'),('C-WINNETKA',54,'54',2,'Fox News Channel'),('C-WINNETKA',55,'55',2,'CNN'),('C-WINNETKA',58,'58',2,'truTV'),('C-WINNETKA',59,'59',2,'VH1'),('C-WINNETKA',60,'60',2,'E!'),('C-WINNETKA',61,'61',2,'Food Network'),('C-WINNETKA',62,'62',2,'Travel Channel'),('C-WINNETKA',64,'64',2,'TV Land'),('C-WINNETKA',65,'65',2,'MSNBC'),('C-WINNETKA',68,'68',2,'Animal Planet'),('C-WINNETKA',69,'69',2,'Lifetime'),('C-WINNETKA',71,'71',2,'Big Ten Network'),('C-WINNETKA',73,'73',2,'Bravo'),('C-WINNETKA',74,'74',2,'History'),('C-WINNETKA',76,'76',2,'VERSUS'),('C-WINNETKA',95,'95',2,'CSPAN'),('C-WINNETKA',96,'96',2,'EWTN'),('C-WINNETKA',99,'99',2,'TV Guide Network'),('C-WINNETKA',100,'100',2,'C-WINNETKA Network 100'),('C-WINNETKA',101,'101',2,'C-WINNETKA Network 101'),('C-WINNETKA',102,'102',2,'Cable Marketplace 2'),('C-WINNETKA',103,'103',2,'Leased Access'),('C-WINNETKA',104,'104',2,'CSPAN 2'),('C-WINNETKA',105,'105',2,'CSPAN 3'),('C-WINNETKA',106,'106',2,'Fox Business Network'),('C-WINNETKA',107,'107',2,'Current'),('C-WINNETKA',108,'108',2,'National Geographic Wild'),('C-WINNETKA',109,'109',2,'SOAPnet'),('C-WINNETKA',110,'110',2,'Cable Marketplace 1'),('C-WINNETKA',113,'113',2,'Cable Marketplace 3'),('C-WINNETKA',116,'116',2,'Weatherscan Local'),('C-WINNETKA',118,'118',2,'Style'),('C-WINNETKA',119,'119',2,'EWTN'),('C-WINNETKA',120,'120',2,'Nick Jr.'),('C-WINNETKA',121,'121',2,'DIY'),('C-WINNETKA',122,'122',2,'Disney XD'),('C-WINNETKA',123,'123',2,'Oxygen'),('C-WINNETKA',124,'124',2,'Cooking Channel'),('C-WINNETKA',126,'126',2,'Nicktoons Network'),('C-WINNETKA',127,'127',2,'PBS Kids Sprout'),('C-WINNETKA',128,'128',2,'Bloomberg'),('C-WINNETKA',130,'130',2,'The HUB'),('C-WINNETKA',131,'131',2,'Hallmark Channel'),('C-WINNETKA',132,'132',2,'Nick Too'),('C-WINNETKA',134,'134',2,'Fuse'),('C-WINNETKA',135,'135',2,'MTV 2'),('C-WINNETKA',136,'136',2,'G4'),('C-WINNETKA',141,'141',2,'Tr3s: MTV, Musica y Mas'),('C-WINNETKA',142,'142',2,'MTV Jams'),('C-WINNETKA',143,'143',2,'LOGO'),('C-WINNETKA',146,'146',2,'CMT'),('C-WINNETKA',149,'149',2,'MoviePlex'),('C-WINNETKA',150,'150',2,'Ovation'),('C-WINNETKA',160,'160',2,'Syfy'),('C-WINNETKA',161,'161',2,'GSN'),('C-WINNETKA',162,'162',2,'BBC America'),('C-WINNETKA',169,'169',2,'NFL Network HD'),('C-WINNETKA',171,'171',2,'AMC HD'),('C-WINNETKA',172,'172',2,'TV One'),('C-WINNETKA',173,'173',2,'ESPN HD'),('C-WINNETKA',174,'174',2,'VERSUS HD'),('C-WINNETKA',175,'175',2,'History HD'),('C-WINNETKA',176,'176',2,'TLC HD'),('C-WINNETKA',177,'177',2,'Syfy HD'),('C-WINNETKA',178,'178',2,'CNBC World'),('C-WINNETKA',179,'179',2,'HGTV HD'),('C-WINNETKA',181,'181',2,'Food Network HD'),('C-WINNETKA',182,'182',2,'WGBO (Univision) HD'),('C-WINNETKA',183,'183',2,'WCIU HD'),('C-WINNETKA',184,'184',2,'WPWR HD'),('C-WINNETKA',185,'185',2,'Showtime HD'),('C-WINNETKA',186,'186',2,'HBO HD'),('C-WINNETKA',187,'187',2,'WLS (ABC) HD'),('C-WINNETKA',188,'188',2,'WMAQ (NBC) HD'),('C-WINNETKA',189,'189',2,'WBBM (CBS) HD'),('C-WINNETKA',190,'190',2,'WFLD (FOX) HD'),('C-WINNETKA',191,'191',2,'WTTW (PBS) HD'),('C-WINNETKA',192,'192',2,'WGN (CW) HD'),('C-WINNETKA',193,'193',2,'WSNS (Telemundo) HD'),('C-WINNETKA',194,'194',2,'WXFT (Telefutura) HD'),('C-WINNETKA',195,'195',2,'Cinemax HD'),('C-WINNETKA',196,'196',2,'Starz HD'),('C-WINNETKA',197,'197',2,'Disney Channel HD'),('C-WINNETKA',198,'198',2,'ABC Family HD'),('C-WINNETKA',199,'199',2,'Golf HD'),('C-WINNETKA',200,'200',2,'C-WINNETKA SportsNet HDTV'),('C-WINNETKA',201,'201',2,'Planet Green'),('C-WINNETKA',202,'202',2,'HGTV'),('C-WINNETKA',203,'203',2,'ESPN2 HD'),('C-WINNETKA',204,'204',2,'TNT in HD'),('C-WINNETKA',205,'205',2,'HD Theater'),('C-WINNETKA',206,'206',2,'National Geographic HD'),('C-WINNETKA',207,'207',2,'Universal HD'),('C-WINNETKA',208,'208',2,'A&E HD'),('C-WINNETKA',209,'209',2,'Palladia HD'),('C-WINNETKA',212,'212',2,'Science Channel HD'),('C-WINNETKA',215,'215',2,'TeenNick'),('C-WINNETKA',216,'216',2,'CNN HD'),('C-WINNETKA',217,'217',2,'ABC 7 Live Well HD'),('C-WINNETKA',218,'218',2,'Discovery HD'),('C-WINNETKA',219,'219',2,'TBS HD'),('C-WINNETKA',220,'220',2,'OWN'),('C-WINNETKA',221,'221',2,'USA HD'),('C-WINNETKA',222,'222',2,'FitTV'),('C-WINNETKA',224,'224',2,'Animal Planet HD'),('C-WINNETKA',225,'225',2,'Nickelodeon HD'),('C-WINNETKA',226,'226',2,'Cartoon Network HD'),('C-WINNETKA',227,'227',2,'Hallmark Movie Channel HD'),('C-WINNETKA',228,'228',2,'Lifetime HD'),('C-WINNETKA',229,'229',2,'Lifetime Movie Network HD'),('C-WINNETKA',230,'230',2,'Trinity Broadcasting'),('C-WINNETKA',231,'231',2,'ESPNews HD'),('C-WINNETKA',232,'232',2,'CBS College Sports Network HD'),('C-WINNETKA',233,'233',2,'MLB Network HD'),('C-WINNETKA',234,'234',2,'NHL Network HD'),('C-WINNETKA',235,'235',2,'NBA TV HD'),('C-WINNETKA',236,'236',2,'Tennis Channel HD'),('C-WINNETKA',237,'237',2,'Speed Channel HD'),('C-WINNETKA',238,'238',2,'WCPX (ION) HD'),('C-WINNETKA',240,'240',2,'WYCC HD'),('C-WINNETKA',253,'253',2,'ESPN U HD'),('C-WINNETKA',254,'254',2,'NFL RedZone HD'),('C-WINNETKA',255,'255',2,'Big Ten Network'),('C-WINNETKA',256,'256',2,'Big Ten Network HD'),('C-WINNETKA',257,'257',2,'Starz Kids & Family HD'),('C-WINNETKA',258,'258',2,'Starz Comedy HD'),('C-WINNETKA',259,'259',2,'Starz Edge HD'),('C-WINNETKA',260,'260',2,'TV Games'),('C-WINNETKA',261,'261',2,'Planet Green HD'),('C-WINNETKA',262,'262',2,'E! HD'),('C-WINNETKA',263,'263',2,'Encore HD'),('C-WINNETKA',264,'264',2,'Fox Business Network HD'),('C-WINNETKA',265,'265',2,'Fox News Channel HD'),('C-WINNETKA',266,'266',2,'CNBC HD'),('C-WINNETKA',267,'267',2,'FX HD'),('C-WINNETKA',268,'268',2,'Gol TV (in English)'),('C-WINNETKA',269,'269',2,'BIO HD'),('C-WINNETKA',270,'270',2,'Weather Channel HD'),('C-WINNETKA',271,'271',2,'Investigation Discovery'),('C-WINNETKA',272,'272',2,'The Science Channel'),('C-WINNETKA',273,'273',2,'National Geographic'),('C-WINNETKA',274,'274',2,'Military Channel'),('C-WINNETKA',275,'275',2,'BIO'),('C-WINNETKA',276,'276',2,'History International'),('C-WINNETKA',278,'278',2,'Bravo HD'),('C-WINNETKA',279,'279',2,'Fuse HD'),('C-WINNETKA',280,'280',2,'IFC HD'),('C-WINNETKA',281,'281',2,'WE HD'),('C-WINNETKA',282,'282',2,'QVC HD'),('C-WINNETKA',283,'283',2,'Disney XD HD'),('C-WINNETKA',284,'284',2,'MGM HD'),('C-WINNETKA',285,'285',2,'C-WINNETKA Info Channel HD'),('C-WINNETKA',287,'287',2,'Style HD'),('C-WINNETKA',288,'288',2,'G4 HD'),('C-WINNETKA',289,'289',2,'TV One HD'),('C-WINNETKA',290,'290',2,'Spike HD'),('C-WINNETKA',291,'291',2,'HD Net'),('C-WINNETKA',293,'293',2,'Travel Channel HD'),('C-WINNETKA',294,'294',2,'Comedy Central HD'),('C-WINNETKA',295,'295',2,'BET HD'),('C-WINNETKA',296,'296',2,'MTV HD'),('C-WINNETKA',297,'297',2,'VH1 HD'),('C-WINNETKA',298,'298',2,'CMT HD'),('C-WINNETKA',299,'299',2,'Gospel Music Channel HD'),('C-WINNETKA',300,'300',2,'HBO 2 HD'),('C-WINNETKA',301,'301',2,'HBO Comedy HD'),('C-WINNETKA',304,'304',2,'HBO Zone HD'),('C-WINNETKA',305,'305',2,'HBO Latino HD'),('C-WINNETKA',307,'307',2,'ActionMax HD'),('C-WINNETKA',308,'308',2,'Showtime Too HD'),('C-WINNETKA',309,'309',2,'Showtime Showcase HD'),('C-WINNETKA',310,'310',2,'Showtime Extreme HD'),('C-WINNETKA',314,'314',2,'The Movie Channel HD'),('C-WINNETKA',316,'316',2,'5StarMax HD'),('C-WINNETKA',317,'317',2,'MSNBC HD'),('C-WINNETKA',318,'318',2,'Headline News HD'),('C-WINNETKA',319,'319',2,'Turner Classic Movies HD'),('C-WINNETKA',320,'320',2,'truTV HD'),('C-WINNETKA',321,'321',2,'Hallmark HD'),('C-WINNETKA',322,'322',2,'HSN HD'),('C-WINNETKA',323,'323',2,'History International HD'),('C-WINNETKA',324,'324',2,'Investigation Discovery HD'),('C-WINNETKA',333,'333',2,'3D Events Channel'),('C-WINNETKA',334,'334',2,'ESPN 3D'),('C-WINNETKA',341,'341',2,'NBC Chicago Nonstop'),('C-WINNETKA',342,'342',2,'Universal Sports (via WMAQ-DT)'),('C-WINNETKA',345,'345',2,'ABC 7 News Now'),('C-WINNETKA',353,'353',2,'Antenna TV (via WGN-DT)'),('C-WINNETKA',357,'357',2,'Me-TV'),('C-WINNETKA',358,'358',2,'Me-TOO'),('C-WINNETKA',359,'359',2,'THIStv'),('C-WINNETKA',360,'360',2,'WFBT (via WCIU-DT)'),('C-WINNETKA',369,'369',2,'WTTW Create'),('C-WINNETKA',370,'370',2,'WTTW Prime'),('C-WINNETKA',372,'372',2,'WYCC World'),('C-WINNETKA',386,'386',2,'MCTV (via WJYS-DT)'),('C-WINNETKA',401,'401',2,'Fox Soccer Channel'),('C-WINNETKA',402,'402',2,'ESPNews'),('C-WINNETKA',403,'403',2,'ESPN Classic'),('C-WINNETKA',404,'404',2,'NHL Network'),('C-WINNETKA',405,'405',2,'ESPNU'),('C-WINNETKA',406,'406',2,'Outdoor Channel'),('C-WINNETKA',407,'407',2,'Horse Racing TV'),('C-WINNETKA',408,'408',2,'Speed Channel'),('C-WINNETKA',410,'410',2,'MLB Network'),('C-WINNETKA',411,'411',2,'NFL RedZone'),('C-WINNETKA',413,'413',2,'FCS Atlantic'),('C-WINNETKA',414,'414',2,'FCS Central'),('C-WINNETKA',415,'415',2,'FCS Pacific'),('C-WINNETKA',416,'416',2,'Sportsman Channel'),('C-WINNETKA',417,'417',2,'Tennis Channel'),('C-WINNETKA',418,'418',2,'CBS College Sports'),('C-WINNETKA',439,'439',2,'NBA TV'),('C-WINNETKA',450,'450',2,'TEAM PPV HD'),('C-WINNETKA',459,'459',2,'GAMEHD2 PPV'),('C-WINNETKA',460,'460',2,'GAMEHD PPV'),('C-WINNETKA',471,'471',2,'CMT Pure Country'),('C-WINNETKA',472,'472',2,'MTV Hits'),('C-WINNETKA',473,'473',2,'VH1 Classic'),('C-WINNETKA',474,'474',2,'VH1 Soul'),('C-WINNETKA',475,'475',2,'GMC'),('C-WINNETKA',481,'481',2,'Centric'),('C-WINNETKA',484,'484',2,'Great American Country'),('C-WINNETKA',485,'485',2,'Daystar Television Network'),('C-WINNETKA',486,'486',2,'The Word Network'),('C-WINNETKA',487,'487',2,'Retirement Living TV'),('C-WINNETKA',501,'501',2,'Turner Classic Movies'),('C-WINNETKA',502,'502',2,'WE'),('C-WINNETKA',503,'503',2,'Independent Film Channel'),('C-WINNETKA',504,'504',2,'Lifetime Movie Network'),('C-WINNETKA',505,'505',2,'Sundance Channel'),('C-WINNETKA',506,'506',2,'Fox Movie Channel'),('C-WINNETKA',507,'507',2,'Reelz Channel'),('C-WINNETKA',508,'508',2,'Hallmark Movie Channel'),('C-WINNETKA',516,'516',2,'Encore Wam'),('C-WINNETKA',517,'517',2,'Encore'),('C-WINNETKA',519,'519',2,'Encore Love'),('C-WINNETKA',521,'521',2,'Encore Mystery'),('C-WINNETKA',523,'523',2,'Encore Western'),('C-WINNETKA',527,'527',2,'Encore Drama'),('C-WINNETKA',528,'528',2,'IndiePlex'),('C-WINNETKA',529,'529',2,'Encore Action'),('C-WINNETKA',533,'533',2,'Starz'),('C-WINNETKA',535,'535',2,'Starz Edge'),('C-WINNETKA',537,'537',2,'Starz in Black'),('C-WINNETKA',538,'538',2,'Starz Cinema'),('C-WINNETKA',539,'539',2,'Starz Kids & Family'),('C-WINNETKA',540,'540',2,'Starz Comedy'),('C-WINNETKA',543,'543',2,'Playboy TV'),('C-WINNETKA',550,'550',2,'HBO East'),('C-WINNETKA',551,'551',2,'HBO West'),('C-WINNETKA',552,'552',2,'HBO 2'),('C-WINNETKA',554,'554',2,'HBO Signature'),('C-WINNETKA',556,'556',2,'HBO Family'),('C-WINNETKA',558,'558',2,'HBO Latino'),('C-WINNETKA',559,'559',2,'HBO Comedy'),('C-WINNETKA',560,'560',2,'HBO Zone'),('C-WINNETKA',561,'561',2,'Cinemax West'),('C-WINNETKA',562,'562',2,'Cinemax East'),('C-WINNETKA',564,'564',2,'MoreMax'),('C-WINNETKA',566,'566',2,'ActionMax'),('C-WINNETKA',567,'567',2,'5StarMax'),('C-WINNETKA',575,'575',2,'Showtime'),('C-WINNETKA',577,'577',2,'Showtime Too'),('C-WINNETKA',579,'579',2,'Showtime Showcase'),('C-WINNETKA',581,'581',2,'Showtime Extreme'),('C-WINNETKA',583,'583',2,'Showtime Next'),('C-WINNETKA',584,'584',2,'Showtime FamilyZone'),('C-WINNETKA',585,'585',2,'Showtime Women'),('C-WINNETKA',586,'586',2,'FLIX'),('C-WINNETKA',590,'590',2,'The Movie Channel'),('C-WINNETKA',592,'592',2,'The Movie Channel Xtra'),('C-WINNETKA',595,'595',2,'Playboy en Espa?ol'),('C-WINNETKA',597,'597',2,'Galavisi?n '),('C-WINNETKA',600,'600',2,'VeneMovies'),('C-WINNETKA',601,'601',2,'Discovery en Espa?ol'),('C-WINNETKA',602,'602',2,'Fox Deportes'),('C-WINNETKA',603,'603',2,'mun2'),('C-WINNETKA',604,'604',2,'CineLatino'),('C-WINNETKA',605,'605',2,'History en Espa?ol'),('C-WINNETKA',606,'606',2,'Tr3s: MTV, Musica y Mas'),('C-WINNETKA',607,'607',2,'Canal 52MX'),('C-WINNETKA',608,'608',2,'CNN en Espa?ol'),('C-WINNETKA',609,'609',2,'ESPN Deportes'),('C-WINNETKA',610,'610',2,'CineMexicano'),('C-WINNETKA',611,'611',2,'Caracol TV Internacional'),('C-WINNETKA',612,'612',2,'Ecuavisa Internacional'),('C-WINNETKA',613,'613',2,'El Garage'),('C-WINNETKA',614,'614',2,'AYM Sports'),('C-WINNETKA',615,'615',2,'HTV Musica'),('C-WINNETKA',616,'616',2,'Mexicanal'),('C-WINNETKA',617,'617',2,'Disney XD'),('C-WINNETKA',618,'618',2,'Multimedios'),('C-WINNETKA',619,'619',2,'Cultural.es'),('C-WINNETKA',620,'620',2,'Gran Cine'),('C-WINNETKA',621,'621',2,'Canal 24 Horas'),('C-WINNETKA',622,'622',2,'Gol TV en Espa?ol'),('C-WINNETKA',623,'623',2,'Infinito'),('C-WINNETKA',624,'624',2,'Video Rola'),('C-WINNETKA',625,'625',2,'TV Venezuela'),('C-WINNETKA',626,'626',2,'La Familia Network'),('C-WINNETKA',627,'627',2,'TeleFormula'),('C-WINNETKA',628,'628',2,'Canal Sur'),('C-WINNETKA',630,'630',2,'TV Colombia'),('C-WINNETKA',631,'631',2,'TV Chile'),('C-WINNETKA',632,'632',2,'Latele Novela'),('C-WINNETKA',633,'633',2,'TBN Enlace USA'),('C-WINNETKA',634,'634',2,'Sorpresa'),('C-WINNETKA',635,'635',2,'S? TV'),('C-WINNETKA',637,'637',2,'EWTN Espanol'),('C-WINNETKA',638,'638',2,'Cable Noticias'),('C-WINNETKA',639,'639',2,'Mexico 22'),('C-WINNETKA',640,'640',2,'TeleRitmo'),('C-WINNETKA',641,'641',2,'Once Mexico'),('C-WINNETKA',642,'642',2,'Mexico TV'),('C-WINNETKA',643,'643',2,'Sur Peru'),('C-WINNETKA',644,'644',2,'TV Dominicana'),('C-WINNETKA',645,'645',2,'Telemicro'),('C-WINNETKA',646,'646',2,'Telefe Internacional'),('C-WINNETKA',647,'647',2,'Utilisima'),('C-WINNETKA',648,'648',2,'CBTV Michoacan'),('C-WINNETKA',650,'650',2,'WAPA America'),('C-WINNETKA',651,'651',2,'TVE Internacional'),('C-WINNETKA',652,'652',2,'TeleHit'),('C-WINNETKA',653,'653',2,'Ritmoson'),('C-WINNETKA',654,'654',2,'Bandamax'),('C-WINNETKA',655,'655',2,'De Pelicula'),('C-WINNETKA',656,'656',2,'De Pelicula Clasico'),('C-WINNETKA',660,'660',2,'STAR India News'),('C-WINNETKA',661,'661',2,'STAR ONE'),('C-WINNETKA',662,'662',2,'STAR India GOLD'),('C-WINNETKA',663,'663',2,'STAR India PLUS'),('C-WINNETKA',664,'664',2,'SET Asia'),('C-WINNETKA',665,'665',2,'TV Asia (South Asian)'),('C-WINNETKA',666,'666',2,'Zee TV (South Asian)'),('C-WINNETKA',668,'668',2,'CTI Zhong Tian (Chinese)'),('C-WINNETKA',669,'669',2,'SBTN (Vietnamese)'),('C-WINNETKA',670,'670',2,'TFC (Filipino)'),('C-WINNETKA',671,'671',2,'CCTV 4 (Chinese)'),('C-WINNETKA',674,'674',2,'TV Japan'),('C-WINNETKA',675,'675',2,'TV Polonia'),('C-WINNETKA',676,'676',2,'TVP INFO'),('C-WINNETKA',677,'677',2,'Radio Jedynka'),('C-WINNETKA',678,'678',2,'Radio Trojka'),('C-WINNETKA',679,'679',2,'Raitalia (Italian)'),('C-WINNETKA',680,'680',2,'RTN (Russian)'),('C-WINNETKA',684,'684',2,'ART (Arabic)'),('C-WINNETKA',688,'688',2,'TV5 Monde (French)'),('C-WINNETKA',829,'829',2,'iN DEMAND PPV HD'),('C-WINNETKA',840,'840',2,'Fresh!'),('C-WINNETKA',841,'841',2,'Spice Xcess'),('C-WINNETKA',842,'842',2,'Playboy TV'),('C-WINNETKA',844,'844',2,'Club Jenna'),('C-WINNETKA',845,'845',2,'Penthouse TV'),('C-WINNETKA',900,'900',2,'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 */;
INSERT INTO `videoFav` VALUES (1,'C-WINNETKA',226,'Cartoon Network HD'),(1,'C-WINNETKA',221,'USA HD'),(1,'C-WINNETKA',216,'CNN HD'),(1,'C-WINNETKA',201,'Planet Green'),(1,'C-WINNETKA',192,'WGN (CW) HD'),(1,'C-WINNETKA',191,'WTTW (PBS) HD'),(1,'C-WINNETKA',190,'WFLD (FOX) HD'),(1,'C-WINNETKA',189,'WBBM (CBS) HD'),(1,'C-WINNETKA',188,'WMAQ (NBC) HD'),(1,'C-WINNETKA',187,'WLS (ABC) HD'),(1,'C-WINNETKA',171,'AMC HD'),(1,'C-WINNETKA',319,'Turner Classic Movies HD'),(3,'C-WINNETKA',2,'WBBM (CBS)'),(3,'C-WINNETKA',5,'WMAQ (NBC)'),(3,'C-WINNETKA',7,'WLS (ABC)'),(2,'C-WINNETKA',2,'WBBM (CBS)'),(2,'C-WINNETKA',7,'WLS (ABC)'),(2,'C-WINNETKA',11,'WTTW (PBS)'),(2,'C-WINNETKA',12,'WFLD (FOX)'),(2,'C-WINNETKA',31,'The Golf Channel'),(2,'C-WINNETKA',33,'Discovery Channel'),(2,'C-WINNETKA',34,'AMC'),(2,'C-WINNETKA',38,'Cartoon Network'),(2,'C-WINNETKA',160,'Syfy'),(2,'C-WINNETKA',169,'NFL Network HD'),(2,'C-WINNETKA',188,'WMAQ (NBC) HD'),(2,'C-WINNETKA',189,'WBBM (CBS) 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,1,11,'Cable Box 1','Cable TV','C-WINNETKA',0,'Cable TV',10.0),(2,2,12,'Cable Box 2','Cable TV','C-WINNETKA',0,'Cable TV',10.0),(3,3,13,'Cable Box 3','Cable TV','C-WINNETKA',0,'Cable TV',10.0),(4,4,7,'Kids AppTV','AppleTV',NULL,0,'AppleTV',0.0),(5,5,5,'Janets AppTV','AppleTV',NULL,0,'AppleTV',0.0),(6,6,6,'Joes AppTV','AppleTV',NULL,0,'AppleTV',0.0),(7,8,15,'Grt Rm BluRy','',NULL,1,'Blu-Ray',0.0),(8,94,99,'BluRay','',NULL,1,'Blu-Ray',0.0),(9,99,18,'DVD Player','Local Src',NULL,1,'DVD',7.0),(10,98,99,'VCR','Local Src',NULL,1,'VCR',0.0),(11,97,99,'Wii','Local Src',NULL,0,'Local Src',0.0),(12,96,99,'XBOX','Local Src',NULL,0,'Local Src',0.0),(13,95,99,'Game Plate','Local Src',NULL,0,'Local Src',0.0),(14,93,99,'Playstation','Local Src',NULL,0,'Local Src',0.0),(15,7,14,'DVD Player','Local Src',NULL,0,'DVD',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 'j3051'
--

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