-
Notifications
You must be signed in to change notification settings - Fork 0
Expand file tree
/
Copy pathsql.sql
More file actions
143 lines (107 loc) · 57.2 KB
/
sql.sql
File metadata and controls
143 lines (107 loc) · 57.2 KB
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
117
118
119
120
121
122
123
124
125
126
127
128
129
130
131
132
133
134
135
136
137
138
139
140
141
142
/*
SQLyog Ultimate v11.27 (32 bit)
MySQL - 5.6.21 : Database - bryning
*********************************************************************
*/
/*!40101 SET NAMES utf8 */;
/*!40101 SET SQL_MODE=''*/;
/*!40014 SET @OLD_UNIQUE_CHECKS=@@UNIQUE_CHECKS, UNIQUE_CHECKS=0 */;
/*!40014 SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0 */;
/*!40101 SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='NO_AUTO_VALUE_ON_ZERO' */;
/*!40111 SET @OLD_SQL_NOTES=@@SQL_NOTES, SQL_NOTES=0 */;
CREATE DATABASE /*!32312 IF NOT EXISTS*/`bryning` /*!40100 DEFAULT CHARACTER SET utf8 */;
USE `bryning`;
/*Table structure for table `log` */
DROP TABLE IF EXISTS `log`;
CREATE TABLE `log` (
`logId` int(20) NOT NULL AUTO_INCREMENT,
`type` varchar(20) DEFAULT NULL,
`user` varchar(20) DEFAULT NULL,
`time` int(20) DEFAULT NULL,
`remark` varchar(20) DEFAULT NULL,
`content` varchar(20) DEFAULT NULL,
`sets` varchar(20) DEFAULT NULL,
`parking` varchar(20) DEFAULT NULL,
`license` varchar(20) DEFAULT NULL,
PRIMARY KEY (`logId`)
) ENGINE=InnoDB AUTO_INCREMENT=47 DEFAULT CHARSET=utf8;
/*Data for the table `log` */
insert into `log`(`logId`,`type`,`user`,`time`,`remark`,`content`,`sets`,`parking`,`license`) values (1,'登录','asdf',1495106540,'舍得坊','是打发色粉',NULL,NULL,NULL),(2,'出车',NULL,1496144808,NULL,'出车',NULL,NULL,NULL),(3,'停车',NULL,1496145324,NULL,'停车',NULL,NULL,NULL),(6,'移车',NULL,1496147164,NULL,'移动车辆','aa','锦园停车场','京212312'),(7,'出车',NULL,1496248173,NULL,'出车',NULL,'锦园停车场','bbb'),(8,'登录','大超市2',1496276830,NULL,'用户登录',NULL,NULL,NULL),(9,'移车',NULL,1496278394,NULL,'移动车辆','pbkjs','锦园停车场','bbb'),(10,'移车',NULL,1496281735,NULL,'移动车辆','aa','锦园停车场','京212312'),(11,'移车',NULL,1496281754,NULL,'移动车辆','aa','锦园停车场','bbb'),(12,'移车',NULL,1496281754,NULL,'移动车辆','pbkjs','锦园停车场','京212312'),(13,'移车',NULL,1499281754,NULL,'移动车辆','aa','锦园停车场','bbb'),(14,'登录','大超市2',1496317865,NULL,'用户登录',NULL,NULL,NULL),(15,'停车',NULL,1496333857,NULL,'停车',NULL,'锦园停车场','abcd'),(16,'停车',NULL,1496333860,NULL,'停车',NULL,'锦园停车场','渝212334'),(17,'出车',NULL,1496333866,NULL,'出车',NULL,'锦园停车场','abcd'),(18,'出车',NULL,1496333867,NULL,'出车',NULL,'锦园停车场','渝212334'),(19,'停车',NULL,1496333875,NULL,'停车',NULL,'锦园停车场','abcd'),(20,'停车',NULL,1496333878,NULL,'停车',NULL,'锦园停车场','渝212334'),(21,'移车',NULL,1496334127,NULL,'移动车辆','3F','锦园停车场','沪SDCXCV'),(22,'移车',NULL,1496334137,NULL,'移动车辆','3F','锦园停车场','渝212334'),(23,'移车',NULL,1496334150,NULL,'移动车辆','3F','锦园停车场','京A2SSSS'),(24,'移车',NULL,1496337083,NULL,'移动车辆','3F','锦园停车场','渝212334'),(25,'移车',NULL,1496337087,NULL,'移动车辆','pbkjs','锦园停车场','bbb'),(26,'移车',NULL,1496337088,NULL,'移动车辆','aa','锦园停车场','京212312'),(27,'移车',NULL,1496337093,NULL,'移动车辆','aa','锦园停车场','abcd'),(28,'移车',NULL,1496337614,NULL,'移动车辆','vv','锦园停车场','渝212334'),(29,'移车',NULL,1496337614,NULL,'移动车辆','3F','锦园停车场','bbb'),(30,'移车',NULL,1496337615,NULL,'移动车辆','pbkjs','锦园停车场','abcd'),(31,'移车',NULL,1496337615,NULL,'移动车辆','aa','锦园停车场','沪SDCXCV'),(32,'登录','大超市2',1496337837,NULL,'用户登录',NULL,NULL,NULL),(33,'登录','大超市2',1496375820,NULL,'用户登录',NULL,NULL,NULL),(34,'登录','大超市2',1496414595,NULL,'用户登录',NULL,NULL,NULL),(35,'登录','大超市2',1496420481,NULL,'用户登录',NULL,NULL,NULL),(36,'登录','大超市2',1496421084,NULL,'用户登录',NULL,NULL,NULL),(37,'登录','大超市2',1496421279,NULL,'用户登录',NULL,NULL,NULL),(38,'登录','大超市2',1496422071,NULL,'用户登录',NULL,NULL,NULL),(39,'登录','陈恒涛',1496422479,NULL,'用户登录',NULL,NULL,NULL),(40,'登录','陈恒涛',1496425496,NULL,'用户登录',NULL,NULL,NULL),(41,'登录','陈恒涛',1496427569,NULL,'用户登录',NULL,NULL,NULL),(42,'出车',NULL,1496427670,NULL,'出车',NULL,'金三角饭店停车场未','云WBYDFK'),(43,'移车',NULL,1496427768,NULL,'移动车辆','3A','金鹰酒店停车场','黑TWNYKS'),(44,'移车',NULL,1496427768,NULL,'移动车辆','2A','金鹰酒店停车场','青PY6AJZ'),(45,'移车',NULL,1496427768,NULL,'移动车辆','1A','金鹰酒店停车场','青CRIJ4R'),(46,'登录','陈恒涛',1496430070,NULL,'用户登录',NULL,NULL,NULL);
/*Table structure for table `parking` */
DROP TABLE IF EXISTS `parking`;
CREATE TABLE `parking` (
`parkingId` int(20) NOT NULL AUTO_INCREMENT,
`name` varchar(20) DEFAULT NULL,
`address` varchar(20) DEFAULT NULL,
PRIMARY KEY (`parkingId`)
) ENGINE=InnoDB AUTO_INCREMENT=33 DEFAULT CHARSET=utf8;
/*Data for the table `parking` */
insert into `parking`(`parkingId`,`name`,`address`) values (1,'锦园停车场','莲湖区桃园南路'),(2,'军兴饭店停车场','碑林区草场坡'),(8,'家世界停车场','莲湖区大庆路'),(9,'金鹰酒店停车场','未央区凤城一路'),(10,'联桥招待所','停车场灞桥区酒十路'),(11,'晶众家乐购物广场停车场','碑林区东关南街'),(12,'经贸宾馆停车场','未央区未央路'),(13,'金三角饭店停车场未','86254148'),(14,'大庆停车场（华清东路）','2513308'),(15,'家乐购物广场停车场','未央区玄武路'),(16,'金穗宾馆停车场','碑林区围墙巷'),(17,'建华饭店停车场','碑林区环城南路东段100号'),(18,'金隆小区停车场','莲湖区环城西路'),(19,'陕西中大国际大厦停车场','碑林区南大街'),(20,'明德门地下停车场（友谊西路）','雁塔区友谊西路'),(21,'陕西能源职业技术学院停车场','碑林区含光北路'),(22,'商住大厦停车场','碑林区火炬路'),(23,'陕西省劳动和社会保障局招待所停车场','碑林区建设东路33号'),(24,'陕西省体育场停车场','碑林区长安北路'),(25,'三府湾停车场','新城区华清西路'),(26,'莲湖环卫停车场','雁塔区昆明路'),(27,'明德华园大厦停车场','雁塔区友谊西路'),(28,'陕西丰阳招待所停车场','新城区联志路'),(29,'南方货运停车场','灞桥区米秦路029-86729508'),(30,'庆运总公司招待所停车场','莲湖区沣惠北路'),(31,'德发长酒店停车场','新城区案板路'),(32,'百隆广场停车场','雁塔区小寨东路');
/*Table structure for table `parkingset` */
DROP TABLE IF EXISTS `parkingset`;
CREATE TABLE `parkingset` (
`name` varchar(20) NOT NULL,
`parkingId` varchar(20) NOT NULL,
`available` varchar(20) DEFAULT NULL,
`curVehicle` varchar(20) DEFAULT NULL,
`lastRecordTime` int(20) DEFAULT NULL,
`setId` int(20) NOT NULL AUTO_INCREMENT,
`weight` int(20) DEFAULT NULL,
PRIMARY KEY (`setId`)
) ENGINE=InnoDB AUTO_INCREMENT=13 DEFAULT CHARSET=utf8;
/*Data for the table `parkingset` */
insert into `parkingset`(`name`,`parkingId`,`available`,`curVehicle`,`lastRecordTime`,`setId`,`weight`) values ('2D','1','true','沪SDCXCV',1496403696,3,NULL),('2E','1','true','abcd',1496403701,4,NULL),('3F','1','true','bbb',1496148930,6,NULL),('2W','1','true','渝212334',1496403707,7,NULL),('3F','2','true',NULL,1496425516,8,NULL),('1A','9','true','青CRIJ4R',1496427752,9,NULL),('2A','9','true','青PY6AJZ',1496427759,10,NULL),('3A','9','true','黑TWNYKS',1496427763,11,NULL),('4A','9','true',NULL,1496427782,12,NULL);
/*Table structure for table `scenedata` */
DROP TABLE IF EXISTS `scenedata`;
CREATE TABLE `scenedata` (
`parkingId` int(20) NOT NULL,
`data` varchar(5000) DEFAULT NULL,
PRIMARY KEY (`parkingId`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
/*Data for the table `scenedata` */
insert into `scenedata`(`parkingId`,`data`) values (1,'[{\"type\":\"parkingSet\",\"id\":\"2D\",\"position\":{\"x\":36,\"y\":0.2,\"z\":44},\"rotation\":{\"x\":0,\"y\":0,\"z\":0},\"occupiedArray\":[{\"floor\":{\"x\":8,\"z\":8}},{\"floor\":{\"x\":8,\"z\":9}},{\"floor\":{\"x\":8,\"z\":10}},{\"floor\":{\"x\":8,\"z\":11}},{\"floor\":{\"x\":8,\"z\":12}},{\"floor\":{\"x\":8,\"z\":13}},{\"floor\":{\"x\":9,\"z\":8}},{\"floor\":{\"x\":9,\"z\":9}},{\"floor\":{\"x\":9,\"z\":10}},{\"floor\":{\"x\":9,\"z\":11}},{\"floor\":{\"x\":9,\"z\":12}},{\"floor\":{\"x\":9,\"z\":13}}]},{\"type\":\"parkingSet\",\"id\":\"2E\",\"position\":{\"x\":44,\"y\":0.2,\"z\":44},\"rotation\":{\"x\":0,\"y\":0,\"z\":0},\"occupiedArray\":[{\"floor\":{\"x\":10,\"z\":8}},{\"floor\":{\"x\":10,\"z\":9}},{\"floor\":{\"x\":10,\"z\":10}},{\"floor\":{\"x\":10,\"z\":11}},{\"floor\":{\"x\":10,\"z\":12}},{\"floor\":{\"x\":10,\"z\":13}},{\"floor\":{\"x\":11,\"z\":8}},{\"floor\":{\"x\":11,\"z\":9}},{\"floor\":{\"x\":11,\"z\":10}},{\"floor\":{\"x\":11,\"z\":11}},{\"floor\":{\"x\":11,\"z\":12}},{\"floor\":{\"x\":11,\"z\":13}}]},{\"type\":\"parkingSet\",\"id\":\"3F\",\"position\":{\"x\":64,\"y\":0.2,\"z\":44},\"rotation\":{\"x\":0,\"y\":0,\"z\":0},\"occupiedArray\":[{\"floor\":{\"x\":15,\"z\":8}},{\"floor\":{\"x\":15,\"z\":9}},{\"floor\":{\"x\":15,\"z\":10}},{\"floor\":{\"x\":15,\"z\":11}},{\"floor\":{\"x\":15,\"z\":12}},{\"floor\":{\"x\":15,\"z\":13}},{\"floor\":{\"x\":16,\"z\":8}},{\"floor\":{\"x\":16,\"z\":9}},{\"floor\":{\"x\":16,\"z\":10}},{\"floor\":{\"x\":16,\"z\":11}},{\"floor\":{\"x\":16,\"z\":12}},{\"floor\":{\"x\":16,\"z\":13}}]},{\"type\":\"building1\",\"position\":{\"x\":20,\"y\":1.25,\"z\":8},\"rotation\":{\"x\":0,\"y\":0,\"z\":0},\"occupiedArray\":[{\"floor\":{\"x\":0,\"z\":0}},{\"floor\":{\"x\":0,\"z\":1}},{\"floor\":{\"x\":0,\"z\":2}},{\"floor\":{\"x\":0,\"z\":3}},{\"floor\":{\"x\":1,\"z\":0}},{\"floor\":{\"x\":1,\"z\":1}},{\"floor\":{\"x\":1,\"z\":2}},{\"floor\":{\"x\":1,\"z\":3}},{\"floor\":{\"x\":2,\"z\":0}},{\"floor\":{\"x\":2,\"z\":1}},{\"floor\":{\"x\":2,\"z\":2}},{\"floor\":{\"x\":2,\"z\":3}},{\"floor\":{\"x\":3,\"z\":0}},{\"floor\":{\"x\":3,\"z\":1}},{\"floor\":{\"x\":3,\"z\":2}},{\"floor\":{\"x\":3,\"z\":3}},{\"floor\":{\"x\":4,\"z\":0}},{\"floor\":{\"x\":4,\"z\":1}},{\"floor\":{\"x\":4,\"z\":2}},{\"floor\":{\"x\":4,\"z\":3}},{\"floor\":{\"x\":5,\"z\":0}},{\"floor\":{\"x\":5,\"z\":1}},{\"floor\":{\"x\":5,\"z\":2}},{\"floor\":{\"x\":5,\"z\":3}},{\"floor\":{\"x\":6,\"z\":0}},{\"floor\":{\"x\":6,\"z\":1}},{\"floor\":{\"x\":6,\"z\":2}},{\"floor\":{\"x\":6,\"z\":3}},{\"floor\":{\"x\":7,\"z\":0}},{\"floor\":{\"x\":7,\"z\":1}},{\"floor\":{\"x\":7,\"z\":2}},{\"floor\":{\"x\":7,\"z\":3}},{\"floor\":{\"x\":8,\"z\":0}},{\"floor\":{\"x\":8,\"z\":1}},{\"floor\":{\"x\":8,\"z\":2}},{\"floor\":{\"x\":8,\"z\":3}},{\"floor\":{\"x\":9,\"z\":0}},{\"floor\":{\"x\":9,\"z\":1}},{\"floor\":{\"x\":9,\"z\":2}},{\"floor\":{\"x\":9,\"z\":3}}]},{\"type\":\"building1\",\"position\":{\"x\":20,\"y\":1.25,\"z\":24},\"rotation\":{\"x\":0,\"y\":0,\"z\":0},\"occupiedArray\":[{\"floor\":{\"x\":0,\"z\":4}},{\"floor\":{\"x\":0,\"z\":5}},{\"floor\":{\"x\":0,\"z\":6}},{\"floor\":{\"x\":0,\"z\":7}},{\"floor\":{\"x\":1,\"z\":4}},{\"floor\":{\"x\":1,\"z\":5}},{\"floor\":{\"x\":1,\"z\":6}},{\"floor\":{\"x\":1,\"z\":7}},{\"floor\":{\"x\":2,\"z\":4}},{\"floor\":{\"x\":2,\"z\":5}},{\"floor\":{\"x\":2,\"z\":6}},{\"floor\":{\"x\":2,\"z\":7}},{\"floor\":{\"x\":3,\"z\":4}},{\"floor\":{\"x\":3,\"z\":5}},{\"floor\":{\"x\":3,\"z\":6}},{\"floor\":{\"x\":3,\"z\":7}},{\"floor\":{\"x\":4,\"z\":4}},{\"floor\":{\"x\":4,\"z\":5}},{\"floor\":{\"x\":4,\"z\":6}},{\"floor\":{\"x\":4,\"z\":7}},{\"floor\":{\"x\":5,\"z\":4}},{\"floor\":{\"x\":5,\"z\":5}},{\"floor\":{\"x\":5,\"z\":6}},{\"floor\":{\"x\":5,\"z\":7}},{\"floor\":{\"x\":6,\"z\":4}},{\"floor\":{\"x\":6,\"z\":5}},{\"floor\":{\"x\":6,\"z\":6}},{\"floor\":{\"x\":6,\"z\":7}},{\"floor\":{\"x\":7,\"z\":4}},{\"floor\":{\"x\":7,\"z\":5}},{\"floor\":{\"x\":7,\"z\":6}},{\"floor\":{\"x\":7,\"z\":7}},{\"floor\":{\"x\":8,\"z\":4}},{\"floor\":{\"x\":8,\"z\":5}},{\"floor\":{\"x\":8,\"z\":6}},{\"floor\":{\"x\":8,\"z\":7}},{\"floor\":{\"x\":9,\"z\":4}},{\"floor\":{\"x\":9,\"z\":5}},{\"floor\":{\"x\":9,\"z\":6}},{\"floor\":{\"x\":9,\"z\":7}}]},{\"type\":\"parkingSet\",\"id\":\"2W\",\"position\":{\"x\":56,\"y\":0.2,\"z\":44},\"rotation\":{\"x\":0,\"y\":0,\"z\":0},\"occupiedArray\":[{\"floor\":{\"x\":13,\"z\":8}},{\"floor\":{\"x\":13,\"z\":9}},{\"floor\":{\"x\":13,\"z\":10}},{\"floor\":{\"x\":13,\"z\":11}},{\"floor\":{\"x\":13,\"z\":12}},{\"floor\":{\"x\":13,\"z\":13}},{\"floor\":{\"x\":14,\"z\":8}},{\"floor\":{\"x\":14,\"z\":9}},{\"floor\":{\"x\":14,\"z\":10}},{\"floor\":{\"x\":14,\"z\":11}},{\"floor\":{\"x\":14,\"z\":12}},{\"floor\":{\"x\":14,\"z\":13}}]}]'),(2,'[{\"type\":\"parkingSet\",\"id\":\"3F\",\"position\":{\"x\":44,\"y\":0.2,\"z\":36},\"rotation\":{\"x\":0,\"y\":0,\"z\":0},\"occupiedArray\":[{\"floor\":{\"x\":10,\"z\":6}},{\"floor\":{\"x\":10,\"z\":7}},{\"floor\":{\"x\":10,\"z\":8}},{\"floor\":{\"x\":10,\"z\":9}},{\"floor\":{\"x\":10,\"z\":10}},{\"floor\":{\"x\":10,\"z\":11}},{\"floor\":{\"x\":11,\"z\":6}},{\"floor\":{\"x\":11,\"z\":7}},{\"floor\":{\"x\":11,\"z\":8}},{\"floor\":{\"x\":11,\"z\":9}},{\"floor\":{\"x\":11,\"z\":10}},{\"floor\":{\"x\":11,\"z\":11}}]}]'),(9,'[{\"type\":\"parkingSet\",\"id\":\"1A\",\"position\":{\"x\":44,\"y\":0.2,\"z\":48},\"rotation\":{\"x\":0,\"y\":0,\"z\":0},\"occupiedArray\":[{\"floor\":{\"x\":10,\"z\":9}},{\"floor\":{\"x\":10,\"z\":10}},{\"floor\":{\"x\":10,\"z\":11}},{\"floor\":{\"x\":10,\"z\":12}},{\"floor\":{\"x\":10,\"z\":13}},{\"floor\":{\"x\":10,\"z\":14}},{\"floor\":{\"x\":11,\"z\":9}},{\"floor\":{\"x\":11,\"z\":10}},{\"floor\":{\"x\":11,\"z\":11}},{\"floor\":{\"x\":11,\"z\":12}},{\"floor\":{\"x\":11,\"z\":13}},{\"floor\":{\"x\":11,\"z\":14}}]},{\"type\":\"parkingSet\",\"id\":\"2A\",\"position\":{\"x\":52,\"y\":0.2,\"z\":52},\"rotation\":{\"x\":0,\"y\":0,\"z\":0},\"occupiedArray\":[{\"floor\":{\"x\":12,\"z\":10}},{\"floor\":{\"x\":12,\"z\":11}},{\"floor\":{\"x\":12,\"z\":12}},{\"floor\":{\"x\":12,\"z\":13}},{\"floor\":{\"x\":12,\"z\":14}},{\"floor\":{\"x\":12,\"z\":15}},{\"floor\":{\"x\":13,\"z\":10}},{\"floor\":{\"x\":13,\"z\":11}},{\"floor\":{\"x\":13,\"z\":12}},{\"floor\":{\"x\":13,\"z\":13}},{\"floor\":{\"x\":13,\"z\":14}},{\"floor\":{\"x\":13,\"z\":15}}]},{\"type\":\"parkingSet\",\"id\":\"3A\",\"position\":{\"x\":60,\"y\":0.2,\"z\":52},\"rotation\":{\"x\":0,\"y\":0,\"z\":0},\"occupiedArray\":[{\"floor\":{\"x\":14,\"z\":10}},{\"floor\":{\"x\":14,\"z\":11}},{\"floor\":{\"x\":14,\"z\":12}},{\"floor\":{\"x\":14,\"z\":13}},{\"floor\":{\"x\":14,\"z\":14}},{\"floor\":{\"x\":14,\"z\":15}},{\"floor\":{\"x\":15,\"z\":10}},{\"floor\":{\"x\":15,\"z\":11}},{\"floor\":{\"x\":15,\"z\":12}},{\"floor\":{\"x\":15,\"z\":13}},{\"floor\":{\"x\":15,\"z\":14}},{\"floor\":{\"x\":15,\"z\":15}}]},{\"type\":\"parkingSet\",\"id\":\"4A\",\"position\":{\"x\":68,\"y\":0.2,\"z\":52},\"rotation\":{\"x\":0,\"y\":0,\"z\":0},\"occupiedArray\":[{\"floor\":{\"x\":16,\"z\":10}},{\"floor\":{\"x\":16,\"z\":11}},{\"floor\":{\"x\":16,\"z\":12}},{\"floor\":{\"x\":16,\"z\":13}},{\"floor\":{\"x\":16,\"z\":14}},{\"floor\":{\"x\":16,\"z\":15}},{\"floor\":{\"x\":17,\"z\":10}},{\"floor\":{\"x\":17,\"z\":11}},{\"floor\":{\"x\":17,\"z\":12}},{\"floor\":{\"x\":17,\"z\":13}},{\"floor\":{\"x\":17,\"z\":14}},{\"floor\":{\"x\":17,\"z\":15}}]}]');
/*Table structure for table `user` */
DROP TABLE IF EXISTS `user`;
CREATE TABLE `user` (
`userId` int(20) NOT NULL AUTO_INCREMENT,
`userType` varchar(20) DEFAULT NULL,
`name` varchar(20) DEFAULT NULL,
`age` varchar(20) DEFAULT NULL,
`photo` varchar(20) DEFAULT NULL,
`gender` varchar(20) DEFAULT NULL,
`birth` varchar(20) DEFAULT NULL,
`ID` varchar(20) DEFAULT NULL,
`address` varchar(20) DEFAULT NULL,
`cellPhone` varchar(20) DEFAULT NULL,
`email` varchar(20) DEFAULT NULL,
`startDate` varchar(20) DEFAULT NULL,
`curVehicle` varchar(20) DEFAULT NULL,
`lastRecordTime` int(20) DEFAULT NULL,
`password` varchar(32) DEFAULT NULL,
PRIMARY KEY (`userId`)
) ENGINE=InnoDB AUTO_INCREMENT=123532 DEFAULT CHARSET=utf8;
/*Data for the table `user` */
insert into `user`(`userId`,`userType`,`name`,`age`,`photo`,`gender`,`birth`,`ID`,`address`,`cellPhone`,`email`,`startDate`,`curVehicle`,`lastRecordTime`,`password`) values (123,'管理员','陈恒涛','123','img/avatar-amas.jpg','男','123','123','123','123456789','519132364@qq.com','1169078520000','123',1496237740,'123456'),(123458,'司机','asasas',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(123459,'司机','testName 1','g3','g4','g5','123',NULL,'g8','g9','g40','11',NULL,123123,NULL),(123460,'司机','testName 2','g3','g4','g5','123',NULL,'g8','g9','g40','11',NULL,123123,NULL),(123462,'司机','15','7496','132','1543','156356','586','126','49','456','456','456',456,'156'),(123463,'司机','而言他','135',NULL,'男','1493645280',NULL,NULL,NULL,NULL,'1494595680',NULL,NULL,NULL),(123464,'司机','对对对','12',NULL,'男','1493731740',NULL,'123','12312','123888','1494336540',NULL,NULL,NULL),(123465,'司机','会通过','45',NULL,'男','1494336720',NULL,'231',NULL,NULL,'1493818320',NULL,1496237536,NULL),(123466,'管理员','阿里','12',NULL,'男','794764800','3215431','sadf','4851354','51@qq.com','794764800',NULL,NULL,NULL),(123467,'管理员','x','13',NULL,'男','794851200','3215432','sadf','4851355','52@qq.com','794851200',NULL,NULL,NULL),(123468,'管理员','1','14',NULL,'男','794937600','3215433','sadf','4851356','53@qq.com','794937600',NULL,NULL,NULL),(123469,'管理员','asdf','15',NULL,'男','795024000','3215434','sadf','4851357','54@qq.com','795024000',NULL,NULL,NULL),(123470,'管理员','zdxvf','16',NULL,'男','795110400','3215435','sadf','4851358','55@qq.com','795110400',NULL,NULL,NULL),(123471,'管理员','sadf','17',NULL,'男','795196800','3215436','sadf','4851359','56@qq.com','795196800',NULL,NULL,NULL),(123472,'管理员','cxv','18',NULL,'男','795283200','3215437','sadf','4851360','57@qq.com','795283200',NULL,NULL,NULL),(123473,'管理员','asdf','19',NULL,'男','795369600','3215438','sadf','4851361','58@qq.com','795369600',NULL,NULL,NULL),(123474,'管理员','asdfv','20',NULL,'男','795456000','3215439','sadf','4851362','59@qq.com','795456000',NULL,NULL,NULL),(123475,'管理员','aaa1','21',NULL,'男','795542400','3215440','sadf','4851363','60@qq.com','795542400',NULL,NULL,NULL),(123476,'管理员','aaa2','22',NULL,'男','795628800','3215441','sadf','4851364','61@qq.com','795628800',NULL,NULL,NULL),(123477,'管理员','aaa3','23',NULL,'男','795715200','3215442','sadf','4851365','62@qq.com','795715200',NULL,NULL,NULL),(123478,'管理员','aaa4','24',NULL,'男','795801600','3215443','sadf','4851366','63@qq.com','795801600',NULL,NULL,NULL),(123479,'管理员','aaa5','25',NULL,'男','795888000','3215444','sadf','4851367','64@qq.com','795888000',NULL,NULL,NULL),(123480,'管理员','aaa6','26',NULL,'男','795974400','3215445','sadf','4851368','65@qq.com','795974400',NULL,NULL,NULL),(123481,'管理员','aaa7','27',NULL,'男','796060800','3215446','sadf','4851369','66@qq.com','796060800',NULL,NULL,NULL),(123482,'管理员','aaa8','28',NULL,'男','796147200','3215447','sadf','4851370','67@qq.com','796147200',NULL,NULL,NULL),(123483,'管理员','aaa9','29',NULL,'男','796233600','3215448','sadf','4851371','68@qq.com','796233600',NULL,NULL,NULL),(123484,'管理员','aaa10','30',NULL,'男','796320000','3215449','sadf','4851372','69@qq.com','796320000',NULL,NULL,NULL),(123485,'管理员','aaa11','31',NULL,'男','796406400','3215450','sadf','4851373','70@qq.com','796406400',NULL,NULL,NULL),(123486,'管理员','aaa12','32',NULL,'男','796492800','3215451','sadf','4851374','71@qq.com','796492800',NULL,NULL,NULL),(123487,'管理员','aaa13','33',NULL,'男','796579200','3215452','sadf','4851375','72@qq.com','796579200',NULL,NULL,NULL),(123488,'管理员','aaa14','34',NULL,'男','796665600','3215453','sadf','4851376','73@qq.com','796665600',NULL,NULL,NULL),(123489,'管理员','aaa15','35',NULL,'男','796752000','3215454','sadf','4851377','74@qq.com','796752000',NULL,NULL,NULL),(123490,'管理员','aaa16','36',NULL,'男','796838400','3215455','sadf','4851378','75@qq.com','796838400',NULL,NULL,NULL),(123491,'管理员','aaa17','37',NULL,'男','796924800','3215456','sadf','4851379','76@qq.com','796924800',NULL,NULL,NULL),(123492,'管理员','aaa18','38',NULL,'男','797011200','3215457','sadf','4851380','77@qq.com','797011200',NULL,NULL,NULL),(123493,'管理员','aaa19','39',NULL,'男','797097600','3215458','sadf','4851381','78@qq.com','797097600',NULL,NULL,NULL),(123494,'管理员','aaa20','40',NULL,'男','797184000','3215459','sadf','4851382','79@qq.com','797184000',NULL,NULL,NULL),(123495,'管理员','aaa21','41',NULL,'男','797270400','3215460','sadf','4851383','80@qq.com','797270400',NULL,NULL,NULL),(123496,'管理员','aaa22','42',NULL,'男','797356800','3215461','sadf','4851384','81@qq.com','797356800',NULL,NULL,NULL),(123497,'管理员','aaa23','43',NULL,'男','797443200','3215462','sadf','4851385','82@qq.com','797443200',NULL,NULL,NULL),(123498,'管理员','撒地方','44',NULL,'男','797529600','3215463','sadf','4851386','83@qq.com','797529600',NULL,1496428502,NULL);
/*Table structure for table `vehicle` */
DROP TABLE IF EXISTS `vehicle`;
CREATE TABLE `vehicle` (
`license` varchar(20) NOT NULL,
`route` varchar(20) DEFAULT NULL,
`photo` varchar(20) DEFAULT NULL,
`model` varchar(20) DEFAULT NULL,
`purchasedDate` int(20) DEFAULT NULL,
`maintenance` varchar(20) DEFAULT NULL,
`km` int(20) DEFAULT NULL,
`lastRecordTime` int(20) DEFAULT NULL,
`curStat` varchar(20) DEFAULT NULL,
`nextStart` int(20) DEFAULT NULL,
`parkingId` int(20) DEFAULT NULL,
`curSet` int(20) DEFAULT NULL,
PRIMARY KEY (`license`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
/*Data for the table `vehicle` */
insert into `vehicle`(`license`,`route`,`photo`,`model`,`purchasedDate`,`maintenance`,`km`,`lastRecordTime`,`curStat`,`nextStart`,`parkingId`,`curSet`) values ('abcd','581','pho】','9699',0,'一级',1234,1496333875,'停车',14,1,4),('bbb','421','xca','dsf',123123,NULL,NULL,12312,'停车',1231,1,6),('云B4I5DG','421',NULL,NULL,NULL,NULL,NULL,NULL,'停车',NULL,18,NULL),('云BPKRZR','412',NULL,NULL,NULL,NULL,NULL,NULL,'停车',NULL,16,NULL),('云BRTRRS','412',NULL,NULL,NULL,NULL,NULL,NULL,'停车',NULL,18,NULL),('云FDRS2S','911',NULL,NULL,NULL,NULL,NULL,NULL,'停车',NULL,1,NULL),('云GTDJX2','357',NULL,NULL,NULL,NULL,NULL,NULL,'停车',NULL,8,NULL),('云GXRNNS','357',NULL,NULL,NULL,NULL,NULL,NULL,'停车',NULL,14,NULL),('云HJD24D','503',NULL,NULL,NULL,NULL,NULL,NULL,'停车',NULL,8,NULL),('云MRGWK3','911',NULL,NULL,NULL,NULL,NULL,NULL,'停车',NULL,20,NULL),('云NJSGYR','357',NULL,NULL,NULL,NULL,NULL,NULL,'停车',NULL,19,NULL),('云NXEN4P','503',NULL,NULL,NULL,NULL,NULL,NULL,'停车',NULL,5,NULL),('云PEYWPR','412',NULL,NULL,NULL,NULL,NULL,NULL,'停车',NULL,16,NULL),('云S6MFN2','908',NULL,NULL,NULL,NULL,NULL,NULL,'停车',NULL,18,NULL),('云SCCA7R','412',NULL,NULL,NULL,NULL,NULL,NULL,'停车',NULL,10,NULL),('云T5HNHR','403',NULL,NULL,NULL,NULL,NULL,NULL,'停车',NULL,19,NULL),('云WBYDFK','581',NULL,NULL,NULL,NULL,NULL,1496427670,'出车',NULL,13,NULL),('云YN6GAH','908',NULL,NULL,NULL,NULL,NULL,NULL,'停车',NULL,13,NULL),('云ZS8JSY','908',NULL,NULL,NULL,NULL,NULL,NULL,'停车',NULL,17,NULL),('京212312','655',NULL,'SS',NULL,'一级',123,NULL,'停车',NULL,1,NULL),('京A2SSSS','357',NULL,'22',NULL,'新车',123,NULL,'停车',NULL,1,NULL),('京CAG5KB','412',NULL,NULL,NULL,NULL,NULL,NULL,'停车',NULL,3,NULL),('京DA1233','503',NULL,'123',NULL,'一级',222,NULL,'停车',NULL,1,NULL),('京ET3PPG','655',NULL,NULL,NULL,NULL,NULL,NULL,'停车',NULL,13,NULL),('京F2PZRD','911',NULL,NULL,NULL,NULL,NULL,NULL,'停车',NULL,20,NULL),('京FB4FER','503',NULL,NULL,NULL,NULL,NULL,NULL,'停车',NULL,5,NULL),('京GHQSDM','911',NULL,NULL,NULL,NULL,NULL,NULL,'停车',NULL,20,NULL),('京HBPN6W','581',NULL,NULL,NULL,NULL,NULL,NULL,'停车',NULL,5,NULL),('京J4NS3B','421',NULL,NULL,NULL,NULL,NULL,NULL,'停车',NULL,19,NULL),('京J7NJNX','412',NULL,NULL,NULL,NULL,NULL,NULL,'停车',NULL,3,NULL),('京JHYCPF','357',NULL,NULL,NULL,NULL,NULL,NULL,'停车',NULL,17,NULL),('京JJA87F','911',NULL,NULL,NULL,NULL,NULL,NULL,'停车',NULL,14,NULL),('京K8TINC','503',NULL,NULL,NULL,NULL,NULL,NULL,'停车',NULL,5,NULL),('京Q8CHRP','412',NULL,NULL,NULL,NULL,NULL,NULL,'停车',NULL,18,NULL),('京RDZCNF','503',NULL,NULL,NULL,NULL,NULL,NULL,'停车',NULL,18,NULL),('京TBKCDF','111',NULL,NULL,NULL,NULL,NULL,NULL,'停车',NULL,16,NULL),('京TIJDGM','503',NULL,NULL,NULL,NULL,NULL,NULL,'停车',NULL,1,NULL),('京TIW3AJ','503',NULL,NULL,NULL,NULL,NULL,NULL,'停车',NULL,9,NULL),('京TXKIWT','421',NULL,NULL,NULL,NULL,NULL,NULL,'停车',NULL,5,NULL),('冀BAST8E','403',NULL,NULL,NULL,NULL,NULL,NULL,'停车',NULL,18,NULL),('冀BDKEPR','111',NULL,NULL,NULL,NULL,NULL,NULL,'停车',NULL,3,NULL),('冀CARPWN','503',NULL,NULL,NULL,NULL,NULL,NULL,'停车',NULL,2,NULL),('冀D7MM8R','111',NULL,NULL,NULL,NULL,NULL,NULL,'停车',NULL,17,NULL),('冀ENWHZB','503',NULL,NULL,NULL,NULL,NULL,NULL,'停车',NULL,8,NULL),('冀EPYXPE','503',NULL,NULL,NULL,NULL,NULL,NULL,'停车',NULL,18,NULL),('冀G8BBAJ','503',NULL,NULL,NULL,NULL,NULL,NULL,'停车',NULL,17,NULL),('冀K683DS','655',NULL,NULL,NULL,NULL,NULL,NULL,'停车',NULL,3,NULL),('冀KFNRS4','412',NULL,NULL,NULL,NULL,NULL,NULL,'停车',NULL,8,NULL),('冀KNJKAP','503',NULL,NULL,NULL,NULL,NULL,NULL,'停车',NULL,13,NULL),('冀NPZAPW','357',NULL,NULL,NULL,NULL,NULL,NULL,'停车',NULL,16,NULL),('冀QENSSC','357',NULL,NULL,NULL,NULL,NULL,NULL,'停车',NULL,11,NULL),('冀SPPFRY','412',NULL,NULL,NULL,NULL,NULL,NULL,'停车',NULL,8,NULL),('冀STP6NW','908',NULL,NULL,NULL,NULL,NULL,NULL,'停车',NULL,8,NULL),('冀T66W67','908',NULL,NULL,NULL,NULL,NULL,NULL,'停车',NULL,7,NULL),('冀T8JSHY','911',NULL,NULL,NULL,NULL,NULL,NULL,'停车',NULL,18,NULL),('吉ABQBT2','412',NULL,NULL,NULL,NULL,NULL,NULL,'停车',NULL,4,NULL),('吉CHTWE8','412',NULL,NULL,NULL,NULL,NULL,NULL,'停车',NULL,5,NULL),('吉DJMQR6','357',NULL,NULL,NULL,NULL,NULL,NULL,'停车',NULL,12,NULL),('吉ETEDDG','908',NULL,NULL,NULL,NULL,NULL,NULL,'停车',NULL,16,NULL),('吉EXEMZD','357',NULL,NULL,NULL,NULL,NULL,NULL,'停车',NULL,20,NULL),('吉FDX6B4','412',NULL,NULL,NULL,NULL,NULL,NULL,'停车',NULL,15,NULL),('吉FJEBX2','403',NULL,NULL,NULL,NULL,NULL,NULL,'停车',NULL,6,NULL),('吉FRK58R','799',NULL,NULL,NULL,NULL,NULL,NULL,'停车',NULL,11,NULL),('吉GBFTC8','412',NULL,NULL,NULL,NULL,NULL,NULL,'停车',NULL,14,NULL),('吉H3GZAP','111',NULL,NULL,NULL,NULL,NULL,NULL,'停车',NULL,1,NULL),('吉HMEPQE','111',NULL,NULL,NULL,NULL,NULL,NULL,'停车',NULL,18,NULL),('吉JAGNHR','421',NULL,NULL,NULL,NULL,NULL,NULL,'停车',NULL,11,NULL),('吉JJFMAD','111',NULL,NULL,NULL,NULL,NULL,NULL,'停车',NULL,16,NULL),('吉KCQJPK','412',NULL,NULL,NULL,NULL,NULL,NULL,'停车',NULL,4,NULL),('吉MWJYTH','421',NULL,NULL,NULL,NULL,NULL,NULL,'停车',NULL,20,NULL),('吉MWXRZ8','655',NULL,NULL,NULL,NULL,NULL,NULL,'停车',NULL,15,NULL),('吉P4Y5SE','357',NULL,NULL,NULL,NULL,NULL,NULL,'停车',NULL,9,NULL),('吉QDNZBX','908',NULL,NULL,NULL,NULL,NULL,NULL,'停车',NULL,4,NULL),('吉QXW3XK','503',NULL,NULL,NULL,NULL,NULL,NULL,'停车',NULL,19,NULL),('吉QYIFSN','403',NULL,NULL,NULL,NULL,NULL,NULL,'停车',NULL,9,NULL),('吉RPZKPR','421',NULL,NULL,NULL,NULL,NULL,NULL,'停车',NULL,12,NULL),('吉SP7JBD','111',NULL,NULL,NULL,NULL,NULL,NULL,'停车',NULL,7,NULL),('吉TPGDTJ','655',NULL,NULL,NULL,NULL,NULL,NULL,'停车',NULL,17,NULL),('吉ZWT3D5','403',NULL,NULL,NULL,NULL,NULL,NULL,'停车',NULL,20,NULL),('宁AE4N88','412',NULL,NULL,NULL,NULL,NULL,NULL,'停车',NULL,19,NULL),('宁AEJ6TP','911',NULL,NULL,NULL,NULL,NULL,NULL,'停车',NULL,9,NULL),('宁BYFHJZ','111',NULL,NULL,NULL,NULL,NULL,NULL,'停车',NULL,5,NULL),('宁BYJJBP','655',NULL,NULL,NULL,NULL,NULL,NULL,'停车',NULL,11,NULL),('宁CPFQFZ','911',NULL,NULL,NULL,NULL,NULL,NULL,'停车',NULL,7,NULL),('宁DXT6AB','357',NULL,NULL,NULL,NULL,NULL,NULL,'停车',NULL,15,NULL),('宁F3C3KE','111',NULL,NULL,NULL,NULL,NULL,NULL,'停车',NULL,1,NULL),('宁FDAR5C','421',NULL,NULL,NULL,NULL,NULL,NULL,'停车',NULL,15,NULL),('宁GDRJYK','421',NULL,NULL,NULL,NULL,NULL,NULL,'停车',NULL,4,NULL),('宁GPJH3X','403',NULL,NULL,NULL,NULL,NULL,NULL,'停车',NULL,2,NULL),('宁J7EWHX','412',NULL,NULL,NULL,NULL,NULL,NULL,'停车',NULL,18,NULL),('宁K3MKZK','581',NULL,NULL,NULL,NULL,NULL,NULL,'停车',NULL,4,NULL),('宁KEWCZK','111',NULL,NULL,NULL,NULL,NULL,NULL,'停车',NULL,3,NULL),('宁NFFBHD','655',NULL,NULL,NULL,NULL,NULL,NULL,'停车',NULL,19,NULL),('宁NW727T','111',NULL,NULL,NULL,NULL,NULL,NULL,'停车',NULL,20,NULL),('宁QDR4WR','908',NULL,NULL,NULL,NULL,NULL,NULL,'停车',NULL,13,NULL),('宁RBJKRI','421',NULL,NULL,NULL,NULL,NULL,NULL,'停车',NULL,11,NULL),('宁TTQW4T','357',NULL,NULL,NULL,NULL,NULL,NULL,'停车',NULL,15,NULL),('宁WQEGW2','111',NULL,NULL,NULL,NULL,NULL,NULL,'停车',NULL,10,NULL),('宁XAXPR5','111',NULL,NULL,NULL,NULL,NULL,NULL,'停车',NULL,18,NULL),('宁YF3DHR','655',NULL,NULL,NULL,NULL,NULL,NULL,'停车',NULL,12,NULL),('宁YQ6DMK','412',NULL,NULL,NULL,NULL,NULL,NULL,'停车',NULL,1,NULL),('宁Z8ADCP','911',NULL,NULL,NULL,NULL,NULL,NULL,'停车',NULL,10,NULL),('宁ZYPTWM','412',NULL,NULL,NULL,NULL,NULL,NULL,'停车',NULL,13,NULL),('川BHSSEA','412',NULL,NULL,NULL,NULL,NULL,NULL,'停车',NULL,16,NULL),('川BNK4KZ','421',NULL,NULL,NULL,NULL,NULL,NULL,'停车',NULL,14,NULL),('川CS7C8J','908',NULL,NULL,NULL,NULL,NULL,NULL,'停车',NULL,3,NULL),('川D6FTA2','799',NULL,NULL,NULL,NULL,NULL,NULL,'停车',NULL,13,NULL),('川FBB4J6','412',NULL,NULL,NULL,NULL,NULL,NULL,'停车',NULL,11,NULL),('川GDMMXM','111',NULL,NULL,NULL,NULL,NULL,NULL,'停车',NULL,19,NULL),('川HCZJME','911',NULL,NULL,NULL,NULL,NULL,NULL,'停车',NULL,10,NULL),('川HDC6Y6','412',NULL,NULL,NULL,NULL,NULL,NULL,'停车',NULL,20,NULL),('川HG37SN','655',NULL,NULL,NULL,NULL,NULL,NULL,'停车',NULL,12,NULL),('川HIRBJR','421',NULL,NULL,NULL,NULL,NULL,NULL,'停车',NULL,12,NULL),('川JFDRZI','655',NULL,NULL,NULL,NULL,NULL,NULL,'停车',NULL,11,NULL),('川MFSSAB','412',NULL,NULL,NULL,NULL,NULL,NULL,'停车',NULL,4,NULL),('川MGCKGW','503',NULL,NULL,NULL,NULL,NULL,NULL,'停车',NULL,5,NULL),('川N85CPB','911',NULL,NULL,NULL,NULL,NULL,NULL,'停车',NULL,3,NULL),('川PBSZE5','412',NULL,NULL,NULL,NULL,NULL,NULL,'停车',NULL,14,NULL),('川PCAPBZ','412',NULL,NULL,NULL,NULL,NULL,NULL,'停车',NULL,17,NULL),('川RCYKC8','412',NULL,NULL,NULL,NULL,NULL,NULL,'停车',NULL,16,NULL),('川S58NAK','911',NULL,NULL,NULL,NULL,NULL,NULL,'停车',NULL,5,NULL),('川S5BD2M','911',NULL,NULL,NULL,NULL,NULL,NULL,'停车',NULL,7,NULL),('川YFTHMT','421',NULL,NULL,NULL,NULL,NULL,NULL,'停车',NULL,8,NULL),('川YNJI2H','503',NULL,NULL,NULL,NULL,NULL,NULL,'停车',NULL,3,NULL),('川YNS3WW','655',NULL,NULL,NULL,NULL,NULL,NULL,'停车',NULL,16,NULL),('新CCXWXP','581',NULL,NULL,NULL,NULL,NULL,NULL,'停车',NULL,4,NULL),('新GSHZQE','908',NULL,NULL,NULL,NULL,NULL,NULL,'停车',NULL,17,NULL),('新HHJMEP','111',NULL,NULL,NULL,NULL,NULL,NULL,'停车',NULL,14,NULL),('新KHY32K','403',NULL,NULL,NULL,NULL,NULL,NULL,'停车',NULL,13,NULL),('新NDPPYR','403',NULL,NULL,NULL,NULL,NULL,NULL,'停车',NULL,19,NULL),('新P5WWMZ','908',NULL,NULL,NULL,NULL,NULL,NULL,'停车',NULL,3,NULL),('新PRRZX4','911',NULL,NULL,NULL,NULL,NULL,NULL,'停车',NULL,16,NULL),('新QKWHST','421',NULL,NULL,NULL,NULL,NULL,NULL,'停车',NULL,4,NULL),('新RCY6TX','655',NULL,NULL,NULL,NULL,NULL,NULL,'停车',NULL,19,NULL),('新RNY5ZA','503',NULL,NULL,NULL,NULL,NULL,NULL,'停车',NULL,19,NULL),('新SHYER8','357',NULL,NULL,NULL,NULL,NULL,NULL,'停车',NULL,10,NULL),('新WBBEJY','799',NULL,NULL,NULL,NULL,NULL,NULL,'停车',NULL,2,NULL),('新WC3WBQ','581',NULL,NULL,NULL,NULL,NULL,NULL,'停车',NULL,7,NULL),('新Z7X3XD','581',NULL,NULL,NULL,NULL,NULL,NULL,'停车',NULL,11,NULL),('晋ARIXMI','403',NULL,NULL,NULL,NULL,NULL,NULL,'停车',NULL,11,NULL),('晋CEDRDB','655',NULL,NULL,NULL,NULL,NULL,NULL,'停车',NULL,9,NULL),('晋ERRJHS','655',NULL,NULL,NULL,NULL,NULL,NULL,'停车',NULL,10,NULL),('晋HRWFRP','357',NULL,NULL,NULL,NULL,NULL,NULL,'停车',NULL,6,NULL),('晋R23SEY','357',NULL,NULL,NULL,NULL,NULL,NULL,'停车',NULL,18,NULL),('晋RPF7RT','799',NULL,NULL,NULL,NULL,NULL,NULL,'停车',NULL,4,NULL),('晋TPBMPI','908',NULL,NULL,NULL,NULL,NULL,NULL,'停车',NULL,1,NULL),('晋WWJBNP','911',NULL,NULL,NULL,NULL,NULL,NULL,'停车',NULL,18,NULL),('桂A2TPRS','357',NULL,NULL,NULL,NULL,NULL,NULL,'停车',NULL,15,NULL),('桂AM6AAF','412',NULL,NULL,NULL,NULL,NULL,NULL,'停车',NULL,3,NULL),('桂BJYADC','581',NULL,NULL,NULL,NULL,NULL,NULL,'停车',NULL,12,NULL),('桂DNR6TM','799',NULL,NULL,NULL,NULL,NULL,NULL,'停车',NULL,1,NULL),('桂EZE8HK','908',NULL,NULL,NULL,NULL,NULL,NULL,'停车',NULL,6,NULL),('桂FAKQJB','403',NULL,NULL,NULL,NULL,NULL,NULL,'停车',NULL,7,NULL),('桂KJ5FFK','403',NULL,NULL,NULL,NULL,NULL,NULL,'停车',NULL,6,NULL),('桂M7DEED','911',NULL,NULL,NULL,NULL,NULL,NULL,'停车',NULL,16,NULL),('桂M7KXRY','581',NULL,NULL,NULL,NULL,NULL,NULL,'停车',NULL,13,NULL),('桂MWCRJC','503',NULL,NULL,NULL,NULL,NULL,NULL,'停车',NULL,15,NULL),('桂N6DHN4','412',NULL,NULL,NULL,NULL,NULL,NULL,'停车',NULL,10,NULL),('桂NCXBCE','412',NULL,NULL,NULL,NULL,NULL,NULL,'停车',NULL,4,NULL),('桂NPSYZN','421',NULL,NULL,NULL,NULL,NULL,NULL,'停车',NULL,3,NULL),('桂PWFGZY','403',NULL,NULL,NULL,NULL,NULL,NULL,'停车',NULL,5,NULL),('桂RKHNFS','421',NULL,NULL,NULL,NULL,NULL,NULL,'停车',NULL,13,NULL),('桂SF7DRX','412',NULL,NULL,NULL,NULL,NULL,NULL,'停车',NULL,15,NULL),('桂WZ7EBF','581',NULL,NULL,NULL,NULL,NULL,NULL,'停车',NULL,2,NULL),('桂ZSESE7','421',NULL,NULL,NULL,NULL,NULL,NULL,'停车',NULL,17,NULL),('沪AHFFNS','908',NULL,NULL,NULL,NULL,NULL,NULL,'停车',NULL,5,NULL),('沪BJ2DZQ','911',NULL,NULL,NULL,NULL,NULL,NULL,'停车',NULL,3,NULL),('沪EMCPKX','503',NULL,NULL,NULL,NULL,NULL,NULL,'停车',NULL,1,NULL),('沪FEMMEG','503',NULL,NULL,NULL,NULL,NULL,NULL,'停车',NULL,7,NULL),('沪G7BI2K','357',NULL,NULL,NULL,NULL,NULL,NULL,'停车',NULL,1,NULL),('沪KRX7RS','503',NULL,NULL,NULL,NULL,NULL,NULL,'停车',NULL,13,NULL),('沪MJDMRE','412',NULL,NULL,NULL,NULL,NULL,NULL,'停车',NULL,18,NULL),('沪QAIBPT','412',NULL,NULL,NULL,NULL,NULL,NULL,'停车',NULL,19,NULL),('沪RRTJNI','412',NULL,NULL,NULL,NULL,NULL,NULL,'停车',NULL,13,NULL),('沪RZCNMX','412',NULL,NULL,NULL,NULL,NULL,NULL,'停车',NULL,11,NULL),('沪S27DX7','911',NULL,NULL,NULL,NULL,NULL,NULL,'停车',NULL,8,NULL),('沪SDCXCV','412',NULL,'123',1495030560,'一级',23,1496153797,'停车',NULL,1,3),('沪SYPHRF','412',NULL,NULL,NULL,NULL,NULL,NULL,'停车',NULL,11,NULL),('沪WRDACE','421',NULL,NULL,NULL,NULL,NULL,NULL,'停车',NULL,9,NULL),('沪X4DSMY','503',NULL,NULL,NULL,NULL,NULL,NULL,'停车',NULL,6,NULL),('沪YSBMKX','799',NULL,NULL,NULL,NULL,NULL,NULL,'停车',NULL,19,NULL),('津E7BTTH','581',NULL,NULL,NULL,NULL,NULL,NULL,'停车',NULL,11,NULL),('津HTGWMK','412',NULL,NULL,NULL,NULL,NULL,NULL,'停车',NULL,18,NULL),('津KJ8E6R','911',NULL,NULL,NULL,NULL,NULL,NULL,'停车',NULL,3,NULL),('津P7YZPS','908',NULL,NULL,NULL,NULL,NULL,NULL,'停车',NULL,15,NULL),('津QEKZFM','503',NULL,NULL,NULL,NULL,NULL,NULL,'停车',NULL,20,NULL),('津REXRTB','655',NULL,NULL,NULL,NULL,NULL,NULL,'停车',NULL,15,NULL),('津SHQYEY','403',NULL,NULL,NULL,NULL,NULL,NULL,'停车',NULL,13,NULL),('津YTMMWW','799',NULL,NULL,NULL,NULL,NULL,NULL,'停车',NULL,2,NULL),('津ZAFBDX','357',NULL,NULL,NULL,NULL,NULL,NULL,'停车',NULL,6,NULL),('浙A7RSPJ','581',NULL,NULL,NULL,NULL,NULL,NULL,'停车',NULL,20,NULL),('浙B4IRKF','911',NULL,NULL,NULL,NULL,NULL,NULL,'停车',NULL,11,NULL),('浙BIQJ3H','908',NULL,NULL,NULL,NULL,NULL,NULL,'停车',NULL,8,NULL),('浙FPHPMW','412',NULL,NULL,NULL,NULL,NULL,NULL,'停车',NULL,10,NULL),('浙FR5FFI','911',NULL,NULL,NULL,NULL,NULL,NULL,'停车',NULL,9,NULL),('浙GKQJPK','412',NULL,NULL,NULL,NULL,NULL,NULL,'停车',NULL,6,NULL),('浙JETEFJ','799',NULL,NULL,NULL,NULL,NULL,NULL,'停车',NULL,16,NULL),('浙K8GYKH','357',NULL,NULL,NULL,NULL,NULL,NULL,'停车',NULL,20,NULL),('浙M5M4QJ','908',NULL,NULL,NULL,NULL,NULL,NULL,'停车',NULL,17,NULL),('浙MERP4F','403',NULL,NULL,NULL,NULL,NULL,NULL,'停车',NULL,17,NULL),('浙QF7EHH','799',NULL,NULL,NULL,NULL,NULL,NULL,'停车',NULL,17,NULL),('浙RTC7P5','403',NULL,NULL,NULL,NULL,NULL,NULL,'停车',NULL,10,NULL),('浙S8N6SY','412',NULL,NULL,NULL,NULL,NULL,NULL,'停车',NULL,14,NULL),('浙SDPCKN','581',NULL,NULL,NULL,NULL,NULL,NULL,'停车',NULL,14,NULL),('浙TBSS2C','412',NULL,NULL,NULL,NULL,NULL,NULL,'停车',NULL,6,NULL),('渝212334','403',NULL,'dfg',1,'新车',123,1496333878,'停车',NULL,1,7),('渝ASWQZP','908',NULL,NULL,NULL,NULL,NULL,NULL,'停车',NULL,1,NULL),('渝CCZWYW','412',NULL,NULL,NULL,NULL,NULL,NULL,'停车',NULL,2,NULL),('渝CM2B2Q','412',NULL,NULL,NULL,NULL,NULL,NULL,'停车',NULL,19,NULL),('渝CWDJSB','412',NULL,NULL,NULL,NULL,NULL,NULL,'停车',NULL,2,NULL),('渝EPZTJG','581',NULL,NULL,NULL,NULL,NULL,NULL,'停车',NULL,13,NULL),('渝F2X554','357',NULL,NULL,NULL,NULL,NULL,NULL,'停车',NULL,17,NULL),('渝F8S2HA','412',NULL,NULL,NULL,NULL,NULL,NULL,'停车',NULL,8,NULL),('渝FMNBND','581',NULL,NULL,NULL,NULL,NULL,NULL,'停车',NULL,20,NULL),('渝GGKKPY','911',NULL,NULL,NULL,NULL,NULL,NULL,'停车',NULL,14,NULL),('渝GSE4RN','412',NULL,NULL,NULL,NULL,NULL,NULL,'停车',NULL,12,NULL),('渝JXFNSI','357',NULL,NULL,NULL,NULL,NULL,NULL,'停车',NULL,12,NULL),('渝KTNDFX','911',NULL,NULL,NULL,NULL,NULL,NULL,'停车',NULL,19,NULL),('渝MNFD5P','581',NULL,NULL,NULL,NULL,NULL,NULL,'停车',NULL,8,NULL),('渝P55FSK','655',NULL,NULL,NULL,NULL,NULL,NULL,'停车',NULL,1,NULL),('渝PHFZ3B','581',NULL,NULL,NULL,NULL,NULL,NULL,'停车',NULL,7,NULL),('渝PYDNNN','911',NULL,NULL,NULL,NULL,NULL,NULL,'停车',NULL,16,NULL),('渝QKPJ8Z','412',NULL,NULL,NULL,NULL,NULL,NULL,'停车',NULL,13,NULL),('渝STXKE4','421',NULL,NULL,NULL,NULL,NULL,NULL,'停车',NULL,9,NULL),('渝TF8CDD','908',NULL,NULL,NULL,NULL,NULL,NULL,'停车',NULL,3,NULL),('渝W5GE6G','503',NULL,NULL,NULL,NULL,NULL,NULL,'停车',NULL,14,NULL),('湘A4K2DT','412',NULL,NULL,NULL,NULL,NULL,NULL,'停车',NULL,15,NULL),('湘H4QARE','412',NULL,NULL,NULL,NULL,NULL,NULL,'停车',NULL,12,NULL),('湘KBHSWC','412',NULL,NULL,NULL,NULL,NULL,NULL,'停车',NULL,12,NULL),('湘M5IWAY','412',NULL,NULL,NULL,NULL,NULL,NULL,'停车',NULL,14,NULL),('湘NJJNMS','503',NULL,NULL,NULL,NULL,NULL,NULL,'停车',NULL,10,NULL),('湘PTBKXT','421',NULL,NULL,NULL,NULL,NULL,NULL,'停车',NULL,19,NULL),('湘QNJE7G','503',NULL,NULL,NULL,NULL,NULL,NULL,'停车',NULL,16,NULL),('湘RJ6ZHF','581',NULL,NULL,NULL,NULL,NULL,NULL,'停车',NULL,12,NULL),('湘XEWSMP','421',NULL,NULL,NULL,NULL,NULL,NULL,'停车',NULL,1,NULL),('琼BD7I2B','357',NULL,NULL,NULL,NULL,NULL,NULL,'停车',NULL,4,NULL),('琼CTDBAK','412',NULL,NULL,NULL,NULL,NULL,NULL,'停车',NULL,6,NULL),('琼DCQYMT','911',NULL,NULL,NULL,NULL,NULL,NULL,'停车',NULL,12,NULL),('琼FKZ38X','503',NULL,NULL,NULL,NULL,NULL,NULL,'停车',NULL,4,NULL),('琼H44AJQ','111',NULL,NULL,NULL,NULL,NULL,NULL,'停车',NULL,7,NULL),('琼KB74EM','655',NULL,NULL,NULL,NULL,NULL,NULL,'停车',NULL,4,NULL),('琼MRXF2B','357',NULL,NULL,NULL,NULL,NULL,NULL,'停车',NULL,11,NULL),('琼NB6NMY','412',NULL,NULL,NULL,NULL,NULL,NULL,'停车',NULL,18,NULL),('琼NH3BWY','412',NULL,NULL,NULL,NULL,NULL,NULL,'停车',NULL,2,NULL),('琼P2QNBS','421',NULL,NULL,NULL,NULL,NULL,NULL,'停车',NULL,5,NULL),('琼QEJF2B','503',NULL,NULL,NULL,NULL,NULL,NULL,'停车',NULL,13,NULL),('琼RG8X6H','503',NULL,NULL,NULL,NULL,NULL,NULL,'停车',NULL,2,NULL),('琼XAYB7S','581',NULL,NULL,NULL,NULL,NULL,NULL,'停车',NULL,18,NULL),('琼ZETFTZ','503',NULL,NULL,NULL,NULL,NULL,NULL,'停车',NULL,4,NULL),('琼ZW5YPZ','911',NULL,NULL,NULL,NULL,NULL,NULL,'停车',NULL,13,NULL),('甘ATKNIJ','503',NULL,NULL,NULL,NULL,NULL,NULL,'停车',NULL,12,NULL),('甘B4QGXD','655',NULL,NULL,NULL,NULL,NULL,NULL,'停车',NULL,7,NULL),('甘BAFWEB','581',NULL,NULL,NULL,NULL,NULL,NULL,'停车',NULL,7,NULL),('甘BFCAFW','581',NULL,NULL,NULL,NULL,NULL,NULL,'停车',NULL,13,NULL),('甘DWAXDD','412',NULL,NULL,NULL,NULL,NULL,NULL,'停车',NULL,19,NULL),('甘GACFQC','911',NULL,NULL,NULL,NULL,NULL,NULL,'停车',NULL,12,NULL),('甘GCZF3I','908',NULL,NULL,NULL,NULL,NULL,NULL,'停车',NULL,5,NULL),('甘GFRXNY','111',NULL,NULL,NULL,NULL,NULL,NULL,'停车',NULL,15,NULL),('甘H4C73C','911',NULL,NULL,NULL,NULL,NULL,NULL,'停车',NULL,16,NULL),('甘HKFZRW','911',NULL,NULL,NULL,NULL,NULL,NULL,'停车',NULL,19,NULL),('甘HQ5TRC','111',NULL,NULL,NULL,NULL,NULL,NULL,'停车',NULL,6,NULL),('甘JNXDKK','111',NULL,NULL,NULL,NULL,NULL,NULL,'停车',NULL,11,NULL),('甘K43ANX','403',NULL,NULL,NULL,NULL,NULL,NULL,'停车',NULL,18,NULL),('甘KNS7DQ','503',NULL,NULL,NULL,NULL,NULL,NULL,'停车',NULL,5,NULL),('甘MJTNWK','799',NULL,NULL,NULL,NULL,NULL,NULL,'停车',NULL,3,NULL),('甘N3MDHJ','911',NULL,NULL,NULL,NULL,NULL,NULL,'停车',NULL,6,NULL),('甘NBCY7I','111',NULL,NULL,NULL,NULL,NULL,NULL,'停车',NULL,10,NULL),('甘RFHJXW','799',NULL,NULL,NULL,NULL,NULL,NULL,'停车',NULL,16,NULL),('甘RMJ6TZ','911',NULL,NULL,NULL,NULL,NULL,NULL,'停车',NULL,17,NULL),('甘WMBATB','911',NULL,NULL,NULL,NULL,NULL,NULL,'停车',NULL,13,NULL),('甘XBRCFZ','111',NULL,NULL,NULL,NULL,NULL,NULL,'停车',NULL,3,NULL),('皖AEIWE5','357',NULL,NULL,NULL,NULL,NULL,NULL,'停车',NULL,11,NULL),('皖CP8YMA','799',NULL,NULL,NULL,NULL,NULL,NULL,'停车',NULL,12,NULL),('皖CTG54K','412',NULL,NULL,NULL,NULL,NULL,NULL,'停车',NULL,1,NULL),('皖DNYYNB','403',NULL,NULL,NULL,NULL,NULL,NULL,'停车',NULL,4,NULL),('皖DWSPTY','908',NULL,NULL,NULL,NULL,NULL,NULL,'停车',NULL,8,NULL),('皖EDZ63C','908',NULL,NULL,NULL,NULL,NULL,NULL,'停车',NULL,11,NULL),('皖FHD2F4','412',NULL,NULL,NULL,NULL,NULL,NULL,'停车',NULL,14,NULL),('皖FSARRK','503',NULL,NULL,NULL,NULL,NULL,NULL,'停车',NULL,5,NULL),('皖GYBR2F','799',NULL,NULL,NULL,NULL,NULL,NULL,'停车',NULL,10,NULL),('皖JMNQAF','911',NULL,NULL,NULL,NULL,NULL,NULL,'停车',NULL,12,NULL),('皖JPYSMZ','412',NULL,NULL,NULL,NULL,NULL,NULL,'停车',NULL,7,NULL),('皖JX6PRN','911',NULL,NULL,NULL,NULL,NULL,NULL,'停车',NULL,10,NULL),('皖KPZHBH','421',NULL,NULL,NULL,NULL,NULL,NULL,'停车',NULL,16,NULL),('皖M4HIM3','412',NULL,NULL,NULL,NULL,NULL,NULL,'停车',NULL,7,NULL),('皖MJENAJ','911',NULL,NULL,NULL,NULL,NULL,NULL,'停车',NULL,6,NULL),('皖NP48SD','421',NULL,NULL,NULL,NULL,NULL,NULL,'停车',NULL,2,NULL),('皖PQJBX6','412',NULL,NULL,NULL,NULL,NULL,NULL,'停车',NULL,5,NULL),('皖QWTHDI','111',NULL,NULL,NULL,NULL,NULL,NULL,'停车',NULL,9,NULL),('皖RIAJRP','111',NULL,NULL,NULL,NULL,NULL,NULL,'停车',NULL,4,NULL),('皖S4A5TR','503',NULL,NULL,NULL,NULL,NULL,NULL,'停车',NULL,12,NULL),('皖TM85TM','503',NULL,NULL,NULL,NULL,NULL,NULL,'停车',NULL,16,NULL),('皖TRARMK','412',NULL,NULL,NULL,NULL,NULL,NULL,'停车',NULL,19,NULL),('皖WD5Y4S','412',NULL,NULL,NULL,NULL,NULL,NULL,'停车',NULL,6,NULL),('皖Y5FZCY','403',NULL,NULL,NULL,NULL,NULL,NULL,'停车',NULL,11,NULL),('皖ZFFD2T','357',NULL,NULL,NULL,NULL,NULL,NULL,'停车',NULL,10,NULL),('粤AZS4R8','503',NULL,NULL,NULL,NULL,NULL,NULL,'停车',NULL,20,NULL),('粤D3D2ST','655',NULL,NULL,NULL,NULL,NULL,NULL,'停车',NULL,12,NULL),('粤F52YTA','111',NULL,NULL,NULL,NULL,NULL,NULL,'停车',NULL,15,NULL),('粤HPWPHT','111',NULL,NULL,NULL,NULL,NULL,NULL,'停车',NULL,15,NULL),('粤J5AEI8','908',NULL,NULL,NULL,NULL,NULL,NULL,'停车',NULL,12,NULL),('粤QJ3KWK','908',NULL,NULL,NULL,NULL,NULL,NULL,'停车',NULL,18,NULL),('粤RWZ6ZM','911',NULL,NULL,NULL,NULL,NULL,NULL,'停车',NULL,7,NULL),('粤TJXNT5','908',NULL,NULL,NULL,NULL,NULL,NULL,'停车',NULL,7,NULL),('粤XPWRAD','111',NULL,NULL,NULL,NULL,NULL,NULL,'停车',NULL,19,NULL),('粤XYMKMD','412',NULL,NULL,NULL,NULL,NULL,NULL,'停车',NULL,10,NULL),('粤Y7YNPF','503',NULL,NULL,NULL,NULL,NULL,NULL,'停车',NULL,15,NULL),('粤Y8MPMG','403',NULL,NULL,NULL,NULL,NULL,NULL,'停车',NULL,8,NULL),('苏AD2YBR','412',NULL,NULL,NULL,NULL,NULL,NULL,'停车',NULL,2,NULL),('苏AYTMNC','421',NULL,NULL,NULL,NULL,NULL,NULL,'停车',NULL,13,NULL),('苏GRC6XI','503',NULL,NULL,NULL,NULL,NULL,NULL,'停车',NULL,13,NULL),('苏GYNMET','412',NULL,NULL,NULL,NULL,NULL,NULL,'停车',NULL,13,NULL),('苏HR5C2P','111',NULL,NULL,NULL,NULL,NULL,NULL,'停车',NULL,4,NULL),('苏J8YART','357',NULL,NULL,NULL,NULL,NULL,NULL,'停车',NULL,3,NULL),('苏KM8SRT','503',NULL,NULL,NULL,NULL,NULL,NULL,'停车',NULL,10,NULL),('苏MEHWET','503',NULL,NULL,NULL,NULL,NULL,NULL,'停车',NULL,6,NULL),('苏NHSP3F','421',NULL,NULL,NULL,NULL,NULL,NULL,'停车',NULL,16,NULL),('苏RHCW6E','908',NULL,NULL,NULL,NULL,NULL,NULL,'停车',NULL,17,NULL),('苏SSDPQT','421',NULL,NULL,NULL,NULL,NULL,NULL,'停车',NULL,10,NULL),('苏TWE4WT','799',NULL,NULL,NULL,NULL,NULL,NULL,'停车',NULL,17,NULL),('苏ZITRRE','357',NULL,NULL,NULL,NULL,NULL,NULL,'停车',NULL,11,NULL),('苏ZNXDMM','799',NULL,NULL,NULL,NULL,NULL,NULL,'停车',NULL,14,NULL),('蒙ABZZIK','403',NULL,NULL,NULL,NULL,NULL,NULL,'停车',NULL,4,NULL),('蒙AWPAZS','908',NULL,NULL,NULL,NULL,NULL,NULL,'停车',NULL,20,NULL),('蒙BCF3JR','412',NULL,NULL,NULL,NULL,NULL,NULL,'停车',NULL,1,NULL),('蒙BCHTTH','503',NULL,NULL,NULL,NULL,NULL,NULL,'停车',NULL,2,NULL),('蒙CBGEHZ','799',NULL,NULL,NULL,NULL,NULL,NULL,'停车',NULL,9,NULL),('蒙DESPKE','412',NULL,NULL,NULL,NULL,NULL,NULL,'停车',NULL,17,NULL),('蒙DW4MNJ','403',NULL,NULL,NULL,NULL,NULL,NULL,'停车',NULL,7,NULL),('蒙GNZYNZ','357',NULL,NULL,NULL,NULL,NULL,NULL,'停车',NULL,14,NULL),('蒙GXBIPC','421',NULL,NULL,NULL,NULL,NULL,NULL,'停车',NULL,15,NULL),('蒙H6FBXT','403',NULL,NULL,NULL,NULL,NULL,NULL,'停车',NULL,4,NULL),('蒙HHNGEA','908',NULL,NULL,NULL,NULL,NULL,NULL,'停车',NULL,6,NULL),('蒙RJ4MME','357',NULL,NULL,NULL,NULL,NULL,NULL,'停车',NULL,3,NULL),('蒙TK2J5R','412',NULL,NULL,NULL,NULL,NULL,NULL,'停车',NULL,15,NULL),('蒙TMCJQW','412',NULL,NULL,NULL,NULL,NULL,NULL,'停车',NULL,20,NULL),('蒙TMRCSE','357',NULL,NULL,NULL,NULL,NULL,NULL,'停车',NULL,2,NULL),('蒙WKDGYK','421',NULL,NULL,NULL,NULL,NULL,NULL,'停车',NULL,8,NULL),('蒙WNJDSW','655',NULL,NULL,NULL,NULL,NULL,NULL,'停车',NULL,8,NULL),('蒙X8NIP4','911',NULL,NULL,NULL,NULL,NULL,NULL,'停车',NULL,3,NULL),('蒙XZYF7A','403',NULL,NULL,NULL,NULL,NULL,NULL,'停车',NULL,17,NULL),('蒙Y6NTMY','908',NULL,NULL,NULL,NULL,NULL,NULL,'停车',NULL,19,NULL),('蒙YFBCRW','911',NULL,NULL,NULL,NULL,NULL,NULL,'停车',NULL,8,NULL),('蒙Z7TTZA','111',NULL,NULL,NULL,NULL,NULL,NULL,'停车',NULL,19,NULL),('蒙ZHG7MT','908',NULL,NULL,NULL,NULL,NULL,NULL,'停车',NULL,7,NULL),('藏CPX47E','421',NULL,NULL,NULL,NULL,NULL,NULL,'停车',NULL,20,NULL),('藏D2SSXT','421',NULL,NULL,NULL,NULL,NULL,NULL,'停车',NULL,20,NULL),('藏GBQKNC','908',NULL,NULL,NULL,NULL,NULL,NULL,'停车',NULL,19,NULL),('藏MDNYXT','911',NULL,NULL,NULL,NULL,NULL,NULL,'停车',NULL,14,NULL),('藏NAFFQP','911',NULL,NULL,NULL,NULL,NULL,NULL,'停车',NULL,15,NULL),('藏NEANEY','412',NULL,NULL,NULL,NULL,NULL,NULL,'停车',NULL,11,NULL),('藏RWGATJ','799',NULL,NULL,NULL,NULL,NULL,NULL,'停车',NULL,11,NULL),('藏SXXBZF','908',NULL,NULL,NULL,NULL,NULL,NULL,'停车',NULL,5,NULL),('藏T3ECM7','111',NULL,NULL,NULL,NULL,NULL,NULL,'停车',NULL,20,NULL),('藏TZ7IQF','111',NULL,NULL,NULL,NULL,NULL,NULL,'停车',NULL,7,NULL),('藏WIBYIM','111',NULL,NULL,NULL,NULL,NULL,NULL,'停车',NULL,9,NULL),('藏WNIPJE','799',NULL,NULL,NULL,NULL,NULL,NULL,'停车',NULL,17,NULL),('藏ZG5TNR','908',NULL,NULL,NULL,NULL,NULL,NULL,'停车',NULL,6,NULL),('豫B5X6KB','503',NULL,NULL,NULL,NULL,NULL,NULL,'停车',NULL,9,NULL),('豫DFMXT3','111',NULL,NULL,NULL,NULL,NULL,NULL,'停车',NULL,7,NULL),('豫E5IP68','911',NULL,NULL,NULL,NULL,NULL,NULL,'停车',NULL,7,NULL),('豫EF4DTE','655',NULL,NULL,NULL,NULL,NULL,NULL,'停车',NULL,4,NULL),('豫EWPAFZ','403',NULL,NULL,NULL,NULL,NULL,NULL,'停车',NULL,11,NULL),('豫KXXS7C','503',NULL,NULL,NULL,NULL,NULL,NULL,'停车',NULL,11,NULL),('豫M8IRCI','357',NULL,NULL,NULL,NULL,NULL,NULL,'停车',NULL,3,NULL),('豫PW7FEZ','503',NULL,NULL,NULL,NULL,NULL,NULL,'停车',NULL,13,NULL),('豫PWTAZR','403',NULL,NULL,NULL,NULL,NULL,NULL,'停车',NULL,1,NULL),('豫Q7RYYA','655',NULL,NULL,NULL,NULL,NULL,NULL,'停车',NULL,5,NULL),('豫WWAAFF','503',NULL,NULL,NULL,NULL,NULL,NULL,'停车',NULL,14,NULL),('豫XKTDDX','581',NULL,NULL,NULL,NULL,NULL,NULL,'停车',NULL,11,NULL),('豫YWYPKX','412',NULL,NULL,NULL,NULL,NULL,NULL,'停车',NULL,12,NULL),('贵BKZ2ST','412',NULL,NULL,NULL,NULL,NULL,NULL,'停车',NULL,13,NULL),('贵CKAY4E','581',NULL,NULL,NULL,NULL,NULL,NULL,'停车',NULL,14,NULL),('贵CPKCWM','503',NULL,NULL,NULL,NULL,NULL,NULL,'停车',NULL,1,NULL),('贵FKZ64Z','911',NULL,NULL,NULL,NULL,NULL,NULL,'停车',NULL,6,NULL),('贵NM5WBC','581',NULL,NULL,NULL,NULL,NULL,NULL,'停车',NULL,7,NULL),('贵PHQWXJ','911',NULL,NULL,NULL,NULL,NULL,NULL,'停车',NULL,15,NULL),('贵QEFXDR','655',NULL,NULL,NULL,NULL,NULL,NULL,'停车',NULL,20,NULL),('贵QR4K4R','799',NULL,NULL,NULL,NULL,NULL,NULL,'停车',NULL,4,NULL),('贵SJ2CT5','655',NULL,NULL,NULL,NULL,NULL,NULL,'停车',NULL,11,NULL),('贵T36MSR','403',NULL,NULL,NULL,NULL,NULL,NULL,'停车',NULL,14,NULL),('贵TE63M3','655',NULL,NULL,NULL,NULL,NULL,NULL,'停车',NULL,20,NULL),('贵TWCDC8','421',NULL,NULL,NULL,NULL,NULL,NULL,'停车',NULL,3,NULL),('贵ZZPKMP','503',NULL,NULL,NULL,NULL,NULL,NULL,'停车',NULL,10,NULL),('赣ATTQRX','357',NULL,NULL,NULL,NULL,NULL,NULL,'停车',NULL,13,NULL),('赣BWWPYP','412',NULL,NULL,NULL,NULL,NULL,NULL,'停车',NULL,11,NULL),('赣DCRC4A','412',NULL,NULL,NULL,NULL,NULL,NULL,'停车',NULL,20,NULL),('赣DMSSXF','908',NULL,NULL,NULL,NULL,NULL,NULL,'停车',NULL,7,NULL),('赣EDHFJS','581',NULL,NULL,NULL,NULL,NULL,NULL,'停车',NULL,5,NULL),('赣ETEYAH','503',NULL,NULL,NULL,NULL,NULL,NULL,'停车',NULL,8,NULL),('赣FKC4XH','412',NULL,NULL,NULL,NULL,NULL,NULL,'停车',NULL,4,NULL),('赣GWQAEB','503',NULL,NULL,NULL,NULL,NULL,NULL,'停车',NULL,20,NULL),('赣JIAQ88','908',NULL,NULL,NULL,NULL,NULL,NULL,'停车',NULL,2,NULL),('赣JZMWQA','581',NULL,NULL,NULL,NULL,NULL,NULL,'停车',NULL,15,NULL),('赣MS2FEW','911',NULL,NULL,NULL,NULL,NULL,NULL,'停车',NULL,13,NULL),('赣QTT24J','111',NULL,NULL,NULL,NULL,NULL,NULL,'停车',NULL,2,NULL),('赣SXYCRQ','503',NULL,NULL,NULL,NULL,NULL,NULL,'停车',NULL,10,NULL),('赣TMWGIF','503',NULL,NULL,NULL,NULL,NULL,NULL,'停车',NULL,10,NULL),('辽ECHXEY','412',NULL,NULL,NULL,NULL,NULL,NULL,'停车',NULL,11,NULL),('辽EY8JRW','908',NULL,NULL,NULL,NULL,NULL,NULL,'停车',NULL,2,NULL),('辽HYTCA8','655',NULL,NULL,NULL,NULL,NULL,NULL,'停车',NULL,9,NULL),('辽JXT26W','111',NULL,NULL,NULL,NULL,NULL,NULL,'停车',NULL,19,NULL),('辽K4HHZZ','911',NULL,NULL,NULL,NULL,NULL,NULL,'停车',NULL,11,NULL),('辽MTRTZK','412',NULL,NULL,NULL,NULL,NULL,NULL,'停车',NULL,1,NULL),('辽PFJ4GX','357',NULL,NULL,NULL,NULL,NULL,NULL,'停车',NULL,7,NULL),('辽QYQ6WT','421',NULL,NULL,NULL,NULL,NULL,NULL,'停车',NULL,11,NULL),('辽RYDXNJ','503',NULL,NULL,NULL,NULL,NULL,NULL,'停车',NULL,2,NULL),('辽SXJWA5','111',NULL,NULL,NULL,NULL,NULL,NULL,'停车',NULL,9,NULL),('辽TKCF72','655',NULL,NULL,NULL,NULL,NULL,NULL,'停车',NULL,17,NULL),('辽TZPXN2','412',NULL,NULL,NULL,NULL,NULL,NULL,'停车',NULL,19,NULL),('辽WCC8QY','799',NULL,NULL,NULL,NULL,NULL,NULL,'停车',NULL,11,NULL),('辽WNZHQR','655',NULL,NULL,NULL,NULL,NULL,NULL,'停车',NULL,19,NULL),('鄂CWWG2B','911',NULL,NULL,NULL,NULL,NULL,NULL,'停车',NULL,13,NULL),('鄂DM7X5F','503',NULL,NULL,NULL,NULL,NULL,NULL,'停车',NULL,4,NULL),('鄂DWKMKF','403',NULL,NULL,NULL,NULL,NULL,NULL,'停车',NULL,4,NULL),('鄂EGEAIF','503',NULL,NULL,NULL,NULL,NULL,NULL,'停车',NULL,4,NULL),('鄂RMAKHM','403',NULL,NULL,NULL,NULL,NULL,NULL,'停车',NULL,12,NULL),('鄂RXWZ58','412',NULL,NULL,NULL,NULL,NULL,NULL,'停车',NULL,6,NULL),('鄂STYNZX','908',NULL,NULL,NULL,NULL,NULL,NULL,'停车',NULL,1,NULL),('鄂WSHBMX','503',NULL,NULL,NULL,NULL,NULL,NULL,'停车',NULL,16,NULL),('鄂WYSCEK','911',NULL,NULL,NULL,NULL,NULL,NULL,'停车',NULL,3,NULL),('鄂XFCCW8','799',NULL,NULL,NULL,NULL,NULL,NULL,'停车',NULL,7,NULL),('鄂XFSQXG','403',NULL,NULL,NULL,NULL,NULL,NULL,'停车',NULL,2,NULL),('鄂YR7AFX','111',NULL,NULL,NULL,NULL,NULL,NULL,'停车',NULL,20,NULL),('鄂ZN3M8S','412',NULL,NULL,NULL,NULL,NULL,NULL,'停车',NULL,8,NULL),('闽AHJPCK','403',NULL,NULL,NULL,NULL,NULL,NULL,'停车',NULL,19,NULL),('闽AQM66Y','412',NULL,NULL,NULL,NULL,NULL,NULL,'停车',NULL,6,NULL),('闽B4S3TP','908',NULL,NULL,NULL,NULL,NULL,NULL,'停车',NULL,4,NULL),('闽BZ76KX','655',NULL,NULL,NULL,NULL,NULL,NULL,'停车',NULL,4,NULL),('闽CG5SAX','403',NULL,NULL,NULL,NULL,NULL,NULL,'停车',NULL,7,NULL),('闽DMMYMK','799',NULL,NULL,NULL,NULL,NULL,NULL,'停车',NULL,14,NULL),('闽DNW8EP','412',NULL,NULL,NULL,NULL,NULL,NULL,'停车',NULL,16,NULL),('闽FHN3B4','111',NULL,NULL,NULL,NULL,NULL,NULL,'停车',NULL,16,NULL),('闽GKWWB2','111',NULL,NULL,NULL,NULL,NULL,NULL,'停车',NULL,17,NULL),('闽HH8Y3H','412',NULL,NULL,NULL,NULL,NULL,NULL,'停车',NULL,15,NULL),('闽HSH7MN','412',NULL,NULL,NULL,NULL,NULL,NULL,'停车',NULL,5,NULL),('闽JEZPFH','911',NULL,NULL,NULL,NULL,NULL,NULL,'停车',NULL,4,NULL),('闽MM8CYJ','421',NULL,NULL,NULL,NULL,NULL,NULL,'停车',NULL,17,NULL),('闽R7PZDN','655',NULL,NULL,NULL,NULL,NULL,NULL,'停车',NULL,18,NULL),('闽RB8IYP','357',NULL,NULL,NULL,NULL,NULL,NULL,'停车',NULL,3,NULL),('闽S7FPHA','503',NULL,NULL,NULL,NULL,NULL,NULL,'停车',NULL,19,NULL),('闽SNPKDE','111',NULL,NULL,NULL,NULL,NULL,NULL,'停车',NULL,5,NULL),('闽W7ZZBW','421',NULL,NULL,NULL,NULL,NULL,NULL,'停车',NULL,7,NULL),('闽WTBSJQ','111',NULL,NULL,NULL,NULL,NULL,NULL,'停车',NULL,2,NULL),('闽YNRJHT','412',NULL,NULL,NULL,NULL,NULL,NULL,'停车',NULL,12,NULL),('闽YR2BSK','111',NULL,NULL,NULL,NULL,NULL,NULL,'停车',NULL,4,NULL),('陕BWXKPK','655',NULL,NULL,NULL,NULL,NULL,NULL,'停车',NULL,16,NULL),('陕CNHCPE','111',NULL,NULL,NULL,NULL,NULL,NULL,'停车',NULL,8,NULL),('陕CR7KYF','503',NULL,NULL,NULL,NULL,NULL,NULL,'停车',NULL,18,NULL),('陕CXQJEC','421',NULL,NULL,NULL,NULL,NULL,NULL,'停车',NULL,20,NULL),('陕ECBRDS','357',NULL,NULL,NULL,NULL,NULL,NULL,'停车',NULL,2,NULL),('陕EJABHP','503',NULL,NULL,NULL,NULL,NULL,NULL,'停车',NULL,1,NULL),('陕GSWZD5','799',NULL,NULL,NULL,NULL,NULL,NULL,'停车',NULL,5,NULL),('陕KJWJEY','908',NULL,NULL,NULL,NULL,NULL,NULL,'停车',NULL,5,NULL),('陕N33QR6','357',NULL,NULL,NULL,NULL,NULL,NULL,'停车',NULL,9,NULL),('陕QFRJJW','111',NULL,NULL,NULL,NULL,NULL,NULL,'停车',NULL,8,NULL),('陕R6JIAY','111',NULL,NULL,NULL,NULL,NULL,NULL,'停车',NULL,3,NULL),('陕RXKAKW','357',NULL,NULL,NULL,NULL,NULL,NULL,'停车',NULL,12,NULL),('陕SJWXYX','412',NULL,NULL,NULL,NULL,NULL,NULL,'停车',NULL,19,NULL),('陕TFYTPN','403',NULL,NULL,NULL,NULL,NULL,NULL,'停车',NULL,14,NULL),('陕W6PHBH','581',NULL,NULL,NULL,NULL,NULL,NULL,'停车',NULL,9,NULL),('陕Y3TB8W','581',NULL,NULL,NULL,NULL,NULL,NULL,'停车',NULL,17,NULL),('陕ZQXHXR','503',NULL,NULL,NULL,NULL,NULL,NULL,'停车',NULL,5,NULL),('青CRIJ4R','357',NULL,NULL,NULL,NULL,NULL,NULL,'停车',NULL,9,9),('青CSDGXB','581',NULL,NULL,NULL,NULL,NULL,NULL,'停车',NULL,15,NULL),('青E4MT4Z','799',NULL,NULL,NULL,NULL,NULL,NULL,'停车',NULL,19,NULL),('青ERRFDZ','908',NULL,NULL,NULL,NULL,NULL,NULL,'停车',NULL,13,NULL),('青FBMF3F','421',NULL,NULL,NULL,NULL,NULL,NULL,'停车',NULL,3,NULL),('青H4M6PE','412',NULL,NULL,NULL,NULL,NULL,NULL,'停车',NULL,1,NULL),('青JW87BR','911',NULL,NULL,NULL,NULL,NULL,NULL,'停车',NULL,20,NULL),('青MM5RG3','403',NULL,NULL,NULL,NULL,NULL,NULL,'停车',NULL,16,NULL),('青NMPKFA','357',NULL,NULL,NULL,NULL,NULL,NULL,'停车',NULL,1,NULL),('青PY6AJZ','412',NULL,NULL,NULL,NULL,NULL,NULL,'停车',NULL,9,10),('青WAMWD4','799',NULL,NULL,NULL,NULL,NULL,NULL,'停车',NULL,12,NULL),('青XRSXC8','655',NULL,NULL,NULL,NULL,NULL,NULL,'停车',NULL,2,NULL),('青YNRJCX','908',NULL,NULL,NULL,NULL,NULL,NULL,'停车',NULL,14,NULL),('青Z75REX','403',NULL,NULL,NULL,NULL,NULL,NULL,'停车',NULL,3,NULL),('青ZKQMAF','403',NULL,NULL,NULL,NULL,NULL,NULL,'停车',NULL,16,NULL),('青ZKWY6N','911',NULL,NULL,NULL,NULL,NULL,NULL,'停车',NULL,19,NULL),('鲁A3IJCE','581',NULL,NULL,NULL,NULL,NULL,NULL,'停车',NULL,5,NULL),('鲁BFEZZ6','412',NULL,NULL,NULL,NULL,NULL,NULL,'停车',NULL,16,NULL),('鲁CMJJCR','357',NULL,NULL,NULL,NULL,NULL,NULL,'停车',NULL,16,NULL),('鲁EX8KZJ','911',NULL,NULL,NULL,NULL,NULL,NULL,'停车',NULL,4,NULL),('鲁F4YJZ4','655',NULL,NULL,NULL,NULL,NULL,NULL,'停车',NULL,11,NULL),('鲁N4WFRH','111',NULL,NULL,NULL,NULL,NULL,NULL,'停车',NULL,16,NULL),('鲁PJ6ABR','799',NULL,NULL,NULL,NULL,NULL,NULL,'停车',NULL,15,NULL),('鲁PWSH6Z','908',NULL,NULL,NULL,NULL,NULL,NULL,'停车',NULL,15,NULL),('鲁QDWYNM','357',NULL,NULL,NULL,NULL,NULL,NULL,'停车',NULL,15,NULL),('鲁REGTEK','799',NULL,NULL,NULL,NULL,NULL,NULL,'停车',NULL,3,NULL),('鲁SMN6TE','799',NULL,NULL,NULL,NULL,NULL,NULL,'停车',NULL,15,NULL),('鲁YXRSZ3','403',NULL,NULL,NULL,NULL,NULL,NULL,'停车',NULL,19,NULL),('鲁Z5Q5NR','111',NULL,NULL,NULL,NULL,NULL,NULL,'停车',NULL,7,NULL),('黑AD48CS','911',NULL,NULL,NULL,NULL,NULL,NULL,'停车',NULL,11,NULL),('黑CRSW44','799',NULL,NULL,NULL,NULL,NULL,NULL,'停车',NULL,1,NULL),('黑EMMHKX','412',NULL,NULL,NULL,NULL,NULL,NULL,'停车',NULL,17,NULL),('黑G452JC','412',NULL,NULL,NULL,NULL,NULL,NULL,'停车',NULL,16,NULL),('黑GGACKE','357',NULL,NULL,NULL,NULL,NULL,NULL,'停车',NULL,11,NULL),('黑GZ77DI','911',NULL,NULL,NULL,NULL,NULL,NULL,'停车',NULL,18,NULL),('黑H3ZT5Y','412',NULL,NULL,NULL,NULL,NULL,NULL,'停车',NULL,19,NULL),('黑KTHNZX','908',NULL,NULL,NULL,NULL,NULL,NULL,'停车',NULL,19,NULL),('黑QMCMXH','581',NULL,NULL,NULL,NULL,NULL,NULL,'停车',NULL,5,NULL),('黑RF5CKS','911',NULL,NULL,NULL,NULL,NULL,NULL,'停车',NULL,15,NULL),('黑TE6KRP','412',NULL,NULL,NULL,NULL,NULL,NULL,'停车',NULL,2,NULL),('黑TWNYKS','908',NULL,NULL,NULL,NULL,NULL,NULL,'停车',NULL,9,11),('黑XBT8GC','357',NULL,NULL,NULL,NULL,NULL,NULL,'停车',NULL,12,NULL),('黑XTFP4J','412',NULL,NULL,NULL,NULL,NULL,NULL,'停车',NULL,2,NULL);
/*!40101 SET SQL_MODE=@OLD_SQL_MODE */;
/*!40014 SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS */;
/*!40014 SET UNIQUE_CHECKS=@OLD_UNIQUE_CHECKS */;
/*!40111 SET SQL_NOTES=@OLD_SQL_NOTES */;