WebAssignment

-- phpMyAdmin SQL Dump -- version 4.8.5 -- https://www.phpmyadmin.net/ -- -- Host: localhost:3306 -- Generation Time: Nov 28, 2019 at 01:15 PM -- 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: `gpoudelx_xyz` -- -- -------------------------------------------------------- -- -- Table structure for table `Music` -- CREATE TABLE `Music` ( `Music_ID` int(15) NOT NULL, `Title` varchar(55) NOT NULL, `Langugae` varchar(55) NOT NULL, `Time` int(15) NOT NULL, `Genre` varchar(55) NOT NULL, `Writer_ID` int(15) NOT NULL, `Singer_ID` int(15) NOT NULL ) ENGINE=MyISAM DEFAULT CHARSET=latin1; -- -- Dumping data for table `Music` -- INSERT INTO `Music` (`Music_ID`, `Title`, `Langugae`, `Time`, `Genre`, `Writer_ID`, `Singer_ID`) VALUES (12, 'Love Me Like You Do', 'English', 5, 'Pop', 555, 666), (15, 'Sorry', 'English', 4, 'Jazz', 987, 678); -- -------------------------------------------------------- -- -- Table structure for table `Writer` -- CREATE TABLE `Writer` ( `Writter_Id` int(25) NOT NULL, `First _Name` varchar(15) NOT NULL, `Middle_Name` varchar(15) NOT NULL, `Last_Name` varchar(15) NOT NULL, `Race` varchar(15) NOT NULL ) ENGINE=MyISAM DEFAULT CHARSET=latin1; -- -- Dumping data for table `Writer` -- INSERT INTO `Writer` (`Writter_Id`, `First _Name`, `Middle_Name`, `Last_Name`, `Race`) VALUES (468, 'Joey', 'Downy', 'Ruther', 'Asian'), (743, 'Alex', 'Der', 'Poudel', 'American'); -- -- Indexes for dumped tables -- -- -- Indexes for table `Music` -- ALTER TABLE `Music` ADD PRIMARY KEY (`Music_ID`); -- -- Indexes for table `Writer` -- ALTER TABLE `Writer` ADD PRIMARY KEY (`Writter_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 */;