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.
This URL has Read-Only access.
root / trunk / upgrade / 01178to01179.sql @ 294
History | View | Annotate | Download (9.9 kB)
| 1 | -- MySQL dump 10.13 Distrib 5.1.37, for debian-linux-gnu (i486)
|
|---|---|
| 2 | --
|
| 3 | -- Host: localhost Database: domotiga |
| 4 | -- ------------------------------------------------------
|
| 5 | -- Server version 5.1.37-1ubuntu5
|
| 6 | |
| 7 | /*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
|
| 8 | /*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
|
| 9 | /*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;
|
| 10 | /*!40101 SET NAMES utf8 */;
|
| 11 | /*!40103 SET @OLD_TIME_ZONE=@@TIME_ZONE */;
|
| 12 | /*!40103 SET TIME_ZONE='+00:00' */;
|
| 13 | /*!40014 SET @OLD_UNIQUE_CHECKS=@@UNIQUE_CHECKS, UNIQUE_CHECKS=0 */;
|
| 14 | /*!40014 SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0 */;
|
| 15 | /*!40101 SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='NO_AUTO_VALUE_ON_ZERO' */;
|
| 16 | /*!40111 SET @OLD_SQL_NOTES=@@SQL_NOTES, SQL_NOTES=0 */;
|
| 17 | |
| 18 | USE domotiga; |
| 19 | |
| 20 | --
|
| 21 | -- Table structure for table `version` |
| 22 | --
|
| 23 | |
| 24 | DROP TABLE IF EXISTS `version`; |
| 25 | /*!40101 SET @saved_cs_client = @@character_set_client */;
|
| 26 | /*!40101 SET character_set_client = utf8 */;
|
| 27 | CREATE TABLE `version` ( |
| 28 | `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT, |
| 29 | `db` varchar(16) DEFAULT NULL, |
| 30 | PRIMARY KEY (`id`) |
| 31 | ) ENGINE=MyISAM AUTO_INCREMENT=15 DEFAULT CHARSET=latin1; |
| 32 | /*!40101 SET character_set_client = @saved_cs_client */;
|
| 33 | |
| 34 | --
|
| 35 | -- Dumping data for table `version` |
| 36 | --
|
| 37 | |
| 38 | LOCK TABLES `version` WRITE;
|
| 39 | /*!40000 ALTER TABLE `version` DISABLE KEYS */;
|
| 40 | INSERT INTO `version` VALUES (1,'0.1.166'),(2,'0.1.167'),(3,'0.1.168'),(4,'0.1.169'),(5,'0.1.170'),(6,'0.1.171'),(7,'0.1.172'),(8,'0.1.173'),(9,'0.1.174'),(10,'0.1.175'),(11,'0.1.176'),(12,'0.1.177'),(13,'0.1.178'),(14,'0.1.179'); |
| 41 | /*!40000 ALTER TABLE `version` ENABLE KEYS */;
|
| 42 | UNLOCK TABLES; |
| 43 | |
| 44 | --
|
| 45 | -- Table structure for table `security` |
| 46 | --
|
| 47 | |
| 48 | DROP TABLE IF EXISTS `security`; |
| 49 | /*!40101 SET @saved_cs_client = @@character_set_client */;
|
| 50 | /*!40101 SET character_set_client = utf8 */;
|
| 51 | CREATE TABLE `security` ( |
| 52 | `id` int(11) NOT NULL DEFAULT '0', |
| 53 | `ready` tinyint(1) DEFAULT NULL, |
| 54 | `armed` tinyint(1) DEFAULT NULL, |
| 55 | `trouble` tinyint(1) DEFAULT NULL, |
| 56 | `lcd_line1` varchar(32) DEFAULT NULL, |
| 57 | `lcd_line2` varchar(32) DEFAULT NULL, |
| 58 | PRIMARY KEY (`id`) |
| 59 | ) ENGINE=MyISAM DEFAULT CHARSET=latin1; |
| 60 | /*!40101 SET character_set_client = @saved_cs_client */;
|
| 61 | |
| 62 | --
|
| 63 | -- Dumping data for table `security` |
| 64 | --
|
| 65 | |
| 66 | LOCK TABLES `security` WRITE;
|
| 67 | /*!40000 ALTER TABLE `security` DISABLE KEYS */;
|
| 68 | INSERT INTO `security` VALUES (0,1,0,0,'DSC Security','14/January/2010 15:50'); |
| 69 | /*!40000 ALTER TABLE `security` ENABLE KEYS */;
|
| 70 | UNLOCK TABLES; |
| 71 | |
| 72 | --
|
| 73 | -- Table structure for table `devicetypes` |
| 74 | --
|
| 75 | |
| 76 | DROP TABLE IF EXISTS `devicetypes`; |
| 77 | /*!40101 SET @saved_cs_client = @@character_set_client */;
|
| 78 | /*!40101 SET character_set_client = utf8 */;
|
| 79 | CREATE TABLE `devicetypes` ( |
| 80 | `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT, |
| 81 | `name` varchar(32) DEFAULT NULL, |
| 82 | `description` varchar(32) DEFAULT NULL, |
| 83 | `type` varchar(32) DEFAULT NULL, |
| 84 | `addressformat` varchar(24) DEFAULT NULL, |
| 85 | PRIMARY KEY (`id`) |
| 86 | ) ENGINE=MyISAM AUTO_INCREMENT=107 DEFAULT CHARSET=latin1; |
| 87 | /*!40101 SET character_set_client = @saved_cs_client */;
|
| 88 | |
| 89 | --
|
| 90 | -- Dumping data for table `devicetypes` |
| 91 | --
|
| 92 | |
| 93 | LOCK TABLES `devicetypes` WRITE;
|
| 94 | /*!40000 ALTER TABLE `devicetypes` DISABLE KEYS */;
|
| 95 | INSERT INTO `devicetypes` VALUES (1,'Marmitek DS90','Door/Window Sensor','X10Security','DWS[256]S'),(2,'Marmitek LW10G','Lamp Module','X10','A1'),(3,'Marmitek LD11','Dimmer Module','X10','A1'),(4,'Marmitek MS13E M','Motion Sensor','X10','A1'),(5,'Marmitek MS13E L','Light Sensor','X10','A1'),(6,'Xanura SAX35','I/O Actor','A10','A1'),(7,'Oregon THGR238N','Temp/Hygro Sensor','Oregon','TH1[256]'),(8,'Oregon UV138','UV Light Sensor','Oregon','UV1[256]'),(9,'RFXPwr Module','Power Usage Sensor','RFXCom','RFXMETER[256]M'),(10,'Marmitek TM13','Wireless Tranceiver','X10','A1'),(11,'HDDTemp Item','Temp Monitor','HDDTemp','/dev/sda'),(12,'Oregon THR128','Temp Sensor','Oregon','TEMP1[256]'),(13,'Sony AIBO','Status AIBO','Ping','192.168.1.10'),(14,'APC SmartUPS1000','Power Supply','UPS','smartups1000'),(15,'Dallas DS18S20','Temp Sensor','1-Wire','1049023A01080011'),(16,'Dallas Rain Gauge','Rain Gauge','1-Wire','1D3AB905000000DB'),(17,'Marmitek SD90','Smoke Detector','X10Security','DWS[256]S'),(18,'Bluetooth Device','Phone','Bluetooth','00:1C:22:39:9D:31'),(19,'ITHO ECO Fan','Central Ventilation','Weeder','A'),(20,'RFXPulse Gas','Gas Usage Sensor','RFXCom','RFXMETER[256]M'),(21,'RFXPulse Water','Water Usage Sensor','RFXCom','RFXMETER[256]M'),(22,'Oregon BWR102','Digital Bathroom Scale','Oregon','WEIGHT1[1]'),(23,'Oregon GR101','Digital Bathroom Scale','Oregon','WEIGHT2[1]'),(24,'Oregon THC138','Temp Sensor','Oregon','TEMP1[256]'),(25,'Oregon THR138','Temp Sensor','Oregon','TEMP1[256]'),(26,'Oregon THGR810','Temp/Hygro Sensor','Oregon','TH2[256]'),(27,'Plugwise Circle','Zigbee Appliance Module','Plugwise','000D6F000021811A'),(28,'Plugwise Circle+','Zigbee Appliance Module','Plugwise','000D6F000021811A'),(29,'KAKU Chime','Wireless Doorbell','X10','C1'),(30,'Oregon THN132N','Temp Sensor','Oregon','TEMP2[256]'),(31,'Oregon THWR288','Temp Sensor','Oregon','TEMP2[256]'),(32,'Oregon BTHR918N','Baro/Temp/Hygro Sensor','Oregon','THB1[256]'),(33,'Oregon BTHR968','Baro/Temp/Hygro Sensor','Oregon','THB2[256]'),(34,'Marmitek AD10','Switch Module','X10','A1'),(35,'Marmitek LM12','Lamp Module','X10','A1'),(36,'Marmitek AM12','Appliance Module','X10','A1'),(37,'Oregon WGR918','Anemo Meter','Oregon','WIND3[256]'),(38,'Oregon PCR800','Rain Gauge','Oregon','RAIN2[256]'),(39,'Oregon RTGR328N','Temp/Hygro/Time Sensor','Oregon','TH3[256] & DT1[256]'),(40,'DSC PIR','Motion Sensor','DSC','Living'),(41,'DSC Contact','Door/Window Sensor','DSC','Backdoor'),(42,'DSC Smoke','Smoke Detector','DSC','Kitchen'),(43,'KAKU AWST-8802','Wireless Wallswitch Dual','HE','013B5A11'),(44,'KAKU AMST-606','Door/Window Sensor','HE','013B5A11'),(45,'KNX/EIB Dim','EIS 2','KNX/EIB','0/1/2'),(46,'KNX/EIB On/Off','EIS 1','KNX/EIB','0/1/2'),(47,'KNX/EIB Values','EIS 5','KNX/EIB','0/1/2'),(48,'KNX/EIB Date','EIS 4','KNX/EIB','0/1/2'),(49,'KNX/EIB Time','EIS 3','KNX/EIB','0/1/2'),(50,'KNX/EIB Scaling %','EIS 6','KNX/EIB','0/1/2'),(51,'KNX/EIB Motor Drives','EIS 7','KNX/EIB','0/1/2'),(52,'KNX/EIB Forced Control','EIS 8','KNX/EIB','0/1/2'),(53,'KNX/EIB 32bit Float','EIS 9','KNX/EIB','0/1/2'),(54,'KNX/EIB 16bit Int','EIS 10','KNX/EIB','0/1/2'),(55,'KNX/EIB 32bit Int','EIS 11','KNX/EIB','0/1/2'),(56,'KNX/EIB 8bit Int','EIS 14','KNX/EIB','0/1/2'),(57,'KNX/EIB 14byte Text','EIS 15','KNX/EIB','0/1/2'),(58,'Dallas DS2423','4Kbit RAM + Counter','1-Wire','1D3AB905000000DB'),(59,'KAKU PAR 1000','Appliance Module','ARC','A1'),(60,'KAKU AC-300','Dimmer Module','AC','A1'),(61,'Z-Wave Switch','Binary Switch','Z-Wave','1'),(62,'Z-Wave Dimmer','Multilevel Switch','Z-Wave','3'),(63,'Z-Wave D/W Sensor','Door/Window Sensor','Z-Wave','4'),(64,'Z-Wave PIR Sensor','Motion Sensor','Z-Wave','2'),(65,'Dallas DS2438','Smart Battery Monitor ','1-Wire','26D050E7000000FF'),(66,'Cent-a-Meter','Power Usage Sensor','Oregon','ELEC1[256]'),(67,'Marmitek DS10','Door/Window Sensor','X10Security','DWS[256]S'),(68,'Visonic MCT302','Door/Window Sensor','X10Security','REMOTE[256]S'),(69,'Marmitek MS90','Motion Sensor','X10Security','MOTION[256]S'),(70,'Marmitek KR10','Keychain Security Remote','X10Security','REMOTE[256]S'),(71,'Visonic MCT234','Security Remote KeyFob','X10Security','REMOTE[256]S'),(72,'Network Device','Status On/Off','Ping','192.168.1.10'),(73,'Network Host','Status Up/Down','Ping','192.168.1.10'),(74,'Oregon WTGR800','Anemo/Temp/Hygro Sensor','Oregon','TH5[256] & WIND1[256]'),(75,'Oregon BWR101','Digital Bathroom Scale','Oregon','WEIGHT1[1]'),(76,'OWL CM113','Power Usage Sensor','Oregon','ELEC1[256]'),(77,'Electrisave','Power Usage Sensor','Oregon','ELEC1[256]'),(78,'OWL CM119','Power Usage Sensor','Oregon','ELEC1[256]'),(79,'Oregon THC238','Temp Sensor Remote','Oregon','TEMP2[256]'),(80,'Oregon THC268','Temp Sensor Remote','Oregon','TEMP2[256]'),(81,'Oregon THN122N','Temp Sensor','Oregon','TEMP2[256]'),(82,'Oregon AW129','BBQ Thermometer','Oregon','TEMP2[256]'),(83,'Oregon AW131','BBQ Thermometer','Oregon','TEMP2[256]'),(84,'Oregon THWR800','Temp Sensor Floating','Oregon','TEMP3[256]'),(85,'Oregon RTHN318','Temp Sensor Outdoor','Oregon','TEMP4[256]'),(86,'Oregon THGN122N','Temp/Hygro Sensor','Oregon','TH1[256]'),(87,'Oregon THGN123N','Temp/Hygro Sensor','Oregon','TH1[256]'),(88,'Oregon THGR122N','Temp/Hygro Sensor','Oregon','TH1[256]'),(89,'Oregon THGR228N','Temp/Hygro Sensor','Oregon','TH1[256]'),(90,'Oregon THGR328N','Temp/Hygro Sensor','Oregon','TH1[256]'),(91,'Oregon THGR268','Temp/Hygro Sensor','Oregon','TH1[256]'),(92,'Oregon THGR918','Temp/Hygro Sensor Outdoor','Oregon','TH6[256]'),(93,'Oregon THGR228','Temp/Hygro Sensor Outdoor','Oregon','TH6[256]'),(94,'Oregon RGR126','Rain Gauge','Oregon','RAIN1[256]'),(95,'Oregon RGR682','Rain Gauge','Oregon','RAIN1[256]'),(96,'Oregon RGR918','Rain Gauge','Oregon','RAIN1[256]'),(97,'Oregon WGR800','Anemo Meter','Oregon','WIND2[256]'),(98,'Oregon UVR128','UV Light Sensor','Oregon','UV1[256]'),(99,'Oregon UVN800','UV Light Sensor','Oregon','UV2[256]'),(100,'RFXSensor Temp','Temp Sensor','RFXCom','RFXSENSOR[256]T'),(101,'RFXSensor A/D Sensor','A/D Sensor','RFXCom','RFXSENSOR[256]Z'),(102,'RFXSensor Voltage','Supply Voltage (Internal)','RFXCom','RFXSENSOR[256]V'),(103,'Marmitek SH624','Security Remote','X10Security','REMOTE[256]S'),(104,'Marmitek KR21','Keychain Security Remote','X10Security','REMOTE[256]S'),(105,'Visonic HP564','Security Remote KeyFob','X10Security','REMOTE[256]S'),(106,'Visonic MCT425','Smoke Detector','X10Security','REMOTE[256]S'); |
| 96 | /*!40000 ALTER TABLE `devicetypes` ENABLE KEYS */;
|
| 97 | UNLOCK TABLES; |
| 98 | /*!40103 SET TIME_ZONE=@OLD_TIME_ZONE */;
|
| 99 | |
| 100 | /*!40101 SET SQL_MODE=@OLD_SQL_MODE */;
|
| 101 | /*!40014 SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS */;
|
| 102 | /*!40014 SET UNIQUE_CHECKS=@OLD_UNIQUE_CHECKS */;
|
| 103 | /*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
|
| 104 | /*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */;
|
| 105 | /*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;
|
| 106 | /*!40111 SET SQL_NOTES=@OLD_SQL_NOTES */;
|
| 107 | |
| 108 | -- Dump completed on 2010-01-14 16:18:43
|