Difference between revisions of "Database Tables"

From Dreamwidth Notes
Jump to: navigation, search
(adding github link.)
(Other)
 
(2 intermediate revisions by the same user not shown)
Line 14: Line 14:
  
 
=== Global ===
 
=== Global ===
 +
 +
==== Individually Listed ====
 +
 +
==== Search Results ====
 
{{#ask: [[Kind::Database Table]][[Name::+]][[Table type::global]]  
 
{{#ask: [[Kind::Database Table]][[Name::+]][[Table type::global]]  
 
  | ?Name
 
  | ?Name
Line 24: Line 28:
  
 
=== Clustered ===
 
=== Clustered ===
 +
 +
==== Individually Listed ====
 +
 +
==== Search Results ====
 
{{#ask: [[Kind::Database Table]][[Name::+]][[Table type::clustered]]  
 
{{#ask: [[Kind::Database Table]][[Name::+]][[Table type::clustered]]  
 
  | ?Name
 
  | ?Name
Line 34: Line 42:
  
 
=== Other ===
 
=== Other ===
 +
 +
==== Individually Listed ====
 +
 +
==== Search Results ====
 
{{#ask: [[Kind::Database Table]][[Name::+]][[Table type::other]]  
 
{{#ask: [[Kind::Database Table]][[Name::+]][[Table type::other]]  
 
  | ?Name
 
  | ?Name

Latest revision as of 22:30, 18 July 2016

An overview of what all the tables mean has been started at Database Table Overview.

Needs Update: These three categories need work.
Category:Database Table Needing Relationship Data

Category:Database Tables Needing Description

Category:Database Tables To Check

The canonical current version of the database tables can be viewd at /bin/upgrading/update-db-general.pl. Search this file for the section you're interested in.

List of Database Tables

55 database tables.

Global

Individually Listed

Search Results

acctcode_promo
acctcode_request
captcha_cache
cc_log
cc_trans
email_aliases
external_site_moods
externaluserinfo
gco_log
gco_map
import_data
import_items
import_usermap
media_prop_list
openid_claims
pollproplist2
This table stores metadata of poll properties used.
pp_log
pp_tokens
pp_trans
renames
s2categories
shop_carts
shop_cmo
shop_codes
site_stats
sitekeywords
statkeylist
syndicated_hubbub2
tor_proxy_exits
users_for_paid_accounts
vgift_counts
vgift_ids
vgift_tagpriv
vgift_tags
wt_edges

Clustered

Individually Listed

Search Results

bannotes
birthdays
This is a table on the clustered database that stores information about upcoming birthdays.
collection_items
collections
content_filter_data
content_filters
dbnotes
embedcontent_preview
externalaccount
import_status
logprop_history
logslugs
media
media_props
media_versions
pollprop2
trust_groups
userblob
Ancient system for storing userpics. Used if MogileFS or BlobCache is not being run.
userpicmap3
Stores userpic keyword mappings.

Other

Individually Listed

Search Results

posts_raw
Table for sphinx to use.

---