Tables/bannerclient
From Joomla! Documentation
< Tables(Difference between revisions)
(→Description:) |
(class="wikitable") |
||
| (5 intermediate revisions by one user not shown) | |||
| Line 5: | Line 5: | ||
The banner_clients table contains information that identifies clients for banner advertisements used in the mod_banners module. | The banner_clients table contains information that identifies clients for banner advertisements used in the mod_banners module. | ||
| − | <table border="1"> | + | <table class="wikitable" border="1"> |
| − | <caption>Table (#__banner_clients)</caption> | + | <caption>'''banner_clients Table (#__banner_clients)'''</caption> |
<tr> | <tr> | ||
<th>Field</th> | <th>Field</th> | ||
| Line 68: | Line 68: | ||
<td></td> | <td></td> | ||
<td></td> | <td></td> | ||
| − | <td> | + | <td>State for the banner client.</td> |
| − | + | ||
| − | + | ||
</tr> | </tr> | ||
<tr> | <tr> | ||
| Line 148: | Line 146: | ||
== Notes: == | == Notes: == | ||
| − | <table> | + | <table class="wikitable" border="1"> |
| − | <caption>Indices</caption> | + | <caption>'''Indices'''</caption> |
<tr> | <tr> | ||
<th>Index Name</th> | <th>Index Name</th> | ||
Revision as of 22:13, 24 September 2011
Usage:
- Since:
Description:
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:
| Index Name | Column(s) | Unique? |
|---|---|---|
| idx_own_prefix | own_prefix | No |
| idx_metakey_prefix | metakey_prefix | No |
- Default character set: utf8
