-- MySQL dump 10.13  Distrib 5.7.12, for Win32 (AMD64)
--
-- Host: localhost    Database: videos
-- ------------------------------------------------------
-- Server version	5.6.35

/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
/*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
/*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;
/*!40101 SET NAMES utf8 */;
/*!40103 SET @OLD_TIME_ZONE=@@TIME_ZONE */;
/*!40103 SET TIME_ZONE='+00:00' */;
/*!40014 SET @OLD_UNIQUE_CHECKS=@@UNIQUE_CHECKS, UNIQUE_CHECKS=0 */;
/*!40014 SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0 */;
/*!40101 SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='NO_AUTO_VALUE_ON_ZERO' */;
/*!40111 SET @OLD_SQL_NOTES=@@SQL_NOTES, SQL_NOTES=0 */;

--
-- Table structure for table `borrows`
--
Drop schema if exists videos;

CREATE SCHEMA `videos`;

USE videos;

DROP TABLE IF EXISTS `borrows`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `borrows` (
  `borrows_id` int(11) NOT NULL AUTO_INCREMENT,
  `VIDEO` int(11) DEFAULT NULL,
  `MEMBER` int(11) DEFAULT NULL,
  `DATEOFCREATION` date DEFAULT NULL,
  `DATEOFTURNBACK` date DEFAULT NULL,
  PRIMARY KEY (`borrows_id`)
) ENGINE=InnoDB AUTO_INCREMENT=33 DEFAULT CHARSET=utf8 COLLATE=utf8_hungarian_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `borrows`
--

LOCK TABLES `borrows` WRITE;
/*!40000 ALTER TABLE `borrows` DISABLE KEYS */;
INSERT INTO `borrows` VALUES (1,10016,10016,'2017-02-18',NULL),(2,10013,10015,'2017-02-27',NULL),(3,10011,10014,'2017-02-25',NULL),(4,10010,10013,'2017-03-01',NULL),(5,10013,10012,'2016-06-21','2016-07-08'),(6,10016,10014,'2016-09-29','2016-10-01'),(7,10009,10013,'2014-11-06','2015-02-15'),(8,10010,10016,'2017-01-21','2017-01-22'),(9,10011,10015,'2016-12-09','2016-12-17'),(10,10000,10001,'2016-06-08','2016-07-20'),(11,10000,10013,'2016-07-21','2016-08-31'),(12,10000,10003,'2016-09-01','2016-11-02'),(13,10000,10001,'2016-12-07','2016-12-17'),(14,10001,10002,'2016-04-24','2016-04-29'),(15,10001,10006,'2016-06-30','2016-07-13'),(16,10001,10000,'2016-07-24','2016-08-06'),(17,10001,10016,'2016-09-02','2016-09-04'),(18,10001,10003,'2017-01-18','2017-02-18'),(19,10002,10006,'2015-11-05','2015-11-13'),(20,10002,10008,'2017-02-15','2017-02-25'),(21,10003,10008,'2016-12-09','2016-12-18'),(22,10003,10004,'2017-01-16','2017-02-05'),(23,10003,10005,'2017-02-18','2017-02-24'),(24,10004,10006,'2016-12-09','2016-12-17'),(25,10005,10005,'2016-12-28','2017-01-29'),(26,10005,10001,'2017-02-05','2017-02-15'),(27,10005,10005,'2017-02-27',NULL),(28,10006,10006,'2016-12-09','2016-12-17'),(29,10007,10006,'2016-12-10','2017-01-05'),(30,10007,10002,'2017-01-08','2017-02-08'),(31,10007,10004,'2017-02-10','2017-02-15'),(32,10007,10013,'2017-02-22',NULL);
/*!40000 ALTER TABLE `borrows` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `members`
--

DROP TABLE IF EXISTS `members`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `members` (
  `MEMBERID` int(11) NOT NULL,
  `NAME` text COLLATE utf8_hungarian_ci,
  `ADDRESS` text COLLATE utf8_hungarian_ci,
  `DATEOFBIRTH` date DEFAULT NULL,
  `DATEOFCREATION` date DEFAULT NULL,
  `LEVELOFMEMBER` text COLLATE utf8_hungarian_ci,
  PRIMARY KEY (`MEMBERID`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_hungarian_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `members`
--

LOCK TABLES `members` WRITE;
/*!40000 ALTER TABLE `members` DISABLE KEYS */;
INSERT INTO `members` VALUES (10000,'Kovács Károly','9600 Sopron, Ászok u. 11','1982-01-30','2015-11-02','BASIC'),(10001,'Nagy István','7622 Pécs, Malom u. 10','2053-01-07','2011-10-02','SILVER'),(10002,'Kiss Károly','8500 Pápa, Kossuth u. 126','1978-03-02','2015-01-02','BASIC'),(10003,'Nagy Istvan','7622 Pécs, Malom u. 10','1982-09-08','2011-11-02','SILVER'),(10004,'Király István','2500 Esztergom, Kis-Duna sétány 1.','1984-03-02','1997-03-02','BASIC'),(10005,'Fehér Barna','1117 Budapest, Bogdánfy u. 3.','1990-05-18','2014-12-02','GOLD'),(10006,'Vörös Piroska','1111 Budapest, Lágymányosi u. 11.','1989-02-07','2014-05-02','SILVER'),(10007,'Könyves Kálmán','1092 Budapest, Üllői út 101.','2027-08-27','2015-12-02','GOLD'),(10008,'Első Imre','1005 Budapest, Arany János u. 5.','2040-08-16','2016-04-02','BASIC'),(10009,'Illés Béla','1102 Budapest, Hungária krt. 10.','1982-03-02','2017-02-02','BASIC'),(10010,'Bill Gates','Seattle Area','1974-03-02','2017-01-02','SILVER'),(10011,'Will B. Yeats','Burbank, CA','1998-03-02','2016-12-02','BASIC'),(10012,'Conan O\'Bryan','NY 47. Str. 4.','1992-08-02','2016-11-02','BASIC'),(10013,'Johnny B. Good','NY Broadway 234.','1978-03-02','2016-10-02','BASIC'),(10014,'Kovács I. Béla','Budapest Váci út 123.','1994-03-02','2016-05-02','SILVER'),(10015,'Vito Corleone','NY 13. Str.','2053-03-02','2015-03-02','GOLD'),(10016,'Al Bundy','Chicago, IL, next to Marcy','1993-03-02','2015-02-02','GOLD');
/*!40000 ALTER TABLE `members` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `videos`
--

DROP TABLE IF EXISTS `videos`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `videos` (
  `VIDEOID` int(11) NOT NULL,
  `TITLE` text COLLATE utf8_hungarian_ci,
  `APPEARANCE` date DEFAULT NULL,
  `DIRECTOR` text COLLATE utf8_hungarian_ci,
  `DURATION` int(11) DEFAULT NULL,
  `FEE` int(11) DEFAULT NULL,
  `COMMENTLINE` text COLLATE utf8_hungarian_ci,
  `TYPE` text COLLATE utf8_hungarian_ci,
  PRIMARY KEY (`VIDEOID`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_hungarian_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `videos`
--

LOCK TABLES `videos` WRITE;
/*!40000 ALTER TABLE `videos` DISABLE KEYS */;
INSERT INTO `videos` VALUES (10000,'Lock, Stock And Two Smoking Barrels','2008-03-02','Guy Ritchie',120,450,'Angol, szinkronizált','B'),(10001,'Dogma','2009-03-02','Kevin Smith',130,450,'','D'),(10002,'Clerks','2004-03-02','Kevin Smith',95,250,'ff.','B'),(10003,'Gladiator','2010-03-02','Ridley Scott',150,600,'Oscar-díjas','D'),(10004,'Gladiator','2002-03-02','Rowdy Herrington',101,250,'Akció','B'),(10005,'The English Patient','2007-03-02','Anthony Minghella',160,500,'Oscar-díjas','D'),(10006,'Kandi Kamera+','2016-11-02','-',25,150,'rejtett felvételek','B'),(10007,'A botkormányos 2.','2016-06-02','Kovi',75,750,'','D'),(10008,'Le Dernier Combat','2016-03-02','Francis Ford Coppola',120,600,'Oscar-díjas','B'),(10009,'Atlantis','2015-09-02','George Lucas',120,500,'Klasszikus','D'),(10010,'Subway','2008-03-02','Luc Besson',110,800,'','B'),(10011,'Le Grande Bleu','2006-03-02','James Cameron',130,200,'','B'),(10012,'Nikita','2016-03-02','Michael Curtiz',115,400,'','B'),(10013,'Leon','2009-03-02','Sam Mendes',120,600,'Oscar dijas','D'),(10014,'Fifth Element','2019-03-02','Kenneth Branagh',80,600,'Alapmű','D'),(10015,'Jeanne d\'Arc','2015-03-02','Martin Scorsese',60,400,'Kihagyhatatlan','D'),(10016,'Le Transporteur','2016-03-02','Stanley Kubrick',60,400,'','D');
/*!40000 ALTER TABLE `videos` ENABLE KEYS */;
UNLOCK TABLES;
/*!40103 SET TIME_ZONE=@OLD_TIME_ZONE */;

/*!40101 SET SQL_MODE=@OLD_SQL_MODE */;
/*!40014 SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS */;
/*!40014 SET UNIQUE_CHECKS=@OLD_UNIQUE_CHECKS */;
/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
/*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */;
/*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;
/*!40111 SET SQL_NOTES=@OLD_SQL_NOTES */;

-- Dump completed on 2017-10-27  8:23:21
