New answers tagged mysql-5
0
I think you need a third table, orders, which connects the items and persons.
Tables
CREATE TABLE IF NOT EXISTS `persons` (
`person_id` int(4) NOT NULL AUTO_INCREMENT,
`name` varchar(100) NOT NULL,
PRIMARY KEY (`person_id`)
);
CREATE TABLE IF NOT EXISTS `items` (
`item_id` int(4) NOT NULL AUTO_INCREMENT,
`item_type` varchar(50) NOT NULL,
...
Top 50 recent answers are included
