diff options
| author | Abyss777 <abyss@fox5.ru> | 2017-07-12 09:02:49 +0500 |
|---|---|---|
| committer | Abyss777 <abyss@fox5.ru> | 2017-07-12 09:03:28 +0500 |
| commit | 2f11883528f4bfb5210259f735531e216b40fb7d (patch) | |
| tree | 076bcf7704176134b008d2b14b3c5eae8679a517 | |
| parent | 6a2efbf78f7012e893079a1c086c12ab14e92cd6 (diff) | |
| download | trackermap-server-2f11883528f4bfb5210259f735531e216b40fb7d.tar.gz trackermap-server-2f11883528f4bfb5210259f735531e216b40fb7d.tar.bz2 trackermap-server-2f11883528f4bfb5210259f735531e216b40fb7d.zip | |
Add database requests
| -rw-r--r-- | setup/default.xml | 57 |
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> |