mysql> desc feeds; +-------+------------------------------------------+------+-----+------------------+----------------+ | Field | Type | Null | Key | Default | Extra | +-------+------------------------------------------+------+-----+------------------+----------------+ | id | int(10) | | PRI | NULL | auto_increment | | type | enum('static','comic','feed','userfeed') | | | static | | | title | char(100) | | | (no title given) | | +-------+------------------------------------------+------+-----+------------------+----------------+ 3 rows in set (0.00 sec) mysql> desc items; +--------+-----------+------+-----+---------+----------------+ | Field | Type | Null | Key | Default | Extra | +--------+-----------+------+-----+---------+----------------+ | id | int(10) | | PRI | NULL | auto_increment | | feedid | int(10) | | | 0 | | | title | char(100) | | | | | +--------+-----------+------+-----+---------+----------------+ 3 rows in set (0.00 sec) mysql> desc feeddata; +--------+--------------+------+-----+---------+-------+ | Field | Type | Null | Key | Default | Extra | +--------+--------------+------+-----+---------+-------+ | feedid | int(10) | | PRI | 0 | | | key | varchar(250) | | | | | | value | text | YES | | NULL | | +--------+--------------+------+-----+---------+-------+ 3 rows in set (0.00 sec) mysql> desc itemdata; +--------+--------------+------+-----+---------+-------+ | Field | Type | Null | Key | Default | Extra | +--------+--------------+------+-----+---------+-------+ | itemid | int(10) | | PRI | 0 | | | key | varchar(250) | | | | | | value | text | YES | | NULL | | +--------+--------------+------+-----+---------+-------+ 3 rows in set (0.00 sec)