Table customers info
From Zen Cart(tm) Wiki
Revision as of 12:44, 8 September 2006 by Allcanadiansearch.ca (Talk | contribs)
Contents |
Database Version
- 1.3.5
Description
- Stores additional information about the customer not included in the customers table.
Table Details
Primary Key
Indexed Fields
- None.
Columns
customers_info_id 
- A unique, auto incremented value to identify each customer info entry.
Type: int(11) Null: No Default: 0 Extra: auto_increment
customers_info_date_of_last_logon
- The date and time the customer last logged in.
Type: datetime Null: Yes Default: NULL
customers_info_number_of_logons
- The number of times the customer has logged in.
Type: int(5) Null: Yes Default: NULL
customers_info_date_account_created
- The date and time the customer record was created.
Type: datetime Null: Yes Default: NULL
customers_info_date_account_last_modified
- The date and time the customer record was last modified.
Type: datetime Null: Yes Default: NULL
global_product_notifications
- Are global product notifications turned on for this customer? Can be set to 0 (no) or 1 (yes).
Type: int(1) Null: Yes Default: 0
Default Entries
customers_info_id: 1 customers_info_date_of_last_logon: 0001-01-01 00:00:00 customers_info_number_of_logons: 0 customers_info_date_account_created: 2004-01-21 01:35:28 customers_info_date_account_last_modified: 0001-01-01 00:00:00 global_product_notifications: 0
