mysql> show tables;
+---------------------+
| Tables_in_beaglenet |
+---------------------+
| categories          |
| changelog           |
| classes             |
| documents           |
| favorites           |
| log                 |
| users               |
+---------------------+
7 rows in set (0.00 sec)

mysql> describe categories
    -> ;
+------------+------------------+------+-----+---------+----------------+
| Field      | Type             | Null | Key | Default | Extra          |
+------------+------------------+------+-----+---------+----------------+
| id         | int(11) unsigned | NO   | PRI |         | auto_increment |
| parent_id  | int(11) unsigned | YES  |     |         |                |
| title      | varchar(255)     | YES  |     |         |                |
| defaultdoc | varchar(9)       | NO   |     |         |                |
| iq         | int(3) unsigned  | NO   |     | 0       |                |
+------------+------------------+------+-----+---------+----------------+
5 rows in set (0.02 sec)

mysql> describe documents;
+-----------+---------------------+------+-----+---------+-------+
| Field     | Type                | Null | Key | Default | Extra |
+-----------+---------------------+------+-----+---------+-------+
| bnum      | varchar(9)          | NO   | PRI |         |       |
| tree_id   | int(11) unsigned    | YES  | MUL |         |       |
| archive   | tinyint(1) unsigned | YES  | MUL | 0       |       |
| title     | varchar(255)        | YES  | MUL |         |       |
| doc       | longtext            | YES  | MUL |         |       |
| html      | int(1) unsigned     | YES  |     | 0       |       |
| alt_doc   | varchar(100)        | YES  |     |         |       |
| iq        | int(3) unsigned     | YES  | MUL |         |       |
| class     | int(11) unsigned    | YES  |     |         |       |
| doxyfile  | varchar(255)        | YES  | UNI |         |       |
| start_ver | varchar(100)        | YES  |     |         |       |
| end_ver   | varchar(100)        | YES  |     |         |       |
| title2    | varchar(96)         | YES  |     |         |       |
| title3    | varchar(96)         | YES  |     |         |       |
| tw        | int(11)             | YES  |     | 0       |       |
| title4    | varchar(96)         | YES  |     |         |       |
+-----------+---------------------+------+-----+---------+-------+
16 rows in set (0.02 sec)

mysql> describe classes;
+-------+------------------+------+-----+---------+----------------+
| Field | Type             | Null | Key | Default | Extra          |
+-------+------------------+------+-----+---------+----------------+
| id    | int(11) unsigned | NO   | PRI |         | auto_increment |
| title | varchar(64)      | YES  |     |         |                |
+-------+------------------+------+-----+---------+----------------+
2 rows in set (0.00 sec)

mysql> describe changelog;
+---------+-------------+------+-----+-------------------+----------------+
| Field   | Type        | Null | Key | Default           | Extra          |
+---------+-------------+------+-----+-------------------+----------------+
| id      | bigint(11)  | NO   | PRI |                   | auto_increment |
| bnum    | varchar(9)  | NO   | MUL |                   |                |
| cl_when | timestamp   | YES  |     | CURRENT_TIMESTAMP |                |
| log     | longtext    | YES  |     |                   |                |
| diff    | longtext    | YES  |     |                   |                |
| cl_who  | varchar(24) | NO   |     |                   |                |
+---------+-------------+------+-----+-------------------+----------------+
6 rows in set (0.00 sec)

mysql> describe favorites;
+-------+------------------+------+-----+---------+----------------+
| Field | Type             | Null | Key | Default | Extra          |
+-------+------------------+------+-----+---------+----------------+
| id    | int(11) unsigned | NO   | PRI |         | auto_increment |
| user  | varchar(24)      | NO   |     |         |                |
| title | varchar(48)      | YES  |     |         |                |
| url   | varchar(96)      | YES  |     |         |                |
+-------+------------------+------+-----+---------+----------------+
4 rows in set (0.00 sec)

mysql> describe users;
+----------+-----------------+------+-----+---------+-------+
| Field    | Type            | Null | Key | Default | Extra |
+----------+-----------------+------+-----+---------+-------+
| username | varchar(24)     | NO   | PRI |         |       |
| iq       | int(3) unsigned | YES  |     | 0       |       |
+----------+-----------------+------+-----+---------+-------+
2 rows in set (0.00 sec)

mysql> describe log;
+----------+--------------+------+-----+-------------------+-------+
| Field    | Type         | Null | Key | Default           | Extra |
+----------+--------------+------+-----+-------------------+-------+
| datetime | timestamp    | YES  |     | CURRENT_TIMESTAMP |       |
| session  | varchar(48)  | NO   |     |                   |       |
| user     | varchar(24)  | NO   |     |                   |       |
| action   | varchar(24)  | NO   |     |                   |       |
| value    | varchar(100) | NO   |     |                   |       |
| title    | varchar(255) | NO   |     |                   |       |
+----------+--------------+------+-----+-------------------+-------+
6 rows in set (0.00 sec)

mysql>