connectionstring        = hostaddr=127.0.0.1 dbname=vmm user=nss password=5ecr41 connect_timeout=1

getgroupmembersbygid    = SELECT local_part||'@'||domainname AS name FROM users JOIN domain_name USING (gid) WHERE gid = $1 AND is_primary = 't'
getpwnam   = SELECT local_part||'@'||domainname AS name, '*' AS passwd, 'vmm virtual mail account' AS gecos, domaindir ||'/'||uid AS homedir, '/bin/true' AS shell, uid, gid FROM users JOIN domain_data USING (gid) JOIN domain_name USING (gid) WHERE local_part = split_part($1, '@', 1) AND domainname = split_part($1, '@', 2) AND is_primary = 't'
getpwuid   = SELECT local_part||'@'||domainname AS name, '*' AS passwd, 'vmm virtual mail account' AS gecos, domaindir ||'/'||uid AS homedir, '/bin/true' AS shell, uid, gid FROM users JOIN domain_data USING (gid) JOIN domain_name USING (gid) WHERE uid = $1 AND is_primary = 't'
allusers   = SELECT local_part||'@'||domainname AS name, '*' AS passwd, 'vmm virtual mail account' AS gecos, domaindir ||'/'||uid AS homedir, '/bin/true' AS shell, uid, gid FROM users JOIN domain_data USING (gid) JOIN domain_name USING (gid) WHERE is_primary = 't'
getgrnam   = SELECT domainname, '*' AS passwd, gid, NULL AS members FROM domain_name WHERE domainname = $1
getgrgid   = SELECT domainname, '*' AS passwd, gid, NULL AS members FROM domain_name WHERE gid = $1
groups_dyn = SELECT domainname, '*' AS passwd, gid, NULL AS members FROM domain_name WHERE is_primary = 't'
allgroups  = SELECT domainname, '*' AS passwd, gid, NULL AS members FROM domain_name WHERE is_primary = 't'