diff options
| author | Kevin Hoerr <kjhoerr@noreply.cybr.es> | 2022-08-06 01:44:00 +0000 |
|---|---|---|
| committer | Kevin Hoerr <kjhoerr@noreply.cybr.es> | 2022-08-06 01:44:00 +0000 |
| commit | 461b1fa053bcc86d06156574ab59fa7000dbf69e (patch) | |
| tree | 6e0080d057b5015bd92c843481cf45575af462a8 /src/main/resources/db/changelogs | |
| parent | cdf65b32202746eaffd9e58bf951d1995ab03be3 (diff) | |
| download | pantry-461b1fa053bcc86d06156574ab59fa7000dbf69e.tar.gz pantry-461b1fa053bcc86d06156574ab59fa7000dbf69e.tar.bz2 pantry-461b1fa053bcc86d06156574ab59fa7000dbf69e.zip | |
Quarkus (#2)
Reviewed-on: https://git.submelon.dev/kjhoerr/pantry/pulls/2
Diffstat (limited to 'src/main/resources/db/changelogs')
| -rw-r--r-- | src/main/resources/db/changelogs/20220804-add-pantryitem.xml | 30 |
1 files changed, 30 insertions, 0 deletions
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 |