/*
 Navicat Premium Data Transfer

 Source Server         : local-mysql
 Source Server Type    : MySQL
 Source Server Version : 80011
 Source Host           : localhost:3306
 Source Schema         : deliverytakingsystem

 Target Server Type    : MySQL
 Target Server Version : 80011
 File Encoding         : 65001

 Date: 12/03/2022 12:42:55
*/

SET NAMES utf8mb4;
SET FOREIGN_KEY_CHECKS = 0;

-- ----------------------------
-- Table structure for order
-- ----------------------------
DROP TABLE IF EXISTS `order`;
CREATE TABLE `order`  (
                          `id` int(11) NOT NULL AUTO_INCREMENT,
                          `description` text CHARACTER SET utf8 COLLATE utf8_general_ci NULL COMMENT '基本描述',
                          `when` datetime NULL DEFAULT NULL COMMENT '目的送达时间',
                          `location` text CHARACTER SET utf8 COLLATE utf8_general_ci NULL COMMENT '目的送达位置',
                          `sender_id` int(11) NULL DEFAULT NULL COMMENT '派单人',
                          `receiver_id` int(11) NULL DEFAULT NULL COMMENT '收单人',
                          `price` decimal(10, 2) NULL DEFAULT 0.00 COMMENT '价格',
                          `status` varchar(20) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '状态',
                          `comment` text CHARACTER SET utf8 COLLATE utf8_general_ci NULL COMMENT '备注',
                          `create_time` datetime NULL DEFAULT NULL COMMENT '创建时间',
                          PRIMARY KEY (`id`) USING BTREE,
                          INDEX `k_sender_id`(`sender_id`) USING BTREE
) ENGINE = InnoDB CHARACTER SET = utf8 COLLATE = utf8_general_ci COMMENT = '订单表' ROW_FORMAT = Dynamic;

-- ----------------------------
-- Records of order
-- ----------------------------
INSERT INTO `order` VALUES (1, '订单1', '2020-12-10 00:00:00', '中北校区，河西食堂后面', 5, NULL, 10.00, '已接单', '加油！奥力给', '2020-12-10 10:30:30');
INSERT INTO `order` VALUES (2, '订单2', '2020-12-11 00:00:00', '中北校区，河西食堂后面', 5, NULL, 60.00, '已接单', '加油！奥力给', '2020-12-10 10:30:30');
INSERT INTO `order` VALUES (3, '订单3', '2020-12-12 00:00:00', '中北校区，河西食堂后面', 5, NULL, 80.00, '已接单', '加油！奥力给', '2020-12-10 10:30:30');
INSERT INTO `order` VALUES (4, '订单4', '2020-12-13 00:00:00', '中北校区，河西食堂后面', 5, NULL, 10.00, '未接单', '加油！奥力给', '2020-12-10 10:30:30');
INSERT INTO `order` VALUES (5, '订单5', '2020-12-14 00:00:00', '中北校区，河西食堂后面', 5, NULL, 60.00, '未接单', '加油！奥力给', '2020-12-10 10:30:30');
INSERT INTO `order` VALUES (6, '订单6', '2020-12-15 00:00:00', '中北校区，河西食堂后面', 5, NULL, 60.00, '未接单', '加油！奥力给', '2020-12-10 10:30:30');

-- ----------------------------
-- Table structure for user
-- ----------------------------
DROP TABLE IF EXISTS `user`;
CREATE TABLE `user`  (
                         `id` int(11) NOT NULL AUTO_INCREMENT,
                         `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 '密码',
                         `phone` varchar(11) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '手机号',
                         `asset` decimal(10, 2) NULL DEFAULT 0.00 COMMENT '余额',
                         PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB CHARACTER SET = utf8 COLLATE = utf8_general_ci COMMENT = '用户表' ROW_FORMAT = Dynamic;

-- ----------------------------
-- Records of user
-- ----------------------------
INSERT INTO `user` VALUES (5, 'betaberry', '100299', '110', 100.00);

SET FOREIGN_KEY_CHECKS = 1;