X-Git-Url: http://matita.cs.unibo.it/gitweb/?a=blobdiff_plain;f=helm%2Fmetadata%2Fsql%2Fcreate_mowgli_tables.mysql.sql;h=d0846ec7ca8df44729c9a6c8695e4c9a9d111682;hb=532cedb4dfaee23bbddffa70801f6abf604bd436;hp=bc2e2846004955089f0a71b3e22e689d5b303c26;hpb=3feb47fdb6a5060b3b68f9fe435a17a2b9920f52;p=helm.git

diff --git a/helm/metadata/sql/create_mowgli_tables.mysql.sql b/helm/metadata/sql/create_mowgli_tables.mysql.sql
index bc2e28460..d0846ec7c 100644
--- a/helm/metadata/sql/create_mowgli_tables.mysql.sql
+++ b/helm/metadata/sql/create_mowgli_tables.mysql.sql
@@ -21,11 +21,11 @@ CREATE TABLE objectName (
     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 (
@@ -37,6 +37,13 @@ CREATE TABLE owners (
     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);