The Users.Users table contains a record of all users created in VPOP3.
Columns
usernumber - this is a number which is used to refer to the user in other database tables
username - this is the text name of the user
username is case insensitive and is indexed in lower case, so to take advantage of the index use something like SELECT * FROM users.users WHERE LOWER(username)='fred'