aboutsummaryrefslogtreecommitdiff
diff options
context:
space:
mode:
authorAbyss777 <abyss@fox5.ru>2017-07-12 09:02:49 +0500
committerAbyss777 <abyss@fox5.ru>2017-07-12 09:03:28 +0500
commit2f11883528f4bfb5210259f735531e216b40fb7d (patch)
tree076bcf7704176134b008d2b14b3c5eae8679a517
parent6a2efbf78f7012e893079a1c086c12ab14e92cd6 (diff)
downloadtraccar-server-2f11883528f4bfb5210259f735531e216b40fb7d.tar.gz
traccar-server-2f11883528f4bfb5210259f735531e216b40fb7d.tar.bz2
traccar-server-2f11883528f4bfb5210259f735531e216b40fb7d.zip
Add database requests
-rw-r--r--setup/default.xml57
1 files changed, 57 insertions, 0 deletions
diff --git a/setup/default.xml b/setup/default.xml
index 2fc6c3cf0..9533c3a9b 100644
--- a/setup/default.xml
+++ b/setup/default.xml
@@ -431,6 +431,63 @@
DELETE FROM device_attribute WHERE deviceId = :deviceId AND attributeId = :attributeId
</entry>
+ <entry key='database.selectDrivers'>
+ SELECT * FROM drivers
+ </entry>
+
+ <entry key='database.insertDriver'>
+ INSERT INTO drivers (name, uniqueId, attributes)
+ VALUES (:name, :uniqueId, :attributes)
+ </entry>
+
+ <entry key='database.updateDriver'>
+ UPDATE drivers SET
+ name = :name,
+ uniqueId = :uniqueId
+ attributes = :attributes
+ WHERE id = :id
+ </entry>
+
+ <entry key='database.deleteDriver'>
+ DELETE FROM drivers WHERE id = :id
+ </entry>
+
+ <entry key='database.selectDriverPermissions'>
+ SELECT userId, driverId FROM user_driver
+ </entry>
+
+ <entry key='database.linkDriver'>
+ INSERT INTO user_driver (userId, driverId) VALUES (:userId, :driverId)
+ </entry>
+
+ <entry key='database.unlinkDriver'>
+ DELETE FROM user_attribute WHERE userId = :userId AND driverId = :driverId
+ </entry>
+
+ <entry key='database.selectGroupDrivers'>
+ SELECT groupId, driverId FROM group_driver
+ </entry>
+
+ <entry key='database.linkGroupDriver'>
+ INSERT INTO group_driver (groupId, driverId) VALUES (:groupId, :driverId)
+ </entry>
+
+ <entry key='database.unlinkGroupDriver'>
+ DELETE FROM group_driver WHERE groupId = :groupId AND driverId = :driverId
+ </entry>
+
+ <entry key='database.selectDeviceDrivers'>
+ SELECT deviceId, driverId FROM device_driver
+ </entry>
+
+ <entry key='database.linkDeviceDriver'>
+ INSERT INTO device_driver (deviceId, driverId) VALUES (:deviceId, :driverId)
+ </entry>
+
+ <entry key='database.unlinkDeviceDriver'>
+ DELETE FROM device_driver WHERE deviceId = :deviceId AND driverId = :driverId
+ </entry>
+
<!-- PROTOCOL CONFIG -->
<entry key='gps103.port'>5001</entry>