From 07dde8de9d6040e60bf59e238444f620dba330c0 Mon Sep 17 00:00:00 2001
From: Trygve Laugstøl <trygvis@inamo.no>
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

