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