80 lines
3.4 KiB
Markdown
80 lines
3.4 KiB
Markdown
# Database Schema
|
|
|
|
**Updated:** 2026-05-07 | **Total tables:** Unknown from files | **Engine:** MySQL/MariaDB via WordPress | **Charset:** Not available from files
|
|
|
|
---
|
|
|
|
## WordPress Core Schema
|
|
|
|
This repository does not include an authoritative live database dump or project-owned migration set. The site depends on the standard WordPress schema managed by WordPress core and plugins.
|
|
|
|
Expected core tables use the configured table prefix from `wp-config.php`:
|
|
|
|
| Table | Purpose | Source |
|
|
|-------|---------|--------|
|
|
| `wp_posts` | Pages, posts, Elementor documents, attachments, revisions | WordPress core |
|
|
| `wp_postmeta` | Post/page/Elementor metadata | WordPress core |
|
|
| `wp_options` | Site options, plugin settings, active theme/plugin state | WordPress core |
|
|
| `wp_users` | WordPress users | WordPress core |
|
|
| `wp_usermeta` | User metadata/capabilities | WordPress core |
|
|
| `wp_terms` | Terms/categories/tags | WordPress core |
|
|
| `wp_term_taxonomy` | Term taxonomy definitions | WordPress core |
|
|
| `wp_term_relationships` | Content-to-term relationships | WordPress core |
|
|
| `wp_comments` | Comments/submissions where applicable | WordPress core |
|
|
| `wp_commentmeta` | Comment metadata | WordPress core |
|
|
|
|
Elementor page layouts, form definitions, menus, options, and active plugin/theme state are database-resident and are not fully visible in this file tree.
|
|
|
|
---
|
|
|
|
## Elementor Pro Tables
|
|
|
|
Elementor Pro includes plugin-managed migrations for form submissions and notes.
|
|
|
|
**Form submissions** - lead/form submission storage
|
|
- Migration: `wp-content/plugins/elementor-pro/modules/forms/submissions/database/migrations/initial.php`.
|
|
- Creates submission, submission value, and form action log tables via WordPress `dbDelta`.
|
|
- Exact live table names depend on WordPress table prefix.
|
|
|
|
**Notes** - Elementor collaboration/notes features
|
|
- Migration: `wp-content/plugins/elementor-pro/modules/notes/database/migrations/initial.php`.
|
|
- Creates note-related custom tables via plugin migration infrastructure.
|
|
|
|
Other database migration/update infrastructure exists under:
|
|
- `wp-content/plugins/elementor/core/database`.
|
|
- `wp-content/plugins/elementor-pro/core/database`.
|
|
- `wp-content/plugins/elementor/modules/*/database`.
|
|
|
|
---
|
|
|
|
## Backup / Installer Database Logic
|
|
|
|
Duplicator Pro contains database packaging and installer logic, but this is restore tooling rather than the authoritative application schema.
|
|
|
|
Relevant paths:
|
|
- `wp-content/plugins/duplicator-pro-v4.5.16.2/classes`.
|
|
- `wp-content/plugins/duplicator-pro-v4.5.16.2/installer`.
|
|
- `wp-content/backups-dup-pro/`.
|
|
|
|
No extracted SQL dump was found during the scan.
|
|
|
|
---
|
|
|
|
## Schema Characteristics
|
|
|
|
| Property | Value |
|
|
|----------|-------|
|
|
| Engine | MySQL/MariaDB through WordPress |
|
|
| Charset | Not available from files |
|
|
| Encrypted columns | Not detected in project-owned schema |
|
|
| Soft deletes | Not detected in project-owned schema |
|
|
| Audit via JSON | Not detected in project-owned schema |
|
|
| Migrations | WordPress core/plugin-managed; no project-owned migration directory detected |
|
|
| Deferred indexes | Not documented |
|
|
| Table prefix | Configured in `wp-config.php`; value intentionally not repeated here |
|
|
|
|
## Verification Notes
|
|
|
|
- For planning that touches form submissions, leads, Elementor layouts, or page content, verify live schema/content via database access, WP-CLI, or WordPress admin.
|
|
- Do not rely on file tree alone for Elementor page structure or active form settings.
|