DROP TABLE rooms;

CREATE TABLE rooms (
	code INTEGER PRIMARY KEY,
	password TEXT,

	last_access INTEGER,

	player_max INTEGER,
	round_max INTEGER,
	timer_max INTEGER,
	game_mode INTEGER,
	
	player1_remote TEXT,
	player1_config TEXT,

	player2_remote TEXT,
	player2_config TEXT,

	player3_remote TEXT,
	player3_config TEXT,

	player4_remote TEXT,
	player4_config TEXT		
);