/*
 Navicat Premium Data Transfer

 Source Server         : localhost_3306
 Source Server Type    : MySQL
 Source Server Version : 80022
 Source Host           : localhost:3306
 Source Schema         : drug_system

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

 Date: 25/03/2022 19:55:21
*/

SET NAMES utf8mb4;
SET FOREIGN_KEY_CHECKS = 0;

-- ----------------------------
-- Table structure for book
-- ----------------------------
DROP TABLE IF EXISTS `book`;
CREATE TABLE `book`  (
  `id` int NOT NULL AUTO_INCREMENT,
  `name` varchar(20) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
  `number` int NULL DEFAULT NULL,
  `createtime` timestamp NULL DEFAULT NULL,
  `status` varchar(20) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
  `supplier` varchar(20) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
  `phone` varchar(20) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
  PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = Dynamic;

-- ----------------------------
-- Records of book
-- ----------------------------
INSERT INTO `book` VALUES (2, '999感冒灵', 10, '2022-03-25 17:07:56', '不能进货', 'C', '15896545625');
INSERT INTO `book` VALUES (5, '止咳糖浆', 20, '2022-03-25 19:37:47', '已经进货成功', 'F', '15698568456');
INSERT INTO `book` VALUES (6, '珍视明眼药水', 4, '2022-03-25 19:51:18', '已经进货成功', 'D', '15698568787');
INSERT INTO `book` VALUES (7, '急支糖浆', 20, '2022-03-25 19:52:04', '已经进货成功', 'B', '18545698525');
INSERT INTO `book` VALUES (8, '维生素A', 15, '2022-03-25 19:52:22', '待审批', 'B', '18545698525');

-- ----------------------------
-- Table structure for drug
-- ----------------------------
DROP TABLE IF EXISTS `drug`;
CREATE TABLE `drug`  (
  `id` int NOT NULL AUTO_INCREMENT,
  `name` varchar(20) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
  `number` int NULL DEFAULT NULL,
  `status` varchar(10) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
  `acc_sold` int NULL DEFAULT NULL,
  `price` float NULL DEFAULT NULL,
  `content` varchar(20) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
  `supplierid` int NULL DEFAULT NULL,
  PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 20 CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = Dynamic;

-- ----------------------------
-- Records of drug
-- ----------------------------
INSERT INTO `drug` VALUES (1, '999感冒灵', 107, '正常', 1003, 20, '治感冒', 7);
INSERT INTO `drug` VALUES (2, '健胃消食片', 87, '正常', 5213, 17, '助消化', 8);
INSERT INTO `drug` VALUES (3, '退烧灵', 48, '正常', 742, 32, '退烧', 11);
INSERT INTO `drug` VALUES (4, '珍视明眼药水', 60, '正常', 1429, 15.2, '缓解眼疲劳', 8);
INSERT INTO `drug` VALUES (14, '急支糖浆', 65, '正常', 20, 23.6, '清肺，润嗓', 6);
INSERT INTO `drug` VALUES (15, '维生素B', 16, '正常', 4, 3.5, '补充维生素', 6);
INSERT INTO `drug` VALUES (20, '止咳糖浆', 47, '正常', 0, 25.8, '止咳化痰', 9);
INSERT INTO `drug` VALUES (21, '维生素A', 40, '正常', 0, 2.7, '补充维生素', 6);
INSERT INTO `drug` VALUES (22, '维生素C', 0, '正常', 0, 5.7, '补充维生素', 9);
INSERT INTO `drug` VALUES (23, '清热口服液', 0, '正常', 0, 56, '治疗热感冒', 6);
INSERT INTO `drug` VALUES (24, '病毒口服液', 21, '正常', 0, 45, '治感冒', 7);
INSERT INTO `drug` VALUES (25, '小葵花口服液', 15, '正常', 0, 25, '小儿感冒', 9);
INSERT INTO `drug` VALUES (26, '阿达帕宁', 26, '正常', 0, 15, '皮肤病', 6);

-- ----------------------------
-- Table structure for supplier
-- ----------------------------
DROP TABLE IF EXISTS `supplier`;
CREATE TABLE `supplier`  (
  `id` int NOT NULL AUTO_INCREMENT,
  `name` varchar(20) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
  `regtime` timestamp NULL DEFAULT NULL,
  `phone` varchar(20) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
  `location` varchar(20) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
  PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 15 CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = Dynamic;

-- ----------------------------
-- Records of supplier
-- ----------------------------
INSERT INTO `supplier` VALUES (6, 'B', '2022-03-21 21:50:20', '18545698525', '杭州');
INSERT INTO `supplier` VALUES (7, 'C', '2022-03-21 21:53:06', '15896545625', '广州');
INSERT INTO `supplier` VALUES (8, 'D', '2022-03-21 21:53:58', '15698568787', '北京');
INSERT INTO `supplier` VALUES (9, 'F', '2022-03-21 21:54:20', '15698568456', '北京');
INSERT INTO `supplier` VALUES (11, 'E', '2022-03-21 21:56:15', '18236895474', '苏州');

-- ----------------------------
-- Table structure for t_user
-- ----------------------------
DROP TABLE IF EXISTS `t_user`;
CREATE TABLE `t_user`  (
  `id` int NOT NULL AUTO_INCREMENT,
  `name` varchar(40) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
  `password` varchar(40) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
  `status` varchar(10) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
  `role` varchar(10) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
  `regtime` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 46 CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = Dynamic;

-- ----------------------------
-- Records of t_user
-- ----------------------------
INSERT INTO `t_user` VALUES (16, '张三', '202cb962ac59075b964b07152d234b70', '激活', 'user', '2022-03-18 22:46:15');
INSERT INTO `t_user` VALUES (17, '张四', '202cb962ac59075b964b07152d234b70', '激活', 'user', '2022-03-18 22:46:50');
INSERT INTO `t_user` VALUES (18, '张五', '202cb962ac59075b964b07152d234b70', '激活', 'user', '2022-03-18 22:47:17');
INSERT INTO `t_user` VALUES (19, '我是管理员', '202cb962ac59075b964b07152d234b70', '激活', 'admin', '2022-03-18 22:47:37');

SET FOREIGN_KEY_CHECKS = 1;