summaryrefslogtreecommitdiff
path: root/RGens/src/main/sql
diff options
context:
space:
mode:
authorBen Culkin <benculkin@Daniel-Culkins-iMac.local>2018-05-16 12:21:55 -0400
committerBen Culkin <benculkin@Daniel-Culkins-iMac.local>2018-05-16 12:21:55 -0400
commit66f5a43dee94657a56141c093488eccbf64c7ae1 (patch)
tree0c02cc607fbee44d375691760164c1ea8e81af58 /RGens/src/main/sql
parentae9340847b7a6ef839b096d663da8162fd29c44a (diff)
Update
Diffstat (limited to 'RGens/src/main/sql')
-rwxr-xr-x[-rw-r--r--]RGens/src/main/sql/db_schema.sql0
-rwxr-xr-xRGens/src/main/sql/db_schema.sql.orig15
2 files changed, 15 insertions, 0 deletions
diff --git a/RGens/src/main/sql/db_schema.sql b/RGens/src/main/sql/db_schema.sql
index 553c7a8..553c7a8 100644..100755
--- a/RGens/src/main/sql/db_schema.sql
+++ b/RGens/src/main/sql/db_schema.sql
diff --git a/RGens/src/main/sql/db_schema.sql.orig b/RGens/src/main/sql/db_schema.sql.orig
new file mode 100755
index 0000000..10df3f0
--- /dev/null
+++ b/RGens/src/main/sql/db_schema.sql.orig
@@ -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);