228 lines
6.8 KiB
SQL
228 lines
6.8 KiB
SQL
-- phpMyAdmin SQL Dump
|
|
-- version 4.0.10.20
|
|
-- https://www.phpmyadmin.net
|
|
--
|
|
-- 主机: localhost
|
|
-- 生成日期: 2025-04-10 02:32:17
|
|
-- 服务器版本: 5.6.50-log
|
|
-- PHP 版本: 5.6.40
|
|
|
|
SET SQL_MODE = "NO_AUTO_VALUE_ON_ZERO";
|
|
SET time_zone = "+00:00";
|
|
|
|
|
|
/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
|
|
/*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
|
|
/*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;
|
|
/*!40101 SET NAMES utf8 */;
|
|
|
|
--
|
|
-- 数据库: `danche`
|
|
--
|
|
|
|
-- --------------------------------------------------------
|
|
|
|
--
|
|
-- 表的结构 `admin`
|
|
--
|
|
|
|
CREATE TABLE IF NOT EXISTS `admin` (
|
|
`id` int(4) NOT NULL AUTO_INCREMENT,
|
|
`username` varchar(50) DEFAULT NULL,
|
|
`password` varchar(50) DEFAULT NULL,
|
|
`type` varchar(30) DEFAULT NULL,
|
|
`img` varchar(50) DEFAULT NULL,
|
|
`sex` varchar(10) DEFAULT NULL,
|
|
`begintime` varchar(50) DEFAULT NULL,
|
|
`desc1` varchar(200) DEFAULT NULL,
|
|
`tname` varchar(10) DEFAULT NULL,
|
|
`tel` varchar(50) DEFAULT NULL,
|
|
PRIMARY KEY (`id`)
|
|
) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=18 ;
|
|
|
|
--
|
|
-- 转存表中的数据 `admin`
|
|
--
|
|
|
|
INSERT INTO `admin` (`id`, `username`, `password`, `type`, `img`, `sex`, `begintime`, `desc1`, `tname`, `tel`) VALUES
|
|
(1, 'admin', '21232f297a57a5a743894a0e4a801fc3', '超级管理员', '0', NULL, NULL, NULL, NULL, NULL);
|
|
|
|
-- --------------------------------------------------------
|
|
|
|
--
|
|
-- 表的结构 `baoxiu`
|
|
--
|
|
|
|
CREATE TABLE IF NOT EXISTS `baoxiu` (
|
|
`id` int(11) NOT NULL AUTO_INCREMENT,
|
|
`carsid` int(11) DEFAULT '0' COMMENT '车辆id',
|
|
`content` varchar(250) DEFAULT NULL COMMENT '详细',
|
|
`addtime` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
|
|
`status` varchar(10) DEFAULT '维修中' COMMENT '状态',
|
|
`eacherid` int(11) DEFAULT '0' COMMENT '人员id',
|
|
PRIMARY KEY (`id`)
|
|
) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=18 ;
|
|
|
|
-- --------------------------------------------------------
|
|
|
|
--
|
|
-- 表的结构 `cars`
|
|
--
|
|
|
|
CREATE TABLE IF NOT EXISTS `cars` (
|
|
`id` int(11) NOT NULL AUTO_INCREMENT,
|
|
`categoryid` int(11) DEFAULT '0' COMMENT '品牌',
|
|
`colors` varchar(50) DEFAULT NULL COMMENT '颜色',
|
|
`title` varchar(50) DEFAULT NULL COMMENT '车牌号',
|
|
`img` varchar(50) DEFAULT NULL,
|
|
`ages` varchar(11) DEFAULT NULL COMMENT '车龄',
|
|
`lat` varchar(255) NOT NULL,
|
|
`lng` varchar(255) NOT NULL,
|
|
`status` varchar(10) DEFAULT NULL COMMENT '状态',
|
|
PRIMARY KEY (`id`)
|
|
) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=56 ;
|
|
|
|
-- --------------------------------------------------------
|
|
|
|
--
|
|
-- 表的结构 `category`
|
|
--
|
|
|
|
CREATE TABLE IF NOT EXISTS `category` (
|
|
`id` int(6) NOT NULL AUTO_INCREMENT COMMENT 'id自然编号',
|
|
`title` varchar(60) NOT NULL COMMENT '名称',
|
|
PRIMARY KEY (`id`)
|
|
) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=11 ;
|
|
|
|
--
|
|
-- 转存表中的数据 `category`
|
|
--
|
|
|
|
INSERT INTO `category` (`id`, `title`) VALUES
|
|
(8, '出行'),
|
|
(7, 'hellobike'),
|
|
(6, 'ofo'),
|
|
(5, 'mobike'),
|
|
(9, '小蓝'),
|
|
(10, '123');
|
|
|
|
-- --------------------------------------------------------
|
|
|
|
--
|
|
-- 表的结构 `eacher`
|
|
--
|
|
|
|
CREATE TABLE IF NOT EXISTS `eacher` (
|
|
`id` int(4) NOT NULL AUTO_INCREMENT,
|
|
`username` varchar(50) DEFAULT NULL,
|
|
`password` varchar(50) DEFAULT NULL,
|
|
`img` varchar(50) DEFAULT NULL,
|
|
`sex` varchar(10) DEFAULT NULL,
|
|
`begintime` varchar(50) DEFAULT NULL,
|
|
`desc1` varchar(200) DEFAULT NULL,
|
|
`tname` varchar(10) DEFAULT NULL,
|
|
`tel` varchar(50) DEFAULT NULL,
|
|
PRIMARY KEY (`id`)
|
|
) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=10 ;
|
|
|
|
--
|
|
-- 转存表中的数据 `eacher`
|
|
--
|
|
|
|
INSERT INTO `eacher` (`id`, `username`, `password`, `img`, `sex`, `begintime`, `desc1`, `tname`, `tel`) VALUES
|
|
(8, '111222', '00b7691d86d96aebd21dd9e138f90840', '1756066.png', '男', '2000-10-09', '123', '王师傅2', '13325652145');
|
|
|
|
-- --------------------------------------------------------
|
|
|
|
--
|
|
-- 表的结构 `orders`
|
|
--
|
|
|
|
CREATE TABLE IF NOT EXISTS `orders` (
|
|
`id` int(11) NOT NULL AUTO_INCREMENT,
|
|
`studentid` varchar(50) DEFAULT '0' COMMENT '学生id',
|
|
`carsid` int(11) DEFAULT '0' COMMENT '车辆id',
|
|
`price` decimal(11,0) DEFAULT '0' COMMENT '预计价格',
|
|
`begintime` date DEFAULT NULL COMMENT '开始时间',
|
|
`endtime` date DEFAULT NULL COMMENT '结束时间',
|
|
`addtime` timestamp NULL DEFAULT CURRENT_TIMESTAMP COMMENT '添加时间',
|
|
`status` varchar(50) DEFAULT NULL,
|
|
`carstitle` varchar(50) DEFAULT NULL COMMENT '车牌号',
|
|
PRIMARY KEY (`id`)
|
|
) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=28 ;
|
|
|
|
-- --------------------------------------------------------
|
|
|
|
--
|
|
-- 表的结构 `payorder`
|
|
--
|
|
|
|
CREATE TABLE IF NOT EXISTS `payorder` (
|
|
`id` int(11) NOT NULL AUTO_INCREMENT,
|
|
`orderid` text NOT NULL,
|
|
`uid` text NOT NULL,
|
|
`money` text NOT NULL,
|
|
`status` int(11) NOT NULL DEFAULT '0',
|
|
PRIMARY KEY (`id`)
|
|
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 AUTO_INCREMENT=27 ;
|
|
|
|
--
|
|
-- 转存表中的数据 `payorder`
|
|
--
|
|
|
|
INSERT INTO `payorder` (`id`, `orderid`, `uid`, `money`, `status`) VALUES
|
|
(26, '2025041002282963899', '18', '300', 1);
|
|
|
|
-- --------------------------------------------------------
|
|
|
|
--
|
|
-- 表的结构 `user`
|
|
--
|
|
|
|
CREATE TABLE IF NOT EXISTS `user` (
|
|
`id` smallint(5) unsigned NOT NULL AUTO_INCREMENT,
|
|
`studentid` varchar(64) NOT NULL COMMENT '学号',
|
|
`stuname` varchar(50) NOT NULL COMMENT '姓名',
|
|
`password` char(32) NOT NULL COMMENT '密码',
|
|
`banji` varchar(50) DEFAULT NULL COMMENT '班级',
|
|
`addtime` timestamp NULL DEFAULT CURRENT_TIMESTAMP COMMENT '注册时间',
|
|
`img` varchar(255) DEFAULT NULL COMMENT '头像',
|
|
`sex` varchar(255) DEFAULT NULL COMMENT '性别',
|
|
`status` int(2) NOT NULL DEFAULT '0' COMMENT '状态',
|
|
`tel` varchar(50) DEFAULT NULL COMMENT '电话',
|
|
PRIMARY KEY (`id`),
|
|
UNIQUE KEY `account` (`studentid`)
|
|
) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=19 ;
|
|
|
|
--
|
|
-- 转存表中的数据 `user`
|
|
--
|
|
|
|
INSERT INTO `user` (`id`, `studentid`, `stuname`, `password`, `banji`, `addtime`, `img`, `sex`, `status`, `tel`) VALUES
|
|
(18, '20221109', '张三', 'c812a07d304cedbaceb66144428d6c7a', '网络工程2班', '2022-11-09 05:35:31', '2516853.png', '男', 0, '13325652145');
|
|
|
|
-- --------------------------------------------------------
|
|
|
|
--
|
|
-- 表的结构 `yajin`
|
|
--
|
|
|
|
CREATE TABLE IF NOT EXISTS `yajin` (
|
|
`id` int(11) NOT NULL AUTO_INCREMENT,
|
|
`userid` int(11) DEFAULT '0' COMMENT '学生id',
|
|
`price` decimal(11,0) NOT NULL DEFAULT '0' COMMENT '金额',
|
|
`addtime` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '时间',
|
|
PRIMARY KEY (`id`)
|
|
) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=10 ;
|
|
|
|
--
|
|
-- 转存表中的数据 `yajin`
|
|
--
|
|
|
|
INSERT INTO `yajin` (`id`, `userid`, `price`, `addtime`) VALUES
|
|
(9, 18, '300', '2025-04-09 18:29:03');
|
|
|
|
/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
|
|
/*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */;
|
|
/*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;
|