PHP Classes

File: SQL File

Recommend this page to a friend!
  Packages of Matthew Asham   Binkterm PHP   database/migrations/v1.10.3_allow_null_tcp_port_dosbox_pid.sql   Download  
File: database/migrations/v1.10.3_allow_null_tcp_port_dosbox_pid.sql
Role: Auxiliary data
Content type: text/plain
Description: Auxiliary data
Class: Binkterm PHP
Bulletin board system based on the Web
Author: By
Last change:
Date: 5 days ago
Size: 541 bytes
 

Contents

Class file image Download 
-- Allow NULL for tcp_port and dosbox_pid since they're set by bridge after WebSocket connects
-- This supports the v3 architecture where PHP creates session record, bridge allocates port and launches DOSBox

ALTER TABLE door_sessions
ALTER COLUMN tcp_port DROP NOT NULL;

ALTER TABLE door_sessions
ALTER COLUMN dosbox_pid DROP NOT NULL;

COMMENT ON COLUMN door_sessions.tcp_port IS 'TCP port allocated by bridge (NULL until bridge allocates)';
COMMENT ON COLUMN door_sessions.dosbox_pid IS 'DOSBox process ID (NULL until bridge launches)';