-- V5.2: client error log + configurable home sections/social footer.
CREATE TABLE IF NOT EXISTS app_error_logs (
  id BIGINT UNSIGNED AUTO_INCREMENT PRIMARY KEY,
  reference_code VARCHAR(32) NOT NULL UNIQUE,
  source VARCHAR(40) NOT NULL DEFAULT 'flutter',
  level VARCHAR(20) NOT NULL DEFAULT 'error',
  message VARCHAR(1000) NOT NULL,
  stack_trace MEDIUMTEXT NULL,
  route VARCHAR(255) NULL,
  user_id BIGINT UNSIGNED NULL,
  app_version VARCHAR(50) NULL,
  device_info VARCHAR(500) NULL,
  ip_address VARCHAR(64) NULL,
  resolved_at DATETIME NULL,
  created_at TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP,
  INDEX(created_at), INDEX(resolved_at), INDEX(user_id)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;

INSERT INTO settings (`key`,`value`) VALUES
('home_new_limit','4'),
('home_best_limit','4'),
('home_whatsapp',''),
('home_facebook',''),
('home_instagram',''),
('home_phone',''),
('home_footer_about','RIXOS MARKET — جودة مختارة وخدمة نثق بها')
ON DUPLICATE KEY UPDATE `value`=`value`;