rendered paste bodymysql> 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>