-- MySQL dump 10.13  Distrib 5.5.31, for debian-linux-gnu (x86_64)
--
-- Host: localhost    Database: j2895
-- ------------------------------------------------------
-- 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);
/*!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 */;
/*!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 (6,1),(5,1),(4,1),(3,1),(2,1),(1,1),(6,2),(5,2),(4,2),(3,2),(2,2),(1,2),(6,3),(5,3),(4,3),(3,3),(2,3),(1,3),(6,5),(5,5),(4,5),(3,5),(2,5),(1,5),(6,6),(5,6),(4,6),(3,6),(2,6),(1,6),(6,4),(5,4),(4,4),(3,4),(2,4),(1,4);
/*!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,1,'FM 1','Radio','Radio_AMFM',0,'FM1',0.0),(2,2,'FM 2','Radio','Radio_AMFM',0,'FM 2',0.0),(3,3,'XM Radio','Radio','Radio_XM',0,'XM',0.0),(4,4,'Squeezebox','Radio','Radio_SqB',0,'Squeezebox',0.0),(5,8,'iPod','',NULL,0,'iPod',0.0),(6,9,'CD Changer','','CD Changer',0,'CD Changer',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 */;
INSERT INTO `climateZone` VALUES (1,'North',1,1,0),(2,'South',1,1,0);
/*!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,'Unit 27F');
/*!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=31 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,2,'[1:5:1:1]','Appliances','Dimmer',0,313,155),(2,2,'[1:5:1:2]','Downlights','Dimmer',0,224,75),(3,2,'[1:5:1:3]','Island','Dimmer',0,237,209),(4,2,'[1:5:1:4]','Undercab','Dimmer',0,149,272),(5,5,'[1:5:1:5]','Downlights','Dimmer',0,333,195),(6,5,'[1:5:1:6]','Downlights 2','Dimmer',0,28,230),(7,5,'[1:5:2:1]','Pendant','Dimmer',0,73,156),(8,4,'[1:5:2:2]','WC','Dimmer',0,324,252),(9,4,'[1:5:2:3]','Downlights','Dimmer',0,191,164),(10,4,'[1:5:2:4]','Sconces','Dimmer',0,90,107),(11,4,'[1:5:2:5]','Tub','Dimmer',0,175,262),(12,4,'[1:5:2:6]','Shower','Dimmer',0,320,94),(13,3,'[1:8:1:2]','His Table','Dimmer',0,143,116),(14,3,'[1:8:1:1]','Her Table','Dimmer',0,143,220),(15,7,'[1:4:1:2:1]','Downlights','Dimmer',0,235,165),(16,6,'[1:4:1:1:7]','Downlights','Dimmer',0,215,174),(17,7,'[1:8:1:14]','Fixtures','Dimmer',0,156,165),(18,3,'[1:4:1:2:4]','Downlights','Dimmer',0,247,207),(19,2,'[1:4:2:1]','West','Shade',1,226,20),(20,5,'[1:4:2:2]','North','Shade',1,345,5),(21,5,'[1:4:2:3]','South','Shade',1,118,10),(22,3,'[1:4:2:7]','Shade','Shade',1,212,17),(23,1,'[1:4:2:6]','West','Shade',1,320,175),(24,1,'[1:8:1:4]','Lamps','Dimmer',0,269,250),(25,3,'[1:8:1:3]','Floor Lamp','Dimmer',0,275,90),(26,1,'[1:4:1:3:4]','Ceiling','Dimmer',0,170,191),(27,6,'[1:4:2:4]','Shade','Shade',1,244,75),(28,7,'[1:4:2:5]','Shade','Shade',1,343,163),(29,5,'[1:8:1:5]','Lamp','Dimmer',0,228,115),(30,3,'[1:4:1:1:5]','Hall','Dimmer',0,281,307);
/*!40000 ALTER TABLE `light` ENABLE KEYS */;
UNLOCK TABLES;

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

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

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

LOCK TABLES `lightScene` WRITE;
/*!40000 ALTER TABLE `lightScene` DISABLE KEYS */;
INSERT INTO `lightScene` VALUES ('[1:6:17]',6,'Off'),('[1:6:17]',3,'Dim'),('[1:6:17]',2,'Medium'),('[1:6:17]',1,'Bright'),('[1:6:16]',6,'Off'),('[1:6:16]',3,'Dim'),('[1:6:16]',2,'Medium'),('[1:6:16]',1,'Bright'),('[1:6:20]',6,'Off'),('[1:6:20]',3,'Dim'),('[1:6:20]',2,'Medium'),('[1:6:20]',1,'Bright'),('[1:6:21]',6,'Off'),('[1:6:21]',3,'Dim'),('[1:6:21]',2,'Medium'),('[1:6:21]',1,'Bright'),('[1:6:22]',6,'Off'),('[1:6:22]',3,'Dim'),('[1:6:22]',2,'Medium'),('[1:6:22]',1,'Bright'),('[1:6:18]',6,'Off'),('[1:6:18]',3,'Dim'),('[1:6:18]',2,'Medium'),('[1:6:18]',1,'Bright'),('[1:6:19]',6,'Off'),('[1:6:19]',3,'Dim'),('[1:6:19]',2,'Medium'),('[1:6:19]',1,'Bright');
/*!40000 ALTER TABLE `lightScene` ENABLE KEYS */;
UNLOCK TABLES;

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

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

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

LOCK TABLES `localSrc` WRITE;
/*!40000 ALTER TABLE `localSrc` DISABLE KEYS */;
/*!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 */;
/*!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,'Den',5,1,NULL,50,85,'[1:6:19]',NULL,'[1:6:27]',0,'0 0 0 0 0 0 0 0 0 0',999,999,0,0),(2,1,'Kitchen',4,2,NULL,50,85,'[1:6:18]',NULL,'[1:6:23]',0,'0 0 0 0 0 0 0 0 0 0',999,999,0,0),(3,1,'Master Bed',2,4,NULL,50,85,'[1:6:22]',NULL,'[1:6:28]',0,'0 0 0 0 0 0 0 0 0 0',999,999,0,0),(4,1,'Master Bath',1,3,NULL,50,85,'[1:6:21]',NULL,NULL,0,'0 0 0 0 0 0 0 0 0 0',999,999,0,0),(5,1,'Living Room',3,NULL,NULL,50,85,'[1:6:20]',NULL,'[1:6:24]',0,'0 0 0 0 0 0 0 0 0 0',999,999,0,0),(6,1,'Bed 2',NULL,NULL,NULL,50,85,'[1:6:16]',NULL,'[1:6:25]',0,'0 0 0 0 0 0 0 0 0 0',999,999,0,0),(7,1,'Bed 3',NULL,NULL,NULL,50,85,'[1:6:17]',NULL,'[1:6:26]',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:23]',1,'Open'),('[1:6:23]',2,'Close'),('[1:6:24]',1,'Open South'),('[1:6:24]',2,'Close South'),('[1:6:24]',4,'Open North'),('[1:6:24]',5,'Close North'),('[1:6:28]',1,'Open'),('[1:6:28]',2,'Close'),('[1:6:27]',1,'Open'),('[1:6:27]',2,'Close'),('[1:6:25]',1,'Open'),('[1:6:25]',2,'Close'),('[1:6:26]',1,'Open'),('[1:6:26]',2,'Close');
/*!40000 ALTER TABLE `shadeScene` ENABLE KEYS */;
UNLOCK TABLES;

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

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

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

LOCK TABLES `system` WRITE;
/*!40000 ALTER TABLE `system` DISABLE KEYS */;
INSERT INTO `system` VALUES ('Becker Residence',5,10,5,100,50,25,15,0,'Chicago, IL',41.899627,-87.624613,'60620','Crestron','APRIL','99.21.168.153',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,'Kitchen',2,'1.2.3.4.5.6.7',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 (5,1),(4,1),(3,1),(2,1),(1,1),(5,2),(4,2),(3,2),(2,2),(1,2),(5,3),(4,3),(3,3),(2,3),(1,3),(5,4),(4,4),(3,4),(2,4),(1,4);
/*!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,5,'DVR 1','DVR','Cable',0,'DVR 1',0.0),(2,2,6,'DVR 2','DVR','Cable',0,'DVR 2',0.0),(3,3,7,'AppleTV','',NULL,0,'AppleTV',0.0),(4,4,8,'iPod','',NULL,0,'iPod',0.0),(5,5,10,'BluRay','',NULL,0,'BluRay',0.0),(6,99,99,'VTC','',NULL,0,'VTC',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 'j2895'
--

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