|
|
(32 intermediate revisions by 4 users not shown) |
Line 1: |
Line 1: |
− | {{Update|text=These need sorting into decent categories. Key relationships need more complete annotation. Individual pages need high-level descriptions.}}
| + | An overview of what all the tables mean has been started at [[Database Table Overview]]. |
| | | |
− | * [[Database Table: acctcode]]
| + | {{Update|text=These three categories need work.}} |
− | * [[Database Table: actionhistory]]
| + | [[:Category:Database Table Needing Relationship Data]] |
− | * [[Database Table: active_user]]
| + | |
− | * [[Database Table: active_user_summary]]
| + | [[:Category:Database Tables Needing Description]] |
− | * [[Database Table: authactions]]
| + | |
− | * [[Database Table: backupdirty]]
| + | [[:Category:Database Tables To Check]] |
− | * [[Database Table: birthdays]]
| + | |
− | * [[Database Table: blobcache]]
| + | 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. |
− | * [[Database Table: blockwatch_events]]
| + | |
− | * [[Database Table: captcha_session]]
| + | == List of Database Tables == |
− | * [[Database Table: captchas]]
| + | {{#ask: [[Kind::Database Table]][[Name::+]] | format=count }} database tables. |
− | * [[Database Table: challenges]]
| + | |
− | * [[Database Table: clients]]
| + | === Global === |
− | * [[Database Table: clientusage]]
| + | |
− | * [[Database Table: clustermove]]
| + | ==== Individually Listed ==== |
− | * [[Database Table: clustermove_inprogress]]
| + | |
− | * [[Database Table: clustertrack2]]
| + | ==== Search Results ==== |
− | * [[Database Table: cmdbuffer]]
| + | {{#ask: [[Kind::Database Table]][[Name::+]][[Table type::global]] |
− | * [[Database Table: codes]]
| + | | ?Name |
− | * [[Database Table: comm_promo_list]]
| + | | ?Description |
− | * [[Database Table: commenturls]]
| + | | link=none |
− | * [[Database Table: comminterests]]
| + | | format=template |
− | * [[Database Table: community]]
| + | | template=SemanticDLList |
− | * [[Database Table: content_flag]]
| + | | limit=1000 |
− | * [[Database Table: counter]]
| + | }} |
− | * [[Database Table: cprod]]
| + | |
− | * [[Database Table: cprodlist]]
| + | === Clustered === |
− | * [[Database Table: dbinfo]]
| + | |
− | * [[Database Table: dbweights]]
| + | ==== Individually Listed ==== |
− | * [[Database Table: debug_notifymethod]]
| + | |
− | * [[Database Table: dirmogsethandles]]
| + | ==== Search Results ==== |
− | * [[Database Table: dirsearchres2]]
| + | {{#ask: [[Kind::Database Table]][[Name::+]][[Table type::clustered]] |
− | * [[Database Table: domains]]
| + | | ?Name |
− | * [[Database Table: dudata]]
| + | | ?Description |
− | * [[Database Table: duplock]]
| + | | link=none |
− | * [[Database Table: dw_paidstatus]]
| + | | format=template |
− | * [[Database Table: dw_payments]]
| + | | template=SemanticDLList |
− | * [[Database Table: dw_pp_details]]
| + | | limit=1000 |
− | * [[Database Table: dw_pp_log]]
| + | }} |
− | * [[Database Table: dw_pp_notify_log]]
| + | |
− | * [[Database Table: email]]
| + | === Other === |
− | * [[Database Table: embedcontent]]
| + | |
− | * [[Database Table: eventtypelist]]
| + | ==== Individually Listed ==== |
− | * [[Database Table: expunged_users]]
| + | |
− | * [[Database Table: extuser]]
| + | ==== Search Results ==== |
− | * [[Database Table: faq]]
| + | {{#ask: [[Kind::Database Table]][[Name::+]][[Table type::other]] |
− | * [[Database Table: faqcat]]
| + | | ?Name |
− | * [[Database Table: faquses]]
| + | | ?Description |
− | * [[Database Table: friendgroup2]]
| + | | link=none |
− | * [[Database Table: friends]]
| + | | format=template |
− | * [[Database Table: has_subs]]
| + | | template=SemanticDLList |
− | * [[Database Table: identitymap]]
| + | | limit=1000 |
− | * [[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: log2]]
| + | |
− | * [[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: talkleft]]
| + | |
− | * [[Database Table: talkprop2]]
| + | |
− | * [[Database Table: talkproplist]]
| + | |
− | * [[Database Table: talktext2]]
| + | |
− | * [[Database Table: tempanonips]]
| + | |
− | * [[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]] |
55 database tables.