-- Create website_settings table
CREATE TABLE IF NOT EXISTS `website_settings` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `title` varchar(255) DEFAULT 'Dragons Pay - Instant UPI Payments Solution',
  `logo` varchar(255) DEFAULT 'newassets/images/Logo.png',
  `favicon` varchar(255) DEFAULT 'newassets/images/favicon.png',
  `contact_email` varchar(255) DEFAULT 'info@pay.garudhub.in',
  `contact_phone` varchar(20) DEFAULT '+91 6200218694',
  `contact_address` text DEFAULT 'Delhi, India',
  `recaptcha_site_key` varchar(255) DEFAULT '6LcAbAgsAAAAAJ7cvR1PpoyHlChULeDsxaTZFtd-',
  `recaptcha_secret_key` varchar(255) DEFAULT '6LcAbAgsAAAAAB-2p85-_YLSWSQWAuhHiUGkb7dQ',
  `smtp_host` varchar(255) DEFAULT 'smtp.hostinger.com',
  `smtp_username` varchar(255) DEFAULT 'support@garudhub.in',
  `smtp_password` varchar(255) DEFAULT 'Raushan7x@@@',
  `smtp_port` int(11) DEFAULT 587,
  `smtp_encryption` varchar(10) DEFAULT 'tls',
  `smtp_from_email` varchar(255) DEFAULT 'support@garudhub.in',
  `smtp_from_name` varchar(255) DEFAULT 'Greenpay',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;

-- Insert default settings
INSERT INTO `website_settings` (`id`, `title`, `logo`, `favicon`, `contact_email`, `contact_phone`, `contact_address`, `recaptcha_site_key`, `recaptcha_secret_key`, `smtp_host`, `smtp_username`, `smtp_password`, `smtp_port`, `smtp_encryption`, `smtp_from_email`, `smtp_from_name`) VALUES
(1, 'Dragons Pay - Instant UPI Payments Solution', 'newassets/images/Logo.png', 'newassets/images/favicon.png', 'info@pay.garudhub.in', '+91 6200218694', 'Delhi, India', '6LcAbAgsAAAAAJ7cvR1PpoyHlChULeDsxaTZFtd-', '6LcAbAgsAAAAAB-2p85-_YLSWSQWAuhHiUGkb7dQ', 'smtp.hostinger.com', 'support@garudhub.in', 'Raushan7x@@@', 587, 'tls', 'support@garudhub.in', 'Greenpay')
ON DUPLICATE KEY UPDATE id=1;
