The Users.Users table contains a record of all users created in VPOP3.

• 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'