Difference between revisions of "Database Tables"

From Dreamwidth Notes
Jump to: navigation, search
(add a page linking to stubs about database tables)
 
(er, make a list of that)
Line 1: Line 1:
 
{{Update|text=These need sorting into decent categories.  And then documenting and creating.}}
 
{{Update|text=These need sorting into decent categories.  And then documenting and creating.}}
  
[[Database Table: acctcode]]
+
* [[Database Table: acctcode]]
[[Database Table: actionhistory]]
+
* [[Database Table: actionhistory]]
[[Database Table: active_user]]
+
* [[Database Table: active_user]]
[[Database Table: active_user_summary]]
+
* [[Database Table: active_user_summary]]
[[Database Table: adopt]]
+
* [[Database Table: adopt]]
[[Database Table: adoptlast]]
+
* [[Database Table: adoptlast]]
[[Database Table: authactions]]
+
* [[Database Table: authactions]]
[[Database Table: backupdirty]]
+
* [[Database Table: backupdirty]]
[[Database Table: birthdays]]
+
* [[Database Table: birthdays]]
[[Database Table: blobcache]]
+
* [[Database Table: blobcache]]
[[Database Table: blockwatch_events]]
+
* [[Database Table: blockwatch_events]]
[[Database Table: captcha_session]]
+
* [[Database Table: captcha_session]]
[[Database Table: captchas]]
+
* [[Database Table: captchas]]
[[Database Table: challenges]]
+
* [[Database Table: challenges]]
[[Database Table: clients]]
+
* [[Database Table: clients]]
[[Database Table: clientusage]]
+
* [[Database Table: clientusage]]
[[Database Table: clustermove]]
+
* [[Database Table: clustermove]]
[[Database Table: clustermove_inprogress]]
+
* [[Database Table: clustermove_inprogress]]
[[Database Table: clustertrack2]]
+
* [[Database Table: clustertrack2]]
[[Database Table: cmdbuffer]]
+
* [[Database Table: cmdbuffer]]
[[Database Table: codes]]
+
* [[Database Table: codes]]
[[Database Table: comm_promo_list]]
+
* [[Database Table: comm_promo_list]]
[[Database Table: commenturls]]
+
* [[Database Table: commenturls]]
[[Database Table: comminterests]]
+
* [[Database Table: comminterests]]
[[Database Table: community]]
+
* [[Database Table: community]]
[[Database Table: content_flag]]
+
* [[Database Table: content_flag]]
[[Database Table: counter]]
+
* [[Database Table: counter]]
[[Database Table: cprod]]
+
* [[Database Table: cprod]]
[[Database Table: cprodlist]]
+
* [[Database Table: cprodlist]]
[[Database Table: dbinfo]]
+
* [[Database Table: dbinfo]]
[[Database Table: dbweights]]
+
* [[Database Table: dbweights]]
[[Database Table: debug_notifymethod]]
+
* [[Database Table: debug_notifymethod]]
[[Database Table: dirmogsethandles]]
+
* [[Database Table: dirmogsethandles]]
[[Database Table: dirsearchres2]]
+
* [[Database Table: dirsearchres2]]
[[Database Table: domains]]
+
* [[Database Table: domains]]
[[Database Table: dudata]]
+
* [[Database Table: dudata]]
[[Database Table: duplock]]
+
* [[Database Table: duplock]]
[[Database Table: dw_paidstatus]]
+
* [[Database Table: dw_paidstatus]]
[[Database Table: dw_payments]]
+
* [[Database Table: dw_payments]]
[[Database Table: dw_pp_details]]
+
* [[Database Table: dw_pp_details]]
[[Database Table: dw_pp_log]]
+
* [[Database Table: dw_pp_log]]
[[Database Table: dw_pp_notify_log]]
+
* [[Database Table: dw_pp_notify_log]]
[[Database Table: email]]
+
* [[Database Table: email]]
[[Database Table: embedcontent]]
+
* [[Database Table: embedcontent]]
[[Database Table: eventtypelist]]
+
* [[Database Table: eventtypelist]]
[[Database Table: expunged_users]]
+
* [[Database Table: expunged_users]]
[[Database Table: extuser]]
+
* [[Database Table: extuser]]
[[Database Table: faq]]
+
* [[Database Table: faq]]
[[Database Table: faqcat]]
+
* [[Database Table: faqcat]]
[[Database Table: faquses]]
+
* [[Database Table: faquses]]
[[Database Table: friendgroup]]
+
* [[Database Table: friendgroup]]
[[Database Table: friendgroup2]]
+
* [[Database Table: friendgroup2]]
[[Database Table: friends]]
+
* [[Database Table: friends]]
[[Database Table: has_subs]]
+
* [[Database Table: has_subs]]
[[Database Table: identitymap]]
+
* [[Database Table: identitymap]]
[[Database Table: includetext]]
+
* [[Database Table: includetext]]
[[Database Table: incoming_email_handle]]
+
* [[Database Table: incoming_email_handle]]
[[Database Table: infohistory]]
+
* [[Database Table: infohistory]]
[[Database Table: interests]]
+
* [[Database Table: interests]]
[[Database Table: inviterecv]]
+
* [[Database Table: inviterecv]]
[[Database Table: invitesent]]
+
* [[Database Table: invitesent]]
[[Database Table: jabcluster]]
+
* [[Database Table: jabcluster]]
[[Database Table: jablastseen]]
+
* [[Database Table: jablastseen]]
[[Database Table: jabpresence]]
+
* [[Database Table: jabpresence]]
[[Database Table: jabroster]]
+
* [[Database Table: jabroster]]
[[Database Table: jobstatus]]
+
* [[Database Table: jobstatus]]
[[Database Table: keywords]]
+
* [[Database Table: keywords]]
[[Database Table: knob]]
+
* [[Database Table: knob]]
[[Database Table: links]]
+
* [[Database Table: links]]
[[Database Table: log2]]
+
* [[Database Table: log2]]
[[Database Table: loginlog]]
+
* [[Database Table: loginlog]]
[[Database Table: loginstall]]
+
* [[Database Table: loginstall]]
[[Database Table: logkwsum]]
+
* [[Database Table: logkwsum]]
[[Database Table: logprop2]]
+
* [[Database Table: logprop2]]
[[Database Table: logproplist]]
+
* [[Database Table: logproplist]]
[[Database Table: logsec2]]
+
* [[Database Table: logsec2]]
[[Database Table: logtags]]
+
* [[Database Table: logtags]]
[[Database Table: logtagsrecent]]
+
* [[Database Table: logtagsrecent]]
[[Database Table: logtext2]]
+
* [[Database Table: logtext2]]
[[Database Table: meme]]
+
* [[Database Table: meme]]
[[Database Table: memkeyword]]
+
* [[Database Table: memkeyword]]
[[Database Table: memkeyword2]]
+
* [[Database Table: memkeyword2]]
[[Database Table: memorable]]
+
* [[Database Table: memorable]]
[[Database Table: memorable2]]
+
* [[Database Table: memorable2]]
[[Database Table: ml_domains]]
+
* [[Database Table: ml_domains]]
[[Database Table: ml_items]]
+
* [[Database Table: ml_items]]
[[Database Table: ml_langdomains]]
+
* [[Database Table: ml_langdomains]]
[[Database Table: ml_langs]]
+
* [[Database Table: ml_langs]]
[[Database Table: ml_latest]]
+
* [[Database Table: ml_latest]]
[[Database Table: ml_text]]
+
* [[Database Table: ml_text]]
[[Database Table: modblob]]
+
* [[Database Table: modblob]]
[[Database Table: modlog]]
+
* [[Database Table: modlog]]
[[Database Table: moods]]
+
* [[Database Table: moods]]
[[Database Table: moodthemedata]]
+
* [[Database Table: moodthemedata]]
[[Database Table: moodthemes]]
+
* [[Database Table: moodthemes]]
[[Database Table: navtag]]
+
* [[Database Table: navtag]]
[[Database Table: news_sent]]
+
* [[Database Table: news_sent]]
[[Database Table: noderefs]]
+
* [[Database Table: noderefs]]
[[Database Table: notifyarchive]]
+
* [[Database Table: notifyarchive]]
[[Database Table: notifybookmarks]]
+
* [[Database Table: notifybookmarks]]
[[Database Table: notifyqueue]]
+
* [[Database Table: notifyqueue]]
[[Database Table: notifytypelist]]
+
* [[Database Table: notifytypelist]]
[[Database Table: oldids]]
+
* [[Database Table: oldids]]
[[Database Table: openid_endpoint]]
+
* [[Database Table: openid_endpoint]]
[[Database Table: openid_external]]
+
* [[Database Table: openid_external]]
[[Database Table: openid_trust]]
+
* [[Database Table: openid_trust]]
[[Database Table: openproxy]]
+
* [[Database Table: openproxy]]
[[Database Table: overrides]]
+
* [[Database Table: overrides]]
[[Database Table: partialstats]]
+
* [[Database Table: partialstats]]
[[Database Table: partialstatsdata]]
+
* [[Database Table: partialstatsdata]]
[[Database Table: password]]
+
* [[Database Table: password]]
[[Database Table: pendcomments]]
+
* [[Database Table: pendcomments]]
[[Database Table: persistent_queue]]
+
* [[Database Table: persistent_queue]]
[[Database Table: poll]]
+
* [[Database Table: poll]]
[[Database Table: poll2]]
+
* [[Database Table: poll2]]
[[Database Table: pollitem]]
+
* [[Database Table: pollitem]]
[[Database Table: pollitem2]]
+
* [[Database Table: pollitem2]]
[[Database Table: pollowner]]
+
* [[Database Table: pollowner]]
[[Database Table: pollquestion]]
+
* [[Database Table: pollquestion]]
[[Database Table: pollquestion2]]
+
* [[Database Table: pollquestion2]]
[[Database Table: pollresult]]
+
* [[Database Table: pollresult]]
[[Database Table: pollresult2]]
+
* [[Database Table: pollresult2]]
[[Database Table: pollsubmission]]
+
* [[Database Table: pollsubmission]]
[[Database Table: pollsubmission2]]
+
* [[Database Table: pollsubmission2]]
[[Database Table: portal]]
+
* [[Database Table: portal]]
[[Database Table: portal_box_prop]]
+
* [[Database Table: portal_box_prop]]
[[Database Table: portal_config]]
+
* [[Database Table: portal_config]]
[[Database Table: portal_typemap]]
+
* [[Database Table: portal_typemap]]
[[Database Table: priv_list]]
+
* [[Database Table: priv_list]]
[[Database Table: priv_map]]
+
* [[Database Table: priv_map]]
[[Database Table: priv_packages]]
+
* [[Database Table: priv_packages]]
[[Database Table: priv_packages_content]]
+
* [[Database Table: priv_packages_content]]
[[Database Table: procnotify]]
+
* [[Database Table: procnotify]]
[[Database Table: qotd]]
+
* [[Database Table: qotd]]
[[Database Table: random_user_set]]
+
* [[Database Table: random_user_set]]
[[Database Table: rateabuse]]
+
* [[Database Table: rateabuse]]
[[Database Table: ratelist]]
+
* [[Database Table: ratelist]]
[[Database Table: ratelog]]
+
* [[Database Table: ratelog]]
[[Database Table: readonly_user]]
+
* [[Database Table: readonly_user]]
[[Database Table: recentactions]]
+
* [[Database Table: recentactions]]
[[Database Table: reluser]]
+
* [[Database Table: reluser]]
[[Database Table: reluser2]]
+
* [[Database Table: reluser2]]
[[Database Table: s1overrides]]
+
* [[Database Table: s1overrides]]
[[Database Table: s1style]]
+
* [[Database Table: s1style]]
[[Database Table: s1stylecache]]
+
* [[Database Table: s1stylecache]]
[[Database Table: s1stylemap]]
+
* [[Database Table: s1stylemap]]
[[Database Table: s1usercache]]
+
* [[Database Table: s1usercache]]
[[Database Table: s2checker]]
+
* [[Database Table: s2checker]]
[[Database Table: s2compiled]]
+
* [[Database Table: s2compiled]]
[[Database Table: s2compiled2]]
+
* [[Database Table: s2compiled2]]
[[Database Table: s2info]]
+
* [[Database Table: s2info]]
[[Database Table: s2layers]]
+
* [[Database Table: s2layers]]
[[Database Table: s2source]]
+
* [[Database Table: s2source]]
[[Database Table: s2source_inno]]
+
* [[Database Table: s2source_inno]]
[[Database Table: s2stylelayers]]
+
* [[Database Table: s2stylelayers]]
[[Database Table: s2stylelayers2]]
+
* [[Database Table: s2stylelayers2]]
[[Database Table: s2styles]]
+
* [[Database Table: s2styles]]
[[Database Table: sch_error]]
+
* [[Database Table: sch_error]]
[[Database Table: sch_exitstatus]]
+
* [[Database Table: sch_exitstatus]]
[[Database Table: sch_funcmap]]
+
* [[Database Table: sch_funcmap]]
[[Database Table: sch_job]]
+
* [[Database Table: sch_job]]
[[Database Table: sch_note]]
+
* [[Database Table: sch_note]]
[[Database Table: schemacols]]
+
* [[Database Table: schemacols]]
[[Database Table: schematables]]
+
* [[Database Table: schematables]]
[[Database Table: schools]]
+
* [[Database Table: schools]]
[[Database Table: schools_attended]]
+
* [[Database Table: schools_attended]]
[[Database Table: schools_pending]]
+
* [[Database Table: schools_pending]]
[[Database Table: secrets]]
+
* [[Database Table: secrets]]
[[Database Table: sessions]]
+
* [[Database Table: sessions]]
[[Database Table: sessions_data]]
+
* [[Database Table: sessions_data]]
[[Database Table: site_messages]]
+
* [[Database Table: site_messages]]
[[Database Table: sms_msg]]
+
* [[Database Table: sms_msg]]
[[Database Table: sms_msgack]]
+
* [[Database Table: sms_msgack]]
[[Database Table: sms_msgerror]]
+
* [[Database Table: sms_msgerror]]
[[Database Table: sms_msgprop]]
+
* [[Database Table: sms_msgprop]]
[[Database Table: sms_msgproplist]]
+
* [[Database Table: sms_msgproplist]]
[[Database Table: sms_msgtext]]
+
* [[Database Table: sms_msgtext]]
[[Database Table: smsuniqmap]]
+
* [[Database Table: smsuniqmap]]
[[Database Table: smsusermap]]
+
* [[Database Table: smsusermap]]
[[Database Table: spamreports]]
+
* [[Database Table: spamreports]]
[[Database Table: stats]]
+
* [[Database Table: stats]]
[[Database Table: statushistory]]
+
* [[Database Table: statushistory]]
[[Database Table: style]]
+
* [[Database Table: style]]
[[Database Table: subs]]
+
* [[Database Table: subs]]
[[Database Table: subsprop]]
+
* [[Database Table: subsprop]]
[[Database Table: subsproplist]]
+
* [[Database Table: subsproplist]]
[[Database Table: support]]
+
* [[Database Table: support]]
[[Database Table: support_answers]]
+
* [[Database Table: support_answers]]
[[Database Table: support_youreplied]]
+
* [[Database Table: support_youreplied]]
[[Database Table: supportcat]]
+
* [[Database Table: supportcat]]
[[Database Table: supportlog]]
+
* [[Database Table: supportlog]]
[[Database Table: supportnotify]]
+
* [[Database Table: supportnotify]]
[[Database Table: supportpoints]]
+
* [[Database Table: supportpoints]]
[[Database Table: supportpointsum]]
+
* [[Database Table: supportpointsum]]
[[Database Table: supportprop]]
+
* [[Database Table: supportprop]]
[[Database Table: syndicated]]
+
* [[Database Table: syndicated]]
[[Database Table: synitem]]
+
* [[Database Table: synitem]]
[[Database Table: sysban]]
+
* [[Database Table: sysban]]
[[Database Table: talk2]]
+
* [[Database Table: talk2]]
[[Database Table: talkleft]]
+
* [[Database Table: talkleft]]
[[Database Table: talkleft_xfp]]
+
* [[Database Table: talkleft_xfp]]
[[Database Table: talkprop2]]
+
* [[Database Table: talkprop2]]
[[Database Table: talkproplist]]
+
* [[Database Table: talkproplist]]
[[Database Table: talktext2]]
+
* [[Database Table: talktext2]]
[[Database Table: tempanonips]]
+
* [[Database Table: tempanonips]]
[[Database Table: themedata]]
+
* [[Database Table: themedata]]
[[Database Table: themelist]]
+
* [[Database Table: themelist]]
[[Database Table: todo]]
+
* [[Database Table: todo]]
[[Database Table: tododep]]
+
* [[Database Table: tododep]]
[[Database Table: todokeyword]]
+
* [[Database Table: todokeyword]]
[[Database Table: txtmsg]]
+
* [[Database Table: txtmsg]]
[[Database Table: underage]]
+
* [[Database Table: underage]]
[[Database Table: uniqmap]]
+
* [[Database Table: uniqmap]]
[[Database Table: urimap]]
+
* [[Database Table: urimap]]
[[Database Table: user]]
+
* [[Database Table: user]]
[[Database Table: user_schools]]
+
* [[Database Table: user_schools]]
[[Database Table: userbio]]
+
* [[Database Table: userbio]]
[[Database Table: userblob]]
+
* [[Database Table: userblob]]
[[Database Table: userblobcache]]
+
* [[Database Table: userblobcache]]
[[Database Table: usercounter]]
+
* [[Database Table: usercounter]]
[[Database Table: useridmap]]
+
* [[Database Table: useridmap]]
[[Database Table: userinterests]]
+
* [[Database Table: userinterests]]
[[Database Table: userkeywords]]
+
* [[Database Table: userkeywords]]
[[Database Table: userlog]]
+
* [[Database Table: userlog]]
[[Database Table: usermsg]]
+
* [[Database Table: usermsg]]
[[Database Table: usermsgprop]]
+
* [[Database Table: usermsgprop]]
[[Database Table: usermsgproplist]]
+
* [[Database Table: usermsgproplist]]
[[Database Table: usermsgtext]]
+
* [[Database Table: usermsgtext]]
[[Database Table: userpic]]
+
* [[Database Table: userpic]]
[[Database Table: userpic2]]
+
* [[Database Table: userpic2]]
[[Database Table: userpicblob2]]
+
* [[Database Table: userpicblob2]]
[[Database Table: userpicmap]]
+
* [[Database Table: userpicmap]]
[[Database Table: userpicmap2]]
+
* [[Database Table: userpicmap2]]
[[Database Table: userprop]]
+
* [[Database Table: userprop]]
[[Database Table: userpropblob]]
+
* [[Database Table: userpropblob]]
[[Database Table: userproplist]]
+
* [[Database Table: userproplist]]
[[Database Table: userproplite]]
+
* [[Database Table: userproplite]]
[[Database Table: userproplite2]]
+
* [[Database Table: userproplite2]]
[[Database Table: usersearch_packdata]]
+
* [[Database Table: usersearch_packdata]]
[[Database Table: usertags]]
+
* [[Database Table: usertags]]
[[Database Table: usertrans]]
+
* [[Database Table: usertrans]]
[[Database Table: userusage]]
+
* [[Database Table: userusage]]
[[Database Table: vertical]]
+
* [[Database Table: vertical]]
[[Database Table: vertical_editorials]]
+
* [[Database Table: vertical_editorials]]
[[Database Table: vertical_entries]]
+
* [[Database Table: vertical_entries]]
[[Database Table: vertical_rules]]
+
* [[Database Table: vertical_rules]]
[[Database Table: weekuserusage]]
+
* [[Database Table: weekuserusage]]
[[Database Table: zip]]
+
* [[Database Table: zip]]
[[Database Table: zips]]
+
* [[Database Table: zips]]
  
 
[[Category: Development]]
 
[[Category: Development]]

Revision as of 22:44, 19 January 2009

Needs Update: These need sorting into decent categories. And then documenting and creating.