· 5 years ago · Apr 23, 2020, 04:58 AM
1-- MySQL dump 10.13 Distrib 8.0.19, for Win64 (x86_64)
2--
3-- Host: localhost Database: mydb
4-- ------------------------------------------------------
5-- Server version 8.0.19
6
7/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
8/*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
9/*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;
10/*!50503 SET NAMES utf8 */;
11/*!40103 SET @OLD_TIME_ZONE=@@TIME_ZONE */;
12/*!40103 SET TIME_ZONE='+00:00' */;
13/*!40014 SET @OLD_UNIQUE_CHECKS=@@UNIQUE_CHECKS, UNIQUE_CHECKS=0 */;
14/*!40014 SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0 */;
15/*!40101 SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='NO_AUTO_VALUE_ON_ZERO' */;
16/*!40111 SET @OLD_SQL_NOTES=@@SQL_NOTES, SQL_NOTES=0 */;
17
18--
19-- Table structure for table `student`
20--
21
22DROP TABLE IF EXISTS `student`;
23/*!40101 SET @saved_cs_client = @@character_set_client */;
24/*!50503 SET character_set_client = utf8mb4 */;
25CREATE TABLE `student` (
26 `Stud_ID` int NOT NULL,
27 `Fname` varchar(45) NOT NULL,
28 `Surname` varchar(45) NOT NULL,
29 `PPSN` varchar(45) NOT NULL,
30 `DOB` varchar(45) NOT NULL,
31 `PhoneNumber` int NOT NULL,
32 `Address1` varchar(45) NOT NULL,
33 `Address2` varchar(45) NOT NULL,
34 `Adress3` varchar(45) NOT NULL,
35 `Nationality` varchar(45) NOT NULL,
36 `Course` varchar(100) DEFAULT NULL,
37 `Group_name` varchar(45) DEFAULT NULL,
38 `Emial` varchar(45) NOT NULL,
39 `Class Group_Class_Name` varchar(20) DEFAULT NULL,
40 PRIMARY KEY (`Stud_ID`),
41 KEY `fk_Student_Class Group_idx` (`Class Group_Class_Name`),
42 CONSTRAINT `fk_Student_Class Group` FOREIGN KEY (`Class Group_Class_Name`) REFERENCES `class group` (`Class_Name`)
43) ENGINE=InnoDB DEFAULT CHARSET=utf8;
44/*!40101 SET character_set_client = @saved_cs_client */;
45
46--
47-- Dumping data for table `student`
48--
49
50LOCK TABLES `student` WRITE;
51/*!40000 ALTER TABLE `student` DISABLE KEYS */;
52INSERT INTO `student` VALUES (12,'Dawid','Wejmanenk','1312423H','20150300',123456787,'50b','upper','super','Ireland',' Software Development 6M0691','APP','DawidWejman303@interia.pl','asdas'),(13,'Dawidek','Wejmanek','124152112H','1999-04-04',123145153,'50Dunry','Athenry','CoGalway','PL','Fashion Design 5M3865',NULL,'DawidekWejmanek303@interios.pl',NULL),(14,'patryk','Piatek','12541325H','1999-03-03',312541244,'2Bdun','Athenry','Galway','PL','Programming & Software Development 5M0529',NULL,'Patryk202@gmail.com',NULL),(17,'HHHH','HHHH','14124H','1999-03-03',4124812,'weqne1','reweq','awas','PL','Fashion Design 5M3865','PLS','hnerduneas',NULL),(113,'TESTnr3','TESTER@@@','213123123H','1700-03-04',41241241,'ffdfdsfaasd','fsdfsd','dada','GER','AD in Software Development 6M0691','APPD','dasdasdas@@@@','APPD'),(122,'fasdf','dasd','21312451H','2000-03-03',3125114,'rwero','ereubjoieq','dofewq','wqe','Advanced Certificate in Fashion Buying, Styling and Visual Merchandising 6M4508','dasd','fsdqwi',NULL),(213,'das','adsd','21312d','2000-04-04',312132213,'dadasasdjoih`','rweqsdaq','fasnowq','FDJ','ie','AD in Software Development 6M0691','APPD','APPD'),(231,'das','dda','213125g','2000-03-03',3221541,'weib','sdqid','dqiwb','diqw','Fashion Design 5M3865','eqw','fsdejb','APPD'),(321,'dasda','das','3213213','2000-03-03',31241245,'fsdfdas','fasda','fasedas','erewr','asa','AD in Software Development 6M0691','APPD','APPD'),(1000,'adsda','das','214214124G','1997-03-03',32215141,'dasdaui!@indted','eqwasfdsda','qcsdd','fsdda','HE','AD in Software Development 6M0691','APPD','APPD'),(1111,'Patryk','Dawid','sada','1999-03-03',3123123,'dasdas','asda','fsddasdq','fassdfa','PL','AD in Software Development 6M0691','ASD','ASD'),(2222,'patryki','iPiatek','125413235H','1999-03-04',312541244,'2Bdunsda','Athenryas','Galwaydsa','IE','Programming & Software Development 5M0529',NULL,'Patryk202@gmaileeee.com',NULL),(1221312,'wqe','dwweq','21353','2000-03-03',237821487,'4534DN','fjek','Galway','PL','Fashion Design 5M3865',NULL,'Dawidwoe@interia','APPD');
53/*!40000 ALTER TABLE `student` ENABLE KEYS */;
54UNLOCK TABLES;
55/*!40103 SET TIME_ZONE=@OLD_TIME_ZONE */;
56
57/*!40101 SET SQL_MODE=@OLD_SQL_MODE */;
58/*!40014 SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS */;
59/*!40014 SET UNIQUE_CHECKS=@OLD_UNIQUE_CHECKS */;
60/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
61/*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */;
62/*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;
63/*!40111 SET SQL_NOTES=@OLD_SQL_NOTES */;
64
65-- Dump completed on 2020-04-22 4:02:43