# play-test

**Repository Path**: chjsdream/play-test

## Basic Information

- **Project Name**: play-test
- **Description**: No description available
- **Primary Language**: Unknown
- **License**: Not specified
- **Default Branch**: master
- **Homepage**: None
- **GVP Project**: No

## Statistics

- **Stars**: 1
- **Forks**: 0
- **Created**: 2024-04-09
- **Last Updated**: 2024-04-24

## Categories & Tags

**Categories**: Uncategorized

**Tags**: None

## README

#
## mysql
```sql
CREATE TABLE `users` (
  `id` int(10) NOT NULL AUTO_INCREMENT,
  `phone` varchar(32) NOT NULL COMMENT '手机号',
  `name` varchar(32) NOT NULL COMMENT '姓名',
  `wish` varchar(255) NOT NULL COMMENT '祝福',
  `header_url` varchar(255) NOT NULL COMMENT '头像地址',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=155 DEFAULT CHARSET=utf8
```

```
CREATE TABLE `award` (
  `id` int(10) NOT NULL AUTO_INCREMENT,
  `award_id` int(10) NOT NULL COMMENT '奖项编号',
  `name` varchar(32) NOT NULL COMMENT '奖品名称',
  `number` int(10) NOT NULL COMMENT '奖品数量',
  `list_index` int(10) DEFAULT NULL COMMENT '列表下标',
  `pic_img` varchar(255) DEFAULT NULL COMMENT '图片',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8
```
```
CREATE TABLE `prize` (
  `id` int(10) NOT NULL AUTO_INCREMENT,
  `name` varchar(32) NOT NULL COMMENT '奖项名称',
  `award_id` int(10) NOT NULL COMMENT '奖项编号',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=26 DEFAULT CHARSET=utf8

```
> 可能出现  1366 报错 字体问题
##### 解决方法
````sql
ALTER TABLE `users` CONVERT TO CHARACTER SET utf8;
````


## 运行

- yarn run dev:local  本地开发环境,连local数据库
- yarn run pm2        生产环境(运行在生产服务器,连生产数据库)
- yarn run pm2:resart 生产环境重启(运行在生产服务器,连生产数据库)
- yarn stop           停止/退出