Tables/bannerclient
From Joomla! Documentation
< Tables(Difference between revisions)
|
|
| Line 1: |
Line 1: |
| − | <h2>Usage:</h2>
| |
| | | | |
| − | <dl>
| |
| − | <dt>Since:</dt>
| |
| − | <dd></dd>
| |
| − | </dl>
| |
| − |
| |
| − | <h2>Description:</h2>
| |
| − |
| |
| − | <p>
| |
| − | The banner_clients table contains information that identifies clients
| |
| − | for banner advertisements used in the mod_banners module.
| |
| − | </p>
| |
| − |
| |
| − | <table>
| |
| − | <caption>Table (#__banner_clients)</caption>
| |
| − | <tr>
| |
| − | <th>Field</th>
| |
| − | <th>Type</th>
| |
| − | <th>Nullable</th>
| |
| − | <th>Default</th>
| |
| − | <th>Key</th>
| |
| − | <th>Extra</th>
| |
| − | <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>
| |
| − |
| |
| − | <h2>Notes:</h2>
| |
| − |
| |
| − | <table>
| |
| − | <caption>Indices</caption>
| |
| − | <tr>
| |
| − | <th>Index Name</th>
| |
| − | <th>Column(s)</th>
| |
| − | <th>Unique?</th>
| |
| − | </tr>
| |
| − | <tr>
| |
| − | <td>idx_own_prefix </td>
| |
| − | <td>own_prefix </td>
| |
| − | <td>No</td>
| |
| − | </tr>
| |
| − | <tr>
| |
| − | <td>idx_metakey_prefix </td>
| |
| − | <td>metakey_prefix </td>
| |
| − | <td>No</td>
| |
| − | </tr>
| |
| − | </table>
| |
| − |
| |
| − | <dl>
| |
| − | <dt>Default character set: </dt>
| |
| − | <dd><b>utf8</b></dd>
| |
| − | </dl>
| |
Revision as of 06:54, 29 August 2010
