-- Remote desktop session table for VNC tunneled sessions
CREATE TABLE remote_sessions (
  id UUID PRIMARY KEY DEFAULT gen_random_uuid(),
  organization_id UUID NOT NULL REFERENCES organizations(id),
  device_id UUID NOT NULL REFERENCES devices(id),
  created_by_user_id UUID NOT NULL REFERENCES users(id),
  job_id UUID REFERENCES jobs(id),
  status VARCHAR(50) NOT NULL DEFAULT 'pending',
  vnc_port INTEGER NOT NULL DEFAULT 5900,
  vnc_password VARCHAR(64),
  error_message TEXT,
  started_at TIMESTAMP WITH TIME ZONE,
  ended_at TIMESTAMP WITH TIME ZONE,
  created_at TIMESTAMP WITH TIME ZONE NOT NULL DEFAULT NOW(),
  updated_at TIMESTAMP WITH TIME ZONE NOT NULL DEFAULT NOW()
);

CREATE INDEX idx_remote_sessions_org ON remote_sessions(organization_id);
CREATE INDEX idx_remote_sessions_device ON remote_sessions(device_id);
CREATE INDEX idx_remote_sessions_status ON remote_sessions(status);