Actions

Difference between revisions of "Tables/banner"

From Joomla! Documentation

< Tables
(class="wikitable")
m (categorisation)
 
Line 1: Line 1:
== Usage: ==
+
== Usage ==
 
* Since:
 
* Since:
  
== Description: ==
+
== Description ==
  
 
The Banners table contains banner advertisement content for the mod_banners module.
 
The Banners table contains banner advertisement content for the mod_banners module.
Line 70: Line 70:
 
|}
 
|}
  
== Notes: ==
+
== Notes ==
 
The following indexes are defined for use as alternate keys:
 
The following indexes are defined for use as alternate keys:
  
Line 90: Line 90:
  
 
Default character set: '''utf8'''.
 
Default character set: '''utf8'''.
 +
 +
<noinclude>[[Category:Database]]</noinclude>

Latest revision as of 10:36, 16 March 2013

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 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')

Notes

The following indexes are defined for use as alternate keys:

Indexes (#__banners)
Index Name Column(s)
idx_state state
idx_own_prefix own_prefix
idx_metakey_prefix metakey_prefix
idx_banner_catid catid
idx_language language

Default character set: utf8.