|
CREATE TABLE IF NOT EXISTS link_table (
task_id SMALLINT NOT NULL,
mood_id SMALLINT NOT NULL,
place_id SMALLINT NOT NULL,
FOREIGN KEY (task_id) REFERENCES task (task_id),
FOREIGN KEY (mood_id) REFERENCES mood (mood_id),
FOREIGN KEY (place_id) REFERENCES place (place_id),
PRIMARY KEY (task_id, mood_id, place_id)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
INSERT INTO link_table (task_id, mood_id, place_id)
VALUES ('4','9','5'),
('4','8','7'),
('1','3','8'),
('1','5','9'),
('4','3','5'),
('4','8','5'),
('1','9','5'),
('2','1','5'),
('2','3','6'),
('4','4','10'),
('2','9','3'),
('4','2','9'),
('4','4','5'),
('3','4','4'),
('2','3','8'),
('4','3','2'),
('4','5','4'),
('2','8','2'),
('4','8','3'),
('2','2','4'),
('1','1','4'),
('3','5','10'),
('4','8','10'),
('1','7','5'),
('2','3','9'),
('3','3','8'),
('4','9','3'),
('4','8','9'),
('4','3','6'),
('2','8','2');
|