users 用户表
=========================

字段
--------------------

+-------------+--------------+----------+--------+-----------------------------------------------------+
| 列名        | 类型         | 是否非空 | 默认值 | 备注                                                |
+-------------+--------------+----------+--------+-----------------------------------------------------+
| id          | varchar(255) | not null | null   | UUID                                                |
+-------------+--------------+----------+--------+-----------------------------------------------------+
| name        | varchar(30)  | not null | null   | 用户名                                              |
+-------------+--------------+----------+--------+-----------------------------------------------------+
| displayname | varchar(30)  | not null | 昵称   |                                                     |
+-------------+--------------+----------+--------+-----------------------------------------------------+
| password    | varchar(100) | not null | null   | 加密后的密码                                        |
+-------------+--------------+----------+--------+-----------------------------------------------------+
| token       | varchar(100) | null     | null   | 临时令牌                                            |
+-------------+--------------+----------+--------+-----------------------------------------------------+
| status      | smallint     | not null | 0      | 状态： 0-正常，1-停用                               |
+-------------+--------------+----------+--------+-----------------------------------------------------+
| role_id     | int          | null     | 0      | 初步创建时可以为空，后续分配角色，删除 user_role 表 |
+-------------+--------------+----------+--------+-----------------------------------------------------+

## 索引

+------+----------+------+
| 字段 | 唯一索引 | 备注 |
+------+----------+------+
| 无   |          |      |
+------+----------+------+

## 说明

## 建表语句

.. code:: 

  CREATE TABLE `users` (
    `id` varchar(255) NOT NULL COMMENT '唯一键',
    `name` varchar(30) CHARACTER SET latin1 NOT NULL COMMENT '用户名',
    `displayname` varchar(30) NOT NULL COMMENT '昵称',
    `password` varchar(100) CHARACTER SET latin1 NOT NULL COMMENT '密码',
    `token` varchar(100) CHARACTER SET latin1 DEFAULT NULL COMMENT '临时令牌',
    `status` smallint(6) NOT NULL DEFAULT 0 COMMENT '状态',
    PRIMARY KEY (`id`)
  ) ENGINE=InnoDB DEFAULT CHARSET=utf8;