--
-- PostgreSQL database dump
--
SET client_encoding = 'UTF8';
SET standard_conforming_strings = off;
SET check_function_bodies = false;
SET client_min_messages = warning;
SET escape_string_warning = off;
--
-- Name: SCHEMA public; Type: COMMENT; Schema: -; Owner: -
--
COMMENT ON SCHEMA public IS 'Standard public schema';
--
-- Name: plpgsql; Type: PROCEDURAL LANGUAGE; Schema: -; Owner: -
--
CREATE PROCEDURAL LANGUAGE plpgsql;
SET search_path = public, pg_catalog;
--
-- Name: cottages_id_seq; Type: SEQUENCE; Schema: public; Owner: -
--
CREATE SEQUENCE cottages_id_seq
START WITH 1
INCREMENT BY 1
NO MAXVALUE
NO MINVALUE
CACHE 1;
SET default_tablespace = '';
SET default_with_oids = false;
--
-- Name: cottages; Type: TABLE; Schema: public; Owner: -; Tablespace:
--
CREATE TABLE cottages (
id integer DEFAULT nextval('cottages_id_seq'::regclass) NOT NULL,
created_at timestamp without time zone
);
--
-- Name: houses_id_seq; Type: SEQUENCE; Schema: public; Owner: -
--
CREATE SEQUENCE houses_id_seq
START WITH 1
INCREMENT BY 1
NO MAXVALUE
NO MINVALUE
CACHE 1;
--
-- Name: houses; Type: TABLE; Schema: public; Owner: -; Tablespace:
--
CREATE TABLE houses (
id integer DEFAULT nextval('houses_id_seq'::regclass) NOT NULL,
color character varying(50),
address text
);
--
-- Name: cottages_pkey; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace:
--
ALTER TABLE ONLY cottages
ADD CONSTRAINT cottages_pkey PRIMARY KEY (id);
--
-- Name: houses_pkey; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace:
--
ALTER TABLE ONLY houses
ADD CONSTRAINT houses_pkey PRIMARY KEY (id);
--
-- PostgreSQL database dump complete
--
