-- ============================================================
-- Farhad YT Pay — Rebrand & Demo-Data Cleanup
-- For EXISTING installations (run once via phpMyAdmin / MySQL CLI).
-- Fresh installs don't need this: "SQL File.sql" already ships clean.
-- Backup your database before running.
-- ============================================================

-- ---------- Branding ----------
UPDATE `options` SET `value` = 'Farhad YT Pay'
  WHERE `name` IN ('site_title', 'site_name', 'copy_right_content', 'email_name', 'website_name');

UPDATE `options` SET `value` = 'Farhad YT Pay is a premium automated payment gateway platform for businesses - accept payments via bKash, Nagad, Rocket, cards and crypto with automated verification, instant settlement and real-time transaction tracking.'
  WHERE `name` = 'site_description';

UPDATE `options` SET `value` = 'farhad yt pay, payment gateway, automated payment, bkash, nagad, rocket, payment automation'
  WHERE `name` = 'site_keywords';

UPDATE `options` SET `value` = 'public/assets/theme/img/favicon.svg' WHERE `name` = 'site_icon';
UPDATE `options` SET `value` = 'public/assets/theme/img/logo.svg'    WHERE `name` = 'site_logo';

UPDATE `options` SET `value` = '' WHERE `name` IN (
  'notification_popup_content',
  'notification_popup_panel_content',
  'embed_head_javascript',
  'website_favicon'
);

-- Placeholder contact identity — replace with your real values
UPDATE `options` SET `value` = 'support@farhadytpay.com' WHERE `name` IN ('contact_email', 'email_from');

-- ---------- Remove demo content ----------
-- Children first, then parents (safe FK order)
DELETE FROM `activity_logs`;
DELETE FROM `admin_activity_logs`;
DELETE FROM `bank_transaction_logs`;
DELETE FROM `blogs`;
DELETE FROM `brands`;
DELETE FROM `coupons`;
DELETE FROM `user_coupons`;
DELETE FROM `devices`;
DELETE FROM `faqs`;
DELETE FROM `file_managers`;
DELETE FROM `invoice`;
DELETE FROM `kyc`;
DELETE FROM `module_data`;
DELETE FROM `notifications`;
DELETE FROM `queue`;
DELETE FROM `staffs`;
DELETE FROM `temp_transactions`;
DELETE FROM `tickets`;
DELETE FROM `ticket_messages`;
DELETE FROM `transactions`;
DELETE FROM `affiliates`;
DELETE FROM `user_payment_settings`;
DELETE FROM `user_payouts`;
DELETE FROM `user_plans`;
DELETE FROM `user_notifier`;
DELETE FROM `user_transactions`;

-- Demo users: keep only the primary admin (id = 1)
DELETE FROM `users` WHERE `id` <> 1;
UPDATE `users`
   SET `avatar` = NULL, `balance` = 0, `activation_key` = NULL, `reset_key` = NULL
 WHERE `id` = 1;

-- Optional: reset admin password to Admin@123
-- (bcrypt hash below was generated with PHP password_hash)
-- UPDATE `users` SET `password` = '$2y$10$Kfik1l5ykQKD6SLM1soaR.P64UPj1pS4fRr6sFsxLsake3Vas7/5K' WHERE `id` = 1;
