-- phpMyAdmin SQL Dump
-- version 2.11.0
-- http://www.phpmyadmin.net
--
-- Host: localhost
-- Generation Time: Sep 24, 2008 at 05:23 PM
-- Server version: 5.0.45
-- PHP Version: 5.2.4

--
-- Database: `drinking`
--

-- --------------------------------------------------------

--
-- Table structure for table `bars`
--

CREATE TABLE "bars" (
  "name" varchar(20) NOT NULL,
  "addr" varchar(50) NOT NULL,
  "license" varchar(25) NOT NULL,
  PRIMARY KEY  ("name")
);

--
-- Dumping data for table `bars`
--

INSERT INTO `bars` (`name`, `addr`, `license`) VALUES
('Joe''s', 'Maploe St.', ''),
('Sue''s', 'River Rd.', '');

-- --------------------------------------------------------

--
-- Table structure for table `beers`
--

CREATE TABLE "beers" (
  "name" varchar(20) NOT NULL,
  "manf" varchar(25) NOT NULL,
  PRIMARY KEY  ("name")
);

--
-- Dumping data for table `beers`
--

INSERT INTO `beers` (`name`, `manf`) VALUES
('Bud', 'Anheuser-Bush'),
('Bud Lite', 'Anheuser-Bush'),
('Michelob', 'Anheuser-Bush');

-- --------------------------------------------------------

--
-- Table structure for table `drinkers`
--

CREATE TABLE "drinkers" (
  "name" varchar(25) NOT NULL,
  "addr" varchar(50) NOT NULL,
  "phone" varchar(10) NOT NULL,
  PRIMARY KEY  ("name")
);

--
-- Dumping data for table `drinkers`
--


-- --------------------------------------------------------

--
-- Table structure for table `frequents`
--

CREATE TABLE "frequents" (
  "drinker" varchar(25) NOT NULL,
  "bar" varchar(20) NOT NULL,
  PRIMARY KEY  ("drinker")
);

--
-- Dumping data for table `frequents`
--

INSERT INTO `frequents` (`drinker`, `bar`) VALUES
('Sally', 'Joe''s');

-- --------------------------------------------------------

--
-- Table structure for table `likes`
--

CREATE TABLE "likes" (
  "drinker" varchar(25) NOT NULL,
  "beer" varchar(20) NOT NULL,
  PRIMARY KEY  ("drinker")
);

--
-- Dumping data for table `likes`
--

INSERT INTO `likes` (`drinker`, `beer`) VALUES
('Sally', 'Bud');

-- --------------------------------------------------------

--
-- Table structure for table `sells`
--

CREATE TABLE "sells" (
  "bar" varchar(20) NOT NULL,
  "beer" varchar(20) NOT NULL,
  "price" float NOT NULL
);

--
-- Dumping data for table `sells`
--

INSERT INTO `sells` (`bar`, `beer`, `price`) VALUES
('Joe''s', 'Bud', 2.5),
('Joe''s', 'Miller', 2.75),
('Sue''s', 'Bud', 2.5),
('Sue''s', 'Miller', 3);