-- Sand World v2: admin approval/decline withdrawals + task proof review + Monetag link
ALTER TABLE withdrawals MODIFY status ENUM('pending','processing','completed','failed') NOT NULL DEFAULT 'pending';
CREATE TABLE IF NOT EXISTS task_proofs (
  id INT UNSIGNED AUTO_INCREMENT PRIMARY KEY,
  user_id INT UNSIGNED NOT NULL,
  task_id INT UNSIGNED NOT NULL,
  proof_text TEXT NOT NULL,
  status ENUM('pending','approved','declined') NOT NULL DEFAULT 'pending',
  admin_note VARCHAR(255) DEFAULT NULL,
  reviewed_at DATETIME DEFAULT NULL,
  created_at DATETIME NOT NULL DEFAULT CURRENT_TIMESTAMP,
  KEY idx_proof_status (status),
  KEY idx_proof_user_task (user_id, task_id)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;
INSERT INTO settings (setting_key, setting_value) VALUES ('monetag_ad_link','') ON DUPLICATE KEY UPDATE setting_key=setting_key;