Tables/banner: Difference between revisions

From Joomla! Documentation

< Tables
← Older editNewer edit →
Dsiders (talk | contribs)
87 edits
Initial content.
Dsiders (talk | contribs)
87 edits
Line 8: Line 8:


{| border=1
{| border=1
|+ '''Bannes Table (#__banners)'''
|+ '''Banners Table (#__banners)'''
|- bgcolor=grey
|- bgcolor=grey
! Field !! Type !! Null !! Key !! Default !! Extra !! Comments
! Field !! Type !! Nullable !! Key !! Default !! Extra !! Comments
|-
|-
| id                || INTEGER || Not Null || PK || || auto_increment || Identifier for the Banner entry
| id                || INTEGER || Not Null || PK || || auto_increment || Identifier for the Banner entry
Line 16: Line 16:
| cid              || INTEGER || Not Null || || 0 || || Banner Client ID (FK) references __banner_clients
| cid              || INTEGER || Not Null || || 0 || || Banner Client ID (FK) references __banner_clients
|-
|-
| type              || INTEGER      || Not Null  ||          || 0        ||          ||          
| type              || INTEGER      || Not Null  ||          || 0        ||          || Banner type identifier (FK)
|-
|-
| name              || VARCHAR(255)  || Not Null  ||          || ''        ||          ||  
| name              || VARCHAR(255)  || Not Null  ||          || ''        ||          || Name for the banner advertisement
|-
|-
| alias            || VARCHAR(255)  || Not Null  ||          || ''        ||          ||  
| alias            || VARCHAR(255)  || Not Null  ||          || ''        ||          || Alias for the banner advertisement
|-
|-
| imptotal          || INTEGER      || Not Null  ||          || '0'      ||          ||  
| imptotal          || INTEGER      || Not Null  ||          || '0'      ||          || Total impressions for the banner advertisement
|-
|-
| impmade          || INTEGER      || Not Null  ||          || '0'      ||          ||  
| impmade          || INTEGER      || Not Null  ||          || '0'      ||          || Impression made for the banner advertisement
|-
|-
| clicks            || INTEGER              || Not Null || || '0'  || ||  
| clicks            || INTEGER              || Not Null || || '0'  || || Number of clicks recorded for the banner advertisement
|-
|-
| clickurl          || VARCHAR(200)        || Not Null || || ''  || ||  
| clickurl          || VARCHAR(200)        || Not Null || || ''  || || URL to visit when the banner advertisement is clicked
|-
|-
| state            || TINYINT(3)          || Not Null || || '0'  || ||  
| state            || TINYINT(3)          || Not Null || || '0'  || || State
|-
|-
| catid            || UNSIGNED INTEGER    || Not Null || || 0    || ||  
| catid            || UNSIGNED INTEGER    || Not Null || || 0    || || Category ID (FK) references #__categories.id
|-
|-
| description      || TEXT                || Not Null || ||      || ||  
| description      || TEXT                || Not Null || ||      || || Brief description of the banner advertisement
|-
|-
| custombannercode  || VARCHAR(2048)        || Not Null || ||      || ||  
| custombannercode  || VARCHAR(2048)        || Not Null || ||      || || Code that represents the content for the banner advertisement
|-
|-
| sticky            || TINYINT(1) UNSIGNED  || Not Null || || 0    || ||  
| sticky            || TINYINT(1) UNSIGNED  || Not Null || || 0    || || Flag indicating the banner ad is ???
|-
|-
| ordering          || INTEGER              || Not Null || || 0    || ||  
| ordering          || INTEGER              || Not Null || || 0    || || The relative ordering of the banner ad
|-
|-
| metakey          || TEXT                || Not Null || ||      || ||  
| metakey          || TEXT                || Not Null || ||      || || The meta keywords for the item
|-
|-
| params            || TEXT                || Not Null || ||      || ||  
| params            || TEXT                || Not Null || ||      || || Parameters
|-
|-
| own_prefix        || TINYINT(1)          || Not Null || || '0'  || ||  
| own_prefix        || TINYINT(1)          || Not Null || || '0'  || || Flag indicating ???
|-
|-
| metakey_prefix    || VARCHAR(255)        || Not Null || || ''  || ||  
| metakey_prefix    || VARCHAR(255)        || Not Null || || ''  || || When matching metakey keywords, search only for this prefix
|-
|-
| purchase_type    || TINYINT              || Not Null || || '-1' || ||  
| purchase_type    || TINYINT              || Not Null || || '-1' || || Flag indicating the target URL is a purchase
|-
|-
| track_clicks      || TINYINT              || Not Null || || '-1' || ||  
| track_clicks      || TINYINT              || Not Null || || '-1' || || Flag indicating if clicks are tracked for the banner ad
|-
|-
| track_impressions || TINYINT              || Not Null || || '-1' || ||  
| track_impressions || TINYINT              || Not Null || || '-1' || || Flag indicating if impressions are track for the banner ad
|-
|-
| checked_out      || INTEGER UNSIGNED    || Not Null || || '0'  || ||  
| checked_out      || INTEGER UNSIGNED    || Not Null || || '0'  || || (FK) references #__users.id
|-
|-
| checked_out_time  || DATETIME            || Not Null || || '0000-00-00 00:00:00' || ||  
| 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' || ||  
| 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' || ||  
| 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' || ||  
| 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' || ||  
| created          || DATETIME            || Not Null || || '0000-00-00 00:00:00' || || Date/time the banner ad was created
|-
|-
| language          || char(7)              || Not Null || || ''  || ||  
| language          || char(7)              || Not Null || || ''  || || Language identifier (like 'en-GB')
|}
|}


== Notes: ==
== Notes: ==

Revision as of 08:16, 29 August 2010

Usage:

  • Since:

Description:

The Banners table contains banner advertisement content for the mod_banners module.

Banners Table (#__banners)
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 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')

Notes:

Retrieved from "https://docs.sandbox.joomla.org/index.php?title=Tables/banner&oldid=30247"