gistfile1.sql

mysql> desc companies_users;
+--------------+--------------------------------------+------+-----+-------------------+-----------------------------+
| Field        | Type                                 | Null | Key | Default           | Extra                       |
+--------------+--------------------------------------+------+-----+-------------------+-----------------------------+
| id           | int(10) unsigned                     | NO   | PRI | NULL              | auto_increment              |
| company_id   | int(10) unsigned                     | NO   | MUL | NULL              |                             |
| user_id      | int(10) unsigned                     | NO   |     | NULL              |                             |
| access_level | enum('normal','admin','creator')     | NO   | MUL | normal            |                             |
| status       | enum('enabled','disabled','deleted') | NO   | MUL | enabled           |                             |
| created      | datetime                             | NO   |     | NULL              |                             |
| modified     | timestamp                            | NO   |     | CURRENT_TIMESTAMP | on update CURRENT_TIMESTAMP |
+--------------+--------------------------------------+------+-----+-------------------+-----------------------------+
7 rows in set (0.00 sec)