2JM8sJxL

1CREATE TABLE `KABESHNIKI` (
2`id_stud` bigint(20) NOT NULL AUTO_INCREMENT,
3`family` varchar(100) NOT NULL,
4`name` varchar(100) NOT NULL,
5`patronymic` varchar(100) NOT NULL,
6`year` smallint(6) NOT NULL,
7`height` smallint(6) NOT NULL,
8`weight` tinyint(4) NOT NULL,
9`gender` varchar(10) NOT NULL,
10PRIMARY KEY (`id_stud`)
11) ENGINE=InnoDB AUTO_INCREMENT=7 DEFAULT CHARSET=utf8;
12/*!40101 SET character_set_client = @saved_cs_client */;
13
14--
15— Dumping data for table `KABESHNIKI`
16--
17
18LOCK TABLES `KABESHNIKI` WRITE;
19/*!40000 ALTER TABLE `is21` DISABLE KEYS */;
20INSERT INTO `is21` VALUES (1,'Суслов','Игорь','Максимович',1998,161,47,'Мужчина'),(2,'Щербинин','Павел','Максимович',1998,178,75,'Мужчина'),(3,'Егоров','Егор','Егорович',1998,168,70,'Мужчина'),(4,'Тарасов','Дмитрий','Максимович',1998,171,60,'Мужчина'),(5,'КАКОЙТОВ','КАКОЙ','КАКОТОВИЧ',1998,165,65,'Мужчина'),(6,'Пысьев','Александр','Владимирович',1999,180,70,'Мужчина');
21/*!40000 ALTER TABLE `is21` ENABLE KEYS */;
22UNLOCK TABLES;
23
24--
25— Table structure for table `mobila`
26--
27
28DROP TABLE IF EXISTS `mobila`;
29/*!40101 SET @saved_cs_client = @@character_set_client */;
30/*!40101 SET character_set_client = utf8 */;
31CREATE TABLE `mobila` (
32`id_mobila` bigint(20) NOT NULL AUTO_INCREMENT,
33`firma` varchar(100) NOT NULL,
34`marka` varchar(100) NOT NULL,
35`capacity` bigint(20) NOT NULL,
36`time` tinyint(4) NOT NULL,
37`dictaphone` tinyint(1) NOT NULL,
38`format` varchar(100) NOT NULL,
39`camera` tinyint(1) NOT NULL,
40`size_camera` bigint(20) NOT NULL,
41PRIMARY KEY (`id_mobila`)
42) ENGINE=InnoDB AUTO_INCREMENT=7 DEFAULT CHARSET=utf8;
43/*!40101 SET character_set_client = @saved_cs_client */;
44
45--
46— Dumping data for table `mobila`
47--
48
49LOCK TABLES `mobila` WRITE;
50/*!40000 ALTER TABLE `mobila` DISABLE KEYS */;
51INSERT INTO `mobila` VALUES (1,'Samsung','Galaxy S5',2800,21,1,'MP3',1,16),(2,'Huawei','Honor 5C',3000,30,1,'MP3',1,13),(3,'Apple','Iphone 5S',1560,10,1,'MP3',1,8),(4,'Samsung','Galaxy S10',3000,30,1,'MP3',1,12),(5,'Apple','Iphone XS',2658,25,1,'MP3',1,12),(6,'Nokia','8 Dual Sim',3090,50,1,'MP3',1,13);
52/*!40000 ALTER TABLE `mobila` ENABLE KEYS */;
53UNLOCK TABLES;
54
55--
56— Table structure for table `provider`
57--
58
59DROP TABLE IF EXISTS `provider`;
60/*!40101 SET @saved_cs_client = @@character_set_client */;
61/*!40101 SET character_set_client = utf8 */;
62CREATE TABLE `provider` (
63`id_provider` bigint(20) NOT NULL AUTO_INCREMENT,
64`name_provider` varchar(100) NOT NULL,
65`site` varchar(100) NOT NULL,
66PRIMARY KEY (`id_provider`)
67) ENGINE=InnoDB AUTO_INCREMENT=6 DEFAULT CHARSET=utf8;
68/*!40101 SET character_set_client = @saved_cs_client */;
69
70--
71— Dumping data for table `provider`
72--
73
74LOCK TABLES `provider` WRITE;
75/*!40000 ALTER TABLE `provider` DISABLE KEYS */;
76INSERT INTO `provider` VALUES (1,'Ростелеком','ulyanovsk.old.rt.ru'),(2,'Дом.ru','domru.ru'),(3,'Билайн','ulyanovsk.beeline.ru'),(4,'Yota','yota.ru'),(5,'Теле-2','tele2.ru');
77/*!40000 ALTER TABLE `provider` ENABLE KEYS */;
78UNLOCK TABLES;
79
80--
81— Table structure for table `stud_mobila`
82--
83
84DROP TABLE IF EXISTS `stud_mobila`;
85/*!40101 SET @saved_cs_client = @@character_set_client */;
86/*!40101 SET character_set_client = utf8 */;
87CREATE TABLE `stud_mobila` (
88`id_stud` bigint(20) NOT NULL,
89`id_mobila` bigint(20) NOT NULL,
90PRIMARY KEY (`id_stud`,`id_mobila`)
91) ENGINE=InnoDB DEFAULT CHARSET=utf8;
92/*!40101 SET character_set_client = @saved_cs_client */;
93
94--
95— Dumping data for table `stud_mobila`
96--
97
98LOCK TABLES `stud_mobila` WRITE;
99/*!40000 ALTER TABLE `stud_mobila` DISABLE KEYS */;
100INSERT INTO `stud_mobila` VALUES (1,2),(2,1),(3,6),(4,4),(5,3),(6,1);
101/*!40000 ALTER TABLE `stud_mobila` ENABLE KEYS */;
102UNLOCK TABLES;
103
104--
105— Table structure for table `stud_provider`
106--
107
108DROP TABLE IF EXISTS `stud_provider`;
109/*!40101 SET @saved_cs_client = @@character_set_client */;
110/*!40101 SET character_set_client = utf8 */;
111CREATE TABLE `stud_provider` (
112`id_stud` bigint(20) NOT NULL,
113`id_provider` bigint(20) NOT NULL,
114PRIMARY KEY (`id_stud`,`id_provider`)
115) ENGINE=InnoDB DEFAULT CHARSET=utf8;
116/*!40101 SET character_set_client = @saved_cs_client */;
117
118--
119— Dumping data