diff options
author | Trygve Laugstøl <trygvis@inamo.no> | 2014-04-13 00:04:13 +0200 |
---|---|---|
committer | Trygve Laugstøl <trygvis@inamo.no> | 2014-04-13 00:04:13 +0200 |
commit | 07dde8de9d6040e60bf59e238444f620dba330c0 (patch) | |
tree | 0be82f05640bd84db734034f91022aa1532d5217 /calamus-engine/src/main/resources/db | |
parent | a521a2d74c480c53c1004e7e5e2addd28a0578f4 (diff) | |
download | calamus-07dde8de9d6040e60bf59e238444f620dba330c0.tar.gz calamus-07dde8de9d6040e60bf59e238444f620dba330c0.tar.bz2 calamus-07dde8de9d6040e60bf59e238444f620dba330c0.tar.xz calamus-07dde8de9d6040e60bf59e238444f620dba330c0.zip |
wip
Diffstat (limited to 'calamus-engine/src/main/resources/db')
-rw-r--r-- | calamus-engine/src/main/resources/db/public/V001_001__baseline.sql | 27 |
1 files changed, 27 insertions, 0 deletions
diff --git a/calamus-engine/src/main/resources/db/public/V001_001__baseline.sql b/calamus-engine/src/main/resources/db/public/V001_001__baseline.sql index b1e7a02..3e39c06 100644 --- a/calamus-engine/src/main/resources/db/public/V001_001__baseline.sql +++ b/calamus-engine/src/main/resources/db/public/V001_001__baseline.sql @@ -12,3 +12,30 @@ CREATE TABLE artifact ( git_hash CHAR(40) NOT NULL, level VARCHAR(100) NOT NULL ); + +DROP TABLE IF EXISTS process; +CREATE TABLE process ( + id BIGINT NOT NULL PRIMARY KEY, + name VARCHAR(100) NOT NULL, + process_id VARCHAR(100) NOT NULL +); + +DROP TABLE IF EXISTS process_trigger; +CREATE TABLE process_trigger ( + id BIGINT NOT NULL PRIMARY KEY, + process_id BIGINT NOT NULL REFERENCES process, + mvel VARCHAR(1000) NOT NULL +); + +INSERT INTO process (id, name, process_id) +VALUES ((SELECT + nextval('calamus_seq')), 'Deploy', 'io.trygvis.calamus.Deploy'); + +INSERT INTO process_trigger (id, process_id, mvel) +VALUES ((SELECT + nextval('calamus_seq')), + (SELECT + id + FROM process + WHERE process_id = 'io.trygvis.calamus.Deploy'), + 'artifact.groupId == "demo"'); |