
CREATE TABLE user_data (
  id INT AUTO_INCREMENT PRIMARY KEY,
  user_agent TEXT,
  platform VARCHAR(255),
  language VARCHAR(10),
  languages TEXT,
  cookie_enabled BOOLEAN,
  do_not_track VARCHAR(10),
  screen_width INT,
  screen_height INT,
  screen_avail_width INT,
  screen_avail_height INT,
  screen_color_depth INT,
  screen_pixel_ratio FLOAT,
  timezone VARCHAR(100),
  hardware_concurrency INT,
  device_memory FLOAT,
  online BOOLEAN,
  referrer TEXT,
  url TEXT,
  title TEXT,
  connection_type VARCHAR(50),
  connection_downlink FLOAT,
  connection_rtt FLOAT,
  ip VARCHAR(45),
  city VARCHAR(100),
  region VARCHAR(100),
  country VARCHAR(100),
  org VARCHAR(255),
  latitude DOUBLE,
  longitude DOUBLE,
  precise BOOLEAN,
  created_at TIMESTAMP DEFAULT CURRENT_TIMESTAMP
);
