143 lines
6.4 KiB
SQL
143 lines
6.4 KiB
SQL
/*
|
|
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;
|