12 lines
357 B
SQL
12 lines
357 B
SQL
-- Create voice_signals table for reliable signaling
|
|
CREATE TABLE IF NOT EXISTS voice_signals (
|
|
id INT AUTO_INCREMENT PRIMARY KEY,
|
|
room_id VARCHAR(50) NOT NULL,
|
|
from_peer_id VARCHAR(16) NOT NULL,
|
|
to_peer_id VARCHAR(16) NOT NULL,
|
|
data TEXT NOT NULL,
|
|
created_at_ms BIGINT NOT NULL,
|
|
INDEX (to_peer_id),
|
|
INDEX (created_at_ms)
|
|
);
|