/*
 Navicat Premium Data Transfer

 Source Server         : 110.41.47.6
 Source Server Type    : MySQL
 Source Server Version : 50734
 Source Host           : 110.41.47.6:3306
 Source Schema         : day_08_06

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

 Date: 06/08/2024 15:32:52
*/

SET NAMES utf8mb4;
SET FOREIGN_KEY_CHECKS = 0;

-- ----------------------------
-- Table structure for admin
-- ----------------------------
DROP TABLE IF EXISTS `admin`;
CREATE TABLE `admin`  (
  `admin_id` int(11) NOT NULL AUTO_INCREMENT,
  `admin_name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL,
  `admin_pwd` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL,
  `admin_phone` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL,
  `admin_email` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL,
  PRIMARY KEY (`admin_id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 3 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci ROW_FORMAT = Dynamic;

-- ----------------------------
-- Records of admin
-- ----------------------------
INSERT INTO `admin` VALUES (1, '张三', '123', '18833078187', '1735378243@qq.com');
INSERT INTO `admin` VALUES (2, '李四', '321', '18833078182', '1735378243@qq.com');

-- ----------------------------
-- Table structure for apply
-- ----------------------------
DROP TABLE IF EXISTS `apply`;
CREATE TABLE `apply`  (
  `apply_id` int(11) NOT NULL AUTO_INCREMENT,
  `apply_name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL,
  `apply_names` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL,
  `apply_phone` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL,
  `apply_type_id` int(11) NULL DEFAULT NULL,
  `apply_privce` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL,
  `apply_date` datetime NULL DEFAULT NULL,
  `apply_static` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL,
  PRIMARY KEY (`apply_id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 9 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci ROW_FORMAT = Dynamic;

-- ----------------------------
-- Records of apply
-- ----------------------------
INSERT INTO `apply` VALUES (6, '高级产品经理', '张三', '18833078187', 2, '20k~35k', '2024-08-06 06:09:22', '2');
INSERT INTO `apply` VALUES (7, '高级产品经理', '张三', '18833078187', 2, '20k~35k', '2024-08-06 07:09:15', '1');
INSERT INTO `apply` VALUES (8, '高级产品经理', '张三', '18833078187', 3, '20k~35k', '2024-08-06 07:29:09', '2');

-- ----------------------------
-- Table structure for boogs
-- ----------------------------
DROP TABLE IF EXISTS `boogs`;
CREATE TABLE `boogs`  (
  `boogs_id` int(11) NOT NULL AUTO_INCREMENT,
  `boogs_name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL,
  `boogs_text` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL,
  `boogs_picer` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL,
  `boogs_type` int(255) NULL DEFAULT NULL,
  `boogs_date` datetime NULL DEFAULT NULL,
  `boogs_count` int(255) NULL DEFAULT NULL,
  `boogs_static` int(11) NULL DEFAULT 0,
  PRIMARY KEY (`boogs_id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 8 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci ROW_FORMAT = Dynamic;

-- ----------------------------
-- Records of boogs
-- ----------------------------
INSERT INTO `boogs` VALUES (1, '高级产品经理', '五哦i国标舞不过', '20k~35k', 1, '2024-08-02 00:00:00', 0, 1);
INSERT INTO `boogs` VALUES (2, 'JAVA开发工程师', '五哦i国标舞不过', '20k~35k', 1, '2002-01-01 00:00:00', 0, 1);
INSERT INTO `boogs` VALUES (3, '高级产品经理', '五哦i国标舞不过', '10k~20k', 1, '2002-01-01 00:00:00', 0, 1);
INSERT INTO `boogs` VALUES (4, '高级产品经理', '五哦i国标舞不过', '20k~35k', 2, '2024-08-02 00:00:00', 1, 0);
INSERT INTO `boogs` VALUES (5, '高级产品经理', '五哦i国标舞不过', '20k~35k', 2, '2024-08-02 00:00:00', 1, 0);
INSERT INTO `boogs` VALUES (6, '高级产品经理', '五哦i国标舞不过', '20k~35k', 2, '2024-08-02 00:00:00', 0, 0);
INSERT INTO `boogs` VALUES (7, '高级产品经理', '五哦i国标舞不过', '20k~35k', 3, '2024-08-05 00:00:00', 1, 0);

-- ----------------------------
-- Table structure for clazz
-- ----------------------------
DROP TABLE IF EXISTS `clazz`;
CREATE TABLE `clazz`  (
  `clazz_id` int(11) NOT NULL AUTO_INCREMENT,
  `clazz_name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL,
  PRIMARY KEY (`clazz_id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 4 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci ROW_FORMAT = Dynamic;

-- ----------------------------
-- Records of clazz
-- ----------------------------
INSERT INTO `clazz` VALUES (1, '产品经理');
INSERT INTO `clazz` VALUES (2, '项目经理');
INSERT INTO `clazz` VALUES (3, 'JAVA开发');

-- ----------------------------
-- Table structure for type
-- ----------------------------
DROP TABLE IF EXISTS `type`;
CREATE TABLE `type`  (
  `type_id` int(11) NOT NULL AUTO_INCREMENT,
  `type_name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL,
  PRIMARY KEY (`type_id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 4 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci ROW_FORMAT = Dynamic;

-- ----------------------------
-- Records of type
-- ----------------------------
INSERT INTO `type` VALUES (1, '东方邯郸远');
INSERT INTO `type` VALUES (2, '拼多多');
INSERT INTO `type` VALUES (3, '艾琳啊啊');

-- ----------------------------
-- Table structure for zhong
-- ----------------------------
DROP TABLE IF EXISTS `zhong`;
CREATE TABLE `zhong`  (
  `zhong_id` int(11) NOT NULL AUTO_INCREMENT,
  `apply_id` int(11) NULL DEFAULT NULL,
  `boogs_id` int(11) NULL DEFAULT NULL,
  `admin_id` int(11) NULL DEFAULT NULL,
  PRIMARY KEY (`zhong_id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 9 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci ROW_FORMAT = Dynamic;

-- ----------------------------
-- Records of zhong
-- ----------------------------
INSERT INTO `zhong` VALUES (6, 6, 4, 1);
INSERT INTO `zhong` VALUES (7, 7, 5, 1);
INSERT INTO `zhong` VALUES (8, 8, 7, 1);

SET FOREIGN_KEY_CHECKS = 1;
