Tables used in the Framework

Name

Purpose

company

Used if you happen to have a Company level in your custom application.

contact

Stores all contact messages via your Contact Us form (the one with CAPTCHA).

web_users

The list of users who can log in.

web_users_imp

A temporary holding table for bulk user import.

wt_content

Holds all content for all pages in the Framework.

wt_contentcat

Allows you to 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.

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_outbox

Holds emails that have been schedule to be sent either immediately or at a later date.

wt_logs

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

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.

websecurity_users

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

websecurity_expired

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

websecurity_groups

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

websecurity_members

Alpha Anywhere's official table to hold "members" which is a record of each user and their assigned security group(s). Important – do not alter this table.

wt_sys_state_province

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

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.

wt_work_queue

A generic "queue" for scheduled tasks.