H2zm97zS

1CREATE TABLE IF NOT EXISTS `task_responsible` (
2  `id` int(11) NOT NULL AUTO_INCREMENT,
3  `task_id` bigint(20) NOT NULL,
4  `user_id` bigint(20) unsigned NOT NULL,
5  `created` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
6  PRIMARY KEY (`id`),
7  KEY `task_id` (`task_id`),
8  KEY `user_id` (`user_id`)
9) ENGINE=InnoDB  DEFAULT CHARSET=utf8 AUTO_INCREMENT=117 ;
10
11--
12-- Megkötések a kiírt táblákhoz
13--
14
15--
16-- Megkötések a táblához `task_responsible`
17--
18ALTER TABLE `task_responsible`
19  ADD CONSTRAINT `fk_task_responsible_task` FOREIGN KEY (`task_id`) REFERENCES `task` (`id`) ON DELETE CASCADE ON UPDATE CASCADE,
20  ADD CONSTRAINT `fk_task_responsible_user` FOREIGN KEY (`user_id`) REFERENCES `user` (`id`) ON DELETE CASCADE ON UPDATE CASCADE;