Table banners history

From Zen Cart(tm) Wiki

Contents 1 Database Version 2 Description 3 Table Details 3.1 Primary Key 3.2 Indexed Fields 4 Columns 4.1 banners_history_id 4.2 banners_id 4.3 banners_shown 4.4 banners_clicked 4.5 banners_history_date 5 Default Entries

Database Version

1.3.5

Description

Contains tracking data about each banner. Banners are defined in the banners table.

Table Details

Primary Key

banners_history_id

Indexed Fields

banners_id

Columns

banners_history_id

A unique, auto incremented value, to identify each banner history record.

Type:	int(11)
Null:	No
Default:
Extra:	auto_increment

banners_id

Links the record to a specific banner. Foreign key to banners.banners_id.

Type:	int(11)
Null:	No
Default:	0

banners_shown

Number of banner impressions shown.

Type:	int(5)
Null:	No
Default:	0

banners_clicked

Number of click thrus on the specific banner.

Type:	int(5)
Null:	No
Default:	0

Limitation!

Banners written in the HTML box do not record click thrus.

banners_history_date

The date and time the entry was first recorded in the database.

Type:	datetime
Null:	No
Default:	0001-01-01 00:00:00

Default Entries

None.