diff options
Diffstat (limited to 'setup')
| -rw-r--r-- | setup/default.xml | 17 |
1 files changed, 15 insertions, 2 deletions
diff --git a/setup/default.xml b/setup/default.xml index 1572ae60c..eab11e10e 100644 --- a/setup/default.xml +++ b/setup/default.xml @@ -64,8 +64,8 @@ </entry> <entry key='database.insertUser'> - INSERT INTO users (name, email, hashedPassword, salt, readonly, admin, map, distanceUnit, speedUnit, latitude, longitude, zoom, twelveHourFormat, coordinateFormat, disabled, expirationTime, deviceLimit, token, attributes) - VALUES (:name, :email, :hashedPassword, :salt, :readonly, :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'> @@ -85,6 +85,7 @@ disabled = :disabled, expirationTime = :expirationTime, deviceLimit = :deviceLimit, + userLimit = :userLimit, token = :token, attributes = :attributes WHERE id = :id @@ -350,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 --> |