Difference between revisions of "Database Tables"
From Dreamwidth Notes
Foxfirefey (Talk | contribs) (er, make a list of that) |
Foxfirefey (Talk | contribs) (removed unused and obsolete tables from the list, linked to categories instead) |
||
| Line 5: | Line 5: | ||
* [[Database Table: active_user]] | * [[Database Table: active_user]] | ||
* [[Database Table: active_user_summary]] | * [[Database Table: active_user_summary]] | ||
| − | |||
| − | |||
* [[Database Table: authactions]] | * [[Database Table: authactions]] | ||
* [[Database Table: backupdirty]] | * [[Database Table: backupdirty]] | ||
| Line 51: | Line 49: | ||
* [[Database Table: faqcat]] | * [[Database Table: faqcat]] | ||
* [[Database Table: faquses]] | * [[Database Table: faquses]] | ||
| − | |||
* [[Database Table: friendgroup2]] | * [[Database Table: friendgroup2]] | ||
* [[Database Table: friends]] | * [[Database Table: friends]] | ||
| Line 67: | Line 64: | ||
* [[Database Table: jabroster]] | * [[Database Table: jabroster]] | ||
* [[Database Table: jobstatus]] | * [[Database Table: jobstatus]] | ||
| − | |||
* [[Database Table: knob]] | * [[Database Table: knob]] | ||
* [[Database Table: links]] | * [[Database Table: links]] | ||
| Line 81: | Line 77: | ||
* [[Database Table: logtext2]] | * [[Database Table: logtext2]] | ||
* [[Database Table: meme]] | * [[Database Table: meme]] | ||
| − | |||
* [[Database Table: memkeyword2]] | * [[Database Table: memkeyword2]] | ||
| − | |||
* [[Database Table: memorable2]] | * [[Database Table: memorable2]] | ||
* [[Database Table: ml_domains]] | * [[Database Table: ml_domains]] | ||
| Line 97: | Line 91: | ||
* [[Database Table: moodthemes]] | * [[Database Table: moodthemes]] | ||
* [[Database Table: navtag]] | * [[Database Table: navtag]] | ||
| − | |||
* [[Database Table: noderefs]] | * [[Database Table: noderefs]] | ||
* [[Database Table: notifyarchive]] | * [[Database Table: notifyarchive]] | ||
| Line 103: | Line 96: | ||
* [[Database Table: notifyqueue]] | * [[Database Table: notifyqueue]] | ||
* [[Database Table: notifytypelist]] | * [[Database Table: notifytypelist]] | ||
| − | |||
* [[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: partialstats]] | * [[Database Table: partialstats]] | ||
* [[Database Table: partialstatsdata]] | * [[Database Table: partialstatsdata]] | ||
| Line 114: | Line 105: | ||
* [[Database Table: pendcomments]] | * [[Database Table: pendcomments]] | ||
* [[Database Table: persistent_queue]] | * [[Database Table: persistent_queue]] | ||
| − | |||
* [[Database Table: poll2]] | * [[Database Table: poll2]] | ||
| − | |||
* [[Database Table: pollitem2]] | * [[Database Table: pollitem2]] | ||
* [[Database Table: pollowner]] | * [[Database Table: pollowner]] | ||
| − | |||
* [[Database Table: pollquestion2]] | * [[Database Table: pollquestion2]] | ||
| − | |||
* [[Database Table: pollresult2]] | * [[Database Table: pollresult2]] | ||
| − | |||
* [[Database Table: pollsubmission2]] | * [[Database Table: pollsubmission2]] | ||
| − | |||
* [[Database Table: portal_box_prop]] | * [[Database Table: portal_box_prop]] | ||
* [[Database Table: portal_config]] | * [[Database Table: portal_config]] | ||
| Line 143: | Line 128: | ||
* [[Database Table: reluser]] | * [[Database Table: reluser]] | ||
* [[Database Table: reluser2]] | * [[Database Table: reluser2]] | ||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
* [[Database Table: s2checker]] | * [[Database Table: s2checker]] | ||
* [[Database Table: s2compiled]] | * [[Database Table: s2compiled]] | ||
| Line 153: | Line 133: | ||
* [[Database Table: s2info]] | * [[Database Table: s2info]] | ||
* [[Database Table: s2layers]] | * [[Database Table: s2layers]] | ||
| − | |||
* [[Database Table: s2source_inno]] | * [[Database Table: s2source_inno]] | ||
| − | |||
* [[Database Table: s2stylelayers2]] | * [[Database Table: s2stylelayers2]] | ||
* [[Database Table: s2styles]] | * [[Database Table: s2styles]] | ||
| Line 172: | Line 150: | ||
* [[Database Table: sessions_data]] | * [[Database Table: sessions_data]] | ||
* [[Database Table: site_messages]] | * [[Database Table: site_messages]] | ||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
* [[Database Table: spamreports]] | * [[Database Table: spamreports]] | ||
* [[Database Table: stats]] | * [[Database Table: stats]] | ||
* [[Database Table: statushistory]] | * [[Database Table: statushistory]] | ||
| − | |||
* [[Database Table: subs]] | * [[Database Table: subs]] | ||
* [[Database Table: subsprop]] | * [[Database Table: subsprop]] | ||
| Line 201: | Line 170: | ||
* [[Database Table: talk2]] | * [[Database Table: talk2]] | ||
* [[Database Table: talkleft]] | * [[Database Table: talkleft]] | ||
| − | |||
* [[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: underage]] | * [[Database Table: underage]] | ||
* [[Database Table: uniqmap]] | * [[Database Table: uniqmap]] | ||
| − | |||
* [[Database Table: user]] | * [[Database Table: user]] | ||
* [[Database Table: user_schools]] | * [[Database Table: user_schools]] | ||
* [[Database Table: userbio]] | * [[Database Table: userbio]] | ||
| − | |||
| − | |||
* [[Database Table: usercounter]] | * [[Database Table: usercounter]] | ||
* [[Database Table: useridmap]] | * [[Database Table: useridmap]] | ||
| Line 229: | Line 188: | ||
* [[Database Table: usermsgproplist]] | * [[Database Table: usermsgproplist]] | ||
* [[Database Table: usermsgtext]] | * [[Database Table: usermsgtext]] | ||
| − | |||
* [[Database Table: userpic2]] | * [[Database Table: userpic2]] | ||
* [[Database Table: userpicblob2]] | * [[Database Table: userpicblob2]] | ||
| − | |||
* [[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: userproplite2]] | * [[Database Table: userproplite2]] | ||
* [[Database Table: usersearch_packdata]] | * [[Database Table: usersearch_packdata]] | ||
| Line 243: | Line 199: | ||
* [[Database Table: usertrans]] | * [[Database Table: usertrans]] | ||
* [[Database Table: userusage]] | * [[Database Table: userusage]] | ||
| − | |||
| − | |||
| − | |||
| − | |||
* [[Database Table: weekuserusage]] | * [[Database Table: weekuserusage]] | ||
* [[Database Table: zip]] | * [[Database Table: zip]] | ||
| − | * [[Database | + | |
| + | * [[:Category: Unused Database Tables | ||
| + | * [[:Category: Obsolete Database Tables]] | ||
[[Category: Development]] | [[Category: Development]] | ||
Revision as of 06:09, 20 January 2009
Needs Update: These need sorting into decent categories. And then documenting and creating.
- Database Table: acctcode
- 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: codes
- Database Table: comm_promo_list
- Database Table: commenturls
- Database Table: comminterests
- Database Table: community
- Database Table: content_flag
- Database Table: counter
- 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: 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: 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: Obsolete Database Tables
