diff options
Diffstat (limited to 'calamus-engine/src/main/resources/db/public')
-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 |