-
Notifications
You must be signed in to change notification settings - Fork 1
/
run.sql
8 lines (8 loc) · 2.77 KB
/
run.sql
1
2
3
4
5
6
7
8
CREATE DATABASE videoLib;
use videoLib;
CREATE TABLE users(id INT, name TEXT, address TEXT);
CREATE TABLE given(id INT, name VARCHAR(250), data VARCHAR(250), film VARCHAR(250));
CREATE TABLE film_info(id INT, name VARCHAR(250), genre VARCHAR(250), producer VARCHAR(250), studio VARCHAR(250), actors VARCHAR(250), brief_abstract TEXT);
INSERT INTO `film_info` VALUES (1,'The Shawshank Redemption','Drama','Frank Darabont','USA','Tim Robbins, Morgan Freeman, Bob Gunton, William Sadler, Clancy Brown Gil Bellows James Whitmore','Banker Andy Dufresne is convicted of murdering his wife and her lover and is sentenced to two consecutive life sentences at the Shawshank State Penitentiary. He is befriended by Ellis \"Red\" Redding,an inmate and prison.'),(2,'The Intouchables','Drama','Nicolas Duval Adassovsky, Yann Zenou','France','François Cluzet, Omar Sy','At night in Paris, Driss is driving Philippe\'s Maserati Quattroporte at high speed. They are chased through the streets by the police and eventually cornered. Driss claims the quadriplegic Philippe must be urgently driven to the emergency room;'),(3,'Joker','Drama','Todd Phillips','USA','Joaquin Phoenix, Robert De Niro, Zazie Beetz ,Frances Conroy','Fleck lives with his mother, Penny, in Gotham City. Gotham is rife with crime and unemployment, leaving swathes of the population disenfranchised and impoverished. Arthur suffers from a medical disorder that causes him to laugh at inappropriate times'),(4,'Heroes','Drama','David Foster','United States','Henry Winkler, Sally Field, Harrison Ford, Val Avery','At the bus station,he accidentally meets Carol Bell,a woman unsure of her engagement to man towards whom she has confused feelings.Initially annoyed by Jack, Carol gradually warms to him as they set off on a trip through America'),(5,'Spider-Man','action','Sam Raimi','United States','Tobey Maguire, Willem Dafoe ,Kirsten Dunst, James Franco, Cliff Robertson, Rosemary Harris','Peter Parker (Toby Maguire) is a simple schoolboy, an ordinary nerd, suffering from unrequited love for his classmate, charming Mary Jane Watson (Kirsten Dunst). Relations with peers do not add up, classmates either do not notice him or mock him.');
INSERT INTO `users` VALUES (1,'Ivanov Petr Ivanovich','Lenina 10'),(2,'Stepanov Danil Alexeevich','Pushkina 20'),(3,'Demidov Karl Osipovich','Borisa Bogatkova 15'),(4,'Merkulov Vladislav Andreevich','Bazovaya 15'),(5,'Makarov Daril Andreevich','Lenina 86'),(6,'Osipov Nikita Vladislavovich','Svoboda 7'),(7,'Morozov Maxim Aduardovich','Kirova 8'),(8,'Dolmatov Dmitriy Petrovich','Smolina 26'),(9,'Mihailiv Petr Igorevich','Stalina 5'),(10,'Borisov Andrey Filipovich','Nevskiy Prospect 11');
INSERT INTO `given` VALUES (1,'Ivanov Petr Ivanovich','02.02.20','Harry Potter'),(2,'Stepanov Danil Alexeevich','06.05.2020','indiana jones');