======Users.Users table====== The [[db_Users|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' ''