-- schema.sql - simplified example schema
CREATE TABLE users (
  id INT AUTO_INCREMENT PRIMARY KEY,
  telegram_id VARCHAR(64),
  username VARCHAR(64),
  first_name VARCHAR(128),
  is_premium TINYINT DEFAULT 0,
  stars_balance INT DEFAULT 0,
  created_at TIMESTAMP DEFAULT CURRENT_TIMESTAMP
);

CREATE TABLE matches (
  id INT AUTO_INCREMENT PRIMARY KEY,
  external_id VARCHAR(64),
  home_team VARCHAR(128),
  away_team VARCHAR(128),
  start_time DATETIME,
  status VARCHAR(32),
  created_at TIMESTAMP DEFAULT CURRENT_TIMESTAMP
);

-- notifications, subscriptions, payments, predictions, quests, points, withdrawals tables should be added here in production