Database table user
- dominik.ziegler
- frederic.schneider
- Former user (Deleted)
Owned by dominik.ziegler
Usage
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 | datetime | Start date for time based activation |
| valid_to | datetime | 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 |
Generic DB information
| ItemCollection | Item |
|---|---|
| cApiUserCollection | cApiUser |
Previous changes of this table
| Field name | Old field specification | New field specification | Changed version |
|---|---|---|---|
| valid_from | date | datetime | 4.9.5 |
| valid_to | date | datetime | 4.9.5 |