From 81db6816268e7355df8e4a2b9600b3ab1145d84d Mon Sep 17 00:00:00 2001
From: Anton Tananaev <anton.tananaev@gmail.com>
Date: Wed, 10 Oct 2018 11:42:03 +1300
Subject: Small changelog improvements

---
 schema/changelog-3.10.xml      | 2 +-
 schema/changelog-3.15.xml      | 2 +-
 schema/changelog-3.7.xml       | 8 ++++----
 schema/changelog-3.8.xml       | 6 +++---
 schema/changelog-4.0-clean.xml | 4 ++--
 5 files changed, 11 insertions(+), 11 deletions(-)

(limited to 'schema')

diff --git a/schema/changelog-3.10.xml b/schema/changelog-3.10.xml
index 6d4fa634c..5495819bd 100644
--- a/schema/changelog-3.10.xml
+++ b/schema/changelog-3.10.xml
@@ -45,7 +45,7 @@
       <column name="calendarid" type="INT" />
     </addColumn>
 
-    <addForeignKeyConstraint baseColumnNames="calendarid" baseTableName="geofences" constraintName="fk_geofence_calendar_calendarid" onDelete="SET NULL" onUpdate="RESTRICT" referencedColumnNames="id" referencedTableName="calendars"/>
+    <addForeignKeyConstraint baseColumnNames="calendarid" baseTableName="geofences" constraintName="fk_geofence_calendar_calendarid" onDelete="SET NULL" onUpdate="RESTRICT" referencedColumnNames="id" referencedTableName="calendars" />
 
     <addColumn tableName="positions">
       <column name="accuracy" type="DOUBLE" defaultValueNumeric="0">
diff --git a/schema/changelog-3.15.xml b/schema/changelog-3.15.xml
index 64afd5c31..a9bea1ca1 100644
--- a/schema/changelog-3.15.xml
+++ b/schema/changelog-3.15.xml
@@ -110,7 +110,7 @@
       INSERT INTO user_notification (notificationid, userid) SELECT id AS notificationid, userid FROM notifications;
     </sql>
 
-    <dropForeignKeyConstraint baseTableName="notifications" constraintName="fk_notifications_userid"/>
+    <dropForeignKeyConstraint baseTableName="notifications" constraintName="fk_notifications_userid" />
     <dropColumn tableName="notifications" columnName="userid" />
 
     <addForeignKeyConstraint baseTableName="user_notification" baseColumnNames="notificationid" constraintName="fk_user_notification_notificationid" referencedTableName="notifications" referencedColumnNames="id" onDelete="CASCADE" />
diff --git a/schema/changelog-3.7.xml b/schema/changelog-3.7.xml
index 1d1cdbaac..427497f43 100644
--- a/schema/changelog-3.7.xml
+++ b/schema/changelog-3.7.xml
@@ -15,14 +15,14 @@
     </preConditions>
 
     <update tableName="devices">
-      <column name="groupid"/>
+      <column name="groupid" />
       <where>groupid NOT IN (SELECT id FROM groups)</where>
     </update>
 
-    <addForeignKeyConstraint baseColumnNames="groupid" baseTableName="devices" constraintName="fk_device_group_groupid" onDelete="SET NULL" onUpdate="RESTRICT" referencedColumnNames="id" referencedTableName="groups"/>
+    <addForeignKeyConstraint baseColumnNames="groupid" baseTableName="devices" constraintName="fk_device_group_groupid" onDelete="SET NULL" onUpdate="RESTRICT" referencedColumnNames="id" referencedTableName="groups" />
 
     <update tableName="groups">
-      <column name="groupid"/>
+      <column name="groupid" />
       <where>groupid NOT IN (SELECT id FROM (SELECT DISTINCT id FROM groups) AS groups_ids)</where>
     </update>
 
@@ -55,7 +55,7 @@
       </not>
     </preConditions>
 
-    <addForeignKeyConstraint baseColumnNames="groupid" baseTableName="groups" constraintName="fk_group_group_groupid" onDelete="SET NULL" onUpdate="RESTRICT" referencedColumnNames="id" referencedTableName="groups"/>
+    <addForeignKeyConstraint baseColumnNames="groupid" baseTableName="groups" constraintName="fk_group_group_groupid" onDelete="SET NULL" onUpdate="RESTRICT" referencedColumnNames="id" referencedTableName="groups" />
 
   </changeSet>
 
diff --git a/schema/changelog-3.8.xml b/schema/changelog-3.8.xml
index fed12c563..aeed32888 100644
--- a/schema/changelog-3.8.xml
+++ b/schema/changelog-3.8.xml
@@ -33,15 +33,15 @@
     <addUniqueConstraint tableName="attribute_aliases" columnNames="deviceid, attribute" constraintName="uk_deviceid_attribute" />
 
     <update tableName="users">
-      <column name="map" type="VARCHAR(128)"/>
+      <column name="map" type="VARCHAR(128)" />
       <where>map = 'osm'</where>
     </update>
     <update tableName="users">
-      <column name="distanceunit" type="VARCHAR(128)"/>
+      <column name="distanceunit" type="VARCHAR(128)" />
       <where>distanceunit = 'km'</where>
     </update>
     <update tableName="users">
-      <column name="speedunit" type="VARCHAR(128)"/>
+      <column name="speedunit" type="VARCHAR(128)" />
       <where>speedunit = 'kmh'</where>
     </update>
 
diff --git a/schema/changelog-4.0-clean.xml b/schema/changelog-4.0-clean.xml
index 96490a3f0..0f3f694ba 100644
--- a/schema/changelog-4.0-clean.xml
+++ b/schema/changelog-4.0-clean.xml
@@ -6,8 +6,8 @@
                       http://www.liquibase.org/xml/ns/dbchangelog/dbchangelog-3.6.xsd"
   logicalFilePath="changelog-4.0-clean">
 
-  <property name="blob.type" value="BLOB" dbms="h2,mysql,mssql,oracle"/>
-  <property name="blob.type" value="bytea" dbms="postgresql"/>
+  <property name="blob.type" value="BLOB" dbms="h2,mysql,mssql,oracle" />
+  <property name="blob.type" value="bytea" dbms="postgresql" />
 
   <changeSet author="author" id="changelog-4.0-clean">
 
-- 
cgit v1.2.3