WebAssignment

-- phpMyAdmin SQL Dump -- version 4.8.5 -- https://www.phpmyadmin.net/ -- -- Host: localhost:3306 -- Generation Time: Nov 28, 2019 at 04:09 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: `dgurungx_shoes` -- -- -------------------------------------------------------- -- -- Table structure for table `brand` -- CREATE TABLE `brand` ( `brand id` int(25) NOT NULL, `brand name` char(55) NOT NULL, `manufacturing country` char(55) NOT NULL, `establishment` int(15) NOT NULL, `type` char(25) NOT NULL, `owner id` int(55) NOT NULL, `manufacture id` int(55) NOT NULL ) ENGINE=InnoDB DEFAULT CHARSET=latin1; -- -- Dumping data for table `brand` -- INSERT INTO `brand` (`brand id`, `brand name`, `manufacturing country`, `establishment`, `type`, `owner id`, `manufacture id`) VALUES (812, 'nike', 'united states', 1920, 'sports', 10012, 20012), (813, 'addidas', 'united states', 1921, 'running', 10013, 20013); -- -------------------------------------------------------- -- -- Table structure for table `owner` -- CREATE TABLE `owner` ( `owner id` int(25) NOT NULL, `owner first name` char(55) NOT NULL, `owner last name` char(55) NOT NULL, `owner middle name` char(55) NOT NULL, `sex` char(25) NOT NULL ) ENGINE=InnoDB DEFAULT CHARSET=latin1; -- -- Dumping data for table `owner` -- INSERT INTO `owner` (`owner id`, `owner first name`, `owner last name`, `owner middle name`, `sex`) VALUES (10012, 'Phil', 'Knight', 'jones', 'male'), (10013, 'Adolf', 'Dassler', 'moise', 'male'); -- -- Indexes for dumped tables -- -- -- Indexes for table `brand` -- ALTER TABLE `brand` ADD PRIMARY KEY (`brand id`); -- -- Indexes for table `owner` -- ALTER TABLE `owner` ADD PRIMARY KEY (`owner id`); -- -- AUTO_INCREMENT for dumped tables -- -- -- AUTO_INCREMENT for table `brand` -- ALTER TABLE `brand` MODIFY `brand id` int(25) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=814; -- -- AUTO_INCREMENT for table `owner` -- ALTER TABLE `owner` MODIFY `owner id` int(25) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=10014; 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 */;