Fields (13)
| Name | Type | Null | Key | Default | Extra |
| id | int(11) unsigned | NO | PRI | NULL | auto_increment |
| email | varchar(255) | NO | MUL | NULL | |
| groupID | int(11) unsigned | NO | | NULL | |
| salutation | varchar(255) | YES | | NULL | |
| title | varchar(255) | YES | | NULL | |
| firstname | varchar(255) | YES | | NULL | |
| lastname | varchar(255) | YES | | NULL | |
| street | varchar(255) | YES | | NULL | |
| zipcode | varchar(255) | YES | | NULL | |
| city | varchar(255) | YES | | NULL | |
| added | datetime | NO | | NULL | |
| double_optin_confirmed | datetime | YES | | NULL | |
| deleted | datetime | YES | | NULL | |
Indexes (2)
| Name | Columns | Unique |
| email | email,groupID | Yes |
| PRIMARY | id | Yes |