master

分支 (1)

管理

管理

master

car-rental-platform
/
car-cl.sql

/*
Navicat MySQL Data Transfer

Source Server         : ceshi
Source Server Version : 50505
Source Host           : localhost:3306
Source Database       : car-cl

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

Date: 2023-12-25 17:22:23
*/

SET FOREIGN_KEY_CHECKS=0;

-- ----------------------------
-- Table structure for car
-- ----------------------------
DROP TABLE IF EXISTS `car`;
CREATE TABLE `car` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `carname` varchar(255) COLLATE utf8mb4_unicode_nopad_ci DEFAULT '',
  `ppid` int(11) NOT NULL,
  `carimg` varchar(255) COLLATE utf8mb4_unicode_nopad_ci DEFAULT NULL,
  `cph` varchar(255) COLLATE utf8mb4_unicode_nopad_ci DEFAULT NULL,
  `status` varchar(255) COLLATE utf8mb4_unicode_nopad_ci DEFAULT NULL,
  `zj` varchar(255) COLLATE utf8mb4_unicode_nopad_ci DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=7 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_nopad_ci;

-- ----------------------------
-- Records of car
-- ----------------------------
INSERT INTO `car` VALUES ('1', '小车1', '2', 'http://demo-mp3.oss-cn-shenzhen.aliyuncs.com/egg-edu-demo/0b33ef059aa5ac4d0d67.webp', '京W45125', '0', '10');
INSERT INTO `car` VALUES ('2', '2', '1', null, null, null, '10');
INSERT INTO `car` VALUES ('4', '奔驰1车', '3', 'http://demo-mp3.oss-cn-shenzhen.aliyuncs.com/egg-edu-demo/c436220bd5a01a1a5d35.webp', null, '1', '10');
INSERT INTO `car` VALUES ('5', '雪佛兰', '3', 'http://demo-mp3.oss-cn-shenzhen.aliyuncs.com/egg-edu-demo/fb9780f47b4c6be09078.webp', null, '0', '10');
INSERT INTO `car` VALUES ('6', '奥迪1', '5', 'http://demo-mp3.oss-cn-shenzhen.aliyuncs.com/egg-edu-demo/050c57760c98284ae83d.webp', null, '0', '10');

-- ----------------------------
-- Table structure for gonggao
-- ----------------------------
DROP TABLE IF EXISTS `gonggao`;
CREATE TABLE `gonggao` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `title` varchar(255) COLLATE utf8mb4_unicode_nopad_ci DEFAULT NULL,
  `content` varchar(255) COLLATE utf8mb4_unicode_nopad_ci DEFAULT NULL,
  `cjsj` varchar(255) COLLATE utf8mb4_unicode_nopad_ci DEFAULT NULL,
  `cjr` varchar(255) COLLATE utf8mb4_unicode_nopad_ci DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=5 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_nopad_ci;

-- ----------------------------
-- Records of gonggao
-- ----------------------------
INSERT INTO `gonggao` VALUES ('1', '今天天气不错，大家一起出去玩吧', '今天天气不错，大家一起出去玩吧', '2023-12-25', 'admin3');
INSERT INTO `gonggao` VALUES ('2', '系统开发完成', '开发完成', '2023-12-25', 'admin3');
INSERT INTO `gonggao` VALUES ('4', '租赁系统开发完成', '大家可以看看', '2023-12-25', 'admin3');

-- ----------------------------
-- Table structure for pinglun
-- ----------------------------
DROP TABLE IF EXISTS `pinglun`;
CREATE TABLE `pinglun` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `content` mediumtext COLLATE utf8mb4_unicode_nopad_ci DEFAULT NULL,
  `userid` int(11) DEFAULT NULL,
  `wzid` int(11) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=4 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_nopad_ci;

-- ----------------------------
-- Records of pinglun
-- ----------------------------
INSERT INTO `pinglun` VALUES ('1', '太好了', '4', '1');
INSERT INTO `pinglun` VALUES ('2', '不好', '1', '1');
INSERT INTO `pinglun` VALUES ('3', 'hao ', '1', '2');

-- ----------------------------
-- Table structure for pinpai
-- ----------------------------
DROP TABLE IF EXISTS `pinpai`;
CREATE TABLE `pinpai` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `name` varchar(255) COLLATE utf8mb4_unicode_nopad_ci DEFAULT NULL,
  `icon` varchar(255) COLLATE utf8mb4_unicode_nopad_ci DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=6 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_nopad_ci;

-- ----------------------------
-- Records of pinpai
-- ----------------------------
INSERT INTO `pinpai` VALUES ('2', '奔驰', 'http://demo-mp3.oss-cn-shenzhen.aliyuncs.com/egg-edu-demo/c92b1db4bcfd24403537.jpg');
INSERT INTO `pinpai` VALUES ('3', '雪佛兰', 'http://demo-mp3.oss-cn-shenzhen.aliyuncs.com/egg-edu-demo/55093e0af5d950f7dec9.jpg');
INSERT INTO `pinpai` VALUES ('5', '奥迪', 'http://demo-mp3.oss-cn-shenzhen.aliyuncs.com/egg-edu-demo/7ae5f7e80f707fa17391.webp');

-- ----------------------------
-- Table structure for user
-- ----------------------------
DROP TABLE IF EXISTS `user`;
CREATE TABLE `user` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `username` varchar(255) COLLATE utf8mb4_unicode_nopad_ci DEFAULT NULL,
  `password` varchar(255) COLLATE utf8mb4_unicode_nopad_ci DEFAULT NULL,
  `type` varchar(255) COLLATE utf8mb4_unicode_nopad_ci DEFAULT NULL,
  `status` varchar(255) COLLATE utf8mb4_unicode_nopad_ci DEFAULT NULL,
  `phone` varchar(255) COLLATE utf8mb4_unicode_nopad_ci DEFAULT NULL,
  `email` varchar(255) COLLATE utf8mb4_unicode_nopad_ci DEFAULT NULL,
  `avator` varchar(255) COLLATE utf8mb4_unicode_nopad_ci DEFAULT NULL,
  `name` varchar(255) COLLATE utf8mb4_unicode_nopad_ci DEFAULT NULL,
  `fjly` varchar(255) COLLATE utf8mb4_unicode_nopad_ci DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=126 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_nopad_ci;

-- ----------------------------
-- Records of user
-- ----------------------------
INSERT INTO `user` VALUES ('1', 'admin', '123321', '1', '2', '18803268331', '1332699687@qq.com', null, null, null);
INSERT INTO `user` VALUES ('4', 'wangshuo', '123321', '2', '2', '18803268331', '1332699687@qq.com', 'http://demo-mp3.oss-cn-shenzhen.aliyuncs.com/egg-edu-demo/67992bbafe5bc1c68f69.jpeg', '王朔', '1233333');
INSERT INTO `user` VALUES ('5', 'wangshuo1', '123321', '2', '2', null, null, null, '王朔1', '违规了');
INSERT INTO `user` VALUES ('6', 'dekai', '123321', '2', '2', null, null, null, null, null);
INSERT INTO `user` VALUES ('7', 'admin3', '123321', '2', '0', null, null, null, null, null);
INSERT INTO `user` VALUES ('8', 'bulaize', '123321', '2', '0', null, null, null, null, null);
INSERT INTO `user` VALUES ('125', 'admin3', 'admin', '1', '2', null, null, null, null, null);

-- ----------------------------
-- Table structure for usertest
-- ----------------------------
DROP TABLE IF EXISTS `usertest`;
CREATE TABLE `usertest` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `username` varchar(255) COLLATE utf8mb4_unicode_nopad_ci DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_nopad_ci;

-- ----------------------------
-- Records of usertest
-- ----------------------------
INSERT INTO `usertest` VALUES ('1', '12333');

-- ----------------------------
-- Table structure for wenzhang
-- ----------------------------
DROP TABLE IF EXISTS `wenzhang`;
CREATE TABLE `wenzhang` (
  `id` int(11) NOT NULL,
  `title` varchar(255) COLLATE utf8mb4_unicode_nopad_ci DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_nopad_ci;

-- ----------------------------
-- Records of wenzhang
-- ----------------------------
INSERT INTO `wenzhang` VALUES ('1', '1');
INSERT INTO `wenzhang` VALUES ('2', '12');

-- ----------------------------
-- Table structure for zldd
-- ----------------------------
DROP TABLE IF EXISTS `zldd`;
CREATE TABLE `zldd` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `zlsj` varchar(255) COLLATE utf8mb4_unicode_nopad_ci DEFAULT NULL,
  `ghsj` varchar(255) COLLATE utf8mb4_unicode_nopad_ci DEFAULT '',
  `username` varchar(255) COLLATE utf8mb4_unicode_nopad_ci DEFAULT NULL,
  `name` varchar(255) COLLATE utf8mb4_unicode_nopad_ci DEFAULT NULL,
  `phone` varchar(255) COLLATE utf8mb4_unicode_nopad_ci DEFAULT NULL,
  `sfz` varchar(255) COLLATE utf8mb4_unicode_nopad_ci DEFAULT NULL,
  `status` varchar(255) COLLATE utf8mb4_unicode_nopad_ci DEFAULT NULL,
  `shhf` varchar(255) COLLATE utf8mb4_unicode_nopad_ci DEFAULT NULL,
  `remark` varchar(255) COLLATE utf8mb4_unicode_nopad_ci DEFAULT NULL,
  `uid` int(11) DEFAULT NULL,
  `carid` int(11) DEFAULT NULL,
  `price` varchar(10) COLLATE utf8mb4_unicode_nopad_ci DEFAULT '',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=6 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_nopad_ci;

-- ----------------------------
-- Records of zldd
-- ----------------------------
INSERT INTO `zldd` VALUES ('1', '2023-12-28', '2023-12-29', 'wangshuo', '王朔', '18803268331', '123', '3', null, '1233', '4', '1', '10');
INSERT INTO `zldd` VALUES ('3', '2023-12-21', '2023-12-22', 'wangshuo', '王朔', '18803268331', '18803268331', '2', null, '123', '4', '4', '10');
INSERT INTO `zldd` VALUES ('4', '2023-12-12', '2023-12-29', 'wangshuo1', '王朔1', null, '188032683231', '1', null, '12333', '5', '4', '170');
INSERT INTO `zldd` VALUES ('5', '2023-12-22', '2023-12-30', 'wangshuo', '王朔', '18803268331', '123', '0', null, null, '4', '5', '80');