770f822fc6
- Added a new modal for reporting bugs, including fields for describing the issue and attaching optional files. - Integrated automatic screenshot capture functionality when the bug report modal is opened. - Created a new API endpoint for submitting bug reports, including validation and rate limiting. - Added database migration for tracking bug report submissions. - Updated frontend scripts to handle bug report submissions and display status messages. - Enhanced contact search functionality with improved error handling and backward compatibility. - Introduced a new button in the UI for accessing the bug report modal.
10 lines
436 B
SQL
10 lines
436 B
SQL
-- Migration 184: Add optional relation to existing global contacts on location contacts
|
|
-- Date: 2026-02-18
|
|
-- Purpose: Allow location contact rows to reference contacts.id for explicit linkage
|
|
|
|
ALTER TABLE locations_contacts
|
|
ADD COLUMN IF NOT EXISTS related_contact_id INTEGER REFERENCES contacts(id) ON DELETE SET NULL;
|
|
|
|
CREATE INDEX IF NOT EXISTS idx_locations_contacts_related_contact_id
|
|
ON locations_contacts(related_contact_id);
|