--
-- Table structure for table `admin_users`
--
CREATE TABLE `admin_users` (
  `id` INT(11) NOT NULL AUTO_INCREMENT,
  `username` VARCHAR(100) NOT NULL,
  `password_hash` VARCHAR(255) NOT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `username` (`username`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;

--
-- Table structure for table `transactions`
--
CREATE TABLE `transactions` (
  `id` INT(11) NOT NULL AUTO_INCREMENT,
  `batch_id` VARCHAR(50) NOT NULL,
  `user_email` VARCHAR(255) NOT NULL,
  `amount` DECIMAL(20, 8) NOT NULL,
  `currency` VARCHAR(10) NOT NULL DEFAULT 'BCH',
  `status` ENUM('success','failed') NOT NULL,
  `faucetpay_response` TEXT DEFAULT NULL,
  `transaction_date` TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP,
  PRIMARY KEY (`id`),
  KEY `batch_id` (`batch_id`),
  KEY `user_email` (`user_email`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;