Name

Purpose

company

Used if you happen to have a Company level in your custom application. Can assign a CompanyID to a User, and therefore manage users by "Company".

websecurity_expired

Alpha Anywhere table to hold expired passwords. Important – do not alter this table.

websecurity_groups

Alpha Anywhere table to hold security groups. Important – do not alter this table.

websecurity_members

Alpha Anywhere table to hold "members" which is a record of each user and their assigned security

websecurity_users

Alpha Anywhere table to hold users who can login to the application. Important – do not alter this table.

wt_contact_log

Stores all contact messages submitted using the Contact Us form (the one with CAPTCHA).

wt_content

Holds all plain-text and HTML content so that it is available to insert into A5W pages.

wt_contentcat

Allows you to optionally define categories for your content such as News, HomePage, Articles.

wt_css_boxes

A list of CSS styles for "boxes"in the Framework. Boxes are the holding containers for all content and can have simple or complex formatting as defined by each Box Class. (Rarely used)

wt_email

Holds email "Templates" used as boilerplate email content for outgoing messages. For example, when a user registers, the contents of the email are stored in this table.

wt_email_log

A record of every email that is sent out of the Framework.

wt_image

A list of images typically in the images folder. Used exclusively for the Image Browser feature in the Content Areas module.

wt_image_group

Used to define groups (aka, 'categories') to assign to Images. Used exclusively for the Image Browser feature in the Content Areas module.

wt_logs

A list of logs that can be opened such as the log of users who login to the application.

wt_main_nav

Stores the menu nodes and instructions to generate navigation in the website.

wt_messages

Stores short messages that can be displayed on the website.

wt_pages

Holds page-specific information such as the Page Title, and meta keywords and descriptions for a given page.

wt_setup

Holds basic configuration settings for the entire web application.

wt_sitemap

Holds the names of pages that you want search engines to index. Useful to define virtual pages that take parameters in order to be found by search engines. For example products.a5w?id=101.

wt_sys_country

An editable list of all Countries used in dropdown selections in the application.

wt_sys_state_province

An editable list of all States/Provinces used in dropdown selections in the application.

wt_users

The list of users who can log in.

wt_users_addl

A child table to the wt_users table, stores additional information about the user.

wt_users_imp

A temporary holding table for bulk user import.

wt_variables

A list of session variables that will get populated when a user logs in. For example, defines that session.__protected__mygroups will get populated with a list of that users Security Groups.