User:Ladsgroup/Test

actor
The "actor" table associates user names or IP addresses with integers for the benefit of other tables that need to refer to either logged-in or logged-out users. If something can only ever be done by logged-in users, it can refer to the user table directly.

Primary Key:

bot_passwords
This table contains a user's bot passwords: passwords that allow access to the account via the API with limited rights.

Primary Key:

category
Track all existing categories. Something is a category if 1) it has an entry somewhere in categorylinks, or 2) it has a description page. Categories might not have corresponding pages, so they need to be tracked separately. The numbers of member pages (including categories and media), subcategories, and Image: namespace members, respectively are included in this table too. These are signed to make underflow more obvious. We make the first number include the second two for better sorting: subtracting for display is easy, adding for ordering is not.

Primary Key:

categorylinks
Track category inclusions *used inline* This tracks a single level of category membership

Primary Key:

change_tag
A table to track tags for revisions, logs and recent changes

Primary Key:

change_tag_def
Table defining tag names for IDs. Also stores hit counts to avoid expensive queries on change_tag

Primary Key:

comment
Edits, blocks, and other actions typically have a textual comment describing the action. They are stored here to reduce the size of the main tables, and to allow for deduplication. Deduplication is currently best-effort to avoid locking on inserts that would be required for strict deduplication. There MAY be multiple rows with the same comment_text and comment_data.

Primary Key:

content
The content table represents content objects. It's primary purpose is to provide the necessary meta-data for loading and interpreting a serialized data blob to create a content object.

Primary Key:

content_models
Normalization table for content model names

Primary Key:

externallinks
Track links to external URLs

Primary Key:

imagelinks
Track links to images *used inline* We don't distinguish live from broken links here, so they do not need to be changed on upload/removal.

Primary Key:

interwiki
Recognized interwiki link prefixes

Primary Key:

ip_changes
Every time an edit by a logged out user is saved, a row is created in ip_changes. This stores the IP as a hex representation so that we can more easily find edits within an IP range.

Primary Key:

ipblocks_restrictions
Partial Block Restrictions

Primary Key:

iwlinks
Track inline interwiki links

Primary Key:

job
Jobs performed by parallel apache threads or a command-line daemon

Primary Key:

l10n_cache
Table for storing localisation data

Primary Key:

langlinks
Track interlanguage links.

Primary Key:

log_search
Primary Key:

logging
Primary Key:

module_deps
Table caching which local files a module depends on that aren't registered directly, used for fast retrieval of file dependency. Currently only used for tracking images that CSS depends on

Primary Key:

page_props
Name/value pairs indexed by page_id

Primary Key:

page_restrictions
Used for storing page restrictions (i.e. protection levels)

Primary Key:

pagelinks
Track page-to-page hyperlinks within the wiki. The target page may or may not exist, and due to renames and deletions may refer to different page records as time goes by.

Primary Key:

protected_titles
Used for storing nonexistent pages that have been protected

Primary Key:

querycache
Used for caching expensive grouped queries

querycache_info
Details of updates to cached special pages

Primary Key:

querycachetwo
Used for caching expensive grouped queries that need two links (for example double-redirects)

redirect
For each redirect, this table contains exactly one row defining its target. Redirect targets are key to page_namespace/page_title of the target page. The target page may or may not exist, and due to renames and deletions may refer to different page records as time goes by.

Primary Key:

revision_actor_temp
Temporary table to avoid blocking on an alter of revision. On large wikis like the English Wikipedia, altering the revision table is a months-long process. This table is being created to avoid such an alter, and will be merged back into revision in the future

Primary Key:

revision_comment_temp
Temporary table to avoid blocking on an alter of revision. On large wikis like the English Wikipedia, altering the revision table is a months-long process. This table is being created to avoid such an alter, and will be merged back into revision in the future

Primary Key:

site_identifiers
Links local site identifiers to their corresponding site.

Primary Key:

site_stats
Contains a single row with some aggregate info on the state of the site.

Primary Key:

sites
Holds all the sites known to the wiki.

Primary Key:

slot_roles
Normalization table for role names

Primary Key:

slots
Slots represent an n:m relation between revisions and content objects. A content object can have a specific "role" in one or more revisions. Each revision can have multiple content objects, each having a different role.

Primary Key:

templatelinks
Track template inclusions. The target page may or may not exist, and due to renames and deletions may refer to different page records as time goes by.

Primary Key:

updatelog
A table to log updates, one text key row per update.

Primary Key:

uploadstash
Store information about newly uploaded files before they're moved into the actual filestore

Primary Key:

user_former_groups
Stores the groups the user has once belonged to. The user may still belong to these groups (check user_groups). Autopromotion of users to groups from which they were removed can be restricted by using wgAutopromoteOnce instead of wgAutopromote.

Primary Key:

user_groups
User permissions have been broken out to a separate table; this allows sites with a shared user table to have different permissions assigned to a user in each project. This table replaces the old user_rights field which used a comma-separated blob.

Primary Key:

user_newtalk
Stores notifications of user talk page changes, for the display of the 'you have new messages' box

user_properties
User preferences and perhaps other fun stuff. :) Replaces the old user.user_options blob, with a couple nice properties: 1) We only store non-default settings, so changes to the defaults are now reflected for everybody, not just new accounts. 2) We can more easily do bulk lookups, statistics, or modifications of saved options since it's a sane table structure.

Primary Key:

watchlist
Primary Key:

watchlist_expiry
Allows setting an expiry for watchlist items.

Primary Key: