Difference between revisions of "Tables/bannerclient"
From Joomla! Documentation
< Tables
Line 148: | Line 148: | ||
== Notes: == | == Notes: == | ||
− | <table> | + | <table border="1"> |
<caption>Indices</caption> | <caption>Indices</caption> | ||
<tr> | <tr> |
Revision as of 07:09, 29 August 2010
Usage:[edit]
- Since:
Description:[edit]
The banner_clients table contains information that identifies clients for banner advertisements used in the mod_banners module.
Field | Type | Nullable | Default | Key | Extra | Comments |
---|---|---|---|---|---|---|
id | INTEGER | NOT NULL | PK | auto_increment | Banner Client ID. | |
name | VARCHAR(255) | NOT NULL | Client name. | |||
contact | VARCHAR(255) | NOT NULL | Contact name. | |||
VARCHAR(255) | NOT NULL | Contact email address. | ||||
extrainfo | TEXT | NOT NULL | Free-form text to describe the banner client. | |||
state | TINYINT(3) | NOT NULL | 0 |
State for the banner client. |
||
checked_out | INTEGER UNSIGNED | NOT NULL | 0 | User ID that has the banner client entry checked out. FK references #__users.id. | ||
checked_out_time | DATETIME | NOT NULL | '0000-00-00 00:00:00' | Date/time that the banner client entry was checked out by the specified user ID. | ||
metakey | TEXT | NOT NULL | Metadata keywords for the banner client. | |||
own_prefix | TINYINT | NOT NULL | 0 | |||
metakey_prefix | VARCHAR(255) | NOT NULL | ||||
purchase_type | TINYINT | NOT NULL | -1 | |||
track_clicks | TINYINT | NOT NULL | -1 | Indicates if the number of clicks are tracked for a banner client. | ||
track_impressions | TINYINT | NOT NULL | -1 | Indicates if the number of impressions are tracked for a banner client. |
Notes:[edit]
Index Name | Column(s) | Unique? |
---|---|---|
idx_own_prefix | own_prefix | No |
idx_metakey_prefix | metakey_prefix | No |
- Default character set: utf8