Anonymous

table virtual_users:
id int
parent_id int (contains a valid `id` value)
username varchar
pw_crypt varchar
pw_htpasswd varchar
pw_clear varchar


table unix_users:
unix int (contains a valid unix uid)
virtual int (contains a valid virtual_users.id value)


table service_settings:
user int (contains a valid unix uid)
service varchar (e.g. "ftp")
permission varchar (e.g. "username", "read_only")
value varchar (value for the permission setting)