summaryrefslogtreecommitdiff
path: root/calamus-engine/src/main/resources/db/public/V001_001__baseline.sql
diff options
context:
space:
mode:
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.sql41
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"');