--
-- PostgreSQL database dump
--

\connect - iangoeth_infobot

SET search_path = public, pg_catalog;

--
-- TOC entry 2 (OID 222350)
-- Name: definitionid; Type: SEQUENCE; Schema: public; Owner: goatsebot
--

CREATE SEQUENCE definitionid
    START 1
    INCREMENT 1
    MAXVALUE 9223372036854775807
    MINVALUE 1
    CACHE 1;


--
-- TOC entry 4 (OID 222352)
-- Name: definitions; Type: TABLE; Schema: public; Owner: goatsebot
--

CREATE TABLE definitions (
    definitionid bigint DEFAULT nextval('definitionid'::text) NOT NULL,
    lookupid bigint,
    lookup character varying(192),
    definition text
);


--
-- TOC entry 3 (OID 238672)
-- Name: urlid; Type: SEQUENCE; Schema: public; Owner: goatsebot
--

CREATE SEQUENCE urlid
    START 1
    INCREMENT 1
    MAXVALUE 9223372036854775807
    MINVALUE 1
    CACHE 1;


--
-- TOC entry 5 (OID 238675)
-- Name: urls; Type: TABLE; Schema: public; Owner: goatsebot
--

CREATE TABLE urls (
    urlid bigint DEFAULT nextval('urlid'::text) NOT NULL,
    who character varying(31),
    url character varying(384),
    "time" timestamp without time zone DEFAULT now()
);


--
-- TOC entry 7 (OID 222361)
-- Name: lookup; Type: INDEX; Schema: public; Owner: goatsebot
--

CREATE INDEX lookup ON definitions USING btree (lookup);


--
-- TOC entry 9 (OID 238870)
-- Name: unq_whourl; Type: INDEX; Schema: public; Owner: goatsebot
--

CREATE UNIQUE INDEX unq_whourl ON urls USING btree (who, url);


--
-- TOC entry 8 (OID 273266)
-- Name: lookupid_lookup; Type: INDEX; Schema: public; Owner: goatsebot
--

CREATE UNIQUE INDEX lookupid_lookup ON definitions USING btree (lookupid, lookup);


--
-- TOC entry 6 (OID 222358)
-- Name: definitions_pkey; Type: CONSTRAINT; Schema: public; Owner: goatsebot
--

ALTER TABLE ONLY definitions
    ADD CONSTRAINT definitions_pkey PRIMARY KEY (definitionid);


--
-- TOC entry 10 (OID 238679)
-- Name: urls_pkey; Type: CONSTRAINT; Schema: public; Owner: goatsebot
--

ALTER TABLE ONLY urls
    ADD CONSTRAINT urls_pkey PRIMARY KEY (urlid);