summaryrefslogtreecommitdiffstats
path: root/src/mad-server.conf
diff options
context:
space:
mode:
Diffstat (limited to 'src/mad-server.conf')
-rw-r--r--src/mad-server.conf7
1 files changed, 7 insertions, 0 deletions
diff --git a/src/mad-server.conf b/src/mad-server.conf
index c19fb0f..58a5116 100644
--- a/src/mad-server.conf
+++ b/src/mad-server.conf
@@ -31,14 +31,21 @@ UserManager {
ListGroups "SELECT id, name FROM groups"
ListUserGroups "SELECT gid FROM usergroups WHERE uid = {UID}"
ListGroupUsers "SELECT uid FROM usergroups WHERE gid = {GID}"
+
UserById "SELECT id, gid, username, fullname FROM users WHERE id = {UID}"
UserByName "SELECT id, gid, username, fullname FROM users WHERE username = {USER}"
GroupById "SELECT id, name FROM groups WHERE id = {GID}"
GroupByName "SELECT id, name FROM groups WHERE name = {GROUP}"
UserGroupTable "SELECT uid, gid FROM usergroups"
+
AddUser "INSERT INTO users (id, gid, username, fullname) VALUES ({UID}, {GID}, {USER}, {FULL_NAME})"
UpdateUser "UPDATE users SET id = {UID}, gid = {GID}, username = {USER}, fullname = {FULL_NAME} WHERE id = {ORIG_UID}"
DeleteUser "DELETE FROM users WHERE id = {UID}"
+
+ AddGroup "INSERT INTO groups (id, name) VALUES ({GID}, {GROUP})"
+ UpdateGroup "UPDATE groups SET id = {GID}, name = {GROUP} WHERE id = {ORIG_GID}"
+ DeleteGroup "DELETE FROM groups WHERE id = {GID}"
+
AddUserToGroup "INSERT INTO usergroups (uid, gid) VALUES ({UID}, {GID})"
DeleteUserFromGroup "DELETE FROM usergroups WHERE uid = {UID} AND gid = {GID}"
}