diff options
author | Trygve Laugstøl <trygvis@inamo.no> | 2014-04-21 09:01:00 +0200 |
---|---|---|
committer | Trygve Laugstøl <trygvis@inamo.no> | 2014-04-21 09:01:00 +0200 |
commit | fd681e2c6663652be02a31f7b40da4cd283ab37e (patch) | |
tree | 83cf23c1cc1f9320f2464e355d33d7abce3249e8 /calamus-engine/src/main/resources/db/public/V001_001__baseline.sql | |
parent | d38810a179a6f669ea0d3e7588f2aabed762deff (diff) | |
download | calamus-fd681e2c6663652be02a31f7b40da4cd283ab37e.tar.gz calamus-fd681e2c6663652be02a31f7b40da4cd283ab37e.tar.bz2 calamus-fd681e2c6663652be02a31f7b40da4cd283ab37e.tar.xz calamus-fd681e2c6663652be02a31f7b40da4cd283ab37e.zip |
wip
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.sql | 41 |
1 files changed, 0 insertions, 41 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 deleted file mode 100644 index 5270d2c..0000000 --- a/calamus-engine/src/main/resources/db/public/V001_001__baseline.sql +++ /dev/null @@ -1,41 +0,0 @@ -DROP SEQUENCE IF EXISTS calamus_seq; -CREATE SEQUENCE calamus_seq; - -DROP TABLE IF EXISTS artifact; -CREATE TABLE artifact ( - id BIGINT NOT NULL PRIMARY KEY, - group_id VARCHAR(100) NOT NULL, - artifact_id VARCHAR(100) NOT NULL, - version VARCHAR(100) NOT NULL, - classifier VARCHAR(100), - extension VARCHAR(100) NOT NULL, - level VARCHAR(100) NOT NULL, - git_hash CHAR(40) -); - -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 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, mvel) -VALUES ((SELECT - nextval('calamus_seq')), - (SELECT - id - FROM process - WHERE process_id = 'io.trygvis.calamus.Deploy'), - 'artifact.groupId == "demo"'); |