# FFTD

**Repository Path**: metaphorchen/fftd

## Basic Information

- **Project Name**: FFTD
- **Description**: 6324 project
- **Primary Language**: Java
- **License**: Not specified
- **Default Branch**: master
- **Homepage**: None
- **GVP Project**: No

## Statistics

- **Stars**: 2
- **Forks**: 0
- **Created**: 2023-02-19
- **Last Updated**: 2025-05-30

## Categories & Tags

**Categories**: Uncategorized

**Tags**: None

## README

# 6324 FFTD Server



### 使用说明

1.  创建本地数据库
2.  修改application.yml如下参数：
    datasource:
    type: com.alibaba.druid.pool.DruidDataSource
    url: jdbc:mysql://127.0.0.1:3306/（**+数据库名字**）
    username: （**+用户名**）
    password: （**+密码**）
3.  修改generatorConfig.xml中</jdbcConnection>里的参数
    





### SQL语句
-- ----------------------------
-- Table structure for tb_user
-- ----------------------------
DROP TABLE IF EXISTS `tb_user`;
CREATE TABLE `tb_user` (
`email` varchar(20) NOT NULL,
`user_name` varchar(20) NOT NULL,
`password` varchar(20) NOT NULL,
PRIMARY KEY (`email`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

-- ----------------------------
-- Records of tb_user
-- ----------------------------
INSERT INTO `tb_user` VALUES ('111@qq.com', '001', '001');

#### Create Comment Table
```sql
CREATE TABLE `tb_comment` (
  `comment_id` int NOT NULL AUTO_INCREMENT COMMENT '主键',
  `user_id` int DEFAULT NULL COMMENT '发布者id',
  `user_name` varchar(20) DEFAULT NULL COMMENT '发布者名字',
  `create_time` datetime DEFAULT NULL COMMENT '发布时间',
  `body` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci DEFAULT NULL COMMENT '评论内容',
  `pic_path` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci DEFAULT NULL COMMENT '图片路径',
  `title` varchar(50) DEFAULT NULL,
  PRIMARY KEY (`comment_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
```

---



#### Create Event Table

```sql
CREATE TABLE `tb_event` (
  `event_id` bigint NOT NULL,
  `user_id` bigint DEFAULT NULL,
  `user_name` varchar(64) DEFAULT NULL,
  `title` varchar(64) DEFAULT NULL,
  `body` varchar(400) DEFAULT NULL,
  `pic_path` varchar(200) DEFAULT NULL,
  `create_time` datetime DEFAULT NULL,
  PRIMARY KEY (`event_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
```