Difference between revisions of "Database Tables"

From Dreamwidth Notes
Jump to: navigation, search
(Other)
 
(18 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_Conversion]]
+
 
 +
[[: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 ==
 +
{{#ask: [[Kind::Database Table]][[Name::+]] | format=count }} database tables.
 +
 
=== Global ===
 
=== Global ===
{{#ask: [[Kind::Database Tables]][[Name::+]][[Clustered:false]]  
+
 
 +
==== Individually Listed ====
 +
 
 +
==== Search Results ====
 +
{{#ask: [[Kind::Database Table]][[Name::+]][[Table type::global]]  
 
  | ?Name
 
  | ?Name
 
  | ?Description
 
  | ?Description
Line 17: Line 28:
  
 
=== Clustered ===
 
=== Clustered ===
{{#ask: [[Kind::Database Tables]][[Name::+]][[Clustered:true]]  
+
 
 +
==== Individually Listed ====
 +
 
 +
==== Search Results ====
 +
{{#ask: [[Kind::Database Table]][[Name::+]][[Table type::clustered]]  
 
  | ?Name
 
  | ?Name
 
  | ?Description
 
  | ?Description
Line 26: Line 41:
 
}}
 
}}
  
==List of Database Tables (needing SMW) ==
+
=== Other ===
  
[[:Category:Database Table Needing Relationship Data]]
+
==== Individually Listed ====
  
 +
==== Search Results ====
 +
{{#ask: [[Kind::Database Table]][[Name::+]][[Table type::other]]
 +
| ?Name
 +
| ?Description
 +
| link=none
 +
| format=template
 +
| template=SemanticDLList
 +
| limit=1000
 +
}}
  
* [[Database Table: actionhistory]]
+
---
* [[Database Table: active_user]]
+
* [[Database Table: active_user_summary]]
+
* [[Database Table: authactions]]
+
* [[Database Table: backupdirty]]
+
* [[Database Table: birthdays]]
+
* [[Database Table: blobcache]]
+
* [[Database Table: blockwatch_events]]
+
* [[Database Table: captcha_session]]
+
* [[Database Table: captchas]]
+
* [[Database Table: challenges]]
+
* [[Database Table: clients]]
+
* [[Database Table: clientusage]]
+
* [[Database Table: clustermove]]
+
* [[Database Table: clustermove_inprogress]]
+
* [[Database Table: clustertrack2]]
+
* [[Database Table: cmdbuffer]]
+
* [[Database Table: comm_promo_list]]
+
* [[Database Table: commenturls]]
+
* [[Database Table: comminterests]]
+
* [[Database Table: community]]
+
* [[Database Table: content_flag]]
+
* [[Database Table: cprod]]
+
* [[Database Table: cprodlist]]
+
* [[Database Table: dbinfo]]
+
* [[Database Table: dbweights]]
+
* [[Database Table: debug_notifymethod]]
+
* [[Database Table: dirmogsethandles]]
+
* [[Database Table: dirsearchres2]]
+
* [[Database Table: domains]]
+
* [[Database Table: dudata]]
+
* [[Database Table: duplock]]
+
* [[Database Table: dw_paidstatus]]
+
* [[Database Table: dw_payments]]
+
* [[Database Table: dw_pp_details]]
+
* [[Database Table: dw_pp_log]]
+
* [[Database Table: dw_pp_notify_log]]
+
* [[Database Table: email]]
+
* [[Database Table: embedcontent]]
+
* [[Database Table: eventtypelist]]
+
* [[Database Table: expunged_users]]
+
* [[Database Table: extuser]]
+
* [[Database Table: faq]]
+
* [[Database Table: faqcat]]
+
* [[Database Table: faquses]]
+
* [[Database Table: friendgroup2]]
+
* [[Database Table: friends]]
+
* [[Database Table: has_subs]]
+
* [[Database Table: identitymap]]
+
* [[Database Table: includetext]]
+
* [[Database Table: incoming_email_handle]]
+
* [[Database Table: infohistory]]
+
* [[Database Table: interests]]
+
* [[Database Table: inviterecv]]
+
* [[Database Table: invitesent]]
+
* [[Database Table: jabcluster]]
+
* [[Database Table: jablastseen]]
+
* [[Database Table: jabpresence]]
+
* [[Database Table: jabroster]]
+
* [[Database Table: jobstatus]]
+
* [[Database Table: knob]]
+
* [[Database Table: links]]
+
* [[Database Table: loginlog]]
+
* [[Database Table: loginstall]]
+
* [[Database Table: logkwsum]]
+
* [[Database Table: logprop2]]
+
* [[Database Table: logproplist]]
+
* [[Database Table: logsec2]]
+
* [[Database Table: logtags]]
+
* [[Database Table: logtagsrecent]]
+
* [[Database Table: logtext2]]
+
* [[Database Table: meme]]
+
* [[Database Table: memkeyword2]]
+
* [[Database Table: memorable2]]
+
* [[Database Table: ml_domains]]
+
* [[Database Table: ml_items]]
+
* [[Database Table: ml_langdomains]]
+
* [[Database Table: ml_langs]]
+
* [[Database Table: ml_latest]]
+
* [[Database Table: ml_text]]
+
* [[Database Table: modblob]]
+
* [[Database Table: modlog]]
+
* [[Database Table: moods]]
+
* [[Database Table: moodthemedata]]
+
* [[Database Table: moodthemes]]
+
* [[Database Table: navtag]]
+
* [[Database Table: noderefs]]
+
* [[Database Table: notifyarchive]]
+
* [[Database Table: notifybookmarks]]
+
* [[Database Table: notifyqueue]]
+
* [[Database Table: notifytypelist]]
+
* [[Database Table: openid_endpoint]]
+
* [[Database Table: openid_external]]
+
* [[Database Table: openid_trust]]
+
* [[Database Table: openproxy]]
+
* [[Database Table: partialstats]]
+
* [[Database Table: partialstatsdata]]
+
* [[Database Table: password]]
+
* [[Database Table: pendcomments]]
+
* [[Database Table: persistent_queue]]
+
* [[Database Table: poll2]]
+
* [[Database Table: pollitem2]]
+
* [[Database Table: pollowner]]
+
* [[Database Table: pollquestion2]]
+
* [[Database Table: pollresult2]]
+
* [[Database Table: pollsubmission2]]
+
* [[Database Table: portal_box_prop]]
+
* [[Database Table: portal_config]]
+
* [[Database Table: portal_typemap]]
+
* [[Database Table: priv_list]]
+
* [[Database Table: priv_map]]
+
* [[Database Table: priv_packages]]
+
* [[Database Table: priv_packages_content]]
+
* [[Database Table: procnotify]]
+
* [[Database Table: qotd]]
+
* [[Database Table: random_user_set]]
+
* [[Database Table: rateabuse]]
+
* [[Database Table: ratelist]]
+
* [[Database Table: ratelog]]
+
* [[Database Table: readonly_user]]
+
* [[Database Table: recentactions]]
+
* [[Database Table: reluser]]
+
* [[Database Table: reluser2]]
+
* [[Database Table: s2checker]]
+
* [[Database Table: s2compiled]]
+
* [[Database Table: s2compiled2]]
+
* [[Database Table: s2info]]
+
* [[Database Table: s2layers]]
+
* [[Database Table: s2source_inno]]
+
* [[Database Table: s2stylelayers2]]
+
* [[Database Table: s2styles]]
+
* [[Database Table: sch_error]]
+
* [[Database Table: sch_exitstatus]]
+
* [[Database Table: sch_funcmap]]
+
* [[Database Table: sch_job]]
+
* [[Database Table: sch_note]]
+
* [[Database Table: schemacols]]
+
* [[Database Table: schematables]]
+
* [[Database Table: schools]]
+
* [[Database Table: schools_attended]]
+
* [[Database Table: schools_pending]]
+
* [[Database Table: secrets]]
+
* [[Database Table: sessions]]
+
* [[Database Table: sessions_data]]
+
* [[Database Table: site_messages]]
+
* [[Database Table: spamreports]]
+
* [[Database Table: stats]]
+
* [[Database Table: statushistory]]
+
* [[Database Table: subs]]
+
* [[Database Table: subsprop]]
+
* [[Database Table: subsproplist]]
+
* [[Database Table: support]]
+
* [[Database Table: support_answers]]
+
* [[Database Table: support_youreplied]]
+
* [[Database Table: supportcat]]
+
* [[Database Table: supportlog]]
+
* [[Database Table: supportnotify]]
+
* [[Database Table: supportpoints]]
+
* [[Database Table: supportpointsum]]
+
* [[Database Table: supportprop]]
+
* [[Database Table: syndicated]]
+
* [[Database Table: synitem]]
+
* [[Database Table: sysban]]
+
* [[Database Table: talk2]]
+
* [[Database Table: talkprop2]]
+
* [[Database Table: talkproplist]]
+
* [[Database Table: talktext2]]
+
* [[Database Table: tempanonips]]
+
* [[Database Table: txtmsg]]
+
* [[Database Table: underage]]
+
* [[Database Table: uniqmap]]
+
* [[Database Table: user]]
+
* [[Database Table: user_schools]]
+
* [[Database Table: userbio]]
+
* [[Database Table: usercounter]]
+
* [[Database Table: useridmap]]
+
* [[Database Table: userinterests]]
+
* [[Database Table: userkeywords]]
+
* [[Database Table: userlog]]
+
* [[Database Table: usermsg]]
+
* [[Database Table: usermsgprop]]
+
* [[Database Table: usermsgproplist]]
+
* [[Database Table: usermsgtext]]
+
* [[Database Table: userpic2]]
+
* [[Database Table: userpicblob2]]
+
* [[Database Table: userpicmap2]]
+
* [[Database Table: userprop]]
+
* [[Database Table: userpropblob]]
+
* [[Database Table: userproplist]]
+
* [[Database Table: userproplite]]
+
* [[Database Table: userproplite2]]
+
* [[Database Table: usersearch_packdata]]
+
* [[Database Table: usertags]]
+
* [[Database Table: usertrans]]
+
* [[Database Table: userusage]]
+
* [[Database Table: weekuserusage]]
+
* [[Database Table: zip]]
+
  
 
* [[: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.

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.

---