11 lines
447 B
SQL
11 lines
447 B
SQL
-- Bomber Rooms MVP schema (idempotent)
|
|
CREATE TABLE IF NOT EXISTS rooms (
|
|
id INT AUTO_INCREMENT PRIMARY KEY,
|
|
name VARCHAR(120) NOT NULL,
|
|
status VARCHAR(32) NOT NULL DEFAULT 'waiting',
|
|
max_players INT NOT NULL DEFAULT 4,
|
|
state_json LONGTEXT NOT NULL,
|
|
created_at TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP,
|
|
updated_at TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP
|
|
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;
|