CREATE TABLE games (
  id INTEGER UNSIGNED NOT NULL PRIMARY KEY,
  unique_key VARCHAR(255) NOT NULL UNIQUE,
  admin_email VARCHAR(255) NOT NULL,
  name VARCHAR(255),
  money_limit INT UNSIGNED NOT NULL,
  status BOOLEAN NOT NULL DEFAULT true,
  created_at TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP,
  expired_at DATE NOT NULL
);

CREATE TABLE players (
  id INTEGER UNSIGNED NOT NULL PRIMARY KEY,
  game_id INTEGER UNSIGNED NOT NULL UNIQUE,
  email VARCHAR(255) NOT NULL,
  phone VARCHAR(255) NOT NULL,
  first_name VARCHAR(255) NOT NULL,
  last_name VARCHAR(255),
  wanted TEXT(65535) NOT NULL,
  unwanted TEXT(65535) NOT NULL,
  place VARCHAR(255)
);