· 7 years ago · Nov 20, 2018, 11:40 AM
1-- MySQL dump 10.16 Distrib 10.1.37-MariaDB, for Linux (x86_64)
2--
3-- Host: localhost Database: innohabit
4-- ------------------------------------------------------
5-- Server version 10.1.37-MariaDB
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--
19-- Table structure for table `battery`
20--
21
22DROP TABLE IF EXISTS `battery`;
23/*!40101 SET @saved_cs_client = @@character_set_client */;
24/*!40101 SET character_set_client = utf8 */;
25CREATE TABLE `battery` (
26 `batteryId` int(50) NOT NULL AUTO_INCREMENT,
27 `batteryBin` varchar(50) NOT NULL,
28 `batteryCapacity` int(1) NOT NULL,
29 `batteryCommissioned` date DEFAULT NULL,
30 `batteryWarranty` int(50) NOT NULL,
31 `batteryCurrent` int(50) NOT NULL,
32 `batteryModel` varchar(10) NOT NULL,
33 `status` int(1) NOT NULL,
34 `createdBy` text,
35 `updatedBy` text,
36 `updatedOn` date DEFAULT NULL,
37 `createdOn` date DEFAULT NULL,
38 PRIMARY KEY (`batteryId`)
39) ENGINE=InnoDB AUTO_INCREMENT=25 DEFAULT CHARSET=latin1;
40/*!40101 SET character_set_client = @saved_cs_client */;
41
42--
43-- Dumping data for table `battery`
44--
45
46LOCK TABLES `battery` WRITE;
47/*!40000 ALTER TABLE `battery` DISABLE KEYS */;
48INSERT INTO `battery` VALUES (19,'1223',333,'2018-11-25',18,10,'Tesla',1,NULL,NULL,NULL,NULL),(22,'83429',1324,'2018-11-21',24,10,'Tesla',1,NULL,NULL,NULL,NULL),(23,'23982',300,NULL,24,10,'Tesla',1,NULL,NULL,NULL,NULL),(24,'12342',300,NULL,24,10,'Tesla',1,NULL,NULL,NULL,NULL);
49/*!40000 ALTER TABLE `battery` ENABLE KEYS */;
50UNLOCK TABLES;
51
52--
53-- Table structure for table `battery_session`
54--
55
56DROP TABLE IF EXISTS `battery_session`;
57/*!40101 SET @saved_cs_client = @@character_set_client */;
58/*!40101 SET character_set_client = utf8 */;
59CREATE TABLE `battery_session` (
60 `batterySessionID` int(50) NOT NULL AUTO_INCREMENT,
61 `batteryLog` varchar(50) NOT NULL,
62 `logID` int(50) NOT NULL,
63 `vehicleID` int(50) DEFAULT NULL,
64 `batteryID` int(11) NOT NULL,
65 `stationID` int(50) DEFAULT NULL,
66 `batterySOC` int(11) DEFAULT NULL,
67 `status` int(11) NOT NULL,
68 PRIMARY KEY (`batterySessionID`),
69 KEY `vehicleID` (`vehicleID`),
70 KEY `batteryID` (`batteryID`),
71 KEY `stationID` (`stationID`),
72 CONSTRAINT `battery_session_ibfk_4` FOREIGN KEY (`vehicleID`) REFERENCES `vehicle` (`vehicleId`) ON DELETE CASCADE,
73 CONSTRAINT `battery_session_ibfk_5` FOREIGN KEY (`batteryID`) REFERENCES `battery` (`batteryId`) ON DELETE CASCADE,
74 CONSTRAINT `battery_session_ibfk_6` FOREIGN KEY (`stationID`) REFERENCES `station` (`stationId`) ON DELETE CASCADE
75) ENGINE=InnoDB AUTO_INCREMENT=17 DEFAULT CHARSET=latin1;
76/*!40101 SET character_set_client = @saved_cs_client */;
77
78--
79-- Dumping data for table `battery_session`
80--
81
82LOCK TABLES `battery_session` WRITE;
83/*!40000 ALTER TABLE `battery_session` DISABLE KEYS */;
84INSERT INTO `battery_session` VALUES (11,'',0,17,19,NULL,80,1),(14,'',0,NULL,22,NULL,NULL,1),(15,'',0,NULL,23,NULL,NULL,0),(16,'',0,NULL,24,NULL,NULL,0);
85/*!40000 ALTER TABLE `battery_session` ENABLE KEYS */;
86UNLOCK TABLES;
87
88--
89-- Table structure for table `station`
90--
91
92DROP TABLE IF EXISTS `station`;
93/*!40101 SET @saved_cs_client = @@character_set_client */;
94/*!40101 SET character_set_client = utf8 */;
95CREATE TABLE `station` (
96 `stationId` int(50) NOT NULL AUTO_INCREMENT,
97 `stationName` text NOT NULL,
98 `stationOwner` text NOT NULL,
99 `stationCommissionedOn` date DEFAULT NULL,
100 `stationLat` int(20) NOT NULL,
101 `stationLong` int(20) NOT NULL,
102 `status` int(1) NOT NULL,
103 `createdOn` date DEFAULT NULL,
104 `createdBy` text,
105 `updatedOn` date DEFAULT NULL,
106 `updatedBy` text,
107 PRIMARY KEY (`stationId`)
108) ENGINE=InnoDB AUTO_INCREMENT=9 DEFAULT CHARSET=latin1;
109/*!40101 SET character_set_client = @saved_cs_client */;
110
111--
112-- Dumping data for table `station`
113--
114
115LOCK TABLES `station` WRITE;
116/*!40000 ALTER TABLE `station` DISABLE KEYS */;
117INSERT INTO `station` VALUES (4,'Super chargers','Ambani','2018-11-19',30,40,1,NULL,NULL,NULL,NULL),(5,'Super chargers','Ambani','2018-11-04',32,52,1,NULL,NULL,NULL,NULL),(6,'Super chargers','Ambani','2018-11-09',92,12,1,NULL,NULL,NULL,NULL),(8,'Super chargers','Ambani','2018-11-26',23,32,1,NULL,NULL,NULL,NULL);
118/*!40000 ALTER TABLE `station` ENABLE KEYS */;
119UNLOCK TABLES;
120
121--
122-- Table structure for table `station_session`
123--
124
125DROP TABLE IF EXISTS `station_session`;
126/*!40101 SET @saved_cs_client = @@character_set_client */;
127/*!40101 SET character_set_client = utf8 */;
128CREATE TABLE `station_session` (
129 `stationLog` int(50) NOT NULL,
130 `stationSessionID` int(50) NOT NULL AUTO_INCREMENT,
131 `oldBatteryID1` int(50) DEFAULT NULL,
132 `oldBatteryID2` int(50) DEFAULT NULL,
133 `userID` int(50) DEFAULT NULL,
134 `vehicleID` int(50) DEFAULT NULL,
135 `acceptedStatus` int(2) NOT NULL,
136 `newBatteryID1` int(50) DEFAULT NULL,
137 `newBatteryID2` int(50) DEFAULT NULL,
138 `swipeStatus` int(2) NOT NULL,
139 `swipeDate` datetime(6) NOT NULL,
140 `initiatePaymentStatus` int(2) NOT NULL,
141 `initiatePaymentDate` datetime(6) NOT NULL,
142 `paymentAmount` int(100) NOT NULL,
143 `paymentModeID` int(50) NOT NULL,
144 `stationID` int(50) DEFAULT NULL,
145 PRIMARY KEY (`stationSessionID`),
146 KEY `oldBatteryID1` (`oldBatteryID1`),
147 KEY `oldBatteryID2` (`oldBatteryID2`),
148 KEY `newBatteryID1` (`newBatteryID1`),
149 KEY `newBatteryID2` (`newBatteryID2`),
150 KEY `vehicleID` (`vehicleID`),
151 KEY `userID` (`userID`),
152 KEY `stationID` (`stationID`),
153 CONSTRAINT `station_session_ibfk_10` FOREIGN KEY (`stationID`) REFERENCES `station` (`stationId`) ON DELETE CASCADE,
154 CONSTRAINT `station_session_ibfk_11` FOREIGN KEY (`oldBatteryID1`) REFERENCES `battery` (`batteryId`) ON DELETE CASCADE,
155 CONSTRAINT `station_session_ibfk_12` FOREIGN KEY (`oldBatteryID2`) REFERENCES `battery` (`batteryId`) ON DELETE CASCADE,
156 CONSTRAINT `station_session_ibfk_13` FOREIGN KEY (`newBatteryID1`) REFERENCES `battery` (`batteryId`) ON DELETE CASCADE,
157 CONSTRAINT `station_session_ibfk_14` FOREIGN KEY (`newBatteryID2`) REFERENCES `battery` (`batteryId`) ON DELETE CASCADE,
158 CONSTRAINT `station_session_ibfk_15` FOREIGN KEY (`vehicleID`) REFERENCES `vehicle` (`vehicleId`) ON DELETE CASCADE,
159 CONSTRAINT `station_session_ibfk_16` FOREIGN KEY (`userID`) REFERENCES `user` (`userId`) ON DELETE CASCADE
160) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=latin1;
161/*!40101 SET character_set_client = @saved_cs_client */;
162
163--
164-- Dumping data for table `station_session`
165--
166
167LOCK TABLES `station_session` WRITE;
168/*!40000 ALTER TABLE `station_session` DISABLE KEYS */;
169/*!40000 ALTER TABLE `station_session` ENABLE KEYS */;
170UNLOCK TABLES;
171
172--
173-- Table structure for table `user`
174--
175
176DROP TABLE IF EXISTS `user`;
177/*!40101 SET @saved_cs_client = @@character_set_client */;
178/*!40101 SET character_set_client = utf8 */;
179CREATE TABLE `user` (
180 `userId` int(50) NOT NULL AUTO_INCREMENT,
181 `userName` text NOT NULL,
182 `userMobileNumber` varchar(15) NOT NULL,
183 `userRole` int(50) NOT NULL,
184 `userDeviceID` varchar(50) DEFAULT NULL,
185 `userFCMToken` varchar(50) DEFAULT NULL,
186 `userPassword` varchar(50) DEFAULT NULL,
187 `status` int(1) NOT NULL,
188 `createdOn` date DEFAULT NULL,
189 `createdBy` text,
190 `updatedBy` text,
191 `updatedOn` date DEFAULT NULL,
192 PRIMARY KEY (`userId`),
193 KEY `user` (`userRole`),
194 CONSTRAINT `user` FOREIGN KEY (`userRole`) REFERENCES `user_role` (`roleId`) ON DELETE CASCADE
195) ENGINE=InnoDB AUTO_INCREMENT=10 DEFAULT CHARSET=latin1;
196/*!40101 SET character_set_client = @saved_cs_client */;
197
198--
199-- Dumping data for table `user`
200--
201
202LOCK TABLES `user` WRITE;
203/*!40000 ALTER TABLE `user` DISABLE KEYS */;
204/*!40000 ALTER TABLE `user` ENABLE KEYS */;
205UNLOCK TABLES;
206
207--
208-- Table structure for table `user_role`
209--
210
211DROP TABLE IF EXISTS `user_role`;
212/*!40101 SET @saved_cs_client = @@character_set_client */;
213/*!40101 SET character_set_client = utf8 */;
214CREATE TABLE `user_role` (
215 `roleId` int(50) NOT NULL,
216 `roleName` varchar(50) NOT NULL,
217 `status` int(2) NOT NULL,
218 `createdOn` date DEFAULT NULL,
219 `createdBy` text,
220 `updatedOn` date DEFAULT NULL,
221 `updatedBy` text,
222 PRIMARY KEY (`roleId`)
223) ENGINE=InnoDB DEFAULT CHARSET=latin1;
224/*!40101 SET character_set_client = @saved_cs_client */;
225
226--
227-- Dumping data for table `user_role`
228--
229
230LOCK TABLES `user_role` WRITE;
231/*!40000 ALTER TABLE `user_role` DISABLE KEYS */;
232INSERT INTO `user_role` VALUES (1,'Senior',1,NULL,NULL,NULL,NULL),(2,'Junior',1,NULL,NULL,NULL,NULL),(3,'Manager',1,NULL,NULL,NULL,NULL);
233/*!40000 ALTER TABLE `user_role` ENABLE KEYS */;
234UNLOCK TABLES;
235
236--
237-- Table structure for table `vehicle`
238--
239
240DROP TABLE IF EXISTS `vehicle`;
241/*!40101 SET @saved_cs_client = @@character_set_client */;
242/*!40101 SET character_set_client = utf8 */;
243CREATE TABLE `vehicle` (
244 `vehicleId` int(50) NOT NULL AUTO_INCREMENT,
245 `vehicleVIN` int(50) NOT NULL,
246 `vehicleOwner` text NOT NULL,
247 `vehicleModel` varchar(50) NOT NULL,
248 `vehicleCommissionedOn` date DEFAULT NULL,
249 `status` int(1) NOT NULL,
250 `updatedBy` text,
251 `updatedOn` date DEFAULT NULL,
252 `createdBy` text,
253 `createdOn` date DEFAULT NULL,
254 PRIMARY KEY (`vehicleId`)
255) ENGINE=InnoDB AUTO_INCREMENT=24 DEFAULT CHARSET=latin1;
256/*!40101 SET character_set_client = @saved_cs_client */;
257
258--
259-- Dumping data for table `vehicle`
260--
261
262LOCK TABLES `vehicle` WRITE;
263/*!40000 ALTER TABLE `vehicle` DISABLE KEYS */;
264INSERT INTO `vehicle` VALUES (17,8235,'Annonymous','Honda','2018-11-11',1,NULL,NULL,NULL,NULL),(18,1234,'Annonymous','Honda','2018-11-14',1,NULL,NULL,NULL,NULL),(19,983,'Annonymous','Honda','2018-11-18',1,NULL,NULL,NULL,NULL),(22,91328,'Fibonacci','Kdjad','2018-11-14',1,NULL,NULL,NULL,NULL);
265/*!40000 ALTER TABLE `vehicle` ENABLE KEYS */;
266UNLOCK TABLES;
267/*!40103 SET TIME_ZONE=@OLD_TIME_ZONE */;
268
269/*!40101 SET SQL_MODE=@OLD_SQL_MODE */;
270/*!40014 SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS */;
271/*!40014 SET UNIQUE_CHECKS=@OLD_UNIQUE_CHECKS */;
272/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
273/*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */;
274/*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;
275/*!40111 SET SQL_NOTES=@OLD_SQL_NOTES */;
276
277-- Dump completed on 2018-11-20 17:05:00