vGzUn2F7

1Cannot add or update a child row: a foreign key constraint fails (`database`.`Goal_data`, CONSTRAINT `Goal_data_ibfk_1` FOREIGN KEY (`goal_id`) REFERENCES `Goals` (`id`))
2	
3CREATE TABLE IF NOT EXISTS Goals (
4    id int(3) NOT NULL,
5    profileId int(11),
6    accountId int(11) NOT NULL,
7    created DATETIME COLLATE utf8_bin,
8    eventDetails varchar(255),
9    internalWebPropertyId int(11),
10    kind varchar(20),
11    goal_name varchar(255),
12    goal_type varchar(20),
13    updated DATETIME COLLATE utf8_bin,
14    goal_value varchar(20),
15    webPropertyId varchar(20),
16    active varchar(20),
17
18    PRIMARY KEY (id, profileId),
19FOREIGN KEY (profileId) REFERENCES Profiles(profile_id)
20) DEFAULT CHARSET=utf8 COLLATE=utf8_bin AUTO_INCREMENT=1 ;
21	
22CREATE TABLE IF NOT EXISTS Goal_data (
23    goal_id int(3) NOT NULL,
24    profile_id int(11) NOT NULL,
25    goal_date DATETIME COLLATE utf8_bin,
26    goalCompletions int(11) NOT NULL,
27    source varchar(255),
28    medium varchar(255),
29    default_channel_grouping varchar(255),
30    keyword varchar(255),
31
32    channel varchar(255),
33    PRIMARY KEY (profile_id, goal_id, goal_date, source, medium, keyword),
34    FOREIGN KEY (goal_id) REFERENCES Goals(id),
35    FOREIGN KEY (profile_id) REFERENCES Goals(profileId)
36
37) DEFAULT CHARSET=utf8 COLLATE=utf8_bin AUTO_INCREMENT=1 ;
38	
39CONSTRAINT FK_goal FOREIGN KEY (goal_id, profile_id) REFERENCES google_analytics_goals(id, profileId)