-- -------------------------------------------------------- -- Host: 127.0.0.1 -- Server version: 10.7.3-MariaDB - mariadb.org binary distribution -- Server OS: Win64 -- HeidiSQL Version: 11.3.0.6295 -- -------------------------------------------------------- /*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */; /*!40101 SET NAMES utf8 */; /*!50503 SET NAMES utf8mb4 */; /*!40014 SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0 */; /*!40101 SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='NO_AUTO_VALUE_ON_ZERO' */; /*!40111 SET @OLD_SQL_NOTES=@@SQL_NOTES, SQL_NOTES=0 */; -- Dumping database structure for bar CREATE DATABASE IF NOT EXISTS `bar` /*!40100 DEFAULT CHARACTER SET latin1 */; USE `bar`; -- Dumping structure for table bar.bars CREATE TABLE IF NOT EXISTS `bars` ( `name` varchar(40) DEFAULT NULL, `license` varchar(10) NOT NULL, `city` varchar(20) NOT NULL, `phone` varchar(20) DEFAULT NULL, `addr` varchar(30) DEFAULT NULL ) ENGINE=InnoDB DEFAULT CHARSET=latin1; -- Dumping data for table bar.bars: ~18 rows (approximately) /*!40000 ALTER TABLE `bars` DISABLE KEYS */; INSERT INTO `bars` (`name`, `license`, `city`, `phone`, `addr`) VALUES ('Caravan', 'IL12345', 'Chicago', '', ''), ('The Shark and Rose', 'MA12345', 'Boston', '', ''), ('Blue Angel', 'CA45678', 'San Francisco', '', ''), ('Britannia Arms', 'MA12346', 'Boston', '345-567-1289', ' '), ('A.P. Stump\'s', 'MA12347', 'Boston', '', ''), ('The B-Hive', 'MA12348', 'Boston', '345-567-1280', ' '), ('The Blank Club', 'MA12349', 'Boston', '345-567-1281', ' '), ('Blue Tattoo', 'CA45678', 'San Francisco', '415-567-1289', '1500 Market St.'), ('Cabana', 'CA45678', 'San Francisco', '', '1200 California Ave.'), ('The Backbeat', 'CA45678', 'San Francisco', '415-567-1289', ' '), ('Club 175', 'CA45678', 'San Francisco', '415-567-1289', ' '), ('Coconut Willie\'s Cocktail Lounge', 'CA45678', 'San Francisco', '415-567-1289', ' '), ('Eulipia', 'IL12346', 'Chicago', '123-456-7890', '1060 West Addison'), ('Gecko Grill', 'IL12348', 'Chicago', '', '1060 West Addison'), ('Giza Hookah Lounge', 'IL12349', 'Chicago', '345-678-9012', ' '), ('Hedley Club', 'NY12345', 'New York', '', '161st St and River Ave'), ('Il Fornaio', 'NY12346', 'New York', '', '161st St and River Ave'), ('Seven Bamboo', 'NY12347', 'New York', ' ', '161st St and River Ave'); /*!40000 ALTER TABLE `bars` ENABLE KEYS */; -- Dumping structure for table bar.beers CREATE TABLE IF NOT EXISTS `beers` ( `name` varchar(30) DEFAULT NULL, `manf` varchar(40) NOT NULL ) ENGINE=InnoDB DEFAULT CHARSET=latin1; -- Dumping data for table bar.beers: ~20 rows (approximately) /*!40000 ALTER TABLE `beers` DISABLE KEYS */; INSERT INTO `beers` (`name`, `manf`) VALUES ('Budweiser', 'Anheuser-Busch'), ('Michelob ULTRA', 'Anheuser-Busch'), ('Michelob Golden Draft Light', 'Anheuser-Busch'), ('Michelob Golden Draft', 'Anheuser-Busch'), ('Michelob Amber Bock', 'Anheuser-Busch'), ('Original Premium Lager Dog', 'Plank Road Brewery'), ('ICEHOUSE', 'Plank Road Brewery'), ('Southpaw Light', 'Plank Road Brewery'), ('Stolichnaya Citrona', 'Miller Brewing Company'), ('Sauza Diablo', 'Miller Brewing Company'), ('Blue Moon', 'Coors Brewing Company'), ('Zima', 'Coors Brewing Company'), ('Zima Citrus', 'Coors Brewing Company'), ('Extra Gold', 'Coors Brewing Company'), ('Killian\'s', 'Coors Brewing Company'), ('Creamy Dark', 'Jacob Leinenkugel Brewing Company'), ('Hefeweizen Doppelbock', 'Jacob Leinenkugel Brewing Company'), ('Original Premium Lager', 'Jacob Leinenkugel Brewing Company'), ('Hefeweizen', 'Jacob Leinenkugel Brewing Company'), ('Original Premium', ' Jacob Leinenkugel Brewing Company'); /*!40000 ALTER TABLE `beers` ENABLE KEYS */; -- Dumping structure for table bar.drinkers CREATE TABLE IF NOT EXISTS `drinkers` ( `name` varchar(10) DEFAULT NULL, `city` varchar(20) NOT NULL, `phone` varchar(20) DEFAULT NULL, `addr` varchar(30) DEFAULT NULL ) ENGINE=InnoDB DEFAULT CHARSET=latin1; -- Dumping data for table bar.drinkers: ~10 rows (approximately) /*!40000 ALTER TABLE `drinkers` DISABLE KEYS */; INSERT INTO `drinkers` (`name`, `city`, `phone`, `addr`) VALUES ('John', 'Chicago', NULL, '1060 West Addison'), ('Tom', 'Chicago', NULL, '1060 West Addison'), ('Rebecca', 'Chicago', '', '1060 West Addison'), ('Jesse', 'San Francisco', '415-234-6789', NULL), ('Bob', 'San Francisco', '415-234-6789', NULL), ('Erik', 'San Francisco', '415-234-6789', NULL), ('Mike', 'Boston', NULL, NULL), ('Justin', 'Boston', NULL, NULL), ('Herb', 'Boston', NULL, NULL), ('Vince', 'New York ', '234-456-7890', '161st St and River Ave '); /*!40000 ALTER TABLE `drinkers` ENABLE KEYS */; -- Dumping structure for table bar.frequents CREATE TABLE IF NOT EXISTS `frequents` ( `drinker` varchar(10) DEFAULT NULL, `bar` varchar(40) NOT NULL ) ENGINE=InnoDB DEFAULT CHARSET=latin1; -- Dumping data for table bar.frequents: ~14 rows (approximately) /*!40000 ALTER TABLE `frequents` DISABLE KEYS */; INSERT INTO `frequents` (`drinker`, `bar`) VALUES ('Bob', 'Coconut Willie\'s Cocktail Lounge'), ('Erik', 'Blue Angel'), ('Herb', 'Seven Bamboo'), ('Jesse', 'Blue Angel'), ('John', 'Caravan'), ('Justin', 'Gecko Grill'), ('Mike', 'A.P. Stump\'s'), ('Mike', 'The Shark and Rose'), ('Rebecca', 'Coconut Willie\'s Cocktail Lounge'), ('Rebecca', 'Gecko Grill'), ('Tom', 'Blue Angel'), ('Tom', 'Caravan'), ('Vince', 'Blue Angel'), ('Vince', 'Seven Bamboo '); /*!40000 ALTER TABLE `frequents` ENABLE KEYS */; -- Dumping structure for table bar.likes CREATE TABLE IF NOT EXISTS `likes` ( `drinker` varchar(10) DEFAULT NULL, `beer` varchar(30) NOT NULL ) ENGINE=InnoDB DEFAULT CHARSET=latin1; -- Dumping data for table bar.likes: ~15 rows (approximately) /*!40000 ALTER TABLE `likes` DISABLE KEYS */; INSERT INTO `likes` (`drinker`, `beer`) VALUES ('Jesse', 'Original Premium Lager Dog'), ('John', 'Blue Moon'), ('John', 'Budweiser'), ('John', 'Creamy Dark'), ('John', 'Killian\'s'), ('John', 'Michelob Golden Draft'), ('John', 'Original Premium'), ('John', 'Stolichnaya Citrona'), ('Mike', 'Blue Moon'), ('Mike', 'Budweiser'), ('Mike', 'Creamy Dark'), ('Mike', 'Hefeweizen'), ('Mike', 'Michelob Golden Draft Light'), ('Mike', 'Original Premium Lager'), ('Mike', 'Original Premium Lager Dog '); /*!40000 ALTER TABLE `likes` ENABLE KEYS */; -- Dumping structure for table bar.sells CREATE TABLE IF NOT EXISTS `sells` ( `bar` varchar(40) NOT NULL, `beer` varchar(30) NOT NULL, `price` decimal(20,6) NOT NULL ) ENGINE=InnoDB DEFAULT CHARSET=latin1; -- Dumping data for table bar.sells: ~20 rows (approximately) /*!40000 ALTER TABLE `sells` DISABLE KEYS */; INSERT INTO `sells` (`bar`, `beer`, `price`) VALUES ('The Shark and Rose', 'Budweiser', 4.500000), ('The Shark and Rose', 'Original Premium Lager Dog', 5.500000), ('Blue Angel', 'Hefeweizen Doppelbock', 5.500000), ('Blue Angel', 'Original Premium Lager Dog', 6.250000), ('Caravan', 'Budweiser', 5.500000), ('Caravan', 'Original Premium Lager Dog', 3.500000), ('Britannia Arms', 'Budweiser', 6.500000), ('The Blank Club', 'Budweiser', 5.500000), ('Cabana', 'Budweiser', 5.000000), ('Club 175', 'Budweiser', 4.500000), ('Coconut Willie\'s Cocktail Lounge', 'Budweiser', 3.250000), ('Gecko Grill', 'Budweiser', 3.000000), ('Seven Bamboo', 'Budweiser', 2.500000), ('A.P. Stump\'s', 'Hefeweizen', 6.000000), ('The B-Hive', 'Michelob Amber Bock', 5.000000), ('Blue Tattoo', 'Killian\'s', 6.000000), ('The Backbeat', 'Killian\'s', 3.500000), ('Eulipia', 'Hefeweizen Doppelbock', 4.500000), ('Giza Hookah Lounge', 'Stolichnaya Citrona', 6.000000), ('Hedley Club', 'Hefeweizen', 8.000000); /*!40000 ALTER TABLE `sells` ENABLE KEYS */; /*!40101 SET SQL_MODE=IFNULL(@OLD_SQL_MODE, '') */; /*!40014 SET FOREIGN_KEY_CHECKS=IFNULL(@OLD_FOREIGN_KEY_CHECKS, 1) */; /*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */; /*!40111 SET SQL_NOTES=IFNULL(@OLD_SQL_NOTES, 1) */;