Difference between revisions of "Tables/banner"
From Joomla! Documentation
< Tables
Line 22: | Line 22: | ||
| alias || VARCHAR(255) || Not Null || || '' || || Alias for the banner advertisement | | alias || VARCHAR(255) || Not Null || || '' || || Alias for the banner advertisement | ||
|- | |- | ||
− | | imptotal || INTEGER || Not Null || || | + | | imptotal || INTEGER || Not Null || || 0 || || Total impressions for the banner advertisement |
|- | |- | ||
− | | impmade || INTEGER || Not Null || || | + | | impmade || INTEGER || Not Null || || 0 || || Impression made for the banner advertisement |
|- | |- | ||
− | | clicks || INTEGER || Not Null || || | + | | clicks || INTEGER || Not Null || || 0 || || Number of clicks recorded for the banner advertisement |
|- | |- | ||
| clickurl || VARCHAR(200) || Not Null || || '' || || URL to visit when the banner advertisement is clicked | | clickurl || VARCHAR(200) || Not Null || || '' || || URL to visit when the banner advertisement is clicked | ||
|- | |- | ||
− | | state || TINYINT(3) || Not Null || || | + | | state || TINYINT(3) || Not Null || || 0 || || State |
|- | |- | ||
| catid || UNSIGNED INTEGER || Not Null || || 0 || || Category ID (FK) references #__categories.id | | catid || UNSIGNED INTEGER || Not Null || || 0 || || Category ID (FK) references #__categories.id | ||
Line 46: | Line 46: | ||
| params || TEXT || Not Null || || || || Parameters | | params || TEXT || Not Null || || || || Parameters | ||
|- | |- | ||
− | | own_prefix || TINYINT(1) || Not Null || || | + | | own_prefix || TINYINT(1) || Not Null || || 0 || || Flag indicating ??? |
|- | |- | ||
| metakey_prefix || VARCHAR(255) || Not Null || || '' || || When matching metakey keywords, search only for this prefix | | metakey_prefix || VARCHAR(255) || Not Null || || '' || || When matching metakey keywords, search only for this prefix | ||
|- | |- | ||
− | | purchase_type || TINYINT || Not Null || || | + | | purchase_type || TINYINT || Not Null || || -1 || || Flag indicating if the target URL is a purchase |
|- | |- | ||
− | | track_clicks || TINYINT || Not Null || || | + | | track_clicks || TINYINT || Not Null || || -1 || || Flag indicating if clicks are tracked for the banner ad |
|- | |- | ||
− | | track_impressions || TINYINT || Not Null || || | + | | track_impressions || TINYINT || Not Null || || -1 || || Flag indicating if impressions are track for the banner ad |
|- | |- | ||
− | | checked_out || INTEGER UNSIGNED || Not Null || || | + | | checked_out || INTEGER UNSIGNED || Not Null || || 0 || || (FK) references #__users.id |
|- | |- | ||
| checked_out_time || DATETIME || Not Null || || '0000-00-00 00:00:00' || || The time the item was checked out | | checked_out_time || DATETIME || Not Null || || '0000-00-00 00:00:00' || || The time the item was checked out |
Revision as of 03:17, 29 August 2010
Usage:[edit]
- Since:
Description:[edit]
The Banners table contains banner advertisement content for the mod_banners module.
Field | Type | Nullable | Key | Default | Extra | Comments |
---|---|---|---|---|---|---|
id | INTEGER | Not Null | PK | auto_increment | Identifier for the Banner entry | |
cid | INTEGER | Not Null | 0 | Banner Client ID (FK) references __banner_clients | ||
type | INTEGER | Not Null | 0 | Banner type identifier (FK) | ||
name | VARCHAR(255) | Not Null | Name for the banner advertisement | |||
alias | VARCHAR(255) | Not Null | Alias for the banner advertisement | |||
imptotal | INTEGER | Not Null | 0 | Total impressions for the banner advertisement | ||
impmade | INTEGER | Not Null | 0 | Impression made for the banner advertisement | ||
clicks | INTEGER | Not Null | 0 | Number of clicks recorded for the banner advertisement | ||
clickurl | VARCHAR(200) | Not Null | URL to visit when the banner advertisement is clicked | |||
state | TINYINT(3) | Not Null | 0 | State | ||
catid | UNSIGNED INTEGER | Not Null | 0 | Category ID (FK) references #__categories.id | ||
description | TEXT | Not Null | Brief description of the banner advertisement | |||
custombannercode | VARCHAR(2048) | Not Null | Code that represents the content for the banner advertisement | |||
sticky | TINYINT(1) UNSIGNED | Not Null | 0 | Flag indicating the banner ad is ??? | ||
ordering | INTEGER | Not Null | 0 | The relative ordering of the banner ad | ||
metakey | TEXT | Not Null | The meta keywords for the item | |||
params | TEXT | Not Null | Parameters | |||
own_prefix | TINYINT(1) | Not Null | 0 | Flag indicating ??? | ||
metakey_prefix | VARCHAR(255) | Not Null | When matching metakey keywords, search only for this prefix | |||
purchase_type | TINYINT | Not Null | -1 | Flag indicating if the target URL is a purchase | ||
track_clicks | TINYINT | Not Null | -1 | Flag indicating if clicks are tracked for the banner ad | ||
track_impressions | TINYINT | Not Null | -1 | Flag indicating if impressions are track for the banner ad | ||
checked_out | INTEGER UNSIGNED | Not Null | 0 | (FK) references #__users.id | ||
checked_out_time | DATETIME | Not Null | '0000-00-00 00:00:00' | The time the item was checked out | ||
publish_up | DATETIME | Not Null | '0000-00-00 00:00:00' | Date/time the banner ad is published | ||
publish_down | DATETIME | Not Null | '0000-00-00 00:00:00' | Date/time the banner ad is unpublished | ||
reset | DATETIME | Not Null | '0000-00-00 00:00:00' | Date/time the impressions and clicks were reset | ||
created | DATETIME | Not Null | '0000-00-00 00:00:00' | Date/time the banner ad was created | ||
language | char(7) | Not Null | Language identifier (like 'en-GB') |