-- Upgrade existing installation to the single Teen Patti game mode.
-- Stop the previous application before running migrations; do not strand live rounds.
UPDATE rooms SET closed=true WHERE mode<>'teen-patti' AND NOT closed;
ALTER TABLE rooms DROP CONSTRAINT IF EXISTS rooms_mode_check;
ALTER TABLE rooms ADD CONSTRAINT rooms_mode_check CHECK (mode='teen-patti');