--
--

-- Started on 2010-01-20 13:48:13 CET

SET escape_string_warning = off;




--
-- TOC entry 1494 (class 1259 OID 16386)
-- Dependencies: 3
-- Name: multisearch_config; Type: TABLE; Schema: public; Owner: bartek; Tablespace: 
--

CREATE TABLE multisearch_config (
    id integer NOT NULL,
    name text,
    value text
);


ALTER TABLE public.multisearch_config OWNER TO bartek;

--
-- TOC entry 1495 (class 1259 OID 16434)
-- Dependencies: 3
-- Name: multisearch_results; Type: TABLE; Schema: public; Owner: bartek; Tablespace: 
--

CREATE TABLE multisearch_results (
    query text NOT NULL,
    rank integer NOT NULL,
    total integer NOT NULL,
    url text NOT NULL,
    title text NOT NULL
);


ALTER TABLE public.multisearch_results OWNER TO bartek;

--
-- TOC entry 1777 (class 0 OID 16386)
-- Dependencies: 1494
-- Data for Name: multisearch_config; Type: TABLE DATA; Schema: public; Owner: bartek
--

COPY multisearch_config (id, name, value) FROM stdin;
3	BingAPIkey	\N
2	YahooAPIkey	YahooDemo
4	Google demo	015060032020641747545:vdytaz32b-q
5	test	\N
1	GoogleAPIkey	008864967094569334548:eyfn6tp4lcm
\.


--
-- TOC entry 1778 (class 0 OID 16434)
-- Dependencies: 1495
-- Data for Name: multisearch_results; Type: TABLE DATA; Schema: public; Owner: bartek
--

COPY multisearch_results (query, rank, total, url, title) FROM stdin;
\.


--
-- TOC entry 1774 (class 2606 OID 16393)
-- Dependencies: 1494 1494
-- Name: idd; Type: CONSTRAINT; Schema: public; Owner: bartek; Tablespace: 
--

ALTER TABLE ONLY multisearch_config
    ADD CONSTRAINT idd PRIMARY KEY (id);


--
-- TOC entry 1776 (class 2606 OID 16441)
-- Dependencies: 1495 1495 1495 1495 1495
-- Name: key; Type: CONSTRAINT; Schema: public; Owner: bartek; Tablespace: 
--

ALTER TABLE ONLY multisearch_results
    ADD CONSTRAINT key PRIMARY KEY (query, url, rank, total);


--
-- TOC entry 1783 (class 0 OID 0)
-- Dependencies: 3
-- 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;


-- Completed on 2010-01-20 13:48:13 CET

--
--

