aZaDFrGP

1DROP TABLE IF EXISTS `group`;
2/*!40101 SET @saved_cs_client     = @@character_set_client */;
3/*!40101 SET character_set_client = utf8 */;
4CREATE TABLE `group` (
5  `id` int(11) unsigned NOT NULL AUTO_INCREMENT,
6  `name` varchar(255) DEFAULT NULL,
7  PRIMARY KEY (`id`)
8) ENGINE=InnoDB AUTO_INCREMENT=6 DEFAULT CHARSET=utf8;
9/*!40101 SET character_set_client = @saved_cs_client */;
10
11--
12-- Dumping data for table `group`
13--
14
15LOCK TABLES `group` WRITE;
16/*!40000 ALTER TABLE `group` DISABLE KEYS */;
17INSERT INTO `group` VALUES (1,'runners'),(2,'cyclists'),(3,'swimmers'),(4,'coders'),(5,'divers');
18/*!40000 ALTER TABLE `group` ENABLE KEYS */;
19UNLOCK TABLES;
20
21--
22-- Table structure for table `group_user`
23--
24
25DROP TABLE IF EXISTS `group_user`;
26/*!40101 SET @saved_cs_client     = @@character_set_client */;
27/*!40101 SET character_set_client = utf8 */;
28CREATE TABLE `group_user` (
29  `id` int(11) unsigned NOT NULL AUTO_INCREMENT,
30  `group_id` int(11) unsigned NOT NULL,
31  `user_id` int(11) NOT NULL,
32  `is_admin` tinyint(1) DEFAULT NULL,
33  PRIMARY KEY (`id`),
34  KEY `fk_group_user_group_idx` (`group_id`),
35  KEY `fk_group_user_user1_idx` (`user_id`),
36  CONSTRAINT `fk_group_user_group` FOREIGN KEY (`group_id`) REFERENCES `group` (`id`) ON DELETE CASCADE ON UPDATE NO ACTION,
37  CONSTRAINT `fk_group_user_user1` FOREIGN KEY (`user_id`) REFERENCES `user` (`id`) ON DELETE CASCADE ON UPDATE NO ACTION
38) ENGINE=InnoDB AUTO_INCREMENT=6 DEFAULT CHARSET=utf8;
39/*!40101 SET character_set_client = @saved_cs_client */;
40
41--
42-- Dumping data for table `group_user`
43--
44
45LOCK TABLES `group_user` WRITE;
46/*!40000 ALTER TABLE `group_user` DISABLE KEYS */;
47INSERT INTO `group_user` VALUES (1,2,7,1),(2,1,6,0),(3,2,6,1),(4,2,9,0),(5,1,9,1);
48/*!40000 ALTER TABLE `group_user` ENABLE KEYS */;
49UNLOCK TABLES;
50
51--
52-- Table structure for table `user`
53--
54
55DROP TABLE IF EXISTS `user`;
56/*!40101 SET @saved_cs_client     = @@character_set_client */;
57/*!40101 SET character_set_client = utf8 */;
58CREATE TABLE `user` (
59  `id` int(11) NOT NULL AUTO_INCREMENT,
60  `name` varchar(255) DEFAULT NULL,
61  `country_id` int(11) NOT NULL,
62  PRIMARY KEY (`id`),
63  KEY `fk_user_country1_idx` (`country_id`),
64  CONSTRAINT `fk_user_country1` FOREIGN KEY (`country_id`) REFERENCES `country` (`id`) ON DELETE CASCADE ON UPDATE NO ACTION
65) ENGINE=InnoDB AUTO_INCREMENT=10 DEFAULT CHARSET=utf8;
66/*!40101 SET character_set_client = @saved_cs_client */;
67
68--
69-- Dumping data for table `user`
70--
71
72LOCK TABLES `user` WRITE;
73/*!40000 ALTER TABLE `user` DISABLE KEYS */;
74INSERT INTO `user` VALUES (1,'John54',2),(6,'Steven',2),(7,'Paul',1),(8,'Janis',3),(9,'Семен',5);
75/*!40000 ALTER TABLE `user` ENABLE KEYS */;
76UNLOCK TABLES;
77
78--
79-- Table structure for table `country`
80--
81
82DROP TABLE IF EXISTS `country`;
83/*!40101 SET @saved_cs_client     = @@character_set_client */;
84/*!40101 SET character_set_client = utf8 */;
85CREATE TABLE `country` (
86  `id` int(11) NOT NULL AUTO_INCREMENT,
87  `name` varchar(255) DEFAULT NULL,
88  PRIMARY KEY (`id`)
89) ENGINE=InnoDB AUTO_INCREMENT=6 DEFAULT CHARSET=utf8;
90/*!40101 SET character_set_client = @saved_cs_client */;
91
92--
93-- Dumping data for table `country`
94--
95
96LOCK TABLES `country` WRITE;
97/*!40000 ALTER TABLE `country` DISABLE KEYS */;
98INSERT INTO `country` VALUES (1,'UK'),(2,'US'),(3,'Latvia'),(4,'Norway'),(5,'Russia');
99/*!40000 ALTER TABLE `country` ENABLE KEYS */;
100UNLOCK TABLES;
101/*!40103 SET TIME_ZONE=@OLD_TIME_ZONE */;