Phase 1-14 complete: - Unified Express.js API (TypeScript, Prisma ORM, PostgreSQL 16) - React Admin GUI (Vite + Ant Design + Zustand) - JWT auth with refresh tokens - Influence: Campaigns, Representatives, Responses, Email Queue - Map: Locations, Cuts, Shifts, Canvassing System - NAR data import infrastructure (2025 format) - Listmonk newsletter integration - Landing page builder (GrapesJS) - MkDocs + Code Server integration - Volunteer portal with GPS tracking - Monitoring stack (Prometheus, Grafana, Alertmanager) - Pangolin tunnel integration Co-Authored-By: Claude Sonnet 4.5 <noreply@anthropic.com>
9 lines
505 B
SQL
9 lines
505 B
SQL
-- AlterTable
|
|
ALTER TABLE "site_settings" ADD COLUMN IF NOT EXISTS "smtpHost" TEXT NOT NULL DEFAULT '',
|
|
ADD COLUMN IF NOT EXISTS "smtpPort" INTEGER NOT NULL DEFAULT 0,
|
|
ADD COLUMN IF NOT EXISTS "smtpUser" TEXT NOT NULL DEFAULT '',
|
|
ADD COLUMN IF NOT EXISTS "smtpPass" TEXT NOT NULL DEFAULT '',
|
|
ADD COLUMN IF NOT EXISTS "smtpFromAddress" TEXT NOT NULL DEFAULT '',
|
|
ADD COLUMN IF NOT EXISTS "emailTestMode" BOOLEAN NOT NULL DEFAULT true,
|
|
ADD COLUMN IF NOT EXISTS "testEmailRecipient" TEXT NOT NULL DEFAULT '';
|