# egg-basic-cms

**Repository Path**: Alex_Lu/egg-basic-cms

## Basic Information

- **Project Name**: egg-basic-cms
- **Description**: No description available
- **Primary Language**: NodeJS
- **License**: MIT
- **Default Branch**: master
- **Homepage**: None
- **GVP Project**: No

## Statistics

- **Stars**: 1
- **Forks**: 0
- **Created**: 2021-12-20
- **Last Updated**: 2022-11-12

## Categories & Tags

**Categories**: Uncategorized

**Tags**: None

## README

# test-cms



## QuickStart

<!-- add docs here for user -->

see [egg docs][egg] for more detail.

### Development

```bash
$ npm i
$ npm run dev
$ open http://localhost:7001/
```

### Deploy

```bash
$ npm start
$ npm stop
```

### npm scripts

- Use `npm run lint` to check code style.
- Use `npm test` to run unit test.
- Use `npm run autod` to auto detect dependencies upgrade, see [autod](https://www.npmjs.com/package/autod) for more detail.


[egg]: https://eggjs.org

### mysql init
```sql
CREATE TABLE user (
    id int(11) PRIMARY KEY AUTO_INCREMENT,
    username varchar(255) NULL,
    password varchar(255) NULL,
    email varchar(255) NULL,
    phone varchar(255) NULL,
    gender tinyint(255) NULL,
    birthday datetime NULL,
    address varchar(255) NULL
);

CREATE TABLE role (
    id int(11) PRIMARY KEY AUTO_INCREMENT,
    name varchar(255) NULL
);

CREATE TABLE role_user (
    role_id int(11) NOT NULL,
    user_id int(11) NOT NULL,
    PRIMARY KEY (user_id, role_id)
);

CREATE TABLE resource (
    id int(11) PRIMARY KEY AUTO_INCREMENT,
    name varchar(255) NOT NULL
);

CREATE TABLE role_resource (
    role_id int(11) NOT NULL,
    resource_id int(255) NOT NULL,
    PRIMARY KEY (role_id, resource_id)
);

```