ySkuFY4t

1-- MySQL dump 10.13  Distrib 5.7.17, for Win64 (x86_64)
2--
3-- Host: localhost    Database: moviestoredb
4-- ------------------------------------------------------
5-- Server version	5.7.19-log
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/*!40101 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 `movie`
20--
21
22DROP TABLE IF EXISTS `movie`;
23/*!40101 SET @saved_cs_client     = @@character_set_client */;
24/*!40101 SET character_set_client = utf8 */;
25CREATE TABLE `movie` (
26  `movieID` int(10) unsigned NOT NULL AUTO_INCREMENT,
27  `movieGenre` varchar(45) DEFAULT NULL,
28  `movieTitle` varchar(45) DEFAULT NULL,
29  `movieDescription` text,
30  `movieYearReleased` varchar(10) DEFAULT NULL,
31  `movieImage` varchar(255) DEFAULT NULL,
32  `movieTrailer` varchar(255) DEFAULT NULL,
33  `movieReleaseDate` date DEFAULT NULL,
34  `movieMPAARating` varchar(10) DEFAULT NULL,
35  `director` varchar(45) NOT NULL,
36  `actor1` varchar(45) NOT NULL,
37  `actor2` varchar(45) NOT NULL,
38  `imdbKey` varchar(45) DEFAULT NULL,
39  `viewCount` int(11) DEFAULT '0',
40  `likeCount` int(11) DEFAULT '0',
41  PRIMARY KEY (`movieID`)
42) ENGINE=InnoDB AUTO_INCREMENT=54 DEFAULT CHARSET=latin1;
43/*!40101 SET character_set_client = @saved_cs_client */;
44
45--
46-- Dumping data for table `movie`
47--
48
49LOCK TABLES `movie` WRITE;
50/*!40000 ALTER TABLE `movie` DISABLE KEYS */;
51INSERT INTO `movie` VALUES (1,'Drama','11:14','Tells the seemingly random yet vitally connected story of a set of incidents that all converge one evening at 11:14pm. The story follows the chain of events of five different characters and five different storylines that all converge to tell the story of murder and deceit.','2003','https://storage.googleapis.com/java419/11_14.jpg','XS8gh5qMlFw','2004-08-20','R','Greg Marcks','Henry Thomas','Blake Heron\r','tt0331811',0,0),(2,'Drama','21 Grams','A freak accident brings together a critically ill mathematician (Penn) a grieving mother (Watts) and a born-again ex-con (Del Toro).','2003','https://storage.googleapis.com/java419/21_Grams.jpg','L2rK8w2ZpGw','2003-12-26','R','Alejandro González Iñárritu','Sean Penn','Naomi Watts\r','tt0315733',0,0),(3,'Drama','25th Hour','Cornered by the DEA convicted New York drug dealer Montgomery Brogan (Norton) reevaluates his life in the 24 remaining hours before facing a seven-year jail term.','2002','https://storage.googleapis.com/java419/25th_Hour.jpg','2qZVGJd6-rI','2003-01-10','R','Spike Lee','Edward Norton','Philip Seymour Hoffman\r','tt0307901',0,0),(4,'Drama','A Beautiful Mind','After a brilliant but asocial mathematician accepts secret work in cryptography his life takes a turn to the nightmarish.','2001','https://storage.googleapis.com/java419/A_Beautiful_Mind.jpg','YWwAOutgWBQ','2002-01-04','PG-13','Ron Howard','Russell Crowe','Ed Harris\r','tt0268978',0,0),(5,'Drama','A Bronx Tale','A father becomes worried when a local gangster befriends his son in the Bronx in the 1960s.','1993','https://storage.googleapis.com/java419/Bronx_Tale.jpg','1bkIqZfviXU','1993-09-29','R','Robert Deniro','Chazz Palminteri','Lillo Brancato\r','tt0106489',1,0),(6,'Drama','A Few Good Men','Neo military lawyer Kaffee defends Marines accused of murder; they contend they were acting under orders.','1992','https://storage.googleapis.com/java419/Few_Good_Men.jpg','ePo91pMcu94','1992-12-11','R','Rob Reiner','Jack Nicholson','Tom Cruise\r','tt0104257',0,0),(7,'Sci-Fi','Alien','A mining ship investigating a suspected SOS lands on a distant planet. The crew discovers some strange creatures and investigates.','1979','https://storage.googleapis.com/java419/Alien.jpg','LjLamj-b0I8','1979-05-25','R','Ridley Scott','Tom Skerritt','Sigourney Weaver\r','tt0078748',0,0),(8,'Sci-Fi','Alien³','Ripley continues to be stalked by a savage alien after her escape pod crashes on a prison planet.','1992','https://storage.googleapis.com/java419/Alien_3.jpg','Ipv1y-Phi7A','1992-05-22','R','David Fincher','Sigourney Weaver','Charles Dutton\r','tt0103644',0,0),(9,'Sci-Fi','Aliens','The planet from Alien (1979) has been colonized but contact is lost. This time the rescue team has impressive firepower enough?','1986','https://storage.googleapis.com/java419/Aliens.jpg','XKSQmYUaIyE','1986-07-18','R','James Cameron','Sigourney Weaver','Carrie Henn\r','tt0090605',0,0),(10,'Drama','Always Outnumbered','An ex-con moves to L.A. to find work and creates a disturbance by fighting for a position.','1998','https://storage.googleapis.com/java419/Always_Outnumbered.jpg','bMgLHo1phOw','1998-03-21','R','Michael Apted','Laurence Fishburne','Daniel Williams\r','tt0146425',11,0),(11,'Drama','Amadeus','The incredible story of Wolfgang Amadeus Mozart told in flashback mode by Antonio Salieri - now confined to an insane asylum.','1984','https://storage.googleapis.com/java419/Amadeus.jpg','r7kWQj9FCGY','1984-09-19','R','Milos Forman','F. Murray Abraham','Tom Hulce\r','tt0086879',0,0),(12,'Drama','American Beauty','Lester Burnham a depressed suburban father in a mid-life crisis decides to turn his hectic life around after developing an infatuation for his daughter\'s attractive friend.','1999','https://storage.googleapis.com/java419/American_Beauty.jpg','3ycmmJ6rxA8','1999-10-01','R','Sam Mendes','Kevin Spacey','Annette Bening\r','tt0169547',0,0),(13,'Drama','American History X','A former neo-nazi skinhead (Norton) tries to prevent his younger brother (Furlong) from going down the same wrong path that he did.','1998','https://storage.googleapis.com/java419/American_History_X.jpg','XfQYHqsiN5g','1998-10-30','R','Tony Kaye','Edward Norton','Edward Furlong\r','tt0120586',0,0),(14,'Drama','Amistad','AMISTAD is about a 1839 mutiny aboard a slave ship that is traveling towards the Northeast Coast of America. Much of the story involves a court-room 1 about the free-man who led the revolt.','1997','https://storage.googleapis.com/java419/Amistad.jpg','BJFDOvGMD0U','1997-12-10','R','Steven Spielberg','Morgna Freeman','Nigel Hawthorne\r','tt0118607',0,0),(15,'Drama','Amores perros','A horrific car accident connects three stories each involving characters dealing with loss regret and life\'s harsh realities all in the name of love.','2000','https://storage.googleapis.com/java419/Amores_perros.jpg','XToRtfQbeHg','2000-06-16','R','Alejandro González Iñárritu','Emilio Echevarría','Gael García Bernal\r','tt0245712',0,0),(16,'Comedy','Anger Management','Sandler plays a businessman who is wrongly sentenced to an anger-management program where he meets an aggressive instructor.','2003','https://storage.googleapis.com/java419/Anger_Manage.jpg','1Gl2kVUsy2M','2003-04-11','PG-13','Peter Segal','Jack Nicholson','Adam Sandler\r','tt0305224',1,0),(17,'Drama','Any Given Sunday','Any Given Sunday is a behind the scenes look at the life and death struggles of modern day gladiators and those who lead them.','1999','https://storage.googleapis.com/java419/Any_Given_Sunday.jpg','RN7sKvaHDlA','1999-12-22','R','Oliver Stone','Al Pacino','Cameron Diaz\r','tt0146838',0,0),(18,'Comedy','Arizona Dream','An Innuit hunter races his sled home with a fresh-caught halibut. This fish pervades the entire film...','1993','https://storage.googleapis.com/java419/Arizona_Dream.jpg','5xgHBIHUqfc','1994-09-09','R','Emir Kusturica','Johnny Depp','Jerry Lewis\r','tt0106307',0,0),(19,'Drama','Arlington Road','A college professor begins to suspect that his neighbour is a terrorist.','1999','https://storage.googleapis.com/java419/Arlington_Road.jpg','nk2CPzIgBRo','1999-07-09','R','Mark Pellington','Jeff Bridges','Tim Robbins\r','tt0137363',0,0),(20,'Comedy','As Good as It Gets','A single mother/waitress a misanthropic author and a gay artist form an unlikely friendship','1997','https://storage.googleapis.com/java419/As_Good_As_It_Gets.jpg','BXHxg6Ug9GM','1997-12-25','PG-13','James Brooks','Jack Nicholson','Helen Hunt\r','tt0119822',2,0),(21,'Action','Assassins','Robert Rath (Sylvester Stallone) is a seasoned hitman who just wants out of the business with no back talk...','1995','https://storage.googleapis.com/java419/Assassins.jpg','OOTTvrb4JZI','1995-10-06','R','Richard Donner','Sylverster Stallone','Antonio Banderas\r','tt0112401',2,0),(22,'Drama','At First Sight','A blind man has an operation to regain his sight at the urging of his girlfriend and must deal with the changes to his life.','1999','https://storage.googleapis.com/java419/At_First_Sight.jpg','os50D-aOZQo','1999-01-15','R','Irwin Winkler','Val Kilmer','Mira Sorvino\r','tt0132512',0,0),(23,'Drama','Autumn in New York','Romantic 1 about an aging playboy who falls for a sweet but terminally ill young woman.','2000','https://storage.googleapis.com/java419/Autumn_In_NewYork.jpg','zACckn8ie-8','2000-08-11','PG-13','Joan Chen','Richard Gere','Winona Ryder\r','tt0174480',0,0),(24,'Drama','Awakenings','The victims of an encephalitis epidemic many years ago have been catatonic ever since but now a new drug offers the prospect of reviving them.','1990','https://storage.googleapis.com/java419/Awakenings.jpg','JAz-prw_W2A','1990-12-20','PG-13','Penny Marshall','Robert De Niro','Julie Kavner\r','tt0099077',0,0),(25,'Drama','Babel','Tragedy strikes a married couple on vacation in the Moroccan desert touching off an interlocking story involving four different families.','2006','https://storage.googleapis.com/java419/Babel.jpg','gzrHrTVaqJs','2006-11-10','R','Alejandro González Iñárritu','Brad Pitt','Cate Blanchett\r','tt0449467',0,0),(26,'Drama','Bang Bang You\'re Dead','For the most part it\'s a tale of a kid Trevor who gets picked on a lot a school. Not as much as he used to...','2002','https://storage.googleapis.com/java419/Bang_Bang_You_Dead.jpg','2WTij_Dzq98','2002-10-13','R','Guy Ferland','Ben Foster','Thomas Cavanagh\r','tt0288439',0,0),(27,'Drama','Basic','A DEA agent investigates the disappearance of a legendary Army ranger drill sergeant and several of his cadets during a training exercise gone severely awry.','2003','https://storage.googleapis.com/java419/Basic.jpg','kE7Ue5hjJc0','2003-03-28','R','John McTiernan','John Travolta','Samuel L. Jackson\r','tt0264395',0,0),(28,'Drama','Basic Instinct','A police detective is in charge of the investigation of a brutal murder in which a beautiful and seductive woman could be involved.','1992','https://storage.googleapis.com/java419/Basic_Instinct.jpg','JvoWfLOa55k','1992-03-20','R','Paul Verhoeven','Michael Douglas','Sharon Stone\r','tt0103772',0,0),(29,'Drama','Before Sunset','It\'s nine years after Jesse and Celine first met; now they encounter one another on the French leg of Jesse\'s book tour.','2004','https://storage.googleapis.com/java419/Before_Sunset.jpg','oI3UuneLcyU','2004-06-17','R','Richard Linklater','Ethan Hawke','Julie Delpy\r','tt0381681',0,0),(30,'Comedy','Being John Malkovich','A puppeteer discovers a portal that leads literally into the head of the movie star John Malkovich.','1999','https://storage.googleapis.com/java419/Being_John.jpg','2UuRFr0GnHM','1999-11-24','R','Spike Jonze','Cameron Diaz','John Malkovich\r','tt0120601',0,0),(31,'Drama','Best Laid Plans','Ever feel like the world is conspiring against you... You don\'t have to tell me where you\'ve been... Everyone sucks but us... keeping a relationship alive can be murder.','1999','https://storage.googleapis.com/java419/Best_Laid_Plans.jpg','8H6yHBc3nvI','1999-05-14','R','Mike Barker','Alessandro Nivola','Reese Witherspoon\r','tt0133412',0,0),(32,'Sci-Fi','Bicentennial Man','An android endeavors to become human as he gradually acquires emotions.','1999','https://storage.googleapis.com/java419/Bicent_Man.jpg','nZ7HxlhVDyM','1999-12-17','PG','Chris Columbus','Robin Williams ','Embeth Davidtz\r','tt0182789',0,0),(33,'Drama','Big Fish','A story about a son trying to learn more about his dying father by reliving stories and myths his father told him about himself.','2003','https://storage.googleapis.com/java419/Big_Fish.jpg','M3YVTgTl-F0','2004-01-09','PG-13','Tim Burton','Ewan McGregor','Albert Finney\r','tt0319061',0,0),(34,'Drama','Birdy','Two friends arrive back from Vietnam scarred in different ways. One has physical injuries the other...','1984','https://storage.googleapis.com/java419/Birdy.jpg','hfGwJGrLz2w','1984-12-21','R','Alan Parker','Matthew Modine','Nicholas Cage\r','tt0086969',0,0),(35,'Comedy','Birthday Girl','A thirtysomething bank clerk from St Albans has his small-town life exploded by the arrival of his Russian mail-order bride.','2001','https://storage.googleapis.com/java419/Birthday_Girl.jpg','QZsi-SQmljI','2002-02-01','R','Jez Butterworth','Nicole Kidman','Ben Chaplin\r','tt0188453',0,0),(36,'Drama','Blow','The story of George Jung the man who established the American cocaine market in the 1970\'s.','2001','https://storage.googleapis.com/java419/Blow.jpg','scWkP1GdnuU','2001-04-06','R','Ted Demme','Johnny Depp','Penélope Cruz\r','tt0221027',0,0),(37,'Horror','Book of Shadows: Blair Witch 2','College students at a Boston college become fascinated by the events of the three missing filmmakers in Maryland so they decide to go into the same woods and find out what really happened.','2000','https://storage.googleapis.com/java419/Blair_Witch_2.jpg','8WtrIgbvsWU','2000-10-27','R','Joe Berlinger','Kim Director','Kurt Loder\r','tt0229260',0,0),(38,'Drama','Boss of Bosses','The story of the rise and fall of the powerful New York City organized crime boss Paul Castellano.','2001','https://storage.googleapis.com/java419/Boss_Of_Bosses.jpg','shSjnxcY1I8','2005-07-19','R','Dwight Little','Angela Alvarado ','Chazz Palminteri\r','tt0205782',0,0),(39,'Drama','Bounce','A man switches plane tickets with another man who dies in that plane in a crash. The man falls in love with the deceased one\'s wife.','2000','https://storage.googleapis.com/java419/Bounce.jpg','ieJSJXWLK_c','2000-11-15','PG-13','Don Roos','Ben Affleck','Gweneth Paltrow\r','tt0186894',0,0),(40,'Drama','Bringing Out the Dead','Frank Pierce is a paramedic working Gotham\'s Hell\'s Kitchen. He\'s become burned out and haunted by visions of the people he\'s tried to save.','1999','https://storage.googleapis.com/java419/Bringing_Out_Dead.jpg','sfUwvmRmMtw','1999-10-22','R','Martin Scorsese','Nicholas Cage','Patricia Arquette\r','tt0163988',6,0),(41,'Comedy','Buffalo \'66','Billy is released after five years in prison. In the next moment he kidnaps teenage student Layla and visits his parents with her...','1998','https://storage.googleapis.com/java419/Buffalo.jpg','pY0H49c4q_Q','1998-06-26','R','Vincent Gallo','Christina Ricci','Mickey Rourke\r','tt0118789',0,0),(42,'Drama','Carandiru','Film based on real life experiences of doctor Drauzio Varella inside dreadful State penitentiary Carandiru...','2003','https://storage.googleapis.com/java419/Carandiru.jpg','0fKI6uwZbxM','2003-04-11','R','Hector Babenco','Luis Carlos Vasconelos','Milton Gonçalves\r','tt0293007',0,0),(43,'Drama','Carlito\'s Way','A Puerto-Rican ex-con just released from prison pledges to stay away from drugs and violence despite the pressure around him and lead on to a better life outside of NYC.','1993','https://storage.googleapis.com/java419/Carlito.jpg','FbXrkKmCTok','1993-11-10','R','Brian DePalma','Sean Penn','Al Pacino\r','tt0106519',0,0),(44,'Drama','Carne trémula','After leaving jail Víctor is still in love with Elena but she\'s married to the former cop -now basketball player- who became paralysed by a shot from Víctor\'s gun...','1997','https://storage.googleapis.com/java419/Live_Flesh.jpg','m0BAPZJJbP0','1998-01-16','R','Pedro Almodóvar','Penélope Cruz','Javier Bardem\r','tt0438912',0,0),(45,'Drama','Casino','Greed deception money power and murder occur between two mobster best friends and a trophy wife over a gambling empire.','1995','https://storage.googleapis.com/java419/Casino.jpg','EJXDMwGWhoA','1995-11-22','R','Martin Scorsese','Robert De Niro','Joe Pesci\r','tt0112641',0,0),(46,'Drama','Cast Away','A FedEx executive must transform himself physically and emotionally to survive a crash landing on a deserted island.','2000','https://storage.googleapis.com/java419/Castaway.jpg','2TWYDogv4WQ','2000-12-22','PG-13','Robert Zemeckis','Tom Hanks','Lari White\r','tt0162222',0,0),(47,'Drama','Catch Me If You Can','A true story about Frank Abagnale Jr. who before his 19th birthday successfully conned millions of dollars worth of checks as a Pan Am pilot doctor and legal prosecutor.','2002','https://storage.googleapis.com/java419/Catch_Me_If_You_Can.jpg','71rDQ7z4eFg','2002-12-25','PG-13','Steven Spielberg','Tom Hanks','Leonarod DiCaprio\r','tt0264464',1,0),(48,'Drama','Changing Lanes','The story of what happens one day in New York when a young lawyer and a businessman share a small automobile accident on F.D.R. Drive and their mutual road rage escalates into a feud...','2002','https://storage.googleapis.com/java419/Changing_Lanes.jpg','UvIwotyCFuo','2002-04-12','R','Roger Michell','Samuel L. Jackson','Ben Affleck\r','tt0264472',0,0),(49,'Drama','Cidade de Deus','Two boys growing up in a violent neighborhood of Rio de Janeiro take different paths: one becomes a photographer the other a drug dealer.','2002','https://storage.googleapis.com/java419/City_Of_God.jpg','pUt-yPxOZqk','2002-08-30','R','Fernando Meirelles','Alexandre Rodrigues','Leandro Firmino\r','tt0317248',0,0),(50,'Drama','City by the Sea','Vincent Lamarca whose father was executed for a 1950s kidnapping of a child grew up to become a police officer only to see his own son become a murderer.','2002','https://storage.googleapis.com/java419/City_By_The_Sea.jpg','W5SKcTTd350','2002-09-06','R','Michael Caton-Jones','Robert De Niro','Frances McDormand\r','tt0269095',0,0),(51,'Action','The Avengers','Nick Fury of S.H.I.E.L.D. brings together a team of super humans to form The Avengers to help save the Earth from Loki and his army.','2012','https://storage.googleapis.com/java419/The_Avengers.jpg','eOrNdBpGMv8','2012-09-25','PG-13','Joss Whedon','Robert Downey Jr.','Chris Evans','tt0848228',0,0),(52,'Action','Terminator 2: Judgment Day','The cyborg who once tried to kill Sarah Connor is dead, and another T-101 must now protect her teenage son, John Connor, from an even more powerful and advanced Terminator, the T-1000.','1991','https://storage.googleapis.com/java419/Terminator_2.jpg','oL1RE8JXaIw','1997-10-22','R','James Cameron','Arnold Schwarzenegger','Linda Hamilton','tt0103064',4,0),(53,'Sci-Fi','Prometheus','A team of explorers discover a clue to the origins of mankind on Earth, leading them on a journey to the darkest corners of the universe. There, they must fight a terrifying battle to save the future of the human race. ','2012','https://storage.googleapis.com/java419/Prometheus.jpg','sftuxbvGwiU','2012-10-09','R','Ridley Scott','Noomi Rapace','Logan-Marshall-Green','tt1446714',0,0);
52/*!40000 ALTER TABLE `movie` ENABLE KEYS */;
53UNLOCK TABLES;
54/*!40103 SET TIME_ZONE=@OLD_TIME_ZONE */;
55
56/*!40101 SET SQL_MODE=@OLD_SQL_MODE */;
57/*!40014 SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS */;
58/*!40014 SET UNIQUE_CHECKS=@OLD_UNIQUE_CHECKS */;
59/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
60/*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */;
61/*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;
62/*!40111 SET SQL_NOTES=@OLD_SQL_NOTES */;
63
64-- Dump completed on 2017-12-13 13:21:27