Difference between revisions of "Tables/bannerclient"
From Joomla! Documentation
< Tables
| Line 34: | Line 34: | ||
<td></td> | <td></td> | ||
<td></td> | <td></td> | ||
| − | <td> | + | <td>Client name.</td> |
| − | |||
| − | |||
</tr> | </tr> | ||
<tr> | <tr> | ||
| Line 45: | Line 43: | ||
<td></td> | <td></td> | ||
<td></td> | <td></td> | ||
| − | <td> | + | <td>Contact name.</td> |
| − | |||
| − | |||
</tr> | </tr> | ||
<tr> | <tr> | ||
| Line 56: | Line 52: | ||
<td></td> | <td></td> | ||
<td></td> | <td></td> | ||
| − | <td> | + | <td>Contact email address.</td> |
| − | |||
| − | |||
</tr> | </tr> | ||
<tr> | <tr> | ||
| Line 67: | Line 61: | ||
<td></td> | <td></td> | ||
<td></td> | <td></td> | ||
| − | <td> | + | <td>Free-form text to describe the banner client.</td> |
| − | |||
| − | |||
</tr> | </tr> | ||
<tr> | <tr> | ||
Revision as of 07:06, 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. |