wip

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"');