| Field | Type | Null | Key | Default | Extra |
| customer_id | int(11) | NO | PRI | auto_increment | |
| firstname | varchar(32) | NO | |||
| lastname | varchar(32) | NO | |||
| varchar(96) | NO | ||||
| telephone | varchar(32) | NO | |||
| fax | varchar(32) | NO | |||
| password | varchar(40) | NO | |||
| salt | varchar(9) | NO | |||
| newsletter | tinyint(1) | NO | 0 | ||
| address_id | int(11) | NO | 0 | ||
| customer_group_id | int(11) | NO | |||
| ip | varchar(40) | NO | 0 | ||
| status | tinyint(1) | NO | |||
| viewed | tinyint(1) | YES | 0 | ||
| approved | tinyint(1) | NO | |||
| token | varchar(255) | NO | |||
| date_added | datetime | NO | 0000-00-00 00:00:00 |
