reorganization continues ...

[helm.git] / metadata / sql / create_mowgli_tables.sql

diff --git a/metadata/sql/create_mowgli_tables.sql b/metadata/sql/create_mowgli_tables.sql
new file mode 100644 (file)
index 0000000..2719f43
--- /dev/null
+++ b/metadata/sql/create_mowgli_tables.sql
@@ -0,0 +1,29 @@
+
+CREATE TABLE refObj (
+    source varchar(255),
+    h_occurrence varchar(255),
+    h_position varchar(255),
+    h_depth integer
+);
+CREATE TABLE refSort (
+    source varchar(255),
+    h_position varchar(255),
+    h_depth integer,
+    h_sort varchar(255)
+);
+CREATE TABLE refRel (
+    source varchar(255),
+    h_position varchar(255),
+    h_depth integer
+);
+CREATE TABLE objectName (
+    source varchar(255),
+    value varchar(255)
+);
+
+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);
+