-- MySQL dump 10.13  Distrib 8.0.30, for Win64 (x86_64)
--
-- Host: localhost    Database: db_presencia_vial
-- ------------------------------------------------------
-- Server version	8.0.30

/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
/*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
/*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;
/*!50503 SET NAMES utf8mb4 */;
/*!40103 SET @OLD_TIME_ZONE=@@TIME_ZONE */;
/*!40103 SET TIME_ZONE='+00:00' */;
/*!40014 SET @OLD_UNIQUE_CHECKS=@@UNIQUE_CHECKS, UNIQUE_CHECKS=0 */;
/*!40014 SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0 */;
/*!40101 SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='NO_AUTO_VALUE_ON_ZERO' */;
/*!40111 SET @OLD_SQL_NOTES=@@SQL_NOTES, SQL_NOTES=0 */;

--
-- Table structure for table `reportes`
--

DROP TABLE IF EXISTS `reportes`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `reportes` (
  `id` int NOT NULL AUTO_INCREMENT,
  `sector_texto` varchar(250) COLLATE utf8mb4_unicode_ci NOT NULL,
  `quienes_estan` text COLLATE utf8mb4_unicode_ci NOT NULL,
  `estado_actual` enum('Activo','Dudoso','Retirado') COLLATE utf8mb4_unicode_ci DEFAULT 'Activo',
  `conteo_fe` int DEFAULT '1',
  `conteo_desmentido` int DEFAULT '0',
  `creado_el` timestamp NULL DEFAULT CURRENT_TIMESTAMP,
  `ultima_confirmacion` timestamp NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `reportes`
--

LOCK TABLES `reportes` WRITE;
/*!40000 ALTER TABLE `reportes` DISABLE KEYS */;
INSERT INTO `reportes` VALUES (1,'Cotacachi el sol','2 patrullas ','Retirado',2,0,'2026-01-29 17:35:49','2026-01-29 17:59:28');
/*!40000 ALTER TABLE `reportes` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `trafico_web`
--

DROP TABLE IF EXISTS `trafico_web`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `trafico_web` (
  `id` int NOT NULL AUTO_INCREMENT,
  `archivo_ejecutado` varchar(100) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `fecha_uso` timestamp NULL DEFAULT CURRENT_TIMESTAMP,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=60 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `trafico_web`
--

LOCK TABLES `trafico_web` WRITE;
/*!40000 ALTER TABLE `trafico_web` DISABLE KEYS */;
INSERT INTO `trafico_web` VALUES (1,'index.php','2026-01-29 18:10:51'),(11,'index.php','2026-01-29 18:17:29'),(12,'index.php','2026-01-29 18:17:51'),(13,'index.php','2026-01-29 18:18:40'),(14,'index.php','2026-01-29 18:19:56'),(15,'index.php','2026-01-29 18:19:59'),(16,'index.php','2026-01-29 18:19:59'),(17,'index.php','2026-01-29 18:19:59'),(18,'index.php','2026-01-29 18:20:01'),(19,'index.php','2026-01-29 18:20:05'),(20,'index.php','2026-01-29 18:20:20'),(21,'index.php','2026-01-29 18:21:31'),(22,'index.php','2026-01-29 18:21:37'),(23,'index.php','2026-01-29 18:22:07'),(24,'index.php','2026-01-29 18:22:44'),(25,'index.php','2026-01-29 18:26:38'),(26,'index.php','2026-01-29 18:26:47'),(27,'index.php','2026-01-29 18:28:16'),(28,'index.php','2026-01-29 18:33:03'),(29,'index.php','2026-01-29 18:33:27'),(30,'index.php','2026-01-29 18:36:11'),(31,'index.php','2026-01-29 18:36:58'),(32,'index.php','2026-01-29 18:37:07'),(33,'index.php','2026-01-29 18:37:11'),(34,'index.php','2026-01-29 18:37:27'),(35,'index.php','2026-01-29 18:39:31'),(36,'index.php','2026-01-29 18:47:43'),(37,'index.php','2026-01-29 18:48:45'),(38,'index.php','2026-01-29 18:49:14'),(39,'index.php','2026-01-29 18:49:18'),(40,'index.php','2026-01-29 18:49:27'),(41,'index.php','2026-01-29 18:49:36'),(42,'index.php','2026-01-29 18:49:48'),(43,'index.php','2026-01-29 18:50:22'),(44,'index.php','2026-01-29 19:04:10'),(45,'index.php','2026-01-29 19:04:20'),(46,'index.php','2026-01-29 19:26:18'),(47,'index.php','2026-01-29 19:34:18'),(48,'index.php','2026-01-29 19:34:31'),(49,'index.php','2026-01-29 19:39:42'),(50,'index.php','2026-01-29 20:09:23'),(51,'index.php','2026-01-29 20:40:05'),(52,'index.php','2026-01-29 23:10:53'),(53,'index.php','2026-01-30 02:52:42'),(54,'index.php','2026-01-30 02:53:01'),(55,'index.php','2026-02-06 17:12:17'),(56,'index.php','2026-02-06 17:12:36'),(57,'index.php','2026-02-18 15:28:11'),(58,'index.php','2026-02-24 00:44:30'),(59,'index.php','2026-02-26 21:57:09');
/*!40000 ALTER TABLE `trafico_web` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `validaciones_ip`
--

DROP TABLE IF EXISTS `validaciones_ip`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `validaciones_ip` (
  `id` int NOT NULL AUTO_INCREMENT,
  `reporte_id` int DEFAULT NULL,
  `ip_usuario` varchar(45) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `tipo_voto` enum('dar_fe','desmentir') COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `fecha` timestamp NULL DEFAULT CURRENT_TIMESTAMP,
  PRIMARY KEY (`id`),
  KEY `reporte_id` (`reporte_id`),
  CONSTRAINT `validaciones_ip_ibfk_1` FOREIGN KEY (`reporte_id`) REFERENCES `reportes` (`id`) ON DELETE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `validaciones_ip`
--

LOCK TABLES `validaciones_ip` WRITE;
/*!40000 ALTER TABLE `validaciones_ip` DISABLE KEYS */;
/*!40000 ALTER TABLE `validaciones_ip` ENABLE KEYS */;
UNLOCK TABLES;
/*!40103 SET TIME_ZONE=@OLD_TIME_ZONE */;

/*!40101 SET SQL_MODE=@OLD_SQL_MODE */;
/*!40014 SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS */;
/*!40014 SET UNIQUE_CHECKS=@OLD_UNIQUE_CHECKS */;
/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
/*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */;
/*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;
/*!40111 SET SQL_NOTES=@OLD_SQL_NOTES */;

-- Dump completed on 2026-03-05 16:10:50
