-- Migration: Add Payment Wallets Table

CREATE TABLE `payment_wallets` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `name` varchar(50) NOT NULL,
  `network` varchar(50) NOT NULL,
  `address` varchar(255) NOT NULL,
  `qr_code` varchar(255) DEFAULT NULL,
  `status` enum('active','inactive') NOT NULL DEFAULT 'active',
  `created_at` timestamp NOT NULL DEFAULT current_timestamp(),
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;

-- Insert default wallet
INSERT INTO `payment_wallets` (`name`, `network`, `address`, `status`) VALUES
('USDT Wallet', 'TRC20', 'T9yD14Nj9j7xAB4dbGeKsqWW8F9m4HGxp5', 'active'),
('Bitcoin Wallet', 'BTC', 'bc1qxy2kgdygjrsqtzq2n0yrf2493p83kkfjhx0wlh', 'active');
