stats170ab-2019: R_Hoofersdb.sql

--
-- PostgreSQL database dump
--

-- Dumped from database version 10.4
-- Dumped by pg_dump version 10.4

SET statement_timeout = 0;
SET lock_timeout = 0;
SET idle_in_transaction_session_timeout = 0;
SET client_encoding = 'SQL_ASCII';
SET standard_conforming_strings = on;
SELECT pg_catalog.set_config('search_path', '', false);
SET check_function_bodies = false;
SET client_min_messages = warning;
SET row_security = off;

--
-- Name: plpgsql; Type: EXTENSION; Schema: -; Owner: 
--

CREATE EXTENSION IF NOT EXISTS plpgsql WITH SCHEMA pg_catalog;


--
-- Name: EXTENSION plpgsql; Type: COMMENT; Schema: -; Owner: 
--

COMMENT ON EXTENSION plpgsql IS 'PL/pgSQL procedural language';


SET default_tablespace = '';

SET default_with_oids = false;

--
-- Name: Boats; Type: TABLE; Schema: public; Owner: postgres
--

CREATE TABLE public."Boats" (
    bid integer NOT NULL,
    bname character varying,
    color character varying
);


ALTER TABLE public."Boats" OWNER TO postgres;

--
-- Name: Reserves; Type: TABLE; Schema: public; Owner: postgres
--

CREATE TABLE public."Reserves" (
    sid integer,
    bid integer,
    date date
);


ALTER TABLE public."Reserves" OWNER TO postgres;

--
-- Name: Sailors; Type: TABLE; Schema: public; Owner: postgres
--

CREATE TABLE public."Sailors" (
    sid integer NOT NULL,
    sname character varying NOT NULL,
    rating integer,
    age numeric(5,1) DEFAULT NULL::numeric
);


ALTER TABLE public."Sailors" OWNER TO postgres;

--
-- Data for Name: Boats; Type: TABLE DATA; Schema: public; Owner: postgres
--

COPY public."Boats" (bid, bname, color) FROM stdin;
101     Interlake       blue
102     Interlake       red
103     Clipper green
104     Marine  red
\.


--
-- Data for Name: Reserves; Type: TABLE DATA; Schema: public; Owner: postgres
--

COPY public."Reserves" (sid, bid, date) FROM stdin;
22      101     1998-10-10
22      102     1998-10-10
22      103     1998-10-08
22      104     1998-10-07
31      102     1998-11-10
31      103     1998-11-06
31      104     1998-11-12
64      101     1998-09-05
64      102     1998-09-08
74      103     1998-09-08
\N      103     1998-09-09
1       \N      2001-01-11
1       \N      2002-02-02
\.


--
-- Data for Name: Sailors; Type: TABLE DATA; Schema: public; Owner: postgres
--

COPY public."Sailors" (sid, sname, rating, age) FROM stdin;
22      Dustin  7       45.0
29      Brutus  1       33.0
31      Lubber  8       55.5
32      Andy    8       25.5
58      Rusty   10      35.0
64      Horatio 7       35.0
71      Zorba   10      16.0
74      Horatio 9       35.0
85      Art     4       25.5
95      Bob     3       63.5
101     Joan    3       \N
107     Johannes        \N      35.0
\.


--
-- Name: Boats Boats_pkey; Type: CONSTRAINT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY public."Boats"
    ADD CONSTRAINT "Boats_pkey" PRIMARY KEY (bid);


--
-- Name: Sailors Sailors_pkey; Type: CONSTRAINT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY public."Sailors"
    ADD CONSTRAINT "Sailors_pkey" PRIMARY KEY (sid);


--
-- PostgreSQL database dump complete
--