reference:users_users

Users.Users table

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'

reference/users_users.txt · Last modified: 2018/11/14 10:45 by 127.0.0.1