Displaying 1 result from an estimated 1 matches for "fk_cp_subcategory".
2006 Mar 30
5
Heeelp - no idea what''s going wrong.
..._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 try to create a listing with subcategories the array
subcategory_ids is populated correctly, and the lis...