技术交流论坛-测试项目

/* Navicat Premium Data Transfer Source Server : 本地MYSQL Source Server Type : MySQL Source Server Version : 50729 Source Host : localhost:3307 Source Schema : community Target Server Type : MySQL Target Server Version : 50729 File Encoding : 65001 Date: 18/02/2023 18:02:12 */ SET NAMES utf8mb4; SET FOREIGN_KEY_CHECKS = 0; -- ---------------------------- -- Table structure for tb_article -- ---------------------------- DROP TABLE IF EXISTS `tb_article`; CREATE TABLE `tb_article` ( `id` int(11) NOT NULL AUTO_INCREMENT, `board_id` int(11) DEFAULT NULL, `title` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL, `title_img` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL, `summary` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL, `author` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL, `content` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL, `status` int(255) DEFAULT NULL, `comment_status` int(255) DEFAULT NULL, `slideshow` int(255) DEFAULT NULL, `top` int(255) DEFAULT NULL, `create_date` date DEFAULT NULL, `create_user` int(255) DEFAULT NULL, `update_date` date DEFAULT NULL, `visit_count` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL, PRIMARY KEY (`id`) USING BTREE ) ENGINE = InnoDB AUTO_INCREMENT = 3 CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = Dynamic; -- ---------------------------- -- Records of tb_article -- ---------------------------- INSERT INTO `tb_article` VALUES (1, 1, '软件测试专业技术交流论坛', 'http://localhost:8888/community/upload/a6aa7207-fcdb-4f86-ae41-d418be90819f.png', '', '超级管理员', '软件测试专业', 1, 0, 1, 1, '2023-02-18', 2, '2023-02-18', '0'); -- ---------------------------- -- Table structure for tb_article_attachment -- ---------------------------- DROP TABLE IF EXISTS `tb_article_attachment`; CREATE TABLE `tb_article_attachment` ( `id` int(11) NOT NULL AUTO_INCREMENT, `article_id` int(11) DEFAULT NULL, `url` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL, PRIMARY KEY (`id`) USING BTREE ) ENGINE = InnoDB AUTO_INCREMENT = 2 CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = Dynamic; -- ---------------------------- -- Records of tb_article_attachment -- ---------------------------- INSERT INTO `tb_article_attachment` VALUES (1, 1, 'http://localhost:8888/community/upload/9436c77a-d719-42ec-a36d-0bc89af9b106.png'); -- ---------------------------- -- Table structure for tb_article_tag -- ---------------------------- DROP TABLE IF EXISTS `tb_article_tag`; CREATE TABLE `tb_article_tag` ( `id` int(11) NOT NULL AUTO_INCREMENT, `article_id` int(11) DEFAULT NULL, `tag_id` int(11) DEFAULT NULL, PRIMARY KEY (`id`) USING BTREE ) ENGINE = InnoDB AUTO_INCREMENT = 3 CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = Dynamic; -- ---------------------------- -- Records of tb_article_tag -- ---------------------------- INSERT INTO `tb_article_tag` VALUES (1, 1, 1); -- ---------------------------- -- Table structure for tb_board -- ---------------------------- DROP TABLE IF EXISTS `tb_board`; CREATE TABLE `tb_board` ( `id` int(11) NOT NULL AUTO_INCREMENT, `board_name` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL, `parent_id` int(11) DEFAULT NULL, `summary` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL, `single` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL, `content` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL, `create_date` date DEFAULT NULL, `create_user` int(255) DEFAULT NULL, `deleted_flag` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL, `pos` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL, `board_img` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL, PRIMARY KEY (`id`) USING BTREE ) ENGINE = InnoDB AUTO_INCREMENT = 2 CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = Dynamic; -- ---------------------------- -- Records of tb_board -- ---------------------------- INSERT INTO `tb_board` VALUES (1, '接口自动化测试', 0, 'Python、JMeter、postman接口自动化测试', 'Y', 'Python、JMeter、postman接口自动化测试', '2023-02-18', 2, NULL, 'A', 'http://localhost:8888/community/upload/999b5019-3b03-4ad8-b300-b87dd31f93c8.png'); -- ---------------------------- -- Table structure for tb_collection -- ---------------------------- DROP TABLE IF EXISTS `tb_collection`; CREATE TABLE `tb_collection` ( `id` int(11) NOT NULL AUTO_INCREMENT, `article_id` int(11) DEFAULT NULL, `user_id` int(11) DEFAULT NULL, PRIMARY KEY (`id`) USING BTREE ) ENGINE = InnoDB AUTO_INCREMENT = 2 CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = Dynamic; -- ---------------------------- -- Records of tb_collection -- ---------------------------- INSERT INTO `tb_collection` VALUES (1, 2, 2); -- ---------------------------- -- Table structure for tb_comment -- ---------------------------- DROP TABLE IF EXISTS `tb_comment`; CREATE TABLE `tb_comment` ( `id` int(11) NOT NULL AUTO_INCREMENT, `author` varchar(500) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL, `email` varchar(501) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL, `ip` varchar(10) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL, `create_date` date DEFAULT NULL, `content` varchar(540) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL, `status` int(11) DEFAULT NULL, `article_id` int(11) DEFAULT NULL, `parent_id` int(11) DEFAULT NULL, PRIMARY KEY (`id`) USING BTREE ) ENGINE = InnoDB AUTO_INCREMENT = 2 CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = Dynamic; -- ---------------------------- -- Table structure for tb_friend_link -- ---------------------------- DROP TABLE IF EXISTS `tb_friend_link`; CREATE TABLE `tb_friend_link` ( `id` int(11) NOT NULL AUTO_INCREMENT, `url` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL, `title` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL, `path` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL, `target` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL, PRIMARY KEY (`id`) USING BTREE ) ENGINE = InnoDB AUTO_INCREMENT = 2 CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = Dynamic; -- ---------------------------- -- Records of tb_friend_link -- ---------------------------- INSERT INTO `tb_friend_link` VALUES (1, 'www.baidu.com', '百度', '', '_blank'); -- ---------------------------- -- Table structure for tb_tag -- ---------------------------- DROP TABLE IF EXISTS `tb_tag`; CREATE TABLE `tb_tag` ( `id` int(11) NOT NULL AUTO_INCREMENT, `tag_name` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL, PRIMARY KEY (`id`) USING BTREE ) ENGINE = InnoDB AUTO_INCREMENT = 4 CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = Dynamic; -- ---------------------------- -- Records of tb_tag -- ---------------------------- INSERT INTO `tb_tag` VALUES (1, '自动化测试'); INSERT INTO `tb_tag` VALUES (2, '性能测试'); INSERT INTO `tb_tag` VALUES (3, '功能测试'); -- ---------------------------- -- Table structure for tb_user -- ---------------------------- DROP TABLE IF EXISTS `tb_user`; CREATE TABLE `tb_user` ( `id` int(11) NOT NULL AUTO_INCREMENT, `user_name` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL, `password` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL, `nick_name` varchar(255) CHARACTER SET utf8 COLLATE utf8_general