Contents

Database updates

In the /admin/dbsync page the administrator can check if any update was not successful and, if so, retry it.

If an update has failed but doesn't register as failed for some reason, the administrator can attempt to re-execute the update. For example for DB update #1999, by visiting the webpage:

https://hubzilla.com.bradmin/dbsync/1999

Database Tables

Table	Description
abconfig	arbitrary storage for connections of local channels
abook	connections of local channels
account	service provider account
addon	registered plugins
app	personal app data
attach	file attachments
auth_codes	OAuth usage
cache	OEmbed cache
cal	CalDAV containers for events
channel	local channels
chat	chat room content
chatpresence	channel presence information for chat
chatroom	data for the actual chat room
clients	OAuth usage
config	main configuration storage
conv	Diaspora private messages meta conversation structure
event	Events
pgrp_member	privacy groups (collections), group info
pgrp	privacy groups (collections), member info
hook	plugin hook registry
hubloc	xchan location storage, ties a hub location to an xchan
iconfig	extensible arbitrary storage for items
issue	future bug/issue database
item	all posts and webpages
item_id	(deprecated by iconfig) other identifiers on other services for posts
likes	likes of 'things'
mail	private messages
menu	webpage menu data
menu_item	entries for webpage menus
notify	notifications
obj	object data for things (x has y)
outq	output queue
pconfig	personal (per channel) configuration storage
photo	photo storage
poll	data for polls
poll_elm	data for poll elements
profdef	custom profile field definitions
profext	custom profile field data
profile	channel profiles
profile_check	DFRN remote auth use, may be obsolete
register	registrations requiring admin approval
session	web session storage
shares	shared item information
sign	Diaspora signatures.  To be phased out.
site	site table to find directory peers
source	channel sources data
sys_perms	extensible permissions for OAuth
term	item taxonomy (categories, tags, etc.) table
tokens	OAuth usage
updates	directory sync updates
verify	general purpose verification structure
vote	vote data for polls
xchan	list of known channels in the universe
xchat	bookmarked chat rooms
xconfig	as pconfig but for channels with no local account
xign	channels ignored by friend suggestions
xlink	"friends of friends" linkages derived from poco, also ratings storage
xperm	OAuth/OpenID-Connect extensible permissions permissions storage
xprof	if this hub is a directory server, contains basic public profile info of everybody in the network
xtag	if this hub is a directory server, contains tags or interests of everybody in the network