1 -- MySQL dump 10.13 Distrib 5.5.50, for debian-linux-gnu (x86_64)
3 -- Host: localhost Database: power
4 -- ------------------------------------------------------
5 -- Server version 5.5.50-0+deb7u2
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 */;
19 -- Table structure for table `circuits`
22 DROP TABLE IF EXISTS `circuits`;
23 /*!40101 SET @saved_cs_client = @@character_set_client */;
24 /*!40101 SET character_set_client = utf8 */;
25 CREATE TABLE `circuits` (
26 `circuit_id` smallint(6) NOT NULL AUTO_INCREMENT,
27 `name` varchar(50) DEFAULT NULL,
28 `device_id` smallint(6) DEFAULT NULL,
29 `alias` varchar(50) DEFAULT NULL,
30 `amps` smallint(6) DEFAULT NULL,
31 PRIMARY KEY (`circuit_id`)
32 ) ENGINE=InnoDB AUTO_INCREMENT=36 DEFAULT CHARSET=utf8;
33 /*!40101 SET character_set_client = @saved_cs_client */;
36 -- Table structure for table `device_log`
39 DROP TABLE IF EXISTS `device_log`;
40 /*!40101 SET @saved_cs_client = @@character_set_client */;
41 /*!40101 SET character_set_client = utf8 */;
42 CREATE TABLE `device_log` (
43 `time` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
44 `SN` varchar(50) DEFAULT NULL,
45 `alias` varchar(50) DEFAULT NULL,
46 `V` smallint(6) DEFAULT NULL,
47 `c1` varchar(50) DEFAULT NULL,
48 `c2` varchar(50) DEFAULT NULL,
49 `c3` varchar(50) DEFAULT NULL,
50 `c4` varchar(50) DEFAULT NULL,
51 `c5` varchar(50) DEFAULT NULL,
52 `c6` varchar(50) DEFAULT NULL,
53 `c7` varchar(50) DEFAULT NULL,
54 `c8` varchar(50) DEFAULT NULL,
55 `c9` varchar(50) DEFAULT NULL,
56 `c10` varchar(50) DEFAULT NULL,
57 `c11` varchar(50) DEFAULT NULL,
58 `c12` varchar(50) DEFAULT NULL,
59 `c13` varchar(50) DEFAULT NULL,
60 `c14` varchar(50) DEFAULT NULL,
61 `c15` varchar(50) DEFAULT NULL,
62 `c16` varchar(50) DEFAULT NULL,
63 `c17` varchar(50) DEFAULT NULL,
64 `c18` varchar(50) DEFAULT NULL,
65 `c19` varchar(50) DEFAULT NULL,
66 `c20` varchar(50) DEFAULT NULL,
67 `c21` varchar(50) DEFAULT NULL,
68 `c22` varchar(50) DEFAULT NULL,
69 `c23` varchar(50) DEFAULT NULL,
70 `c24` varchar(50) DEFAULT NULL,
71 `c25` varchar(50) DEFAULT NULL,
72 `c26` varchar(50) DEFAULT NULL,
73 `c27` varchar(50) DEFAULT NULL,
74 `c28` varchar(50) DEFAULT NULL,
75 `c29` varchar(50) DEFAULT NULL,
76 `c30` varchar(50) DEFAULT NULL,
77 `c31` varchar(50) DEFAULT NULL,
78 `c32` varchar(50) DEFAULT NULL,
80 ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
81 /*!40101 SET character_set_client = @saved_cs_client */;
84 -- Table structure for table `devices`
87 DROP TABLE IF EXISTS `devices`;
88 /*!40101 SET @saved_cs_client = @@character_set_client */;
89 /*!40101 SET character_set_client = utf8 */;
90 CREATE TABLE `devices` (
91 `device_id` smallint(6) NOT NULL AUTO_INCREMENT,
92 `SN` varchar(50) DEFAULT NULL,
93 `alias` varchar(50) DEFAULT NULL,
94 `V` smallint(6) DEFAULT NULL,
95 `c1` varchar(50) DEFAULT NULL,
96 `c2` varchar(50) DEFAULT NULL,
97 `c3` varchar(50) DEFAULT NULL,
98 `c4` varchar(50) DEFAULT NULL,
99 `c5` varchar(50) DEFAULT NULL,
100 `c6` varchar(50) DEFAULT NULL,
101 `c7` varchar(50) DEFAULT NULL,
102 `c8` varchar(50) DEFAULT NULL,
103 `c9` varchar(50) DEFAULT NULL,
104 `c10` varchar(50) DEFAULT NULL,
105 `c11` varchar(50) DEFAULT NULL,
106 `c12` varchar(50) DEFAULT NULL,
107 `c13` varchar(50) DEFAULT NULL,
108 `c14` varchar(50) DEFAULT NULL,
109 `c15` varchar(50) DEFAULT NULL,
110 `c16` varchar(50) DEFAULT NULL,
111 `c17` varchar(50) DEFAULT NULL,
112 `c18` varchar(50) DEFAULT NULL,
113 `c19` varchar(50) DEFAULT NULL,
114 `c20` varchar(50) DEFAULT NULL,
115 `c21` varchar(50) DEFAULT NULL,
116 `c22` varchar(50) DEFAULT NULL,
117 `c23` varchar(50) DEFAULT NULL,
118 `c24` varchar(50) DEFAULT NULL,
119 `c25` varchar(50) DEFAULT NULL,
120 `c26` varchar(50) DEFAULT NULL,
121 `c27` varchar(50) DEFAULT NULL,
122 `c28` varchar(50) DEFAULT NULL,
123 `c29` varchar(50) DEFAULT NULL,
124 `c30` varchar(50) DEFAULT NULL,
125 `c31` varchar(50) DEFAULT NULL,
126 `c32` varchar(50) DEFAULT NULL,
127 PRIMARY KEY (`device_id`)
128 ) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8;
129 /*!40101 SET character_set_client = @saved_cs_client */;
130 /*!40103 SET TIME_ZONE=@OLD_TIME_ZONE */;
132 /*!40101 SET SQL_MODE=@OLD_SQL_MODE */;
133 /*!40014 SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS */;
134 /*!40014 SET UNIQUE_CHECKS=@OLD_UNIQUE_CHECKS */;
135 /*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
136 /*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */;
137 /*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;
138 /*!40111 SET SQL_NOTES=@OLD_SQL_NOTES */;
140 -- Dump completed on 2017-04-18 8:32:12