Difference between revisions of "Database Tables"
From Dreamwidth Notes
(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.
---
