-- phpMyAdmin SQL Dump
-- version 4.5.1
-- http://www.phpmyadmin.net
--
-- Host: 127.0.0.1
-- Czas generowania: 11 Paź 2023, 09:38
-- Wersja serwera: 10.1.8-MariaDB
-- Wersja PHP: 5.5.30

SET SQL_MODE = "NO_AUTO_VALUE_ON_ZERO";
SET time_zone = "+00:00";


/*!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 utf8mb4 */;

--
-- Baza danych: `zad3`
--

-- --------------------------------------------------------

--
-- Struktura tabeli dla tabeli `movies`
--

CREATE TABLE `movies` (
  `id` int(11) NOT NULL,
  `title` text COLLATE utf8_polish_ci NOT NULL,
  `year` int(11) NOT NULL,
  `type` text COLLATE utf8_polish_ci NOT NULL,
  `director` text COLLATE utf8_polish_ci NOT NULL,
  `cast` text COLLATE utf8_polish_ci NOT NULL,
  `rating` float NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_polish_ci;

--
-- Zrzut danych tabeli `movies`
--

INSERT INTO `movies` (`id`, `title`, `year`, `type`, `director`, `cast`, `rating`) VALUES
(1, 'Blade runner', 1982, 'SF', 'Ridley Scott', 'Harrison Ford, Rutger Hauer, Daryl Hannah', 8.3),
(2, 'Commando', 1985, 'action', 'Mark Lester', 'Arnold Schwarzenegger, Rae Dawn Chong, Dan Hedaya', 7.3),
(3, 'Il buono, il brutto, il cattivo', 1966, 'action', 'Sergio Leone', 'Clint Eastwood, Lee Van Cleef, Eli Wallach', 8.7),
(4, 'Top Gun', 1986, 'action', 'Tony Scott', 'Tom Cruise, Kelly McGillis, Val Kilmer', 7.4),
(5, 'Four Weddings and a Funeral', 1994, 'comedy', 'Mike Newell', 'Hugh Grant, Andie MacDowell, Kristin Scott Thomas', 8.5),
(6, 'Alien', 1979, 'SF', 'Ridley Scott', 'Sigourney Weaver, Tom Skerritt, Ian Holm', 8),
(7, 'Edge of Tomorrow', 2014, 'SF', 'Doug Liman', 'Tom Cruise, Emily Blunt, Brendan Gleeson', 7.6),
(8, 'Bean', 1997, 'comedy', 'Mel Smith', 'Rowan Atkinson, Peter MacNicol, Pamela Reed', 7),
(9, 'Any Given Sunday', 1999, 'drama', 'Oliver Stone', 'Dennis Quaid, Al Pacino, Jamie Foxx', 7.4),
(10, 'Saving Private Ryan', 1998, 'drama', 'Steven Spielberg', 'Tom Hanks, Edward Burns, Vin Diesel', 7.5),
(11, 'Days of Thunder', 1990, 'action', 'Tony Scott', 'Tom Cruise, Robert Duvall, Nicole Kidman', 6.9),
(12, 'The Fast and the Furious', 2001, 'action', 'Rob Cohen', 'Vin Diesel, Paul Walker, Michelle Rodriguez', 6.9),
(13, 'Enemy of the State', 1998, 'action', 'Tony Scott', 'Will Smith, Gene Hackman, Jon Voight', 7),
(14, 'Days of Thunder', 1990, 'action', 'Tony Scott', 'Tom Cruise, Robert Duvall, Nicole Kidman', 6.9),
(15, 'Ocean''s Eleven', 2001, 'comedy', 'Steven Soderbergh', 'George Clooney, Brad Pitt, Matt Damon', 7.5),
(16, 'Unforgiven', 1992, 'drama', 'Clint Eastwood', 'Clint Eastwood, Gene Hackman, Morgan Freeman', 8.9),
(17, 'The Straight Story', 1999, 'drama', 'David Lynch', 'Richard Farnsworth, Sissy Spacek, Everett McGill', 8),
(18, 'Gran Torino', 2008, 'drama', 'Clint Eastwood', 'Clint Eastwood, Bee Vang, Christopher Carley', 7.7),
(19, 'Dirty Harry', 1971, 'action', 'Don Siegel', 'Clint Eastwood, Reni Santoni, Harry Guardino', 7.6),
(20, 'Million Dollar Baby', 2004, 'drama', 'Clint Eastwood', 'Hilary Swank, Clint Eastwood, Morgan Freeman', 7.7),
(21, 'Avatar', 2009, 'SF', 'James Cameron', 'Sam Worthington, Zoe Saldana, Sigourney Weaver', 7),
(22, 'The Terminator', 1984, 'SF', 'James Cameron', 'Arnold Schwarzenegger, Michael Biehn, Linda Hamilton', 7.8),
(23, 'Wind', 1992, 'drama', 'Carroll Ballard', 'Matthew Modine, Jennifer Grey, Stellan Skarsgard', 7.5),
(24, 'Iron Man', 2008, 'SF', 'Jon Favreau', 'Robert Downey Jr., Terrence Howard, Gwyneth Paltrow', 7.6),
(25, 'Frost / Nixon', 2008, 'drama', 'Ron Howard', 'Michael Sheen, Frank Langella, Sam Rockwell', 7.9),
(26, 'Moneyball', 2011, 'drama', 'Bennett Miller', 'Brad Pitt, Jonah Hill, Philip Seymour Hoffman', 8.3),
(27, 'The Big Short', 2015, 'drama', 'Adam McKay', 'Christian Bale, Steve Carell, Brad Pitt', 7.9),
(28, 'Wall Street', 1987, 'drama', 'Oliver Stone', 'Michael Douglas, Charlie Sheen, Daryl Hannah', 7.9),
(29, 'Mission: Impossible', 1996, 'action', 'Brian De Palma', 'Tom Cruise, Jon Voight, Ving Rhames', 7.7);

--
-- Indeksy dla zrzutów tabel
--

--
-- Indexes for table `movies`
--
ALTER TABLE `movies`
  ADD PRIMARY KEY (`id`);

--
-- AUTO_INCREMENT for dumped tables
--

--
-- AUTO_INCREMENT dla tabeli `movies`
--
ALTER TABLE `movies`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=30;
/*!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 */;
