aboutsummaryrefslogtreecommitdiff
path: root/setup
diff options
context:
space:
mode:
authorAbyss777 <abyss@fox5.ru>2017-01-13 09:26:52 +0500
committerAbyss777 <abyss@fox5.ru>2017-01-16 13:44:54 +0500
commitcffbce4b3bc5ef817c4063a74f148a2a5986d58a (patch)
tree3eb18f009ec1a7ae5d806eed1a4af7b6a16840e2 /setup
parent3533a7c9007c4ef4f761ff4d959e396b65a7b140 (diff)
downloadtraccar-server-cffbce4b3bc5ef817c4063a74f148a2a5986d58a.tar.gz
traccar-server-cffbce4b3bc5ef817c4063a74f148a2a5986d58a.tar.bz2
traccar-server-cffbce4b3bc5ef817c4063a74f148a2a5986d58a.zip
Initial manager implementation
Diffstat (limited to 'setup')
-rw-r--r--setup/default.xml18
1 files changed, 16 insertions, 2 deletions
diff --git a/setup/default.xml b/setup/default.xml
index 9f15e2f4b..eab11e10e 100644
--- a/setup/default.xml
+++ b/setup/default.xml
@@ -64,14 +64,15 @@
</entry>
<entry key='database.insertUser'>
- INSERT INTO users (name, email, hashedPassword, salt, admin, map, distanceUnit, speedUnit, latitude, longitude, zoom, twelveHourFormat, coordinateFormat, disabled, expirationTime, deviceLimit, token, attributes)
- VALUES (:name, :email, :hashedPassword, :salt, :admin, :map, :distanceUnit, :speedUnit, :latitude, :longitude, :zoom, :twelveHourFormat, :coordinateFormat, :disabled, :expirationTime, :deviceLimit, :token, :attributes)
+ INSERT INTO users (name, email, hashedPassword, salt, readonly, admin, map, distanceUnit, speedUnit, latitude, longitude, zoom, twelveHourFormat, coordinateFormat, disabled, expirationTime, deviceLimit, userLimit, token, attributes)
+ VALUES (:name, :email, :hashedPassword, :salt, :readonly, :admin, :map, :distanceUnit, :speedUnit, :latitude, :longitude, :zoom, :twelveHourFormat, :coordinateFormat, :disabled, :expirationTime, :deviceLimit, :userLimit, :token, :attributes)
</entry>
<entry key='database.updateUser'>
UPDATE users SET
name = :name,
email = :email,
+ readonly = :readonly,
admin = :admin,
map = :map,
distanceUnit = :distanceUnit,
@@ -84,6 +85,7 @@
disabled = :disabled,
expirationTime = :expirationTime,
deviceLimit = :deviceLimit,
+ userLimit = :userLimit,
token = :token,
attributes = :attributes
WHERE id = :id
@@ -349,6 +351,18 @@
<entry key='database.unlinkCalendar'>
DELETE FROM user_calendar WHERE userId = :userId AND calendarId = :calendarId
</entry>
+
+ <entry key='database.selectUserPermissions'>
+ SELECT userId, otherUserId FROM user_user
+ </entry>
+
+ <entry key='database.linkUser'>
+ INSERT INTO user_user (userId, otherUserId) VALUES (:userId, :otherUserId)
+ </entry>
+
+ <entry key='database.unlinkUser'>
+ DELETE FROM user_user WHERE userId = :userId AND otherUserId = :otherUserId
+ </entry>
<!-- PROTOCOL CONFIG -->