diff options
author | Anton Tananaev <anton.tananaev@gmail.com> | 2018-10-10 11:42:03 +1300 |
---|---|---|
committer | Anton Tananaev <anton.tananaev@gmail.com> | 2018-10-10 11:42:03 +1300 |
commit | 81db6816268e7355df8e4a2b9600b3ab1145d84d (patch) | |
tree | d6f83a3ec4684edb772bd82a26d182879373079e /schema | |
parent | 6cfb503b400cbee3689cfb256a9779a024fe7f1d (diff) | |
download | traccar-server-81db6816268e7355df8e4a2b9600b3ab1145d84d.tar.gz traccar-server-81db6816268e7355df8e4a2b9600b3ab1145d84d.tar.bz2 traccar-server-81db6816268e7355df8e4a2b9600b3ab1145d84d.zip |
Small changelog improvements
Diffstat (limited to 'schema')
-rw-r--r-- | schema/changelog-3.10.xml | 2 | ||||
-rw-r--r-- | schema/changelog-3.15.xml | 2 | ||||
-rw-r--r-- | schema/changelog-3.7.xml | 8 | ||||
-rw-r--r-- | schema/changelog-3.8.xml | 6 | ||||
-rw-r--r-- | schema/changelog-4.0-clean.xml | 4 |
5 files changed, 11 insertions, 11 deletions
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"> |