
CREATE TABLE refObj (
    source varchar(255) binary not null,
    h_occurrence varchar(255) binary not null,
    h_position varchar(255) binary not null,
    h_depth integer
);
CREATE TABLE refSort (
    source varchar(255) binary not null,
    h_position varchar(255) binary not null,
    h_depth integer not null,
    h_sort varchar(255) binary not null
);
CREATE TABLE refRel (
    source varchar(255) binary not null,
    h_position varchar(255) binary not null,
    h_depth integer not null
);
CREATE TABLE objectName (
    source varchar(255) binary not null,
    value varchar(255) binary not null
);
CREATE TABLE no_inconcl_aux (
    source varchar(255) binary unique not null,
    no smallint(6) not null
);
CREATE TABLE no_concl_hyp (
    source varchar(255) binary unique not null,
    no smallint(6) not null
);
CREATE TABLE no_hyp (
    source varchar(255) binary unique not null,
    no smallint(6) not null
);
CREATE TABLE owners (
    source varchar(255) binary not null,
    owner varchar(255) binary not null
);

CREATE TABLE count (
    source varchar(255) binary unique not null,
    conclusion smallint(6) not null,
    hypothesis smallint(6) not null,
    statement smallint(6) not null
);

CREATE INDEX refObj_source ON refObj (source);
CREATE INDEX refObj_target ON refObj (h_occurrence);
CREATE INDEX refObj_position ON refObj (h_position);
CREATE INDEX refSort_source ON refSort (source);
CREATE INDEX objectName_value ON objectName (value);
CREATE INDEX no_inconcl_aux_source ON no_inconcl_aux (source);
CREATE INDEX no_inconcl_aux_no ON no_inconcl_aux (no);
CREATE INDEX no_concl_hyp_source ON no_concl_hyp (source);
CREATE INDEX no_concl_hyp_no ON no_concl_hyp (no);
CREATE INDEX no_hyp_no ON no_hyp (no);
CREATE INDEX no_hyp_source ON no_hyp (source);
CREATE INDEX owners_owner ON owners (owner);
CREATE INDEX owners_source ON owners (source);

