aboutsummaryrefslogtreecommitdiff
path: root/schema
diff options
context:
space:
mode:
authorAbyss777 <abyss@fox5.ru>2018-01-23 12:16:46 +0500
committerAbyss777 <abyss@fox5.ru>2018-01-23 12:16:46 +0500
commit9b74f4a691354db61a3096794f3daeec575b8517 (patch)
tree3d70d582b42ca37b34cad8fa9c1ee9032be470b7 /schema
parente2e0501877c501cdf09158684df046e4e4c41734 (diff)
downloadtraccar-server-9b74f4a691354db61a3096794f3daeec575b8517.tar.gz
traccar-server-9b74f4a691354db61a3096794f3daeec575b8517.tar.bz2
traccar-server-9b74f4a691354db61a3096794f3daeec575b8517.zip
Implement scheduled notifications
Diffstat (limited to 'schema')
-rw-r--r--schema/changelog-3.16.xml6
1 files changed, 6 insertions, 0 deletions
diff --git a/schema/changelog-3.16.xml b/schema/changelog-3.16.xml
index 4e8e1cda9..615222676 100644
--- a/schema/changelog-3.16.xml
+++ b/schema/changelog-3.16.xml
@@ -20,5 +20,11 @@
<column name="poilayer" type="VARCHAR(512)" />
</addColumn>
+ <addColumn tableName="notifications">
+ <column name="calendarid" type="INT" />
+ </addColumn>
+
+ <addForeignKeyConstraint baseColumnNames="calendarid" baseTableName="notifications" constraintName="fk_notification_calendar_calendarid" onDelete="SET NULL" onUpdate="RESTRICT" referencedColumnNames="id" referencedTableName="calendars"/>
+
</changeSet>
</databaseChangeLog>