internal/store/migrations/0024_domain_verify.up.sql

1-- DNS-challenge verification for custom pages domains. Existing claims
2-- predate verification and stay serving: they are grandfathered verified.
3ALTER TABLE page_domains ADD COLUMN token TEXT NOT NULL DEFAULT '';
4ALTER TABLE page_domains ADD COLUMN user_id INTEGER NOT NULL DEFAULT 0;
5ALTER TABLE page_domains ADD COLUMN verified_at TEXT NOT NULL DEFAULT '';
6UPDATE page_domains SET verified_at = created_at WHERE verified_at = '';