...
The table frontendgroupmembers contains all frontend users.
Frondenduser is a clientwide ressource.
Table structure
| Field name | Field specification | Comment / Explanation |
|---|---|---|
| idfrontenduser | int(11) | Primary key (auto increment) |
| idclient | int(11) | Foreign key to table client |
| username | varchar(255) | Name of the frontend user |
| password | varchar(64) | Password of the frontend user |
| salt | varchar(32) | Personal salt of the frontend user |
| active | tinyint(1) | Flag whether the frontend user is active or not |
| author | varchar(32) | Username of the creator |
| created | datetime | Date and time of creation |
| modified | datetime | Date and time of last modification |
| modifiedby | varchar(32) | USername of the last modifier |
| valid_from | datetime | Begin date and time of time scheduled activation |
| valid_to | datetime | End date and time of time scheduled activation |
...