vee2RXMJ

1--
2-- Table structure for table `someregistration`
3--
4
5DROP TABLE IF EXISTS `someregistration`;
6/*!40101 SET @saved_cs_client     = @@character_set_client */;
7/*!40101 SET character_set_client = utf8 */;
8CREATE TABLE `someregistration` (
9  `user_login` varchar(64) NOT NULL,
10  `contest_id` varchar(255) NOT NULL,
11  `someData` varchar(255) DEFAULT NULL,
12  PRIMARY KEY (`user_login`,`contest_id`),
13  KEY `contest_id` (`contest_id`),
14  CONSTRAINT `someregistration_ibfk_1` FOREIGN KEY (`user_login`) REFERENCES `registration` (`user_login`) ON DELETE CASCADE,
15  CONSTRAINT `someregistration_ibfk_2` FOREIGN KEY (`contest_id`) REFERENCES `registration` (`contest_id`) ON DELETE CASCADE
16) ENGINE=InnoDB DEFAULT CHARSET=utf8;
17/*!40101 SET character_set_client = @saved_cs_client */;
18
19
20
21--
22-- Table structure for table `registration`
23--
24
25DROP TABLE IF EXISTS `registration`;
26/*!40101 SET @saved_cs_client     = @@character_set_client */;
27/*!40101 SET character_set_client = utf8 */;
28CREATE TABLE `registration` (
29  `user_login` varchar(64) NOT NULL,
30  `contest_id` varchar(255) NOT NULL,
31  `objectType` varchar(40) DEFAULT NULL,
32  PRIMARY KEY (`user_login`,`contest_id`),
33  KEY `ix_registration_user_login` (`user_login`),
34  KEY `ix_registration_contest_id` (`contest_id`),
35  CONSTRAINT `registration_contest_id_fk` FOREIGN KEY (`contest_id`) REFERENCES `contest` (`id`),
36  CONSTRAINT `registration_user_login_fk` FOREIGN KEY (`user_login`) REFERENCES `user` (`login`)
37) ENGINE=InnoDB DEFAULT CHARSET=utf8;
38/*!40101 SET character_set_client = @saved_cs_client */;