Difference between revisions of "Database Tables"

From Dreamwidth Notes
Jump to: navigation, search
m (Kind works better then Category)
(Other)
 
(6 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 two categories need work.}}
+
{{Update|text=These three categories need work.}}
 
[[:Category:Database Table Needing Relationship Data]]
 
[[:Category:Database Table Needing Relationship Data]]
  
[[:Category:Database_Tables_Needing_Description]]
+
[[:Category:Database Tables Needing Description]]
 +
 
 +
[[: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 10: 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 20: 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 30: 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
Line 43: Line 59:
 
* [[:Category: Unused Database Tables]]
 
* [[:Category: Unused Database Tables]]
 
* [[:Category: Obsolete Database Tables]]
 
* [[:Category: Obsolete Database Tables]]
 
+
* [[:Category: Removed Database Tables]]
[[Database_Table:_userblob]]
+
[[Database_Table:_userblobcache]]
+
  
 
[[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.

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.

---