Actions

Difference between revisions of "Tables/bannerclient"

From Joomla! Documentation

< Tables
(New page: <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 us...)
 
(Removing all content from page)
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