CREATE TABLE api_sessions (
  id BIGINT UNSIGNED AUTO_INCREMENT PRIMARY KEY, user_id INT UNSIGNED NOT NULL,
  token_hash CHAR(64) NOT NULL UNIQUE, device VARCHAR(100) NULL,
  expires_at DATETIME NOT NULL, created_at DATETIME DEFAULT CURRENT_TIMESTAMP, INDEX(user_id)
) ENGINE=InnoDB;
ALTER TABLE recharges ADD client_ref VARCHAR(40) NULL, ADD UNIQUE KEY uq_user_ref (user_id, client_ref);
INSERT INTO settings (k,v,grp) VALUES ('callback_secret','CHANGE_ME_LONG_RANDOM','api'),('min_recharge','10','service'),('max_recharge','10000','service');
