.. role:: strike
    :class: strike

:strike:`user_role 用户角色表`
==================================================

## 字段
--------------------

+---------+--------------+----------+--------+---------+
| 列名    | 类型         | 是否非空 | 默认值 | 备注    |
+---------+--------------+----------+--------+---------+
| id      | int          | not null | null   | 自增 id |
+---------+--------------+----------+--------+---------+
| user_id | varchar(255) | not null | null   | 用户 id |
+---------+--------------+----------+--------+---------+
| role_id | int          | null     | null   | 角色 id |
+---------+--------------+----------+--------+---------+

## 索引
--------------------

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

## 说明

## 建表语句

.. code::

  CREATE TABLE `user_role` (
    `id` int(11) NOT NULL AUTO_INCREMENT COMMENT '唯一键',
    `user_id` varchar(255) CHARACTER SET latin1 NOT NULL COMMENT '用户id',
    `role_id` int(11) NOT NULL COMMENT '角色id',
    PRIMARY KEY (`id`)
  ) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8;