diff options
| author | Trygve Laugstøl <trygvis@inamo.no> | 2014-04-13 09:59:38 +0200 |
|---|---|---|
| committer | Trygve Laugstøl <trygvis@inamo.no> | 2014-04-13 09:59:38 +0200 |
| commit | d38810a179a6f669ea0d3e7588f2aabed762deff (patch) | |
| tree | d8417283259e4f4722167bbe18b7448d8453938c /calamus-engine/src/main/resources/db | |
| parent | 07dde8de9d6040e60bf59e238444f620dba330c0 (diff) | |
| download | calamus-d38810a179a6f669ea0d3e7588f2aabed762deff.tar.gz calamus-d38810a179a6f669ea0d3e7588f2aabed762deff.tar.bz2 calamus-d38810a179a6f669ea0d3e7588f2aabed762deff.tar.xz calamus-d38810a179a6f669ea0d3e7588f2aabed762deff.zip | |
yay
Diffstat (limited to 'calamus-engine/src/main/resources/db')
| -rw-r--r-- | calamus-engine/src/main/resources/db/public/V001_000__jbpm.sql | 3 | ||||
| -rw-r--r-- | calamus-engine/src/main/resources/db/public/V001_001__baseline.sql | 12 |
2 files changed, 6 insertions, 9 deletions
diff --git a/calamus-engine/src/main/resources/db/public/V001_000__jbpm.sql b/calamus-engine/src/main/resources/db/public/V001_000__jbpm.sql index 4d2a194..e13e6fb 100644 --- a/calamus-engine/src/main/resources/db/public/V001_000__jbpm.sql +++ b/calamus-engine/src/main/resources/db/public/V001_000__jbpm.sql @@ -1,6 +1,3 @@ -DROP SCHEMA public CASCADE; -CREATE SCHEMA public; - CREATE TABLE Attachment ( AttachmentId INT8 NOT NULL, accessType INT4, 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 3e39c06..5270d2c 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 @@ -9,8 +9,8 @@ CREATE TABLE artifact ( version VARCHAR(100) NOT NULL, classifier VARCHAR(100), extension VARCHAR(100) NOT NULL, - git_hash CHAR(40) NOT NULL, - level VARCHAR(100) NOT NULL + level VARCHAR(100) NOT NULL, + git_hash CHAR(40) ); DROP TABLE IF EXISTS process; @@ -22,16 +22,16 @@ CREATE TABLE process ( 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 + 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_id, mvel) +INSERT INTO process_trigger (id, process, mvel) VALUES ((SELECT nextval('calamus_seq')), (SELECT |