Shopware 5.6.7 s_core_auth
Backend administration user accounts (login, password hash, role, locale, session).
| Column | Type | Nullable | Additional |
| id | int(11) | NO | Primary Key, auto_increment |
| roleID | int(11) | NO | |
| username | varchar(255) | NO | Unique |
| password | varchar(255) | NO | |
| encoder | varchar(255) | NO | Default: LegacyBackendMd5 |
| apiKey | varchar(40) | YES | |
| localeID | int(11) | NO | |
| sessionID | varchar(128) | YES | |
| lastlogin | datetime | NO | Default: 0000-00-00 00:00:00 |
| name | varchar(255) | NO | |
| email | varchar(120) | NO | |
| active | int(1) | NO | Default: 0 |
| failedlogins | int(11) | NO | |
| lockeduntil | datetime | YES | |
| extended_editor | tinyint(1) unsigned | NO | Default: 0 |
| disabled_cache | tinyint(1) unsigned | NO | Default: 0 |
| Index Name | Columns | Unique |
| PRIMARY | id | Yes |
| username | username | Yes |
Relations (to this table)
1 relations
