-- phpMyAdmin SQL Dump -- version 4.9.7 -- https://www.phpmyadmin.net/ -- -- Host: localhost:3307 -- Generation Time: Mar 03, 2021 at 12:24 PM -- Server version: 5.7.33-log -- PHP Version: 7.4.15 SET SQL_MODE = "NO_AUTO_VALUE_ON_ZERO"; SET AUTOCOMMIT = 0; START TRANSACTION; SET time_zone = "+00:00"; SET foreign_key_checks = 0; /*!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: `media_` -- -- -------------------------------------------------------- -- -- Table structure for table `actor` -- DROP TABLE IF EXISTS `actor`; CREATE TABLE `actor` ( `ID` int(10) UNSIGNED NOT NULL, `Actor` varchar(45) NOT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8; -- -- RELATIONSHIPS FOR TABLE `actor`: -- -- -------------------------------------------------------- -- -- Table structure for table `director` -- DROP TABLE IF EXISTS `director`; CREATE TABLE `director` ( `ID` int(10) UNSIGNED NOT NULL, `Director` varchar(45) NOT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8; -- -- RELATIONSHIPS FOR TABLE `director`: -- -- -------------------------------------------------------- -- -- Table structure for table `genre` -- DROP TABLE IF EXISTS `genre`; CREATE TABLE `genre` ( `ID` int(10) UNSIGNED NOT NULL, `Genre` varchar(45) NOT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8; -- -- RELATIONSHIPS FOR TABLE `genre`: -- -- -------------------------------------------------------- -- -- Table structure for table `movie` -- DROP TABLE IF EXISTS `movie`; CREATE TABLE `movie` ( `ID` int(10) UNSIGNED NOT NULL, `title` varchar(256) NOT NULL, `runtime` varchar(45) NOT NULL, `plot` varchar(1024) NOT NULL, `type` varchar(16) NOT NULL, `imdbID` varchar(16) NOT NULL, `year` char(16) NOT NULL, `country` varchar(16) NOT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='Movie data rom IMDB'; -- -- RELATIONSHIPS FOR TABLE `movie`: -- -- -------------------------------------------------------- -- -- Table structure for table `movie_actor` -- DROP TABLE IF EXISTS `movie_actor`; CREATE TABLE `movie_actor` ( `ID` int(10) UNSIGNED NOT NULL, `movie_ID` int(10) UNSIGNED NOT NULL, `actor_ID` int(10) UNSIGNED NOT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8; -- -- RELATIONSHIPS FOR TABLE `movie_actor`: -- -- -------------------------------------------------------- -- -- Table structure for table `movie_director` -- DROP TABLE IF EXISTS `movie_director`; CREATE TABLE `movie_director` ( `ID` int(10) UNSIGNED NOT NULL, `movie_ID` int(10) UNSIGNED NOT NULL, `director_ID` int(10) UNSIGNED NOT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8; -- -- RELATIONSHIPS FOR TABLE `movie_director`: -- -- -------------------------------------------------------- -- -- Table structure for table `movie_genre` -- DROP TABLE IF EXISTS `movie_genre`; CREATE TABLE `movie_genre` ( `ID` int(10) UNSIGNED NOT NULL, `movie_ID` int(10) UNSIGNED NOT NULL, `genre_ID` int(10) UNSIGNED NOT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8; -- -- RELATIONSHIPS FOR TABLE `movie_genre`: -- -- -------------------------------------------------------- -- -- Table structure for table `movie_writer` -- DROP TABLE IF EXISTS `movie_writer`; CREATE TABLE `movie_writer` ( `ID` int(10) UNSIGNED NOT NULL, `movie_ID` int(10) UNSIGNED NOT NULL, `writer_ID` int(10) UNSIGNED NOT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8; -- -- RELATIONSHIPS FOR TABLE `movie_writer`: -- -- -------------------------------------------------------- -- -- Table structure for table `working` -- DROP TABLE IF EXISTS `working`; CREATE TABLE `working` ( `ID` int(10) UNSIGNED NOT NULL, `Value` varchar(256) NOT NULL, `Type` char(1) NOT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='Process sets of values prior to creatig unique value set in final table eg Actors'; -- -- RELATIONSHIPS FOR TABLE `working`: -- -- -------------------------------------------------------- -- -- Table structure for table `writer` -- DROP TABLE IF EXISTS `writer`; CREATE TABLE `writer` ( `ID` int(10) UNSIGNED NOT NULL, `Writer` varchar(128) NOT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8; -- -- RELATIONSHIPS FOR TABLE `writer`: -- -- -- Indexes for dumped tables -- -- -- Indexes for table `actor` -- ALTER TABLE `actor` ADD PRIMARY KEY (`ID`); -- -- Indexes for table `director` -- ALTER TABLE `director` ADD PRIMARY KEY (`ID`); -- -- Indexes for table `genre` -- ALTER TABLE `genre` ADD PRIMARY KEY (`ID`); -- -- Indexes for table `movie` -- ALTER TABLE `movie` ADD PRIMARY KEY (`ID`); -- -- Indexes for table `movie_actor` -- ALTER TABLE `movie_actor` ADD PRIMARY KEY (`ID`); -- -- Indexes for table `movie_director` -- ALTER TABLE `movie_director` ADD PRIMARY KEY (`ID`); -- -- Indexes for table `movie_genre` -- ALTER TABLE `movie_genre` ADD PRIMARY KEY (`ID`); -- -- Indexes for table `movie_writer` -- ALTER TABLE `movie_writer` ADD PRIMARY KEY (`ID`); -- -- Indexes for table `working` -- ALTER TABLE `working` ADD PRIMARY KEY (`ID`); -- -- Indexes for table `writer` -- ALTER TABLE `writer` ADD PRIMARY KEY (`ID`); -- -- CONSTRAINTS -- ALTER TABLE movie_actor ADD CONSTRAINT FK_moviea FOREIGN KEY (movie_ID) REFERENCES movie(ID); ALTER TABLE movie_actor ADD CONSTRAINT FK_actor FOREIGN KEY (actor_ID) REFERENCES actor(ID); ALTER TABLE movie_director ADD CONSTRAINT FK_movied FOREIGN KEY (movie_ID) REFERENCES movie(ID); ALTER TABLE movie_director ADD CONSTRAINT FK_director FOREIGN KEY (director_ID) REFERENCES director(ID); ALTER TABLE movie_genre ADD CONSTRAINT FK_movieg FOREIGN KEY (movie_ID) REFERENCES movie(ID); ALTER TABLE movie_genre ADD CONSTRAINT FK_genre FOREIGN KEY (genre_ID) REFERENCES genre(ID); ALTER TABLE movie_writer ADD CONSTRAINT FK_moview FOREIGN KEY (movie_ID) REFERENCES movie(ID); ALTER TABLE movie_writer ADD CONSTRAINT FK_writer FOREIGN KEY (writer_ID) REFERENCES writer(ID); -- -- AUTO_INCREMENT for dumped tables -- -- -- AUTO_INCREMENT for table `actor` -- ALTER TABLE `actor` MODIFY `ID` int(10) UNSIGNED NOT NULL AUTO_INCREMENT; -- -- AUTO_INCREMENT for table `director` -- ALTER TABLE `director` MODIFY `ID` int(10) UNSIGNED NOT NULL AUTO_INCREMENT; -- -- AUTO_INCREMENT for table `genre` -- ALTER TABLE `genre` MODIFY `ID` int(10) UNSIGNED NOT NULL AUTO_INCREMENT; -- -- AUTO_INCREMENT for table `movie` -- ALTER TABLE `movie` MODIFY `ID` int(10) UNSIGNED NOT NULL AUTO_INCREMENT; -- -- AUTO_INCREMENT for table `movie_actor` -- ALTER TABLE `movie_actor` MODIFY `ID` int(10) UNSIGNED NOT NULL AUTO_INCREMENT; -- -- AUTO_INCREMENT for table `movie_director` -- ALTER TABLE `movie_director` MODIFY `ID` int(10) UNSIGNED NOT NULL AUTO_INCREMENT; -- -- AUTO_INCREMENT for table `movie_genre` -- ALTER TABLE `movie_genre` MODIFY `ID` int(10) UNSIGNED NOT NULL AUTO_INCREMENT; -- -- AUTO_INCREMENT for table `movie_writer` -- ALTER TABLE `movie_writer` MODIFY `ID` int(10) UNSIGNED NOT NULL AUTO_INCREMENT; -- -- AUTO_INCREMENT for table `working` -- ALTER TABLE `working` MODIFY `ID` int(10) UNSIGNED NOT NULL AUTO_INCREMENT; -- -- AUTO_INCREMENT for table `writer` -- ALTER TABLE `writer` MODIFY `ID` int(10) UNSIGNED 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 */;