diff options
| author | Abyss777 <abyss@fox5.ru> | 2017-01-13 09:26:52 +0500 |
|---|---|---|
| committer | Abyss777 <abyss@fox5.ru> | 2017-01-16 13:44:54 +0500 |
| commit | cffbce4b3bc5ef817c4063a74f148a2a5986d58a (patch) | |
| tree | 3eb18f009ec1a7ae5d806eed1a4af7b6a16840e2 /setup | |
| parent | 3533a7c9007c4ef4f761ff4d959e396b65a7b140 (diff) | |
| download | trackermap-server-cffbce4b3bc5ef817c4063a74f148a2a5986d58a.tar.gz trackermap-server-cffbce4b3bc5ef817c4063a74f148a2a5986d58a.tar.bz2 trackermap-server-cffbce4b3bc5ef817c4063a74f148a2a5986d58a.zip | |
Initial manager implementation
Diffstat (limited to 'setup')
| -rw-r--r-- | setup/default.xml | 18 |
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 --> |