shuguang/lzh
1
0
Fork 0
Code Issues Pull Requests Actions Packages Projects Releases 1 Wiki Activity
main
lzh/停车场管理系统/car/car.sql

294 lines
22 KiB
MySQL
Raw Permalink Normal View History

初始化项目
2024-11-10 21:42:55 +08:00
/*
Navicat Premium Data Transfer
Source Server : car
Source Server Type : MySQL
Source Server Version : 50726
Source Host : localhost:3306
Source Schema : car
Target Server Type : MySQL
Target Server Version : 50726
File Encoding : 65001
Date: 13/03/2024 22:01:07
*/
SET NAMES utf8mb4;
SET FOREIGN_KEY_CHECKS = 0;
-- ----------------------------
-- Table structure for admin
-- ----------------------------
DROP TABLE IF EXISTS `admin`;
CREATE TABLE `admin` (
`AdminId` bigint(20) NOT NULL COMMENT '管理员ID',
`AdminName` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '管理员账号',
`AdminPassWord` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '管理员密码\r\n',
`AdminUser` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '管理员姓名',
PRIMARY KEY (`AdminId`) USING BTREE
) ENGINE = MyISAM CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = Dynamic;
-- ----------------------------
-- Records of admin
-- ----------------------------
INSERT INTO `admin` VALUES (1, '张增煊', '111', '111');
-- ----------------------------
-- Table structure for brand
-- ----------------------------
DROP TABLE IF EXISTS `brand`;
CREATE TABLE `brand` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`brand_name_ch` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL,
`brand_name_en` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL,
`brand_logo` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL,
`status` int(11) NOT NULL DEFAULT 1,
PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 85 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci ROW_FORMAT = Dynamic;
-- ----------------------------
-- Records of brand
-- ----------------------------
INSERT INTO `brand` VALUES (1, '奥迪', 'Audi', 'https://img.pqblog.com/i/2024/03/08/145046.png\r\n', 0);
INSERT INTO `brand` VALUES (2, '红旗', 'Hong Qi', 'https://img.pqblog.com/i/2024/03/08/145128.png', 1);
INSERT INTO `brand` VALUES (60, '比亚迪', 'Build Your Dreams', 'https://img.pqblog.com/i/2024/03/08/145242.png', 1);
INSERT INTO `brand` VALUES (61, '极狐', 'ARCFOX', 'https://img.pqblog.com/i/2024/03/08/145353.png', 1);
INSERT INTO `brand` VALUES (62, '阿维塔', 'AVATR', 'https://img.pqblog.com/i/2024/03/08/145422.png', 1);
INSERT INTO `brand` VALUES (63, '宝马', 'Bavarian Motor Work', 'https://img.pqblog.com/i/2024/03/08/145438.png', 0);
INSERT INTO `brand` VALUES (64, '北京现代', 'BEIJING-HYUNDAI AUTO', 'https://img.pqblog.com/i/2024/03/08/145500.png', 1);
INSERT INTO `brand` VALUES (65, '奔驰', 'Mercedes-Benz', 'https://img.pqblog.com/i/2024/03/08/145515.png', 0);
INSERT INTO `brand` VALUES (66, '本田', 'Honda', 'https://img.pqblog.com/i/2024/03/08/145547.png', 1);
INSERT INTO `brand` VALUES (67, '大众', 'Volkswagen', 'https://img.pqblog.com/i/2024/03/08/145606.png', 1);
INSERT INTO `brand` VALUES (68, '丰田', 'TOYOTA MOTOR CORPORATION JAPAN', 'https://img.pqblog.com/i/2024/03/08/145639.png', 1);
INSERT INTO `brand` VALUES (69, '福特', 'Ford', 'https://img.pqblog.com/i/2024/03/08/145747.png', 1);
INSERT INTO `brand` VALUES (70, '观致', 'Qoros', 'https://img.pqblog.com/i/2024/03/08/145814.png', 0);
INSERT INTO `brand` VALUES (71, '哈佛', 'HAVAL', 'https://img.pqblog.com/i/2024/03/08/145851.png', 1);
INSERT INTO `brand` VALUES (72, '海马', 'Haima', 'https://img.pqblog.com/i/2024/03/08/145916.png', 1);
INSERT INTO `brand` VALUES (73, '吉利', 'Gellyauto', 'https://img.pqblog.com/i/2024/03/08/145950.png', 1);
INSERT INTO `brand` VALUES (74, '凯迪拉克', 'Cadillac', 'https://img.pqblog.com/i/2024/03/08/150017.png', 1);
INSERT INTO `brand` VALUES (75, '雷克萨斯', 'Lexus', 'https://img.pqblog.com/i/2024/03/08/150140.png', 1);
INSERT INTO `brand` VALUES (76, '奇瑞', 'CHERY ', 'https://img.pqblog.com/i/2024/03/08/150203.png', 1);
INSERT INTO `brand` VALUES (77, '特斯拉', 'Tesla', 'https://img.pqblog.com/i/2024/03/08/150221.png', 0);
INSERT INTO `brand` VALUES (78, '沃尔沃', 'Volvo', 'https://img.pqblog.com/i/2024/03/08/150310.png', 1);
INSERT INTO `brand` VALUES (79, '雪佛兰', 'Chevrolet', 'https://img.pqblog.com/i/2024/03/08/150236.png', 1);
INSERT INTO `brand` VALUES (81, '长安', 'CHANA', 'https://img.pqblog.com/i/2024/03/08/150336.png', 1);
INSERT INTO `brand` VALUES (83, '五菱汽车', 'WuLing', 'https://img.pqblog.com/i/2024/03/08/150410.png', 1);
INSERT INTO `brand` VALUES (84, '长安欧尚', 'OSHAN', 'https://img.pqblog.com/i/2024/03/08/150422.png', 1);
-- ----------------------------
-- Table structure for car
-- ----------------------------
DROP TABLE IF EXISTS `car`;
CREATE TABLE `car` (
`CarId` bigint(255) NOT NULL AUTO_INCREMENT COMMENT '车辆ID',
`CarModel` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '车辆型号',
`CarLicense` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '车牌号',
`CarContent` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '车辆介绍',
`CarColour` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '车辆颜色',
`CarPhoto` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '车辆照片',
`CarSecurityDeposit` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '车辆押金',
`CarDayMoney` bigint(255) NULL DEFAULT NULL COMMENT '车辆日租金',
`CarHoursMoney` bigint(255) NULL DEFAULT NULL COMMENT '车辆小时租金',
`parking_id` int(255) NULL DEFAULT NULL,
`energy` int(11) NULL DEFAULT NULL COMMENT '能源类型',
`emass` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '电量',
`omass` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '油量',
`km` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '续航',
`CarStatus` int(255) NULL DEFAULT NULL COMMENT '车辆出租情况 0为待租 1为已租 2为维修中 ',
`brand_id` int(255) NULL DEFAULT NULL,
PRIMARY KEY (`CarId`) USING BTREE
) ENGINE = MyISAM AUTO_INCREMENT = 10 CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = Dynamic;
-- ----------------------------
-- Records of car
-- ----------------------------
INSERT INTO `car` VALUES (1, '红旗H9', '陕A00001', '红旗H9是中国一汽旗下的高端豪华品牌红旗推出的一款豪华轿车', '黑色', 'https://img.pqblog.com/i/2024/03/08/150812.png', '500', 214, 100, 51, 0, '48', '0', '453', 1, 71);
INSERT INTO `car` VALUES (2, '辉腾', '陕A69852', '辉腾', '黑色', 'https://img.pqblog.com/i/2024/03/08/150949.png', '500', 999, 100, 52, 1, '0', '72', '248', 0, 67);
INSERT INTO `car` VALUES (3, '红旗H9', '陕A00002', '红旗H9是中国一汽旗下的高端豪华品牌红旗推出的一款豪华轿车', '黑色', 'https://img.pqblog.com/i/2024/03/08/151016.png', '500', 999, 100, 51, 0, '57', '0', '358', 0, 71);
INSERT INTO `car` VALUES (4, '五菱星辰', '陕A66630', '五菱星辰', '绿色', 'https://img.pqblog.com/i/2024/03/08/151125.png', '500', 999, 100, 52, 1, '0', '35', '485', 1, 83);
INSERT INTO `car` VALUES (5, '长安CS75 PLUS', '陕UJ702D', '长安CS75 PLUS', '黑色', 'https://img.pqblog.com/i/2024/03/08/151221.png', '500', 999, 100, 52, 1, '0', '44', '457', 1, 81);
INSERT INTO `car` VALUES (6, '长安欧尚Z6', '陕UZX250', '长安欧尚Z6', '蓝色', 'https://img.pqblog.com/i/2024/03/08/151331.png', '500', 999, 100, 52, 1, '0', '87', '245', 1, 84);
INSERT INTO `car` VALUES (7, '比亚迪 秦PLUS', '陕U251K7', '比亚迪 秦PLUS', '白色', 'https://img.pqblog.com/i/2024/03/08/151530.png', '500', 999, 100, 52, 1, '0', '91', '216', 0, 60);
INSERT INTO `car` VALUES (8, '哈佛H6', '陕UC8602', '哈佛H6', '蓝色', 'https://img.pqblog.com/i/2024/03/08/151704.png', '500', 999, 100, 52, 1, '0', '27', '365', 0, 71);
INSERT INTO `car` VALUES (9, '长安欧尚Z6', '陕U88ASD', '长安欧尚Z6', '蓝色', 'https://img.pqblog.com/i/2024/03/08/151331.png', '500', 999, 100, 52, 1, '0', '54', '247', 0, 84);
-- ----------------------------
-- Table structure for comments
-- ----------------------------
DROP TABLE IF EXISTS `comments`;
CREATE TABLE `comments` (
`CommentId` int(11) NOT NULL AUTO_INCREMENT,
`text` text CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,
`pub_date` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,
`CarId` int(11) NOT NULL,
`UserId` int(11) NOT NULL,
`UserName` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,
PRIMARY KEY (`CommentId`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 29 CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = Dynamic;
-- ----------------------------
-- Records of comments
-- ----------------------------
INSERT INTO `comments` VALUES (25, '111', '2024-03-05 17:58:42', 2, 18, '111');
INSERT INTO `comments` VALUES (26, '可以', '2024-03-05 18:56:38', 2, 18, '111');
INSERT INTO `comments` VALUES (27, '牛逼', '2024-03-09 20:46:51', 2, 18, '111');
INSERT INTO `comments` VALUES (28, '666', '2024-03-12 21:29:29', 6, 18, '111');
-- ----------------------------
-- Table structure for order
-- ----------------------------
DROP TABLE IF EXISTS `order`;
CREATE TABLE `order` (
`OrderId` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '订单ID',
`UserId` bigint(20) NULL DEFAULT NULL COMMENT '用户ID',
`CarId` bigint(20) NULL DEFAULT NULL COMMENT '车辆ID',
`PactId` bigint(20) NULL DEFAULT NULL COMMENT '合同ID',
`OrderMoney` bigint(255) NULL DEFAULT NULL COMMENT '费用合计',
`OutPicture` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '取车照片',
`InPicture` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '还车照片',
`OutTime` datetime(0) NULL DEFAULT NULL COMMENT '出租时间',
`InTime` datetime(0) NULL DEFAULT NULL COMMENT '归还时间',
`Mode` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '出租模式 0为时租 1为日租',
`OrderStatus` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '订单状态 0为未完成 1为完成 ',
PRIMARY KEY (`OrderId`) USING BTREE
) ENGINE = MyISAM AUTO_INCREMENT = 32 CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = Dynamic;
-- ----------------------------
-- Records of order
-- ----------------------------
INSERT INTO `order` VALUES (1, 5, 1, 1, 1000, 'https://img.pqblog.com/i/2024/03/08/150812.png', 'https://img.pqblog.com/i/2024/03/08/150812.png', '2024-02-02 16:10:06', '2024-02-26 22:10:12', '1', '1');
INSERT INTO `order` VALUES (2, 5, 1, 1, 2000, 'https://img.pqblog.com/i/2024/03/08/150812.png', 'https://img.pqblog.com/i/2024/03/08/150812.png', '2024-02-02 21:34:48', '2024-02-26 22:10:12', '1', '1');
INSERT INTO `order` VALUES (3, 5, 1, 1, 500, 'https://img.pqblog.com/i/2024/03/08/150812.png', 'https://img.pqblog.com/i/2024/03/08/150812.png', '2024-02-02 21:35:16', '2024-02-26 22:10:12', '1', '1');
INSERT INTO `order` VALUES (4, 5, 2, 2, 600, 'https://img.pqblog.com/i/2024/03/08/150812.png', 'https://img.pqblog.com/i/2024/03/08/150812.png', '2024-02-02 21:37:15', '2024-03-09 13:34:54', '0', '0');
INSERT INTO `order` VALUES (5, 5, 1, 1, 888, 'https://img.pqblog.com/i/2024/03/08/150812.png', 'https://img.pqblog.com/i/2024/03/08/150812.png', '2024-02-02 21:40:41', '2024-02-14 22:10:17', '1', '1');
INSERT INTO `order` VALUES (6, 5, 1, 1, 777, 'https://img.pqblog.com/i/2024/03/08/150812.png', 'https://img.pqblog.com/i/2024/03/08/150812.png', '2024-02-02 21:42:22', '2024-03-09 13:35:04', '1', '1');
INSERT INTO `order` VALUES (7, 6, 2, 2, 666, 'https://img.pqblog.com/i/2024/03/08/150812.png', 'https://img.pqblog.com/i/2024/03/08/150812.png', '2024-02-20 22:10:21', '2024-03-09 13:35:17', '1', '1');
INSERT INTO `order` VALUES (8, 18, 2, 1, 555, 'https://img.pqblog.com/i/2024/03/08/150812.png', 'https://img.pqblog.com/i/2024/03/08/150812.png', '2024-03-05 14:16:23', '2024-02-26 22:10:12', '1', '1');
INSERT INTO `order` VALUES (9, 6, 2, 1, 444, 'https://img.pqblog.com/i/2024/03/08/150812.png', 'https://img.pqblog.com/i/2024/03/08/150812.png', '2024-02-26 22:10:25', '2024-03-09 13:35:29', '0', '0');
INSERT INTO `order` VALUES (10, 18, 2, 1, 333, 'https://img.pqblog.com/i/2024/03/08/150812.png', 'https://img.pqblog.com/i/2024/03/08/150812.png', '2024-02-26 22:10:12', '2024-03-09 13:35:39', '0', '1');
INSERT INTO `order` VALUES (11, 18, 2, 1, 332, 'https://img.pqblog.com/i/2024/03/08/150812.png', 'https://img.pqblog.com/i/2024/03/08/150812.png', '2024-02-26 22:10:12', '2024-03-09 13:35:46', '1', '1');
INSERT INTO `order` VALUES (17, 18, 2, NULL, 2472, 'https://img.pqblog.com/i/2024/03/08/150812.png', 'https://img.pqblog.com/i/2024/03/09/172247-0.png', '2024-03-09 00:39:39', '2024-03-09 17:22:53', '0', '1');
INSERT INTO `order` VALUES (18, 18, 6, NULL, 10054, 'https://img.pqblog.com/i/2024/03/08/150812.png', 'https://img.pqblog.com/i/2024/03/12/212842-0.png', '2024-03-09 00:55:59', '2024-03-12 21:28:46', '0', '1');
INSERT INTO `order` VALUES (19, 18, 6, NULL, 0, 'https://img.pqblog.com/i/2024/03/08/150812.png', 'https://img.pqblog.com/i/2024/03/08/150812.png', '2024-03-09 00:55:59', NULL, '0', '0');
INSERT INTO `order` VALUES (20, 18, 6, NULL, 0, 'https://img.pqblog.com/i/2024/03/08/150812.png', 'https://img.pqblog.com/i/2024/03/08/150812.png', '2024-03-09 00:55:59', NULL, '0', '0');
INSERT INTO `order` VALUES (21, 18, 6, NULL, 0, 'https://img.pqblog.com/i/2024/03/08/150812.png', 'https://img.pqblog.com/i/2024/03/08/150812.png', '2024-03-09 00:55:59', NULL, '0', '0');
INSERT INTO `order` VALUES (22, 18, 6, NULL, 0, 'https://img.pqblog.com/i/2024/03/08/150812.png', 'https://img.pqblog.com/i/2024/03/08/150812.png', '2024-03-09 00:55:59', NULL, '0', '0');
INSERT INTO `order` VALUES (23, 18, 6, NULL, 0, 'https://img.pqblog.com/i/2024/03/08/150812.png', 'https://img.pqblog.com/i/2024/03/08/150812.png', '2024-03-09 00:55:59', NULL, '0', '0');
INSERT INTO `order` VALUES (24, 18, 6, NULL, 0, 'https://img.pqblog.com/i/2024/03/08/150812.png', 'https://img.pqblog.com/i/2024/03/08/150812.png', '2024-03-09 00:55:59', NULL, '0', '0');
INSERT INTO `order` VALUES (25, 18, 6, NULL, 10049, 'https://img.pqblog.com/i/2024/03/08/150812.png', 'https://img.pqblog.com/i/2024/03/12/212509-0.png', '2024-03-09 00:55:59', '2024-03-12 21:25:12', '0', '1');
INSERT INTO `order` VALUES (26, 18, 6, NULL, 0, 'https://img.pqblog.com/i/2024/03/12/212434-0.png', 'https://img.pqblog.com/i/2024/03/12/222645-0.png', '2024-03-12 21:24:36', '2024-03-12 22:26:46', '1', '1');
INSERT INTO `order` VALUES (27, 18, 6, NULL, 0, 'https://img.pqblog.com/i/2024/03/12/212434-0.png', '', '2024-03-12 21:24:36', '2024-03-12 21:41:58', '1', '1');
INSERT INTO `order` VALUES (28, 18, 5, NULL, 800, 'https://img.pqblog.com/i/2024/03/12/214453-0.png', 'https://img.pqblog.com/i/2024/03/12/214509-0.png', '2024-03-12 21:44:54', '2024-03-12 21:45:12', '0', '1');
INSERT INTO `order` VALUES (29, 18, 1, NULL, 409, 'https://img.pqblog.com/i/2024/03/12/214848-0.png', 'https://img.pqblog.com/i/2024/03/12/214953-0.png', '2024-03-12 21:48:50', '2024-03-12 21:49:59', '0', '1');
INSERT INTO `order` VALUES (30, 18, 3, NULL, 802, 'https://img.pqblog.com/i/2024/03/12/221737-0.png', 'https://img.pqblog.com/i/2024/03/12/221904-0.png', '2024-03-12 22:17:39', '2024-03-12 22:19:09', '0', '1');
INSERT INTO `order` VALUES (31, 18, 6, NULL, 800, 'https://img.pqblog.com/i/2024/03/12/222949-0.png', 'https://img.pqblog.com/i/2024/03/12/223016-0.png', '2024-03-12 22:29:51', '2024-03-12 22:41:09', '0', '1');
-- ----------------------------
-- Table structure for pact
-- ----------------------------
DROP TABLE IF EXISTS `pact`;
CREATE TABLE `pact` (
`PactId` int(255) NOT NULL COMMENT '合同ID',
`CarId` int(255) NULL DEFAULT NULL COMMENT '车辆ID',
`UserId` int(255) NULL DEFAULT NULL COMMENT '用户ID',
`PactMoney` bigint(255) NULL DEFAULT NULL COMMENT '保险费用',
`OutTime` datetime(0) NULL DEFAULT NULL COMMENT '出租时间',
`InTime` datetime(0) NULL DEFAULT NULL COMMENT '归还时间',
`PactContent` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '保险内容',
PRIMARY KEY (`PactId`) USING BTREE
) ENGINE = MyISAM CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = Dynamic;
-- ----------------------------
-- Records of pact
-- ----------------------------
INSERT INTO `pact` VALUES (1, 2, 18, 500, '2024-03-05 18:37:19', '2024-03-05 18:37:24', '解放东路');
-- ----------------------------
-- Table structure for parking
-- ----------------------------
DROP TABLE IF EXISTS `parking`;
CREATE TABLE `parking` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`parkingName` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '停车场名称',
`address` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '详细地址',
`type` int(11) NOT NULL COMMENT '室内/室外 0：室内 1：室外',
`carsNumber` int(11) NOT NULL DEFAULT 0 COMMENT '可停放数量',
`enable` tinyint(1) NOT NULL COMMENT '禁启用',
`coord` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '经纬度',
PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 53 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci ROW_FORMAT = Dynamic;
-- ----------------------------
-- Records of parking
-- ----------------------------
INSERT INTO `parking` VALUES (21, '楼观停车场', '陕西省西安市周至县楼观镇政府隔壁', 1, 7, 1, '108.300245,34.084055');
INSERT INTO `parking` VALUES (22, '首都停车场', '北京市海淀区东丈八路', 1, 6, 1, '116.405637,39.906917');
INSERT INTO `parking` VALUES (23, '小日本停车场', '小日本东京市区', 1, 13, 1, '139.794253,35.707603');
INSERT INTO `parking` VALUES (26, '南山停车场', '重庆第二师范学院南山校区', 1, 3, 1, '106.593706,29.498425');
INSERT INTO `parking` VALUES (44, '玄武停车场', '南京玄武区人民政府', 1, 7, 0, '118.797767,32.048673');
INSERT INTO `parking` VALUES (51, '豆村停车场', '陕西省西安市周至县中二路南四街与中一路交叉路口往东约250米', 0, 22, 1, '108.356593,34.136361');
INSERT INTO `parking` VALUES (52, '明德停车场', '陕西省西安市长安区西滦路南山庭院西360米', 1, 5, 1, '108.792002,34.051373');
-- ----------------------------
-- Table structure for phone
-- ----------------------------
DROP TABLE IF EXISTS `phone`;
CREATE TABLE `phone` (
`phone` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '用户手机号',
`code` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '验证码'
) ENGINE = MyISAM CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = Dynamic;
-- ----------------------------
-- Records of phone
-- ----------------------------
INSERT INTO `phone` VALUES ('18509144920', '7654');
-- ----------------------------
-- Table structure for repair
-- ----------------------------
DROP TABLE IF EXISTS `repair`;
CREATE TABLE `repair` (
`RepairId` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '维修ID',
`CarId` bigint(20) NULL DEFAULT NULL COMMENT '车辆ID',
`RepairReason` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '故障原因',
`PactId` bigint(255) NULL DEFAULT NULL COMMENT '保险合同ID',
`RepairMoney` bigint(255) NULL DEFAULT NULL COMMENT '维修费用',
`RepairStatus` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '维修状态',
PRIMARY KEY (`RepairId`) USING BTREE
) ENGINE = MyISAM AUTO_INCREMENT = 13 CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = Dynamic;
-- ----------------------------
-- Records of repair
-- ----------------------------
INSERT INTO `repair` VALUES (12, 8, '打不着火', NULL, 500, '1');
-- ----------------------------
-- Table structure for user
-- ----------------------------
DROP TABLE IF EXISTS `user`;
CREATE TABLE `user` (
`UserId` bigint(255) NOT NULL AUTO_INCREMENT COMMENT '用户ID',
`Phone` bigint(255) NULL DEFAULT NULL COMMENT '用户手机号',
`UserName` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '用户姓名',
`PassWord` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '用户密码',
`IdCard` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '身份证',
`DriverLicense` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '驾照',
`code` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '临时存储验证码',
PRIMARY KEY (`UserId`) USING BTREE
) ENGINE = MyISAM AUTO_INCREMENT = 19 CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = Dynamic;
-- ----------------------------
-- Records of user
-- ----------------------------
INSERT INTO `user` VALUES (5, 18509144921, '张增煊', '123456', '612522200207031996', '100000', '2668');
INSERT INTO `user` VALUES (6, 17791641989, '张三', '123456', '610522200001051636', '333333', NULL);
INSERT INTO `user` VALUES (7, 19991641989, '王五', '123456', '6101968755501021952', '44444', NULL);
INSERT INTO `user` VALUES (14, 18509144922, '张增煊', '123456', '612522200207031996', '000', NULL);
INSERT INTO `user` VALUES (15, 18509144923, '张增煊', '123456', NULL, NULL, NULL);
INSERT INTO `user` VALUES (16, 18509144923, 'sss', '123456', NULL, NULL, NULL);
INSERT INTO `user` VALUES (17, 18509144924, 'ssss', '123456', NULL, NULL, NULL);
INSERT INTO `user` VALUES (18, 18509144920, '增增', '123456', '612522200207031996', 'https://img.pqblog.com/i/2024/03/10/150423-0.png', NULL);
SET FOREIGN_KEY_CHECKS = 1;
Reference in New Issue Copy Permalink