desc users;
+----------+--------------+------+-----+---------+----------------+
| Field    | Type         | Null | Key | Default | Extra          |
+----------+--------------+------+-----+---------+----------------+
| id       | int(11)      | NO   | PRI | NULL    | auto_increment |
| email    | varchar(255) | NO   |     | NULL    |                |
| password | varchar(255) | NO   |     | NULL    |                |
| created  | datetime     | YES  |     | NULL    |                |
| updated  | datetime     | YES  |     | NULL    |                |
+----------+--------------+------+-----+---------+----------------+
5 rows in set (0.22 sec)

select * from users;
+----+--------------------------+--------------------------------------------------------------+---------------------+---------+
| id | email                    | password                                                     | created             | updated |
+----+--------------------------+--------------------------------------------------------------+---------------------+---------+
|  1 | email0@gmail.com | $2y$10$zKFFxsZ/udZek27d62DvSO6k3i9wcxu18VnI77ruR6L9iqLKjadwC | 2015-04-01 01:35:36 | NULL    |
|  2 | email1@gmail.com | $2y$10$JNLnk6kGlcBu61ABpDLXB.zW66Bk3IxJJ7wuJNyPuuFk6BBTq1jsS | 2015-04-03 23:10:43 | NULL    |
+----+--------------------------+--------------------------------------------------------------+---------------------+---------+

desc roles;
+-------+-------------+------+-----+---------+----------------+
| Field | Type        | Null | Key | Default | Extra          |
+-------+-------------+------+-----+---------+----------------+
| id    | int(11)     | NO   | PRI | NULL    | auto_increment |
| name  | varchar(20) | NO   |     | NULL    |                |
+-------+-------------+------+-----+---------+----------------+
2 rows in set (0.02 sec)

select * from roles;
+----+---------------+
| id | name          |
+----+---------------+
|  1 | administrator |
|  2 | creator       |
|  3 | viewer        |
+----+---------------+
3 rows in set (0.00 sec)

desc user_roles;
+---------+----------+------+-----+---------+----------------+
| Field   | Type     | Null | Key | Default | Extra          |
+---------+----------+------+-----+---------+----------------+
| id      | int(11)  | NO   | PRI | NULL    | auto_increment |
| user_id | int(11)  | NO   | MUL | NULL    |                |
| role_id | int(11)  | NO   | MUL | NULL    |                |
| created | datetime | YES  |     | NULL    |                |
| updated | datetime | YES  |     | NULL    |                |
+---------+----------+------+-----+---------+----------------+
5 rows in set (0.02 sec)

select * from user_roles;
+----+---------+---------+---------+---------+
| id | user_id | role_id | created | updated |
+----+---------+---------+---------+---------+
|  1 |       1 |       1 | NULL    | NULL    |
|  2 |       1 |       2 | NULL    | NULL    |
|  3 |       1 |       3 | NULL    | NULL    |
|  4 |       2 |       3 | NULL    | NULL    |
+----+---------+---------+---------+---------+
4 rows in set (0.00 sec)