DomotiGa - /trunk/upgrade/01167to01168.sql - DomotiGa

The files contained in this repository can be downloaded to your computer using a svn client.
On Linux you simply type the command displayed below.

Subversion

This URL has Read-Only access.

Statistics

root / trunk / upgrade / 01167to01168.sql @ 816

History | View | Annotate | Download (11.2 kB)

 -- 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 `devices`
 --
 ALTER TABLE `devices` ADD COLUMN `calibration` int(11) default NULL AFTER value4;
 ALTER TABLE `devices` ADD COLUMN `calibration2` int(11) default NULL AFTER calibration;
 ALTER TABLE `devices` ADD COLUMN `calibration3` int(11) default NULL AFTER calibration2;
 ALTER TABLE `devices` ADD COLUMN `calibration4` int(11) default NULL AFTER calibration3;
 ALTER TABLE `devices` ADD COLUMN `divider` int(11) default NULL AFTER calibration4;
 ALTER TABLE `devices` ADD COLUMN `divider2` int(11) default NULL AFTER divider;
 ALTER TABLE `devices` ADD COLUMN `divider3` int(11) default NULL AFTER divider2;
 ALTER TABLE `devices` ADD COLUMN `divider4` int(11) default NULL AFTER divider3;
 --
 -- Table structure for table `settings_digitemp`
 --
 DROP TABLE IF EXISTS `settings_digitemp`;
 SET @saved_cs_client     = @@character_set_client;
 SET character_set_client = utf8;
 CREATE TABLE `settings_digitemp` (
   `id` int(11) NOT NULL,
   `enabled` tinyint(1) default NULL,
   `command` varchar(32) default NULL,
   `config` varchar(32) default NULL,
   `polltime` int(11) default NULL,
   `readtime` 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_digitemp`
 --
 LOCK TABLES `settings_digitemp` WRITE;
 /*!40000 ALTER TABLE `settings_digitemp` DISABLE KEYS */;
 INSERT INTO `settings_digitemp` VALUES (0,0,'digitemp_DS9097U','/etc/digitemp.conf',300,1500,0),(1,0,'digitemp_DS9097U','/etc/digitemp.conf',300,1500,0);
 /*!40000 ALTER TABLE `settings_digitemp` ENABLE KEYS */;
 UNLOCK TABLES;
 --
 -- Table structure for table `newsfeeds`
 --
 DROP TABLE IF EXISTS `newsfeeds`;
 SET @saved_cs_client     = @@character_set_client;
 SET character_set_client = utf8;
 CREATE TABLE `newsfeeds` (
   `id` bigint(20) unsigned NOT NULL auto_increment,
   `name` varchar(32) default NULL,
   `url` varchar(254) default NULL,
   `description` text,
   `enabled` tinyint(1) default NULL,
   PRIMARY KEY  (`id`)
 ) ENGINE=MyISAM AUTO_INCREMENT=4 DEFAULT CHARSET=latin1;
 SET character_set_client = @saved_cs_client;
 --
 -- Dumping data for table `newsfeeds`
 --
 LOCK TABLES `newsfeeds` WRITE;
 /*!40000 ALTER TABLE `newsfeeds` DISABLE KEYS */;
 INSERT INTO `newsfeeds` VALUES (1,'Slashdot','http://rss.slashdot.org/Slashdot/slashdot','News for Nerds. Stuff that Matters.',1),(2,'Tweakers','http://gathering.tweakers.net/rss/list_activetopics','Gathering of Tweakers.',1),(3,'Weather','http://www.buienradar.nl/rssnieuws.aspx','',1);
 /*!40000 ALTER TABLE `newsfeeds` 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(254) 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 `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(254) default NULL,
   `description` text,
   `enabled` tinyint(1) default NULL,
   `type` int(11) default NULL,
   PRIMARY KEY  (`id`)
 ) ENGINE=MyISAM AUTO_INCREMENT=4 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 */;
 INSERT INTO `weatherfeeds` VALUES (1,'Sat24','http://www.sat24.com/image.ashx?country=nl','',1,NULL);
 /*!40000 ALTER TABLE `weatherfeeds` 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=15 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'),(14,'Digitemp','Digitemp','Read');
 /*!40000 ALTER TABLE `interfaces` 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=59 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'),(46,'KNX/EIB Dim','EIS 2','KNX/EIB'),(45,'KNX/EIB On/Off','EIS 1','KNX/EIB'),(49,'KNX/EIB Values','EIS 5','KNX/EIB'),(48,'KNX/EIB Date','EIS 4','KNX/EIB'),(47,'KNX/EIB Time','EIS 3','KNX/EIB'),(50,'KNX/EIB Scaling %','EIS 6','KNX/EIB'),(51,'KNX/EIB Motor Drives','EIS 7','KNX/EIB'),(52,'KNX/EIB Forced Control','EIS 8','KNX/EIB'),(53,'KNX/EIB 32bit Float','EIS 9','KNX/EIB'),(54,'KNX/EIB 16bit Int','EIS 10','KNX/EIB'),(55,'KNX/EIB 32bit Int','EIS 11','KNX/EIB'),(56,'KNX/EIB 8bit Int','EIS 14','KNX/EIB'),(57,'KNX/EIB 14byte Text','EIS 15','KNX/EIB'),(58,'Digitemp DS1820','Temp Sensor','Digitemp');
 /*!40000 ALTER TABLE `devicetypes` ENABLE KEYS */;
 UNLOCK TABLES;
 --
 -- Table structure for table `deviceblacklist`
 --
 DROP TABLE IF EXISTS `deviceblacklist`;
 SET @saved_cs_client     = @@character_set_client;
 SET character_set_client = utf8;
 CREATE TABLE `deviceblacklist` (
   `blid` bigint(20) unsigned NOT NULL auto_increment,
   `address` varchar(64) default NULL,
   `comments` text,
   `id` int(11) default NULL,
   PRIMARY KEY  (`blid`)
 ) ENGINE=MyISAM AUTO_INCREMENT=6 DEFAULT CHARSET=latin1;
 SET character_set_client = @saved_cs_client;
 --
 -- Dumping data for table `deviceblacklist`
 --
 LOCK TABLES `deviceblacklist` WRITE;
 /*!40000 ALTER TABLE `deviceblacklist` DISABLE KEYS */;
 /*!40000 ALTER TABLE `deviceblacklist` 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=4 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'),(2,'0.1.167'),(3,'0.1.168');
 /*!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-09-06 14:10:43