-- Create payment settings table
CREATE TABLE IF NOT EXISTS payment_settings (
  id INT PRIMARY KEY AUTO_INCREMENT,
  bkash_number VARCHAR(20),
  bkash_type ENUM('personal', 'merchant') DEFAULT 'personal',
  nagad_number VARCHAR(20),
  rocket_number VARCHAR(20),
  bank_name VARCHAR(100),
  bank_account VARCHAR(50),
  bank_routing VARCHAR(20),
  created_at TIMESTAMP DEFAULT CURRENT_TIMESTAMP,
  updated_at TIMESTAMP DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP
);

-- Insert default settings
INSERT INTO payment_settings (id, bkash_number, bkash_type, nagad_number, rocket_number, bank_name, bank_account, bank_routing) 
VALUES (1, '01780684828', 'personal', '01780684828', '01780684828', 'Dutch Bangla Bank', '1234567890', '090')
ON DUPLICATE KEY UPDATE id=id;
