Database
Database updates
On the https://hub.hubzilla.hu/admin/dbsync page, the administrator can check whether an update has failed and retry it if necessary. If an update has failed, but for some reason is not registered as failed, the administrator can try to run the update again. For example, for DB update #1999, by visiting the web page: https://hubzilla.com.bradmin/dbsync/1999
Database tables
| Table | Description |
|---|---|
| abconfig | any storage space for connections from local channels |
| abook | Connections of the 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 container for events |
| channel | local channels |
| chat | Chat room content |
| chatpresence | Channel presence information for the chat |
| chatroom | Data for the actual chat room |
| clients | OAuth usage |
| config | Main configuration storage |
| conv | Meta conversation structure for private messages in Diaspora |
| event | Events |
| pgrp_member | Data protection groups (collections), group information |
| pgrp | Data protection groups (collections), member information |
| hook | Plugin hook register |
| hubloc | xchan location storage, links a hub location with a xchan |
| iconfig | Expandable, arbitrary memory for elements |
| issue | Upcoming error/problem database |
| item | all articles and websites |
| item_id | (deprecated by iconfig) other identifiers in other services for contributions |
| likes | ‘Like‘ things |
| private messages | |
| menu | Website menu data |
| menu_item | Entries for menus on websites |
| notify | Notifications |
| obj | Object data for things (x has y) |
| outq | Outgoing queue |
| pconfig | Personal (per channel) configuration memory |
| photo | Photo store |
| poll | Data for polls |
| poll_elm | Data for poll elements |
| profdef | Definitions for user-defined profile fields |
| profext | User-defined profile field data |
| profile | Channel profiles |
| profile_check | DFRN remote authorisation, may be outdated |
| register | Registrations that require an administrative authorisation |
| session | Storage of web sessions |
| shares | Information on common elements |
| sign | Diaspora signatures. Is gradually being phased out. |
| site | Location table for finding directory peers |
| source | Data from channel sources |
| sys_perms | Extensible authorisations for OAuth |
| term | Article taxonomy table (categories, tags, etc.) |
| tokens | OAuth usage |
| updates | Directory synchronisation updates |
| verify | General verification structure |
| vote | Voting data for polls |
| xchan | List of known channels in the universe |
| xchat | Chat rooms with bookmarks |
| xconfig | like pconfig, but for channels without a local account |
| xign | Channels ignored by friend suggestions |
| xlink | ‘Friends of friends’ links derived from poco, also storage of ratings |
| xperm | OAuth/OpenID-Connect extendable authorisations Authorisation memory |
| xprof | if this node is a directory server, it contains basic public profile information about everyone on the network |
| xtag | if this hub is a directory server, it contains tags or interests from everyone on the network |