# @mmstudio/an000029

> 用户名密码登录

Latest version **2.0.0** (published 2020-12-14) · MIT license · 0 weekly downloads

## Install

```sh
npm install @mmstudio/an000029
pnpm add @mmstudio/an000029
yarn add @mmstudio/an000029
bun add @mmstudio/an000029
```

## Health

**Score 30/100 (F)** — status: abandoned.

Positive: has types; esm support; no vulnerabilities; high quality score.

Warnings: low downloads.

Negative: abandoned; low maintenance score.

## Facts

| | |
|---|---|
| Version | 2.0.0 |
| Published | 2020-12-14 |
| First published | 2020-03-17 |
| Weekly downloads | 0 |
| License | MIT |
| TypeScript types | bundled |
| Module format | ESM + CommonJS |
| Dependencies | 1 |
| Unpacked size | 8.1 KB |
| Known vulnerabilities | 0 (+3 in 1 direct dependencies) |
| Install scripts | no |
| GitHub stars | 0 |
| Author | taoqf |
| Maintainers | taoqf |
| Keywords | mm, mmstudio, 蛮蛮, 蛮蛮工作室, 插件式, 原子操作, 控件, 框架 |

## Links

- npm: https://www.npmjs.com/package/@mmstudio/an000029
- Repository: https://github.com/mm-atom/an000029
- Homepage: https://mm-works.github.io
- Issues: https://github.com/mm-atom/an000029/issues
- npm.io page: https://npm.io/package/@mmstudio/an000029

## Dependencies (1)

- [jsonwebtoken](https://npm.io/package/jsonwebtoken.md) ^8.5.1

## Alternatives

- [@salesforce/cli](https://npm.io/package/@salesforce/cli.md) — 389.7K weekly downloads
- [@mintlify/cli](https://npm.io/package/@mintlify/cli.md) — 208.9K weekly downloads
- [@grafana/e2e-selectors](https://npm.io/package/@grafana/e2e-selectors.md) — 128.7K weekly downloads
- [mintlify](https://npm.io/package/mintlify.md) — 112.0K weekly downloads
- [@intlayer/cli](https://npm.io/package/@intlayer/cli.md) — 22.8K weekly downloads

## Recent versions

- 2.0.0 (latest) — 2020-12-14
- 1.0.202004171640 — 2020-04-17
- 1.0.202004171630 — 2020-04-17
- 1.0.202004170832 — 2020-04-17
- 1.0.202004170819 — 2020-04-17
- 1.0.202003171711 — 2020-03-17

## README

# 用户名密码登录

## postgres

用户数据存储到postgres数据库中，其json字段更便于存储可扩展的用户信息

## 用户表

### 表结构

#### 用户基础信息表

字段名|字段类型|字段描述
---|---|---
id|text|用户id
info|json|用户信息

#### 用户授权信息表

字段名|字段类型|字段描述
---|---|---
id|text|授权信息关键字
user_id|text|用户id
identity_type|text|登录类型（手机号 邮箱 用户名）或第三方应用名称（微信 微博等）
identifier|text|标识（手机号 邮箱 用户名或第三方应用的唯一标识）
credential|text|密码凭证（站内的保存密码，站外的不保存或保存token）

### 建表语句

```sql
DROP TABLE IF EXISTS mm_users;
CREATE TABLE mm_users (
	id text NOT NULL,
	info json,
	PRIMARY KEY (id)
) WITH (oids = false);

DROP INDEX IF EXISTS mm_users_id;
CREATE UNIQUE INDEX mm_users_id ON mm_users(id);

COMMENT ON TABLE mm_users IS '用户基础信息';
COMMENT ON COLUMN mm_users.id IS '用户id';
COMMENT ON COLUMN mm_users.info IS '用户信息';

DROP TABLE IF EXISTS mm_user_auths;
CREATE TABLE mm_user_auths (
	id text NOT NULL,
	user_id text,
	identity_type text,
	identifier text,
	credential text,
	last_active bigint,
	ip text,
	CONSTRAINT pk_mm_user_auths PRIMARY KEY (identifier, identity_type)
) WITH (oids = false);

DROP INDEX IF EXISTS mm_user_auths_id;
CREATE UNIQUE INDEX mm_user_auths_id ON mm_user_auths(id);
DROP INDEX IF EXISTS mm_user_auths_user_id;
CREATE INDEX mm_user_auths_user_id ON mm_user_auths(user_id);
DROP INDEX IF EXISTS mm_user_auths_identity_type;
CREATE INDEX mm_user_auths_identity_type ON mm_user_auths(identity_type);
DROP INDEX IF EXISTS mm_user_auths_identifier;
CREATE INDEX mm_user_auths_identifier ON mm_user_auths(identifier);

COMMENT ON TABLE mm_user_auths IS '用户授权信息';
COMMENT ON COLUMN mm_user_auths.user_id IS 'users.id';
COMMENT ON COLUMN mm_user_auths.identity_type IS '登录类型（手机号 邮箱 用户名）或第三方应用名称（微信 微博等）';
COMMENT ON COLUMN mm_user_auths.identifier IS '标识（手机号 邮箱 用户名或第三方应用的唯一标识）';
COMMENT ON COLUMN mm_user_auths.credential IS '密码凭证（站内的保存密码，站外的不保存或保存token）';
```

## 完整的配置文件

```json
{
	"session": {
		"secret": "Mmstudio123",
		"expiresIn": "30d"
	},
	"db": {
		"type": "postgres",
		"source": "postgres://mmstudio:Mmstudio123@127.0.0.1:5432/mmstudio"
	}
}
```

## docker-file

[docker-compose安置](https://download.daocloud.io/Docker_Mirror/Docker_Compose)

```yml
version: '3.7'

services:
  postgres:
    image: postgres
    container_name: postgres
    volumes:
      - /home/taoqf/data/postgre:/var/lib/postgresql/data
    restart: always
    environment:
      POSTGRES_DB: mmstudio
      POSTGRES_USER: mmstudio
      POSTGRES_PASSWORD: Mmstudio123
    ports:
      - 5432:5432
  adminer:
    container_name: adminer
    image: adminer
    restart: always
    ports:
      - 8080:8080
```

---
_Source: https://npm.io/package/@mmstudio/an000029 · Machine-readable twin of the npm.io package page. Health data is recomputed on every publish._
