diff options
| author | bculkin2442 <bjculkin@mix.wvu.edu> | 2017-02-06 10:28:48 -0500 |
|---|---|---|
| committer | bculkin2442 <bjculkin@mix.wvu.edu> | 2017-02-06 10:28:48 -0500 |
| commit | c76fa1127918896f9a7cc7ff41191bcd5b506a75 (patch) | |
| tree | 314f76069ffaa3a4a69986e1a4174793d5c90a02 /RGens/src/main/sql | |
| parent | 67edd098d89aa86cac315f4f52343e4f42923b16 (diff) | |
Update
Diffstat (limited to 'RGens/src/main/sql')
| -rw-r--r-- | RGens/src/main/sql/db_schema.sql | 15 |
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); |
