value varchar(255) binary not null
);
CREATE TABLE no_inconcl_aux (
- source varchar(255) binary not null,
+ source varchar(255) binary unique not null,
no smallint(6) not null
);
CREATE TABLE no_concl_hyp (
- source varchar(255) binary not null,
+ 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 (
+CREATE TABLE hits (
source varchar(255) binary not null,
- owner varchar(255) binary not null
+ no integer 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 no_hyp_source ON no_hyp (source);
CREATE INDEX owners_owner ON owners (owner);
CREATE INDEX owners_source ON owners (source);
+CREATE INDEX hits_source ON hits (source);
+CREATE INDEX hits_no ON hits (source);