p8m5ekjfr
/
Dormitory
1
0
Fork 0
Code Issues Pull Requests Packages Projects Releases Wiki Activity
You can not select more than 25 topics Topics must start with a letter or number, can include dashes ('-') and can be up to 35 characters long.
Branches Tags
${ item.name }
Create tag ${ searchTerm }
Create branch ${ searchTerm }
from 'main'
${ noResults }
Dormitory/t100.sql

813 lines
76 KiB
Raw Permalink Blame History

/*
Navicat Premium Dump SQL
Source Server : localhost_3306
Source Server Type : MySQL
Source Server Version : 80040 (8.0.40)
Source Host : localhost:3306
Source Schema : t100
Target Server Type : MySQL
Target Server Version : 80040 (8.0.40)
File Encoding : 65001
Date: 29/12/2024 18:24:50
*/
SET NAMES utf8mb4;
SET FOREIGN_KEY_CHECKS = 0;
-- ----------------------------
-- Table structure for banji
-- ----------------------------
DROP TABLE IF EXISTS `banji`;
CREATE TABLE `banji` (
`id` bigint NOT NULL AUTO_INCREMENT COMMENT '主键',
`addtime` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
`banji` varchar(200) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NOT NULL COMMENT '班级',
PRIMARY KEY (`id`) USING BTREE,
UNIQUE INDEX `banji`(`banji` ASC) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 21 CHARACTER SET = utf8mb3 COLLATE = utf8mb3_general_ci COMMENT = '班级' ROW_FORMAT = Dynamic;
-- ----------------------------
-- Records of banji
-- ----------------------------
INSERT INTO `banji` VALUES (11, '2025-01-01 16:20:00', '班级1');
INSERT INTO `banji` VALUES (12, '2025-01-01 16:20:00', '班级2');
INSERT INTO `banji` VALUES (13, '2025-01-01 16:20:00', '班级3');
INSERT INTO `banji` VALUES (14, '2025-01-01 16:20:00', '班级4');
INSERT INTO `banji` VALUES (15, '2025-01-01 16:20:00', '班级5');
INSERT INTO `banji` VALUES (16, '2025-01-01 16:20:00', '班级6');
INSERT INTO `banji` VALUES (17, '2025-01-01 16:20:00', '班级7');
INSERT INTO `banji` VALUES (18, '2025-01-01 16:20:00', '班级8');
INSERT INTO `banji` VALUES (19, '2025-01-01 16:20:00', '班级9');
INSERT INTO `banji` VALUES (20, '2025-01-01 16:20:00', '班级10');
-- ----------------------------
-- Table structure for baoxiuchuli
-- ----------------------------
DROP TABLE IF EXISTS `baoxiuchuli`;
CREATE TABLE `baoxiuchuli` (
`id` bigint NOT NULL AUTO_INCREMENT COMMENT '主键',
`addtime` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
`baoxiushebei` varchar(200) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NULL DEFAULT NULL COMMENT '报修设备',
`leixing` varchar(200) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NULL DEFAULT NULL COMMENT '类型',
`baoxiuriqi` varchar(200) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NULL DEFAULT NULL COMMENT '报修日期',
`weixiufankui` varchar(200) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NULL DEFAULT NULL COMMENT '维修反馈',
`weixiujindu` varchar(200) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NULL DEFAULT NULL COMMENT '维修进度',
`gengxinriqi` datetime NULL DEFAULT NULL COMMENT '更新日期',
`xuehao` varchar(200) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NULL DEFAULT NULL COMMENT '学号',
`xueshengxingming` varchar(200) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NULL DEFAULT NULL COMMENT '学生姓名',
`sushehao` varchar(200) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NULL DEFAULT NULL COMMENT '宿舍号',
`banji` varchar(200) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NULL DEFAULT NULL COMMENT '班级',
`weixiugonghao` varchar(200) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NULL DEFAULT NULL COMMENT '维修工号',
`xingming` varchar(200) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NULL DEFAULT NULL COMMENT '姓名',
`lianxidianhua` varchar(200) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NULL DEFAULT NULL COMMENT '联系电话',
PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 91 CHARACTER SET = utf8mb3 COLLATE = utf8mb3_general_ci COMMENT = '报修处理' ROW_FORMAT = Dynamic;
-- ----------------------------
-- Records of baoxiuchuli
-- ----------------------------
INSERT INTO `baoxiuchuli` VALUES (81, '2025-01-01 16:20:00', '报修设备1', '类型1', '2025-01-01', '维修反馈1', '维修中', '2025-01-01 16:20:00', '学号1', '学生姓名1', '宿舍号1', '班级1', '维修工号1', '姓名1', '联系电话1');
INSERT INTO `baoxiuchuli` VALUES (82, '2025-01-01 16:20:00', '报修设备2', '类型2', '2025-01-01', '维修反馈2', '维修中', '2025-01-01 16:20:00', '学号2', '学生姓名2', '宿舍号2', '班级2', '维修工号2', '姓名2', '联系电话2');
INSERT INTO `baoxiuchuli` VALUES (83, '2025-01-01 16:20:00', '报修设备3', '类型3', '2025-01-01', '维修反馈3', '维修中', '2025-01-01 16:20:00', '学号3', '学生姓名3', '宿舍号3', '班级3', '维修工号3', '姓名3', '联系电话3');
INSERT INTO `baoxiuchuli` VALUES (84, '2025-01-01 16:20:00', '报修设备4', '类型4', '2025-01-01', '维修反馈4', '维修中', '2025-01-01 16:20:00', '学号4', '学生姓名4', '宿舍号4', '班级4', '维修工号4', '姓名4', '联系电话4');
INSERT INTO `baoxiuchuli` VALUES (85, '2025-01-01 16:20:00', '报修设备5', '类型5', '2025-01-01', '维修反馈5', '维修中', '2025-01-01 16:20:00', '学号5', '学生姓名5', '宿舍号5', '班级5', '维修工号5', '姓名5', '联系电话5');
INSERT INTO `baoxiuchuli` VALUES (86, '2025-01-01 16:20:00', '报修设备6', '类型6', '2025-01-01', '维修反馈6', '维修中', '2025-01-01 16:20:00', '学号6', '学生姓名6', '宿舍号6', '班级6', '维修工号6', '姓名6', '联系电话6');
INSERT INTO `baoxiuchuli` VALUES (87, '2025-01-01 16:20:00', '报修设备7', '类型7', '2025-01-01', '维修反馈7', '维修中', '2025-01-01 16:20:00', '学号7', '学生姓名7', '宿舍号7', '班级7', '维修工号7', '姓名7', '联系电话7');
INSERT INTO `baoxiuchuli` VALUES (88, '2025-01-01 16:20:00', '报修设备8', '类型8', '2025-01-01', '维修反馈8', '维修中', '2025-01-01 16:20:00', '学号8', '学生姓名8', '宿舍号8', '班级8', '维修工号8', '姓名8', '联系电话8');
INSERT INTO `baoxiuchuli` VALUES (89, '2025-01-01 16:20:00', '报修设备9', '类型9', '2025-01-01', '维修反馈9', '维修中', '2025-01-01 16:20:00', '学号9', '学生姓名9', '宿舍号9', '班级9', '维修工号9', '姓名9', '联系电话9');
INSERT INTO `baoxiuchuli` VALUES (90, '2025-01-01 16:20:00', '报修设备10', '类型10', '2025-01-01', '维修反馈10', '维修中', '2025-01-01 16:20:00', '学号10', '学生姓名10', '宿舍号10', '班级10', '维修工号10', '姓名10', '联系电话10');
-- ----------------------------
-- Table structure for baoxiuxinxi
-- ----------------------------
DROP TABLE IF EXISTS `baoxiuxinxi`;
CREATE TABLE `baoxiuxinxi` (
`id` bigint NOT NULL AUTO_INCREMENT COMMENT '主键',
`addtime` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
`baoxiushebei` varchar(200) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NOT NULL COMMENT '报修设备',
`leixing` varchar(200) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NOT NULL COMMENT '类型',
`tupian` varchar(200) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NULL DEFAULT NULL COMMENT '图片',
`baoxiuneirong` longtext CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NULL COMMENT '报修内容',
`baoxiuriqi` date NULL DEFAULT NULL COMMENT '报修日期',
`xuehao` varchar(200) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NULL DEFAULT NULL COMMENT '学号',
`xueshengxingming` varchar(200) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NULL DEFAULT NULL COMMENT '学生姓名',
`banji` varchar(200) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NULL DEFAULT NULL COMMENT '班级',
`sushehao` varchar(200) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NULL DEFAULT NULL COMMENT '宿舍号',
`shouji` varchar(200) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NULL DEFAULT NULL COMMENT '手机',
`sfsh` varchar(200) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NULL DEFAULT '否' COMMENT '是否审核',
`shhf` longtext CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NULL COMMENT '审核回复',
PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 81 CHARACTER SET = utf8mb3 COLLATE = utf8mb3_general_ci COMMENT = '报修信息' ROW_FORMAT = Dynamic;
-- ----------------------------
-- Records of baoxiuxinxi
-- ----------------------------
INSERT INTO `baoxiuxinxi` VALUES (71, '2025-01-01 16:20:00', '报修设备1', '水工', 'http://localhost:8080/springboot68ozj/upload/1735466830135.jpg', '报修内容1', '2025-01-01', '学号1', '学生姓名1', '班级1', '宿舍号1', '手机1', '是', '');
INSERT INTO `baoxiuxinxi` VALUES (72, '2025-01-01 16:20:00', '报修设备2', '水工', 'http://localhost:8080/springboot68ozj/upload/1735466830135.jpg', '报修内容2', '2025-01-01', '学号2', '学生姓名2', '班级2', '宿舍号2', '手机2', '是', '');
INSERT INTO `baoxiuxinxi` VALUES (73, '2025-01-01 16:20:00', '报修设备3', '水工', 'http://localhost:8080/springboot68ozj/upload/1735466830135.jpg', '报修内容3', '2025-01-01', '学号3', '学生姓名3', '班级3', '宿舍号3', '手机3', '是', '');
INSERT INTO `baoxiuxinxi` VALUES (74, '2025-01-01 16:20:00', '报修设备4', '水工', 'http://localhost:8080/springboot68ozj/upload/1735466830135.jpg', '报修内容4', '2025-01-01', '学号4', '学生姓名4', '班级4', '宿舍号4', '手机4', '是', '');
INSERT INTO `baoxiuxinxi` VALUES (75, '2025-01-01 16:20:00', '报修设备5', '水工', 'http://localhost:8080/springboot68ozj/upload/1735466830135.jpg', '报修内容5', '2025-01-01', '学号5', '学生姓名5', '班级5', '宿舍号5', '手机5', '是', '');
INSERT INTO `baoxiuxinxi` VALUES (76, '2025-01-01 16:20:00', '报修设备6', '水工', 'http://localhost:8080/springboot68ozj/upload/1735466830135.jpg', '报修内容6', '2025-01-01', '学号6', '学生姓名6', '班级6', '宿舍号6', '手机6', '是', '');
INSERT INTO `baoxiuxinxi` VALUES (77, '2025-01-01 16:20:00', '报修设备7', '水工', 'http://localhost:8080/springboot68ozj/upload/1735466830135.jpg', '报修内容7', '2025-01-01', '学号7', '学生姓名7', '班级7', '宿舍号7', '手机7', '是', '');
INSERT INTO `baoxiuxinxi` VALUES (78, '2025-01-01 16:20:00', '报修设备8', '水工', 'http://localhost:8080/springboot68ozj/upload/1735466830135.jpg', '报修内容8', '2025-01-01', '学号8', '学生姓名8', '班级8', '宿舍号8', '手机8', '是', '');
INSERT INTO `baoxiuxinxi` VALUES (79, '2025-01-01 16:20:00', '报修设备9', '水工', 'http://localhost:8080/springboot68ozj/upload/1735466830135.jpg', '报修内容9', '2025-01-01', '学号9', '学生姓名9', '班级9', '宿舍号9', '手机9', '是', '');
INSERT INTO `baoxiuxinxi` VALUES (80, '2025-01-01 16:20:00', '报修设备10', '水工', 'http://localhost:8080/springboot68ozj/upload/1735466830135.jpg', '报修内容10', '2025-01-01', '学号10', '学生姓名10', '班级10', '宿舍号10', '手机10', '是', '');
-- ----------------------------
-- Table structure for config
-- ----------------------------
DROP TABLE IF EXISTS `config`;
CREATE TABLE `config` (
`id` bigint NOT NULL AUTO_INCREMENT COMMENT '主键',
`name` varchar(100) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NOT NULL COMMENT '配置参数名称',
`value` varchar(100) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NULL DEFAULT NULL COMMENT '配置参数值',
PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 7 CHARACTER SET = utf8mb3 COLLATE = utf8mb3_general_ci COMMENT = '配置文件' ROW_FORMAT = Dynamic;
-- ----------------------------
-- Records of config
-- ----------------------------
INSERT INTO `config` VALUES (1, 'picture1', 'http://localhost:8080/springboot68ozj/upload/1735467731837.jpg');
INSERT INTO `config` VALUES (2, 'picture2', 'http://localhost:8080/springboot68ozj/upload/1735467765132.jpg');
INSERT INTO `config` VALUES (3, 'picture3', 'http://localhost:8080/springboot68ozj/upload/1735467775814.jpg');
-- ----------------------------
-- Table structure for discussshiwuxinxi
-- ----------------------------
DROP TABLE IF EXISTS `discussshiwuxinxi`;
CREATE TABLE `discussshiwuxinxi` (
`id` bigint NOT NULL AUTO_INCREMENT COMMENT '主键',
`addtime` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
`refid` bigint NOT NULL COMMENT '关联表id',
`userid` bigint NOT NULL COMMENT '用户id',
`nickname` varchar(200) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NULL DEFAULT NULL COMMENT '用户名',
`content` longtext CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NOT NULL COMMENT '评论内容',
`reply` longtext CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NULL COMMENT '回复内容',
PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 231 CHARACTER SET = utf8mb3 COLLATE = utf8mb3_general_ci COMMENT = '失物信息评论表' ROW_FORMAT = Dynamic;
-- ----------------------------
-- Records of discussshiwuxinxi
-- ----------------------------
INSERT INTO `discussshiwuxinxi` VALUES (221, '2025-01-01 16:20:00', 1, 1, '用户名1', '评论内容1', '回复内容1');
INSERT INTO `discussshiwuxinxi` VALUES (222, '2025-01-01 16:20:00', 2, 2, '用户名2', '评论内容2', '回复内容2');
INSERT INTO `discussshiwuxinxi` VALUES (223, '2025-01-01 16:20:00', 3, 3, '用户名3', '评论内容3', '回复内容3');
INSERT INTO `discussshiwuxinxi` VALUES (224, '2025-01-01 16:20:00', 4, 4, '用户名4', '评论内容4', '回复内容4');
INSERT INTO `discussshiwuxinxi` VALUES (225, '2025-01-01 16:20:00', 5, 5, '用户名5', '评论内容5', '回复内容5');
INSERT INTO `discussshiwuxinxi` VALUES (226, '2025-01-01 16:20:00', 6, 6, '用户名6', '评论内容6', '回复内容6');
INSERT INTO `discussshiwuxinxi` VALUES (227, '2025-01-01 16:20:00', 7, 7, '用户名7', '评论内容7', '回复内容7');
INSERT INTO `discussshiwuxinxi` VALUES (228, '2025-01-01 16:20:00', 8, 8, '用户名8', '评论内容8', '回复内容8');
INSERT INTO `discussshiwuxinxi` VALUES (229, '2025-01-01 16:20:00', 9, 9, '用户名9', '评论内容9', '回复内容9');
INSERT INTO `discussshiwuxinxi` VALUES (230, '2025-01-01 16:20:00', 10, 10, '用户名10', '评论内容10', '回复内容10');
-- ----------------------------
-- Table structure for discusstongzhuangshui
-- ----------------------------
DROP TABLE IF EXISTS `discusstongzhuangshui`;
CREATE TABLE `discusstongzhuangshui` (
`id` bigint NOT NULL AUTO_INCREMENT COMMENT '主键',
`addtime` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
`refid` bigint NOT NULL COMMENT '关联表id',
`userid` bigint NOT NULL COMMENT '用户id',
`nickname` varchar(200) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NULL DEFAULT NULL COMMENT '用户名',
`content` longtext CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NOT NULL COMMENT '评论内容',
`reply` longtext CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NULL COMMENT '回复内容',
PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 221 CHARACTER SET = utf8mb3 COLLATE = utf8mb3_general_ci COMMENT = '桶装水评论表' ROW_FORMAT = Dynamic;
-- ----------------------------
-- Records of discusstongzhuangshui
-- ----------------------------
INSERT INTO `discusstongzhuangshui` VALUES (211, '2025-01-01 16:20:00', 1, 1, '用户名1', '评论内容1', '回复内容1');
INSERT INTO `discusstongzhuangshui` VALUES (212, '2025-01-01 16:20:00', 2, 2, '用户名2', '评论内容2', '回复内容2');
INSERT INTO `discusstongzhuangshui` VALUES (213, '2025-01-01 16:20:00', 3, 3, '用户名3', '评论内容3', '回复内容3');
INSERT INTO `discusstongzhuangshui` VALUES (214, '2025-01-01 16:20:00', 4, 4, '用户名4', '评论内容4', '回复内容4');
INSERT INTO `discusstongzhuangshui` VALUES (215, '2025-01-01 16:20:00', 5, 5, '用户名5', '评论内容5', '回复内容5');
INSERT INTO `discusstongzhuangshui` VALUES (216, '2025-01-01 16:20:00', 6, 6, '用户名6', '评论内容6', '回复内容6');
INSERT INTO `discusstongzhuangshui` VALUES (217, '2025-01-01 16:20:00', 7, 7, '用户名7', '评论内容7', '回复内容7');
INSERT INTO `discusstongzhuangshui` VALUES (218, '2025-01-01 16:20:00', 8, 8, '用户名8', '评论内容8', '回复内容8');
INSERT INTO `discusstongzhuangshui` VALUES (219, '2025-01-01 16:20:00', 9, 9, '用户名9', '评论内容9', '回复内容9');
INSERT INTO `discusstongzhuangshui` VALUES (220, '2025-01-01 16:20:00', 10, 10, '用户名10', '评论内容10', '回复内容10');
-- ----------------------------
-- Table structure for discusszhaolingxinxi
-- ----------------------------
DROP TABLE IF EXISTS `discusszhaolingxinxi`;
CREATE TABLE `discusszhaolingxinxi` (
`id` bigint NOT NULL AUTO_INCREMENT COMMENT '主键',
`addtime` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
`refid` bigint NOT NULL COMMENT '关联表id',
`userid` bigint NOT NULL COMMENT '用户id',
`nickname` varchar(200) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NULL DEFAULT NULL COMMENT '用户名',
`content` longtext CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NOT NULL COMMENT '评论内容',
`reply` longtext CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NULL COMMENT '回复内容',
PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 241 CHARACTER SET = utf8mb3 COLLATE = utf8mb3_general_ci COMMENT = '招领信息评论表' ROW_FORMAT = Dynamic;
-- ----------------------------
-- Records of discusszhaolingxinxi
-- ----------------------------
INSERT INTO `discusszhaolingxinxi` VALUES (231, '2025-01-01 16:20:00', 1, 1, '用户名1', '评论内容1', '回复内容1');
INSERT INTO `discusszhaolingxinxi` VALUES (232, '2025-01-01 16:20:00', 2, 2, '用户名2', '评论内容2', '回复内容2');
INSERT INTO `discusszhaolingxinxi` VALUES (233, '2025-01-01 16:20:00', 3, 3, '用户名3', '评论内容3', '回复内容3');
INSERT INTO `discusszhaolingxinxi` VALUES (234, '2025-01-01 16:20:00', 4, 4, '用户名4', '评论内容4', '回复内容4');
INSERT INTO `discusszhaolingxinxi` VALUES (235, '2025-01-01 16:20:00', 5, 5, '用户名5', '评论内容5', '回复内容5');
INSERT INTO `discusszhaolingxinxi` VALUES (236, '2025-01-01 16:20:00', 6, 6, '用户名6', '评论内容6', '回复内容6');
INSERT INTO `discusszhaolingxinxi` VALUES (237, '2025-01-01 16:20:00', 7, 7, '用户名7', '评论内容7', '回复内容7');
INSERT INTO `discusszhaolingxinxi` VALUES (238, '2025-01-01 16:20:00', 8, 8, '用户名8', '评论内容8', '回复内容8');
INSERT INTO `discusszhaolingxinxi` VALUES (239, '2025-01-01 16:20:00', 9, 9, '用户名9', '评论内容9', '回复内容9');
INSERT INTO `discusszhaolingxinxi` VALUES (240, '2025-01-01 16:20:00', 10, 10, '用户名10', '评论内容10', '回复内容10');
-- ----------------------------
-- Table structure for jiaofeixinxi
-- ----------------------------
DROP TABLE IF EXISTS `jiaofeixinxi`;
CREATE TABLE `jiaofeixinxi` (
`id` bigint NOT NULL AUTO_INCREMENT COMMENT '主键',
`addtime` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
`xuehao` varchar(200) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NULL DEFAULT NULL COMMENT '学号',
`xueshengxingming` varchar(200) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NULL DEFAULT NULL COMMENT '学生姓名',
`banji` varchar(200) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NULL DEFAULT NULL COMMENT '班级',
`sushehao` varchar(200) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NULL DEFAULT NULL COMMENT '宿舍号',
`jiaofeimingcheng` varchar(200) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NOT NULL COMMENT '缴费名称',
`jiaofeileixing` varchar(200) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NOT NULL COMMENT '缴费类型',
`jiaofeijine` int NOT NULL COMMENT '缴费金额',
`dengjiriqi` date NULL DEFAULT NULL COMMENT '登记日期',
`ispay` varchar(200) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NULL DEFAULT '未支付' COMMENT '是否支付',
PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 131 CHARACTER SET = utf8mb3 COLLATE = utf8mb3_general_ci COMMENT = '缴费信息' ROW_FORMAT = Dynamic;
-- ----------------------------
-- Records of jiaofeixinxi
-- ----------------------------
INSERT INTO `jiaofeixinxi` VALUES (121, '2025-01-01 16:20:00', '学号1', '学生姓名1', '班级1', '宿舍号1', '缴费名称1', '水费', 1, '2025-01-01', '未支付');
INSERT INTO `jiaofeixinxi` VALUES (122, '2025-01-01 16:20:00', '学号2', '学生姓名2', '班级2', '宿舍号2', '缴费名称2', '水费', 2, '2025-01-01', '未支付');
INSERT INTO `jiaofeixinxi` VALUES (123, '2025-01-01 16:20:00', '学号3', '学生姓名3', '班级3', '宿舍号3', '缴费名称3', '水费', 3, '2025-01-01', '未支付');
INSERT INTO `jiaofeixinxi` VALUES (124, '2025-01-01 16:20:00', '学号4', '学生姓名4', '班级4', '宿舍号4', '缴费名称4', '水费', 4, '2025-01-01', '未支付');
INSERT INTO `jiaofeixinxi` VALUES (125, '2025-01-01 16:20:00', '学号5', '学生姓名5', '班级5', '宿舍号5', '缴费名称5', '水费', 5, '2025-01-01', '未支付');
INSERT INTO `jiaofeixinxi` VALUES (126, '2025-01-01 16:20:00', '学号6', '学生姓名6', '班级6', '宿舍号6', '缴费名称6', '水费', 6, '2025-01-01', '未支付');
INSERT INTO `jiaofeixinxi` VALUES (127, '2025-01-01 16:20:00', '学号7', '学生姓名7', '班级7', '宿舍号7', '缴费名称7', '水费', 7, '2025-01-01', '未支付');
INSERT INTO `jiaofeixinxi` VALUES (128, '2025-01-01 16:20:00', '学号8', '学生姓名8', '班级8', '宿舍号8', '缴费名称8', '水费', 8, '2025-01-01', '未支付');
INSERT INTO `jiaofeixinxi` VALUES (129, '2025-01-01 16:20:00', '学号9', '学生姓名9', '班级9', '宿舍号9', '缴费名称9', '水费', 9, '2025-01-01', '未支付');
INSERT INTO `jiaofeixinxi` VALUES (130, '2025-01-01 16:20:00', '学号10', '学生姓名10', '班级10', '宿舍号10', '缴费名称10', '水费', 10, '2025-01-01', '未支付');
-- ----------------------------
-- Table structure for jiaqiliusu
-- ----------------------------
DROP TABLE IF EXISTS `jiaqiliusu`;
CREATE TABLE `jiaqiliusu` (
`id` bigint NOT NULL AUTO_INCREMENT COMMENT '主键',
`addtime` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
`xuehao` varchar(200) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NULL DEFAULT NULL COMMENT '学号',
`xueshengxingming` varchar(200) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NULL DEFAULT NULL COMMENT '学生姓名',
`banji` varchar(200) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NULL DEFAULT NULL COMMENT '班级',
`sushehao` varchar(200) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NULL DEFAULT NULL COMMENT '宿舍号',
`liuxiaoliyou` longtext CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NULL COMMENT '留校理由',
`kaishiriqi` date NULL DEFAULT NULL COMMENT '开始日期',
`liuxiaotianshu` int NULL DEFAULT NULL COMMENT '留校天数',
`shenqingshijian` date NULL DEFAULT NULL COMMENT '申请时间',
`sfsh` varchar(200) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NULL DEFAULT '否' COMMENT '是否审核',
`shhf` longtext CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NULL COMMENT '审核回复',
PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 101 CHARACTER SET = utf8mb3 COLLATE = utf8mb3_general_ci COMMENT = '假期留宿' ROW_FORMAT = Dynamic;
-- ----------------------------
-- Records of jiaqiliusu
-- ----------------------------
INSERT INTO `jiaqiliusu` VALUES (91, '2025-01-01 16:20:00', '学号1', '学生姓名1', '班级1', '宿舍号1', '留校理由1', '2025-01-01', 1, '2025-01-01', '是', '');
INSERT INTO `jiaqiliusu` VALUES (92, '2025-01-01 16:20:00', '学号2', '学生姓名2', '班级2', '宿舍号2', '留校理由2', '2025-01-01', 2, '2025-01-01', '是', '');
INSERT INTO `jiaqiliusu` VALUES (93, '2025-01-01 16:20:00', '学号3', '学生姓名3', '班级3', '宿舍号3', '留校理由3', '2025-01-01', 3, '2025-01-01', '是', '');
INSERT INTO `jiaqiliusu` VALUES (94, '2025-01-01 16:20:00', '学号4', '学生姓名4', '班级4', '宿舍号4', '留校理由4', '2025-01-01', 4, '2025-01-01', '是', '');
INSERT INTO `jiaqiliusu` VALUES (95, '2025-01-01 16:20:00', '学号5', '学生姓名5', '班级5', '宿舍号5', '留校理由5', '2025-01-01', 5, '2025-01-01', '是', '');
INSERT INTO `jiaqiliusu` VALUES (96, '2025-01-01 16:20:00', '学号6', '学生姓名6', '班级6', '宿舍号6', '留校理由6', '2025-01-01', 6, '2025-01-01', '是', '');
INSERT INTO `jiaqiliusu` VALUES (97, '2025-01-01 16:20:00', '学号7', '学生姓名7', '班级7', '宿舍号7', '留校理由7', '2025-01-01', 7, '2025-01-01', '是', '');
INSERT INTO `jiaqiliusu` VALUES (98, '2025-01-01 16:20:00', '学号8', '学生姓名8', '班级8', '宿舍号8', '留校理由8', '2025-01-01', 8, '2025-01-01', '是', '');
INSERT INTO `jiaqiliusu` VALUES (99, '2025-01-01 16:20:00', '学号9', '学生姓名9', '班级9', '宿舍号9', '留校理由9', '2025-01-01', 9, '2025-01-01', '是', '');
INSERT INTO `jiaqiliusu` VALUES (100, '2025-01-01 16:20:00', '学号10', '学生姓名10', '班级10', '宿舍号10', '留校理由10', '2025-01-01', 10, '2025-01-01', '是', '');
-- ----------------------------
-- Table structure for news
-- ----------------------------
DROP TABLE IF EXISTS `news`;
CREATE TABLE `news` (
`id` bigint NOT NULL AUTO_INCREMENT COMMENT '主键',
`addtime` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
`title` varchar(200) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NOT NULL COMMENT '标题',
`introduction` longtext CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NULL COMMENT '简介',
`picture` varchar(200) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NOT NULL COMMENT '图片',
`content` longtext CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NOT NULL COMMENT '内容',
PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 211 CHARACTER SET = utf8mb3 COLLATE = utf8mb3_general_ci COMMENT = '宿舍公告' ROW_FORMAT = Dynamic;
-- ----------------------------
-- Records of news
-- ----------------------------
INSERT INTO `news` VALUES (201, '2025-01-01 16:20:00', '标题1', '简介1', 'http://localhost:8080/springboot68ozj/upload/1735466914390.jpg', '<p>内容1</p>');
INSERT INTO `news` VALUES (202, '2025-01-01 16:20:00', '标题2', '简介2', 'http://localhost:8080/springboot68ozj/upload/1735466914390.jpg', '内容2');
INSERT INTO `news` VALUES (203, '2025-01-01 16:20:00', '标题3', '简介3', 'http://localhost:8080/springboot68ozj/upload/1735466914390.jpg', '内容3');
INSERT INTO `news` VALUES (204, '2025-01-01 16:20:00', '标题4', '简介4', 'http://localhost:8080/springboot68ozj/upload/1735466914390.jpg', '内容4');
INSERT INTO `news` VALUES (205, '2025-01-01 16:20:00', '标题5', '简介5', 'http://localhost:8080/springboot68ozj/upload/1735466914390.jpg', '内容5');
INSERT INTO `news` VALUES (206, '2025-01-01 16:20:00', '标题6', '简介6', 'http://localhost:8080/springboot68ozj/upload/1735466914390.jpg', '内容6');
INSERT INTO `news` VALUES (207, '2025-01-01 16:20:00', '标题7', '简介7', 'http://localhost:8080/springboot68ozj/upload/1735466914390.jpg', '内容7');
INSERT INTO `news` VALUES (208, '2025-01-01 16:20:00', '标题8', '简介8', 'http://localhost:8080/springboot68ozj/upload/1735466914390.jpg', '内容8');
INSERT INTO `news` VALUES (209, '2025-01-01 16:20:00', '标题9', '简介9', 'http://localhost:8080/springboot68ozj/upload/1735466914390.jpg', '内容9');
INSERT INTO `news` VALUES (210, '2025-01-01 16:20:00', '标题10', '简介10', 'http://localhost:8080/springboot68ozj/upload/1735466914390.jpg', '内容10');
-- ----------------------------
-- Table structure for shangjia
-- ----------------------------
DROP TABLE IF EXISTS `shangjia`;
CREATE TABLE `shangjia` (
`id` bigint NOT NULL AUTO_INCREMENT COMMENT '主键',
`addtime` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
`shangjiazhanghao` varchar(200) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NOT NULL COMMENT '商家账号',
`mima` varchar(200) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NOT NULL COMMENT '密码',
`shangjiamingcheng` varchar(200) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NULL DEFAULT NULL COMMENT '商家名称',
`touxiang` varchar(200) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NULL DEFAULT NULL COMMENT '头像',
`lianxidianhua` varchar(200) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NULL DEFAULT NULL COMMENT '联系电话',
`dizhi` varchar(200) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NULL DEFAULT NULL COMMENT '地址',
PRIMARY KEY (`id`) USING BTREE,
UNIQUE INDEX `shangjiazhanghao`(`shangjiazhanghao` ASC) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 51 CHARACTER SET = utf8mb3 COLLATE = utf8mb3_general_ci COMMENT = '商家' ROW_FORMAT = Dynamic;
-- ----------------------------
-- Records of shangjia
-- ----------------------------
INSERT INTO `shangjia` VALUES (41, '2025-01-01 16:20:00', '商家1', '123456', '商家名称1', 'http://localhost:8080/springboot68ozj/upload/1735466328498.jpg', '13823888881', '地址1');
INSERT INTO `shangjia` VALUES (42, '2025-01-01 16:20:00', '商家2', '123456', '商家名称2', 'http://localhost:8080/springboot68ozj/upload/1735466328498.jpg', '13823888882', '地址2');
INSERT INTO `shangjia` VALUES (43, '2025-01-01 16:20:00', '商家3', '123456', '商家名称3', 'http://localhost:8080/springboot68ozj/upload/1735466328498.jpg', '13823888883', '地址3');
INSERT INTO `shangjia` VALUES (44, '2025-01-01 16:20:00', '商家4', '123456', '商家名称4', 'http://localhost:8080/springboot68ozj/upload/1735466328498.jpg', '13823888884', '地址4');
INSERT INTO `shangjia` VALUES (45, '2025-01-01 16:20:00', '商家5', '123456', '商家名称5', 'http://localhost:8080/springboot68ozj/upload/1735466328498.jpg', '13823888885', '地址5');
INSERT INTO `shangjia` VALUES (46, '2025-01-01 16:20:00', '商家6', '123456', '商家名称6', 'http://localhost:8080/springboot68ozj/upload/1735466328498.jpg', '13823888886', '地址6');
INSERT INTO `shangjia` VALUES (47, '2025-01-01 16:20:00', '商家7', '123456', '商家名称7', 'http://localhost:8080/springboot68ozj/upload/1735466328498.jpg', '13823888887', '地址7');
INSERT INTO `shangjia` VALUES (48, '2025-01-01 16:20:00', '商家8', '123456', '商家名称8', 'http://localhost:8080/springboot68ozj/upload/1735466328498.jpg', '13823888888', '地址8');
INSERT INTO `shangjia` VALUES (49, '2025-01-01 16:20:00', '商家9', '123456', '商家名称9', 'http://localhost:8080/springboot68ozj/upload/1735466328498.jpg', '13823888889', '地址9');
INSERT INTO `shangjia` VALUES (50, '2025-01-01 16:20:00', '商家10', '123456', '商家名称10', 'http://localhost:8080/springboot68ozj/upload/1735466328498.jpg', '13823888890', '地址10');
-- ----------------------------
-- Table structure for shiwuxinxi
-- ----------------------------
DROP TABLE IF EXISTS `shiwuxinxi`;
CREATE TABLE `shiwuxinxi` (
`id` bigint NOT NULL AUTO_INCREMENT COMMENT '主键',
`addtime` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
`wupinmingcheng` varchar(200) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NOT NULL COMMENT '物品名称',
`tupian` varchar(200) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NOT NULL COMMENT '图片',
`wupinleibie` varchar(200) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NOT NULL COMMENT '物品类别',
`diushididian` varchar(200) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NOT NULL COMMENT '丢失地点',
`diushishijian` datetime NOT NULL COMMENT '丢失时间',
`xunwuzhuangtai` varchar(200) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NULL DEFAULT NULL COMMENT '寻物状态',
`xiangximiaoshu` longtext CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NULL COMMENT '详细描述',
`xuehao` varchar(200) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NULL DEFAULT NULL COMMENT '学号',
`xueshengxingming` varchar(200) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NULL DEFAULT NULL COMMENT '学生姓名',
`shouji` varchar(200) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NULL DEFAULT NULL COMMENT '手机',
PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 181 CHARACTER SET = utf8mb3 COLLATE = utf8mb3_general_ci COMMENT = '失物信息' ROW_FORMAT = Dynamic;
-- ----------------------------
-- Records of shiwuxinxi
-- ----------------------------
INSERT INTO `shiwuxinxi` VALUES (171, '2025-01-01 16:20:00', '物品名称1', 'http://localhost:8080/springboot68ozj/upload/1735466705146.jpg', '物品类别1', '丢失地点1', '2025-01-01 16:20:00', '未寻回', '<p>详细描述1</p>', '学号1', '学生姓名1', '手机1');
INSERT INTO `shiwuxinxi` VALUES (172, '2025-01-01 16:20:00', '物品名称2', 'http://localhost:8080/springboot68ozj/upload/1735466705146.jpg', '物品类别2', '丢失地点2', '2025-01-01 16:20:00', '未寻回', '详细描述2', '学号2', '学生姓名2', '手机2');
INSERT INTO `shiwuxinxi` VALUES (173, '2025-01-01 16:20:00', '物品名称3', 'http://localhost:8080/springboot68ozj/upload/1735466705146.jpg', '物品类别3', '丢失地点3', '2025-01-01 16:20:00', '未寻回', '详细描述3', '学号3', '学生姓名3', '手机3');
INSERT INTO `shiwuxinxi` VALUES (174, '2025-01-01 16:20:00', '物品名称4', 'http://localhost:8080/springboot68ozj/upload/1735466705146.jpg', '物品类别4', '丢失地点4', '2025-01-01 16:20:00', '未寻回', '详细描述4', '学号4', '学生姓名4', '手机4');
INSERT INTO `shiwuxinxi` VALUES (175, '2025-01-01 16:20:00', '物品名称5', 'http://localhost:8080/springboot68ozj/upload/1735466705146.jpg', '物品类别5', '丢失地点5', '2025-01-01 16:20:00', '未寻回', '详细描述5', '学号5', '学生姓名5', '手机5');
INSERT INTO `shiwuxinxi` VALUES (176, '2025-01-01 16:20:00', '物品名称6', 'http://localhost:8080/springboot68ozj/upload/1735466705146.jpg', '物品类别6', '丢失地点6', '2025-01-01 16:20:00', '未寻回', '详细描述6', '学号6', '学生姓名6', '手机6');
INSERT INTO `shiwuxinxi` VALUES (177, '2025-01-01 16:20:00', '物品名称7', 'http://localhost:8080/springboot68ozj/upload/1735466705146.jpg', '物品类别7', '丢失地点7', '2025-01-01 16:20:00', '未寻回', '详细描述7', '学号7', '学生姓名7', '手机7');
INSERT INTO `shiwuxinxi` VALUES (178, '2025-01-01 16:20:00', '物品名称8', 'http://localhost:8080/springboot68ozj/upload/1735466705146.jpg', '物品类别8', '丢失地点8', '2025-01-01 16:20:00', '未寻回', '详细描述8', '学号8', '学生姓名8', '手机8');
INSERT INTO `shiwuxinxi` VALUES (179, '2025-01-01 16:20:00', '物品名称9', 'http://localhost:8080/springboot68ozj/upload/1735466705146.jpg', '物品类别9', '丢失地点9', '2025-01-01 16:20:00', '未寻回', '详细描述9', '学号9', '学生姓名9', '手机9');
INSERT INTO `shiwuxinxi` VALUES (180, '2025-01-01 16:20:00', '物品名称10', 'http://localhost:8080/springboot68ozj/upload/1735466705146.jpg', '物品类别10', '丢失地点10', '2025-01-01 16:20:00', '未寻回', '详细描述10', '学号10', '学生姓名10', '手机10');
-- ----------------------------
-- Table structure for storeup
-- ----------------------------
DROP TABLE IF EXISTS `storeup`;
CREATE TABLE `storeup` (
`id` bigint NOT NULL AUTO_INCREMENT COMMENT '主键',
`addtime` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
`userid` bigint NOT NULL COMMENT '用户id',
`refid` bigint NULL DEFAULT NULL COMMENT '收藏id',
`tablename` varchar(200) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NULL DEFAULT NULL COMMENT '表名',
`name` varchar(200) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NOT NULL COMMENT '收藏名称',
`picture` varchar(200) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NOT NULL COMMENT '收藏图片',
PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 1707973621104 CHARACTER SET = utf8mb3 COLLATE = utf8mb3_general_ci COMMENT = '收藏表' ROW_FORMAT = Dynamic;
-- ----------------------------
-- Records of storeup
-- ----------------------------
INSERT INTO `storeup` VALUES (1707973154770, '2025-01-01 16:20:00', 21, 142, 'tongzhuangshui', '名称2', '4.jpg');
INSERT INTO `storeup` VALUES (1707973621093, '2025-01-01 16:20:00', 21, 145, 'tongzhuangshui', '名称5', '5.jpg');
INSERT INTO `storeup` VALUES (1707973621094, '2025-01-01 16:20:00', 21, 146, 'tongzhuangshui', '名称6', '5.jpg');
INSERT INTO `storeup` VALUES (1707973621095, '2025-01-01 16:20:00', 22, 147, 'tongzhuangshui', '名称7', '5.jpg');
INSERT INTO `storeup` VALUES (1707973621096, '2025-01-01 16:20:00', 23, 148, 'tongzhuangshui', '名称8', '5.jpg');
INSERT INTO `storeup` VALUES (1707973621097, '2025-01-01 16:20:00', 24, 149, 'tongzhuangshui', '名称9', '5.jpg');
INSERT INTO `storeup` VALUES (1707973621098, '2025-01-01 16:20:00', 25, 150, 'tongzhuangshui', '名称10', '5.jpg');
INSERT INTO `storeup` VALUES (1707973621099, '2025-01-01 16:20:00', 26, 151, 'tongzhuangshui', '名称11', '5.jpg');
INSERT INTO `storeup` VALUES (1707973621100, '2025-01-01 16:20:00', 27, 152, 'tongzhuangshui', '名称12', '5.jpg');
INSERT INTO `storeup` VALUES (1707973621101, '2025-01-01 16:20:00', 28, 153, 'tongzhuangshui', '名称13', '5.jpg');
INSERT INTO `storeup` VALUES (1707973621102, '2025-01-01 16:20:00', 29, 154, 'tongzhuangshui', '名称14', '5.jpg');
INSERT INTO `storeup` VALUES (1707973621103, '2025-01-01 16:20:00', 30, 155, 'tongzhuangshui', '名称15', '5.jpg');
-- ----------------------------
-- Table structure for susheanpai
-- ----------------------------
DROP TABLE IF EXISTS `susheanpai`;
CREATE TABLE `susheanpai` (
`id` bigint NOT NULL AUTO_INCREMENT COMMENT '主键',
`addtime` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
`sushehao` varchar(200) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NULL DEFAULT NULL COMMENT '宿舍号',
`susheleixing` varchar(200) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NULL DEFAULT NULL COMMENT '宿舍类型',
`weizhi` varchar(200) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NULL DEFAULT NULL COMMENT '位置',
`kezhurenshu` varchar(200) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NULL DEFAULT NULL COMMENT '可住人数',
`xuehao` varchar(200) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NULL DEFAULT NULL COMMENT '学号',
`xueshengxingming` varchar(200) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NULL DEFAULT NULL COMMENT '学生姓名',
`banji` varchar(200) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NULL DEFAULT NULL COMMENT '班级',
`anpairiqi` date NULL DEFAULT NULL COMMENT '安排日期',
PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 71 CHARACTER SET = utf8mb3 COLLATE = utf8mb3_general_ci COMMENT = '宿舍安排' ROW_FORMAT = Dynamic;
-- ----------------------------
-- Records of susheanpai
-- ----------------------------
INSERT INTO `susheanpai` VALUES (61, '2025-01-01 16:20:00', '宿舍号1', '宿舍类型1', '位置1', '可住人数1', '学号1', '学生姓名1', '班级1', '2025-01-01');
INSERT INTO `susheanpai` VALUES (62, '2025-01-01 16:20:00', '宿舍号2', '宿舍类型2', '位置2', '可住人数2', '学号2', '学生姓名2', '班级2', '2025-01-01');
INSERT INTO `susheanpai` VALUES (63, '2025-01-01 16:20:00', '宿舍号3', '宿舍类型3', '位置3', '可住人数3', '学号3', '学生姓名3', '班级3', '2025-01-01');
INSERT INTO `susheanpai` VALUES (64, '2025-01-01 16:20:00', '宿舍号4', '宿舍类型4', '位置4', '可住人数4', '学号4', '学生姓名4', '班级4', '2025-01-01');
INSERT INTO `susheanpai` VALUES (65, '2025-01-01 16:20:00', '宿舍号5', '宿舍类型5', '位置5', '可住人数5', '学号5', '学生姓名5', '班级5', '2025-01-01');
INSERT INTO `susheanpai` VALUES (66, '2025-01-01 16:20:00', '宿舍号6', '宿舍类型6', '位置6', '可住人数6', '学号6', '学生姓名6', '班级6', '2025-01-01');
INSERT INTO `susheanpai` VALUES (67, '2025-01-01 16:20:00', '宿舍号7', '宿舍类型7', '位置7', '可住人数7', '学号7', '学生姓名7', '班级7', '2025-01-01');
INSERT INTO `susheanpai` VALUES (68, '2025-01-01 16:20:00', '宿舍号8', '宿舍类型8', '位置8', '可住人数8', '学号8', '学生姓名8', '班级8', '2025-01-01');
INSERT INTO `susheanpai` VALUES (69, '2025-01-01 16:20:00', '宿舍号9', '宿舍类型9', '位置9', '可住人数9', '学号9', '学生姓名9', '班级9', '2025-01-01');
INSERT INTO `susheanpai` VALUES (70, '2025-01-01 16:20:00', '宿舍号10', '宿舍类型10', '位置10', '可住人数10', '学号10', '学生姓名10', '班级10', '2025-01-01');
-- ----------------------------
-- Table structure for sushexinxi
-- ----------------------------
DROP TABLE IF EXISTS `sushexinxi`;
CREATE TABLE `sushexinxi` (
`id` bigint NOT NULL AUTO_INCREMENT COMMENT '主键',
`addtime` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
`sushehao` varchar(200) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NOT NULL COMMENT '宿舍号',
`susheleixing` varchar(200) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NOT NULL COMMENT '宿舍类型',
`tupian` varchar(200) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NULL DEFAULT NULL COMMENT '图片',
`loudong` varchar(200) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NULL DEFAULT NULL COMMENT '楼栋',
`weizhi` varchar(200) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NULL DEFAULT NULL COMMENT '位置',
`kezhurenshu` int NULL DEFAULT NULL COMMENT '可住人数',
`beizhu` varchar(200) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NULL DEFAULT NULL COMMENT '备注',
PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 61 CHARACTER SET = utf8mb3 COLLATE = utf8mb3_general_ci COMMENT = '宿舍信息' ROW_FORMAT = Dynamic;
-- ----------------------------
-- Records of sushexinxi
-- ----------------------------
INSERT INTO `sushexinxi` VALUES (51, '2025-01-01 16:20:00', '宿舍号1', '男生', 'http://localhost:8080/springboot68ozj/upload/1735466804074.jpg', '楼栋1', '位置1', 1, '备注1');
INSERT INTO `sushexinxi` VALUES (52, '2025-01-01 16:20:00', '宿舍号2', '男生', 'http://localhost:8080/springboot68ozj/upload/1735466804074.jpg', '楼栋2', '位置2', 2, '备注2');
INSERT INTO `sushexinxi` VALUES (53, '2025-01-01 16:20:00', '宿舍号3', '男生', 'http://localhost:8080/springboot68ozj/upload/1735466804074.jpg', '楼栋3', '位置3', 3, '备注3');
INSERT INTO `sushexinxi` VALUES (54, '2025-01-01 16:20:00', '宿舍号4', '男生', 'http://localhost:8080/springboot68ozj/upload/1735466804074.jpg', '楼栋4', '位置4', 4, '备注4');
INSERT INTO `sushexinxi` VALUES (55, '2025-01-01 16:20:00', '宿舍号5', '男生', 'http://localhost:8080/springboot68ozj/upload/1735466804074.jpg', '楼栋5', '位置5', 5, '备注5');
INSERT INTO `sushexinxi` VALUES (56, '2025-01-01 16:20:00', '宿舍号6', '男生', 'http://localhost:8080/springboot68ozj/upload/1735466804074.jpg', '楼栋6', '位置6', 6, '备注6');
INSERT INTO `sushexinxi` VALUES (57, '2025-01-01 16:20:00', '宿舍号7', '男生', 'http://localhost:8080/springboot68ozj/upload/1735466804074.jpg', '楼栋7', '位置7', 7, '备注7');
INSERT INTO `sushexinxi` VALUES (58, '2025-01-01 16:20:00', '宿舍号8', '男生', 'http://localhost:8080/springboot68ozj/upload/1735466804074.jpg', '楼栋8', '位置8', 8, '备注8');
INSERT INTO `sushexinxi` VALUES (59, '2025-01-01 16:20:00', '宿舍号9', '男生', 'http://localhost:8080/springboot68ozj/upload/1735466804074.jpg', '楼栋9', '位置9', 9, '备注9');
INSERT INTO `sushexinxi` VALUES (60, '2025-01-01 16:20:00', '宿舍号10', '男生', 'http://localhost:8080/springboot68ozj/upload/1735466804074.jpg', '楼栋10', '位置10', 10, '备注10');
-- ----------------------------
-- Table structure for token
-- ----------------------------
DROP TABLE IF EXISTS `token`;
CREATE TABLE `token` (
`id` bigint NOT NULL AUTO_INCREMENT COMMENT '主键',
`userid` bigint NOT NULL COMMENT '用户id',
`username` varchar(100) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NOT NULL COMMENT '用户名',
`tablename` varchar(100) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NULL DEFAULT NULL COMMENT '表名',
`role` varchar(100) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NULL DEFAULT NULL COMMENT '角色',
`token` varchar(200) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NOT NULL COMMENT '密码',
`addtime` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '新增时间',
`expiratedtime` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '过期时间',
PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 11 CHARACTER SET = utf8mb3 COLLATE = utf8mb3_general_ci COMMENT = 'token表' ROW_FORMAT = Dynamic;
-- ----------------------------
-- Records of token
-- ----------------------------
INSERT INTO `token` VALUES (1, 1, 'abo', 'users', '管理员', 'ewm2ttspu5wro33fl87m4s42797zk4o3', '2025-01-01 16:20:00', '2024-12-29 18:56:30');
INSERT INTO `token` VALUES (2, 2, '学生2', 'xuesheng', '学生', 'i1fc871uzhu25q1fv5mcrg61l22y6thz', '2025-01-01 16:20:00', '2025-01-01 16:20:00');
INSERT INTO `token` VALUES (3, 3, '维修人员3', 'weixiurenyuan', '维修人员', '2t0uvd5jgb4q9mh420lkh90rcfnulw2r', '2025-01-01 16:20:00', '2025-01-01 16:20:00');
INSERT INTO `token` VALUES (4, 4, '商家4', 'shangjia', '商家', 'hnwg6l7fimdkd47ysyf05ifcr4xa09gz', '2025-01-01 16:20:00', '2025-01-01 16:20:00');
INSERT INTO `token` VALUES (5, 5, '用户5', 'users', '用户', 'generated_token_51', '2025-01-01 16:20:00', '2025-01-01 16:20:00');
INSERT INTO `token` VALUES (6, 6, '用户6', 'users', '用户', 'generated_token_61', '2025-01-01 16:20:00', '2025-01-01 16:20:00');
INSERT INTO `token` VALUES (7, 7, '用户7', 'users', '用户', 'generated_token_71', '2025-01-01 16:20:00', '2025-01-01 16:20:00');
INSERT INTO `token` VALUES (8, 8, '用户8', 'users', '用户', 'generated_token_81', '2025-01-01 16:20:00', '2025-01-01 16:20:00');
INSERT INTO `token` VALUES (9, 9, '用户9', 'users', '用户', 'generated_token_91', '2025-01-01 16:20:00', '2025-01-01 16:20:00');
INSERT INTO `token` VALUES (10, 10, '用户10', 'users', '用户', 'generated_token_101', '2025-01-01 16:20:00', '2025-01-01 16:20:00');
-- ----------------------------
-- Table structure for tongzhuangshui
-- ----------------------------
DROP TABLE IF EXISTS `tongzhuangshui`;
CREATE TABLE `tongzhuangshui` (
`id` bigint NOT NULL AUTO_INCREMENT COMMENT '主键',
`addtime` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
`mingcheng` varchar(200) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NULL DEFAULT NULL COMMENT '名称',
`tupian` varchar(200) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NULL DEFAULT NULL COMMENT '图片',
`pinpai` varchar(200) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NULL DEFAULT NULL COMMENT '品牌',
`guige` varchar(200) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NULL DEFAULT NULL COMMENT '规格',
`jiage` int NULL DEFAULT NULL COMMENT '价格',
`xiangqing` longtext CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NULL COMMENT '详情',
`shangjiazhanghao` varchar(200) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NULL DEFAULT NULL COMMENT '商家账号',
`shangjiamingcheng` varchar(200) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NULL DEFAULT NULL COMMENT '商家名称',
`clicktime` datetime NULL DEFAULT NULL COMMENT '最近点击时间',
`clicknum` int NULL DEFAULT 0 COMMENT '点击次数',
PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 151 CHARACTER SET = utf8mb3 COLLATE = utf8mb3_general_ci COMMENT = '桶装水' ROW_FORMAT = Dynamic;
-- ----------------------------
-- Records of tongzhuangshui
-- ----------------------------
INSERT INTO `tongzhuangshui` VALUES (141, '2025-01-01 16:20:00', '名称1', 'http://localhost:8080/springboot68ozj/upload/1735466861930.jpg', '品牌1', '规格1', 1, '<p>详情1</p>', '商家账号1', '商家名称1', '2024-12-29 18:07:37', 6);
INSERT INTO `tongzhuangshui` VALUES (142, '2025-01-01 16:20:00', '名称2', 'http://localhost:8080/springboot68ozj/upload/1735466861930.jpg', '品牌2', '规格2', 2, '<p>详情2</p>', '商家账号2', '商家名称2', '2025-01-01 16:20:00', 8);
INSERT INTO `tongzhuangshui` VALUES (143, '2025-01-01 16:20:00', '名称3', 'http://localhost:8080/springboot68ozj/upload/1735466861930.jpg', '品牌3', '规格3', 3, '<p>详情3</p>', '商家账号3', '商家名称3', '2025-01-01 16:20:00', 5);
INSERT INTO `tongzhuangshui` VALUES (144, '2025-01-01 16:20:00', '名称4', 'http://localhost:8080/springboot68ozj/upload/1735466861930.jpg', '品牌4', '规格4', 4, '<p>详情4</p>', '商家账号4', '商家名称4', '2025-01-01 16:20:00', 5);
INSERT INTO `tongzhuangshui` VALUES (145, '2025-01-01 16:20:00', '名称5', 'http://localhost:8080/springboot68ozj/upload/1735466861930.jpg', '品牌5', '规格5', 5, '<p>详情5</p>', '商家账号5', '商家名称5', '2025-01-01 16:20:00', 7);
INSERT INTO `tongzhuangshui` VALUES (146, '2025-01-01 16:20:00', '名称6', 'http://localhost:8080/springboot68ozj/upload/1735466861930.jpg', '品牌6', '规格6', 6, '<p>详情6</p>', '商家账号6', '商家名称6', '2025-01-01 16:20:00', 7);
INSERT INTO `tongzhuangshui` VALUES (147, '2025-01-01 16:20:00', '名称7', 'http://localhost:8080/springboot68ozj/upload/1735466861930.jpg', '品牌7', '规格7', 7, '<p>详情7</p>', '商家账号7', '商家名称7', '2025-01-01 16:20:00', 2);
INSERT INTO `tongzhuangshui` VALUES (148, '2025-01-01 16:20:00', '名称8', 'http://localhost:8080/springboot68ozj/upload/1735466861930.jpg', '品牌8', '规格8', 8, '<p>详情8</p>', '商家账号8', '商家名称8', '2025-01-01 16:20:00', 4);
INSERT INTO `tongzhuangshui` VALUES (149, '2025-01-01 16:20:00', '名称9', 'http://localhost:8080/springboot68ozj/upload/1735466861930.jpg', '品牌9', '规格9', 9, '<p>详情9</p>', '商家账号9', '商家名称9', '2025-01-01 16:20:00', 6);
INSERT INTO `tongzhuangshui` VALUES (150, '2025-01-01 16:20:00', '名称10', 'http://localhost:8080/springboot68ozj/upload/1735466861930.jpg', '品牌10', '规格10', 10, '<p>详情10</p>', '商家账号10', '商家名称10', '2025-01-01 16:20:00', 1);
-- ----------------------------
-- Table structure for tongzhuangshuipinpai
-- ----------------------------
DROP TABLE IF EXISTS `tongzhuangshuipinpai`;
CREATE TABLE `tongzhuangshuipinpai` (
`id` bigint NOT NULL AUTO_INCREMENT COMMENT '主键',
`addtime` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
`pinpai` varchar(200) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NOT NULL COMMENT '品牌',
PRIMARY KEY (`id`) USING BTREE,
UNIQUE INDEX `pinpai`(`pinpai` ASC) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 141 CHARACTER SET = utf8mb3 COLLATE = utf8mb3_general_ci COMMENT = '桶装水品牌' ROW_FORMAT = Dynamic;
-- ----------------------------
-- Records of tongzhuangshuipinpai
-- ----------------------------
INSERT INTO `tongzhuangshuipinpai` VALUES (131, '2025-01-01 16:20:00', '品牌1');
INSERT INTO `tongzhuangshuipinpai` VALUES (132, '2025-01-01 16:20:00', '品牌2');
INSERT INTO `tongzhuangshuipinpai` VALUES (133, '2025-01-01 16:20:00', '品牌3');
INSERT INTO `tongzhuangshuipinpai` VALUES (134, '2025-01-01 16:20:00', '品牌4');
INSERT INTO `tongzhuangshuipinpai` VALUES (135, '2025-01-01 16:20:00', '品牌5');
INSERT INTO `tongzhuangshuipinpai` VALUES (136, '2025-01-01 16:20:00', '品牌6');
INSERT INTO `tongzhuangshuipinpai` VALUES (137, '2025-01-01 16:20:00', '品牌7');
INSERT INTO `tongzhuangshuipinpai` VALUES (138, '2025-01-01 16:20:00', '品牌8');
INSERT INTO `tongzhuangshuipinpai` VALUES (139, '2025-01-01 16:20:00', '品牌9');
INSERT INTO `tongzhuangshuipinpai` VALUES (140, '2025-01-01 16:20:00', '品牌10');
-- ----------------------------
-- Table structure for tongzhuangshuiyuding
-- ----------------------------
DROP TABLE IF EXISTS `tongzhuangshuiyuding`;
CREATE TABLE `tongzhuangshuiyuding` (
`id` bigint NOT NULL AUTO_INCREMENT COMMENT '主键',
`addtime` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
`mingcheng` varchar(200) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NULL DEFAULT NULL COMMENT '名称',
`pinpai` varchar(200) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NULL DEFAULT NULL COMMENT '品牌',
`guige` varchar(200) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NULL DEFAULT NULL COMMENT '规格',
`jiage` int NULL DEFAULT NULL COMMENT '价格',
`shuliang` int NULL DEFAULT NULL COMMENT '数量',
`zongjine` varchar(200) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NULL DEFAULT NULL COMMENT '总金额',
`beizhu` varchar(200) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NULL DEFAULT NULL COMMENT '备注',
`songhuodizhi` varchar(200) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NULL DEFAULT NULL COMMENT '送货地址',
`xuehao` varchar(200) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NULL DEFAULT NULL COMMENT '学号',
`shouji` varchar(200) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NULL DEFAULT NULL COMMENT '手机',
`shangjiazhanghao` varchar(200) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NULL DEFAULT NULL COMMENT '商家账号',
`shangjiamingcheng` varchar(200) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NULL DEFAULT NULL COMMENT '商家名称',
`sfsh` varchar(200) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NULL DEFAULT '否' COMMENT '是否审核',
`shhf` longtext CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NULL COMMENT '审核回复',
`ispay` varchar(200) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NULL DEFAULT '未支付' COMMENT '是否支付',
PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 161 CHARACTER SET = utf8mb3 COLLATE = utf8mb3_general_ci COMMENT = '桶装水预订' ROW_FORMAT = Dynamic;
-- ----------------------------
-- Records of tongzhuangshuiyuding
-- ----------------------------
INSERT INTO `tongzhuangshuiyuding` VALUES (151, '2025-01-01 16:20:00', '名称1', '品牌1', '规格1', 1, 1, '总金额1', '备注1', '送货地址1', '学号1', '手机1', '商家账号1', '商家名称1', '是', '', '未支付');
INSERT INTO `tongzhuangshuiyuding` VALUES (152, '2025-01-01 16:20:00', '名称2', '品牌2', '规格2', 2, 2, '总金额2', '备注2', '送货地址2', '学号2', '手机2', '商家账号2', '商家名称2', '是', '', '未支付');
INSERT INTO `tongzhuangshuiyuding` VALUES (153, '2025-01-01 16:20:00', '名称3', '品牌3', '规格3', 3, 3, '总金额3', '备注3', '送货地址3', '学号3', '手机3', '商家账号3', '商家名称3', '是', '', '未支付');
INSERT INTO `tongzhuangshuiyuding` VALUES (154, '2025-01-01 16:20:00', '名称4', '品牌4', '规格4', 4, 4, '总金额4', '备注4', '送货地址4', '学号4', '手机4', '商家账号4', '商家名称4', '是', '', '未支付');
INSERT INTO `tongzhuangshuiyuding` VALUES (155, '2025-01-01 16:20:00', '名称5', '品牌5', '规格5', 5, 5, '总金额5', '备注5', '送货地址5', '学号5', '手机5', '商家账号5', '商家名称5', '是', '', '未支付');
INSERT INTO `tongzhuangshuiyuding` VALUES (156, '2025-01-01 16:20:00', '名称6', '品牌6', '规格6', 6, 6, '总金额6', '备注6', '送货地址6', '学号6', '手机6', '商家账号6', '商家名称6', '是', '', '未支付');
INSERT INTO `tongzhuangshuiyuding` VALUES (157, '2025-01-01 16:20:00', '名称7', '品牌7', '规格7', 7, 7, '总金额7', '备注7', '送货地址7', '学号7', '手机7', '商家账号7', '商家名称7', '是', '', '未支付');
INSERT INTO `tongzhuangshuiyuding` VALUES (158, '2025-01-01 16:20:00', '名称8', '品牌8', '规格8', 8, 8, '总金额8', '备注8', '送货地址8', '学号8', '手机8', '商家账号8', '商家名称8', '是', '', '未支付');
INSERT INTO `tongzhuangshuiyuding` VALUES (159, '2025-01-01 16:20:00', '名称9', '品牌9', '规格9', 9, 9, '总金额9', '备注9', '送货地址9', '学号9', '手机9', '商家账号9', '商家名称9', '是', '', '未支付');
INSERT INTO `tongzhuangshuiyuding` VALUES (160, '2025-01-01 16:20:00', '名称10', '品牌10', '规格10', 10, 10, '总金额10', '备注10', '送货地址10', '学号10', '手机10', '商家账号10', '商家名称10', '是', '', '未支付');
-- ----------------------------
-- Table structure for users
-- ----------------------------
DROP TABLE IF EXISTS `users`;
CREATE TABLE `users` (
`id` bigint NOT NULL AUTO_INCREMENT COMMENT '主键',
`username` varchar(100) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NOT NULL COMMENT '用户名',
`password` varchar(100) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NOT NULL COMMENT '密码',
`role` varchar(100) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NULL DEFAULT '管理员' COMMENT '角色',
`addtime` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '新增时间',
PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 2 CHARACTER SET = utf8mb3 COLLATE = utf8mb3_general_ci COMMENT = '用户表' ROW_FORMAT = Dynamic;
-- ----------------------------
-- Records of users
-- ----------------------------
INSERT INTO `users` VALUES (1, 'admin', '123456', '管理员', '2025-01-01 16:20:00');
-- ----------------------------
-- Table structure for weishengjiancha
-- ----------------------------
DROP TABLE IF EXISTS `weishengjiancha`;
CREATE TABLE `weishengjiancha` (
`id` bigint NOT NULL AUTO_INCREMENT COMMENT '主键',
`addtime` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
`xuehao` varchar(200) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NULL DEFAULT NULL COMMENT '学号',
`xueshengxingming` varchar(200) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NULL DEFAULT NULL COMMENT '学生姓名',
`banji` varchar(200) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NULL DEFAULT NULL COMMENT '班级',
`sushehao` varchar(200) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NULL DEFAULT NULL COMMENT '宿舍号',
`jianchaneirong` varchar(200) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NULL DEFAULT NULL COMMENT '检查内容',
`shifouzhengjie` varchar(200) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NULL DEFAULT NULL COMMENT '是否整洁',
`shifouweigui` varchar(200) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NULL DEFAULT NULL COMMENT '是否违规',
`weishengpingfen` int NULL DEFAULT NULL COMMENT '卫生评分',
`jianchajieguo` varchar(200) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NULL DEFAULT NULL COMMENT '检查结果',
`jianchariqi` date NULL DEFAULT NULL COMMENT '检查日期',
PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 111 CHARACTER SET = utf8mb3 COLLATE = utf8mb3_general_ci COMMENT = '卫生检查' ROW_FORMAT = Dynamic;
-- ----------------------------
-- Records of weishengjiancha
-- ----------------------------
INSERT INTO `weishengjiancha` VALUES (101, '2025-01-01 16:20:00', '学号1', '学生姓名1', '班级1', '宿舍号1', '检查内容1', '是', '是', 1, '合格', '2025-01-01');
INSERT INTO `weishengjiancha` VALUES (102, '2025-01-01 16:20:00', '学号2', '学生姓名2', '班级2', '宿舍号2', '检查内容2', '是', '是', 2, '合格', '2025-01-01');
INSERT INTO `weishengjiancha` VALUES (103, '2025-01-01 16:20:00', '学号3', '学生姓名3', '班级3', '宿舍号3', '检查内容3', '是', '是', 3, '合格', '2025-01-01');
INSERT INTO `weishengjiancha` VALUES (104, '2025-01-01 16:20:00', '学号4', '学生姓名4', '班级4', '宿舍号4', '检查内容4', '是', '是', 4, '合格', '2025-01-01');
INSERT INTO `weishengjiancha` VALUES (105, '2025-01-01 16:20:00', '学号5', '学生姓名5', '班级5', '宿舍号5', '检查内容5', '是', '是', 5, '合格', '2025-01-01');
INSERT INTO `weishengjiancha` VALUES (106, '2025-01-01 16:20:00', '学号6', '学生姓名6', '班级6', '宿舍号6', '检查内容6', '是', '是', 6, '合格', '2025-01-01');
INSERT INTO `weishengjiancha` VALUES (107, '2025-01-01 16:20:00', '学号7', '学生姓名7', '班级7', '宿舍号7', '检查内容7', '是', '是', 7, '合格', '2025-01-01');
INSERT INTO `weishengjiancha` VALUES (108, '2025-01-01 16:20:00', '学号8', '学生姓名8', '班级8', '宿舍号8', '检查内容8', '是', '是', 8, '合格', '2025-01-01');
INSERT INTO `weishengjiancha` VALUES (109, '2025-01-01 16:20:00', '学号9', '学生姓名9', '班级9', '宿舍号9', '检查内容9', '是', '是', 9, '合格', '2025-01-01');
INSERT INTO `weishengjiancha` VALUES (110, '2025-01-01 16:20:00', '学号10', '学生姓名10', '班级10', '宿舍号10', '检查内容10', '是', '是', 10, '合格', '2025-01-01');
-- ----------------------------
-- Table structure for weixiurenyuan
-- ----------------------------
DROP TABLE IF EXISTS `weixiurenyuan`;
CREATE TABLE `weixiurenyuan` (
`id` bigint NOT NULL AUTO_INCREMENT COMMENT '主键',
`addtime` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
`weixiugonghao` varchar(200) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NOT NULL COMMENT '维修工号',
`mima` varchar(200) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NOT NULL COMMENT '密码',
`xingming` varchar(200) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NOT NULL COMMENT '姓名',
`xingbie` varchar(200) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NULL DEFAULT NULL COMMENT '性别',
`zhaopian` varchar(200) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NULL DEFAULT NULL COMMENT '照片',
`lianxidianhua` varchar(200) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NULL DEFAULT NULL COMMENT '联系电话',
`shenfenzheng` varchar(200) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NULL DEFAULT NULL COMMENT '身份证',
PRIMARY KEY (`id`) USING BTREE,
UNIQUE INDEX `weixiugonghao`(`weixiugonghao` ASC) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 41 CHARACTER SET = utf8mb3 COLLATE = utf8mb3_general_ci COMMENT = '维修人员' ROW_FORMAT = Dynamic;
-- ----------------------------
-- Records of weixiurenyuan
-- ----------------------------
INSERT INTO `weixiurenyuan` VALUES (31, '2025-01-01 16:20:00', '维修人员1', '123456', '姓名1', '男', 'http://localhost:8080/springboot68ozj/upload/1735466766623.jpg', '13823888881', '440300199101010001');
INSERT INTO `weixiurenyuan` VALUES (32, '2025-01-01 16:20:00', '维修人员2', '123456', '姓名2', '男', 'http://localhost:8080/springboot68ozj/upload/1735466766623.jpg', '13823888882', '440300199202020002');
INSERT INTO `weixiurenyuan` VALUES (33, '2025-01-01 16:20:00', '维修人员3', '123456', '姓名3', '男', 'http://localhost:8080/springboot68ozj/upload/1735466766623.jpg', '13823888883', '440300199303030003');
INSERT INTO `weixiurenyuan` VALUES (34, '2025-01-01 16:20:00', '维修人员4', '123456', '姓名4', '男', 'http://localhost:8080/springboot68ozj/upload/1735466766623.jpg', '13823888884', '440300199404040004');
INSERT INTO `weixiurenyuan` VALUES (35, '2025-01-01 16:20:00', '维修人员5', '123456', '姓名5', '男', 'http://localhost:8080/springboot68ozj/upload/1735466766623.jpg', '13823888885', '440300199505050005');
INSERT INTO `weixiurenyuan` VALUES (36, '2025-01-01 16:20:00', '维修人员6', '123456', '姓名6', '男', 'http://localhost:8080/springboot68ozj/upload/1735466766623.jpg', '13823888886', '440300199606060006');
INSERT INTO `weixiurenyuan` VALUES (37, '2025-01-01 16:20:00', '维修人员7', '123456', '姓名7', '男', 'http://localhost:8080/springboot68ozj/upload/1735466766623.jpg', '13823888887', '440300199707070007');
INSERT INTO `weixiurenyuan` VALUES (38, '2025-01-01 16:20:00', '维修人员8', '123456', '姓名8', '男', 'http://localhost:8080/springboot68ozj/upload/1735466766623.jpg', '13823888888', '440300199808080008');
INSERT INTO `weixiurenyuan` VALUES (39, '2025-01-01 16:20:00', '维修人员9', '123456', '姓名9', '男', 'http://localhost:8080/springboot68ozj/upload/1735466766623.jpg', '13823888889', '440300199909090009');
INSERT INTO `weixiurenyuan` VALUES (40, '2025-01-01 16:20:00', '维修人员10', '123456', '姓名10', '男', 'http://localhost:8080/springboot68ozj/upload/1735466766623.jpg', '13823888880', '440300200001010001');
-- ----------------------------
-- Table structure for wenmingsushe
-- ----------------------------
DROP TABLE IF EXISTS `wenmingsushe`;
CREATE TABLE `wenmingsushe` (
`id` bigint NOT NULL AUTO_INCREMENT COMMENT '主键',
`addtime` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
`sushehao` varchar(200) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NULL DEFAULT NULL COMMENT '宿舍号',
`weishengpingfen` varchar(200) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NULL DEFAULT NULL COMMENT '卫生评分',
`pingbiriqi` date NULL DEFAULT NULL COMMENT '评比日期',
PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 121 CHARACTER SET = utf8mb3 COLLATE = utf8mb3_general_ci COMMENT = '文明宿舍' ROW_FORMAT = Dynamic;
-- ----------------------------
-- Records of wenmingsushe
-- ----------------------------
INSERT INTO `wenmingsushe` VALUES (111, '2025-01-01 16:20:00', '宿舍号1', '卫生评分1', '2025-01-01');
INSERT INTO `wenmingsushe` VALUES (112, '2025-01-01 16:20:00', '宿舍号2', '卫生评分2', '2025-01-01');
INSERT INTO `wenmingsushe` VALUES (113, '2025-01-01 16:20:00', '宿舍号3', '卫生评分3', '2025-01-01');
INSERT INTO `wenmingsushe` VALUES (114, '2025-01-01 16:20:00', '宿舍号4', '卫生评分4', '2025-01-01');
INSERT INTO `wenmingsushe` VALUES (115, '2025-01-01 16:20:00', '宿舍号5', '卫生评分5', '2025-01-01');
INSERT INTO `wenmingsushe` VALUES (116, '2025-01-01 16:20:00', '宿舍号6', '卫生评分6', '2025-01-01');
INSERT INTO `wenmingsushe` VALUES (117, '2025-01-01 16:20:00', '宿舍号7', '卫生评分7', '2025-01-01');
INSERT INTO `wenmingsushe` VALUES (118, '2025-01-01 16:20:00', '宿舍号8', '卫生评分8', '2025-01-01');
INSERT INTO `wenmingsushe` VALUES (119, '2025-01-01 16:20:00', '宿舍号9', '卫生评分9', '2025-01-01');
INSERT INTO `wenmingsushe` VALUES (120, '2025-01-01 16:20:00', '宿舍号10', '卫生评分10', '2025-01-01');
-- ----------------------------
-- Table structure for wupinleibie
-- ----------------------------
DROP TABLE IF EXISTS `wupinleibie`;
CREATE TABLE `wupinleibie` (
`id` bigint NOT NULL AUTO_INCREMENT COMMENT '主键',
`addtime` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
`wupinleibie` varchar(200) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NOT NULL COMMENT '物品类别',
PRIMARY KEY (`id`) USING BTREE,
UNIQUE INDEX `wupinleibie`(`wupinleibie` ASC) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 171 CHARACTER SET = utf8mb3 COLLATE = utf8mb3_general_ci COMMENT = '物品类别' ROW_FORMAT = Dynamic;
-- ----------------------------
-- Records of wupinleibie
-- ----------------------------
INSERT INTO `wupinleibie` VALUES (161, '2025-01-01 16:20:00', '物品类别1');
INSERT INTO `wupinleibie` VALUES (162, '2025-01-01 16:20:00', '物品类别2');
INSERT INTO `wupinleibie` VALUES (163, '2025-01-01 16:20:00', '物品类别3');
INSERT INTO `wupinleibie` VALUES (164, '2025-01-01 16:20:00', '物品类别4');
INSERT INTO `wupinleibie` VALUES (165, '2025-01-01 16:20:00', '物品类别5');
INSERT INTO `wupinleibie` VALUES (166, '2025-01-01 16:20:00', '物品类别6');
INSERT INTO `wupinleibie` VALUES (167, '2025-01-01 16:20:00', '物品类别7');
INSERT INTO `wupinleibie` VALUES (168, '2025-01-01 16:20:00', '物品类别8');
INSERT INTO `wupinleibie` VALUES (169, '2025-01-01 16:20:00', '物品类别9');
INSERT INTO `wupinleibie` VALUES (170, '2025-01-01 16:20:00', '物品类别10');
-- ----------------------------
-- Table structure for xuesheng
-- ----------------------------
DROP TABLE IF EXISTS `xuesheng`;
CREATE TABLE `xuesheng` (
`id` bigint NOT NULL AUTO_INCREMENT COMMENT '主键',
`addtime` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
`xuehao` varchar(200) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NOT NULL COMMENT '学号',
`mima` varchar(200) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NOT NULL COMMENT '密码',
`xueshengxingming` varchar(200) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NOT NULL COMMENT '学生姓名',
`xingbie` varchar(200) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NULL DEFAULT NULL COMMENT '性别',
`touxiang` varchar(200) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NULL DEFAULT NULL COMMENT '头像',
`banji` varchar(200) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NULL DEFAULT NULL COMMENT '班级',
`shouji` varchar(200) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NULL DEFAULT NULL COMMENT '手机',
`youxiang` varchar(200) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NULL DEFAULT NULL COMMENT '邮箱',
`sushehao` varchar(200) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NULL DEFAULT NULL COMMENT '宿舍号',
PRIMARY KEY (`id`) USING BTREE,
UNIQUE INDEX `xuehao`(`xuehao` ASC) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 31 CHARACTER SET = utf8mb3 COLLATE = utf8mb3_general_ci COMMENT = '学生' ROW_FORMAT = Dynamic;
-- ----------------------------
-- Records of xuesheng
-- ----------------------------
INSERT INTO `xuesheng` VALUES (21, '2025-01-01 16:20:00', '学生1', '123456', '学生姓名1', '男', 'http://localhost:8080/springboot68ozj/upload/1735466968938.jpg', '班级1', '13823888881', '773890001@qq.com', '宿舍号1');
INSERT INTO `xuesheng` VALUES (22, '2025-01-01 16:20:00', '学生2', '123456', '学生姓名2', '男', 'http://localhost:8080/springboot68ozj/upload/1735466968938.jpg', '班级2', '13823888882', '773890002@qq.com', '宿舍号2');
INSERT INTO `xuesheng` VALUES (23, '2025-01-01 16:20:00', '学生3', '123456', '学生姓名3', '男', 'http://localhost:8080/springboot68ozj/upload/1735466968938.jpg', '班级3', '13823888883', '773890003@qq.com', '宿舍号3');
INSERT INTO `xuesheng` VALUES (24, '2025-01-01 16:20:00', '学生4', '123456', '学生姓名4', '男', 'http://localhost:8080/springboot68ozj/upload/1735466968938.jpg', '班级4', '13823888884', '773890004@qq.com', '宿舍号4');
INSERT INTO `xuesheng` VALUES (25, '2025-01-01 16:20:00', '学生5', '123456', '学生姓名5', '男', 'http://localhost:8080/springboot68ozj/upload/1735466968938.jpg', '班级5', '13823888885', '773890005@qq.com', '宿舍号5');
INSERT INTO `xuesheng` VALUES (26, '2025-01-01 16:20:00', '学生6', '123456', '学生姓名6', '男', 'http://localhost:8080/springboot68ozj/upload/1735466968938.jpg', '班级6', '13823888886', '773890006@qq.com', '宿舍号6');
INSERT INTO `xuesheng` VALUES (27, '2025-01-01 16:20:00', '学生7', '123456', '学生姓名7', '男', 'http://localhost:8080/springboot68ozj/upload/1735466968938.jpg', '班级7', '13823888887', '773890007@qq.com', '宿舍号7');
INSERT INTO `xuesheng` VALUES (28, '2025-01-01 16:20:00', '学生8', '123456', '学生姓名8', '男', 'http://localhost:8080/springboot68ozj/upload/1735466968938.jpg', '班级8', '13823888888', '773890008@qq.com', '宿舍号8');
INSERT INTO `xuesheng` VALUES (29, '2025-01-01 16:20:00', '学生9', '123456', '学生姓名9', '男', 'http://localhost:8080/springboot68ozj/upload/1735466968938.jpg', '班级9', '13823888889', '773890009@qq.com', '宿舍号9');
INSERT INTO `xuesheng` VALUES (30, '2025-01-01 16:20:00', '学生10', '123456', '学生姓名10', '男', 'http://localhost:8080/springboot68ozj/upload/1735466968938.jpg', '班级10', '13823888880', '773890010@qq.com', '宿舍号10');
-- ----------------------------
-- Table structure for zhaolingxinxi
-- ----------------------------
DROP TABLE IF EXISTS `zhaolingxinxi`;
CREATE TABLE `zhaolingxinxi` (
`id` bigint NOT NULL AUTO_INCREMENT COMMENT '主键',
`addtime` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
`wupinmingcheng` varchar(200) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NOT NULL COMMENT '物品名称',
`tupian` varchar(200) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NOT NULL COMMENT '图片',
`wupinleibie` varchar(200) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NOT NULL COMMENT '物品类别',
`jianshididian` varchar(200) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NOT NULL COMMENT '捡拾地点',
`jianshishijian` datetime NOT NULL COMMENT '捡拾时间',
`renlingzhuangtai` varchar(200) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NULL DEFAULT NULL COMMENT '认领状态',
`xiangximiaoshu` longtext CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NULL COMMENT '详细描述',
`xuehao` varchar(200) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NULL DEFAULT NULL COMMENT '学号',
`xueshengxingming` varchar(200) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NULL DEFAULT NULL COMMENT '学生姓名',
`shouji` varchar(200) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NULL DEFAULT NULL COMMENT '手机',
PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 191 CHARACTER SET = utf8mb3 COLLATE = utf8mb3_general_ci COMMENT = '招领信息' ROW_FORMAT = Dynamic;
-- ----------------------------
-- Records of zhaolingxinxi
-- ----------------------------
INSERT INTO `zhaolingxinxi` VALUES (181, '2025-01-01 16:20:00', '物品名称1', 'http://localhost:8080/springboot68ozj/upload/1735466637264.jpg', '物品类别1', '捡拾地点1', '2025-01-01 16:20:00', '未认领', '<p>这是对物品1的详细描述</p>', '学号001', '学生姓名1', '13800138000');
INSERT INTO `zhaolingxinxi` VALUES (182, '2025-01-01 16:20:00', '物品名称2', 'http://localhost:8080/springboot68ozj/upload/1735466637264.jpg', '物品类别2', '捡拾地点2', '2025-01-01 16:20:00', '未认领', '这是对物品2的详细描述', '学号002', '学生姓名2', '13800138001');
INSERT INTO `zhaolingxinxi` VALUES (183, '2025-01-01 16:20:00', '物品名称3', 'http://localhost:8080/springboot68ozj/upload/1735466637264.jpg', '物品类别3', '捡拾地点3', '2025-01-01 16:20:00', '未认领', '这是对物品3的详细描述', '学号003', '学生姓名3', '13800138002');
INSERT INTO `zhaolingxinxi` VALUES (184, '2025-01-01 16:20:00', '物品名称4', 'http://localhost:8080/springboot68ozj/upload/1735466637264.jpg', '物品类别4', '捡拾地点4', '2025-01-01 16:20:00', '未认领', '这是对物品4的详细描述', '学号004', '学生姓名4', '13800138003');
INSERT INTO `zhaolingxinxi` VALUES (185, '2025-01-01 16:20:00', '物品名称5', 'http://localhost:8080/springboot68ozj/upload/1735466637264.jpg', '物品类别5', '捡拾地点5', '2025-01-01 16:20:00', '未认领', '这是对物品5的详细描述', '学号005', '学生姓名5', '13800138004');
INSERT INTO `zhaolingxinxi` VALUES (186, '2025-01-01 16:20:00', '物品名称6', 'http://localhost:8080/springboot68ozj/upload/1735466637264.jpg', '物品类别6', '捡拾地点6', '2025-01-01 16:20:00', '未认领', '这是对物品6的详细描述', '学号006', '学生姓名6', '13800138005');
INSERT INTO `zhaolingxinxi` VALUES (187, '2025-01-01 16:20:00', '物品名称7', 'http://localhost:8080/springboot68ozj/upload/1735466637264.jpg', '物品类别7', '捡拾地点7', '2025-01-01 16:20:00', '未认领', '这是对物品7的详细描述', '学号007', '学生姓名7', '13800138006');
INSERT INTO `zhaolingxinxi` VALUES (188, '2025-01-01 16:20:00', '物品名称8', 'http://localhost:8080/springboot68ozj/upload/1735466637264.jpg', '物品类别8', '捡拾地点8', '2025-01-01 16:20:00', '未认领', '这是对物品8的详细描述', '学号008', '学生姓名8', '13800138007');
INSERT INTO `zhaolingxinxi` VALUES (189, '2025-01-01 16:20:00', '物品名称9', 'http://localhost:8080/springboot68ozj/upload/1735466637264.jpg', '物品类别9', '捡拾地点9', '2025-01-01 16:20:00', '未认领', '这是对物品9的详细描述', '学号009', '学生姓名9', '13800138008');
INSERT INTO `zhaolingxinxi` VALUES (190, '2025-01-01 16:20:00', '物品名称10', 'http://localhost:8080/springboot68ozj/upload/1735466637264.jpg', '物品类别10', '捡拾地点10', '2025-01-01 16:20:00', '未认领', '这是对物品10的详细描述', '学号010', '学生姓名10', '13800138009');
SET FOREIGN_KEY_CHECKS = 1;
Reference in new issue View Git Blame Copy Permalink