+-----+---------------+---------------------+-----------------+---------+------------------+----------------+
|     | Field name    |       Type          | Allow nulls?    | Key     | Default value    |   Extras       |
+-----+---------------+---------------------+-----------------+---------+------------------+----------------+
|     | uid           | bigint(20) unsigned | No              | Primary | NULL             | auto_increment |
|     | username      | varchar(36)         | No              | None    |                  |                |
|     | email         | varchar(255)        | No              | None    |                  |                |
|     | confirmed     | tinyint(1)          | No              | None    | 0                |                |
|     | password      | varchar(255)        | No              | None    |                  |                |
|     | gold          | tinyint(1) unsigned | No              | None    | 0                |                |
+-----+---------------+---------------------+-----------------+---------+------------------+----------------+