From 461b1fa053bcc86d06156574ab59fa7000dbf69e Mon Sep 17 00:00:00 2001
From: Kevin Hoerr <kjhoerr@noreply.cybr.es>
Date: Sat, 6 Aug 2022 01:44:00 +0000
Subject: Quarkus (#2)

Reviewed-on: https://git.submelon.dev/kjhoerr/pantry/pulls/2
---
 src/main/resources/db/changeLog.xml                |  8 ++++++
 .../db/changelogs/20220804-add-pantryitem.xml      | 30 ++++++++++++++++++++++
 2 files changed, 38 insertions(+)
 create mode 100644 src/main/resources/db/changeLog.xml
 create mode 100644 src/main/resources/db/changelogs/20220804-add-pantryitem.xml

(limited to 'src/main/resources/db')

diff --git a/src/main/resources/db/changeLog.xml b/src/main/resources/db/changeLog.xml
new file mode 100644
index 0000000..f759350
--- /dev/null
+++ b/src/main/resources/db/changeLog.xml
@@ -0,0 +1,8 @@
+<databaseChangeLog
+    xmlns="http://www.liquibase.org/xml/ns/dbchangelog"
+    xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"
+    xmlns:ext="http://www.liquibase.org/xml/ns/dbchangelog-ext"
+    xsi:schemaLocation="http://www.liquibase.org/xml/ns/dbchangelog http://www.liquibase.org/xml/ns/dbchangelog/dbchangelog-3.6.xsd
+    http://www.liquibase.org/xml/ns/dbchangelog-ext http://www.liquibase.org/xml/ns/dbchangelog/dbchangelog-ext.xsd">
+   <include file="db/changelogs/20220804-add-pantryitem.xml" />
+</databaseChangeLog>
\ No newline at end of file
diff --git a/src/main/resources/db/changelogs/20220804-add-pantryitem.xml b/src/main/resources/db/changelogs/20220804-add-pantryitem.xml
new file mode 100644
index 0000000..d118fa8
--- /dev/null
+++ b/src/main/resources/db/changelogs/20220804-add-pantryitem.xml
@@ -0,0 +1,30 @@
+<databaseChangeLog
+    xmlns="http://www.liquibase.org/xml/ns/dbchangelog"
+    xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"
+    xmlns:ext="http://www.liquibase.org/xml/ns/dbchangelog-ext"
+    xsi:schemaLocation="http://www.liquibase.org/xml/ns/dbchangelog http://www.liquibase.org/xml/ns/dbchangelog/dbchangelog-3.6.xsd
+    http://www.liquibase.org/xml/ns/dbchangelog-ext http://www.liquibase.org/xml/ns/dbchangelog/dbchangelog-ext.xsd">
+   <changeSet id="20220804-add-pantryitem" author="kjhoerr">
+        <validCheckSum>8:350c0b8d4ff8ce36a2453a0fe2373684</validCheckSum>
+        <createSequence 
+            sequenceName="hibernate_sequence"
+            incrementBy="1"
+            startValue="1"
+        />
+        <createTable tableName="pantryitem">
+            <column name="id" type="int8">
+                <constraints primaryKey="true" primaryKeyName="pk_pantryitem_id" nullable="false" />
+            </column>
+            <column name="name" type="varchar(80)">
+                <constraints nullable="false" />
+            </column>
+            <column name="description" type="varchar(1000)" />
+            <column name="quantity" type="float8">
+                <constraints nullable="false" />
+            </column>
+            <column name="quantityunittype" type="varchar(40)">
+                <constraints nullable="false" />
+            </column>
+        </createTable>
+   </changeSet>
+</databaseChangeLog>
\ No newline at end of file
-- 
cgit