shuguang/lzh
1
0
Fork 0
Code Issues Pull Requests Actions Packages Projects Releases 1 Wiki Activity
main
lzh/停车场管理系统/car/car.sql
曙光 0532b02868 初始化项目
2024-11-10 21:42:55 +08:00

294 lines
22 KiB
SQL
Raw Permalink Blame History

This file contains ambiguous Unicode characters

This file contains Unicode characters that might be confused with other characters. If you think that this is intentional, you can safely ignore this warning. Use the Escape button to reveal them.

/*
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 View Git Blame Copy Permalink