<?xml version="1.0" encoding="UTF-8"?>
<databaseChangeLog
        xmlns="http://www.liquibase.org/xml/ns/dbchangelog"
        xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"
        xsi:schemaLocation="http://www.liquibase.org/xml/ns/dbchangelog
                      http://www.liquibase.org/xml/ns/dbchangelog/dbchangelog-3.3.xsd">

  <!-- Managing both DB that use sequences and db that use auto increment -->
  <property name="autoIncrement" value="true" dbms="mysql,mssql,h2,sybase,db2,hsqldb"/>
  <property name="autoIncrement" value="false" dbms="oracle,postgresql"/>

  <changeSet id="1.1.0-1" author="task">
    <dropTable tableName="TASK_TAGS" />
    <rollback>
      <!-- This rollback is need because in unit test we will revert all changes after each test case-->
      <createTable tableName="TASK_TAGS">
        <column name="TASK_ID" type="BIGINT">
          <constraints foreignKeyName="FK_TASK_TAGS_TASK_TASKS_01" references="TASK_TASKS(TASK_ID)" nullable="false"/>
        </column>
        <column name="TAG" type="NVARCHAR(50)">
          <constraints nullable="false"/>
        </column>
      </createTable>
    </rollback>
  </changeSet>
</databaseChangeLog>