Fields (38)
| Name | Type | Null | Key | Default | Extra |
|---|---|---|---|---|---|
| id | int(11) | NO | PRI | NULL | auto_increment |
| password | varchar(1024) | NO | NULL | ||
| encoder | varchar(255) | NO | md5 | ||
| varchar(70) | NO | MUL | NULL | ||
| active | int(1) | NO | 0 | ||
| accountmode | int(11) | NO | NULL | ||
| confirmationkey | varchar(100) | NO | NULL | ||
| paymentID | int(11) | NO | 0 | ||
| doubleOptinRegister | tinyint(1) | YES | 0 | ||
| doubleOptinEmailSentDate | datetime | YES | NULL | ||
| doubleOptinConfirmDate | datetime | YES | NULL | ||
| firstlogin | date | YES | MUL | NULL | |
| lastlogin | datetime | YES | MUL | NULL | |
| sessionID | varchar(128) | YES | MUL | NULL | |
| newsletter | int(1) | NO | 0 | ||
| validation | varchar(255) | NO | MUL | 0 | |
| affiliate | int(10) | NO | 0 | ||
| customergroup | varchar(15) | NO | MUL | NULL | |
| paymentpreset | int(11) | NO | NULL | ||
| language | varchar(10) | NO | NULL | ||
| subshopID | int(11) | NO | NULL | ||
| referer | varchar(255) | NO | NULL | ||
| pricegroupID | int(11) unsigned | YES | MUL | NULL | |
| internalcomment | mediumtext | NO | NULL | ||
| failedlogins | int(11) | NO | NULL | ||
| lockeduntil | datetime | YES | NULL | ||
| default_billing_address_id | int(11) | YES | MUL | NULL | |
| default_shipping_address_id | int(11) | YES | MUL | NULL | |
| title | varchar(100) | YES | NULL | ||
| salutation | varchar(30) | YES | NULL | ||
| firstname | varchar(255) | YES | NULL | ||
| lastname | varchar(255) | YES | NULL | ||
| birthday | date | YES | NULL | ||
| customernumber | varchar(30) | YES | NULL | ||
| login_token | varchar(250) | YES | NULL | ||
| changed | datetime | YES | NULL | ||
| password_change_date | datetime | NO | current_timestamp() | ||
| register_opt_in_id | int(11) | YES | NULL |
Indexes (10)
| Name | Columns | Unique |
|---|---|---|
| customergroup | customergroup | No |
| default_billing_address_id | default_billing_address_id | No |
| default_shipping_address_id | default_shipping_address_id | No |
| No | ||
| firstlogin | firstlogin | No |
| lastlogin | lastlogin | No |
| pricegroupID | pricegroupID | No |
| PRIMARY | id | Yes |
| sessionID | sessionID | No |
| validation | validation | No |