aboutsummaryrefslogtreecommitdiff
path: root/schema
diff options
context:
space:
mode:
authorAnton Tananaev <anton.tananaev@gmail.com>2018-10-10 11:42:03 +1300
committerAnton Tananaev <anton.tananaev@gmail.com>2018-10-10 11:42:03 +1300
commit81db6816268e7355df8e4a2b9600b3ab1145d84d (patch)
treed6f83a3ec4684edb772bd82a26d182879373079e /schema
parent6cfb503b400cbee3689cfb256a9779a024fe7f1d (diff)
downloadtraccar-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.xml2
-rw-r--r--schema/changelog-3.15.xml2
-rw-r--r--schema/changelog-3.7.xml8
-rw-r--r--schema/changelog-3.8.xml6
-rw-r--r--schema/changelog-4.0-clean.xml4
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">