MySQL Query Browser

[Frank Amponsah]

Below is a script i think should be running correctly.

CREATE TABLE Sponsor(SponsorID INT, 
    Companyname VARCHAR (20),
    ActivitiesID INT NOT NULL,
    UNIQUE(ActivitiesID),
    Foreign Key (ActivitiesID)REFERENCES Activities(ActivitiesID),
    Primary Key (SponsorID)) ENGINE=InnoDB;
 
INSERT INTO Sponsor VALUES (1,'Red Bull'),(2,'Nike')
,(3,'YMCA'),(4,'Mercedes'),(5,'Lucozade'),(6,'BHF');
 
CREATE TABLE Activities(ActivitiesID INT, 
    Name VARCHAR (20), Maxcapacity INT, 
    StartTime TIME, EndTime TIME,
    Primary Key (ActivitiesID)) ENGINE=InnoDB;
 
INSERT INTO Activities VALUES (1,'Aerobics', 3,
 '10:00:00', '12:00:00'),(2,'Bicycling', 6, 
'08:30:00', '13:00:00'), (3,'Circuit', 10, 
'14:00:00', '16:30:00'), (4,'Rowing', 5, 
'06:00:00', '15:00:00'), (5,'Swimming', 4,
'13:30:00', '17:00:00'), (6,'Badminton', 8, 
'15:30:00', '17:30:00');

But whenever i run the above queries, I get 'can't create sponsor'; errono 150.

How do i correct this?

[Dormilich]

from the manual:

1005 (ER_CANT_CREATE_TABLE)

Cannot create table. If the error message refers to error 150, table creation failed because a foreign key constraint was not correctly formed. If the error message refers to error –1, table creation probably failed because the table includes a column name that matched the name of an internal InnoDB table.

so it seems that something is wrong with your FK definition. (e.g. the Activities table does not exist yet)