...
The table user contains all backend user.
User is systemwide ressource.
Table structure
| Field name | Field specification | Comment / Explanation |
|---|---|---|
| user_id | varchar(32) | Primary key |
| username | varchar(32) | Name of the user |
| password | varchar(64) | Password of the user |
| salt | varchar(32) | Personal salt of the user |
| perms | mediumtext | Permission information |
| realname | varchar(255) | Real name of the user |
| varchar(255) | Mail address of the user | |
| telephone | varchar(255) | Phone number of the user |
| address_street | varchar(255) | Street of the user |
| address_zip | varchar(10) | ZIP code of the users city |
| address_city | varchar(255) | City of the user |
| address_country | varchar(255) | Country of the user |
| wysi | tinyint(2) | Flag for using WYSIWYG editor or not |
| valid_from | date | Start date for time based activation |
| valid_to | date | End date for time based activation |
| last_pw_request | datetime | Date and time of last password request |
| tmp_pw_request | varchar(32) | Temporary password |
| using_pw_request | tinyint(1) | Flag for using password request or not |
...