1 files changed, 15 insertions, 0 deletions
diff --git a/src/main/sql/db_schema.sql b/src/main/sql/db_schema.sql
new file mode 100755
index 0000000..553c7a8
--- /dev/null
+++ b/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);