j7d2FP6F

1DROP TABLE IF EXISTS `training2target`;
2SET @saved_cs_client     = @@character_set_client;
3SET character_set_client = utf8;
4CREATE TABLE `training2target` (
5  `training_name` varchar(255) collate utf8_unicode_ci NOT NULL default '',
6  `target_name` varchar(255) collate utf8_unicode_ci NOT NULL default '',
7  PRIMARY KEY  (`training_name`,`target_name`),
8  KEY `training2target_target_name_coursetarget_name` (`target_name`),
9  CONSTRAINT `training2target_target_name_coursetarget_name` FOREIGN KEY (`target_name`) REFERENCES `coursetarget` (`name`),
10  CONSTRAINT `training2target_training_name_training_name` FOREIGN KEY (`training_name`) REFERENCES `training` (`name`)
11) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
12SET character_set_client = @saved_cs_client;