Table customers
From Zen Cart(tm) Wiki
Database Version
- 1.3.5
Description
- Stores all the main customer information.
Table Details
Primary Key
Indexed Fields
- customers_email_address
- customers_referral
- customers_group_pricing
- customers_nick
- customers_newsletter
Columns
customers_id 
- A unique, auto incremented value, to identify each customer record.
Type: int(11) Null: No Default: Extra: auto_increment
customers_gender
- The gender of the customer. Can be set to m (male) or f (female).
Type: char(1) Null: No Default:
customers_firstname
- The first name of the customer.
Type: varchar(32) Null: No Default:
customers_lastname
- The last name of the customer.
Type: varchar(32) Null: No Default:
customers_dob
- The date of birth of the customer.
Type: datetime Null: No Default: 0001-01-01 00:00:00
customers_email_address 
- The email address of the customer.
Type: varchar(96) Null: No Default:
customers_nick
- The nickname (for the purposes of phpBB linkage) of the customer.
Type: varchar(96) Null: No Default:
customers_default_address_id
- The default address book entry to use for this customer.
Type: int(11) Null: No Default: 0
customers_telephone
- The telephone number of the customer.
Type: varchar(32) Null: No Default:
customers_fax
- The fax number of the customer.
Type: varchar(32) Null: Yes Default: NULL
customers_password
- The password of the customer (stored encrypted).
Type: varchar(40) Null: No Default:
customers_newsletter
- Is the customer signed up for the newsletter? Can be set to 0 (no) or 1 (yes).
Type: char(1) Null: Yes Default: NULL
customers_group_pricing
- The group (if any) that the customer belongs to for group pricing purposes.
Type: int(11) Null: No Default: 0
customers_email_format
- What format will the customer receive emails in. Can be set to TEXT or HTML.
Type: varchar(4) Null: No Default: TEXT
customers_authorization
- What level of authorization does the customer have?
- Options:
- 0 = Approved
- 1 = Pending Approval - Must be Authorized to Browse
- 2 = Pending Approval - May Browse But Sees No Prices
- 3 = Pending Approval - May browse with prices but may not buy
Type: int(1) Null: No Default: 0
customers_referral
- The referral-code set for how this customer was acquired.
- Depending on system configuration, this information may be entered by the customer, by the administrator, or set by the first coupon-code redeemed by the customer.
Type: varchar(32) Null: No Default:
Default Entries
customers_id: 1 customers_gender: m customers_firstname: Bill customers_lastname: Smith customers_dob: 2001-01-01 00:00:00 customers_email_address: root@localhost customers_nick: customers_default_address_id: 1 customers_telephone: 12345 customers_fax: customers_password: d95e8fa7f20a009372eb3477473fcd34:1c customers_newsletter: 0 customers_group_pricing: 0 customers_email_format: TEXT customers_authorization: 0 customers_referral:
