Difference between revisions of "Database Tables"

From Dreamwidth Notes
Jump to: navigation, search
(adding github link.)
Line 7: Line 7:
  
 
[[:Category:Database Tables To Check]]
 
[[:Category:Database Tables To Check]]
 +
 +
The canonical current version of the database tables can be viewd at [https://github.com/dreamwidth/dw-free/blob/develop/bin/upgrading/update-db-general.pl /bin/upgrading/update-db-general.pl]. Search this file for the section you're interested in.
  
 
== List of Database Tables ==
 
== List of Database Tables ==

Revision as of 22:24, 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

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

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

posts_raw
Table for sphinx to use.

---