gistfile1

mysql> desc usuario;
+-------------------+-------------------------------------+------+-----+---------------------+-----------------------------+
| Field             | Type                                | Null | Key | Default             | Extra                       |
+-------------------+-------------------------------------+------+-----+---------------------+-----------------------------+
| id                | int(11)                             | NO   | PRI | NULL                | auto_increment              |
| nombre            | varchar(64)                         | NO   | MUL | NULL                |                             |
| contrasena        | varchar(64)                         | NO   |     | NULL                |                             |
| correo            | varchar(64)                         | NO   | MUL | NULL                |                             |
| activo            | enum('s','n')                       | NO   |     | s                   |                             |
| creado            | datetime                            | YES  |     | NULL                |                             |
| hash_verificacion | varchar(64)                         | YES  |     | NULL                |                             |
| verificado        | enum('s','n')                       | YES  |     | n                   |                             |
| intentos_login    | tinyint(4)                          | YES  |     | 0                   |                             |
| ts_intentos_login | int(11)                             | YES  |     | NULL                |                             |
| rol               | enum('visitante','usuario','admin') | NO   |     | usuario             |                             |
| sal               | varchar(64)                         | NO   |     |                     |                             |
| ult_ingreso       | datetime                            | YES  |     | 0000-00-00 00:00:00 |                             |
| ip_ult_ingreso    | varchar(32)                         | YES  |     | NULL                |                             |
| log               | timestamp                           | NO   |     | CURRENT_TIMESTAMP   | on update CURRENT_TIMESTAMP |
+-------------------+-------------------------------------+------+-----+---------------------+-----------------------------+