--
-- PostgreSQL database dump
--

-- Dumped from database version 13.9 (Debian 13.9-0+deb11u1)
-- Dumped by pg_dump version 13.9 (Debian 13.9-0+deb11u1)

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

SET default_tablespace = '';

SET default_table_access_method = heap;

--
-- Name: horses; Type: TABLE; Schema: public; Owner: jrisacher
--

CREATE TABLE public.horses (
    id integer NOT NULL,
    name character varying(30),
    farm character varying(30),
    breed character varying(50),
    prize integer,
    date_won date
);


ALTER TABLE public.horses OWNER TO jrisacher;

--
-- Name: horses_id_seq; Type: SEQUENCE; Schema: public; Owner: jrisacher
--

CREATE SEQUENCE public.horses_id_seq
    AS integer
    START WITH 1
    INCREMENT BY 1
    NO MINVALUE
    NO MAXVALUE
    CACHE 1;


ALTER TABLE public.horses_id_seq OWNER TO jrisacher;

--
-- Name: horses_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: jrisacher
--

ALTER SEQUENCE public.horses_id_seq OWNED BY public.horses.id;


--
-- Name: horses id; Type: DEFAULT; Schema: public; Owner: jrisacher
--

ALTER TABLE ONLY public.horses ALTER COLUMN id SET DEFAULT nextval('public.horses_id_seq'::regclass);


--
-- Data for Name: horses; Type: TABLE DATA; Schema: public; Owner: jrisacher
--

COPY public.horses (id, name, farm, breed, prize, date_won) FROM stdin;
1	calypso	sleipnir stables	thoroughbred	1000	2005-03-12
2	sunny	sleipnir stables	thoroughbred	500	2012-07-15
3	Eevee	sleipnir stables	paint	300	2020-12-20
4	wally	Shenandoah stables	Icelandic horse	300	2020-12-20
5	calypso	sleipnir stables	thoroughbred	800	2011-06-23
6	Inny	Burgundy Farm	quarer horse	1000	2007-04-04
7	calypso	sleipnir stables	thoroughbred	2000	2003-01-13
8	Eevee	sleipnir stables	paint	100	2021-03-07
9	Inny	Burgundy Farm	quarer horse	200	2008-03-14
10	wally	Shenandoah stables	Icelandic horse	400	2021-09-22
11	Virginia	Marithiel	Mustang	900	2001-08-17
\.


--
-- Name: horses_id_seq; Type: SEQUENCE SET; Schema: public; Owner: jrisacher
--

SELECT pg_catalog.setval('public.horses_id_seq', 11, true);


--
-- Name: horses horses_pkey; Type: CONSTRAINT; Schema: public; Owner: jrisacher
--

ALTER TABLE ONLY public.horses
    ADD CONSTRAINT horses_pkey PRIMARY KEY (id);


--
-- PostgreSQL database dump complete
--