-- MySQL dump 10.11

--

-- Host: localhost    Database: domotiga

-- ------------------------------------------------------

-- Server version        5.0.75-0ubuntu10.2

/*!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 */;

USE domotiga;

--

-- Table structure for table `settings_eib`

--

DROP TABLE IF EXISTS `settings_eib`;

SET @saved_cs_client     = @@character_set_client;

SET character_set_client = utf8;

CREATE TABLE `settings_eib` (

  `id` int(11) NOT NULL,

  `enabled` tinyint(1) default NULL,

  `tcphost` varchar(32) default NULL,

  `tcpport` int(11) default NULL,

  `debug` tinyint(1) default NULL,

  PRIMARY KEY  (`id`)

) ENGINE=MyISAM DEFAULT CHARSET=latin1;

SET character_set_client = @saved_cs_client;

--

-- Dumping data for table `settings_eib`

--

LOCK TABLES `settings_eib` WRITE;

/*!40000 ALTER TABLE `settings_eib` DISABLE KEYS */;

INSERT INTO `settings_eib` VALUES (0,0,'localhost',6720,1),(1,0,'localhost',6720,-1);

/*!40000 ALTER TABLE `settings_eib` ENABLE KEYS */;

UNLOCK TABLES;

--

-- Table structure for table `settings_domotica`

--

DROP TABLE IF EXISTS `settings_domotica`;

SET @saved_cs_client     = @@character_set_client;

SET character_set_client = utf8;

CREATE TABLE `settings_domotica` (

  `id` int(11) NOT NULL,

  `enabled` tinyint(1) default NULL,

  `serialport` varchar(32) default NULL,

  `debug` tinyint(1) default NULL,

  PRIMARY KEY  (`id`)

) ENGINE=MyISAM DEFAULT CHARSET=latin1;

SET character_set_client = @saved_cs_client;

--

-- Dumping data for table `settings_domotica`

--

LOCK TABLES `settings_domotica` WRITE;

/*!40000 ALTER TABLE `settings_domotica` DISABLE KEYS */;

INSERT INTO `settings_domotica` VALUES (0,0,'/dev/ttyUSB6',0),(1,0,'/dev/ttyUSB4',0);

/*!40000 ALTER TABLE `settings_domotica` ENABLE KEYS */;

UNLOCK TABLES;

--

-- Table structure for table `devicetypes`

--

DROP TABLE IF EXISTS `devicetypes`;

SET @saved_cs_client     = @@character_set_client;

SET character_set_client = utf8;

CREATE TABLE `devicetypes` (

  `id` bigint(20) unsigned NOT NULL auto_increment,

  `name` varchar(32) default NULL,

  `description` varchar(32) default NULL,

  `type` varchar(32) default NULL,

  PRIMARY KEY  (`id`)

) ENGINE=MyISAM AUTO_INCREMENT=47 DEFAULT CHARSET=latin1;

SET character_set_client = @saved_cs_client;

--

-- Dumping data for table `devicetypes`

--

LOCK TABLES `devicetypes` WRITE;

/*!40000 ALTER TABLE `devicetypes` DISABLE KEYS */;

INSERT INTO `devicetypes` VALUES (1,'Marmitek DS90','Door/Window Sensor','X10Security'),(2,'Marmitek LW10G','Lamp Module','X10'),(3,'Marmitek LD11','Dimmer Module','X10'),(4,'Marmitek MS13E M','Motion Sensor','X10'),(5,'Marmitek MS13E L','Light Sensor','X10'),(6,'Xanura SAX35','I/O Actor','A10'),(7,'Oregon THGR238N','Temp/Hygro Sensor','Oregon'),(8,'Oregon UV138','UV Light Sensor','Oregon'),(9,'RFXPwr Module','Power Usage Sensor','RFXCom'),(10,'Marmitek TM13','Wireless Tranceiver','X10'),(11,'HDDTemp Item','Temp Monitor','HDDTemp'),(12,'Oregon THR128','Temp Sensor','Oregon'),(13,'Sony AIBO ERS-7 ','Robot Dog','AIBO'),(14,'APC SmartUPS1000','Power Supply','UPS'),(15,'Dallas DS18S20','Temp Sensor','1-Wire'),(16,'Dallas Rain Gauge','Rain Gauge','1-Wire'),(17,'Marmitek SD90','Smoke Detector','X10Security'),(18,'Bluetooth Device','Phone','Bluetooth'),(19,'ITHO ECO Fan','Central Ventilation','Weeder'),(20,'RFXPulse Gas','Gas Usage Sensor','RFXCom'),(21,'RFXPulse Water','Water Usage Sensor','RFXCom'),(22,'Oregon BWR102','Digital Bathroom Scale','Oregon'),(23,'Oregon GR101','Digital Bathroom Scale','Oregon'),(24,'Oregon THC138','Temp Sensor','Oregon'),(25,'Oregon THR138','Temp Sensor','Oregon'),(26,'Oregon THGR810','Temp/Hygro Sensor','Oregon'),(27,'Plugwise Circle','Zigbee Appliance Module','Plugwise'),(28,'Plugwise Circle+','Zigbee Appliance Module','Plugwise'),(29,'KAKU Doorbell','Wireless Doorbell','X10'),(30,'Oregon THN132N','Temp Sensor','Oregon'),(31,'Oregon THWR288','Temp Sensor','Oregon'),(32,'Oregon BTHR918N','Baro/Temp/Hygro Sensor','Oregon'),(33,'Oregon BTHR968','Baro/Temp/Hygro Sensor','Oregon'),(34,'Marmitek AD10','Switch Module','X10'),(35,'Marmitek LM12','Lamp Module','X10'),(36,'Marmitek AM12','Appliance Module','X10'),(38,'Oregon PCR800','Rain Gauge','Oregon'),(39,'Oregon RTGR328N','Temp/Hygro/Time Sensor','Oregon'),(40,'DSC PIR','Motion Sensor','DSC'),(41,'DSC Contact','Door/Window Sensor','DSC'),(42,'DSC Smoke','Smoke Detector','DSC'),(43,'KAKU AWST-8802','Wireless Wallswitch Dual','HE'),(44,'KAKU AMST-606','Door/Window Sensor','HE'),(45,'KNX/EIB (On/Off)','EIS 1','KNX/EIB'),(46,'KNX/EIB (Dim)','EIS 2','KNX/EIB');

/*!40000 ALTER TABLE `devicetypes` ENABLE KEYS */;

UNLOCK TABLES;

--

-- Table structure for table `interfaces`

--

DROP TABLE IF EXISTS `interfaces`;

SET @saved_cs_client     = @@character_set_client;

SET character_set_client = utf8;

CREATE TABLE `interfaces` (

  `id` bigint(20) unsigned NOT NULL auto_increment,

  `name` varchar(32) default NULL,

  `type` varchar(32) default NULL,

  `mode` varchar(32) default NULL,

  PRIMARY KEY  (`id`)

) ENGINE=MyISAM AUTO_INCREMENT=14 DEFAULT CHARSET=latin1;

SET character_set_client = @saved_cs_client;

--

-- Dumping data for table `interfaces`

--

LOCK TABLES `interfaces` WRITE;

/*!40000 ALTER TABLE `interfaces` DISABLE KEYS */;

INSERT INTO `interfaces` VALUES (1,'RFXCom Receiver','A10 X10 Oregon KAKU','Read'),(2,'Xanura CTX35','A10 X10','Read Write'),(3,'Midon TEMP08','One-Wire','Read Write'),(4,'HDDTemp Socket','Build-in Module','Read'),(5,'AIBO Socket','Build-in Module','Read'),(6,'UPS Socket','Build-in Module','Read'),(7,'Heyu X10','A10 X10','Write'),(8,'Bluetooth Dongle','Bluetooth','Read Write'),(9,'Weeder I/O Bus','Weeder','Read Write'),(10,'Plugwise Stick','Plugwise','Read Write'),(11,'DSC5401 Interface','DSC','Read Write'),(12,'RFXCom Transmitter','A10 X10 KAKU','Read Write'),(13,'KNX/EIB Interface','KNX EIB','Read Write');

/*!40000 ALTER TABLE `interfaces` ENABLE KEYS */;

UNLOCK TABLES;

--

-- Table structure for table `weatherfeeds`

--

DROP TABLE IF EXISTS `weatherfeeds`;

SET @saved_cs_client     = @@character_set_client;

SET character_set_client = utf8;

CREATE TABLE `weatherfeeds` (

  `id` bigint(20) unsigned NOT NULL auto_increment,

  `name` varchar(32) default NULL,

  `url` varchar(64) default NULL,

  `description` text,

  `enabled` tinyint(1) default NULL,

  `type` int(11) default NULL,

  PRIMARY KEY  (`id`)

) ENGINE=MyISAM DEFAULT CHARSET=latin1;

SET character_set_client = @saved_cs_client;

--

-- Dumping data for table `weatherfeeds`

--

LOCK TABLES `weatherfeeds` WRITE;

/*!40000 ALTER TABLE `weatherfeeds` DISABLE KEYS */;

/*!40000 ALTER TABLE `weatherfeeds` ENABLE KEYS */;

UNLOCK TABLES;

--

-- Table structure for table `trafficfeeds`

--

DROP TABLE IF EXISTS `trafficfeeds`;

SET @saved_cs_client     = @@character_set_client;

SET character_set_client = utf8;

CREATE TABLE `trafficfeeds` (

  `id` bigint(20) unsigned NOT NULL auto_increment,

  `name` varchar(32) default NULL,

  `url` varchar(64) default NULL,

  `description` text,

  `enabled` tinyint(1) default NULL,

  `type` int(11) default NULL,

  PRIMARY KEY  (`id`)

) ENGINE=MyISAM DEFAULT CHARSET=latin1;

SET character_set_client = @saved_cs_client;

--

-- Dumping data for table `trafficfeeds`

--

LOCK TABLES `trafficfeeds` WRITE;

/*!40000 ALTER TABLE `trafficfeeds` DISABLE KEYS */;

/*!40000 ALTER TABLE `trafficfeeds` ENABLE KEYS */;

UNLOCK TABLES;

--

-- Table structure for table `version`

--

DROP TABLE IF EXISTS `version`;

SET @saved_cs_client     = @@character_set_client;

SET character_set_client = utf8;

CREATE TABLE `version` (

  `id` bigint(20) unsigned NOT NULL auto_increment,

  `db` varchar(16) default NULL,

  PRIMARY KEY  (`id`)

) ENGINE=MyISAM AUTO_INCREMENT=2 DEFAULT CHARSET=latin1;

SET character_set_client = @saved_cs_client;

--

-- Dumping data for table `version`

--

LOCK TABLES `version` WRITE;

/*!40000 ALTER TABLE `version` DISABLE KEYS */;

INSERT INTO `version` VALUES (1,'0.1.166');

/*!40000 ALTER TABLE `version` ENABLE KEYS */;

UNLOCK TABLES;

/*!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 2009-07-04 12:36:08