Files
xxx-sphere-web/bin/main/db/migration/V4__lock_game_session_nullable.sql
Mario 34e5fcd777
Some checks failed
Host-Based Deploy (Java 21 Fix) / build-and-run (push) Has been cancelled
Weiter am Chastity Ingame gearbeitet
2026-04-27 17:41:00 +02:00

6 lines
281 B
SQL

-- session_id war fälschlicherweise PRIMARY KEY der lock_game-Tabelle.
-- Korrekter PK ist game_id (gemäß JPA-Entity @Id).
ALTER TABLE lock_game DROP PRIMARY KEY;
ALTER TABLE lock_game MODIFY COLUMN session_id VARCHAR(255) NULL;
ALTER TABLE lock_game ADD PRIMARY KEY (game_id);