aboutsummaryrefslogtreecommitdiff
path: root/src/main/resources/db
diff options
context:
space:
mode:
Diffstat (limited to 'src/main/resources/db')
-rw-r--r--src/main/resources/db/changeLog.xml9
-rw-r--r--src/main/resources/db/changelogs/20220804-add-pantryitem.xml30
-rw-r--r--src/main/resources/db/changelogs/20220814-test-data.xml93
3 files changed, 0 insertions, 132 deletions
diff --git a/src/main/resources/db/changeLog.xml b/src/main/resources/db/changeLog.xml
deleted file mode 100644
index 870baf4..0000000
--- a/src/main/resources/db/changeLog.xml
+++ /dev/null
@@ -1,9 +0,0 @@
-<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" />
- <include file="db/changelogs/20220814-test-data.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
deleted file mode 100644
index f6ab0ee..0000000
--- a/src/main/resources/db/changelogs/20220804-add-pantryitem.xml
+++ /dev/null
@@ -1,30 +0,0 @@
-<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" context="migrate">
- <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
diff --git a/src/main/resources/db/changelogs/20220814-test-data.xml b/src/main/resources/db/changelogs/20220814-test-data.xml
deleted file mode 100644
index b8b9ad3..0000000
--- a/src/main/resources/db/changelogs/20220814-test-data.xml
+++ /dev/null
@@ -1,93 +0,0 @@
-<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="20220814-test-data" author="kjhoerr" context="test">
- <insert tableName="pantryitem">
- <column name="id" valueSequenceNext="hibernate_sequence"/>
- <column name="name" value="Flour"/>
- <column name="description" value="Unbleached white"/>
- <column name="quantity" value="2.3"/>
- <column name="quantityunittype" value="lb"/>
- </insert>
- <insert tableName="pantryitem">
- <column name="id" valueSequenceNext="hibernate_sequence"/>
- <column name="name" value="Sugar"/>
- <column name="description" value="Granulated"/>
- <column name="quantity" value="9.3"/>
- <column name="quantityunittype" value="oz"/>
- </insert>
- <insert tableName="pantryitem">
- <column name="id" valueSequenceNext="hibernate_sequence"/>
- <column name="name" value="Eggs"/>
- <column name="description" value="Large white"/>
- <column name="quantity" value="10"/>
- <column name="quantityunittype" value="ct"/>
- </insert>
- <insert tableName="pantryitem">
- <column name="id" valueSequenceNext="hibernate_sequence"/>
- <column name="name" value="Baking Powder"/>
- <column name="description" value="Double acting"/>
- <column name="quantity" value="3.3"/>
- <column name="quantityunittype" value="oz"/>
- </insert>
- <insert tableName="pantryitem">
- <column name="id" valueSequenceNext="hibernate_sequence"/>
- <column name="name" value="Oat Milk"/>
- <column name="description" value="Unsweetened/no flavoring"/>
- <column name="quantity" value="107"/>
- <column name="quantityunittype" value="oz"/>
- </insert>
- <insert tableName="pantryitem">
- <column name="id" valueSequenceNext="hibernate_sequence"/>
- <column name="name" value="Vanilla Extract"/>
- <column name="description" value=""/>
- <column name="quantity" value="8.8"/>
- <column name="quantityunittype" value="oz"/>
- </insert>
- <insert tableName="pantryitem">
- <column name="id" valueSequenceNext="hibernate_sequence"/>
- <column name="name" value="Almond Extract"/>
- <column name="description" value=""/>
- <column name="quantity" value="1.07"/>
- <column name="quantityunittype" value="oz"/>
- </insert>
- <insert tableName="pantryitem">
- <column name="id" valueSequenceNext="hibernate_sequence"/>
- <column name="name" value="Canola Oil"/>
- <column name="description" value=""/>
- <column name="quantity" value="51"/>
- <column name="quantityunittype" value="oz"/>
- </insert>
- <insert tableName="pantryitem">
- <column name="id" valueSequenceNext="hibernate_sequence"/>
- <column name="name" value="Salt"/>
- <column name="description" value="Iodized"/>
- <column name="quantity" value="4.5"/>
- <column name="quantityunittype" value="oz"/>
- </insert>
- <insert tableName="pantryitem">
- <column name="id" valueSequenceNext="hibernate_sequence"/>
- <column name="name" value="Baking Soda"/>
- <column name="description" value=""/>
- <column name="quantity" value="6.5"/>
- <column name="quantityunittype" value="oz"/>
- </insert>
- <insert tableName="pantryitem">
- <column name="id" valueSequenceNext="hibernate_sequence"/>
- <column name="name" value="Butter"/>
- <column name="description" value="Salted"/>
- <column name="quantity" value="3.5"/>
- <column name="quantityunittype" value="cups"/>
- </insert>
- <insert tableName="pantryitem">
- <column name="id" valueSequenceNext="hibernate_sequence"/>
- <column name="name" value="Brown Sugar"/>
- <column name="description" value=""/>
- <column name="quantity" value="15"/>
- <column name="quantityunittype" value="oz"/>
- </insert>
- </changeSet>
-</databaseChangeLog> \ No newline at end of file