<?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-3.9.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>