Maciej Pienczyn
b187b0fc4a
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
- Migration 064 fixes 12 records in company_websites table missing https:// - Added ensure_url filter to w.url in contact bar template as safety net Co-Authored-By: Claude Opus 4.6 <noreply@anthropic.com>
10 lines
301 B
SQL
10 lines
301 B
SQL
-- Migration 064: Fix company_websites URLs missing https:// prefix
|
|
-- 12 records have URLs without http/https scheme, causing relative link issues
|
|
|
|
UPDATE company_websites
|
|
SET url = 'https://' || url
|
|
WHERE url IS NOT NULL
|
|
AND url != ''
|
|
AND url NOT LIKE 'http://%'
|
|
AND url NOT LIKE 'https://%';
|