--
-- Host: 127.0.0.1    Database: midas_staging
-- ------------------------------------------------------


--
-- Table structure for table `usuarios`
--

CREATE TABLE `usuarios` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `nombre` varchar(120) NOT NULL,
  `email` varchar(190) NOT NULL,
  `rol` enum('admin','comercial','operaciones') NOT NULL DEFAULT 'comercial',
  `password_hash` varchar(255) DEFAULT NULL,
  `activo` tinyint(1) NOT NULL DEFAULT 1,
  `created_at` datetime DEFAULT current_timestamp(),
  `updated_at` datetime DEFAULT current_timestamp() ON UPDATE current_timestamp(),
  PRIMARY KEY (`id`),
  UNIQUE KEY `email` (`email`)
) ENGINE=InnoDB AUTO_INCREMENT=4 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `usuarios`
--

INSERT INTO `usuarios` VALUES
(1,'Fabiola','fabiola@soinsa.local','admin','$2y$12$dIjtM8wjhY/wQClGKQwry.I1DfI6.IG7GVowrge8U5EiHKH4Jd09e',1,'2026-06-17 00:21:48','2026-06-17 00:21:48'),
(2,'Javiera','javiera@soinsa.local','comercial','$2y$12$LVC5Ka54qUnHlrPIVWZ8reCpH/hxAdYnn.cNmQdZEw4lY.7q6IJpS',1,'2026-06-17 00:21:48','2026-06-17 00:21:48'),
(3,'Direccion','direccion@soinsa.local','operaciones','$2y$12$W9GL8j4qGIQPAO0NyDSxwuZFPQ/y764/MDYJf/OJH1HZ5JdGpHRpy',1,'2026-06-17 00:21:48','2026-06-17 00:21:48');
COMMIT;


