I am trying to create a table and I get the error as shown below.
create table if not exists actual_facilities
( facility_id int not null auto_increment
, business_id int not null
, room_id int not null
, facility_name varchar(64) not null
, CONSTRAINT facilities_fk
FOREIGN KEY (facility_name)
, CONSTRAINT business_id_fk
FOREIGN KEY (business_id)
, CONSTRAINT facilities_room_id_fk
FOREIGN KEY (room_id)
, primary key (facility_id)
, unique key (business_id,room_id,facility_name)
) engine=innodb default charset=latin1;
With regard to the constraints, the table names and columns are correctly named to mathc the other tables/cols.
#1005 - Can't create table
If you have time, please can you lend me your eyes. I am missing something but cannot see what.