Verify the Delivery Note database installation
Confirm the two module tables, indexes and installed options required by the code. The guide then takes you through the correct route, the checks to complete before making changes, the workflow in order, and the evidence to review afterwards.
Where to goServer database administration → Britixo CRM database → Inspect module-owned tables
What you’ll accomplish
Confirm the two module tables, indexes and installed options required by the code. This guide follows the supplied Delivery Note module’s live hooks, controller actions, model rules, views and stored side effects.
Follow these steps
- Verify the prefixed `delivery_notes` table exists.
- Verify the prefixed `delivery_note_events` table exists.
- Check unique indexes on `reference` and `secure_token`.
- Check invoice, client and status indexes.
- Check the installed Delivery Note options before functional testing.
Fields and options to review
- Delivery notes table stores invoice/client IDs, reference, token, statuses, snapshots, delivery details and signing evidence.
- Events table stores event type/message, IP, user agent, JSON metadata, actor and time.
- Options include enabled, reference prefix, routes, route mode, schema version, invoice UI flag and PDF footer text.
Rules the system enforces
- Table names use the CRM database prefix.
- The installer is idempotent for existing tables/options.
- `signed_by_name`, `signed_by_email` and `locked_at` exist in the schema but are not populated by the supplied signing flow.
How to confirm it worked
- Activation has produced the complete portable schema expected by the controllers and model.
Safety checks and troubleshooting
- Do not document or use migration scaffolding as a user workflow; this module installs through `install.php`.
Stay within the supported flowDo not force database values, expose secure tokens, bypass permission checks, replace a stored signature or invent a status or interface that the supplied code does not implement.
Continue with related guidance
Was this guide useful?Your response is stored only in this browser.