Stuff

TABLE 'heads'
+--------------------+------------+------+-----+---------------------+----------------+
| Field              | Type       | Null | Key | Default             | Extra          |
+--------------------+------------+------+-----+---------------------+----------------+
| id                 | bigint(20) |      | PRI | NULL                | auto_increment |
| date_indexed       | datetime   |      |     | 0000-00-00 00:00:00 |                |
| last_date_spidered | datetime   |      |     | 0000-00-00 00:00:00 |                |
| pub_date           | datetime   |      |     | 0000-00-00 00:00:00 |                |
| url                | text       |      |     |                     |                |
+--------------------+------------+------+-----+---------------------+----------------+


TABLE 'items' (foreign key on [head_id] references 'heads' [id])
+-------------+--------------+------+-----+---------------------+----------------+
| Field       | Type         | Null | Key | Default             | Extra          |
+-------------+--------------+------+-----+---------------------+----------------+
| id          | bigint(20)   |      | PRI | NULL                | auto_increment |
| head_id     | bigint(20)   |      | MUL | 0                   |                |
| pub_date    | datetime     |      |     | 0000-00-00 00:00:00 |                |
| title       | varchar(120) |      |     |                     |                |
| url         | text         |      |     |                     |                |
| description | text         |      |     |                     |                |
| content     | mediumtext   |      |     |                     |                |
+-------------+--------------+------+-----+---------------------+----------------+