From 07dde8de9d6040e60bf59e238444f620dba330c0 Mon Sep 17 00:00:00 2001 From: Trygve Laugstøl Date: Sun, 13 Apr 2014 00:04:13 +0200 Subject: wip --- .../resources/db/public/V001_001__baseline.sql | 27 ++++++++++++++++++++++ 1 file changed, 27 insertions(+) (limited to 'calamus-engine/src/main/resources/db/public/V001_001__baseline.sql') 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"'); -- cgit v1.2.3