-- MySQL dump 10.13  Distrib 5.5.31, for debian-linux-gnu (x86_64)
--
-- Host: localhost    Database: j2214
-- ------------------------------------------------------
-- 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 (11,'Text file corruption','mpullin@integrisys.com',NULL,0),(1,'Garage Door is Open','dwilson@drwholdings.com','alzbetaxiv@hotmail.com, asalerno@l3devco.com',1);
/*!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 ('2015-06-01 15:13:41',1,NULL,1),('2015-06-01 15:17:00',1,NULL,1),('2015-06-01 15:17:02',1,NULL,0),('2015-06-01 15:17:03',1,NULL,0),('2015-06-01 15:17:05',1,NULL,0),('2015-06-01 15:17:07',1,NULL,0),('2015-06-01 15:18:07',1,NULL,1),('2015-06-01 15:18:09',1,NULL,0),('2015-06-01 15:18:11',1,NULL,0),('2015-06-01 15:18:12',1,NULL,0),('2015-06-01 15:18:14',1,NULL,0),('2015-06-01 15:19:25',1,NULL,1),('2015-06-01 15:19:27',1,NULL,0),('2015-06-01 15:19:28',1,NULL,0),('2015-06-01 15:19:30',1,NULL,0),('2015-06-01 15:19:32',1,NULL,0),('2015-06-01 15:20:30',1,NULL,1),('2015-06-01 15:20:32',1,NULL,0),('2015-06-01 15:20:33',1,NULL,0),('2015-06-01 15:20:35',1,NULL,0),('2015-06-01 15:20:37',1,NULL,0),('2015-06-01 15:21:27',1,NULL,0),('2015-06-01 15:21:29',1,NULL,0),('2015-06-01 15:21:31',1,NULL,1),('2015-06-01 15:21:32',1,NULL,0),('2015-06-01 15:21:34',1,NULL,0),('2015-11-15 22:24:22',1,NULL,1),('2015-11-15 22:24:24',1,NULL,0),('2015-11-15 22:24:25',1,NULL,0),('2015-11-15 22:24:27',1,NULL,0),('2015-11-15 22:24:29',1,NULL,0);
/*!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,18),(3,18),(2,18),(1,18),(4,10),(3,10),(2,10),(1,10),(4,16),(3,16),(4,2),(3,2),(4,19),(3,19),(2,19),(1,19),(4,3),(3,3),(2,3),(1,3),(2,2),(1,2),(6,1),(5,1),(4,1),(3,1),(2,1),(1,1),(4,4),(3,4),(2,4),(1,4),(4,5),(3,5),(2,5),(1,5),(4,7),(3,7),(2,7),(1,7),(4,21),(3,21),(2,21),(1,21),(4,6),(3,6),(2,6),(1,6),(4,8),(3,8),(2,8),(1,8),(4,9),(3,9),(2,9),(1,9),(1,12),(2,12),(3,12),(4,12),(1,20),(2,20),(3,20),(4,20),(4,11),(3,11),(2,11),(1,11),(1,13),(2,13),(3,13),(4,13),(4,15),(3,15),(2,15),(1,15),(4,17),(3,17),(2,17),(1,17),(2,16),(1,16),(1,14),(2,14),(3,14),(4,14);
/*!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 */;
/*!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 */;
/*!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,9,'FM ','Radio',NULL,0,'AMFM',-4.0),(2,6,'Ipod Rack','IPOD',NULL,0,'Ipod Rack',0.0),(3,7,'Ipod Kitchen','IPOD',NULL,0,'Ipod Kitchen',0.0),(4,8,'CD Changer','','',0,'CD Changer',0.0),(5,4,'Kscape Theater','',NULL,0,'Kscape Theater',0.0),(6,5,'BluRay Theater','',NULL,0,'BluRay Theater',0.0),(7,11,'Kscape Family','',NULL,0,'Kscape Family',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,'Basement'),(2,'First Floor'),(3,'Second Floor'),(4,'Third Floor'),(5,'Fourth Floor');
/*!40000 ALTER TABLE `floor` ENABLE KEYS */;
UNLOCK TABLES;

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

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

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

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

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

DROP TABLE IF EXISTS `light`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `light` (
  `index` smallint(6) NOT NULL AUTO_INCREMENT,
  `room` tinyint(2) NOT NULL DEFAULT '1',
  `addr` varchar(16) NOT NULL DEFAULT '[0:0:0:0]',
  `name` varchar(35) NOT NULL DEFAULT 'New Light',
  `type` varchar(15) NOT NULL DEFAULT 'Dimmer',
  `shade` tinyint(1) NOT NULL DEFAULT '0',
  `maplocX` smallint(3) NOT NULL DEFAULT '999',
  `maplocY` smallint(3) NOT NULL DEFAULT '999',
  PRIMARY KEY (`index`)
) ENGINE=MyISAM AUTO_INCREMENT=66 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 (9,4,'[1:1:0:8:1]','Switched Outlets','Dimmer',0,264,188),(8,4,'[1:1:0:8:2]','Recessed Plaster Ceiling','Dimmer',0,151,213),(7,4,'[1:1:0:7:4]','Ceiling Lantern','Dimmer',0,244,91),(6,4,'[1:1:0:4:4]','Landscape Sconces','Dimmer',0,147,89),(5,5,'[1:1:0:7:2]','Chandelier','Dimmer',0,222,80),(4,5,'[1:1:0:7:1]','Sconces','Dimmer',0,270,178),(3,7,'[1:1:0:5:3]','Wall Sconces','Dimmer',0,112,90),(2,7,'[1:1:0:5:2]','Fireplace','Dimmer',0,196,19),(1,7,'[1:1:0:5:4]','Picture Lights','Dimmer',0,308,106),(10,4,'[1:1:0:8:3]','Landscape Lights','Dimmer',0,184,29),(11,4,'[1:1:0:7:3]','Sconces','Dimmer',0,159,162),(12,7,'[1:1:1:3:3]','Recessed Plaster Ceiling','Dimmer',0,303,29),(13,7,'[1:1:1:2:4]','Fireplace End','Dimmer',0,202,85),(14,7,'[1:1:1:3:1]','Wall Sconces','Dimmer',0,97,20),(15,19,'[1:1:1:3:4]','Chandelier','Dimmer',0,999,999),(16,19,'[1:1:1:4:1]','Recessed Wood Ceiling','Dimmer',0,243,181),(17,19,'[1:1:1:4:2]','Outside Sconces','Dimmer',0,999,999),(18,15,'[2:1:0:2:2]','Ceiling','Dimmer',0,0,183),(19,15,'[2:1:0:2:1]','Sconces','Dimmer',0,0,122),(20,15,'[2:1:0:2:3]','W.C. Ceiling','Dimmer',0,0,58),(21,15,'[2:1:0:7:3]','FA Shower','Dimmer',0,0,0),(22,11,'[2:1:0:4:3]','Ceiling','Dimmer',0,86,251),(23,11,'[2:1:0:8:1]','Bed Lamp Switched Outlets','Dimmer',0,84,190),(24,11,'[2:1:0:4:2]','Fireplace','Dimmer',0,84,129),(25,14,'[2:1:0:6:3]','Bathtub Light','Dimmer',0,7,147),(26,14,'[2:1:0:4:4]','Sconces','Dimmer',0,4,75),(27,14,'[2:1:0:5:1]','Ceiling','Dimmer',0,5,5),(28,18,'[1:1:0:1:1]','Sconces','Dimmer',0,131,46),(29,18,'[1:1:0:1:3]','Startube','Dimmer',0,182,180),(30,18,'[1:1:0:1:2]','Karaoke Lights','Dimmer',0,186,109),(31,2,'[1:1:0:2:1]','Ceiling Chandelier','Dimmer',0,166,163),(32,2,'[1:1:0:2:3]','Puck Lights','Dimmer',0,60,107),(33,2,'[1:1:1:4:3]','Bar Lights','Dimmer',0,338,79),(34,2,'[1:1:0:1:4]','Underbar Light','Dimmer',0,348,205),(35,2,'[1:1:0:2:2]','Bar Sconce','Dimmer',0,190,24),(36,1,'[1:1:0:3:3]','Casino Ceiling','Dimmer',0,123,210),(37,1,'[1:1:0:3:4]','Pool Table Chandelier','Dimmer',0,101,8),(38,1,'[1:1:0:3:1]','Niche South LED','Dimmer',0,261,128),(39,1,'[1:1:0:3:2]','Linear Sconces','Dimmer',0,63,137),(40,19,'[1:4:2:3]','South East Shade','Shade',1,381,288),(41,11,'[1:4:2:13]','Wired QED Shade 1','Shade',1,999,999),(42,11,'[1:4:2:14]','Wired QED Shade 2','Shade',1,16,307),(43,11,'[1:4:2:15]','Wired QED Shade 3','Shade',1,10,252),(44,11,'[1:4:2:16]','Wired QED Shade 4','Shade',1,407,14),(45,11,'[1:4:2:17]','Wired QED Shade 5','Shade',1,324,11),(46,11,'[1:4:2:18]','Wired QED Shade 6','Shade',1,6,188),(47,11,'[1:4:2:7]','Wired QED Drape 1','Shade',1,247,9),(48,11,'[1:4:2:7]','Wired QED Drape 2','Shade',1,165,10),(49,11,'[1:4:2:9]','Wired QED Drape 3','Shade',1,5,128),(50,11,'[1:4:2:10]','Wired QED Drape 4','Shade',1,83,7),(51,11,'[1:4:2:11]','Wired QED Drape 5','Shade',1,6,66),(52,11,'[1:4:2:12]','Wired QED Drape 6','Shade',1,6,5),(53,19,'[1:4:2:4]','South West Shade','Shade',1,374,117),(54,19,'[1:4:2:6]','West South Shade','Shade',1,294,307),(55,19,'[1:4:2:5]','West North Shade','Shade',1,195,307),(56,19,'[1:4:2:2]','North West Shade','Shade',1,116,110),(57,19,'[1:4:2:1]','North East Shades','Shade',1,116,284),(58,18,'[1:4:2:36]','Drapes','Shade',1,219,51),(59,21,'[1:1:1:6:1]','Tree Spots','Dimmer',0,363,254),(60,21,'[1:1:1:6:2]','Trellis Downlights','Dimmer',0,278,188),(61,21,'[1:1:1:5:3]','Garage West Exit  Ext','Dimmer',0,36,116),(62,21,'[1:1:1:5:4]','Garage East Exit Ext','Dimmer',0,365,115),(63,21,'[1:1:1:1:1]','Inside Garage Sconces','Dimmer',0,196,115),(64,21,'[1:1:1:1:2]','Garage West Stairwell','Dimmer',0,33,198),(65,21,'[1:1:1:2:3]','Trash Room','Dimmer',0,174,248);
/*!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:32]',2,'Dim'),('[1:5:32]',1,'Bright'),('[1:5:11]',5,'Off'),('[1:5:11]',2,'Dim'),('[1:5:11]',1,'Bright'),('[1:5:15]',5,'Off'),('[1:5:15]',2,'Dim'),('[1:5:15]',1,'Bright'),('[1:5:16]',5,'Off'),('[1:5:16]',2,'Dim'),('[1:5:16]',1,'Bright'),('[1:5:3]',4,'Step Lts'),('[1:5:4]',5,'Off'),('[1:5:4]',2,'Dim'),('[1:5:4]',1,'Bright'),('[1:5:32]',5,'Off'),('[2:6:12]',4,'Drapes'),('[2:6:12]',3,'Lamps'),('[2:6:14]',1,'Bright'),('[2:6:14]',2,'Dim'),('[2:6:14]',5,'Off'),('[2:6:5]',1,'Bright'),('[2:6:5]',2,'Dim'),('[2:6:5]',5,'Off'),('[1:5:6]',1,'Bright'),('[1:5:6]',2,'Dim'),('[1:5:6]',5,'Off'),('[1:5:3]',3,'Sconce'),('[1:5:3]',2,'Dim'),('[1:5:3]',1,'Bright'),('[1:5:3]',5,'Off'),('[2:6:12]',5,'Off'),('[2:6:12]',2,'Dim'),('[2:6:12]',1,'Bright'),('[X.X.X]',1,' ');
/*!40000 ALTER TABLE `lightScene` ENABLE KEYS */;
UNLOCK TABLES;

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

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

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

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

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

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

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

LOCK TABLES `mode` WRITE;
/*!40000 ALTER TABLE `mode` DISABLE KEYS */;
INSERT INTO `mode` VALUES (1,1,1,'Leave','','F','',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 */;
/*!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,'Casino Area',1,NULL,NULL,50,85,'[1:5:6]',NULL,NULL,0,'0 0 0 0 0 0 0 0 0 0',999,999,0,0),(2,1,'Speakeasy',2,2,NULL,50,85,'[1:5:4]',NULL,NULL,0,'0 0 0 0 0 0 0 0 0 0',999,999,0,0),(3,1,'Music Room',3,NULL,NULL,50,85,NULL,NULL,NULL,0,'0 0 0 0 0 0 0 0 0 0',999,999,0,0),(4,2,'Loggia',4,NULL,NULL,50,85,'[1:5:16]',NULL,NULL,0,'0 0 0 0 0 0 0 0 0 0',999,999,0,0),(5,2,'Project Room',5,4,NULL,50,85,'[1:5:15]',NULL,NULL,0,'-30 -30 -30 0 0 0 0 40 40 40',999,999,0,0),(6,3,'Dining Room',6,NULL,NULL,50,85,NULL,NULL,NULL,0,'0 0 0 0 0 0 0 0 0 0',999,999,0,0),(7,2,'Library',7,NULL,NULL,50,85,'[1:5:11]',NULL,NULL,0,'0 0 0 0 0 0 0 0 0 0',999,999,0,0),(8,3,'Laurie\'s Office',9,NULL,NULL,50,85,NULL,NULL,NULL,0,'0 0 0 0 0 0 0 0 0 0',999,999,0,0),(9,3,'Breakfast',10,NULL,NULL,50,85,NULL,NULL,NULL,0,'0 0 0 0 0 0 0 0 0 0',999,999,0,0),(10,3,'Kitchen',11,13,NULL,50,85,NULL,NULL,NULL,0,'0 0 0 0 0 0 0 0 0 0',999,999,0,0),(11,4,'Master Bed',12,8,NULL,50,85,'[2:6:12]',NULL,'[1:6:31]',0,'0 0 0 0 0 0 0 0 0 0',999,999,0,0),(12,3,'Living Room',13,NULL,NULL,50,85,NULL,NULL,NULL,0,'0 0 0 0 0 0 0 0 0 0',999,999,0,0),(13,4,'Her Dressing',14,NULL,NULL,50,85,NULL,NULL,NULL,0,'0 0 0 0 0 0 0 0 0 0',999,999,0,0),(14,4,'Her Bath',15,NULL,NULL,50,85,'[2:6:14]',NULL,NULL,0,'0 0 0 0 0 0 0 0 0 0',999,999,0,0),(15,4,'His Bath',16,NULL,NULL,50,85,'[2:6:5]',NULL,NULL,0,'0 0 0 0 0 0 0 0 0 0',999,999,0,0),(16,5,'Playroom',18,10,NULL,50,85,NULL,NULL,NULL,0,'0 0 0 0 0 0 0 0 0 0',999,999,0,0),(17,5,'Exercise',17,11,NULL,50,85,NULL,NULL,NULL,0,'0 0 0 0 0 0 0 0 0 0',999,999,0,0),(18,1,'Theater',19,1,NULL,90,85,'[1:5:3]',NULL,'[1:6:32]',0,'0 0 0 0 0 0 0 0 0 0',999,999,0,0),(19,3,'Family Room',20,5,NULL,90,85,'[1:5:32]',NULL,'[1:6:30]',0,'0 0 0 0 0 0 0 0 0 0',999,999,0,0),(20,2,'Au Pair Bed',22,3,NULL,50,85,NULL,NULL,NULL,0,'0 0 0 0 0 0 0 0 0 0',999,999,0,0),(21,2,'Garage Terrace',3,NULL,NULL,50,85,'[X.X.X]',NULL,NULL,0,'0 0 0 0 0 0 0 0 0 0',999,999,0,0);
/*!40000 ALTER TABLE `room` ENABLE KEYS */;
UNLOCK TABLES;

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

LOCK TABLES `shadeScene` WRITE;
/*!40000 ALTER TABLE `shadeScene` DISABLE KEYS */;
INSERT INTO `shadeScene` VALUES ('[1:6:32]',2,'Curtain Close'),('[1:6:32]',1,'Curtain Open'),('[1:6:31]',2,'Drapes Close'),('[1:6:31]',1,'Drapes Open'),('[1:6:30]',2,'Close All'),('[1:6:30]',1,'Open All');
/*!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 ('Unused System',5,10,5,100,50,25,15,0,'Chicago, IL',41.920334,-87.643388,'60642','Crestron','APRIL','j2214.dyndns.org',NULL,2,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 */;
/*!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,'1','TPMC-8X',1,'Family Room',19,'1.2.3.4.5.6.7.8.9.10.11.12.13.14.15.16.17.18.19.20.21',1,1,1,1),(2,'2','TPS-4L',0,'Master Bed',11,'11',1,1,1,1),(3,'3','TPMC-8X',1,'Theater',18,'1.2.3.4.5.6.7.8.9.10.11.12.13.14.15.16.17.18.19.20.21',1,1,1,1),(4,'4','MLX-2',0,'Speakeasy',2,'2',1,1,1,1),(5,'5','MLX-2',0,'AuPair Bed',20,'20',1,1,1,1),(6,'6','MLX-2',1,'Project Room',5,'5',1,1,1,1),(7,'7','MLX-2',0,'Master Bed',11,'11',1,1,1,1),(8,'8','MLX-2',0,'Exercise',17,'17',1,1,1,1),(9,'9','MLX-2',0,'Sitting Room',16,'16',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 (8,18),(6,18),(5,18),(7,10),(3,10),(2,10),(8,2),(6,2),(4,2),(7,19),(6,19),(3,19),(2,19),(1,19),(3,2),(2,2),(5,5),(5,2),(8,5),(3,21),(2,21),(1,21),(1,20),(2,20),(3,20),(7,20),(7,11),(3,11),(2,11),(8,17),(7,17),(5,17),(4,18),(1,11),(7,16),(3,16),(2,16),(3,18),(7,5),(3,5),(2,5),(1,2),(1,5),(1,10),(8,11),(1,16),(3,17),(2,18),(8,19),(8,20),(8,10),(2,17),(8,16),(5,10),(5,11),(5,16),(1,17),(1,18),(5,19),(5,20);
/*!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 */;
/*!40000 ALTER TABLE `videoChannel` ENABLE KEYS */;
UNLOCK TABLES;

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

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

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

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

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

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

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

LOCK TABLES `videoSrc` WRITE;
/*!40000 ALTER TABLE `videoSrc` DISABLE KEYS */;
INSERT INTO `videoSrc` VALUES (1,1,1,'Cable 1','Cable',NULL,0,'Cable 1',0.5),(2,2,2,'Cable 2','Cable',NULL,0,'Cable 2',0.0),(3,3,3,'DVD Changer','',NULL,0,'DVD Changer',0.0),(4,4,4,'Kscape Theater','',NULL,0,'Kscape Theater',0.0),(5,5,0,'Camera DVR','',NULL,0,'Camera DVR',0.0),(6,6,5,'BluRay Theater','',NULL,0,'BluRay Theater',0.0),(7,7,10,'Kscape Family','',NULL,0,'',0.0),(8,8,11,'Akoo Player','',NULL,0,'Akoo Player',0.0);
/*!40000 ALTER TABLE `videoSrc` ENABLE KEYS */;
UNLOCK TABLES;

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

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

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

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

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

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

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

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

--
-- Dumping events for database 'j2214'
--

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