diff options
author | Trygve Laugstøl <trygvis@inamo.no> | 2014-04-12 20:37:55 +0200 |
---|---|---|
committer | Trygve Laugstøl <trygvis@inamo.no> | 2014-04-12 20:37:55 +0200 |
commit | a521a2d74c480c53c1004e7e5e2addd28a0578f4 (patch) | |
tree | f6d36cdecb56bc35f18faf496c8251a14f3f3a26 /calamus-engine/src/main/resources/db | |
parent | bfcfcf5e3b4301bc94c27f47bfda61693edf3595 (diff) | |
download | calamus-a521a2d74c480c53c1004e7e5e2addd28a0578f4.tar.gz calamus-a521a2d74c480c53c1004e7e5e2addd28a0578f4.tar.bz2 calamus-a521a2d74c480c53c1004e7e5e2addd28a0578f4.tar.xz calamus-a521a2d74c480c53c1004e7e5e2addd28a0578f4.zip |
wip
Diffstat (limited to 'calamus-engine/src/main/resources/db')
-rw-r--r-- | calamus-engine/src/main/resources/db/public/V001_000__jbpm.sql (renamed from calamus-engine/src/main/resources/db/postgresql-jbpm-schema.sql) | 3 | ||||
-rw-r--r-- | calamus-engine/src/main/resources/db/public/V001_001__baseline.sql | 14 |
2 files changed, 17 insertions, 0 deletions
diff --git a/calamus-engine/src/main/resources/db/postgresql-jbpm-schema.sql b/calamus-engine/src/main/resources/db/public/V001_000__jbpm.sql index e13e6fb..4d2a194 100644 --- a/calamus-engine/src/main/resources/db/postgresql-jbpm-schema.sql +++ b/calamus-engine/src/main/resources/db/public/V001_000__jbpm.sql @@ -1,3 +1,6 @@ +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 new file mode 100644 index 0000000..b1e7a02 --- /dev/null +++ b/calamus-engine/src/main/resources/db/public/V001_001__baseline.sql @@ -0,0 +1,14 @@ +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, + git_hash CHAR(40) NOT NULL, + level VARCHAR(100) NOT NULL +); |