CREATE DATABASE  IF NOT EXISTS `bdisteneabastecimiento` /*!40100 DEFAULT CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci */ /*!80016 DEFAULT ENCRYPTION='N' */;
USE `bdisteneabastecimiento`;
-- MySQL dump 10.13  Distrib 8.0.44, for macos15 (arm64)
--
-- Host: 127.0.0.1    Database: bdisteneabastecimiento
-- ------------------------------------------------------
-- Server version	8.4.7

/*!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 utf8 */;
/*!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 `area_solicitante`
--

DROP TABLE IF EXISTS `area_solicitante`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `area_solicitante` (
  `id` int NOT NULL AUTO_INCREMENT,
  `area_nombre` varchar(100) DEFAULT NULL,
  `area_estado` bit(1) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `area_solicitante`
--

LOCK TABLES `area_solicitante` WRITE;
/*!40000 ALTER TABLE `area_solicitante` DISABLE KEYS */;
/*!40000 ALTER TABLE `area_solicitante` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `cache`
--

DROP TABLE IF EXISTS `cache`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `cache` (
  `key` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `value` mediumtext COLLATE utf8mb4_unicode_ci NOT NULL,
  `expiration` int NOT NULL,
  PRIMARY KEY (`key`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `cache`
--

LOCK TABLES `cache` WRITE;
/*!40000 ALTER TABLE `cache` DISABLE KEYS */;
/*!40000 ALTER TABLE `cache` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `estado_solicitud`
--

DROP TABLE IF EXISTS `estado_solicitud`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `estado_solicitud` (
  `id` int NOT NULL AUTO_INCREMENT,
  `ests_nombre` varchar(50) DEFAULT NULL,
  `ests_estado` bit(1) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `estado_solicitud`
--

LOCK TABLES `estado_solicitud` WRITE;
/*!40000 ALTER TABLE `estado_solicitud` DISABLE KEYS */;
/*!40000 ALTER TABLE `estado_solicitud` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `kardex`
--

DROP TABLE IF EXISTS `kardex`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `kardex` (
  `id` int NOT NULL AUTO_INCREMENT,
  `kar_cantidad` decimal(10,2) DEFAULT NULL,
  `kar_fecha_movimiento` datetime DEFAULT NULL,
  `kar_costo_unitario` decimal(10,2) DEFAULT NULL,
  `kar_usuario_crea` varchar(100) DEFAULT NULL,
  `kar_fecha_crea` datetime DEFAULT NULL,
  `kar_usuario_edita` varchar(100) DEFAULT NULL,
  `kar_fecha_edita` datetime DEFAULT NULL,
  `productoid` int NOT NULL,
  `tipo_movimientoid` int NOT NULL,
  PRIMARY KEY (`id`),
  KEY `FKkardex221626` (`tipo_movimientoid`),
  KEY `FKkardex305300` (`productoid`),
  CONSTRAINT `FKkardex221626` FOREIGN KEY (`tipo_movimientoid`) REFERENCES `tipo_movimiento` (`id`),
  CONSTRAINT `FKkardex305300` FOREIGN KEY (`productoid`) REFERENCES `producto` (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `kardex`
--

LOCK TABLES `kardex` WRITE;
/*!40000 ALTER TABLE `kardex` DISABLE KEYS */;
/*!40000 ALTER TABLE `kardex` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `migrations`
--

DROP TABLE IF EXISTS `migrations`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `migrations` (
  `id` int unsigned NOT NULL AUTO_INCREMENT,
  `migration` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `batch` int NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `migrations`
--

LOCK TABLES `migrations` WRITE;
/*!40000 ALTER TABLE `migrations` DISABLE KEYS */;
/*!40000 ALTER TABLE `migrations` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `necesidad`
--

DROP TABLE IF EXISTS `necesidad`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `necesidad` (
  `id` int NOT NULL AUTO_INCREMENT,
  `nec_nombre` varchar(50) DEFAULT NULL,
  `nec_estado` bit(1) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `necesidad`
--

LOCK TABLES `necesidad` WRITE;
/*!40000 ALTER TABLE `necesidad` DISABLE KEYS */;
/*!40000 ALTER TABLE `necesidad` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `producto`
--

DROP TABLE IF EXISTS `producto`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `producto` (
  `id` int NOT NULL AUTO_INCREMENT,
  `pro_codigo` varchar(50) DEFAULT NULL,
  `pro_nombre` varchar(250) DEFAULT NULL,
  `pro_descripcion` varchar(250) DEFAULT NULL,
  `pro_stock_minimo` decimal(10,2) DEFAULT NULL,
  `pro_stock_maximo` decimal(10,2) DEFAULT NULL,
  `pro_estado` bit(1) DEFAULT b'1',
  `unidad_medidaid` int NOT NULL,
  `pro_es_servicio` bit(1) NOT NULL DEFAULT b'0',
  PRIMARY KEY (`id`),
  KEY `FKproducto157156` (`unidad_medidaid`),
  CONSTRAINT `FKproducto157156` FOREIGN KEY (`unidad_medidaid`) REFERENCES `unidad_medida` (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=6 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `producto`
--

LOCK TABLES `producto` WRITE;
/*!40000 ALTER TABLE `producto` DISABLE KEYS */;
INSERT INTO `producto` VALUES (1,'A1023','ALCOHOL ISOPROPILICO','demo detalle',4.00,NULL,NULL,3,_binary '\0'),(2,'HOJ100','HOJAS BOND','DETALLE PRODUCTO',23.00,NULL,_binary '',1,_binary '\0'),(3,'A1023','ALQUILER TOLDO','DDD',23.00,NULL,_binary '',1,_binary '\0'),(4,'A1023','ALCOHOL ISOPROPILICO','2333',23.00,NULL,_binary '',7,_binary ''),(5,'sadsad2121','HOJAS BOND','2323',222.00,NULL,_binary '',7,_binary '\0');
/*!40000 ALTER TABLE `producto` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `proveedor`
--

DROP TABLE IF EXISTS `proveedor`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `proveedor` (
  `id` int NOT NULL AUTO_INCREMENT,
  `prv_nro_documento` varchar(11) DEFAULT NULL,
  `prv_razon_social` varchar(250) DEFAULT NULL,
  `prv_nombre` varchar(250) DEFAULT NULL,
  `prv_esjuridica` bit(1) DEFAULT NULL,
  `prv_rubro` varchar(50) DEFAULT NULL,
  `prv_celular` varchar(15) DEFAULT NULL,
  `prv_email` varchar(150) DEFAULT NULL,
  `prv_historial` int DEFAULT NULL,
  `prv_calificacion` int DEFAULT NULL,
  `prv_estado` bit(1) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=16 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `proveedor`
--

LOCK TABLES `proveedor` WRITE;
/*!40000 ALTER TABLE `proveedor` DISABLE KEYS */;
INSERT INTO `proveedor` VALUES (1,'20123456789','Tech Solutions SAC','Carlos Méndez',_binary '','Tecnología','987654321','contacto@techsolutions.com',3,5,_binary ''),(2,'10456789123',NULL,'María López',_binary '\0','Servicios Generales','912345678','maria.lopez@gmail.com',2,4,_binary ''),(3,'20678912345','AgroPeru SRL','Luis Fernández',_binary '','Agricultura','976543210','ventas@agroperu.com',5,5,_binary ''),(4,'10765432109',NULL,'Jorge Castillo',_binary '\0','Transporte','945678321','jorge.castillo@yahoo.com',1,3,_binary ''),(5,'20543219876','Construmax SAC','Pedro Ramos',_binary '','Construcción','984321765','info@construmax.com',4,5,_binary ''),(6,'10876543210',NULL,'Ana Ruiz',_binary '\0','Consultoría','956478321','ana.ruiz@gmail.com',3,4,_binary ''),(7,'20765439876','MarketLine EIRL','Raúl García',_binary '','Comercio','974563210','ventas@marketline.com',6,5,_binary ''),(8,'10987654321',NULL,'Lucía Torres',_binary '\0','Diseño Gráfico','987654123','lucia.torres@gmail.com',2,4,_binary ''),(9,'20876543219','EcoServicios SAC','Diego Morales',_binary '','Limpieza','923456789','contacto@ecoservicios.com',5,5,_binary ''),(10,'11098765432',NULL,'Ricardo Paredes',_binary '\0','Electricidad','934567890','ricardo.paredes@hotmail.com',3,3,_binary ''),(11,'20987654322','Industrias Andinas SAC','Sofía Vega',_binary '','Manufactura','965478231','sofia.vega@indandinas.com',4,5,_binary ''),(12,'11123456789',NULL,'Fernando Díaz',_binary '\0','Transporte','987654789','fernando.diaz@gmail.com',1,4,_binary ''),(13,'21012345678','MedTech Perú SAC','Gabriela Chávez',_binary '','Salud','976123987','contacto@medtechperu.com',6,5,_binary ''),(14,'11234567890',NULL,'Claudia Ramos',_binary '\0','Eventos','954321876','claudia.ramos@gmail.com',2,4,_binary ''),(15,'21123456789','Global Imports EIRL','Javier Soto',_binary '','Importación','999888777','ventas@globalimports.com',5,5,_binary '');
/*!40000 ALTER TABLE `proveedor` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `requerimiento`
--

DROP TABLE IF EXISTS `requerimiento`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `requerimiento` (
  `id` int NOT NULL AUTO_INCREMENT,
  `req_nro` varchar(250) DEFAULT NULL,
  `req_fecha_solicitud` date DEFAULT NULL,
  `req_fecha_registro` date DEFAULT NULL,
  `req_descripcion` varchar(350) DEFAULT NULL,
  `req_monto_aprox` decimal(10,2) DEFAULT NULL,
  `req_nro_comprobante` varchar(150) DEFAULT NULL,
  `req_estado` int DEFAULT NULL,
  `req_usuario_crea` varchar(100) DEFAULT NULL,
  `req_usuario_edita` varchar(150) DEFAULT NULL,
  `req_date_crea` date DEFAULT NULL,
  `req_date_edita` date DEFAULT NULL,
  `area_solicitanteid` int NOT NULL,
  `necesidadid` int NOT NULL,
  `estado_solicitudid` int NOT NULL,
  `proveedorid` int NOT NULL,
  `req_nombres_solicita` varchar(100) DEFAULT NULL,
  `req_apellidos_solicita` varchar(150) DEFAULT NULL,
  `req_dni_solicita` varchar(150) DEFAULT NULL,
  `req_email_solicita` varchar(150) DEFAULT NULL,
  `req_celular_solicita` varchar(20) DEFAULT NULL,
  `req_apellido_paterno_solicita` varchar(150) DEFAULT NULL,
  `req_apellido_materno_solicita` varchar(150) DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `FKrequerimie900794` (`proveedorid`),
  KEY `FKrequerimie257029` (`estado_solicitudid`),
  KEY `FKrequerimie155661` (`necesidadid`),
  KEY `FKrequerimie705983` (`area_solicitanteid`),
  CONSTRAINT `FKrequerimie155661` FOREIGN KEY (`necesidadid`) REFERENCES `necesidad` (`id`),
  CONSTRAINT `FKrequerimie257029` FOREIGN KEY (`estado_solicitudid`) REFERENCES `estado_solicitud` (`id`),
  CONSTRAINT `FKrequerimie705983` FOREIGN KEY (`area_solicitanteid`) REFERENCES `area_solicitante` (`id`),
  CONSTRAINT `FKrequerimie900794` FOREIGN KEY (`proveedorid`) REFERENCES `proveedor` (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `requerimiento`
--

LOCK TABLES `requerimiento` WRITE;
/*!40000 ALTER TABLE `requerimiento` DISABLE KEYS */;
/*!40000 ALTER TABLE `requerimiento` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `requerimiento_detalle`
--

DROP TABLE IF EXISTS `requerimiento_detalle`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `requerimiento_detalle` (
  `id` int NOT NULL AUTO_INCREMENT,
  `reqd_cantidad` decimal(19,0) DEFAULT NULL,
  `reqd_estado` bit(1) DEFAULT NULL,
  `reqd_observacion` varchar(250) DEFAULT NULL,
  `productoid` int NOT NULL,
  `requerimientoid` int NOT NULL,
  PRIMARY KEY (`id`),
  KEY `FKrequerimie38923` (`requerimientoid`),
  KEY `FKrequerimie667242` (`productoid`),
  CONSTRAINT `FKrequerimie38923` FOREIGN KEY (`requerimientoid`) REFERENCES `requerimiento` (`id`),
  CONSTRAINT `FKrequerimie667242` FOREIGN KEY (`productoid`) REFERENCES `producto` (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `requerimiento_detalle`
--

LOCK TABLES `requerimiento_detalle` WRITE;
/*!40000 ALTER TABLE `requerimiento_detalle` DISABLE KEYS */;
/*!40000 ALTER TABLE `requerimiento_detalle` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `sessions`
--

DROP TABLE IF EXISTS `sessions`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `sessions` (
  `id` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `user_id` bigint unsigned DEFAULT NULL,
  `ip_address` varchar(45) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `user_agent` text COLLATE utf8mb4_unicode_ci,
  `payload` longtext COLLATE utf8mb4_unicode_ci NOT NULL,
  `last_activity` int NOT NULL,
  PRIMARY KEY (`id`),
  KEY `sessions_user_id_index` (`user_id`),
  KEY `sessions_last_activity_index` (`last_activity`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `sessions`
--

LOCK TABLES `sessions` WRITE;
/*!40000 ALTER TABLE `sessions` DISABLE KEYS */;
INSERT INTO `sessions` VALUES ('j1XD202QPJp4IhRgUdsh6WqoxjJRVj4js1TvvNen',1,'127.0.0.1','Mozilla/5.0 (Macintosh; Intel Mac OS X 10_15_7) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/142.0.0.0 Safari/537.36','YTo0OntzOjY6Il90b2tlbiI7czo0MDoiY09OVFhDSUpwTmtDWnlUdTQ1cmxhNkdnTHdGSWRvajBtdlRHRWk1TCI7czo5OiJfcHJldmlvdXMiO2E6MTp7czozOiJ1cmwiO3M6NDQ6Imh0dHA6Ly9sb2NhbGhvc3Q6ODAwMC9yZWdpc3Ryby1yZXF1ZXJpbWllbnRvIjt9czo2OiJfZmxhc2giO2E6Mjp7czozOiJvbGQiO2E6MDp7fXM6MzoibmV3IjthOjA6e319czo1MDoibG9naW5fd2ViXzU5YmEzNmFkZGMyYjJmOTQwMTU4MGYwMTRjN2Y1OGVhNGUzMDk4OWQiO2k6MTt9',1763219822),('scbRvjECEvPbsj0yWw2TL9bvXNKAArEXURiaVrjm',1,'127.0.0.1','Mozilla/5.0 (Macintosh; Intel Mac OS X 10_15_7) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/142.0.0.0 Safari/537.36','YTo0OntzOjY6Il90b2tlbiI7czo0MDoibnlSUVFveUpnVjJ3V1ViTlhuOWg0UzVSUXRyeHpmT2VMaEF5bEt5YiI7czo2OiJfZmxhc2giO2E6Mjp7czozOiJvbGQiO2E6MDp7fXM6MzoibmV3IjthOjA6e319czo1MDoibG9naW5fd2ViXzU5YmEzNmFkZGMyYjJmOTQwMTU4MGYwMTRjN2Y1OGVhNGUzMDk4OWQiO2k6MTtzOjk6Il9wcmV2aW91cyI7YToxOntzOjM6InVybCI7czo0MjoiaHR0cDovL2xvY2FsaG9zdDo4MDAwL2FwaS91bmlkYWRlcy1tZWRpZGFzIjt9fQ==',1764718708);
/*!40000 ALTER TABLE `sessions` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `tipo_movimiento`
--

DROP TABLE IF EXISTS `tipo_movimiento`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `tipo_movimiento` (
  `id` int NOT NULL AUTO_INCREMENT,
  `tipm_nombre` varchar(50) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `tipo_movimiento`
--

LOCK TABLES `tipo_movimiento` WRITE;
/*!40000 ALTER TABLE `tipo_movimiento` DISABLE KEYS */;
/*!40000 ALTER TABLE `tipo_movimiento` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `unidad_medida`
--

DROP TABLE IF EXISTS `unidad_medida`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `unidad_medida` (
  `id` int NOT NULL AUTO_INCREMENT,
  `uni_nombre` varchar(150) NOT NULL,
  `uni_abreviatura` varchar(20) DEFAULT NULL,
  `uni_estado` bit(1) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=11 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `unidad_medida`
--

LOCK TABLES `unidad_medida` WRITE;
/*!40000 ALTER TABLE `unidad_medida` DISABLE KEYS */;
INSERT INTO `unidad_medida` VALUES (1,'Kilogramo','kg',_binary ''),(2,'Gramo','g',_binary ''),(3,'Litro','L',_binary ''),(4,'Mililitro','ml',_binary ''),(5,'Metro','m',_binary ''),(6,'Centímetro','cm',_binary ''),(7,'Unidad','u',_binary ''),(8,'Docena','dz',_binary ''),(9,'Pulgada','in',_binary ''),(10,'Caja','cj',_binary '\0');
/*!40000 ALTER TABLE `unidad_medida` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `users`
--

DROP TABLE IF EXISTS `users`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `users` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `name` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `email` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `email_verified_at` timestamp NULL DEFAULT NULL,
  `password` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `remember_token` varchar(100) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `users_email_unique` (`email`)
) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `users`
--

LOCK TABLES `users` WRITE;
/*!40000 ALTER TABLE `users` DISABLE KEYS */;
INSERT INTO `users` VALUES (1,'MIGUEL LIZARDO SANCHEZ DIAZ','admin@gmail.com',NULL,'$2y$12$XjGIpdu63GvO164Nd.Xo4unO5ZR1RJAPbm7oiFEsoeKjK3LP8fi2S',NULL,'2025-07-27 04:01:13','2025-07-27 04:01:13'),(2,'Takeshy','takeshydiaz05@gmail.com',NULL,'$2y$12$7MySt7RmMgmcGpQS1wegqu1m4ZIJSISWAtNj6wSCyjQ/IpFMMfDdS','F6wFJUbixtSdZ137lzoucbXfyeZg35UliAY9mIJ71WX2nyfAx6IutpvPvlPr','2025-07-27 13:07:11','2025-07-31 10:46:20');
/*!40000 ALTER TABLE `users` 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 2025-12-02 18:42:05
