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