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