Table customers info

From Zen Cart(tm) Wiki
Revision as of 12:44, 8 September 2006 by Allcanadiansearch.ca (talk | contribs)
(diff) ← Older revision | Latest revision (diff) | Newer revision → (diff)
Jump to: navigation, search

Database Version

1.3.5


Description

Stores additional information about the customer not included in the customers table.


Table Details

Primary Key

customers_info_id

Indexed Fields

None.


Columns

customers_info_id Primary Key

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