diff options
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>
|