Files
OwnCord/Server/migrations/004_voice_optimization.sql
jevb fa1435e4de fix: address critical and high code review findings
- C-1: handle filepath.Abs error in backup path traversal guards
- C-2: WAL checkpoint before live DB restore to prevent corruption
- C-4: default AllowedOrigins to empty (deny cross-origin by default)
- C-5: renumber duplicate 003_ migration prefix (003-008 -> 003-009)
- H-1: sanitize FTS5 query input to prevent operator injection
- H-3: send SIGTERM for graceful shutdown before os.Exit in updater
- H-9: fix RingBuffer memory leak from unbounded backing array growth
- H-10: use errorResponse struct consistently in upload handler
2026-03-31 18:46:33 +02:00

10 lines
536 B
SQL

-- Phase 5b: Voice optimization — add camera/screenshare tracking and
-- per-channel voice configuration for the Pion SFU.
ALTER TABLE voice_states ADD COLUMN camera INTEGER NOT NULL DEFAULT 0;
ALTER TABLE voice_states ADD COLUMN screenshare INTEGER NOT NULL DEFAULT 0;
ALTER TABLE channels ADD COLUMN voice_max_users INTEGER NOT NULL DEFAULT 0;
ALTER TABLE channels ADD COLUMN voice_quality TEXT;
ALTER TABLE channels ADD COLUMN mixing_threshold INTEGER;
ALTER TABLE channels ADD COLUMN voice_max_video INTEGER NOT NULL DEFAULT 25;