Difference between revisions of "Database Tables"
From Dreamwidth Notes
m |
(→Other) |
||
| (10 intermediate revisions by 2 users not shown) | |||
| Line 1: | Line 1: | ||
An overview of what all the tables mean has been started at [[Database Table Overview]]. | An overview of what all the tables mean has been started at [[Database Table Overview]]. | ||
| − | {{Update|text=These | + | {{Update|text=These three categories need work.}} |
[[:Category:Database Table Needing Relationship Data]] | [[:Category:Database Table Needing Relationship Data]] | ||
| − | [[:Category: | + | [[:Category:Database Tables Needing Description]] |
| − | [[:Category: | + | [[: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 == | ||
| Line 12: | 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 22: | Line 28: | ||
=== Clustered === | === Clustered === | ||
| − | {{#ask: [[ | + | |
| + | ==== Individually Listed ==== | ||
| + | |||
| + | ==== Search Results ==== | ||
| + | {{#ask: [[Kind::Database Table]][[Name::+]][[Table type::clustered]] | ||
| ?Name | | ?Name | ||
| ?Description | | ?Description | ||
| Line 30: | Line 40: | ||
| limit=1000 | | limit=1000 | ||
}} | }} | ||
| + | |||
| + | === Other === | ||
| + | |||
| + | ==== Individually Listed ==== | ||
| + | |||
| + | ==== Search Results ==== | ||
| + | {{#ask: [[Kind::Database Table]][[Name::+]][[Table type::other]] | ||
| + | | ?Name | ||
| + | | ?Description | ||
| + | | link=none | ||
| + | | format=template | ||
| + | | template=SemanticDLList | ||
| + | | limit=1000 | ||
| + | }} | ||
| + | |||
| + | --- | ||
* [[:Category: Unused Database Tables]] | * [[:Category: Unused Database Tables]] | ||
* [[:Category: Obsolete Database Tables]] | * [[:Category: Obsolete Database Tables]] | ||
| + | * [[:Category: Removed Database Tables]] | ||
[[Category: Development]] | [[Category: Development]] | ||
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.
Contents
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.
---
