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 / 01158to01160.sql @ 465
History | View | Annotate | Download (9.6 kB)
| 1 | -- MySQL dump 10.11
|
|---|---|
| 2 | --
|
| 3 | -- Host: localhost Database: domotiga |
| 4 | -- ------------------------------------------------------
|
| 5 | -- Server version 5.0.51a-3ubuntu5.4
|
| 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 | -- Table structure for table `devicetypes` |
| 21 | --
|
| 22 | |
| 23 | DROP TABLE IF EXISTS `devicetypes`; |
| 24 | SET @saved_cs_client = @@character_set_client; |
| 25 | SET character_set_client = utf8;
|
| 26 | CREATE TABLE `devicetypes` ( |
| 27 | `id` bigint(20) unsigned NOT NULL auto_increment, |
| 28 | `name` varchar(32) default NULL, |
| 29 | `description` varchar(32) default NULL, |
| 30 | `type` varchar(32) default NULL, |
| 31 | PRIMARY KEY (`id`) |
| 32 | ) ENGINE=MyISAM AUTO_INCREMENT=29 DEFAULT CHARSET=latin1; |
| 33 | SET character_set_client = @saved_cs_client; |
| 34 | |
| 35 | --
|
| 36 | -- Dumping data for table `devicetypes` |
| 37 | --
|
| 38 | |
| 39 | LOCK TABLES `devicetypes` WRITE;
|
| 40 | /*!40000 ALTER TABLE `devicetypes` DISABLE KEYS */;
|
| 41 | INSERT INTO `devicetypes` VALUES (1,'Marmitek DS90','Door/Window Sensor','X10Security'),(2,'Marmitek LW10G','Lamp Module','X10'),(3,'Marmitek LD11','Lamp 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,'HWG TM751','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,'HP iPAQ 514','Phone','Bluetooth'),(19,'ITHO Fan on WTSSR','Central Ventilation','Weeder'),(20,'RFXPulse Module','Gas Usage Sensor','RFXCom'),(21,'RFXPulse Module','Water Usage Sensor','RFXCom'),(22,'Oregon BWR102','Digital Bathroom Scale','Oregon'),(23,'Oregon GR101','Digital Bathroom Scale','Oregon'),(24,'Oregon THR128','Temp Sensor','Oregon'),(25,'Oregon THx138','Temp Sensor','Oregon'),(26,'Oregon THGR810','Temp/Hygro Sensor','Oregon'),(27,'Plugwise Circle','Zigbee Appliance Module','Plugwise'),(28,'Plugwise Circle+','Zigbee Appliance Module','Plugwise'); |
| 42 | /*!40000 ALTER TABLE `devicetypes` ENABLE KEYS */;
|
| 43 | UNLOCK TABLES; |
| 44 | |
| 45 | --
|
| 46 | -- Table structure for table `interfaces` |
| 47 | --
|
| 48 | |
| 49 | DROP TABLE IF EXISTS `interfaces`; |
| 50 | SET @saved_cs_client = @@character_set_client; |
| 51 | SET character_set_client = utf8;
|
| 52 | CREATE TABLE `interfaces` ( |
| 53 | `id` bigint(20) unsigned NOT NULL auto_increment, |
| 54 | `name` varchar(32) default NULL, |
| 55 | `type` varchar(32) default NULL, |
| 56 | `mode` varchar(32) default NULL, |
| 57 | PRIMARY KEY (`id`) |
| 58 | ) ENGINE=MyISAM AUTO_INCREMENT=11 DEFAULT CHARSET=latin1; |
| 59 | SET character_set_client = @saved_cs_client; |
| 60 | |
| 61 | --
|
| 62 | -- Dumping data for table `interfaces` |
| 63 | --
|
| 64 | |
| 65 | LOCK TABLES `interfaces` WRITE;
|
| 66 | /*!40000 ALTER TABLE `interfaces` DISABLE KEYS */;
|
| 67 | 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'); |
| 68 | /*!40000 ALTER TABLE `interfaces` ENABLE KEYS */;
|
| 69 | UNLOCK TABLES; |
| 70 | |
| 71 | --
|
| 72 | -- Table structure for table `settings_plugwise` |
| 73 | --
|
| 74 | |
| 75 | DROP TABLE IF EXISTS `settings_plugwise`; |
| 76 | SET @saved_cs_client = @@character_set_client; |
| 77 | SET character_set_client = utf8;
|
| 78 | CREATE TABLE `settings_plugwise` ( |
| 79 | `id` int(11) NOT NULL, |
| 80 | `enabled` tinyint(1) default NULL, |
| 81 | `serialport` varchar(32) default NULL, |
| 82 | `polltime` int(11) default NULL, |
| 83 | `debug` tinyint(1) default NULL, |
| 84 | PRIMARY KEY (`id`) |
| 85 | ) ENGINE=MyISAM DEFAULT CHARSET=latin1; |
| 86 | SET character_set_client = @saved_cs_client; |
| 87 | |
| 88 | --
|
| 89 | -- Dumping data for table `settings_plugwise` |
| 90 | --
|
| 91 | |
| 92 | LOCK TABLES `settings_plugwise` WRITE;
|
| 93 | /*!40000 ALTER TABLE `settings_plugwise` DISABLE KEYS */;
|
| 94 | INSERT INTO `settings_plugwise` VALUES (0,1,'/dev/ttyUSB7',300,1),(1,0,'/dev/ttyUSB7',300,-1); |
| 95 | /*!40000 ALTER TABLE `settings_plugwise` ENABLE KEYS */;
|
| 96 | UNLOCK TABLES; |
| 97 | /*!40103 SET TIME_ZONE=@OLD_TIME_ZONE */;
|
| 98 | |
| 99 | /*!40101 SET SQL_MODE=@OLD_SQL_MODE */;
|
| 100 | /*!40014 SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS */;
|
| 101 | /*!40014 SET UNIQUE_CHECKS=@OLD_UNIQUE_CHECKS */;
|
| 102 | /*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
|
| 103 | /*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */;
|
| 104 | /*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;
|
| 105 | /*!40111 SET SQL_NOTES=@OLD_SQL_NOTES */;
|
| 106 | |
| 107 | -- Dump completed on 2008-12-14 21:18:13
|
| 108 | -- MySQL dump 10.11
|
| 109 | --
|
| 110 | -- Host: localhost Database: domotiga |
| 111 | -- ------------------------------------------------------
|
| 112 | -- Server version 5.0.51a-3ubuntu5.4
|
| 113 | |
| 114 | /*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
|
| 115 | /*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
|
| 116 | /*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;
|
| 117 | /*!40101 SET NAMES utf8 */;
|
| 118 | /*!40103 SET @OLD_TIME_ZONE=@@TIME_ZONE */;
|
| 119 | /*!40103 SET TIME_ZONE='+00:00' */;
|
| 120 | /*!40014 SET @OLD_UNIQUE_CHECKS=@@UNIQUE_CHECKS, UNIQUE_CHECKS=0 */;
|
| 121 | /*!40014 SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0 */;
|
| 122 | /*!40101 SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='NO_AUTO_VALUE_ON_ZERO' */;
|
| 123 | /*!40111 SET @OLD_SQL_NOTES=@@SQL_NOTES, SQL_NOTES=0 */;
|
| 124 | |
| 125 | --
|
| 126 | -- Table structure for table `devices` |
| 127 | --
|
| 128 | |
| 129 | ALTER TABLE `devices` ADD COLUMN `value3` varchar(32) default NULL AFTER value2; |
| 130 | ALTER TABLE `devices` ADD COLUMN `label3` varchar(32) default NULL AFTER label2; |
| 131 | ALTER TABLE `devices` ADD COLUMN `value3rrddsname` varchar(32) default NULL AFTER value2rrddsname; |
| 132 | ALTER TABLE `devices` ADD COLUMN `value3rrdtype` varchar(32) default NULL AFTER value2rrdtype; |
| 133 | |
| 134 | /*!40000 ALTER TABLE `devices` ENABLE KEYS */;
|
| 135 | UNLOCK TABLES; |
| 136 | /*!40103 SET TIME_ZONE=@OLD_TIME_ZONE */;
|
| 137 | |
| 138 | /*!40101 SET SQL_MODE=@OLD_SQL_MODE */;
|
| 139 | /*!40014 SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS */;
|
| 140 | /*!40014 SET UNIQUE_CHECKS=@OLD_UNIQUE_CHECKS */;
|
| 141 | /*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
|
| 142 | /*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */;
|
| 143 | /*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;
|
| 144 | /*!40111 SET SQL_NOTES=@OLD_SQL_NOTES */;
|
| 145 | |
| 146 | -- Dump completed on 2008-12-14 21:19:27
|
| 147 | -- MySQL dump 10.11
|
| 148 | --
|
| 149 | -- Host: localhost Database: domotiga |
| 150 | -- ------------------------------------------------------
|
| 151 | -- Server version 5.0.51a-3ubuntu5.4
|
| 152 | |
| 153 | /*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
|
| 154 | /*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
|
| 155 | /*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;
|
| 156 | /*!40101 SET NAMES utf8 */;
|
| 157 | /*!40103 SET @OLD_TIME_ZONE=@@TIME_ZONE */;
|
| 158 | /*!40103 SET TIME_ZONE='+00:00' */;
|
| 159 | /*!40014 SET @OLD_UNIQUE_CHECKS=@@UNIQUE_CHECKS, UNIQUE_CHECKS=0 */;
|
| 160 | /*!40014 SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0 */;
|
| 161 | /*!40101 SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='NO_AUTO_VALUE_ON_ZERO' */;
|
| 162 | /*!40111 SET @OLD_SQL_NOTES=@@SQL_NOTES, SQL_NOTES=0 */;
|
| 163 | |
| 164 | --
|
| 165 | -- Table structure for table `settings_fritzbox` |
| 166 | --
|
| 167 | |
| 168 | DROP TABLE IF EXISTS `settings_fritzbox`; |
| 169 | SET @saved_cs_client = @@character_set_client; |
| 170 | SET character_set_client = utf8;
|
| 171 | CREATE TABLE `settings_fritzbox` ( |
| 172 | `id` int(11) NOT NULL, |
| 173 | `enabled` tinyint(1) default NULL, |
| 174 | `tcphost` varchar(32) default NULL, |
| 175 | `debug` tinyint(1) default NULL, |
| 176 | PRIMARY KEY (`id`) |
| 177 | ) ENGINE=MyISAM DEFAULT CHARSET=latin1; |
| 178 | SET character_set_client = @saved_cs_client; |
| 179 | |
| 180 | --
|
| 181 | -- Dumping data for table `settings_fritzbox` |
| 182 | --
|
| 183 | |
| 184 | LOCK TABLES `settings_fritzbox` WRITE;
|
| 185 | /*!40000 ALTER TABLE `settings_fritzbox` DISABLE KEYS */;
|
| 186 | INSERT INTO `settings_fritzbox` VALUES (0,0,'192.168.100.1',1),(1,0,'192.168.100.1',-1); |
| 187 | /*!40000 ALTER TABLE `settings_fritzbox` ENABLE KEYS */;
|
| 188 | |
| 189 | UPDATE devicetypes SET name = "RFXPulse Gas" WHERE id = 20; |
| 190 | UPDATE devicetypes SET name = "RFXPulse Water" WHERE id = 21; |
| 191 | |
| 192 | --
|
| 193 | -- Table structure for table `power_usage` |
| 194 | --
|
| 195 | ALTER TABLE `power_usage` CHANGE `watt` `usage` bigint(20) default NULL; |
| 196 | |
| 197 | /*!40000 ALTER TABLE `power_usage` ENABLE KEYS */;
|
| 198 | |
| 199 | CREATE TABLE `gas_usage` ( |
| 200 | `id` bigint(20) unsigned NOT NULL auto_increment, |
| 201 | `counter` bigint(20) default NULL, |
| 202 | `stamp` datetime default NULL, |
| 203 | `usage` bigint(20) default NULL, |
| 204 | PRIMARY KEY (`id`) |
| 205 | ) ENGINE=MyISAM AUTO_INCREMENT=1 DEFAULT CHARSET=latin1; |
| 206 | |
| 207 | CREATE TABLE `water_usage` ( |
| 208 | `id` bigint(20) unsigned NOT NULL auto_increment, |
| 209 | `counter` bigint(20) default NULL, |
| 210 | `stamp` datetime default NULL, |
| 211 | `usage` bigint(20) default NULL, |
| 212 | PRIMARY KEY (`id`) |
| 213 | ) ENGINE=MyISAM AUTO_INCREMENT=1 DEFAULT CHARSET=latin1; |
| 214 | |
| 215 | UNLOCK TABLES; |
| 216 | /*!40103 SET TIME_ZONE=@OLD_TIME_ZONE */;
|
| 217 | |
| 218 | /*!40101 SET SQL_MODE=@OLD_SQL_MODE */;
|
| 219 | /*!40014 SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS */;
|
| 220 | /*!40014 SET UNIQUE_CHECKS=@OLD_UNIQUE_CHECKS */;
|
| 221 | /*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
|
| 222 | /*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */;
|
| 223 | /*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;
|
| 224 | /*!40111 SET SQL_NOTES=@OLD_SQL_NOTES */;
|
| 225 | |
| 226 | -- Dump completed on 2008-12-30 14:05:50
|