Change changelog for update constraint at column habbit_id at habit_status_calendar
-<?xml version="1.0" encoding="UTF-8"?>
-<databaseChangeLog xmlns="http://www.liquibase.org/xml/ns/dbchangelog"
+<?xml version="1.0" 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 http://www.liquibase.org/xml/ns/dbchangelog/dbchangelog-3.4.xsd">
- <changeSet id="zakhar" author="ZakharVeremchuk" runOnChange="true">
- <update catalogName="greencity"
- schemaName="public"
- tableName="habit_status_calendar">
- <column name="habit_assign_id">
- <constraints unique="true" nullable="false"/>
- </column>
- </update>
+ 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.4.xsd">
+ <changeSet id="zakhar123" author="ZakharVeremchuk" >
+ <addUniqueConstraint columnNames="enroll_date, habit_assign_id" constraintName="UK_eroll_date_and_habie_assign_id" tableName="habit_status_calendar"/>
</changeSet>
