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
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 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.
It contains the fields:
The address of the user who made the request
The name of the page requested, without its file extension
The user ID of the user making the request
The date and time of the request
The name of the Section to which the requested page belonged
The arguments of the user request
A miscellaneous field used for additional
information logged via
For performance reasons, the
authors_cache table contains information about all current
and past site Authors. The