moviedb

-- phpMyAdmin SQL Dump
-- version 4.8.5
-- https://www.phpmyadmin.net/
--
-- Host: localhost
-- Generation Time: May 16, 2019 at 05:17 AM
-- Server version: 8.0.15
-- PHP Version: 7.2.7

SET SQL_MODE = "NO_AUTO_VALUE_ON_ZERO";
SET AUTOCOMMIT = 0;
START TRANSACTION;
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 */;

--
-- Database: `moviedb`
--

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

--
-- Table structure for table `actor`
--

CREATE TABLE `actor` (
  `id` int(11) NOT NULL,
  `fName` varchar(255) CHARACTER SET latin1 COLLATE latin1_swedish_ci DEFAULT NULL,
  `lName` varchar(255) CHARACTER SET latin1 COLLATE latin1_swedish_ci DEFAULT NULL,
  `dob` date DEFAULT NULL,
  `imdb_id` varchar(255) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `actor`
--

INSERT INTO `actor` (`id`, `fName`, `lName`, `dob`, `imdb_id`) VALUES
(1, 'Jonny Lee', 'Miller', '1972-11-15', 'nm0001538'),
(2, 'Fisher', 'Stevens', '1963-11-27', 'nm0001770'),
(3, 'Joe', 'Pesci', '1943-02-09', 'nm0000582'),
(4, 'Crispin', 'Glover', '1964-04-20', 'nm0000417'),
(5, 'Christopher', 'Lloyd', '1938-10-22', 'nm0000502');

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

--
-- Table structure for table `actor_starredin_movie`
--

CREATE TABLE `actor_starredin_movie` (
  `nr` int(11) NOT NULL,
  `movie.id` int(11) NOT NULL,
  `actor.id` int(11) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

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

--
-- Table structure for table `certification`
--

CREATE TABLE `certification` (
  `id` int(11) NOT NULL,
  `country` varchar(255) NOT NULL,
  `rating` varchar(255) NOT NULL,
  `reason` text NOT NULL,
  `age_limit` int(11) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

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

--
-- Table structure for table `country`
--

CREATE TABLE `country` (
  `id` int(11) NOT NULL,
  `name` varchar(255) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

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

--
-- Table structure for table `country_has_releasedate`
--

CREATE TABLE `country_has_releasedate` (
  `nr` int(11) NOT NULL,
  `country.id` int(11) NOT NULL,
  `releasedate.id` int(11) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

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

--
-- Table structure for table `director`
--

CREATE TABLE `director` (
  `id` int(11) NOT NULL,
  `fName` varchar(255) CHARACTER SET latin1 COLLATE latin1_swedish_ci NOT NULL,
  `lName` varchar(255) CHARACTER SET latin1 COLLATE latin1_swedish_ci NOT NULL,
  `dob` date NOT NULL,
  `imdb_id` varchar(255) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

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

--
-- Table structure for table `director_directed_movie`
--

CREATE TABLE `director_directed_movie` (
  `nr` int(11) NOT NULL,
  `director.id` int(11) NOT NULL,
  `movie.id` int(11) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

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

--
-- Table structure for table `genre`
--

CREATE TABLE `genre` (
  `id` int(11) NOT NULL,
  `name` varchar(255) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

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

--
-- Table structure for table `language`
--

CREATE TABLE `language` (
  `id` int(11) NOT NULL,
  `name` varchar(255) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1 ROW_FORMAT=COMPACT;

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

--
-- Table structure for table `language_spokenin_country`
--

CREATE TABLE `language_spokenin_country` (
  `nr` int(11) NOT NULL,
  `language.id` int(11) NOT NULL,
  `country.id` int(11) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

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

--
-- Table structure for table `media`
--

CREATE TABLE `media` (
  `id` int(11) NOT NULL,
  `title` varchar(255) NOT NULL,
  `host` varchar(255) NOT NULL,
  `link` varchar(2083) NOT NULL,
  `age_restriction` int(11) NOT NULL,
  `media_type` varchar(255) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

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

--
-- Table structure for table `media_promotes_movies`
--

CREATE TABLE `media_promotes_movies` (
  `nr` int(11) NOT NULL,
  `media.id` int(11) NOT NULL,
  `movie.id` int(11) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

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

--
-- Table structure for table `movie`
--

CREATE TABLE `movie` (
  `id` int(11) NOT NULL,
  `name` varchar(255) NOT NULL,
  `imdb_year` year(4) NOT NULL,
  `imdb_id` int(11) NOT NULL,
  `imdb_rating` float NOT NULL,
  `runtime` int(11) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

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

--
-- Table structure for table `movie_filmedin_country`
--

CREATE TABLE `movie_filmedin_country` (
  `nr` int(11) NOT NULL,
  `movie.id` int(11) NOT NULL,
  `country.id` int(11) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

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

--
-- Table structure for table `movie_has_certification`
--

CREATE TABLE `movie_has_certification` (
  `nr` int(11) NOT NULL,
  `movie.id` int(11) NOT NULL,
  `certification.id` int(11) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

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

--
-- Table structure for table `movie_has_genre`
--

CREATE TABLE `movie_has_genre` (
  `nr` int(11) NOT NULL,
  `movie.id` int(11) NOT NULL,
  `genre.id` int(11) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

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

--
-- Table structure for table `movie_has_rating`
--

CREATE TABLE `movie_has_rating` (
  `nr` int(11) NOT NULL,
  `movie.id` int(11) NOT NULL,
  `rating.id` int(11) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

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

--
-- Table structure for table `otherstaff`
--

CREATE TABLE `otherstaff` (
  `id` int(11) NOT NULL,
  `fName` varchar(255) CHARACTER SET latin1 COLLATE latin1_swedish_ci NOT NULL,
  `lName` varchar(255) CHARACTER SET latin1 COLLATE latin1_swedish_ci NOT NULL,
  `dob` date NOT NULL,
  `imdb_id` varchar(255) NOT NULL,
  `role` varchar(255) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1 ROW_FORMAT=COMPACT;

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

--
-- Table structure for table `otherstaff_workedin_movie`
--

CREATE TABLE `otherstaff_workedin_movie` (
  `nr` int(11) NOT NULL,
  `otherstaff.id` int(11) NOT NULL,
  `movie.id` int(11) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

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

--
-- Table structure for table `prodcomp`
--

CREATE TABLE `prodcomp` (
  `id` int(11) NOT NULL,
  `name` int(11) NOT NULL,
  `imdb_id` int(11) NOT NULL,
  `street_address` int(11) NOT NULL,
  `city` int(11) NOT NULL,
  `postal_code` int(11) NOT NULL,
  `country` int(11) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1 ROW_FORMAT=COMPACT;

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

--
-- Table structure for table `prodcomp_produced_movie`
--

CREATE TABLE `prodcomp_produced_movie` (
  `nr` int(11) NOT NULL,
  `prodcomp.id` int(11) NOT NULL,
  `movie.id` int(11) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

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

--
-- Table structure for table `rating`
--

CREATE TABLE `rating` (
  `id` int(11) NOT NULL,
  `source` varchar(255) NOT NULL,
  `grade` float NOT NULL,
  `scale` float NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

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

--
-- Table structure for table `releasedate`
--

CREATE TABLE `releasedate` (
  `id` int(11) NOT NULL,
  `theater` date NOT NULL,
  `dvd` date NOT NULL,
  `bluray` date NOT NULL,
  `streaming` date NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1 ROW_FORMAT=COMPACT;

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

--
-- Table structure for table `showtime`
--

CREATE TABLE `showtime` (
  `id` int(11) NOT NULL,
  `date` date NOT NULL,
  `time_slot` time NOT NULL,
  `3D` tinyint(1) NOT NULL,
  `IMAX` tinyint(1) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1 ROW_FORMAT=COMPACT;

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

--
-- Table structure for table `theater`
--

CREATE TABLE `theater` (
  `id` int(11) NOT NULL,
  `name` varchar(255) NOT NULL,
  `address` varchar(255) NOT NULL,
  `city` varchar(255) NOT NULL,
  `state` varchar(255) NOT NULL,
  `postal_code` int(11) NOT NULL,
  `country` varchar(255) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

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

--
-- Table structure for table `theater_has_showtime`
--

CREATE TABLE `theater_has_showtime` (
  `nr` int(11) NOT NULL,
  `theater.id` int(11) NOT NULL,
  `showtime.id` int(11) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

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

--
-- Table structure for table `writer`
--

CREATE TABLE `writer` (
  `id` int(11) NOT NULL,
  `fName` varchar(255) CHARACTER SET latin1 COLLATE latin1_swedish_ci NOT NULL,
  `lName` varchar(255) CHARACTER SET latin1 COLLATE latin1_swedish_ci NOT NULL,
  `dob` date NOT NULL,
  `imdb_id` varchar(255) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

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

--
-- Table structure for table `writer_wrote_movie`
--

CREATE TABLE `writer_wrote_movie` (
  `nr` int(11) NOT NULL,
  `writer.id` int(11) NOT NULL,
  `movie.id` int(11) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Indexes for dumped tables
--

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

--
-- Indexes for table `actor_starredin_movie`
--
ALTER TABLE `actor_starredin_movie`
  ADD PRIMARY KEY (`nr`);

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

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

--
-- Indexes for table `country_has_releasedate`
--
ALTER TABLE `country_has_releasedate`
  ADD PRIMARY KEY (`nr`);

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

--
-- Indexes for table `director_directed_movie`
--
ALTER TABLE `director_directed_movie`
  ADD PRIMARY KEY (`nr`);

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

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

--
-- Indexes for table `language_spokenin_country`
--
ALTER TABLE `language_spokenin_country`
  ADD PRIMARY KEY (`nr`);

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

--
-- Indexes for table `media_promotes_movies`
--
ALTER TABLE `media_promotes_movies`
  ADD PRIMARY KEY (`nr`);

--
-- Indexes for table `movie`
--
ALTER TABLE `movie`
  ADD PRIMARY KEY (`id`) USING BTREE;

--
-- Indexes for table `movie_filmedin_country`
--
ALTER TABLE `movie_filmedin_country`
  ADD PRIMARY KEY (`nr`);

--
-- Indexes for table `movie_has_certification`
--
ALTER TABLE `movie_has_certification`
  ADD PRIMARY KEY (`nr`);

--
-- Indexes for table `movie_has_genre`
--
ALTER TABLE `movie_has_genre`
  ADD PRIMARY KEY (`nr`);

--
-- Indexes for table `movie_has_rating`
--
ALTER TABLE `movie_has_rating`
  ADD PRIMARY KEY (`nr`);

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

--
-- Indexes for table `otherstaff_workedin_movie`
--
ALTER TABLE `otherstaff_workedin_movie`
  ADD PRIMARY KEY (`nr`);

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

--
-- Indexes for table `prodcomp_produced_movie`
--
ALTER TABLE `prodcomp_produced_movie`
  ADD PRIMARY KEY (`nr`);

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

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

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

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

--
-- Indexes for table `theater_has_showtime`
--
ALTER TABLE `theater_has_showtime`
  ADD PRIMARY KEY (`nr`);

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

--
-- Indexes for table `writer_wrote_movie`
--
ALTER TABLE `writer_wrote_movie`
  ADD PRIMARY KEY (`nr`);

--
-- AUTO_INCREMENT for dumped tables
--

--
-- AUTO_INCREMENT for table `actor`
--
ALTER TABLE `actor`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=6;

--
-- AUTO_INCREMENT for table `actor_starredin_movie`
--
ALTER TABLE `actor_starredin_movie`
  MODIFY `nr` int(11) NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `certification`
--
ALTER TABLE `certification`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `country`
--
ALTER TABLE `country`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `country_has_releasedate`
--
ALTER TABLE `country_has_releasedate`
  MODIFY `nr` int(11) NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `director`
--
ALTER TABLE `director`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `director_directed_movie`
--
ALTER TABLE `director_directed_movie`
  MODIFY `nr` int(11) NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `genre`
--
ALTER TABLE `genre`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `language`
--
ALTER TABLE `language`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `language_spokenin_country`
--
ALTER TABLE `language_spokenin_country`
  MODIFY `nr` int(11) NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `media`
--
ALTER TABLE `media`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `media_promotes_movies`
--
ALTER TABLE `media_promotes_movies`
  MODIFY `nr` int(11) NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `movie_filmedin_country`
--
ALTER TABLE `movie_filmedin_country`
  MODIFY `nr` int(11) NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `movie_has_certification`
--
ALTER TABLE `movie_has_certification`
  MODIFY `nr` int(11) NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `movie_has_genre`
--
ALTER TABLE `movie_has_genre`
  MODIFY `nr` int(11) NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `movie_has_rating`
--
ALTER TABLE `movie_has_rating`
  MODIFY `nr` int(11) NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `otherstaff`
--
ALTER TABLE `otherstaff`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `otherstaff_workedin_movie`
--
ALTER TABLE `otherstaff_workedin_movie`
  MODIFY `nr` int(11) NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `prodcomp`
--
ALTER TABLE `prodcomp`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `prodcomp_produced_movie`
--
ALTER TABLE `prodcomp_produced_movie`
  MODIFY `nr` int(11) NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `rating`
--
ALTER TABLE `rating`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `releasedate`
--
ALTER TABLE `releasedate`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `showtime`
--
ALTER TABLE `showtime`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `theater`
--
ALTER TABLE `theater`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `theater_has_showtime`
--
ALTER TABLE `theater_has_showtime`
  MODIFY `nr` int(11) NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `writer`
--
ALTER TABLE `writer`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `writer_wrote_movie`
--
ALTER TABLE `writer_wrote_movie`
  MODIFY `nr` int(11) NOT NULL AUTO_INCREMENT;
COMMIT;

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