CREATE TABLE `exchange_rates` (
  `id` int(11) NOT NULL,
  `country` enum('VE','BR','MX','PE','PA','US','') NOT NULL,
  `isofiat` varchar(5) NOT NULL,
  `symbol` varchar(5) NOT NULL,
  `rate` decimal(10,3) NOT NULL,
  `at_register` timestamp NOT NULL DEFAULT current_timestamp() ON UPDATE current_timestamp()
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_general_ci;

CREATE TABLE `payment_processors` (
  `id` int(11) NOT NULL,
  `name` varchar(100) NOT NULL,
  `imagen` text NOT NULL,
  `min` decimal(10,3) NOT NULL,
  `max` decimal(10,3) NOT NULL,
  `status` enum('Activo','Inactivo','','') NOT NULL,
  `created_at` timestamp NOT NULL DEFAULT current_timestamp() ON UPDATE current_timestamp(),
  `id_commissions` int(10) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_general_ci;

CREATE TABLE `commissions` (
  `id` int(11) NOT NULL,
  `maximum` decimal(10,3) NOT NULL,
  `divider` decimal(10,2) NOT NULL,
  `variable` decimal(10,3) NOT NULL,
  `fixed` decimal(10,3) NOT NULL,
  `reduce` decimal(10,3) NOT NULL,
  `at_register` timestamp NOT NULL DEFAULT current_timestamp() ON UPDATE current_timestamp()
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_general_ci;