org.aksw.bsbm.bsbm-schema2-postgres-export.sql Maven / Gradle / Ivy

Go to download
Show more of this group Show more artifacts with this name
Show all versions of sparqlify-benchmark Show documentation
There is a newer version: 0.9.8
--
-- PostgreSQL database dump
--

SET statement_timeout = 0;
SET client_encoding = 'UTF8';
SET standard_conforming_strings = off;
SET check_function_bodies = false;
SET client_min_messages = warning;
SET escape_string_warning = off;

SET search_path = public, pg_catalog;

SET default_tablespace = '';

SET default_with_oids = false;

--
-- Name: ap; Type: TABLE; Schema: public; Owner: -; Tablespace: 
--

CREATE TABLE ap (
    ap integer NOT NULL,
    dt date DEFAULT ('now'::text)::date NOT NULL,
    tt text NOT NULL,
    ur text,
    bn text,
    au text,
    ti text,
    pb text,
    yr smallint,
    uq smallint,
    ui smallint,
    ul text,
    li character(2),
    ip text,
    co text,
    ad text,
    fp text
);


--
-- Name: TABLE ap; Type: COMMENT; Schema: public; Owner: -
--

COMMENT ON TABLE ap IS 'approvers';


--
-- Name: COLUMN ap.ap; Type: COMMENT; Schema: public; Owner: -
--

COMMENT ON COLUMN ap.ap IS 'ID';


--
-- Name: COLUMN ap.dt; Type: COMMENT; Schema: public; Owner: -
--

COMMENT ON COLUMN ap.dt IS 'registration date';


--
-- Name: COLUMN ap.tt; Type: COMMENT; Schema: public; Owner: -
--

COMMENT ON COLUMN ap.tt IS 'label';


--
-- Name: COLUMN ap.ur; Type: COMMENT; Schema: public; Owner: -
--

COMMENT ON COLUMN ap.ur IS 'URI';


--
-- Name: COLUMN ap.bn; Type: COMMENT; Schema: public; Owner: -
--

COMMENT ON COLUMN ap.bn IS 'ISBN';


--
-- Name: COLUMN ap.au; Type: COMMENT; Schema: public; Owner: -
--

COMMENT ON COLUMN ap.au IS 'author';


--
-- Name: COLUMN ap.ti; Type: COMMENT; Schema: public; Owner: -
--

COMMENT ON COLUMN ap.ti IS 'title';


--
-- Name: COLUMN ap.pb; Type: COMMENT; Schema: public; Owner: -
--

COMMENT ON COLUMN ap.pb IS 'monograph publisher or serial title, volume, and page range';


--
-- Name: COLUMN ap.yr; Type: COMMENT; Schema: public; Owner: -
--

COMMENT ON COLUMN ap.yr IS 'year of publication';


--
-- Name: COLUMN ap.uq; Type: COMMENT; Schema: public; Owner: -
--

COMMENT ON COLUMN ap.uq IS 'quality measure specified by the user';


--
-- Name: COLUMN ap.ui; Type: COMMENT; Schema: public; Owner: -
--

COMMENT ON COLUMN ap.ui IS 'numeric ID specified by the user';


--
-- Name: COLUMN ap.ul; Type: COMMENT; Schema: public; Owner: -
--

COMMENT ON COLUMN ap.ul IS 'miscellaneous information';


--
-- Name: COLUMN ap.li; Type: COMMENT; Schema: public; Owner: -
--

COMMENT ON COLUMN ap.li IS 'type of offered license';


--
-- Name: COLUMN ap.ip; Type: COMMENT; Schema: public; Owner: -
--

COMMENT ON COLUMN ap.ip IS 'summary of intellectual-property claim';


--
-- Name: COLUMN ap.co; Type: COMMENT; Schema: public; Owner: -
--

COMMENT ON COLUMN ap.co IS 'name of apparent intellectual-property claimant';


--
-- Name: COLUMN ap.ad; Type: COMMENT; Schema: public; Owner: -
--

COMMENT ON COLUMN ap.ad IS 'SMTP address for licensing correspondence';


--
-- Name: COLUMN ap.fp; Type: COMMENT; Schema: public; Owner: -
--

COMMENT ON COLUMN ap.fp IS 'source file or directory path';


--
-- Name: offer; Type: TABLE; Schema: public; Owner: -; Tablespace: 
--

CREATE TABLE offer (
    nr integer NOT NULL,
    product integer,
    producer integer,
    vendor integer,
    price double precision,
    "validFrom" timestamp without time zone,
    "validTo" timestamp without time zone,
    "deliveryDays" integer,
    "offerWebpage" character varying(100),
    publisher integer,
    "publishDate" date
);


--
-- Name: person; Type: TABLE; Schema: public; Owner: -; Tablespace: 
--

CREATE TABLE person (
    nr integer NOT NULL,
    name character varying(30),
    mbox_sha1sum character(40),
    country character(2),
    publisher integer,
    "publishDate" date
);


--
-- Name: producer; Type: TABLE; Schema: public; Owner: -; Tablespace: 
--

CREATE TABLE producer (
    nr integer NOT NULL,
    label character varying(100),
    comment character varying(2000),
    homepage character varying(100),
    country character(2),
    publisher integer,
    "publishDate" date
);


--
-- Name: product; Type: TABLE; Schema: public; Owner: -; Tablespace: 
--

CREATE TABLE product (
    nr integer NOT NULL,
    label character varying(100),
    comment character varying(2000),
    producer integer,
    "propertyNum1" integer,
    "propertyNum2" integer,
    "propertyNum3" integer,
    "propertyNum4" integer,
    "propertyNum5" integer,
    "propertyNum6" integer,
    "propertyTex1" character varying(250),
    "propertyTex2" character varying(250),
    "propertyTex3" character varying(250),
    "propertyTex4" character varying(250),
    "propertyTex5" character varying(250),
    "propertyTex6" character varying(250),
    publisher integer,
    "publishDate" date
);


--
-- Name: productfeature; Type: TABLE; Schema: public; Owner: -; Tablespace: 
--

CREATE TABLE productfeature (
    nr integer NOT NULL,
    label character varying(100),
    comment character varying(2000),
    publisher integer,
    "publishDate" date
);


--
-- Name: productfeatureproduct; Type: TABLE; Schema: public; Owner: -; Tablespace: 
--

CREATE TABLE productfeatureproduct (
    product integer NOT NULL,
    productfeature integer NOT NULL
);


--
-- Name: producttype; Type: TABLE; Schema: public; Owner: -; Tablespace: 
--

CREATE TABLE producttype (
    nr integer NOT NULL,
    label character varying(100),
    comment character varying(2000),
    parent integer,
    publisher integer,
    "publishDate" date
);


--
-- Name: producttypeproduct; Type: TABLE; Schema: public; Owner: -; Tablespace: 
--

CREATE TABLE producttypeproduct (
    product integer NOT NULL,
    producttype integer NOT NULL
);


--
-- Name: review; Type: TABLE; Schema: public; Owner: -; Tablespace: 
--

CREATE TABLE review (
    nr integer NOT NULL,
    product integer,
    producer integer,
    person integer,
    "reviewDate" timestamp without time zone,
    title character varying(200),
    text text,
    language character(2),
    rating1 integer,
    rating2 integer,
    rating3 integer,
    rating4 integer,
    publisher integer,
    "publishDate" date
);


--
-- Name: test; Type: TABLE; Schema: public; Owner: -; Tablespace: 
--

CREATE TABLE test (
    id character(2)
);


--
-- Name: test10; Type: TABLE; Schema: public; Owner: -; Tablespace: 
--

CREATE TABLE test10 (
    id character(10)
);


--
-- Name: vendor; Type: TABLE; Schema: public; Owner: -; Tablespace: 
--

CREATE TABLE vendor (
    nr integer NOT NULL,
    label character varying(100),
    comment character varying(2000),
    homepage character varying(100),
    country character(2),
    publisher integer,
    "publishDate" date
);


--
-- Name: ap_pkey; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace: 
--

ALTER TABLE ONLY ap
    ADD CONSTRAINT ap_pkey PRIMARY KEY (ap);

ALTER TABLE ap CLUSTER ON ap_pkey;


--
-- Name: ap_tt_key; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace: 
--

ALTER TABLE ONLY ap
    ADD CONSTRAINT ap_tt_key UNIQUE (tt);


--
-- Name: offer_pkey; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace: 
--

ALTER TABLE ONLY offer
    ADD CONSTRAINT offer_pkey PRIMARY KEY (nr);


--
-- Name: person_pkey; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace: 
--

ALTER TABLE ONLY person
    ADD CONSTRAINT person_pkey PRIMARY KEY (nr);


--
-- Name: producer_pkey; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace: 
--

ALTER TABLE ONLY producer
    ADD CONSTRAINT producer_pkey PRIMARY KEY (nr);


--
-- Name: product_pkey; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace: 
--

ALTER TABLE ONLY product
    ADD CONSTRAINT product_pkey PRIMARY KEY (nr);


--
-- Name: productfeature_pkey; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace: 
--

ALTER TABLE ONLY productfeature
    ADD CONSTRAINT productfeature_pkey PRIMARY KEY (nr);


--
-- Name: productfeatureproduct_pkey; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace: 
--

ALTER TABLE ONLY productfeatureproduct
    ADD CONSTRAINT productfeatureproduct_pkey PRIMARY KEY (product, productfeature);


--
-- Name: producttype_pkey; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace: 
--

ALTER TABLE ONLY producttype
    ADD CONSTRAINT producttype_pkey PRIMARY KEY (nr);


--
-- Name: producttypeproduct_pkey; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace: 
--

ALTER TABLE ONLY producttypeproduct
    ADD CONSTRAINT producttypeproduct_pkey PRIMARY KEY (product, producttype);


--
-- Name: review_pkey; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace: 
--

ALTER TABLE ONLY review
    ADD CONSTRAINT review_pkey PRIMARY KEY (nr);


--
-- Name: vendor_pkey; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace: 
--

ALTER TABLE ONLY vendor
    ADD CONSTRAINT vendor_pkey PRIMARY KEY (nr);


--
-- Name: idx_review_language_upper; Type: INDEX; Schema: public; Owner: -; Tablespace: 
--

CREATE INDEX idx_review_language_upper ON review USING btree (upper((language)::text));


--
-- Name: offer_producer_product; Type: INDEX; Schema: public; Owner: -; Tablespace: 
--

CREATE UNIQUE INDEX offer_producer_product ON offer USING btree (producer, product, nr);


--
-- Name: offer_product; Type: INDEX; Schema: public; Owner: -; Tablespace: 
--

CREATE INDEX offer_product ON offer USING btree (product, "deliveryDays");


--
-- Name: offer_validto; Type: INDEX; Schema: public; Owner: -; Tablespace: 
--

CREATE INDEX offer_validto ON offer USING btree ("validTo");


--
-- Name: offer_vendor_product; Type: INDEX; Schema: public; Owner: -; Tablespace: 
--

CREATE INDEX offer_vendor_product ON offer USING btree (vendor, product);


--
-- Name: offer_webpage; Type: INDEX; Schema: public; Owner: -; Tablespace: 
--

CREATE INDEX offer_webpage ON offer USING btree ("offerWebpage");


--
-- Name: pfeature_inv; Type: INDEX; Schema: public; Owner: -; Tablespace: 
--

CREATE INDEX pfeature_inv ON productfeatureproduct USING btree (productfeature, product);


--
-- Name: producer_country; Type: INDEX; Schema: public; Owner: -; Tablespace: 
--

CREATE INDEX producer_country ON producer USING btree (country);


--
-- Name: producer_homepage; Type: INDEX; Schema: public; Owner: -; Tablespace: 
--

CREATE INDEX producer_homepage ON producer USING btree (homepage);


--
-- Name: product_label_nr; Type: INDEX; Schema: public; Owner: -; Tablespace: 
--

CREATE INDEX product_label_nr ON product USING btree (label text_pattern_ops, nr);


--
-- Name: product_lbl; Type: INDEX; Schema: public; Owner: -; Tablespace: 
--

CREATE INDEX product_lbl ON product USING btree (label);


--
-- Name: product_pn1; Type: INDEX; Schema: public; Owner: -; Tablespace: 
--

CREATE INDEX product_pn1 ON product USING btree ("propertyNum1");


--
-- Name: product_pn2; Type: INDEX; Schema: public; Owner: -; Tablespace: 
--

CREATE INDEX product_pn2 ON product USING btree ("propertyNum2");


--
-- Name: product_pn3; Type: INDEX; Schema: public; Owner: -; Tablespace: 
--

CREATE INDEX product_pn3 ON product USING btree ("propertyNum3");


--
-- Name: product_producer_nr; Type: INDEX; Schema: public; Owner: -; Tablespace: 
--

CREATE UNIQUE INDEX product_producer_nr ON product USING btree (producer, nr);


--
-- Name: ptype_inv; Type: INDEX; Schema: public; Owner: -; Tablespace: 
--

CREATE INDEX ptype_inv ON producttypeproduct USING btree (producttype, product);


--
-- Name: review_person; Type: INDEX; Schema: public; Owner: -; Tablespace: 
--

CREATE INDEX review_person ON review USING btree (person);


--
-- Name: review_person_1; Type: INDEX; Schema: public; Owner: -; Tablespace: 
--

CREATE INDEX review_person_1 ON review USING btree (person, product, title);


--
-- Name: review_producer_product; Type: INDEX; Schema: public; Owner: -; Tablespace: 
--

CREATE UNIQUE INDEX review_producer_product ON review USING btree (producer, product, nr);


--
-- Name: review_product_person_producer; Type: INDEX; Schema: public; Owner: -; Tablespace: 
--

CREATE UNIQUE INDEX review_product_person_producer ON review USING btree (product, person, producer, nr);


--
-- Name: review_textlang; Type: INDEX; Schema: public; Owner: -; Tablespace: 
--

CREATE INDEX review_textlang ON review USING btree (language);


--
-- Name: vendor_country; Type: INDEX; Schema: public; Owner: -; Tablespace: 
--

CREATE INDEX vendor_country ON vendor USING btree (country);


--
-- Name: vendor_homepage; Type: INDEX; Schema: public; Owner: -; Tablespace: 
--

CREATE INDEX vendor_homepage ON vendor USING btree (homepage);


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

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;


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

REVOKE ALL ON TABLE ap FROM PUBLIC;
REVOKE ALL ON TABLE ap FROM postgres;
GRANT ALL ON TABLE ap TO postgres;


--
-- PostgreSQL database dump complete
--