| Column Name | Type | Default | Description |
|---|---|---|---|
| mnumber | int(11) | Member ID | |
| mname | varchar(16) | '' | Display name (the one used to login) |
| mrealname | varchar(60) | NULL | Full name |
| mpassword | varchar(40) | '' | password (md5 hash) |
| memail | varchar(60) | NULL | E-mail address. This should always be a valid address. |
| murl | varchar(100) | NULL | URL of members site |
| mnotes | varchar(100) | NULL | Extra notes (members can fill these out themselves) |
| madmin | tinyint(2) | '0' | Is super-admin? (1=true/0=false; super-admins have all rights; there must be at least one super-admin in the system) |
| mcanlogin | tinyint(2) | '1' | Can logon to admin area? (1=true/0=false) |
| mcookiekey | varchar(40) | NULL | A copy of the key that is stored in the users cookie. This key is used to log on. When a member logs on, a random cookiekey is generated. One copy goes into the database, another one goes into a cookie on the users computer. (together with the username). |
| deflang | varchar(20) | '' | Language file to use for this member. When empty, uses the default site language. |