diff options
| author | Anton Tananaev <anton.tananaev@gmail.com> | 2016-06-28 14:09:44 +1200 |
|---|---|---|
| committer | GitHub <noreply@github.com> | 2016-06-28 14:09:44 +1200 |
| commit | 7327681f0bd2338f9c8ee3ea1b4a19dcc5f0de48 (patch) | |
| tree | 0ea99ab937fbae96b35cc5dc62edbc74594af9e4 /setup | |
| parent | 67f46c80d3b5e34440a2644f52b81dddfbaba5fa (diff) | |
| parent | 61b2486353c742afe6214f0a0c5c2e9956ea3b97 (diff) | |
| download | traccar-server-7327681f0bd2338f9c8ee3ea1b4a19dcc5f0de48.tar.gz traccar-server-7327681f0bd2338f9c8ee3ea1b4a19dcc5f0de48.tar.bz2 traccar-server-7327681f0bd2338f9c8ee3ea1b4a19dcc5f0de48.zip | |
Merge pull request #2052 from Abyss777/master
Notifications via email
Diffstat (limited to 'setup')
| -rw-r--r-- | setup/unix/traccar.xml | 21 | ||||
| -rw-r--r-- | setup/windows/traccar.xml | 21 |
2 files changed, 42 insertions, 0 deletions
diff --git a/setup/unix/traccar.xml b/setup/unix/traccar.xml index b75376434..c5759f87f 100644 --- a/setup/unix/traccar.xml +++ b/setup/unix/traccar.xml @@ -252,6 +252,27 @@ DELETE FROM device_geofence WHERE deviceId = :deviceId AND geofenceId = :geofenceId; </entry> + <entry key='database.selectNotifications'> + SELECT * FROM notifications; + </entry> + + <entry key='database.insertNotification'> + INSERT INTO notifications (userId, type, attributes) + VALUES (:userId, :type, :attributes); + </entry> + + <entry key='database.updateNotification'> + UPDATE notifications SET + userId = :userId, + type = :type, + attributes = :attributes + WHERE id = :id; + </entry> + + <entry key='database.deleteNotification'> + DELETE FROM notifications WHERE id = :id; + </entry> + <!-- PROTOCOL CONFIG --> <entry key='gps103.port'>5001</entry> diff --git a/setup/windows/traccar.xml b/setup/windows/traccar.xml index 995b52c0d..1d573f282 100644 --- a/setup/windows/traccar.xml +++ b/setup/windows/traccar.xml @@ -252,6 +252,27 @@ DELETE FROM device_geofence WHERE deviceId = :deviceId AND geofenceId = :geofenceId;
</entry>
+ <entry key='database.selectNotifications'>
+ SELECT * FROM notifications;
+ </entry>
+
+ <entry key='database.insertNotification'>
+ INSERT INTO notifications (userId, type, attributes)
+ VALUES (:userId, :type, :attributes);
+ </entry>
+
+ <entry key='database.updateNotification'>
+ UPDATE notifications SET
+ userId = :userId,
+ type = :type,
+ attributes = :attributes
+ WHERE id = :id;
+ </entry>
+
+ <entry key='database.deleteNotification'>
+ DELETE FROM notifications WHERE id = :id;
+ </entry>
+
<!-- PROTOCOL CONFIG -->
<entry key='gps103.port'>5001</entry>
|