<?xml version="1.1" encoding="UTF-8" standalone="no"?> <databaseChangeLog xmlns="http://www.liquibase.org/xml/ns/dbchangelog" xmlns:ext="http://www.liquibase.org/xml/ns/dbchangelog-ext" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xsi:schemaLocation="http://www.liquibase.org/xml/ns/dbchangelog-ext http://www.liquibase.org/xml/ns/dbchangelog/dbchangelog-ext.xsd http://www.liquibase.org/xml/ns/dbchangelog http://www.liquibase.org/xml/ns/dbchangelog/dbchangelog-latest.xsd http://www.liquibase.org/xml/ns/dbchangelog-ext/vacuum http://www.liquibase.org/xml/ns/dbchangelog-ext/vacuum-1.0.xsd"> <changeSet author="liquibase-user" id="1::table" labels="community"> <createTable tableName="testtable1"> <column name="supplier_id" type="numeric(4)"/> <column name="supplier_name" type="VARCHAR(50)"/> </createTable> </changeSet> <changeSet author="liquibase-user" id="2::view" labels="community"> <createView fullDefinition="true" viewName="testview1">CREATE VIEW testview1 AS SELECT supplier_name FROM public.testtable1 ORDER BY supplier_name DESC; </createView> </changeSet> <changeSet author="liquibase-user" id="1::tag-u-r-it" labels="tagme"> <tagDatabase tag="myTag"/> </changeSet> <!-- Test Liquibase Postgres Extension --> <changeSet author="liquibase-user" id="1::pgExt" labels="community"> <createTable tableName="vacuumtest"> <column name="id" type="int"/> <column name="name" type="varchar(50)"/> </createTable> </changeSet> <changeSet author="liquibase-user" id="2::pgExt" labels="community,vacuum" runInTransaction="false"> <ext:vacuum tableName="vacuumtest"/> <rollback></rollback> </changeSet> <changeSet author="liquibase-user" id="1::testclasspath" labels="classpath"> <createTable tableName="testcp"> <column name="supplier_id" type="numeric(4)"/> <column name="supplier_name" type="VARCHAR(50)"/> </createTable> </changeSet> <changeSet author="liquibase-user" id="2::testclasspath" labels="classpath2"> <createTable tableName="testcp2"> <column name="supplier_id" type="numeric(4)"/> <column name="supplier_name" type="VARCHAR(50)"/> </createTable> </changeSet> <changeSet author="liquibase-user" id="3:testclasspath" labels="classpath3"> <createTable tableName="testcp3"> <column name="supplier_id" type="numeric(4)"/> <column name="supplier_name" type="VARCHAR(50)"/> </createTable> </changeSet> <changeSet author="liquibase-user" id="4:testclasspath" labels="classpath4"> <createTable tableName="testcp4"> <column name="supplier_id" type="numeric(4)"/> <column name="supplier_name" type="VARCHAR(50)"/> </createTable> </changeSet> <changeSet author="liquibase-user" id="5:testclasspath" labels="classpath5"> <createTable tableName="testcp5"> <column name="supplier_id" type="numeric(4)"/> <column name="supplier_name" type="VARCHAR(50)"/> </createTable> </changeSet> <changeSet author="liquibase-user" id="6:testclasspath" labels="classpath6"> <createTable tableName="testcp6"> <column name="supplier_id" type="numeric(4)"/> <column name="supplier_name" type="VARCHAR(50)"/> </createTable> </changeSet> </databaseChangeLog>