-- MySQL dump 10.13  Distrib 8.0.30, for Win64 (x86_64)
--
-- Host: localhost    Database: forcenet_db
-- ------------------------------------------------------
-- 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 `cambio_aceite`
--

DROP TABLE IF EXISTS `cambio_aceite`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `cambio_aceite` (
  `id` int NOT NULL AUTO_INCREMENT,
  `fecha` date NOT NULL,
  `km_cambio` int NOT NULL,
  `proximo_cambio` int DEFAULT NULL,
  `costo` decimal(10,2) NOT NULL,
  `foto_factura` varchar(255) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `cambio_aceite`
--

LOCK TABLES `cambio_aceite` WRITE;
/*!40000 ALTER TABLE `cambio_aceite` DISABLE KEYS */;
INSERT INTO `cambio_aceite` VALUES (1,'2026-02-09',10122,11122,8.00,'uploads/FORCENET_20260209_214103_698a546faedaa.jpg');
/*!40000 ALTER TABLE `cambio_aceite` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `combustible`
--

DROP TABLE IF EXISTS `combustible`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `combustible` (
  `id` int NOT NULL AUTO_INCREMENT,
  `fecha` date NOT NULL,
  `km_registro` int NOT NULL,
  `galones` decimal(10,2) NOT NULL,
  `costo_total` decimal(10,2) NOT NULL,
  `rendimiento_km_gal` decimal(10,2) DEFAULT '0.00',
  `costo_por_km` decimal(10,2) DEFAULT '0.00',
  `foto_recibo` varchar(255) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=7 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `combustible`
--

LOCK TABLES `combustible` WRITE;
/*!40000 ALTER TABLE `combustible` DISABLE KEYS */;
INSERT INTO `combustible` VALUES (1,'2026-02-09',0,0.00,0.00,0.00,0.00,NULL),(2,'2026-02-09',10120,1.93,5.26,0.00,0.00,'uploads/FORCENET_20260209_220059_698a591ba9f01.jpg'),(3,'2026-02-09',10281,1.88,5.11,0.00,0.03,NULL),(4,'2026-02-10',10435,1.22,3.31,0.00,0.02,'uploads/FORCENET_20260210_152511_698b4dd77b6bb.jpg'),(5,'2026-02-22',10541,1.84,5.00,0.00,0.05,'uploads/FORCENET_20260222_153300_699b21ac26e99.jpg'),(6,'2026-03-02',10697,1.84,5.00,0.00,0.03,'uploads/FORCENET_20260302_025321_69a4fba1e60d5.jpg');
/*!40000 ALTER TABLE `combustible` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `registros_diarios`
--

DROP TABLE IF EXISTS `registros_diarios`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `registros_diarios` (
  `id` int NOT NULL AUTO_INCREMENT,
  `fecha` date NOT NULL,
  `km_actual` int NOT NULL,
  `km_recorrido` int DEFAULT '0',
  `created_at` timestamp NULL DEFAULT CURRENT_TIMESTAMP,
  `foto_odometro` varchar(255) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=12 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `registros_diarios`
--

LOCK TABLES `registros_diarios` WRITE;
/*!40000 ALTER TABLE `registros_diarios` DISABLE KEYS */;
INSERT INTO `registros_diarios` VALUES (1,'2026-02-09',10428,0,'2026-02-09 21:41:36',NULL),(2,'2026-02-13',10453,25,'2026-02-13 18:44:09','uploads/FORCENET_20260213_184409_698f70f91656c.jpg'),(3,'2026-02-15',10467,14,'2026-02-15 15:21:23',NULL),(4,'2026-02-15',10467,0,'2026-02-15 15:21:34','uploads/FORCENET_20260215_152134_6991e47e52089.jpg'),(5,'2026-02-17',10478,11,'2026-02-17 18:24:07','uploads/FORCENET_20260217_182407_6994b247d8254.jpg'),(6,'2026-02-18',10507,29,'2026-02-18 22:20:13','uploads/FORCENET_20260218_222013_69963b1dd6171.jpg'),(7,'2026-02-21',10514,7,'2026-02-21 16:31:38','uploads/FORCENET_20260221_163138_6999ddeab080f.jpg'),(8,'2026-02-28',10659,145,'2026-02-28 21:55:36','uploads/FORCENET_20260228_215536_69a36458ecd96.jpg'),(9,'2026-03-02',10697,38,'2026-03-02 02:52:50','uploads/FORCENET_20260302_025250_69a4fb82be9d7.jpg'),(10,'2026-03-05',10788,91,'2026-03-05 18:35:58',NULL),(11,'2026-03-05',10788,0,'2026-03-05 18:36:06','uploads/FORCENET_20260305_183606_69a9cd16893f9.jpg');
/*!40000 ALTER TABLE `registros_diarios` 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
