7r2cmdRv

1--
2-- Table structure for table `oiregistration`
3--
4
5DROP TABLE IF EXISTS `oiregistration`;
6/*!40101 SET @saved_cs_client     = @@character_set_client */;
7/*!40101 SET character_set_client = utf8 */;
8CREATE TABLE `oiregistration` (
9  `user_login` varchar(64) NOT NULL,
10  `contest_id` varchar(255) NOT NULL,
11  `region` varchar(255) DEFAULT NULL,
12  `city` varchar(255) DEFAULT NULL,
13  `postalCode` varchar(20) DEFAULT NULL,
14  `address` varchar(255) DEFAULT NULL,
15  `school` varchar(255) DEFAULT NULL,
16  `educationStage` int(11) DEFAULT NULL,
17  `schoolType` varchar(255) DEFAULT NULL,
18  `placeOfBirth` varchar(255) DEFAULT NULL,
19  `birthDate` date DEFAULT NULL,
20  `tshirtSize` varchar(5) DEFAULT NULL,
21  `phone` varchar(20) DEFAULT NULL,
22  PRIMARY KEY (`user_login`,`contest_id`),
23  CONSTRAINT `oiregistration_ibfk_1` FOREIGN KEY (`user_login`, `contest_id`) REFERENCES `registration` (`user_login`, `contest_id`) ON DELETE CASCADE
24) ENGINE=InnoDB DEFAULT CHARSET=utf8;
25/*!40101 SET character_set_client = @saved_cs_client */;