WebAssignment

-- phpMyAdmin SQL Dump -- version 4.8.5 -- https://www.phpmyadmin.net/ -- -- Host: localhost:3306 -- Generation Time: Nov 28, 2019 at 04:10 PM -- Server version: 10.0.31-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: `sdangolx_dangol` -- -- -------------------------------------------------------- -- -- Table structure for table `DVDCollection` -- CREATE TABLE `DVDCollection` ( `DVD_ID` int(20) NOT NULL, `Title` varchar(70) NOT NULL, `Name` varchar(70) NOT NULL, `Size` int(20) NOT NULL, `Format` varchar(70) NOT NULL, `Seller_ID` int(20) NOT NULL, `Consumer_ID` int(20) NOT NULL ) ENGINE=InnoDB DEFAULT CHARSET=latin1; -- -- Dumping data for table `DVDCollection` -- INSERT INTO `DVDCollection` (`DVD_ID`, `Title`, `Name`, `Size`, `Format`, `Seller_ID`, `Consumer_ID`) VALUES (12, 'Movie', 'Takers', 345, 'Blu-ray', 123, 456), (333, 'Coldplay', 'Scientist', 3, 'DVD', 222, 111); -- -------------------------------------------------------- -- -- Table structure for table `Seller_ID` -- CREATE TABLE `Seller_ID` ( `Seller_ID` int(30) NOT NULL, `First_Name` varchar(50) NOT NULL, `Last_Name` varchar(50) NOT NULL, `Address` varchar(50) NOT NULL, `Rating` varchar(50) NOT NULL ) ENGINE=InnoDB DEFAULT CHARSET=latin1; -- -- Dumping data for table `Seller_ID` -- INSERT INTO `Seller_ID` (`Seller_ID`, `First_Name`, `Last_Name`, `Address`, `Rating`) VALUES (777, 'Isaac', 'Johnson', 'Plano, TX', 'Good'), (789, 'Seth', 'Wright', 'Birmingham, AL', 'Excellent'); -- -- Indexes for dumped tables -- -- -- Indexes for table `DVDCollection` -- ALTER TABLE `DVDCollection` ADD PRIMARY KEY (`DVD_ID`); -- -- Indexes for table `Seller_ID` -- ALTER TABLE `Seller_ID` ADD PRIMARY KEY (`Seller_ID`); 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 */;