CREATE TABLE IF NOT EXISTS dxbots_bot_claims (
  id INT AUTO_INCREMENT PRIMARY KEY,
  account_id INT NOT NULL,
  remaining INT NOT NULL DEFAULT 0,
  created_at TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP,
  updated_at TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  UNIQUE KEY uq_account_id (account_id),
  CONSTRAINT fk_bot_claim_account FOREIGN KEY (account_id) REFERENCES dxbots_accounts(id) ON DELETE CASCADE
);
