summaryrefslogtreecommitdiff
path: root/RGens/src/main/sql
diff options
context:
space:
mode:
authorbculkin2442 <bjculkin@mix.wvu.edu>2017-02-06 10:28:48 -0500
committerbculkin2442 <bjculkin@mix.wvu.edu>2017-02-06 10:28:48 -0500
commitc76fa1127918896f9a7cc7ff41191bcd5b506a75 (patch)
tree314f76069ffaa3a4a69986e1a4174793d5c90a02 /RGens/src/main/sql
parent67edd098d89aa86cac315f4f52343e4f42923b16 (diff)
Update
Diffstat (limited to 'RGens/src/main/sql')
-rw-r--r--RGens/src/main/sql/db_schema.sql15
1 files changed, 15 insertions, 0 deletions
diff --git a/RGens/src/main/sql/db_schema.sql b/RGens/src/main/sql/db_schema.sql
new file mode 100644
index 0000000..10df3f0
--- /dev/null
+++ b/RGens/src/main/sql/db_schema.sql
@@ -0,0 +1,15 @@
+create table Rules (
+ ruleid serial,
+ name varchar(255) not null,
+ casecount int,
+ primary key(id)
+);
+
+create index Rules_name on Rules(name);
+
+create table RuleCases (
+ ruleid serial,
+ cse varchar(255) array
+);
+
+create index RuleCase_id on RuleCases(ruleid);