ontohub/db/structure.sql

	structure.sql revision 0be38598001e15ea877bf3d4807e941159753df2
72e60fd4eabcfbcdbfe01e8c38b94052bc6c2067Jakub Hrozek--
72e60fd4eabcfbcdbfe01e8c38b94052bc6c2067Jakub Hrozek-- PostgreSQL database dump
72e60fd4eabcfbcdbfe01e8c38b94052bc6c2067Jakub Hrozek--
69fb159e1464ef91376f56e65afa9704d5bafad8Lukas Slebodnik
69fb159e1464ef91376f56e65afa9704d5bafad8Lukas SlebodnikSET statement_timeout = 0;
72e60fd4eabcfbcdbfe01e8c38b94052bc6c2067Jakub HrozekSET client_encoding = 'UTF8';
72e60fd4eabcfbcdbfe01e8c38b94052bc6c2067Jakub HrozekSET standard_conforming_strings = on;
69fb159e1464ef91376f56e65afa9704d5bafad8Lukas SlebodnikSET check_function_bodies = false;
72e60fd4eabcfbcdbfe01e8c38b94052bc6c2067Jakub HrozekSET client_min_messages = warning;
72e60fd4eabcfbcdbfe01e8c38b94052bc6c2067Jakub Hrozek
72e60fd4eabcfbcdbfe01e8c38b94052bc6c2067Jakub Hrozek--
72e60fd4eabcfbcdbfe01e8c38b94052bc6c2067Jakub Hrozek-- Name: plpgsql; Type: EXTENSION; Schema: -; Owner: -
72e60fd4eabcfbcdbfe01e8c38b94052bc6c2067Jakub Hrozek--
72e60fd4eabcfbcdbfe01e8c38b94052bc6c2067Jakub Hrozek
72e60fd4eabcfbcdbfe01e8c38b94052bc6c2067Jakub HrozekCREATE EXTENSION IF NOT EXISTS plpgsql WITH SCHEMA pg_catalog;
72e60fd4eabcfbcdbfe01e8c38b94052bc6c2067Jakub Hrozek
341a00311680a440d7f979f06c34c70d86c9367aBohuslav Kabrda
341a00311680a440d7f979f06c34c70d86c9367aBohuslav Kabrda--
341a00311680a440d7f979f06c34c70d86c9367aBohuslav Kabrda-- Name: EXTENSION plpgsql; Type: COMMENT; Schema: -; Owner: -
341a00311680a440d7f979f06c34c70d86c9367aBohuslav Kabrda--
341a00311680a440d7f979f06c34c70d86c9367aBohuslav Kabrda
341a00311680a440d7f979f06c34c70d86c9367aBohuslav KabrdaCOMMENT ON EXTENSION plpgsql IS 'PL/pgSQL procedural language';
341a00311680a440d7f979f06c34c70d86c9367aBohuslav Kabrda
341a00311680a440d7f979f06c34c70d86c9367aBohuslav Kabrda
341a00311680a440d7f979f06c34c70d86c9367aBohuslav KabrdaSET search_path = public, pg_catalog;
341a00311680a440d7f979f06c34c70d86c9367aBohuslav Kabrda
341a00311680a440d7f979f06c34c70d86c9367aBohuslav KabrdaSET default_tablespace = '';
341a00311680a440d7f979f06c34c70d86c9367aBohuslav Kabrda
341a00311680a440d7f979f06c34c70d86c9367aBohuslav KabrdaSET default_with_oids = false;
341a00311680a440d7f979f06c34c70d86c9367aBohuslav Kabrda
72e60fd4eabcfbcdbfe01e8c38b94052bc6c2067Jakub Hrozek--
72e60fd4eabcfbcdbfe01e8c38b94052bc6c2067Jakub Hrozek-- Name: axioms; Type: TABLE; Schema: public; Owner: -; Tablespace:
72e60fd4eabcfbcdbfe01e8c38b94052bc6c2067Jakub Hrozek--
72e60fd4eabcfbcdbfe01e8c38b94052bc6c2067Jakub Hrozek
72e60fd4eabcfbcdbfe01e8c38b94052bc6c2067Jakub HrozekCREATE TABLE axioms (
72e60fd4eabcfbcdbfe01e8c38b94052bc6c2067Jakub Hrozek    id integer NOT NULL,
c6278b2fa4a7ea389ed4086b2def16e0e6cbb184Lukas Slebodnik    ontology_id integer NOT NULL,
c6278b2fa4a7ea389ed4086b2def16e0e6cbb184Lukas Slebodnik    text character varying(255) NOT NULL,
c6278b2fa4a7ea389ed4086b2def16e0e6cbb184Lukas Slebodnik    created_at timestamp without time zone NOT NULL,
72e60fd4eabcfbcdbfe01e8c38b94052bc6c2067Jakub Hrozek    updated_at timestamp without time zone NOT NULL
72e60fd4eabcfbcdbfe01e8c38b94052bc6c2067Jakub Hrozek);
72e60fd4eabcfbcdbfe01e8c38b94052bc6c2067Jakub Hrozek
72e60fd4eabcfbcdbfe01e8c38b94052bc6c2067Jakub Hrozek
4a6a5421113ab662a665c62ed6a24b61a5a36950Jakub Hrozek--
72e60fd4eabcfbcdbfe01e8c38b94052bc6c2067Jakub Hrozek-- Name: axioms_entities; Type: TABLE; Schema: public; Owner: -; Tablespace:
72e60fd4eabcfbcdbfe01e8c38b94052bc6c2067Jakub Hrozek--
72e60fd4eabcfbcdbfe01e8c38b94052bc6c2067Jakub Hrozek
72e60fd4eabcfbcdbfe01e8c38b94052bc6c2067Jakub HrozekCREATE TABLE axioms_entities (
72e60fd4eabcfbcdbfe01e8c38b94052bc6c2067Jakub Hrozek    axiom_id integer NOT NULL,
72e60fd4eabcfbcdbfe01e8c38b94052bc6c2067Jakub Hrozek    entity_id integer NOT NULL,
72e60fd4eabcfbcdbfe01e8c38b94052bc6c2067Jakub Hrozek    ontology_id integer NOT NULL
4a6a5421113ab662a665c62ed6a24b61a5a36950Jakub Hrozek);
72e60fd4eabcfbcdbfe01e8c38b94052bc6c2067Jakub Hrozek
72e60fd4eabcfbcdbfe01e8c38b94052bc6c2067Jakub Hrozek
--
-- Name: axioms_id_seq; Type: SEQUENCE; Schema: public; Owner: -
--

CREATE SEQUENCE axioms_id_seq
    START WITH 1
    INCREMENT BY 1
    NO MINVALUE
    NO MAXVALUE
    CACHE 1;


--
-- Name: axioms_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: -
--

ALTER SEQUENCE axioms_id_seq OWNED BY axioms.id;


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

CREATE TABLE entities (
    id integer NOT NULL,
    ontology_id integer NOT NULL,
    kind character varying(255),
    text character varying(255) NOT NULL,
    name character varying(255) NOT NULL,
    uri character varying(255),
    created_at timestamp without time zone NOT NULL,
    updated_at timestamp without time zone NOT NULL
);


--
-- Name: entities_id_seq; Type: SEQUENCE; Schema: public; Owner: -
--

CREATE SEQUENCE entities_id_seq
    START WITH 1
    INCREMENT BY 1
    NO MINVALUE
    NO MAXVALUE
    CACHE 1;


--
-- Name: entities_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: -
--

ALTER SEQUENCE entities_id_seq OWNED BY entities.id;


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

CREATE TABLE links (
    id integer NOT NULL,
    source_id integer NOT NULL,
    target_id integer NOT NULL,
    kind character varying(255),
    created_at timestamp without time zone NOT NULL,
    updated_at timestamp without time zone NOT NULL
);


--
-- Name: links_id_seq; Type: SEQUENCE; Schema: public; Owner: -
--

CREATE SEQUENCE links_id_seq
    START WITH 1
    INCREMENT BY 1
    NO MINVALUE
    NO MAXVALUE
    CACHE 1;


--
-- Name: links_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: -
--

ALTER SEQUENCE links_id_seq OWNED BY links.id;


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

CREATE TABLE logics (
    id integer NOT NULL,
    name character varying(255),
    uri character varying(255),
    created_at timestamp without time zone NOT NULL,
    updated_at timestamp without time zone NOT NULL
);


--
-- Name: logics_id_seq; Type: SEQUENCE; Schema: public; Owner: -
--

CREATE SEQUENCE logics_id_seq
    START WITH 1
    INCREMENT BY 1
    NO MINVALUE
    NO MAXVALUE
    CACHE 1;


--
-- Name: logics_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: -
--

ALTER SEQUENCE logics_id_seq OWNED BY logics.id;


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

CREATE TABLE ontologies (
    id integer NOT NULL,
    logic_id integer,
    uri character varying(255),
    state character varying(255),
    name character varying(255),
    description text,
    created_at timestamp without time zone NOT NULL,
    updated_at timestamp without time zone NOT NULL
);


--
-- Name: ontologies_id_seq; Type: SEQUENCE; Schema: public; Owner: -
--

CREATE SEQUENCE ontologies_id_seq
    START WITH 1
    INCREMENT BY 1
    NO MINVALUE
    NO MAXVALUE
    CACHE 1;


--
-- Name: ontologies_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: -
--

ALTER SEQUENCE ontologies_id_seq OWNED BY ontologies.id;


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

CREATE TABLE ontology_versions (
    id integer NOT NULL,
    user_id integer NOT NULL,
    ontology_id integer NOT NULL,
    source_uri character varying(255),
    raw_file_name character varying(255),
    raw_file_size integer,
    xml_file_name character varying(255),
    xml_file_size integer,
    created_at timestamp without time zone NOT NULL,
    updated_at timestamp without time zone NOT NULL
);


--
-- Name: ontology_versions_id_seq; Type: SEQUENCE; Schema: public; Owner: -
--

CREATE SEQUENCE ontology_versions_id_seq
    START WITH 1
    INCREMENT BY 1
    NO MINVALUE
    NO MAXVALUE
    CACHE 1;


--
-- Name: ontology_versions_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: -
--

ALTER SEQUENCE ontology_versions_id_seq OWNED BY ontology_versions.id;


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

CREATE TABLE schema_migrations (
    version character varying(255) NOT NULL
);


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

CREATE TABLE users (
    id integer NOT NULL,
    email character varying(255),
    encrypted_password character varying(255),
    reset_password_token character varying(255),
    reset_password_sent_at timestamp without time zone,
    remember_created_at timestamp without time zone,
    sign_in_count integer DEFAULT 0,
    current_sign_in_at timestamp without time zone,
    last_sign_in_at timestamp without time zone,
    current_sign_in_ip character varying(255),
    last_sign_in_ip character varying(255),
    failed_attempts integer DEFAULT 0,
    unlock_token character varying(255),
    locked_at timestamp without time zone,
    name character varying(255),
    admin boolean DEFAULT false NOT NULL,
    created_at timestamp without time zone NOT NULL,
    updated_at timestamp without time zone NOT NULL,
    deleted_at timestamp without time zone
);


--
-- Name: users_id_seq; Type: SEQUENCE; Schema: public; Owner: -
--

CREATE SEQUENCE users_id_seq
    START WITH 1
    INCREMENT BY 1
    NO MINVALUE
    NO MAXVALUE
    CACHE 1;


--
-- Name: users_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: -
--

ALTER SEQUENCE users_id_seq OWNED BY users.id;


--
-- Name: id; Type: DEFAULT; Schema: public; Owner: -
--

ALTER TABLE ONLY axioms ALTER COLUMN id SET DEFAULT nextval('axioms_id_seq'::regclass);


--
-- Name: id; Type: DEFAULT; Schema: public; Owner: -
--

ALTER TABLE ONLY entities ALTER COLUMN id SET DEFAULT nextval('entities_id_seq'::regclass);


--
-- Name: id; Type: DEFAULT; Schema: public; Owner: -
--

ALTER TABLE ONLY links ALTER COLUMN id SET DEFAULT nextval('links_id_seq'::regclass);


--
-- Name: id; Type: DEFAULT; Schema: public; Owner: -
--

ALTER TABLE ONLY logics ALTER COLUMN id SET DEFAULT nextval('logics_id_seq'::regclass);


--
-- Name: id; Type: DEFAULT; Schema: public; Owner: -
--

ALTER TABLE ONLY ontologies ALTER COLUMN id SET DEFAULT nextval('ontologies_id_seq'::regclass);


--
-- Name: id; Type: DEFAULT; Schema: public; Owner: -
--

ALTER TABLE ONLY ontology_versions ALTER COLUMN id SET DEFAULT nextval('ontology_versions_id_seq'::regclass);


--
-- Name: id; Type: DEFAULT; Schema: public; Owner: -
--

ALTER TABLE ONLY users ALTER COLUMN id SET DEFAULT nextval('users_id_seq'::regclass);


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

ALTER TABLE ONLY axioms
    ADD CONSTRAINT axioms_pkey PRIMARY KEY (id);


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

ALTER TABLE ONLY entities
    ADD CONSTRAINT entities_pkey PRIMARY KEY (id);


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

ALTER TABLE ONLY links
    ADD CONSTRAINT links_pkey PRIMARY KEY (id);


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

ALTER TABLE ONLY logics
    ADD CONSTRAINT logics_pkey PRIMARY KEY (id);


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

ALTER TABLE ONLY ontologies
    ADD CONSTRAINT ontologies_pkey PRIMARY KEY (id);


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

ALTER TABLE ONLY ontology_versions
    ADD CONSTRAINT ontology_versions_pkey PRIMARY KEY (id);


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

ALTER TABLE ONLY users
    ADD CONSTRAINT users_pkey PRIMARY KEY (id);


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

CREATE INDEX index_axioms_entities_on_axiom_id_and_entity_id ON axioms_entities USING btree (axiom_id, entity_id);


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

CREATE UNIQUE INDEX index_axioms_entities_on_axiom_id_and_ontology_id ON axioms_entities USING btree (axiom_id, ontology_id);


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

CREATE INDEX index_axioms_entities_on_entity_id_and_axiom_id ON axioms_entities USING btree (entity_id, axiom_id);


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

CREATE UNIQUE INDEX index_axioms_entities_on_entity_id_and_ontology_id ON axioms_entities USING btree (entity_id, ontology_id);


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

CREATE UNIQUE INDEX index_axioms_on_ontology_id_and_id ON axioms USING btree (ontology_id, id);


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

CREATE UNIQUE INDEX index_axioms_on_ontology_id_and_text ON axioms USING btree (ontology_id, text);


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

CREATE UNIQUE INDEX index_entities_on_ontology_id_and_id ON entities USING btree (ontology_id, id);


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

CREATE UNIQUE INDEX index_entities_on_ontology_id_and_text ON entities USING btree (ontology_id, text);


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

CREATE INDEX index_links_on_source_id ON links USING btree (source_id);


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

CREATE INDEX index_links_on_target_id ON links USING btree (target_id);


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

CREATE INDEX index_ontologies_on_logic_id ON ontologies USING btree (logic_id);


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

CREATE INDEX index_ontology_versions_on_ontology_id ON ontology_versions USING btree (ontology_id);


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

CREATE INDEX index_ontology_versions_on_user_id ON ontology_versions USING btree (user_id);


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

CREATE UNIQUE INDEX index_users_on_email ON users USING btree (email);


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

CREATE UNIQUE INDEX index_users_on_reset_password_token ON users USING btree (reset_password_token);


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

CREATE UNIQUE INDEX index_users_on_unlock_token ON users USING btree (unlock_token);


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

CREATE UNIQUE INDEX unique_schema_migrations ON schema_migrations USING btree (version);


--
-- Name: axioms_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: -
--

ALTER TABLE ONLY axioms
    ADD CONSTRAINT axioms_id_fkey FOREIGN KEY (id, ontology_id) REFERENCES axioms_entities(axiom_id, ontology_id) ON DELETE CASCADE;


--
-- Name: axioms_ontology_id_fk; Type: FK CONSTRAINT; Schema: public; Owner: -
--

ALTER TABLE ONLY axioms
    ADD CONSTRAINT axioms_ontology_id_fk FOREIGN KEY (ontology_id) REFERENCES ontologies(id) ON DELETE CASCADE;


--
-- Name: entities_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: -
--

ALTER TABLE ONLY entities
    ADD CONSTRAINT entities_id_fkey FOREIGN KEY (id, ontology_id) REFERENCES axioms_entities(entity_id, ontology_id) ON DELETE CASCADE;


--
-- Name: entities_ontology_id_fk; Type: FK CONSTRAINT; Schema: public; Owner: -
--

ALTER TABLE ONLY entities
    ADD CONSTRAINT entities_ontology_id_fk FOREIGN KEY (ontology_id) REFERENCES ontologies(id) ON DELETE CASCADE;


--
-- Name: links_source_id_fk; Type: FK CONSTRAINT; Schema: public; Owner: -
--

ALTER TABLE ONLY links
    ADD CONSTRAINT links_source_id_fk FOREIGN KEY (source_id) REFERENCES ontologies(id);


--
-- Name: links_target_id_fk; Type: FK CONSTRAINT; Schema: public; Owner: -
--

ALTER TABLE ONLY links
    ADD CONSTRAINT links_target_id_fk FOREIGN KEY (target_id) REFERENCES ontologies(id);


--
-- Name: ontologies_logic_id_fk; Type: FK CONSTRAINT; Schema: public; Owner: -
--

ALTER TABLE ONLY ontologies
    ADD CONSTRAINT ontologies_logic_id_fk FOREIGN KEY (logic_id) REFERENCES logics(id);


--
-- Name: ontology_versions_ontology_id_fk; Type: FK CONSTRAINT; Schema: public; Owner: -
--

ALTER TABLE ONLY ontology_versions
    ADD CONSTRAINT ontology_versions_ontology_id_fk FOREIGN KEY (ontology_id) REFERENCES ontologies(id) ON DELETE CASCADE;


--
-- Name: ontology_versions_user_id_fk; Type: FK CONSTRAINT; Schema: public; Owner: -
--

ALTER TABLE ONLY ontology_versions
    ADD CONSTRAINT ontology_versions_user_id_fk FOREIGN KEY (user_id) REFERENCES users(id);


--
-- PostgreSQL database dump complete
--

INSERT INTO schema_migrations (version) VALUES ('20120307103820');

INSERT INTO schema_migrations (version) VALUES ('20120307142053');

INSERT INTO schema_migrations (version) VALUES ('20120307143552');

INSERT INTO schema_migrations (version) VALUES ('20120307143553');

INSERT INTO schema_migrations (version) VALUES ('20120307152347');

INSERT INTO schema_migrations (version) VALUES ('20120307152935');

INSERT INTO schema_migrations (version) VALUES ('20120307154214');

INSERT INTO schema_migrations (version) VALUES ('20120307163615');