summaryrefslogtreecommitdiff
path: root/calamus-engine/src/main/resources/db/public/V001_001__baseline.sql
diff options
context:
space:
mode:
Diffstat (limited to 'calamus-engine/src/main/resources/db/public/V001_001__baseline.sql')
-rw-r--r--calamus-engine/src/main/resources/db/public/V001_001__baseline.sql27
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"');