From 0faa5175b6f0de8835ed514615ac64135f406b29 Mon Sep 17 00:00:00 2001 From: "Benjamin J. Culkin" Date: Tue, 29 May 2018 15:35:02 -0300 Subject: Move files out of folder --- src/main/sql/db_schema.sql | 15 +++++++++++++++ 1 file changed, 15 insertions(+) create mode 100644 src/main/sql/db_schema.sql (limited to 'src/main/sql') diff --git a/src/main/sql/db_schema.sql b/src/main/sql/db_schema.sql new file mode 100644 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); -- cgit v1.2.3