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.sql14
1 files changed, 14 insertions, 0 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
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
+);