--
-- PostgreSQL database dump
--

SET client_encoding = 'SQL_ASCII';
SET check_function_bodies = false;

SET SESSION AUTHORIZATION 'slicks';

SET search_path = public, pg_catalog;

--
-- TOC entry 3 (OID 586676)
-- Name: bm_search; Type: TABLE; Schema: public; Owner: slicks
--

CREATE TABLE bm_search (
    id serial NOT NULL,
    bookmark_id integer NOT NULL,
    type_id integer NOT NULL,
    mode_id integer NOT NULL,
    url text NOT NULL,
    pattern text NOT NULL,
    command text
);


--
-- Data for TOC entry 6 (OID 586676)
-- Name: bm_search; Type: TABLE DATA; Schema: public; Owner: slicks
--

INSERT INTO bm_search VALUES (1, 1, 1, 1, 'http://repertoire.bmi.com/TitleSearch.asp?querytype=WorkName&page=1&fromrow=1&torow=25&keyname=$key&blnWriter=True&blnPublisher=True&blnArtist=False&blnAltTitles=False', '/.*There are (\\d+) Titles.*/', 'curl -D /tmp/coverdbheader -b bmiRepDisclaimerReadNew=T "http://repertoire.bmi.com/getinput.asp?TypeofSearch=title&SearchFor=foo" > /dev/null; curl -b /tmp/coverdbheader "http://repertoire.bmi.com/TitleSearch.asp?querytype=WorkName&page=1&fromrow=1&torow=25&keyname=$key&blnWriter=True&blnPublisher=True&blnArtist=True&blnAltTitles=True"');
INSERT INTO bm_search VALUES (2, 1, 2, 1, 'http://repertoire.bmi.com/artistSearch.asp?blnWriter=True&blnPublisher=True&blnArtist=True&blnAltTitles=True&queryType=ArtistName&page=1&keyname=$key&keyid=0&fromrow=1&torow=25', '/.*There are (\\d+) Artists.*/', NULL);
INSERT INTO bm_search VALUES (3, 1, 3, 1, 'http://repertoire.bmi.com/WriterSearch.asp?blnWriter=True&blnPublisher=True&blnArtist=True&blnAltTitles=True&queryType=WriterName&page=1&keyname=$key&keyid=0&fromrow=1&torow=25', '/.*There are (\\d+) Songwriter.*/', NULL);
INSERT INTO bm_search VALUES (4, 1, 4, 1, 'http://repertoire.bmi.com/pubSearch.asp?blnWriter=True&blnPublisher=True&blnArtist=True&blnAltTitles=True&queryType=PubName&page=1&keyname=$key&keyid=0&fromrow=1&torow=25', '/.*There are (\\d+) Publishers.*/', NULL);
INSERT INTO bm_search VALUES (5, 2, 1, 1, 'http://www.ascap.com/ace/search.cfm?requesttimeout=300&searchstr=$key&search_in=t&dsn=ws_ascap_2&start=1&mode=results&pageNum=1&search=Search&search_type=exact&search_det=t,s,w,p,b,v&results_pp=10', '/.*returned[over ]*(\\d+) results.*/', NULL);
INSERT INTO bm_search VALUES (6, 2, 2, 1, 'http://www.ascap.com/ace/search.cfm?requesttimeout=300&searchstr=$key&search_in=p&dsn=ws_ascap_2&start=1&mode=results&pageNum=1&search=Search&search_type=exact&search_det=t,s,w,p,b,v&results_pp=10', '/.*returned (\\d+) results.*/', NULL);
INSERT INTO bm_search VALUES (7, 2, 3, 1, 'http://www.ascap.com/ace/search.cfm?requesttimeout=300&searchstr=$key&search_in=w&dsn=ws_ascap_2&start=1&mode=results&pageNum=1&search=Search&search_type=exact&search_det=t,s,w,p,b,v&results_pp=10', '/.*returned (\\d+) results.*/', NULL);
INSERT INTO bm_search VALUES (8, 2, 4, 1, 'http://www.ascap.com/ace/search.cfm?requesttimeout=300&searchstr=$key&search_in=b&dsn=ws_ascap_2&start=1&mode=results&pageNum=1&search=Search&search_type=exact&search_det=t,s,w,p,b,v&results_pp=10', '/.*returned (\\d+) results.*/', NULL);
INSERT INTO bm_search VALUES (9, 3, 1, 2, 'http://www.originals.be', '/main.cfm.c=t_.*_show/', 'curl -d wat=$key -d waar=titel -d Submit=Search http://www.originals.be/eng/main.cfm?c=zoek_uitvoer');
INSERT INTO bm_search VALUES (10, 3, 3, 2, 'http://www.originals.be', '/main.cfm.c=t_.*_show/', 'curl -d wat=$key -d waar=auteur -d Submit=Search http://www.originals.be/eng/main.cfm?c=zoek_uitvoer');
INSERT INTO bm_search VALUES (11, 3, 2, 2, 'http://www.originals.be', '/main.cfm.c=t_.*_show/', 'curl -d wat=$key -d waar=origineel -d Submit=Search http://www.originals.be/eng/main.cfm?c=zoek_uitvoer');


--
-- TOC entry 5 (OID 593333)
-- Name: bm_search_pkey; Type: CONSTRAINT; Schema: public; Owner: slicks
--

ALTER TABLE ONLY bm_search
    ADD CONSTRAINT bm_search_pkey PRIMARY KEY (id);


--
-- TOC entry 7 (OID 593451)
-- Name: $1; Type: FK CONSTRAINT; Schema: public; Owner: slicks
--

ALTER TABLE ONLY bm_search
    ADD CONSTRAINT "$1" FOREIGN KEY (bookmark_id) REFERENCES bookmark(id);


--
-- TOC entry 8 (OID 593455)
-- Name: $2; Type: FK CONSTRAINT; Schema: public; Owner: slicks
--

ALTER TABLE ONLY bm_search
    ADD CONSTRAINT "$2" FOREIGN KEY (type_id) REFERENCES bm_search_t(id);


--
-- TOC entry 9 (OID 593459)
-- Name: $3; Type: FK CONSTRAINT; Schema: public; Owner: slicks
--

ALTER TABLE ONLY bm_search
    ADD CONSTRAINT "$3" FOREIGN KEY (mode_id) REFERENCES bm_mode_t(id);


--
-- TOC entry 4 (OID 586674)
-- Name: bm_search_id_seq; Type: SEQUENCE SET; Schema: public; Owner: slicks
--

SELECT pg_catalog.setval('bm_search_id_seq', 11, true);


