WebAssignment

-- phpMyAdmin SQL Dump -- version 4.8.5 -- https://www.phpmyadmin.net/ -- -- Host: localhost:3306 -- Generation Time: Nov 24, 2019 at 11:04 AM -- Server version: 10.0.38-MariaDB-cll-lve -- 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: `sgautam7_movie` -- -- -------------------------------------------------------- -- -- Table structure for table `Director` -- CREATE TABLE `Director` ( `director_id` int(15) NOT NULL, `first_name` char(40) NOT NULL, `last_name` char(40) NOT NULL, `middle_name` char(40) NOT NULL, `gender` char(15) NOT NULL ) ENGINE=InnoDB DEFAULT CHARSET=latin1; -- -- Dumping data for table `Director` -- INSERT INTO `Director` (`director_id`, `first_name`, `last_name`, `middle_name`, `gender`) VALUES (12345, 'Holland', 'James', 'ray', 'Male'), (12346, 'Ray', 'Hudson', 'alex', 'Male'); -- -------------------------------------------------------- -- -- Table structure for table `movie` -- CREATE TABLE `movie` ( `movie_id` int(15) NOT NULL, `title` char(40) NOT NULL, `language` char(40) NOT NULL, `year` int(10) NOT NULL, `genre` char(15) NOT NULL, `director_id` int(40) NOT NULL, `producer_id` int(40) NOT NULL ) ENGINE=InnoDB DEFAULT CHARSET=latin1; -- -- Dumping data for table `movie` -- INSERT INTO `movie` (`movie_id`, `title`, `language`, `year`, `genre`, `director_id`, `producer_id`) VALUES (20, 'Race', 'English', 2010, 'Action', 12345, 3500), (30, 'Zombie vs Man', 'Spanish', 2009, 'Horror', 12346, 3501); -- -- Indexes for dumped tables -- -- -- Indexes for table `Director` -- ALTER TABLE `Director` ADD PRIMARY KEY (`director_id`); -- -- Indexes for table `movie` -- ALTER TABLE `movie` ADD PRIMARY KEY (`movie_id`); -- -- AUTO_INCREMENT for dumped tables -- -- -- AUTO_INCREMENT for table `Director` -- ALTER TABLE `Director` MODIFY `director_id` int(15) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=12347; -- -- AUTO_INCREMENT for table `movie` -- ALTER TABLE `movie` MODIFY `movie_id` int(15) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=31; 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 */;