From c76fa1127918896f9a7cc7ff41191bcd5b506a75 Mon Sep 17 00:00:00 2001 From: bculkin2442 Date: Mon, 6 Feb 2017 10:28:48 -0500 Subject: Update --- RGens/src/main/sql/db_schema.sql | 15 +++++++++++++++ 1 file changed, 15 insertions(+) create mode 100644 RGens/src/main/sql/db_schema.sql (limited to 'RGens/src/main/sql') 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); -- cgit v1.2.3