· 8 years ago · Feb 26, 2018, 08:58 AM
1CREATE DATABASE IF NOT EXISTS `idriveapp` /*!40100 DEFAULT CHARACTER SET utf8 */;
2USE `idriveapp`;
3-- MySQL dump 10.13 Distrib 5.7.12, for Win64 (x86_64)
4--
5-- Host: localhost Database: idriveapp
6-- ------------------------------------------------------
7-- Server version 5.7.16-log
8
9/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
10/*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
11/*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;
12/*!40101 SET NAMES utf8 */;
13/*!40103 SET @OLD_TIME_ZONE=@@TIME_ZONE */;
14/*!40103 SET TIME_ZONE='+00:00' */;
15/*!40014 SET @OLD_UNIQUE_CHECKS=@@UNIQUE_CHECKS, UNIQUE_CHECKS=0 */;
16/*!40014 SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0 */;
17/*!40101 SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='NO_AUTO_VALUE_ON_ZERO' */;
18/*!40111 SET @OLD_SQL_NOTES=@@SQL_NOTES, SQL_NOTES=0 */;
19
20--
21-- Table structure for table `ac_log`
22--
23
24DROP TABLE IF EXISTS `ac_log`;
25/*!40101 SET @saved_cs_client = @@character_set_client */;
26/*!40101 SET character_set_client = utf8 */;
27CREATE TABLE `ac_log` (
28 `log_id` int(11) NOT NULL,
29 `lg_date` date NOT NULL,
30 `lg_type` int(11) NOT NULL,
31 `lg_activity` varchar(45) NOT NULL,
32 `id_number` varchar(45) NOT NULL,
33 PRIMARY KEY (`log_id`,`id_number`,`lg_date`,`lg_type`,`lg_activity`)
34) ENGINE=InnoDB DEFAULT CHARSET=utf8;
35/*!40101 SET character_set_client = @saved_cs_client */;
36
37--
38-- Dumping data for table `ac_log`
39--
40
41LOCK TABLES `ac_log` WRITE;
42/*!40000 ALTER TABLE `ac_log` DISABLE KEYS */;
43/*!40000 ALTER TABLE `ac_log` ENABLE KEYS */;
44UNLOCK TABLES;
45
46--
47-- Table structure for table `col_location`
48--
49
50DROP TABLE IF EXISTS `col_location`;
51/*!40101 SET @saved_cs_client = @@character_set_client */;
52/*!40101 SET character_set_client = utf8 */;
53CREATE TABLE `col_location` (
54 `loc_id` int(11) NOT NULL,
55 `loc_name` varchar(45) DEFAULT NULL,
56 `loc_short` varchar(45) DEFAULT NULL,
57 `loc_email` varchar(45) DEFAULT NULL,
58 `loc_phone` varchar(45) DEFAULT NULL,
59 `loc_code` varchar(45) DEFAULT NULL,
60 PRIMARY KEY (`loc_id`)
61) ENGINE=InnoDB DEFAULT CHARSET=utf8;
62/*!40101 SET character_set_client = @saved_cs_client */;
63
64--
65-- Dumping data for table `col_location`
66--
67
68LOCK TABLES `col_location` WRITE;
69/*!40000 ALTER TABLE `col_location` DISABLE KEYS */;
70/*!40000 ALTER TABLE `col_location` ENABLE KEYS */;
71UNLOCK TABLES;
72
73--
74-- Table structure for table `collection`
75--
76
77DROP TABLE IF EXISTS `collection`;
78/*!40101 SET @saved_cs_client = @@character_set_client */;
79/*!40101 SET character_set_client = utf8 */;
80CREATE TABLE `collection` (
81 `col_id` int(11) NOT NULL,
82 `col_type` varchar(45) DEFAULT NULL,
83 `col_fee` decimal(10,2) DEFAULT NULL,
84 `col_status` int(11) DEFAULT NULL,
85 PRIMARY KEY (`col_id`)
86) ENGINE=InnoDB DEFAULT CHARSET=utf8;
87/*!40101 SET character_set_client = @saved_cs_client */;
88
89--
90-- Dumping data for table `collection`
91--
92
93LOCK TABLES `collection` WRITE;
94/*!40000 ALTER TABLE `collection` DISABLE KEYS */;
95/*!40000 ALTER TABLE `collection` ENABLE KEYS */;
96UNLOCK TABLES;
97
98--
99-- Table structure for table `history`
100--
101
102DROP TABLE IF EXISTS `history`;
103/*!40101 SET @saved_cs_client = @@character_set_client */;
104/*!40101 SET character_set_client = utf8 */;
105CREATE TABLE `history` (
106 `hist_id` int(11) NOT NULL,
107 `vrn` varchar(45) DEFAULT NULL,
108 `id_number` varchar(45) DEFAULT NULL,
109 `log_type` varchar(45) DEFAULT NULL,
110 `ins_type` varchar(45) DEFAULT NULL,
111 `ins_period` int(11) DEFAULT NULL,
112 `zin_period` int(11) DEFAULT NULL,
113 `zbc_period` int(11) DEFAULT NULL,
114 `ins_short` varchar(45) DEFAULT NULL,
115 `col_address` varchar(45) DEFAULT NULL,
116 `col_type` varchar(45) DEFAULT NULL,
117 `col_fee` int(11) DEFAULT NULL,
118 PRIMARY KEY (`hist_id`)
119) ENGINE=InnoDB DEFAULT CHARSET=utf8;
120/*!40101 SET character_set_client = @saved_cs_client */;
121
122--
123-- Dumping data for table `history`
124--
125
126LOCK TABLES `history` WRITE;
127/*!40000 ALTER TABLE `history` DISABLE KEYS */;
128/*!40000 ALTER TABLE `history` ENABLE KEYS */;
129UNLOCK TABLES;
130
131--
132-- Table structure for table `insurance`
133--
134
135DROP TABLE IF EXISTS `insurance`;
136/*!40101 SET @saved_cs_client = @@character_set_client */;
137/*!40101 SET character_set_client = utf8 */;
138CREATE TABLE `insurance` (
139 `ins_id` int(11) NOT NULL,
140 `ins_name` varchar(45) DEFAULT NULL,
141 `ins_short` varchar(45) DEFAULT NULL,
142 PRIMARY KEY (`ins_id`)
143) ENGINE=InnoDB DEFAULT CHARSET=utf8;
144/*!40101 SET character_set_client = @saved_cs_client */;
145
146--
147-- Dumping data for table `insurance`
148--
149
150LOCK TABLES `insurance` WRITE;
151/*!40000 ALTER TABLE `insurance` DISABLE KEYS */;
152/*!40000 ALTER TABLE `insurance` ENABLE KEYS */;
153UNLOCK TABLES;
154
155--
156-- Table structure for table `licensing`
157--
158
159DROP TABLE IF EXISTS `licensing`;
160/*!40101 SET @saved_cs_client = @@character_set_client */;
161/*!40101 SET character_set_client = utf8 */;
162CREATE TABLE `licensing` (
163 `lic_id` int(11) NOT NULL,
164 `vrn` varchar(45) DEFAULT NULL,
165 `req_id` varchar(45) DEFAULT NULL,
166 `ag_number` varchar(45) DEFAULT NULL,
167 `ec_number` varchar(45) DEFAULT NULL,
168 `cust_number` varchar(45) DEFAULT NULL,
169 `client_id` varchar(45) DEFAULT NULL,
170 `curr_zbc` varchar(45) DEFAULT NULL,
171 `curr_zin` varchar(45) DEFAULT NULL,
172 `enq_bal` varchar(45) DEFAULT NULL,
173 PRIMARY KEY (`lic_id`)
174) ENGINE=InnoDB DEFAULT CHARSET=utf8;
175/*!40101 SET character_set_client = @saved_cs_client */;
176
177--
178-- Dumping data for table `licensing`
179--
180
181LOCK TABLES `licensing` WRITE;
182/*!40000 ALTER TABLE `licensing` DISABLE KEYS */;
183/*!40000 ALTER TABLE `licensing` ENABLE KEYS */;
184UNLOCK TABLES;
185
186--
187-- Table structure for table `member`
188--
189
190DROP TABLE IF EXISTS `member`;
191/*!40101 SET @saved_cs_client = @@character_set_client */;
192/*!40101 SET character_set_client = utf8 */;
193CREATE TABLE `member` (
194 `m_id` int(11) NOT NULL,
195 `id_number` varchar(45) NOT NULL,
196 `firstname` varchar(45) NOT NULL,
197 `lastname` varchar(45) NOT NULL,
198 `ec_number` varchar(45) DEFAULT NULL,
199 `email` varchar(45) DEFAULT NULL,
200 `phone` varchar(45) NOT NULL,
201 `acc_level` int(11) DEFAULT NULL,
202 `ag_number` varchar(45) DEFAULT NULL,
203 `cust_number` varchar(45) DEFAULT NULL,
204 `pin` varchar(100) DEFAULT NULL,
205 `status` int(11) DEFAULT NULL,
206 PRIMARY KEY (`m_id`,`id_number`),
207 UNIQUE KEY `id_number_UNIQUE` (`id_number`)
208) ENGINE=InnoDB DEFAULT CHARSET=utf8;
209/*!40101 SET character_set_client = @saved_cs_client */;
210
211--
212-- Dumping data for table `member`
213--
214
215LOCK TABLES `member` WRITE;
216/*!40000 ALTER TABLE `member` DISABLE KEYS */;
217/*!40000 ALTER TABLE `member` ENABLE KEYS */;
218UNLOCK TABLES;
219
220--
221-- Table structure for table `request`
222--
223
224DROP TABLE IF EXISTS `request`;
225/*!40101 SET @saved_cs_client = @@character_set_client */;
226/*!40101 SET character_set_client = utf8 */;
227CREATE TABLE `request` (
228 `rq_id` int(11) NOT NULL,
229 `vrn` varchar(45) DEFAULT NULL,
230 `client_id` varchar(45) DEFAULT NULL,
231 `ins_type` varchar(45) DEFAULT NULL,
232 `ins_short` varchar(45) DEFAULT NULL,
233 `zin_period` int(11) DEFAULT '0',
234 `zbc_period` int(11) DEFAULT '0',
235 `v_make` varchar(45) DEFAULT NULL,
236 `col_type` varchar(45) DEFAULT NULL,
237 `cust_number` varchar(45) DEFAULT NULL,
238 `ag_number` varchar(45) DEFAULT NULL,
239 `ec_number` varchar(45) DEFAULT NULL,
240 `delv_address` varchar(45) DEFAULT NULL,
241 `req_status` varchar(45) DEFAULT NULL,
242 `col_status` varchar(45) DEFAULT NULL,
243 `etym_number` varchar(45) DEFAULT NULL,
244 PRIMARY KEY (`rq_id`)
245) ENGINE=InnoDB DEFAULT CHARSET=utf8;
246/*!40101 SET character_set_client = @saved_cs_client */;
247
248--
249-- Dumping data for table `request`
250--
251
252LOCK TABLES `request` WRITE;
253/*!40000 ALTER TABLE `request` DISABLE KEYS */;
254/*!40000 ALTER TABLE `request` ENABLE KEYS */;
255UNLOCK TABLES;
256
257--
258-- Table structure for table `succ_trans`
259--
260
261DROP TABLE IF EXISTS `succ_trans`;
262/*!40101 SET @saved_cs_client = @@character_set_client */;
263/*!40101 SET character_set_client = utf8 */;
264CREATE TABLE `succ_trans` (
265 `suc_trans_id` int(11) NOT NULL,
266 `trans_id` varchar(45) DEFAULT NULL,
267 `client_id` varchar(45) DEFAULT NULL,
268 `trans_date` date DEFAULT NULL,
269 `ag_number` varchar(45) DEFAULT NULL,
270 `cust_number` varchar(45) DEFAULT NULL,
271 `ec_number` varchar(45) DEFAULT NULL,
272 `ins_type` varchar(45) DEFAULT NULL,
273 `ins_period` int(11) DEFAULT '0',
274 `vrn` varchar(45) DEFAULT NULL,
275 `zin_period` int(11) DEFAULT '0',
276 `zbc_period` int(11) DEFAULT '0',
277 `col_type` varchar(45) DEFAULT NULL,
278 `col_loc` varchar(45) DEFAULT NULL,
279 `col_status` varchar(45) DEFAULT NULL,
280 `delv_address` varchar(45) DEFAULT NULL,
281 PRIMARY KEY (`suc_trans_id`)
282) ENGINE=InnoDB DEFAULT CHARSET=utf8;
283/*!40101 SET character_set_client = @saved_cs_client */;
284
285--
286-- Dumping data for table `succ_trans`
287--
288
289LOCK TABLES `succ_trans` WRITE;
290/*!40000 ALTER TABLE `succ_trans` DISABLE KEYS */;
291/*!40000 ALTER TABLE `succ_trans` ENABLE KEYS */;
292UNLOCK TABLES;
293
294--
295-- Table structure for table `vehicle`
296--
297
298DROP TABLE IF EXISTS `vehicle`;
299/*!40101 SET @saved_cs_client = @@character_set_client */;
300/*!40101 SET character_set_client = utf8 */;
301CREATE TABLE `vehicle` (
302 `v_id` int(11) NOT NULL,
303 `vrn` varchar(45) NOT NULL,
304 `id_number` varchar(45) NOT NULL,
305 `v_make` varchar(45) DEFAULT NULL,
306 `v_model` varchar(45) DEFAULT NULL,
307 `renew_date` date DEFAULT NULL,
308 PRIMARY KEY (`v_id`,`vrn`,`id_number`)
309) ENGINE=InnoDB DEFAULT CHARSET=utf8;
310/*!40101 SET character_set_client = @saved_cs_client */;
311
312--
313-- Dumping data for table `vehicle`
314--
315
316LOCK TABLES `vehicle` WRITE;
317/*!40000 ALTER TABLE `vehicle` DISABLE KEYS */;
318/*!40000 ALTER TABLE `vehicle` ENABLE KEYS */;
319UNLOCK TABLES;
320/*!40103 SET TIME_ZONE=@OLD_TIME_ZONE */;
321
322/*!40101 SET SQL_MODE=@OLD_SQL_MODE */;
323/*!40014 SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS */;
324/*!40014 SET UNIQUE_CHECKS=@OLD_UNIQUE_CHECKS */;
325/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
326/*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */;
327/*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;
328/*!40111 SET SQL_NOTES=@OLD_SQL_NOTES */;
329
330-- Dump completed on 2018-02-19 15:23:16