--
-- 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: postgres
--

COMMENT ON SCHEMA public IS 'Standard public schema';


SET search_path = public, pg_catalog;

SET default_tablespace = '';

SET default_with_oids = false;

--
-- Name: cards; Type: TABLE; Schema: public; Owner: blobtag; Tablespace: 
--

CREATE TABLE cards (
    c text,
    cid integer NOT NULL
);


ALTER TABLE public.cards OWNER TO blobtag;

--
-- Name: cards_cid_seq; Type: SEQUENCE; Schema: public; Owner: blobtag
--

CREATE SEQUENCE cards_cid_seq
    INCREMENT BY 1
    NO MAXVALUE
    NO MINVALUE
    CACHE 1;


ALTER TABLE public.cards_cid_seq OWNER TO blobtag;

--
-- Name: cards_cid_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: blobtag
--

ALTER SEQUENCE cards_cid_seq OWNED BY cards.cid;


--
-- Name: cards_cid_seq; Type: SEQUENCE SET; Schema: public; Owner: blobtag
--

SELECT pg_catalog.setval('cards_cid_seq', 136, true);


--
-- Name: triples; Type: TABLE; Schema: public; Owner: blobtag; Tablespace: 
--

CREATE TABLE triples (
    s integer,
    o integer,
    p integer,
    tid integer NOT NULL
);


ALTER TABLE public.triples OWNER TO blobtag;

--
-- Name: triples_tid_seq; Type: SEQUENCE; Schema: public; Owner: blobtag
--

CREATE SEQUENCE triples_tid_seq
    INCREMENT BY 1
    NO MAXVALUE
    NO MINVALUE
    CACHE 1;


ALTER TABLE public.triples_tid_seq OWNER TO blobtag;

--
-- Name: triples_tid_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: blobtag
--

ALTER SEQUENCE triples_tid_seq OWNED BY triples.tid;


--
-- Name: triples_tid_seq; Type: SEQUENCE SET; Schema: public; Owner: blobtag
--

SELECT pg_catalog.setval('triples_tid_seq', 10, true);


--
-- Name: cid; Type: DEFAULT; Schema: public; Owner: blobtag
--

ALTER TABLE cards ALTER COLUMN cid SET DEFAULT nextval('cards_cid_seq'::regclass);


--
-- Name: tid; Type: DEFAULT; Schema: public; Owner: blobtag
--

ALTER TABLE triples ALTER COLUMN tid SET DEFAULT nextval('triples_tid_seq'::regclass);


--
-- Data for Name: cards; Type: TABLE DATA; Schema: public; Owner: blobtag
--

COPY cards (c, cid) FROM stdin;
bt:test1	1
bt:isa	2
bt:syn	3
bt:user:Batman	130
priv:hashword	131
string:e28e60b01aaf500426a86b2d7a0ed85d7eed9dd3	132
Batman	135
string:foo	136
\.


--
-- Data for Name: triples; Type: TABLE DATA; Schema: public; Owner: blobtag
--

COPY triples (s, o, p, tid) FROM stdin;
130	132	131	9
\.


--
-- Name: cards_pkey; Type: CONSTRAINT; Schema: public; Owner: blobtag; Tablespace: 
--

ALTER TABLE ONLY cards
    ADD CONSTRAINT cards_pkey PRIMARY KEY (cid);


--
-- Name: triples_pkey; Type: CONSTRAINT; Schema: public; Owner: blobtag; Tablespace: 
--

ALTER TABLE ONLY triples
    ADD CONSTRAINT triples_pkey PRIMARY KEY (tid);


--
-- Name: triples_o_fkey; Type: FK CONSTRAINT; Schema: public; Owner: blobtag
--

ALTER TABLE ONLY triples
    ADD CONSTRAINT triples_o_fkey FOREIGN KEY (o) REFERENCES cards(cid);


--
-- Name: triples_p_fkey; Type: FK CONSTRAINT; Schema: public; Owner: blobtag
--

ALTER TABLE ONLY triples
    ADD CONSTRAINT triples_p_fkey FOREIGN KEY (p) REFERENCES cards(cid);


--
-- Name: triples_s_fkey; Type: FK CONSTRAINT; Schema: public; Owner: blobtag
--

ALTER TABLE ONLY triples
    ADD CONSTRAINT triples_s_fkey FOREIGN KEY (s) REFERENCES cards(cid);


--
-- Name: public; Type: ACL; Schema: -; Owner: postgres
--

REVOKE ALL ON SCHEMA public FROM PUBLIC;
REVOKE ALL ON SCHEMA public FROM postgres;
GRANT ALL ON SCHEMA public TO postgres;
GRANT ALL ON SCHEMA public TO PUBLIC;


--
-- PostgreSQL database dump complete
--