Database

Intercessor stores its application data in dedicated WordPress database tables managed through the bundled BerlinDB integration.

Tables

The current plugin registers six tables:

1. requesters
2. prayer_requests
3. prayer_history
4. prayer_notes
5. prayed_counts
6. requester_notes

In a normal WordPress installation these are prefixed with the site's $wpdb->prefix and use the intercessor_ naming convention.

Installation and upgrades

Tables are registered during plugin initialization. On activation, Intercessor explicitly runs the table upgrade process so that the required tables exist before the remainder of activation completes.

Logical relationships

The registry installs parent tables before child tables. Prayer requests reference requester records, while history, notes, and prayed-count data are associated with requests. Requester notes belong to requester records.

Local storage

Prayer-request data is stored locally in the WordPress database. The optional Google reCAPTCHA integration is the documented external service used by the plugin.

WARNING

When developing extensions, use the plugin's query and row abstractions rather than writing ad-hoc SQL against table names whenever possible.