/*
Navicat MySQL Data Transfer

Source Server         : LI
Source Server Version : 80022
Source Host           : localhost:3306
Source Database       : keshe

Target Server Type    : MYSQL
Target Server Version : 80022
File Encoding         : 65001

Date: 2022-01-07 13:52:49
*/

SET FOREIGN_KEY_CHECKS=0;

-- ----------------------------
-- Table structure for area
-- ----------------------------
DROP TABLE IF EXISTS `area`;
CREATE TABLE `area` (
  `id` int NOT NULL AUTO_INCREMENT COMMENT '区域编号',
  `name` varchar(1) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '区域名称',
  `surplus` int NOT NULL COMMENT '剩余车位',
  `price` double(2,0) NOT NULL COMMENT '车位价格',
  PRIMARY KEY (`id`,`price`),
  KEY `area` (`name`) USING BTREE
) ENGINE=InnoDB AUTO_INCREMENT=5 DEFAULT CHARSET=utf8;

-- ----------------------------
-- Records of area
-- ----------------------------
INSERT INTO `area` VALUES ('1', 'A', '18', '8');
INSERT INTO `area` VALUES ('2', 'B', '100', '4');
INSERT INTO `area` VALUES ('3', 'C', '500', '2');

-- ----------------------------
-- Table structure for cars
-- ----------------------------
DROP TABLE IF EXISTS `cars`;
CREATE TABLE `cars` (
  `id` int NOT NULL AUTO_INCREMENT COMMENT '编号',
  `licensePlate` varchar(7) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '车牌号',
  `ownerId` int NOT NULL COMMENT '车主编号',
  PRIMARY KEY (`id`),
  KEY `ownerId` (`ownerId`),
  KEY `licensePlate` (`licensePlate`),
  CONSTRAINT `ownerId` FOREIGN KEY (`ownerId`) REFERENCES `owner` (`id`) ON DELETE CASCADE ON UPDATE CASCADE
) ENGINE=InnoDB AUTO_INCREMENT=7 DEFAULT CHARSET=utf8;

-- ----------------------------
-- Records of cars
-- ----------------------------
INSERT INTO `cars` VALUES ('5', '鲁vw7788', '4');

-- ----------------------------
-- Table structure for owner
-- ----------------------------
DROP TABLE IF EXISTS `owner`;
CREATE TABLE `owner` (
  `id` int NOT NULL AUTO_INCREMENT COMMENT '车主编号',
  `name` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '车主姓名',
  `tel` varchar(11) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL COMMENT '用户电话',
  `money` double(11,2) NOT NULL COMMENT '消费总额',
  `level` int DEFAULT NULL COMMENT '会员等级',
  PRIMARY KEY (`id`),
  KEY `vip1` (`level`),
  CONSTRAINT `vip1` FOREIGN KEY (`level`) REFERENCES `vip` (`id`) ON DELETE CASCADE ON UPDATE CASCADE
) ENGINE=InnoDB AUTO_INCREMENT=8 DEFAULT CHARSET=utf8 ROW_FORMAT=DYNAMIC;

-- ----------------------------
-- Records of owner
-- ----------------------------
INSERT INTO `owner` VALUES ('4', '于潇杰', '13245678977', '5173.20', '3');
INSERT INTO `owner` VALUES ('6', '李怿', '13245678977', '500.00', '3');

-- ----------------------------
-- Table structure for park
-- ----------------------------
DROP TABLE IF EXISTS `park`;
CREATE TABLE `park` (
  `id` int NOT NULL AUTO_INCREMENT COMMENT '停车位编号',
  `area` varchar(255) NOT NULL COMMENT '所在区域',
  `number` int NOT NULL COMMENT '区域号',
  `state` int NOT NULL COMMENT '停车状态（0为未停，1为已停）',
  PRIMARY KEY (`id`),
  KEY `area` (`area`),
  CONSTRAINT `area` FOREIGN KEY (`area`) REFERENCES `area` (`name`) ON DELETE CASCADE ON UPDATE CASCADE
) ENGINE=InnoDB AUTO_INCREMENT=1870 DEFAULT CHARSET=utf8;

-- ----------------------------
-- Records of park
-- ----------------------------
INSERT INTO `park` VALUES ('1249', 'A', '1', '1');
INSERT INTO `park` VALUES ('1250', 'A', '2', '0');
INSERT INTO `park` VALUES ('1251', 'A', '3', '1');
INSERT INTO `park` VALUES ('1252', 'A', '4', '0');
INSERT INTO `park` VALUES ('1253', 'A', '5', '0');
INSERT INTO `park` VALUES ('1254', 'A', '6', '0');
INSERT INTO `park` VALUES ('1255', 'A', '7', '0');
INSERT INTO `park` VALUES ('1256', 'A', '8', '0');
INSERT INTO `park` VALUES ('1257', 'A', '9', '0');
INSERT INTO `park` VALUES ('1258', 'A', '10', '0');
INSERT INTO `park` VALUES ('1259', 'A', '11', '0');
INSERT INTO `park` VALUES ('1260', 'A', '12', '0');
INSERT INTO `park` VALUES ('1261', 'A', '13', '0');
INSERT INTO `park` VALUES ('1262', 'A', '14', '0');
INSERT INTO `park` VALUES ('1263', 'A', '15', '0');
INSERT INTO `park` VALUES ('1264', 'A', '16', '0');
INSERT INTO `park` VALUES ('1265', 'A', '17', '0');
INSERT INTO `park` VALUES ('1266', 'A', '18', '0');
INSERT INTO `park` VALUES ('1267', 'A', '19', '0');
INSERT INTO `park` VALUES ('1268', 'A', '20', '0');
INSERT INTO `park` VALUES ('1269', 'B', '1', '0');
INSERT INTO `park` VALUES ('1270', 'B', '2', '0');
INSERT INTO `park` VALUES ('1271', 'B', '3', '0');
INSERT INTO `park` VALUES ('1272', 'B', '4', '0');
INSERT INTO `park` VALUES ('1273', 'B', '5', '0');
INSERT INTO `park` VALUES ('1274', 'B', '6', '0');
INSERT INTO `park` VALUES ('1275', 'B', '7', '0');
INSERT INTO `park` VALUES ('1276', 'B', '8', '0');
INSERT INTO `park` VALUES ('1277', 'B', '9', '0');
INSERT INTO `park` VALUES ('1278', 'B', '10', '0');
INSERT INTO `park` VALUES ('1279', 'B', '11', '0');
INSERT INTO `park` VALUES ('1280', 'B', '12', '0');
INSERT INTO `park` VALUES ('1281', 'B', '13', '0');
INSERT INTO `park` VALUES ('1282', 'B', '14', '0');
INSERT INTO `park` VALUES ('1283', 'B', '15', '0');
INSERT INTO `park` VALUES ('1284', 'B', '16', '0');
INSERT INTO `park` VALUES ('1285', 'B', '17', '0');
INSERT INTO `park` VALUES ('1286', 'B', '18', '0');
INSERT INTO `park` VALUES ('1287', 'B', '19', '0');
INSERT INTO `park` VALUES ('1288', 'B', '20', '0');
INSERT INTO `park` VALUES ('1289', 'B', '21', '0');
INSERT INTO `park` VALUES ('1290', 'B', '22', '0');
INSERT INTO `park` VALUES ('1291', 'B', '23', '0');
INSERT INTO `park` VALUES ('1292', 'B', '24', '0');
INSERT INTO `park` VALUES ('1293', 'B', '25', '0');
INSERT INTO `park` VALUES ('1294', 'B', '26', '0');
INSERT INTO `park` VALUES ('1295', 'B', '27', '0');
INSERT INTO `park` VALUES ('1296', 'B', '28', '0');
INSERT INTO `park` VALUES ('1297', 'B', '29', '0');
INSERT INTO `park` VALUES ('1298', 'B', '30', '0');
INSERT INTO `park` VALUES ('1299', 'B', '31', '0');
INSERT INTO `park` VALUES ('1300', 'B', '32', '0');
INSERT INTO `park` VALUES ('1301', 'B', '33', '0');
INSERT INTO `park` VALUES ('1302', 'B', '34', '0');
INSERT INTO `park` VALUES ('1303', 'B', '35', '0');
INSERT INTO `park` VALUES ('1304', 'B', '36', '0');
INSERT INTO `park` VALUES ('1305', 'B', '37', '0');
INSERT INTO `park` VALUES ('1306', 'B', '38', '0');
INSERT INTO `park` VALUES ('1307', 'B', '39', '0');
INSERT INTO `park` VALUES ('1308', 'B', '40', '0');
INSERT INTO `park` VALUES ('1309', 'B', '41', '0');
INSERT INTO `park` VALUES ('1310', 'B', '42', '0');
INSERT INTO `park` VALUES ('1311', 'B', '43', '0');
INSERT INTO `park` VALUES ('1312', 'B', '44', '0');
INSERT INTO `park` VALUES ('1313', 'B', '45', '0');
INSERT INTO `park` VALUES ('1314', 'B', '46', '0');
INSERT INTO `park` VALUES ('1315', 'B', '47', '0');
INSERT INTO `park` VALUES ('1316', 'B', '48', '0');
INSERT INTO `park` VALUES ('1317', 'B', '49', '0');
INSERT INTO `park` VALUES ('1318', 'B', '50', '0');
INSERT INTO `park` VALUES ('1319', 'B', '51', '0');
INSERT INTO `park` VALUES ('1320', 'B', '52', '0');
INSERT INTO `park` VALUES ('1321', 'B', '53', '0');
INSERT INTO `park` VALUES ('1322', 'B', '54', '0');
INSERT INTO `park` VALUES ('1323', 'B', '55', '0');
INSERT INTO `park` VALUES ('1324', 'B', '56', '0');
INSERT INTO `park` VALUES ('1325', 'B', '57', '0');
INSERT INTO `park` VALUES ('1326', 'B', '58', '0');
INSERT INTO `park` VALUES ('1327', 'B', '59', '0');
INSERT INTO `park` VALUES ('1328', 'B', '60', '0');
INSERT INTO `park` VALUES ('1329', 'B', '61', '0');
INSERT INTO `park` VALUES ('1330', 'B', '62', '0');
INSERT INTO `park` VALUES ('1331', 'B', '63', '0');
INSERT INTO `park` VALUES ('1332', 'B', '64', '0');
INSERT INTO `park` VALUES ('1333', 'B', '65', '0');
INSERT INTO `park` VALUES ('1334', 'B', '66', '0');
INSERT INTO `park` VALUES ('1335', 'B', '67', '0');
INSERT INTO `park` VALUES ('1336', 'B', '68', '0');
INSERT INTO `park` VALUES ('1337', 'B', '69', '0');
INSERT INTO `park` VALUES ('1338', 'B', '70', '0');
INSERT INTO `park` VALUES ('1339', 'B', '71', '0');
INSERT INTO `park` VALUES ('1340', 'B', '72', '0');
INSERT INTO `park` VALUES ('1341', 'B', '73', '0');
INSERT INTO `park` VALUES ('1342', 'B', '74', '0');
INSERT INTO `park` VALUES ('1343', 'B', '75', '0');
INSERT INTO `park` VALUES ('1344', 'B', '76', '0');
INSERT INTO `park` VALUES ('1345', 'B', '77', '0');
INSERT INTO `park` VALUES ('1346', 'B', '78', '0');
INSERT INTO `park` VALUES ('1347', 'B', '79', '0');
INSERT INTO `park` VALUES ('1348', 'B', '80', '0');
INSERT INTO `park` VALUES ('1349', 'B', '81', '0');
INSERT INTO `park` VALUES ('1350', 'B', '82', '0');
INSERT INTO `park` VALUES ('1351', 'B', '83', '0');
INSERT INTO `park` VALUES ('1352', 'B', '84', '0');
INSERT INTO `park` VALUES ('1353', 'B', '85', '0');
INSERT INTO `park` VALUES ('1354', 'B', '86', '0');
INSERT INTO `park` VALUES ('1355', 'B', '87', '0');
INSERT INTO `park` VALUES ('1356', 'B', '88', '0');
INSERT INTO `park` VALUES ('1357', 'B', '89', '0');
INSERT INTO `park` VALUES ('1358', 'B', '90', '0');
INSERT INTO `park` VALUES ('1359', 'B', '91', '0');
INSERT INTO `park` VALUES ('1360', 'B', '92', '0');
INSERT INTO `park` VALUES ('1361', 'B', '93', '0');
INSERT INTO `park` VALUES ('1362', 'B', '94', '0');
INSERT INTO `park` VALUES ('1363', 'B', '95', '0');
INSERT INTO `park` VALUES ('1364', 'B', '96', '0');
INSERT INTO `park` VALUES ('1365', 'B', '97', '0');
INSERT INTO `park` VALUES ('1366', 'B', '98', '0');
INSERT INTO `park` VALUES ('1367', 'B', '99', '0');
INSERT INTO `park` VALUES ('1368', 'B', '100', '0');
INSERT INTO `park` VALUES ('1369', 'C', '1', '0');
INSERT INTO `park` VALUES ('1370', 'C', '2', '0');
INSERT INTO `park` VALUES ('1371', 'C', '3', '0');
INSERT INTO `park` VALUES ('1372', 'C', '4', '0');
INSERT INTO `park` VALUES ('1373', 'C', '5', '0');
INSERT INTO `park` VALUES ('1374', 'C', '6', '0');
INSERT INTO `park` VALUES ('1375', 'C', '7', '0');
INSERT INTO `park` VALUES ('1376', 'C', '8', '0');
INSERT INTO `park` VALUES ('1377', 'C', '9', '0');
INSERT INTO `park` VALUES ('1378', 'C', '10', '0');
INSERT INTO `park` VALUES ('1379', 'C', '11', '0');
INSERT INTO `park` VALUES ('1380', 'C', '12', '0');
INSERT INTO `park` VALUES ('1381', 'C', '13', '0');
INSERT INTO `park` VALUES ('1382', 'C', '14', '0');
INSERT INTO `park` VALUES ('1383', 'C', '15', '0');
INSERT INTO `park` VALUES ('1384', 'C', '16', '0');
INSERT INTO `park` VALUES ('1385', 'C', '17', '0');
INSERT INTO `park` VALUES ('1386', 'C', '18', '0');
INSERT INTO `park` VALUES ('1387', 'C', '19', '0');
INSERT INTO `park` VALUES ('1388', 'C', '20', '0');
INSERT INTO `park` VALUES ('1389', 'C', '21', '0');
INSERT INTO `park` VALUES ('1390', 'C', '22', '0');
INSERT INTO `park` VALUES ('1391', 'C', '23', '0');
INSERT INTO `park` VALUES ('1392', 'C', '24', '0');
INSERT INTO `park` VALUES ('1393', 'C', '25', '0');
INSERT INTO `park` VALUES ('1394', 'C', '26', '0');
INSERT INTO `park` VALUES ('1395', 'C', '27', '0');
INSERT INTO `park` VALUES ('1396', 'C', '28', '0');
INSERT INTO `park` VALUES ('1397', 'C', '29', '0');
INSERT INTO `park` VALUES ('1398', 'C', '30', '0');
INSERT INTO `park` VALUES ('1399', 'C', '31', '0');
INSERT INTO `park` VALUES ('1400', 'C', '32', '0');
INSERT INTO `park` VALUES ('1401', 'C', '33', '0');
INSERT INTO `park` VALUES ('1402', 'C', '34', '0');
INSERT INTO `park` VALUES ('1403', 'C', '35', '0');
INSERT INTO `park` VALUES ('1404', 'C', '36', '0');
INSERT INTO `park` VALUES ('1405', 'C', '37', '0');
INSERT INTO `park` VALUES ('1406', 'C', '38', '0');
INSERT INTO `park` VALUES ('1407', 'C', '39', '0');
INSERT INTO `park` VALUES ('1408', 'C', '40', '0');
INSERT INTO `park` VALUES ('1409', 'C', '41', '0');
INSERT INTO `park` VALUES ('1410', 'C', '42', '0');
INSERT INTO `park` VALUES ('1411', 'C', '43', '0');
INSERT INTO `park` VALUES ('1412', 'C', '44', '0');
INSERT INTO `park` VALUES ('1413', 'C', '45', '0');
INSERT INTO `park` VALUES ('1414', 'C', '46', '0');
INSERT INTO `park` VALUES ('1415', 'C', '47', '0');
INSERT INTO `park` VALUES ('1416', 'C', '48', '0');
INSERT INTO `park` VALUES ('1417', 'C', '49', '0');
INSERT INTO `park` VALUES ('1418', 'C', '50', '0');
INSERT INTO `park` VALUES ('1419', 'C', '51', '0');
INSERT INTO `park` VALUES ('1420', 'C', '52', '0');
INSERT INTO `park` VALUES ('1421', 'C', '53', '0');
INSERT INTO `park` VALUES ('1422', 'C', '54', '0');
INSERT INTO `park` VALUES ('1423', 'C', '55', '0');
INSERT INTO `park` VALUES ('1424', 'C', '56', '0');
INSERT INTO `park` VALUES ('1425', 'C', '57', '0');
INSERT INTO `park` VALUES ('1426', 'C', '58', '0');
INSERT INTO `park` VALUES ('1427', 'C', '59', '0');
INSERT INTO `park` VALUES ('1428', 'C', '60', '0');
INSERT INTO `park` VALUES ('1429', 'C', '61', '0');
INSERT INTO `park` VALUES ('1430', 'C', '62', '0');
INSERT INTO `park` VALUES ('1431', 'C', '63', '0');
INSERT INTO `park` VALUES ('1432', 'C', '64', '0');
INSERT INTO `park` VALUES ('1433', 'C', '65', '0');
INSERT INTO `park` VALUES ('1434', 'C', '66', '0');
INSERT INTO `park` VALUES ('1435', 'C', '67', '0');
INSERT INTO `park` VALUES ('1436', 'C', '68', '0');
INSERT INTO `park` VALUES ('1437', 'C', '69', '0');
INSERT INTO `park` VALUES ('1438', 'C', '70', '0');
INSERT INTO `park` VALUES ('1439', 'C', '71', '0');
INSERT INTO `park` VALUES ('1440', 'C', '72', '0');
INSERT INTO `park` VALUES ('1441', 'C', '73', '0');
INSERT INTO `park` VALUES ('1442', 'C', '74', '0');
INSERT INTO `park` VALUES ('1443', 'C', '75', '0');
INSERT INTO `park` VALUES ('1444', 'C', '76', '0');
INSERT INTO `park` VALUES ('1445', 'C', '77', '0');
INSERT INTO `park` VALUES ('1446', 'C', '78', '0');
INSERT INTO `park` VALUES ('1447', 'C', '79', '0');
INSERT INTO `park` VALUES ('1448', 'C', '80', '0');
INSERT INTO `park` VALUES ('1449', 'C', '81', '0');
INSERT INTO `park` VALUES ('1450', 'C', '82', '0');
INSERT INTO `park` VALUES ('1451', 'C', '83', '0');
INSERT INTO `park` VALUES ('1452', 'C', '84', '0');
INSERT INTO `park` VALUES ('1453', 'C', '85', '0');
INSERT INTO `park` VALUES ('1454', 'C', '86', '0');
INSERT INTO `park` VALUES ('1455', 'C', '87', '0');
INSERT INTO `park` VALUES ('1456', 'C', '88', '0');
INSERT INTO `park` VALUES ('1457', 'C', '89', '0');
INSERT INTO `park` VALUES ('1458', 'C', '90', '0');
INSERT INTO `park` VALUES ('1459', 'C', '91', '0');
INSERT INTO `park` VALUES ('1460', 'C', '92', '0');
INSERT INTO `park` VALUES ('1461', 'C', '93', '0');
INSERT INTO `park` VALUES ('1462', 'C', '94', '0');
INSERT INTO `park` VALUES ('1463', 'C', '95', '0');
INSERT INTO `park` VALUES ('1464', 'C', '96', '0');
INSERT INTO `park` VALUES ('1465', 'C', '97', '0');
INSERT INTO `park` VALUES ('1466', 'C', '98', '0');
INSERT INTO `park` VALUES ('1467', 'C', '99', '0');
INSERT INTO `park` VALUES ('1468', 'C', '100', '0');
INSERT INTO `park` VALUES ('1469', 'C', '101', '0');
INSERT INTO `park` VALUES ('1470', 'C', '102', '0');
INSERT INTO `park` VALUES ('1471', 'C', '103', '0');
INSERT INTO `park` VALUES ('1472', 'C', '104', '0');
INSERT INTO `park` VALUES ('1473', 'C', '105', '0');
INSERT INTO `park` VALUES ('1474', 'C', '106', '0');
INSERT INTO `park` VALUES ('1475', 'C', '107', '0');
INSERT INTO `park` VALUES ('1476', 'C', '108', '0');
INSERT INTO `park` VALUES ('1477', 'C', '109', '0');
INSERT INTO `park` VALUES ('1478', 'C', '110', '0');
INSERT INTO `park` VALUES ('1479', 'C', '111', '0');
INSERT INTO `park` VALUES ('1480', 'C', '112', '0');
INSERT INTO `park` VALUES ('1481', 'C', '113', '0');
INSERT INTO `park` VALUES ('1482', 'C', '114', '0');
INSERT INTO `park` VALUES ('1483', 'C', '115', '0');
INSERT INTO `park` VALUES ('1484', 'C', '116', '0');
INSERT INTO `park` VALUES ('1485', 'C', '117', '0');
INSERT INTO `park` VALUES ('1486', 'C', '118', '0');
INSERT INTO `park` VALUES ('1487', 'C', '119', '0');
INSERT INTO `park` VALUES ('1488', 'C', '120', '0');
INSERT INTO `park` VALUES ('1489', 'C', '121', '0');
INSERT INTO `park` VALUES ('1490', 'C', '122', '0');
INSERT INTO `park` VALUES ('1491', 'C', '123', '0');
INSERT INTO `park` VALUES ('1492', 'C', '124', '0');
INSERT INTO `park` VALUES ('1493', 'C', '125', '0');
INSERT INTO `park` VALUES ('1494', 'C', '126', '0');
INSERT INTO `park` VALUES ('1495', 'C', '127', '0');
INSERT INTO `park` VALUES ('1496', 'C', '128', '0');
INSERT INTO `park` VALUES ('1497', 'C', '129', '0');
INSERT INTO `park` VALUES ('1498', 'C', '130', '0');
INSERT INTO `park` VALUES ('1499', 'C', '131', '0');
INSERT INTO `park` VALUES ('1500', 'C', '132', '0');
INSERT INTO `park` VALUES ('1501', 'C', '133', '0');
INSERT INTO `park` VALUES ('1502', 'C', '134', '0');
INSERT INTO `park` VALUES ('1503', 'C', '135', '0');
INSERT INTO `park` VALUES ('1504', 'C', '136', '0');
INSERT INTO `park` VALUES ('1505', 'C', '137', '0');
INSERT INTO `park` VALUES ('1506', 'C', '138', '0');
INSERT INTO `park` VALUES ('1507', 'C', '139', '0');
INSERT INTO `park` VALUES ('1508', 'C', '140', '0');
INSERT INTO `park` VALUES ('1509', 'C', '141', '0');
INSERT INTO `park` VALUES ('1510', 'C', '142', '0');
INSERT INTO `park` VALUES ('1511', 'C', '143', '0');
INSERT INTO `park` VALUES ('1512', 'C', '144', '0');
INSERT INTO `park` VALUES ('1513', 'C', '145', '0');
INSERT INTO `park` VALUES ('1514', 'C', '146', '0');
INSERT INTO `park` VALUES ('1515', 'C', '147', '0');
INSERT INTO `park` VALUES ('1516', 'C', '148', '0');
INSERT INTO `park` VALUES ('1517', 'C', '149', '0');
INSERT INTO `park` VALUES ('1518', 'C', '150', '0');
INSERT INTO `park` VALUES ('1519', 'C', '151', '0');
INSERT INTO `park` VALUES ('1520', 'C', '152', '0');
INSERT INTO `park` VALUES ('1521', 'C', '153', '0');
INSERT INTO `park` VALUES ('1522', 'C', '154', '0');
INSERT INTO `park` VALUES ('1523', 'C', '155', '0');
INSERT INTO `park` VALUES ('1524', 'C', '156', '0');
INSERT INTO `park` VALUES ('1525', 'C', '157', '0');
INSERT INTO `park` VALUES ('1526', 'C', '158', '0');
INSERT INTO `park` VALUES ('1527', 'C', '159', '0');
INSERT INTO `park` VALUES ('1528', 'C', '160', '0');
INSERT INTO `park` VALUES ('1529', 'C', '161', '0');
INSERT INTO `park` VALUES ('1530', 'C', '162', '0');
INSERT INTO `park` VALUES ('1531', 'C', '163', '0');
INSERT INTO `park` VALUES ('1532', 'C', '164', '0');
INSERT INTO `park` VALUES ('1533', 'C', '165', '0');
INSERT INTO `park` VALUES ('1534', 'C', '166', '0');
INSERT INTO `park` VALUES ('1535', 'C', '167', '0');
INSERT INTO `park` VALUES ('1536', 'C', '168', '0');
INSERT INTO `park` VALUES ('1537', 'C', '169', '0');
INSERT INTO `park` VALUES ('1538', 'C', '170', '0');
INSERT INTO `park` VALUES ('1539', 'C', '171', '0');
INSERT INTO `park` VALUES ('1540', 'C', '172', '0');
INSERT INTO `park` VALUES ('1541', 'C', '173', '0');
INSERT INTO `park` VALUES ('1542', 'C', '174', '0');
INSERT INTO `park` VALUES ('1543', 'C', '175', '0');
INSERT INTO `park` VALUES ('1544', 'C', '176', '0');
INSERT INTO `park` VALUES ('1545', 'C', '177', '0');
INSERT INTO `park` VALUES ('1546', 'C', '178', '0');
INSERT INTO `park` VALUES ('1547', 'C', '179', '0');
INSERT INTO `park` VALUES ('1548', 'C', '180', '0');
INSERT INTO `park` VALUES ('1549', 'C', '181', '0');
INSERT INTO `park` VALUES ('1550', 'C', '182', '0');
INSERT INTO `park` VALUES ('1551', 'C', '183', '0');
INSERT INTO `park` VALUES ('1552', 'C', '184', '0');
INSERT INTO `park` VALUES ('1553', 'C', '185', '0');
INSERT INTO `park` VALUES ('1554', 'C', '186', '0');
INSERT INTO `park` VALUES ('1555', 'C', '187', '0');
INSERT INTO `park` VALUES ('1556', 'C', '188', '0');
INSERT INTO `park` VALUES ('1557', 'C', '189', '0');
INSERT INTO `park` VALUES ('1558', 'C', '190', '0');
INSERT INTO `park` VALUES ('1559', 'C', '191', '0');
INSERT INTO `park` VALUES ('1560', 'C', '192', '0');
INSERT INTO `park` VALUES ('1561', 'C', '193', '0');
INSERT INTO `park` VALUES ('1562', 'C', '194', '0');
INSERT INTO `park` VALUES ('1563', 'C', '195', '0');
INSERT INTO `park` VALUES ('1564', 'C', '196', '0');
INSERT INTO `park` VALUES ('1565', 'C', '197', '0');
INSERT INTO `park` VALUES ('1566', 'C', '198', '0');
INSERT INTO `park` VALUES ('1567', 'C', '199', '0');
INSERT INTO `park` VALUES ('1568', 'C', '200', '0');
INSERT INTO `park` VALUES ('1569', 'C', '201', '0');
INSERT INTO `park` VALUES ('1570', 'C', '202', '0');
INSERT INTO `park` VALUES ('1571', 'C', '203', '0');
INSERT INTO `park` VALUES ('1572', 'C', '204', '0');
INSERT INTO `park` VALUES ('1573', 'C', '205', '0');
INSERT INTO `park` VALUES ('1574', 'C', '206', '0');
INSERT INTO `park` VALUES ('1575', 'C', '207', '0');
INSERT INTO `park` VALUES ('1576', 'C', '208', '0');
INSERT INTO `park` VALUES ('1577', 'C', '209', '0');
INSERT INTO `park` VALUES ('1578', 'C', '210', '0');
INSERT INTO `park` VALUES ('1579', 'C', '211', '0');
INSERT INTO `park` VALUES ('1580', 'C', '212', '0');
INSERT INTO `park` VALUES ('1581', 'C', '213', '0');
INSERT INTO `park` VALUES ('1582', 'C', '214', '0');
INSERT INTO `park` VALUES ('1583', 'C', '215', '0');
INSERT INTO `park` VALUES ('1584', 'C', '216', '0');
INSERT INTO `park` VALUES ('1585', 'C', '217', '0');
INSERT INTO `park` VALUES ('1586', 'C', '218', '0');
INSERT INTO `park` VALUES ('1587', 'C', '219', '0');
INSERT INTO `park` VALUES ('1588', 'C', '220', '0');
INSERT INTO `park` VALUES ('1589', 'C', '221', '0');
INSERT INTO `park` VALUES ('1590', 'C', '222', '0');
INSERT INTO `park` VALUES ('1591', 'C', '223', '0');
INSERT INTO `park` VALUES ('1592', 'C', '224', '0');
INSERT INTO `park` VALUES ('1593', 'C', '225', '0');
INSERT INTO `park` VALUES ('1594', 'C', '226', '0');
INSERT INTO `park` VALUES ('1595', 'C', '227', '0');
INSERT INTO `park` VALUES ('1596', 'C', '228', '0');
INSERT INTO `park` VALUES ('1597', 'C', '229', '0');
INSERT INTO `park` VALUES ('1598', 'C', '230', '0');
INSERT INTO `park` VALUES ('1599', 'C', '231', '0');
INSERT INTO `park` VALUES ('1600', 'C', '232', '0');
INSERT INTO `park` VALUES ('1601', 'C', '233', '0');
INSERT INTO `park` VALUES ('1602', 'C', '234', '0');
INSERT INTO `park` VALUES ('1603', 'C', '235', '0');
INSERT INTO `park` VALUES ('1604', 'C', '236', '0');
INSERT INTO `park` VALUES ('1605', 'C', '237', '0');
INSERT INTO `park` VALUES ('1606', 'C', '238', '0');
INSERT INTO `park` VALUES ('1607', 'C', '239', '0');
INSERT INTO `park` VALUES ('1608', 'C', '240', '0');
INSERT INTO `park` VALUES ('1609', 'C', '241', '0');
INSERT INTO `park` VALUES ('1610', 'C', '242', '0');
INSERT INTO `park` VALUES ('1611', 'C', '243', '0');
INSERT INTO `park` VALUES ('1612', 'C', '244', '0');
INSERT INTO `park` VALUES ('1613', 'C', '245', '0');
INSERT INTO `park` VALUES ('1614', 'C', '246', '0');
INSERT INTO `park` VALUES ('1615', 'C', '247', '0');
INSERT INTO `park` VALUES ('1616', 'C', '248', '0');
INSERT INTO `park` VALUES ('1617', 'C', '249', '0');
INSERT INTO `park` VALUES ('1618', 'C', '250', '0');
INSERT INTO `park` VALUES ('1619', 'C', '251', '0');
INSERT INTO `park` VALUES ('1620', 'C', '252', '0');
INSERT INTO `park` VALUES ('1621', 'C', '253', '0');
INSERT INTO `park` VALUES ('1622', 'C', '254', '0');
INSERT INTO `park` VALUES ('1623', 'C', '255', '0');
INSERT INTO `park` VALUES ('1624', 'C', '256', '0');
INSERT INTO `park` VALUES ('1625', 'C', '257', '0');
INSERT INTO `park` VALUES ('1626', 'C', '258', '0');
INSERT INTO `park` VALUES ('1627', 'C', '259', '0');
INSERT INTO `park` VALUES ('1628', 'C', '260', '0');
INSERT INTO `park` VALUES ('1629', 'C', '261', '0');
INSERT INTO `park` VALUES ('1630', 'C', '262', '0');
INSERT INTO `park` VALUES ('1631', 'C', '263', '0');
INSERT INTO `park` VALUES ('1632', 'C', '264', '0');
INSERT INTO `park` VALUES ('1633', 'C', '265', '0');
INSERT INTO `park` VALUES ('1634', 'C', '266', '0');
INSERT INTO `park` VALUES ('1635', 'C', '267', '0');
INSERT INTO `park` VALUES ('1636', 'C', '268', '0');
INSERT INTO `park` VALUES ('1637', 'C', '269', '0');
INSERT INTO `park` VALUES ('1638', 'C', '270', '0');
INSERT INTO `park` VALUES ('1639', 'C', '271', '0');
INSERT INTO `park` VALUES ('1640', 'C', '272', '0');
INSERT INTO `park` VALUES ('1641', 'C', '273', '0');
INSERT INTO `park` VALUES ('1642', 'C', '274', '0');
INSERT INTO `park` VALUES ('1643', 'C', '275', '0');
INSERT INTO `park` VALUES ('1644', 'C', '276', '0');
INSERT INTO `park` VALUES ('1645', 'C', '277', '0');
INSERT INTO `park` VALUES ('1646', 'C', '278', '0');
INSERT INTO `park` VALUES ('1647', 'C', '279', '0');
INSERT INTO `park` VALUES ('1648', 'C', '280', '0');
INSERT INTO `park` VALUES ('1649', 'C', '281', '0');
INSERT INTO `park` VALUES ('1650', 'C', '282', '0');
INSERT INTO `park` VALUES ('1651', 'C', '283', '0');
INSERT INTO `park` VALUES ('1652', 'C', '284', '0');
INSERT INTO `park` VALUES ('1653', 'C', '285', '0');
INSERT INTO `park` VALUES ('1654', 'C', '286', '0');
INSERT INTO `park` VALUES ('1655', 'C', '287', '0');
INSERT INTO `park` VALUES ('1656', 'C', '288', '0');
INSERT INTO `park` VALUES ('1657', 'C', '289', '0');
INSERT INTO `park` VALUES ('1658', 'C', '290', '0');
INSERT INTO `park` VALUES ('1659', 'C', '291', '0');
INSERT INTO `park` VALUES ('1660', 'C', '292', '0');
INSERT INTO `park` VALUES ('1661', 'C', '293', '0');
INSERT INTO `park` VALUES ('1662', 'C', '294', '0');
INSERT INTO `park` VALUES ('1663', 'C', '295', '0');
INSERT INTO `park` VALUES ('1664', 'C', '296', '0');
INSERT INTO `park` VALUES ('1665', 'C', '297', '0');
INSERT INTO `park` VALUES ('1666', 'C', '298', '0');
INSERT INTO `park` VALUES ('1667', 'C', '299', '0');
INSERT INTO `park` VALUES ('1668', 'C', '300', '0');
INSERT INTO `park` VALUES ('1669', 'C', '301', '0');
INSERT INTO `park` VALUES ('1670', 'C', '302', '0');
INSERT INTO `park` VALUES ('1671', 'C', '303', '0');
INSERT INTO `park` VALUES ('1672', 'C', '304', '0');
INSERT INTO `park` VALUES ('1673', 'C', '305', '0');
INSERT INTO `park` VALUES ('1674', 'C', '306', '0');
INSERT INTO `park` VALUES ('1675', 'C', '307', '0');
INSERT INTO `park` VALUES ('1676', 'C', '308', '0');
INSERT INTO `park` VALUES ('1677', 'C', '309', '0');
INSERT INTO `park` VALUES ('1678', 'C', '310', '0');
INSERT INTO `park` VALUES ('1679', 'C', '311', '0');
INSERT INTO `park` VALUES ('1680', 'C', '312', '0');
INSERT INTO `park` VALUES ('1681', 'C', '313', '0');
INSERT INTO `park` VALUES ('1682', 'C', '314', '0');
INSERT INTO `park` VALUES ('1683', 'C', '315', '0');
INSERT INTO `park` VALUES ('1684', 'C', '316', '0');
INSERT INTO `park` VALUES ('1685', 'C', '317', '0');
INSERT INTO `park` VALUES ('1686', 'C', '318', '0');
INSERT INTO `park` VALUES ('1687', 'C', '319', '0');
INSERT INTO `park` VALUES ('1688', 'C', '320', '0');
INSERT INTO `park` VALUES ('1689', 'C', '321', '0');
INSERT INTO `park` VALUES ('1690', 'C', '322', '0');
INSERT INTO `park` VALUES ('1691', 'C', '323', '0');
INSERT INTO `park` VALUES ('1692', 'C', '324', '0');
INSERT INTO `park` VALUES ('1693', 'C', '325', '0');
INSERT INTO `park` VALUES ('1694', 'C', '326', '0');
INSERT INTO `park` VALUES ('1695', 'C', '327', '0');
INSERT INTO `park` VALUES ('1696', 'C', '328', '0');
INSERT INTO `park` VALUES ('1697', 'C', '329', '0');
INSERT INTO `park` VALUES ('1698', 'C', '330', '0');
INSERT INTO `park` VALUES ('1699', 'C', '331', '0');
INSERT INTO `park` VALUES ('1700', 'C', '332', '0');
INSERT INTO `park` VALUES ('1701', 'C', '333', '0');
INSERT INTO `park` VALUES ('1702', 'C', '334', '0');
INSERT INTO `park` VALUES ('1703', 'C', '335', '0');
INSERT INTO `park` VALUES ('1704', 'C', '336', '0');
INSERT INTO `park` VALUES ('1705', 'C', '337', '0');
INSERT INTO `park` VALUES ('1706', 'C', '338', '0');
INSERT INTO `park` VALUES ('1707', 'C', '339', '0');
INSERT INTO `park` VALUES ('1708', 'C', '340', '0');
INSERT INTO `park` VALUES ('1709', 'C', '341', '0');
INSERT INTO `park` VALUES ('1710', 'C', '342', '0');
INSERT INTO `park` VALUES ('1711', 'C', '343', '0');
INSERT INTO `park` VALUES ('1712', 'C', '344', '0');
INSERT INTO `park` VALUES ('1713', 'C', '345', '0');
INSERT INTO `park` VALUES ('1714', 'C', '346', '0');
INSERT INTO `park` VALUES ('1715', 'C', '347', '0');
INSERT INTO `park` VALUES ('1716', 'C', '348', '0');
INSERT INTO `park` VALUES ('1717', 'C', '349', '0');
INSERT INTO `park` VALUES ('1718', 'C', '350', '0');
INSERT INTO `park` VALUES ('1719', 'C', '351', '0');
INSERT INTO `park` VALUES ('1720', 'C', '352', '0');
INSERT INTO `park` VALUES ('1721', 'C', '353', '0');
INSERT INTO `park` VALUES ('1722', 'C', '354', '0');
INSERT INTO `park` VALUES ('1723', 'C', '355', '0');
INSERT INTO `park` VALUES ('1724', 'C', '356', '0');
INSERT INTO `park` VALUES ('1725', 'C', '357', '0');
INSERT INTO `park` VALUES ('1726', 'C', '358', '0');
INSERT INTO `park` VALUES ('1727', 'C', '359', '0');
INSERT INTO `park` VALUES ('1728', 'C', '360', '0');
INSERT INTO `park` VALUES ('1729', 'C', '361', '0');
INSERT INTO `park` VALUES ('1730', 'C', '362', '0');
INSERT INTO `park` VALUES ('1731', 'C', '363', '0');
INSERT INTO `park` VALUES ('1732', 'C', '364', '0');
INSERT INTO `park` VALUES ('1733', 'C', '365', '0');
INSERT INTO `park` VALUES ('1734', 'C', '366', '0');
INSERT INTO `park` VALUES ('1735', 'C', '367', '0');
INSERT INTO `park` VALUES ('1736', 'C', '368', '0');
INSERT INTO `park` VALUES ('1737', 'C', '369', '0');
INSERT INTO `park` VALUES ('1738', 'C', '370', '0');
INSERT INTO `park` VALUES ('1739', 'C', '371', '0');
INSERT INTO `park` VALUES ('1740', 'C', '372', '0');
INSERT INTO `park` VALUES ('1741', 'C', '373', '0');
INSERT INTO `park` VALUES ('1742', 'C', '374', '0');
INSERT INTO `park` VALUES ('1743', 'C', '375', '0');
INSERT INTO `park` VALUES ('1744', 'C', '376', '0');
INSERT INTO `park` VALUES ('1745', 'C', '377', '0');
INSERT INTO `park` VALUES ('1746', 'C', '378', '0');
INSERT INTO `park` VALUES ('1747', 'C', '379', '0');
INSERT INTO `park` VALUES ('1748', 'C', '380', '0');
INSERT INTO `park` VALUES ('1749', 'C', '381', '0');
INSERT INTO `park` VALUES ('1750', 'C', '382', '0');
INSERT INTO `park` VALUES ('1751', 'C', '383', '0');
INSERT INTO `park` VALUES ('1752', 'C', '384', '0');
INSERT INTO `park` VALUES ('1753', 'C', '385', '0');
INSERT INTO `park` VALUES ('1754', 'C', '386', '0');
INSERT INTO `park` VALUES ('1755', 'C', '387', '0');
INSERT INTO `park` VALUES ('1756', 'C', '388', '0');
INSERT INTO `park` VALUES ('1757', 'C', '389', '0');
INSERT INTO `park` VALUES ('1758', 'C', '390', '0');
INSERT INTO `park` VALUES ('1759', 'C', '391', '0');
INSERT INTO `park` VALUES ('1760', 'C', '392', '0');
INSERT INTO `park` VALUES ('1761', 'C', '393', '0');
INSERT INTO `park` VALUES ('1762', 'C', '394', '0');
INSERT INTO `park` VALUES ('1763', 'C', '395', '0');
INSERT INTO `park` VALUES ('1764', 'C', '396', '0');
INSERT INTO `park` VALUES ('1765', 'C', '397', '0');
INSERT INTO `park` VALUES ('1766', 'C', '398', '0');
INSERT INTO `park` VALUES ('1767', 'C', '399', '0');
INSERT INTO `park` VALUES ('1768', 'C', '400', '0');
INSERT INTO `park` VALUES ('1769', 'C', '401', '0');
INSERT INTO `park` VALUES ('1770', 'C', '402', '0');
INSERT INTO `park` VALUES ('1771', 'C', '403', '0');
INSERT INTO `park` VALUES ('1772', 'C', '404', '0');
INSERT INTO `park` VALUES ('1773', 'C', '405', '0');
INSERT INTO `park` VALUES ('1774', 'C', '406', '0');
INSERT INTO `park` VALUES ('1775', 'C', '407', '0');
INSERT INTO `park` VALUES ('1776', 'C', '408', '0');
INSERT INTO `park` VALUES ('1777', 'C', '409', '0');
INSERT INTO `park` VALUES ('1778', 'C', '410', '0');
INSERT INTO `park` VALUES ('1779', 'C', '411', '0');
INSERT INTO `park` VALUES ('1780', 'C', '412', '0');
INSERT INTO `park` VALUES ('1781', 'C', '413', '0');
INSERT INTO `park` VALUES ('1782', 'C', '414', '0');
INSERT INTO `park` VALUES ('1783', 'C', '415', '0');
INSERT INTO `park` VALUES ('1784', 'C', '416', '0');
INSERT INTO `park` VALUES ('1785', 'C', '417', '0');
INSERT INTO `park` VALUES ('1786', 'C', '418', '0');
INSERT INTO `park` VALUES ('1787', 'C', '419', '0');
INSERT INTO `park` VALUES ('1788', 'C', '420', '0');
INSERT INTO `park` VALUES ('1789', 'C', '421', '0');
INSERT INTO `park` VALUES ('1790', 'C', '422', '0');
INSERT INTO `park` VALUES ('1791', 'C', '423', '0');
INSERT INTO `park` VALUES ('1792', 'C', '424', '0');
INSERT INTO `park` VALUES ('1793', 'C', '425', '0');
INSERT INTO `park` VALUES ('1794', 'C', '426', '0');
INSERT INTO `park` VALUES ('1795', 'C', '427', '0');
INSERT INTO `park` VALUES ('1796', 'C', '428', '0');
INSERT INTO `park` VALUES ('1797', 'C', '429', '0');
INSERT INTO `park` VALUES ('1798', 'C', '430', '0');
INSERT INTO `park` VALUES ('1799', 'C', '431', '0');
INSERT INTO `park` VALUES ('1800', 'C', '432', '0');
INSERT INTO `park` VALUES ('1801', 'C', '433', '0');
INSERT INTO `park` VALUES ('1802', 'C', '434', '0');
INSERT INTO `park` VALUES ('1803', 'C', '435', '0');
INSERT INTO `park` VALUES ('1804', 'C', '436', '0');
INSERT INTO `park` VALUES ('1805', 'C', '437', '0');
INSERT INTO `park` VALUES ('1806', 'C', '438', '0');
INSERT INTO `park` VALUES ('1807', 'C', '439', '0');
INSERT INTO `park` VALUES ('1808', 'C', '440', '0');
INSERT INTO `park` VALUES ('1809', 'C', '441', '0');
INSERT INTO `park` VALUES ('1810', 'C', '442', '0');
INSERT INTO `park` VALUES ('1811', 'C', '443', '0');
INSERT INTO `park` VALUES ('1812', 'C', '444', '0');
INSERT INTO `park` VALUES ('1813', 'C', '445', '0');
INSERT INTO `park` VALUES ('1814', 'C', '446', '0');
INSERT INTO `park` VALUES ('1815', 'C', '447', '0');
INSERT INTO `park` VALUES ('1816', 'C', '448', '0');
INSERT INTO `park` VALUES ('1817', 'C', '449', '0');
INSERT INTO `park` VALUES ('1818', 'C', '450', '0');
INSERT INTO `park` VALUES ('1819', 'C', '451', '0');
INSERT INTO `park` VALUES ('1820', 'C', '452', '0');
INSERT INTO `park` VALUES ('1821', 'C', '453', '0');
INSERT INTO `park` VALUES ('1822', 'C', '454', '0');
INSERT INTO `park` VALUES ('1823', 'C', '455', '0');
INSERT INTO `park` VALUES ('1824', 'C', '456', '0');
INSERT INTO `park` VALUES ('1825', 'C', '457', '0');
INSERT INTO `park` VALUES ('1826', 'C', '458', '0');
INSERT INTO `park` VALUES ('1827', 'C', '459', '0');
INSERT INTO `park` VALUES ('1828', 'C', '460', '0');
INSERT INTO `park` VALUES ('1829', 'C', '461', '0');
INSERT INTO `park` VALUES ('1830', 'C', '462', '0');
INSERT INTO `park` VALUES ('1831', 'C', '463', '0');
INSERT INTO `park` VALUES ('1832', 'C', '464', '0');
INSERT INTO `park` VALUES ('1833', 'C', '465', '0');
INSERT INTO `park` VALUES ('1834', 'C', '466', '0');
INSERT INTO `park` VALUES ('1835', 'C', '467', '0');
INSERT INTO `park` VALUES ('1836', 'C', '468', '0');
INSERT INTO `park` VALUES ('1837', 'C', '469', '0');
INSERT INTO `park` VALUES ('1838', 'C', '470', '0');
INSERT INTO `park` VALUES ('1839', 'C', '471', '0');
INSERT INTO `park` VALUES ('1840', 'C', '472', '0');
INSERT INTO `park` VALUES ('1841', 'C', '473', '0');
INSERT INTO `park` VALUES ('1842', 'C', '474', '0');
INSERT INTO `park` VALUES ('1843', 'C', '475', '0');
INSERT INTO `park` VALUES ('1844', 'C', '476', '0');
INSERT INTO `park` VALUES ('1845', 'C', '477', '0');
INSERT INTO `park` VALUES ('1846', 'C', '478', '0');
INSERT INTO `park` VALUES ('1847', 'C', '479', '0');
INSERT INTO `park` VALUES ('1848', 'C', '480', '0');
INSERT INTO `park` VALUES ('1849', 'C', '481', '0');
INSERT INTO `park` VALUES ('1850', 'C', '482', '0');
INSERT INTO `park` VALUES ('1851', 'C', '483', '0');
INSERT INTO `park` VALUES ('1852', 'C', '484', '0');
INSERT INTO `park` VALUES ('1853', 'C', '485', '0');
INSERT INTO `park` VALUES ('1854', 'C', '486', '0');
INSERT INTO `park` VALUES ('1855', 'C', '487', '0');
INSERT INTO `park` VALUES ('1856', 'C', '488', '0');
INSERT INTO `park` VALUES ('1857', 'C', '489', '0');
INSERT INTO `park` VALUES ('1858', 'C', '490', '0');
INSERT INTO `park` VALUES ('1859', 'C', '491', '0');
INSERT INTO `park` VALUES ('1860', 'C', '492', '0');
INSERT INTO `park` VALUES ('1861', 'C', '493', '0');
INSERT INTO `park` VALUES ('1862', 'C', '494', '0');
INSERT INTO `park` VALUES ('1863', 'C', '495', '0');
INSERT INTO `park` VALUES ('1864', 'C', '496', '0');
INSERT INTO `park` VALUES ('1865', 'C', '497', '0');
INSERT INTO `park` VALUES ('1866', 'C', '498', '0');
INSERT INTO `park` VALUES ('1867', 'C', '499', '0');
INSERT INTO `park` VALUES ('1868', 'C', '500', '0');

-- ----------------------------
-- Table structure for parking
-- ----------------------------
DROP TABLE IF EXISTS `parking`;
CREATE TABLE `parking` (
  `id` int NOT NULL AUTO_INCREMENT COMMENT '停车信息编号',
  `licensePlate` varchar(7) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '车牌号',
  `in` datetime NOT NULL COMMENT '进库时间',
  `parkId` int NOT NULL COMMENT '停车位编号',
  `money` double DEFAULT NULL COMMENT '金额',
  `out` datetime DEFAULT NULL COMMENT '出库时间',
  PRIMARY KEY (`id`),
  KEY `licensePlate` (`licensePlate`),
  KEY `park` (`parkId`),
  CONSTRAINT `licensePlate` FOREIGN KEY (`licensePlate`) REFERENCES `cars` (`licensePlate`) ON DELETE CASCADE ON UPDATE CASCADE,
  CONSTRAINT `park` FOREIGN KEY (`parkId`) REFERENCES `park` (`id`) ON DELETE CASCADE ON UPDATE CASCADE
) ENGINE=InnoDB AUTO_INCREMENT=51 DEFAULT CHARSET=utf8;

-- ----------------------------
-- Records of parking
-- ----------------------------
INSERT INTO `parking` VALUES ('42', '鲁vw7788', '2022-01-07 08:21:50', '1250', '0', '2022-01-07 08:24:03');
INSERT INTO `parking` VALUES ('44', '鲁vw7788', '2022-01-07 08:30:00', '1250', '12.8', '2022-01-07 10:47:09');
INSERT INTO `parking` VALUES ('50', '鲁vw7788', '2022-01-07 13:30:06', '1249', '0', '2022-01-07 13:37:21');

-- ----------------------------
-- Table structure for user
-- ----------------------------
DROP TABLE IF EXISTS `user`;
CREATE TABLE `user` (
  `name` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '账户名',
  `password` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '123456' COMMENT '账户密码',
  `anthority` int NOT NULL COMMENT '权限（0为超级管理员、1为操作员）',
  PRIMARY KEY (`name`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

-- ----------------------------
-- Records of user
-- ----------------------------
INSERT INTO `user` VALUES ('ly', '123123', '0');

-- ----------------------------
-- Table structure for vip
-- ----------------------------
DROP TABLE IF EXISTS `vip`;
CREATE TABLE `vip` (
  `id` int NOT NULL AUTO_INCREMENT COMMENT 'Vip编号',
  `level` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '等级名称',
  `discount` double(11,2) NOT NULL COMMENT '折扣',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=4 DEFAULT CHARSET=utf8;

-- ----------------------------
-- Records of vip
-- ----------------------------
INSERT INTO `vip` VALUES ('1', '大众会员', '1.00');
INSERT INTO `vip` VALUES ('2', '黄金会员', '0.95');
INSERT INTO `vip` VALUES ('3', '钻石会员', '0.80');

-- ----------------------------
-- Procedure structure for autoinsertinfo
-- ----------------------------
DROP PROCEDURE IF EXISTS `autoinsertinfo`;
DELIMITER ;;
CREATE DEFINER=`root`@`localhost` PROCEDURE `autoinsertinfo`()
BEGIN
	DECLARE i int DEFAULT 1 ;
	WHILE (i<21)DO
		INSERT INTO park(area,number,state) VALUES("A",i,0);
		SET i = i+1;
	END WHILE;
SET i = 1;
WHILE(i<101)DO
INSERT INTO park(area,number,state) VALUES("B",i,0);
		SET i = i+1;
END WHILE;
SET i = 1;
WHILE(i<501)DO
INSERT INTO park(area,number,state) VALUES("C",i,0);
		SET i = i+1;
END WHILE;
END
;;
DELIMITER ;
DROP TRIGGER IF EXISTS `ownermessage`;
DELIMITER ;;
CREATE TRIGGER `ownermessage` BEFORE INSERT ON `owner` FOR EACH ROW BEGIN 
SET new.money = 0;
SET new.level = 1;
END
;;
DELIMITER ;
DROP TRIGGER IF EXISTS `ownerupdate`;
DELIMITER ;;
CREATE TRIGGER `ownerupdate` BEFORE UPDATE ON `owner` FOR EACH ROW BEGIN 
IF new.money>99 AND new.money<499 THEN SET new.level=2;
ELSEIF new.money>499 THEN SET new.level=3;
ELSEIF new.money<100 THEN SET new.level=1;
END IF;
END
;;
DELIMITER ;
DROP TRIGGER IF EXISTS `updatesurplus`;
DELIMITER ;;
CREATE TRIGGER `updatesurplus` BEFORE UPDATE ON `park` FOR EACH ROW BEGIN
DECLARE name1 varchar(1);
SET name1 = old.area;
IF old.state = 0 THEN
UPDATE area
SET surplus = surplus - 1
WHERE name = name1;
ELSEIF old.state = 1 THEN
UPDATE area
SET surplus = surplus + 1
WHERE name = name1;
end IF;
END
;;
DELIMITER ;
DROP TRIGGER IF EXISTS `inserttimeandupdatestate`;
DELIMITER ;;
CREATE TRIGGER `inserttimeandupdatestate` BEFORE INSERT ON `parking` FOR EACH ROW BEGIN
DECLARE pid INT;
SET new.in = NOW();
SET pid = new.parkId;
UPDATE park
SET state = 1
WHERE id = pid;
END
;;
DELIMITER ;
DROP TRIGGER IF EXISTS `updatestate`;
DELIMITER ;;
CREATE TRIGGER `updatestate` BEFORE UPDATE ON `parking` FOR EACH ROW BEGIN
DECLARE pid INT;
SET pid = old.parkId;
UPDATE park
SET state = 0
WHERE id = pid;

END
;;
DELIMITER ;
DROP TRIGGER IF EXISTS `updatestate1`;
DELIMITER ;;
CREATE TRIGGER `updatestate1` BEFORE UPDATE ON `parking` FOR EACH ROW BEGIN
DECLARE pid INT;
SET pid = new.parkId;
UPDATE park
SET state = 1
WHERE id = pid;
END
;;
DELIMITER ;
DROP TRIGGER IF EXISTS `getmoney`;
DELIMITER ;;
CREATE TRIGGER `getmoney` BEFORE UPDATE ON `parking` FOR EACH ROW BEGIN
DECLARE pid INT;
DECLARE hour INT;
DECLARE area1 VARCHAR(255);
DECLARE price1 DOUBLE;
DECLARE owner1 INT;
DECLARE level1 INT;
DECLARE discount1 double;
DECLARE money1 double;
SET pid = old.parkId;
SET hour = TIMESTAMPDIFF(HOUR,new.in,new.out);
SELECT area  from park where id =old.parkId INTO area1;
SELECT price from area WHERE name = area1 INTO price1  ;
SELECT ownerId from cars WHERE licensePlate = old.licensePlate INTO owner1;
SET level1 = (SELECT  level from `owner` WHERE id = owner1 );
SET discount1 = (SELECT discount from vip where id = level1);
SET new.money = hour*price1*discount1;
if old.money != 0
THEN
SET money1 = hour*price1*discount1;
UPDATE `owner`
SET money = money+money1 where id = owner1 ;
END IF;
END
;;
DELIMITER ;