Maciej Pienczyn
a8f2178b7e
Some checks are pending
NordaBiz Tests / Unit & Integration Tests (push) Waiting to run
NordaBiz Tests / E2E Tests (Playwright) (push) Blocked by required conditions
NordaBiz Tests / Smoke Tests (Production) (push) Blocked by required conditions
NordaBiz Tests / Send Failure Notification (push) Blocked by required conditions
Add document management routes (upload, download, soft-delete) to board blueprint, link BoardDocument to BoardMeeting via meeting_id FK, add documents section to meeting view template, and include import scripts for meeting 2/2026 data and PDFs. Co-Authored-By: Claude Opus 4.6 <noreply@anthropic.com>
12 lines
420 B
SQL
12 lines
420 B
SQL
-- Migration 074: Add meeting_id FK to board_documents
|
|
-- Links documents directly to board_meetings for reliable associations
|
|
-- Date: 2026-02-20
|
|
|
|
ALTER TABLE board_documents
|
|
ADD COLUMN IF NOT EXISTS meeting_id INTEGER REFERENCES board_meetings(id);
|
|
|
|
CREATE INDEX IF NOT EXISTS idx_board_documents_meeting_id ON board_documents(meeting_id);
|
|
|
|
-- Grant permissions
|
|
GRANT ALL ON TABLE board_documents TO nordabiz_app;
|