Running Weblogs with Slash

Common Table Schemas

The following sections describe the basic groupings of tables. They do not include entity relationship diagrams or example create statements. These can be found in the docs/ and sql/ subdirectories, respectively. Because of the schema changes between versions, going into specific detail would render most of this information worthless. Consult the files provided with your specific version of Slash (including docs/slashtables.pod) for the latest information on the tables’ current relationships, entities, and attributes.

Access Log

access_log will be the largest table on busy sites. It keeps track of all hits to HTML, SHTML, and Perl files. Because of its size, only two days’ worth of content is ever kept. The purpose of this table is to create the nightly statistics and calculate the time when a user last used the system. It can also be used to create more detailed reports on site usage.^[58] It contains the fields:

host_addr

The address of the user who made the request

op

The name of the page requested, without its file extension

uid

The user ID of the user making the request

ts

The date and time of the request

section

The name of the Section to which the requested page belonged

query_string

The arguments of the user request

dat

A miscellaneous field used for additional information logged via writeLog

Authors Cache

For performance reasons, the authors_cache table contains information about all current and past site Authors. The refresh_authors_cache ...