用户角色表：dl_user_role
================================


**用户角色表**


**字段**

+--------------+---------+------+--------+----------+--------+---------------+
|     列名     |  类型   | 长度 | 小数点 | 是否非空 | 默认值 |     备注      |
+==============+=========+======+========+==========+========+===============+
| id           | bigint  | 20   | 0      | not null |        | 主键，自增 ID |
+--------------+---------+------+--------+----------+--------+---------------+
| user_id      | varchar | 255  | 0      | not null |        | 用户ID        |
+--------------+---------+------+--------+----------+--------+---------------+
| role_id      | bigint  | 20   | 0      | not null |        | 角色ID        |
+--------------+---------+------+--------+----------+--------+---------------+


**索引**

+------+----------+------+
| 字段 | 索引类型 | 备注 |
+======+==========+======+
| id   | PRIMARY  |      |
+------+----------+------+


**建表语句**
::

  CREATE TABLE `dl_user_role` (
    `id` bigint(20) NOT NULL AUTO_INCREMENT,
    `user_id` varchar(255) NOT NULL,
    `role_id` bigint(20) NOT NULL,
    PRIMARY KEY (`id`) USING BTREE
  ) ENGINE=InnoDB AUTO_INCREMENT=4 DEFAULT CHARSET=utf8 ROW_FORMAT=DYNAMIC;