< Tables(Difference between revisions)
|
|
| 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 07: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
|
