--
-- Host: localhost    Database: asterisk
-- ------------------------------------------------------


--
-- Table structure for table `agentes`
--

CREATE TABLE `agentes` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `usuario` varchar(20) DEFAULT NULL,
  `nombre` varchar(50) DEFAULT NULL,
  `apellidos` varchar(100) DEFAULT NULL,
  `descripcion` text DEFAULT NULL,
  `password` int(3) DEFAULT NULL,
  `telefono` varchar(20) DEFAULT NULL,
  `estado_login` tinyint(4) DEFAULT 0,
  `estado_ocupacion` tinyint(4) DEFAULT 0,
  `dnd_status` tinyint(1) NOT NULL DEFAULT 0,
  `activo` tinyint(1) DEFAULT 1,
  `orden_display` int(11) DEFAULT 0,
  `created_at` timestamp NULL DEFAULT current_timestamp(),
  `updated_at` timestamp NULL DEFAULT current_timestamp() ON UPDATE current_timestamp(),
  `sync_with_panel` tinyint(1) DEFAULT 1 COMMENT 'Si debe sincronizarse con panel_tarot',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=35 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `agentes`
--

INSERT INTO `agentes` VALUES
(8,'324','cristina',NULL,NULL,324,'626885499',0,0,0,1,0,'2025-07-30 13:28:36','2025-07-30 13:28:36',1),
(9,'350','David',NULL,NULL,350,'680696867',1,1,0,1,0,'2025-07-30 13:28:36','2025-07-30 13:28:36',1),
(10,'325','paloma',NULL,NULL,325,'605731697',1,0,0,1,0,'2025-07-30 13:28:36','2025-07-30 13:28:36',1),
(11,'326','Tatiana',NULL,NULL,326,'670954248',0,0,0,1,0,'2025-07-30 13:28:36','2025-07-30 13:28:36',1),
(12,'327','TelfRojo',NULL,NULL,327,'911762148',0,0,0,1,0,'2025-07-30 13:28:36','2025-07-31 10:10:38',0),
(13,'328','Telefonorojo',NULL,NULL,328,'910640539',0,0,0,1,0,'2025-07-30 13:28:36','2025-07-31 10:10:35',0),
(14,'351','Carmen Luna',NULL,NULL,123,NULL,1,1,0,1,0,'2025-07-30 13:28:36','2025-07-30 13:28:36',1),
(15,'352','Pilar Vidente',NULL,NULL,123,NULL,1,0,0,1,0,'2025-07-30 13:28:36','2025-07-30 13:28:36',1),
(16,'353','Rosa Tarot',NULL,NULL,123,NULL,1,0,1,1,0,'2025-07-30 13:28:36','2025-07-30 13:28:36',1),
(17,'354','Elena Esotérica',NULL,NULL,123,NULL,1,0,0,1,0,'2025-07-30 13:28:36','2025-07-30 13:28:36',1),
(18,'355','Laura Cartas',NULL,NULL,123,NULL,0,0,0,1,0,'2025-07-30 13:28:36','2025-07-30 13:28:36',1),
(22,'301','CLARA','',NULL,5252,'951990101',0,0,0,1,0,'2025-07-30 19:14:04','2025-07-31 10:17:30',1),
(23,'303','BRUNO','',NULL,5252,'983655881',0,0,0,1,0,'2025-07-30 19:14:04','2025-07-30 19:14:04',1),
(24,'308','ERIKA','',NULL,5252,'960153483',0,0,0,1,0,'2025-07-30 19:14:04','2025-07-30 19:14:04',1),
(25,'502','BORJA','',NULL,5252,'CENTRALITA',0,0,0,1,0,'2025-07-30 19:16:42','2025-07-30 19:16:42',1),
(26,'514','ANA','',NULL,5252,'911490669',0,0,0,1,0,'2025-07-30 19:16:42','2025-07-30 19:16:42',1),
(27,'515','MIGUEL','ANGEL',NULL,5252,'926923194',0,0,0,1,0,'2025-07-30 19:16:42','2025-07-30 19:16:42',1),
(28,'534','FLORIDA','',NULL,5252,'CENTRALITA',0,0,0,1,0,'2025-07-30 19:16:42','2025-07-30 19:16:42',1),
(29,'537','MARIA','',NULL,5252,'981753964',0,0,0,1,0,'2025-07-30 19:16:42','2025-07-30 19:16:42',1),
(30,'555','BEATRIZ','',NULL,5252,'925821839',0,0,0,1,0,'2025-07-30 19:16:42','2025-07-30 19:16:42',1),
(31,'568','LEONOR','',NULL,5252,'825852340',0,0,0,1,0,'2025-07-30 19:16:42','2025-07-30 19:16:42',1),
(32,'569','MAGGIE','',NULL,5252,'965563678',0,0,0,1,0,'2025-07-30 19:16:42','2025-07-30 19:16:42',1),
(33,'574','ESTRELLA','',NULL,5252,'881123980',0,0,0,1,0,'2025-07-30 19:16:42','2025-07-30 19:16:42',1),
(34,'577','DANIEL','',NULL,5252,'924033345',0,0,0,1,0,'2025-07-30 19:16:42','2025-07-30 19:16:42',1);


