Displaying 1 result from an estimated 1 matches for "categories_listings".
2006 Mar 30
5
Heeelp - no idea what''s going wrong.
...;
create table subcategories (
id int not null auto_increment
name varchar(100) not null,
category_id int not null,
constraint fk_items_category foreign key (category_id) references
categories(id),
primary key (id)
);
create table listings_subcategories
(practically a duplicate of categories_listings, which works)
subcategory_id int not null,
listing_id int not null,
constraint fk_cp_subcategory foreign key (subcategory_id) references
subcategories(id),
constraint fk_cp_listing foreign key (listing_id) references
listings(id),
primary key (subcategory_id, listing_id)
);
When I...