/*
 Navicat Premium Data Transfer

 Source Server         : local
 Source Server Type    : MySQL
 Source Server Version : 50743
 Source Host           : localhost:3306
 Source Schema         : baage_campus

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

 Date: 21/04/2024 17:56:54
*/

SET NAMES utf8mb4;
SET FOREIGN_KEY_CHECKS = 0;

-- ----------------------------
-- Table structure for bc_category
-- ----------------------------
DROP TABLE IF EXISTS `bc_category`;
CREATE TABLE `bc_category`  (
  `id` varchar(32) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '分类ID',
  `name` varchar(8) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '分类名称',
  `order_num` int(11) NULL DEFAULT 0 COMMENT '顺序',
  `create_time` datetime NULL DEFAULT NULL COMMENT '创建时间',
  `update_time` datetime NULL DEFAULT NULL COMMENT '修改时间',
  PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB CHARACTER SET = utf8 COLLATE = utf8_general_ci COMMENT = '分类' ROW_FORMAT = Dynamic;

-- ----------------------------
-- Records of bc_category
-- ----------------------------
INSERT INTO `bc_category` VALUES ('3a161aee14c34ecfad1df30cc44fb27c', '校园活动', 4, '2024-04-12 09:51:00', '2024-04-12 09:51:00');
INSERT INTO `bc_category` VALUES ('465418b619a946caacc74d22681c0d51', '二手闲置', 2, '2024-04-12 09:50:40', '2024-04-12 09:50:40');
INSERT INTO `bc_category` VALUES ('70d9ce4513ca4241ba2ba60b2e7a8500', '表白墙', 3, '2024-04-12 09:50:52', '2024-04-12 09:50:52');
INSERT INTO `bc_category` VALUES ('87f3c744eb6e4b25838ec54a9246316d', '打听求助', 1, '2024-04-12 09:50:26', '2024-04-12 09:50:26');
INSERT INTO `bc_category` VALUES ('bb35a17fa6a046adbdc1c97505b22d4b', '新鲜事', 0, '2024-04-12 09:49:19', '2024-04-12 09:49:19');

-- ----------------------------
-- Table structure for bc_comment
-- ----------------------------
DROP TABLE IF EXISTS `bc_comment`;
CREATE TABLE `bc_comment`  (
  `id` varchar(32) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '' COMMENT '主键',
  `parent_id` varchar(32) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT '0' COMMENT '父评论ID',
  `posting_id` varchar(32) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '帖子ID',
  `user_id` varchar(32) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '用户ID',
  `content` varchar(300) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '评论内容',
  `like_num` int(11) NULL DEFAULT 0 COMMENT '点赞数',
  `have_img` tinyint(4) NULL DEFAULT 0 COMMENT '是否包含图片 0不包含 1包含',
  `create_time` datetime NULL DEFAULT NULL COMMENT '创建时间',
  `update_time` datetime NULL DEFAULT NULL COMMENT '更新时间',
  `del_flag` tinyint(2) NULL DEFAULT 0 COMMENT '是否删除',
  `nick_name` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '昵称',
  `avatar_url` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '头像',
  `reply_id` varchar(32) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT '0' COMMENT '回复评论ID',
  `reply_nick_name` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '回复目标昵称',
  PRIMARY KEY (`id`) USING BTREE,
  INDEX `p_i`(`posting_id`) USING BTREE
) ENGINE = InnoDB CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = Dynamic;

-- ----------------------------
-- Records of bc_comment
-- ----------------------------
INSERT INTO `bc_comment` VALUES ('01f1faad13984b7da16c38c1706ba643', '0', '7c916d39eeda49f7bdb469b8659e2afe', 'c854700c3013460c960fc5b1ddd5fd22', '测试哈哈哈哈哈哈', 0, 0, '2024-04-16 15:15:52', '2024-04-16 15:15:52', 0, '冲动の熊猫', 'avatar/default_1.jpg', '', NULL);
INSERT INTO `bc_comment` VALUES ('03ac0c96243e4a148bf2407056ee5df6', '0', '2b00bb27ce3d4c00bb24eb6e8166b692', '00d273d4ac754ff5a0fb9577065a4095', '哈哈哈哈', 0, 0, '2024-04-20 17:40:28', '2024-04-20 17:40:28', 0, '热心肠の八阿哥', 'avatar/default_7.jpg', '', NULL);
INSERT INTO `bc_comment` VALUES ('0627f392d4284d8895704c534c61958c', '0', '7c916d39eeda49f7bdb469b8659e2afe', '00d273d4ac754ff5a0fb9577065a4095', '123123', 0, 0, '2024-04-16 16:33:54', '2024-04-16 16:33:54', 0, '热心肠の八阿哥', 'avatar/default_7.jpg', '', NULL);
INSERT INTO `bc_comment` VALUES ('0b37b81627ac4026a136f39c6b1219ba', '0', '7c916d39eeda49f7bdb469b8659e2afe', '00d273d4ac754ff5a0fb9577065a4095', '12312312', 0, 0, '2024-04-16 16:27:36', '2024-04-16 16:27:36', 0, '热心肠の八阿哥', 'avatar/default_7.jpg', '', NULL);
INSERT INTO `bc_comment` VALUES ('0bc79177ba6f402aac7341e5c4c579a4', '9d5b764ae50a4b6a9d90c32c68f7ddc3', '7c916d39eeda49f7bdb469b8659e2afe', '00d273d4ac754ff5a0fb9577065a4095', '测试哈哈哈哈哈哈2234', 0, 0, '2024-04-16 16:20:33', '2024-04-16 16:20:33', 0, '热心肠の八阿哥', 'avatar/default_7.jpg', '0', NULL);
INSERT INTO `bc_comment` VALUES ('15e85c64f3814f50a516f8587c943511', '0', '7c916d39eeda49f7bdb469b8659e2afe', '00d273d4ac754ff5a0fb9577065a4095', '测试哈哈哈哈哈哈', 0, 1, '2024-04-16 16:22:40', '2024-04-16 16:22:40', 0, '热心肠の八阿哥', 'avatar/default_7.jpg', '', NULL);
INSERT INTO `bc_comment` VALUES ('16d515fcffdb4e52bd16383edf81e03b', '0', '7c916d39eeda49f7bdb469b8659e2afe', '00d273d4ac754ff5a0fb9577065a4095', '测试12374488383\n333', 0, 1, '2024-04-16 11:49:24', '2024-04-16 11:49:24', 0, '热心肠の八阿哥', 'avatar/default_7.jpg', '', NULL);
INSERT INTO `bc_comment` VALUES ('18f24aa480a44ed6b0d60b9d49c45030', '0', '7c916d39eeda49f7bdb469b8659e2afe', 'c854700c3013460c960fc5b1ddd5fd22', '测试哈哈哈哈哈哈哈哈哈哈哈哈好', 0, 0, '2024-04-16 15:17:08', '2024-04-16 15:17:08', 0, '冲动の熊猫', 'avatar/default_1.jpg', '', NULL);
INSERT INTO `bc_comment` VALUES ('2d8be7d36dc04afc8e30c60a294858a0', '0', '7c916d39eeda49f7bdb469b8659e2afe', '00d273d4ac754ff5a0fb9577065a4095', '213123123', 0, 0, '2024-04-16 16:29:43', '2024-04-16 16:29:43', 0, '热心肠の八阿哥', 'avatar/default_7.jpg', '', NULL);
INSERT INTO `bc_comment` VALUES ('38c23f4143574f2a9df55eb3da3417b7', '9d5b764ae50a4b6a9d90c32c68f7ddc3', '7c916d39eeda49f7bdb469b8659e2afe', '00d273d4ac754ff5a0fb9577065a4095', '测试哈哈哈哈哈哈', 0, 0, '2024-04-16 16:07:54', '2024-04-16 16:07:54', 0, '热心肠の八阿哥', 'avatar/default_7.jpg', '0', NULL);
INSERT INTO `bc_comment` VALUES ('392df8ce444349259ed7971d4b7b8910', '0', '7c916d39eeda49f7bdb469b8659e2afe', 'c854700c3013460c960fc5b1ddd5fd22', '测试哈122哈哈哈哈哈1112', 0, 0, '2024-04-16 15:16:02', '2024-04-16 15:16:02', 0, '冲动の熊猫', 'avatar/default_1.jpg', '', NULL);
INSERT INTO `bc_comment` VALUES ('39c1139107f64519993c1ceb32eb3798', '0', '7c916d39eeda49f7bdb469b8659e2afe', '00d273d4ac754ff5a0fb9577065a4095', '测试<br>11111<br>2222<br>3333<br>4444<br>5555<br>', 0, 0, '2024-04-16 16:39:46', '2024-04-16 16:39:46', 0, '热心肠の八阿哥', 'avatar/default_7.jpg', '', NULL);
INSERT INTO `bc_comment` VALUES ('3ca94b6c7ba045ad8e32ecad57313b27', '6845681416c7428e9e2f1dd02abf796e', '7c916d39eeda49f7bdb469b8659e2afe', '00d273d4ac754ff5a0fb9577065a4095', '1122111', 0, 0, '2024-04-16 16:00:51', '2024-04-16 16:00:51', 0, '热心肠の八阿哥', 'avatar/default_7.jpg', '', NULL);
INSERT INTO `bc_comment` VALUES ('43c7adae6e4d4b3db92504751fdefa44', '6845681416c7428e9e2f1dd02abf796e', '7c916d39eeda49f7bdb469b8659e2afe', '00d273d4ac754ff5a0fb9577065a4095', '1111111', 0, 0, '2024-04-16 16:01:15', '2024-04-16 16:01:15', 0, '热心肠の八阿哥', 'avatar/default_7.jpg', '0', NULL);
INSERT INTO `bc_comment` VALUES ('4571ed0dc3094cee8bbd52835c5643ed', '9d5b764ae50a4b6a9d90c32c68f7ddc3', '7c916d39eeda49f7bdb469b8659e2afe', '7aa7788540014b6f8c05e45b36a2ada0', '也就那样', 0, 0, '2024-04-16 14:48:05', '2024-04-16 14:48:05', 0, '乖乖の足球', 'avatar/default_2.jpg', 'a7273b3c655e4475a9917fb846d9aa0f', '乖乖の足球');
INSERT INTO `bc_comment` VALUES ('6230607e222f46a781a7d8c405d5636b', '0', '7c916d39eeda49f7bdb469b8659e2afe', '00d273d4ac754ff5a0fb9577065a4095', 'xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx', 0, 0, '2024-04-16 16:37:21', '2024-04-16 16:37:21', 0, '热心肠の八阿哥', 'avatar/default_7.jpg', '', NULL);
INSERT INTO `bc_comment` VALUES ('6845681416c7428e9e2f1dd02abf796e', '0', '7c916d39eeda49f7bdb469b8659e2afe', '00d273d4ac754ff5a0fb9577065a4095', '带图片\n测试评论\n213123\n测试1111\n', 0, 1, '2024-04-16 10:21:59', '2024-04-16 10:21:59', 0, '热心肠の八阿哥', 'avatar/default_7.jpg', '', NULL);
INSERT INTO `bc_comment` VALUES ('6fdf32f7c5b64867872430ec7c80252f', '0', '7c916d39eeda49f7bdb469b8659e2afe', 'c854700c3013460c960fc5b1ddd5fd22', '测试哈哈哈哈哈哈', 0, 0, '2024-04-16 15:15:48', '2024-04-16 15:15:48', 0, '冲动の熊猫', 'avatar/default_1.jpg', '', NULL);
INSERT INTO `bc_comment` VALUES ('78ef72d40263457da6f5a6ae2ee3b689', 'b162dd480e864fe38d110b3d9028df1e', '2b00bb27ce3d4c00bb24eb6e8166b692', '7aa7788540014b6f8c05e45b36a2ada0', '测试子回复=========================================', 0, 0, '2024-04-16 12:47:00', '2024-04-16 12:47:00', 0, '乖乖の足球', 'avatar/default_2.jpg', '', NULL);
INSERT INTO `bc_comment` VALUES ('7a057f0be92740c6bc6ff7b3e6a4da80', 'b162dd480e864fe38d110b3d9028df1e', '2b00bb27ce3d4c00bb24eb6e8166b692', '00d273d4ac754ff5a0fb9577065a4095', '测试二次回复', 0, 0, '2024-04-16 13:23:11', '2024-04-16 13:23:11', 0, '热心肠の八阿哥', 'avatar/default_7.jpg', '78ef72d40263457da6f5a6ae2ee3b689', '乖乖の足球');
INSERT INTO `bc_comment` VALUES ('7ec88bf160864c05a80fea2b01f467ee', '0', '7c916d39eeda49f7bdb469b8659e2afe', 'c854700c3013460c960fc5b1ddd5fd22', '测试哈亲亲亲亲亲哈哈哈1112', 0, 0, '2024-04-16 15:16:15', '2024-04-16 15:16:15', 0, '冲动の熊猫', 'avatar/default_1.jpg', '', NULL);
INSERT INTO `bc_comment` VALUES ('7fd328863566443287ef813c419519fe', '0', '2b00bb27ce3d4c00bb24eb6e8166b692', '00d273d4ac754ff5a0fb9577065a4095', '测试1222', 0, 0, '2024-04-20 17:40:35', '2024-04-20 17:40:35', 0, '热心肠の八阿哥', 'avatar/default_7.jpg', '', NULL);
INSERT INTO `bc_comment` VALUES ('9411e8b920f14e0c9608cf1db0009548', '0', '7c916d39eeda49f7bdb469b8659e2afe', '00d273d4ac754ff5a0fb9577065a4095', '测试哈哈哈哈哈哈2234', 0, 0, '2024-04-16 16:20:23', '2024-04-16 16:20:23', 0, '热心肠の八阿哥', 'avatar/default_7.jpg', '', NULL);
INSERT INTO `bc_comment` VALUES ('9a38e932602f4fc180d1c4603bd0c0d3', '0', '7c916d39eeda49f7bdb469b8659e2afe', 'c854700c3013460c960fc5b1ddd5fd22', '测试哈哈哈哈哈哈', 0, 0, '2024-04-16 15:15:46', '2024-04-16 15:15:46', 0, '冲动の熊猫', 'avatar/default_1.jpg', '', NULL);
INSERT INTO `bc_comment` VALUES ('9d5b764ae50a4b6a9d90c32c68f7ddc3', '0', '7c916d39eeda49f7bdb469b8659e2afe', '00d273d4ac754ff5a0fb9577065a4095', '测试评论\n213123\n测试1111', 0, 0, '2024-04-16 10:21:26', '2024-04-16 10:21:26', 0, '热心肠の八阿哥', 'avatar/default_7.jpg', '', NULL);
INSERT INTO `bc_comment` VALUES ('a7273b3c655e4475a9917fb846d9aa0f', '9d5b764ae50a4b6a9d90c32c68f7ddc3', '7c916d39eeda49f7bdb469b8659e2afe', '7aa7788540014b6f8c05e45b36a2ada0', '哈哈哈哈，怎么样', 0, 1, '2024-04-16 14:47:52', '2024-04-16 14:47:52', 0, '乖乖の足球', 'avatar/default_2.jpg', '', NULL);
INSERT INTO `bc_comment` VALUES ('af5bc86a1e1a4134aa8efceb50b08371', '0', '7c916d39eeda49f7bdb469b8659e2afe', 'c854700c3013460c960fc5b1ddd5fd22', '测试哈哈哈哈哈哈', 0, 0, '2024-04-16 15:15:44', '2024-04-16 15:15:44', 0, '冲动の熊猫', 'avatar/default_1.jpg', '', NULL);
INSERT INTO `bc_comment` VALUES ('b162dd480e864fe38d110b3d9028df1e', '0', '2b00bb27ce3d4c00bb24eb6e8166b692', '00d273d4ac754ff5a0fb9577065a4095', '评论测试哈哈哈哈哈哈哈哈哈哈哈哈好', 0, 1, '2024-04-16 11:52:01', '2024-04-16 11:52:01', 0, '热心肠の八阿哥', 'avatar/default_7.jpg', '', NULL);
INSERT INTO `bc_comment` VALUES ('b4aaaa916d72438989df325574ffc872', '0', '7c916d39eeda49f7bdb469b8659e2afe', 'c854700c3013460c960fc5b1ddd5fd22', '测试哈哈哈哈哈哈', 0, 0, '2024-04-16 15:15:50', '2024-04-16 15:15:50', 0, '冲动の熊猫', 'avatar/default_1.jpg', '', NULL);
INSERT INTO `bc_comment` VALUES ('c6b5460157054a8b972d793326e5c3bc', '0', '8420cdc38fa743bca9c17032df40253c', '00d273d4ac754ff5a0fb9577065a4095', '测试123131231<br>测试123123123', 0, 1, '2024-04-17 20:51:50', '2024-04-17 20:51:50', 0, '热心肠の八阿哥', 'avatar/default_7.jpg', '', NULL);
INSERT INTO `bc_comment` VALUES ('c759585cf7e84e9eaddf4d4f1a4cec16', '0', '7c916d39eeda49f7bdb469b8659e2afe', '00d273d4ac754ff5a0fb9577065a4095', '测试哈哈哈哈', 0, 0, '2024-04-16 16:26:09', '2024-04-16 16:26:09', 0, '热心肠の八阿哥', 'avatar/default_7.jpg', '', NULL);
INSERT INTO `bc_comment` VALUES ('c79c8936938941369ca7234adb32e08b', 'af5bc86a1e1a4134aa8efceb50b08371', '7c916d39eeda49f7bdb469b8659e2afe', '00d273d4ac754ff5a0fb9577065a4095', '哈哈哈哈', 0, 1, '2024-04-16 16:23:25', '2024-04-16 16:23:25', 0, '热心肠の八阿哥', 'avatar/default_7.jpg', '0', NULL);
INSERT INTO `bc_comment` VALUES ('ca94c7072f5948f587921df4968cb44a', '0', '7c916d39eeda49f7bdb469b8659e2afe', 'c854700c3013460c960fc5b1ddd5fd22', '112333', 0, 0, '2024-04-16 15:17:23', '2024-04-16 15:17:23', 0, '冲动の熊猫', 'avatar/default_1.jpg', '', NULL);
INSERT INTO `bc_comment` VALUES ('cf0eef02b27248ca8c16ec75db0554c1', '0', '7c916d39eeda49f7bdb469b8659e2afe', '00d273d4ac754ff5a0fb9577065a4095', '哈哈哈哈哈', 0, 0, '2024-04-16 16:18:29', '2024-04-16 16:18:29', 0, '热心肠の八阿哥', 'avatar/default_7.jpg', '', NULL);
INSERT INTO `bc_comment` VALUES ('d2e7add3219d41708d55be93b9cef0c9', 'af5bc86a1e1a4134aa8efceb50b08371', '7c916d39eeda49f7bdb469b8659e2afe', '00d273d4ac754ff5a0fb9577065a4095', '测试1227378383', 0, 0, '2024-04-16 16:03:26', '2024-04-16 16:03:26', 0, '热心肠の八阿哥', 'avatar/default_7.jpg', '', NULL);
INSERT INTO `bc_comment` VALUES ('d4b433978d704b12be5bcd9ee91bd969', '0', '7c916d39eeda49f7bdb469b8659e2afe', 'c854700c3013460c960fc5b1ddd5fd22', '测亲亲亲亲哈哈哈1112', 0, 0, '2024-04-16 15:16:19', '2024-04-16 15:16:19', 0, '冲动の熊猫', 'avatar/default_1.jpg', '', NULL);
INSERT INTO `bc_comment` VALUES ('dedeb67e04da4984a640cff57bdd1ff9', '0', '7c916d39eeda49f7bdb469b8659e2afe', 'c854700c3013460c960fc5b1ddd5fd22', '测试哈122哈哈蛇姐哈哈哈1112', 0, 0, '2024-04-16 15:16:07', '2024-04-16 15:16:07', 0, '冲动の熊猫', 'avatar/default_1.jpg', '', NULL);
INSERT INTO `bc_comment` VALUES ('e788d642564447228d5f7704946b9e7d', '0', '7c916d39eeda49f7bdb469b8659e2afe', '00d273d4ac754ff5a0fb9577065a4095', '123123', 0, 0, '2024-04-19 17:11:44', '2024-04-19 17:11:44', 0, '热心肠の八阿哥', 'avatar/default_7.jpg', '', NULL);
INSERT INTO `bc_comment` VALUES ('fbb29153ebaf4fac95e2b46b367a092a', '0', '7c916d39eeda49f7bdb469b8659e2afe', 'c854700c3013460c960fc5b1ddd5fd22', '测试哈哈哈哈哈哈1112', 0, 0, '2024-04-16 15:15:57', '2024-04-16 15:15:57', 0, '冲动の熊猫', 'avatar/default_1.jpg', '', NULL);
INSERT INTO `bc_comment` VALUES ('fc85f58921dd4c07afbb93689a140b9c', '9d5b764ae50a4b6a9d90c32c68f7ddc3', '7c916d39eeda49f7bdb469b8659e2afe', '00d273d4ac754ff5a0fb9577065a4095', '112333', 0, 0, '2024-04-16 16:01:29', '2024-04-16 16:01:29', 0, '热心肠の八阿哥', 'avatar/default_7.jpg', '4571ed0dc3094cee8bbd52835c5643ed', '乖乖の足球');

-- ----------------------------
-- Table structure for bc_comment_img
-- ----------------------------
DROP TABLE IF EXISTS `bc_comment_img`;
CREATE TABLE `bc_comment_img`  (
  `comment_id` varchar(32) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '评论ID',
  `img_path` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '图片路径',
  `del_flag` tinyint(2) NULL DEFAULT 0 COMMENT '是否删除 0:未删除 1:已删除'
) ENGINE = InnoDB CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = Dynamic;

-- ----------------------------
-- Records of bc_comment_img
-- ----------------------------
INSERT INTO `bc_comment_img` VALUES ('6845681416c7428e9e2f1dd02abf796e', 'default/2024/04/16/0a5a536351d740548a6309fb8b0abbb7.png', 0);
INSERT INTO `bc_comment_img` VALUES ('16d515fcffdb4e52bd16383edf81e03b', 'default/2024/04/16/77094ac5f98246dd9c694298bc38ef88.jpg', 0);
INSERT INTO `bc_comment_img` VALUES ('16d515fcffdb4e52bd16383edf81e03b', 'default/2024/04/16/0c65eb9830704b95852fd7dd242d1178.jpg', 0);
INSERT INTO `bc_comment_img` VALUES ('16d515fcffdb4e52bd16383edf81e03b', 'default/2024/04/16/d2bac636947e4af3a20655c748e696d4.jpg', 0);
INSERT INTO `bc_comment_img` VALUES ('16d515fcffdb4e52bd16383edf81e03b', 'default/2024/04/16/d49641b52aa1427b8ec2fda6d2eb8619.jpg', 0);
INSERT INTO `bc_comment_img` VALUES ('16d515fcffdb4e52bd16383edf81e03b', 'default/2024/04/16/bad76dc0e0d742a79fd2089a7907845f.jpg', 0);
INSERT INTO `bc_comment_img` VALUES ('b162dd480e864fe38d110b3d9028df1e', 'default/2024/04/16/b8966fb9fc424d1cb4bad27404dd4c52.jpg', 0);
INSERT INTO `bc_comment_img` VALUES ('b162dd480e864fe38d110b3d9028df1e', 'default/2024/04/16/45fc2f3e28a443fabdbf9ed695c4f2b8.jpg', 0);
INSERT INTO `bc_comment_img` VALUES ('b162dd480e864fe38d110b3d9028df1e', 'default/2024/04/16/4a519dfd70964c02934c2fdc03938d57.jpg', 0);
INSERT INTO `bc_comment_img` VALUES ('b162dd480e864fe38d110b3d9028df1e', 'default/2024/04/16/e3004abb47f846e48bf216f86286ce8e.jpg', 0);
INSERT INTO `bc_comment_img` VALUES ('b162dd480e864fe38d110b3d9028df1e', 'default/2024/04/16/c4773694f1574f2bb359773c1f273720.jpg', 0);
INSERT INTO `bc_comment_img` VALUES ('15e85c64f3814f50a516f8587c943511', 'default/2024/04/16/12329a7536ee45b1952c0d0f89665147.jpg', 0);
INSERT INTO `bc_comment_img` VALUES ('c79c8936938941369ca7234adb32e08b', 'default/2024/04/16/970cbe3d512947af8dbe637ed5021bbc.jpg', 0);
INSERT INTO `bc_comment_img` VALUES ('c6b5460157054a8b972d793326e5c3bc', 'default/2024/04/17/862067781aab44ceb861d44de2f1772f.png', 0);
INSERT INTO `bc_comment_img` VALUES ('c6b5460157054a8b972d793326e5c3bc', 'default/2024/04/17/a9e998a9bb494489b278141af01fab91.jpg', 0);

-- ----------------------------
-- Table structure for bc_posting
-- ----------------------------
DROP TABLE IF EXISTS `bc_posting`;
CREATE TABLE `bc_posting`  (
  `id` varchar(32) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '内容主键',
  `user_id` varchar(32) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '用户id',
  `category_id` varchar(32) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '分类id',
  `abstract_content` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '内容摘要',
  `like_num` int(11) NULL DEFAULT 0 COMMENT '喜欢数',
  `read_num` int(11) NULL DEFAULT 0 COMMENT '阅读数',
  `img_num` int(11) NULL DEFAULT 0 COMMENT '图片数',
  `create_time` datetime NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
  `update_time` datetime NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT '更新时间',
  `status` tinyint(2) NULL DEFAULT 0 COMMENT '状态：0:默认 1:已完结',
  `have_img` tinyint(2) NULL DEFAULT 0 COMMENT '包含图片 0:不包含 1:包含',
  `del_flag` tinyint(2) NULL DEFAULT 0 COMMENT '是否删除 0:未删除 1:已删除',
  `hot_score` 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 bc_posting
-- ----------------------------
INSERT INTO `bc_posting` VALUES ('1865995b620a4c5aaf188658bc4b28cb', '00d273d4ac754ff5a0fb9577065a4095', 'bb35a17fa6a046adbdc1c97505b22d4b', '111111111', 7, 233, 1, '2024-04-19 08:49:44', '2024-04-21 16:50:00', 0, 1, 0, 50.30);
INSERT INTO `bc_posting` VALUES ('19bb5a0c83e54b22b341270a88abc4e7', '00d273d4ac754ff5a0fb9577065a4095', '87f3c744eb6e4b25838ec54a9246316d', 'basadasdadad1231<br>123123123', 0, 323, 0, '2024-04-19 23:43:29', '2024-04-21 16:43:30', 0, 0, 0, 67.70);
INSERT INTO `bc_posting` VALUES ('2b00bb27ce3d4c00bb24eb6e8166b692', '00d273d4ac754ff5a0fb9577065a4095', 'bb35a17fa6a046adbdc1c97505b22d4b', '测试12273737373838383838<br>1237377373<br>243883838<br>334848848383939<br>3344949949谁对诶诶诶', 1, 365, 5, '2024-04-19 17:11:49', '2024-04-21 17:12:00', 0, 1, 0, 77.70);
INSERT INTO `bc_posting` VALUES ('2dfd8cf353a549d4acec1955aa75db3b', '00d273d4ac754ff5a0fb9577065a4095', 'bb35a17fa6a046adbdc1c97505b22d4b', '123123', 6, 8, 1, '2024-04-13 23:29:04', '2024-04-21 13:41:42', 0, 1, 0, 0.00);
INSERT INTO `bc_posting` VALUES ('336fbf058b1b40c68c2b354b2876fecf', '00d273d4ac754ff5a0fb9577065a4095', '87f3c744eb6e4b25838ec54a9246316d', '123123', 0, 0, 0, '2024-04-20 23:39:34', '2024-04-21 17:40:00', 0, 0, 0, 5.40);
INSERT INTO `bc_posting` VALUES ('378a5a49d16c43f0b13f60d12e1d25a4', '00d273d4ac754ff5a0fb9577065a4095', 'bb35a17fa6a046adbdc1c97505b22d4b', '213132<br>12312<br>31231', 35, 0, 2, '2024-04-20 23:19:14', '2024-04-21 17:19:30', 0, 1, 0, 15.90);
INSERT INTO `bc_posting` VALUES ('4ece2c0ba2354bd0afe4b6d2c50b51fd', 'ff452408ce7548ada4c2123c2b647a85', '87f3c744eb6e4b25838ec54a9246316d', '测试1238389339', 1, 0, 0, '2024-04-13 23:59:37', '2024-04-21 13:41:44', 0, 0, 0, 0.00);
INSERT INTO `bc_posting` VALUES ('4fd3f15b66bf4a8c8a276842d364dae1', '00d273d4ac754ff5a0fb9577065a4095', 'bb35a17fa6a046adbdc1c97505b22d4b', '1231313', 3, 0, 0, '2024-04-12 23:03:47', '2024-04-21 13:41:44', 0, 0, 0, 0.00);
INSERT INTO `bc_posting` VALUES ('66b40b9e28be43e29e0864d4c5cef152', '00d273d4ac754ff5a0fb9577065a4095', 'bb35a17fa6a046adbdc1c97505b22d4b', '测试1223773733783383', 43, 0, 1, '2024-04-13 21:46:53', '2024-04-21 13:41:45', 0, 1, 0, 0.00);
INSERT INTO `bc_posting` VALUES ('6d447a5415e14a6cb87b1e310ac57b0f', '00d273d4ac754ff5a0fb9577065a4095', 'bb35a17fa6a046adbdc1c97505b22d4b', '12313131312', 1, 295, 2, '2024-04-17 08:49:31', '2024-04-21 13:41:45', 0, 1, 0, 0.00);
INSERT INTO `bc_posting` VALUES ('6f3b1d9bebe640878d7dd5d6a5861abc', '00d273d4ac754ff5a0fb9577065a4095', '87f3c744eb6e4b25838ec54a9246316d', '有没有平时可以聊聊天的女生，不需要每天聊的事无巨细，日常就行，问我身高或照片啥的我也不介意，对方我也不介意，就交个朋友，认识久了你喜欢可以谈，不谈也可以做个朋友，周末也可以吃吃饭，假期一起出去玩呀，就...', 1, 1, 5, '2024-04-14 16:48:55', '2024-04-21 13:41:45', 0, 1, 0, 0.00);
INSERT INTO `bc_posting` VALUES ('75d31fe8c7664591a48a0493560af719', '00d273d4ac754ff5a0fb9577065a4095', '87f3c744eb6e4b25838ec54a9246316d', '123131313', 346, 0, 0, '2024-04-13 23:52:11', '2024-04-21 14:00:00', 0, 0, 0, 0.00);
INSERT INTO `bc_posting` VALUES ('76c3c191b7bc455a8f1487cde59ae082', '00d273d4ac754ff5a0fb9577065a4095', 'bb35a17fa6a046adbdc1c97505b22d4b', 'ces\n12333\n12334\n测试\n533344', 0, 0, 0, '2024-04-13 22:02:39', '2024-04-21 13:41:46', 0, 0, 0, 0.00);
INSERT INTO `bc_posting` VALUES ('7c916d39eeda49f7bdb469b8659e2afe', '00d273d4ac754ff5a0fb9577065a4095', 'bb35a17fa6a046adbdc1c97505b22d4b', '测试1223334<br>2333”', 16, 49, 0, '2024-04-14 17:21:20', '2024-04-21 13:41:47', 0, 0, 0, 0.00);
INSERT INTO `bc_posting` VALUES ('7d342b3818cd443d974e4428ec5ccabe', '00d273d4ac754ff5a0fb9577065a4095', '87f3c744eb6e4b25838ec54a9246316d', '12323<br>12312<br>123123', 5, 0, 1, '2024-04-13 23:48:54', '2024-04-21 13:41:47', 0, 1, 0, 0.00);
INSERT INTO `bc_posting` VALUES ('8420cdc38fa743bca9c17032df40253c', '00d273d4ac754ff5a0fb9577065a4095', '87f3c744eb6e4b25838ec54a9246316d', '我要吐槽一下我们学校的清洁问题！我真是服了，每次走在校园里，到处都是烟蒂、塑料袋和垃圾，简直就像是垃圾场一样！难道我们的学校是给垃圾专门开设的吗？<br><br>别以为清洁工会帮忙解决问题，他们只管大路上的，小路...', 1, 0, 1, '2024-04-14 16:34:03', '2024-04-21 13:41:47', 0, 1, 0, 0.00);
INSERT INTO `bc_posting` VALUES ('87b0a64194e841e68c16cd6639993522', '00d273d4ac754ff5a0fb9577065a4095', 'bb35a17fa6a046adbdc1c97505b22d4b', '12313131312', 0, 0, 2, '2024-04-13 08:49:10', '2024-04-21 13:41:48', 0, 1, 0, 0.00);
INSERT INTO `bc_posting` VALUES ('8b504505aeb04173a55a7f081f8697d1', '00d273d4ac754ff5a0fb9577065a4095', 'bb35a17fa6a046adbdc1c97505b22d4b', '12313132', 3, 0, 0, '2024-04-13 23:52:24', '2024-04-21 13:41:49', 0, 0, 0, 0.00);
INSERT INTO `bc_posting` VALUES ('905441c02f2a4417b208783f7a7edc57', '00d273d4ac754ff5a0fb9577065a4095', '87f3c744eb6e4b25838ec54a9246316d', '123123123', 52, 0, 0, '2024-04-13 23:41:28', '2024-04-21 13:41:49', 0, 0, 0, 0.00);
INSERT INTO `bc_posting` VALUES ('936ca04dd55946f9a4de9e6d17eabb34', '00d273d4ac754ff5a0fb9577065a4095', 'bb35a17fa6a046adbdc1c97505b22d4b', '1231313<br>12313131', 53, 0, 1, '2024-04-13 23:22:40', '2024-04-21 13:41:49', 0, 1, 0, 0.00);
INSERT INTO `bc_posting` VALUES ('a5809729ce494d9eadb9f87be393d005', '00d273d4ac754ff5a0fb9577065a4095', 'bb35a17fa6a046adbdc1c97505b22d4b', '嘿，亲爱的校友们！今天我想和大家分享一段关于春日校园的美好时光。在温暖的阳光下，我踏着轻快的步伐漫步在校园的小径上，感受着春天的气息。刚刚进入校园，我就被那一片', 3, 0, 0, '2024-04-12 14:29:28', '2024-04-21 13:41:50', 0, 0, 0, 0.00);
INSERT INTO `bc_posting` VALUES ('a74917605d454f54b5882d07aec7ded2', '00d273d4ac754ff5a0fb9577065a4095', 'bb35a17fa6a046adbdc1c97505b22d4b', '123123123', 2, 0, 0, '2024-04-13 23:46:55', '2024-04-21 13:41:50', 0, 0, 0, 0.00);
INSERT INTO `bc_posting` VALUES ('ae7747cf63bb4b11819e6d99a418f2f0', '00d273d4ac754ff5a0fb9577065a4095', 'bb35a17fa6a046adbdc1c97505b22d4b', 'baage', 23, 0, 0, '2024-04-12 22:44:34', '2024-04-21 13:41:51', 0, 0, 0, 0.00);
INSERT INTO `bc_posting` VALUES ('b8e9e5b348524e9999dd995ad107f4c0', '00d273d4ac754ff5a0fb9577065a4095', 'bb35a17fa6a046adbdc1c97505b22d4b', '12313123<br>12312<br>312<br>3123', 324, 0, 0, '2024-04-13 23:29:58', '2024-04-21 13:41:51', 0, 0, 0, 0.00);
INSERT INTO `bc_posting` VALUES ('bca009c3856b45238b2e1445afc2e64c', '00d273d4ac754ff5a0fb9577065a4095', 'bb35a17fa6a046adbdc1c97505b22d4b', '测试1234748383', 2, 0, 0, '2024-04-12 22:50:22', '2024-04-21 13:41:51', 0, 0, 0, 0.00);
INSERT INTO `bc_posting` VALUES ('d402bcb8a87a48679d53d71a038ed402', '00d273d4ac754ff5a0fb9577065a4095', 'bb35a17fa6a046adbdc1c97505b22d4b', '测试1245678\n换行测试\n111111', 6, 0, 0, '2024-04-12 22:48:39', '2024-04-21 13:41:52', 0, 0, 0, 0.00);
INSERT INTO `bc_posting` VALUES ('ec07874e397341c89c96dab72da452ab', '00d273d4ac754ff5a0fb9577065a4095', 'bb35a17fa6a046adbdc1c97505b22d4b', '\"大家好！最近校园里有个超级有趣的活动，就是由学生会组织的一场寻宝游戏！整个校园都被布置成了一个巨大的宝藏地图，学生们要分组合作，通过解谜和寻找线索来找到隐藏在', 1, 0, 2, '2024-04-14 14:59:01', '2024-04-21 13:41:52', 0, 1, 0, 0.00);
INSERT INTO `bc_posting` VALUES ('ef2d3d0f5f524398bb50b61c8f589611', '00d273d4ac754ff5a0fb9577065a4095', 'bb35a17fa6a046adbdc1c97505b22d4b', '测试1111111', 5, 0, 4, '2024-04-12 23:06:30', '2024-04-21 13:41:52', 0, 1, 0, 0.00);
INSERT INTO `bc_posting` VALUES ('f1f4c5ed10b3481dbff75f8cd2f956f6', '00d273d4ac754ff5a0fb9577065a4095', '87f3c744eb6e4b25838ec54a9246316d', '12737383838', 4, 0, 2, '2024-04-13 08:53:08', '2024-04-21 13:41:54', 0, 1, 0, 0.00);

-- ----------------------------
-- Table structure for bc_posting_detail
-- ----------------------------
DROP TABLE IF EXISTS `bc_posting_detail`;
CREATE TABLE `bc_posting_detail`  (
  `posting_id` varchar(32) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '帖子ID',
  `detail` varchar(3000) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '帖子详情',
  `contact_type` tinyint(2) NULL DEFAULT NULL COMMENT '联系方式类型',
  `contact` varchar(32) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '联系方式',
  PRIMARY KEY (`posting_id`) USING BTREE
) ENGINE = InnoDB CHARACTER SET = utf8 COLLATE = utf8_general_ci COMMENT = '帖子详情' ROW_FORMAT = Dynamic;

-- ----------------------------
-- Records of bc_posting_detail
-- ----------------------------
INSERT INTO `bc_posting_detail` VALUES ('1865995b620a4c5aaf188658bc4b28cb', '12313131312', NULL, NULL);
INSERT INTO `bc_posting_detail` VALUES ('19bb5a0c83e54b22b341270a88abc4e7', 'basadasdadad1231<br>123123123', NULL, NULL);
INSERT INTO `bc_posting_detail` VALUES ('2b00bb27ce3d4c00bb24eb6e8166b692', '测试12273737373838383838<br>1237377373<br>243883838<br>334848848383939<br>3344949949谁对诶诶诶', NULL, NULL);
INSERT INTO `bc_posting_detail` VALUES ('2dfd8cf353a549d4acec1955aa75db3b', '123123', NULL, NULL);
INSERT INTO `bc_posting_detail` VALUES ('336fbf058b1b40c68c2b354b2876fecf', '123123', NULL, NULL);
INSERT INTO `bc_posting_detail` VALUES ('378a5a49d16c43f0b13f60d12e1d25a4', '213132<br>12312<br>31231', NULL, NULL);
INSERT INTO `bc_posting_detail` VALUES ('4ece2c0ba2354bd0afe4b6d2c50b51fd', '测试1238389339', NULL, NULL);
INSERT INTO `bc_posting_detail` VALUES ('4fd3f15b66bf4a8c8a276842d364dae1', '1231313', NULL, NULL);
INSERT INTO `bc_posting_detail` VALUES ('66b40b9e28be43e29e0864d4c5cef152', '测试1223773733783383', NULL, NULL);
INSERT INTO `bc_posting_detail` VALUES ('6d447a5415e14a6cb87b1e310ac57b0f', '12313131312', NULL, NULL);
INSERT INTO `bc_posting_detail` VALUES ('6f3b1d9bebe640878d7dd5d6a5861abc', '有没有平时可以聊聊天的女生，不需要每天聊的事无巨细，日常就行，问我身高或照片啥的我也不介意，对方我也不介意，就交个朋友，认识久了你喜欢可以谈，不谈也可以做个朋友，周末也可以吃吃饭，假期一起出去玩呀，就做个吃饭旅游搭子也没问题', NULL, NULL);
INSERT INTO `bc_posting_detail` VALUES ('75d31fe8c7664591a48a0493560af719', '123131313', NULL, NULL);
INSERT INTO `bc_posting_detail` VALUES ('76c3c191b7bc455a8f1487cde59ae082', 'ces<br>12333<br>12334<br>测试<br>533344', NULL, NULL);
INSERT INTO `bc_posting_detail` VALUES ('7c916d39eeda49f7bdb469b8659e2afe', '测试1223334<br>2333”', NULL, NULL);
INSERT INTO `bc_posting_detail` VALUES ('7d342b3818cd443d974e4428ec5ccabe', '12323<br>12312<br>123123', NULL, NULL);
INSERT INTO `bc_posting_detail` VALUES ('8420cdc38fa743bca9c17032df40253c', '我要吐槽一下我们学校的清洁问题！我真是服了，每次走在校园里，到处都是烟蒂、塑料袋和垃圾，简直就像是垃圾场一样！难道我们的学校是给垃圾专门开设的吗？<br><br>别以为清洁工会帮忙解决问题，他们只管大路上的，小路、角落里的垃圾可不管。看着那些飘来飘去的垃圾袋，我真是无语了！<br><br>更气人的是，有些同学就是不懂得爱护环境，吃完东西就随手扔，随手丢一块垃圾，完全不顾别人的感受。哎，难道垃圾桶离你们那么远吗？<br><br>我们学校急需一场大扫除啊！不然，再这样下去，我们的校园就要成为垃圾的天下了！', NULL, NULL);
INSERT INTO `bc_posting_detail` VALUES ('87b0a64194e841e68c16cd6639993522', '12313131312', NULL, NULL);
INSERT INTO `bc_posting_detail` VALUES ('8b504505aeb04173a55a7f081f8697d1', '12313132', NULL, NULL);
INSERT INTO `bc_posting_detail` VALUES ('905441c02f2a4417b208783f7a7edc57', '123123123', NULL, NULL);
INSERT INTO `bc_posting_detail` VALUES ('936ca04dd55946f9a4de9e6d17eabb34', '1231313<br>12313131', NULL, NULL);
INSERT INTO `bc_posting_detail` VALUES ('a5809729ce494d9eadb9f87be393d005', '嘿，亲爱的校友们！今天我想和大家分享一段关于春日校园的美好时光。在温暖的阳光下，我踏着轻快的步伐漫步在校园的小径上，感受着春天的气息。刚刚进入校园，我就被那一片片嫩绿的树叶和绽放的鲜花所吸引。樱花树下，一群同学正在拍照留念，欢声笑语回荡在空气中。我也加入了他们，与好友们一起留下了这美好的瞬间。沿着湖边的小路走去，微风拂过湖面，荷叶轻轻摇曳着。几只可爱的小鸭子在湖中嬉戏，不时发出欢快的叫声。我停下脚步，静静地欣赏着这一切，心情顿时愉悦了许多。午后时光，我来到了校园里的图书馆。一阵清香扑面而来，原来是图书馆旁的茶馆正在举办茶艺表演。一位老师傅手法娴熟地为我们泡了一杯香气扑鼻的茶，仿佛把春天的清新味道都注入了其中。夕阳西下，我漫步回到宿舍，满心欢喜地回顾这美好的一天。春日校园漫步，不仅让我感受到了大自然的美好，也与同学们分享了快乐与欢笑。希望大家也能在校园里发现属于自己的美好时光，享受春天的温暖与美丽！', NULL, NULL);
INSERT INTO `bc_posting_detail` VALUES ('a74917605d454f54b5882d07aec7ded2', '123123123', NULL, NULL);
INSERT INTO `bc_posting_detail` VALUES ('ae7747cf63bb4b11819e6d99a418f2f0', 'baage', NULL, NULL);
INSERT INTO `bc_posting_detail` VALUES ('b8e9e5b348524e9999dd995ad107f4c0', '12313123<br>12312<br>312<br>3123', NULL, NULL);
INSERT INTO `bc_posting_detail` VALUES ('bca009c3856b45238b2e1445afc2e64c', '测试1234748383', NULL, NULL);
INSERT INTO `bc_posting_detail` VALUES ('d402bcb8a87a48679d53d71a038ed402', '测试1245678\n换行测试\n111111', NULL, NULL);
INSERT INTO `bc_posting_detail` VALUES ('ec07874e397341c89c96dab72da452ab', '\"大家好！最近校园里有个超级有趣的活动，就是由学生会组织的一场寻宝游戏！整个校园都被布置成了一个巨大的宝藏地图，学生们要分组合作，通过解谜和寻找线索来找到隐藏在校园各处的宝藏。这不仅是锻炼团队合作能力，还增加了校园生活的乐趣！<br><br>据说，宝藏不仅有各种小奖品，还有一些神秘大奖等着幸运的队伍发现。而且，参与的队伍不仅仅是同学之间的组合，还有老师和工作人员的队伍，大家都兴致勃勃地投入其中。<br><br>这次寻宝活动不仅丰富了我们的课余生活，也增进了同学们之间的交流和友谊。希望大家能够积极参与，一起寻找属于我们的宝藏，让校园生活更加丰富多彩！\"', NULL, NULL);
INSERT INTO `bc_posting_detail` VALUES ('ef2d3d0f5f524398bb50b61c8f589611', '测试1111111', NULL, NULL);
INSERT INTO `bc_posting_detail` VALUES ('f1f4c5ed10b3481dbff75f8cd2f956f6', '12737383838', NULL, NULL);

-- ----------------------------
-- Table structure for bc_posting_img
-- ----------------------------
DROP TABLE IF EXISTS `bc_posting_img`;
CREATE TABLE `bc_posting_img`  (
  `posting_id` varchar(32) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '帖子ID',
  `img_path` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '图片路径',
  `del_flag` tinyint(2) NULL DEFAULT 0 COMMENT '是否删除 0:未删除 1:已删除'
) ENGINE = InnoDB CHARACTER SET = utf8 COLLATE = utf8_general_ci COMMENT = '帖子图片' ROW_FORMAT = Dynamic;

-- ----------------------------
-- Records of bc_posting_img
-- ----------------------------
INSERT INTO `bc_posting_img` VALUES ('8420cdc38fa743bca9c17032df40253c', 'default/2024/04/14/1f61c3f618a8492bbff49d5b03107aee.jpg', 0);
INSERT INTO `bc_posting_img` VALUES ('6f3b1d9bebe640878d7dd5d6a5861abc', 'default/2024/04/14/3e6ab4758f8e408ba967440eeb2661ea.jpg', 0);
INSERT INTO `bc_posting_img` VALUES ('6f3b1d9bebe640878d7dd5d6a5861abc', 'default/2024/04/14/3e6ab4758f8e408ba967440eeb2661ea.jpg', 0);
INSERT INTO `bc_posting_img` VALUES ('6f3b1d9bebe640878d7dd5d6a5861abc', 'default/2024/04/14/3e6ab4758f8e408ba967440eeb2661ea.jpg', 0);
INSERT INTO `bc_posting_img` VALUES ('6f3b1d9bebe640878d7dd5d6a5861abc', 'default/2024/04/14/3e6ab4758f8e408ba967440eeb2661ea.jpg', 0);
INSERT INTO `bc_posting_img` VALUES ('6f3b1d9bebe640878d7dd5d6a5861abc', 'default/2024/04/14/3e6ab4758f8e408ba967440eeb2661ea.jpg', 0);
INSERT INTO `bc_posting_img` VALUES ('2b00bb27ce3d4c00bb24eb6e8166b692', 'default/2024/04/14/f36a5bd20e294c1aa1c2ce64f70d2675.jpg', 0);
INSERT INTO `bc_posting_img` VALUES ('2b00bb27ce3d4c00bb24eb6e8166b692', 'default/2024/04/14/be02f798ae9a4f2c9d1e6a82fdde6a60.jpg', 0);
INSERT INTO `bc_posting_img` VALUES ('2b00bb27ce3d4c00bb24eb6e8166b692', 'default/2024/04/14/4d2e61e775a24ebebc6809dcdd874890.jpg', 0);
INSERT INTO `bc_posting_img` VALUES ('2b00bb27ce3d4c00bb24eb6e8166b692', 'default/2024/04/14/da18b9c824ab4cb5b9cdc993369b5856.jpg', 0);
INSERT INTO `bc_posting_img` VALUES ('2b00bb27ce3d4c00bb24eb6e8166b692', 'default/2024/04/14/e63e5fd864c84983a558e4d2fbc624d0.jpg', 0);

-- ----------------------------
-- Table structure for bc_role
-- ----------------------------
DROP TABLE IF EXISTS `bc_role`;
CREATE TABLE `bc_role`  (
  `id` varchar(32) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '角色ID',
  `name` varchar(32) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '角色名称',
  `key` varchar(32) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '角色权限字符串',
  `remark` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '备注',
  PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB CHARACTER SET = utf8 COLLATE = utf8_general_ci COMMENT = '角色信息' ROW_FORMAT = Dynamic;

-- ----------------------------
-- Records of bc_role
-- ----------------------------
INSERT INTO `bc_role` VALUES ('1', '管理员', 'ADMIN', '');
INSERT INTO `bc_role` VALUES ('2', '普通用户', 'ORDINARY', '');
INSERT INTO `bc_role` VALUES ('3', '访客', 'VISITORS', '');

-- ----------------------------
-- Table structure for bc_user
-- ----------------------------
DROP TABLE IF EXISTS `bc_user`;
CREATE TABLE `bc_user`  (
  `id` varchar(32) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '0' COMMENT '用户ID',
  `username` varchar(32) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '用户名',
  `password` varchar(256) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '密码',
  `email` varchar(32) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '邮箱',
  `phone` varchar(16) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '手机',
  `nick_name` varchar(16) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '昵称',
  `avatar_url` varchar(512) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '头像',
  `wx_id` varchar(32) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '微信ID',
  `create_time` datetime NULL DEFAULT NULL COMMENT '创建时间',
  `update_time` datetime NULL DEFAULT NULL COMMENT '修改时间',
  `status` tinyint(2) NULL DEFAULT NULL COMMENT '状态 0:锁定 1:未认证 2:已认证',
  `del_flag` tinyint(2) NULL DEFAULT NULL COMMENT '是否删除 0:未删除 1:已删除',
  PRIMARY KEY (`id`) USING BTREE,
  UNIQUE INDEX `uk_username`(`username`) USING BTREE COMMENT '用户名唯一索引'
) ENGINE = InnoDB CHARACTER SET = utf8 COLLATE = utf8_general_ci COMMENT = '用户信息' ROW_FORMAT = Dynamic;

-- ----------------------------
-- Records of bc_user
-- ----------------------------
INSERT INTO `bc_user` VALUES ('00d273d4ac754ff5a0fb9577065a4095', 'baage', '$2a$10$pnRzvD39I5JlwRDVnhZACOfsnaUoeNtXVVIdQaF/jSKIE89hOPwqK', '21312312@qq.com', NULL, '热心肠の八阿哥1', 'default/2024/04/20/091086d69889467f92633873a1a53ecc.jpg', NULL, '2024-04-10 11:27:02', '2024-04-20 23:04:41', 1, 0);
INSERT INTO `bc_user` VALUES ('371994a3317d431c8b381e24d41b7af1', 'test03', '$2a$10$5k0HXSvpLV7lndHBk2urmu9R1ZR9vnb6Uav/ZO3EpNiiEZVnURkti', '112312@qq.com', NULL, '火爆の棒棒糖', 'avatar/default_7.jpg', NULL, '2024-04-11 18:35:56', '2024-04-11 18:35:56', 1, 0);
INSERT INTO `bc_user` VALUES ('390b1e4f073e483b9284fce52f940bac', 'baage123', '$2a$10$xsVPE0Rn.i5AitYfuElJvusmsy2M.xd4Xdijm56tc751AHY5kYX3e', '134125197231@qq.com', NULL, '爱喝酒の企鹅', 'avatar/default_2.jpg', NULL, '2024-04-21 16:30:11', '2024-04-21 16:30:11', 1, 0);
INSERT INTO `bc_user` VALUES ('7aa7788540014b6f8c05e45b36a2ada0', 'test02', '$2a$10$rgvJBwLW7ROcIqYyahsRYu6CsbOxDXCZWe0OALiplhi8nHhkahhcS', '123123@qq.com', NULL, '乖乖の足球', 'avatar/default_2.jpg', NULL, '2024-04-11 18:33:35', '2024-04-11 18:33:35', 1, 0);
INSERT INTO `bc_user` VALUES ('bdfc83be693d4bd4820f6f215961cd2c', 'baage02', '$2a$10$ay2Mld96X5vbBo9CoDmg8OlyqIFxfOQYxPhY65SX8Wnoml/yX5iee', '133333@qq.com', NULL, '打盹の自行车', 'avatar/default_5.jpg', NULL, '2024-04-12 23:42:20', '2024-04-12 23:42:20', 1, 0);
INSERT INTO `bc_user` VALUES ('c854700c3013460c960fc5b1ddd5fd22', 'test01', '$2a$10$no0QbErGsrtztuaIJVPdwe/jBlehu.KIMBz/XoD4OhCBybxkQOuTS', '1341251971@qq.com', NULL, '冲动の熊猫', 'avatar/default_1.jpg', NULL, '2024-04-11 18:31:23', '2024-04-11 21:40:37', 1, 0);
INSERT INTO `bc_user` VALUES ('e2f61a32a04f428983ed3b07a447f3d5', 'baage01', '$2a$10$zJQKkztVqjoqCl7s7dj4a.lZ54OL7/tkV2pYIHCokiJQAlVwvK.Wi', '1341251972@qq.com', NULL, '粗眉毛の莴苣', 'avatar/default_6.jpg', NULL, '2024-04-11 21:39:34', '2024-04-11 21:39:34', 1, 0);
INSERT INTO `bc_user` VALUES ('ed52b7de329044fe958ea9a9ba5c0b53', 'test04', '$2a$10$38sUKAi.uGgUsr7ibK5K..O..k1oFGj4/Dx6zXqe8H51mtPAsg2m6', '123123@qq.com', NULL, '热心肠の骆驼', 'avatar/default_1.jpg', NULL, '2024-04-11 18:37:09', '2024-04-11 18:37:09', 1, 0);
INSERT INTO `bc_user` VALUES ('ff452408ce7548ada4c2123c2b647a85', 'baage03', '$2a$10$WqCEbKos4n.Gvah/Q5udF.R9GsA854WxzQwDLrFh9N8QtI86fu2mq', '134125@qq.com', NULL, '憨厚の板凳', 'avatar/default_12.jpg', NULL, '2024-04-13 23:59:01', '2024-04-13 23:59:01', 1, 0);

-- ----------------------------
-- Table structure for bc_user_role
-- ----------------------------
DROP TABLE IF EXISTS `bc_user_role`;
CREATE TABLE `bc_user_role`  (
  `user_id` varchar(32) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '用户ID',
  `role_id` varchar(32) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '角色ID',
  PRIMARY KEY (`user_id`, `role_id`) USING BTREE
) ENGINE = InnoDB CHARACTER SET = utf8 COLLATE = utf8_general_ci COMMENT = '用户与角色关联' ROW_FORMAT = Dynamic;

-- ----------------------------
-- Records of bc_user_role
-- ----------------------------
INSERT INTO `bc_user_role` VALUES ('00d273d4ac754ff5a0fb9577065a4095', '1');
INSERT INTO `bc_user_role` VALUES ('00d273d4ac754ff5a0fb9577065a4095', '2');
INSERT INTO `bc_user_role` VALUES ('371994a3317d431c8b381e24d41b7af1', '2');
INSERT INTO `bc_user_role` VALUES ('390b1e4f073e483b9284fce52f940bac', '2');
INSERT INTO `bc_user_role` VALUES ('55b722c605384d25801e1050acd6590e', '1');
INSERT INTO `bc_user_role` VALUES ('7aa7788540014b6f8c05e45b36a2ada0', '2');
INSERT INTO `bc_user_role` VALUES ('bdfc83be693d4bd4820f6f215961cd2c', '2');
INSERT INTO `bc_user_role` VALUES ('c854700c3013460c960fc5b1ddd5fd22', '2');
INSERT INTO `bc_user_role` VALUES ('e2f61a32a04f428983ed3b07a447f3d5', '2');
INSERT INTO `bc_user_role` VALUES ('ed52b7de329044fe958ea9a9ba5c0b53', '2');
INSERT INTO `bc_user_role` VALUES ('ff452408ce7548ada4c2123c2b647a85', '2');

-- ----------------------------
-- Table structure for bc_verification
-- ----------------------------
DROP TABLE IF EXISTS `bc_verification`;
CREATE TABLE `bc_verification`  (
  `user_id` varchar(32) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '用户ID',
  `name` varchar(32) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '姓名',
  `student_id` varchar(32) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '学号',
  `admission_year` int(11) NULL DEFAULT NULL COMMENT '入学年份',
  `graduation_year` int(11) NULL DEFAULT NULL COMMENT '毕业年份',
  `card_img` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '学生证照片',
  `remarks` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '备注',
  `status` tinyint(2) NULL DEFAULT 0 COMMENT '认证状态 0:未通过 1:已通过',
  PRIMARY KEY (`user_id`) USING BTREE
) ENGINE = InnoDB CHARACTER SET = utf8 COLLATE = utf8_general_ci COMMENT = '实名认证信息' ROW_FORMAT = Dynamic;

-- ----------------------------
-- Records of bc_verification
-- ----------------------------

SET FOREIGN_KEY_CHECKS = 1;