-- --------------------------------------------------------
-- Versión del servidor:         8.0.30 - MySQL Community Server - GPL
-- SO del servidor:              Win64
-- HeidiSQL Versión:             12.8.0.6908
-- --------------------------------------------------------


-- Volcando estructura para tabla larapos.arqueo_cajas
CREATE TABLE IF NOT EXISTS `arqueo_cajas` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `caja_id` bigint unsigned NOT NULL,
  `fecha_inicio` date NOT NULL,
  `fecha_fin` date DEFAULT NULL,
  `monto_inicial` decimal(10,2) NOT NULL,
  `monto_final` decimal(10,2) DEFAULT '0.00',
  `estado` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `user_id` bigint unsigned NOT NULL,
  `empresa_id` bigint unsigned NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `arqueo_cajas_caja_id_foreign` (`caja_id`),
  KEY `arqueo_cajas_user_id_foreign` (`user_id`),
  KEY `arqueo_cajas_empresa_id_foreign` (`empresa_id`),
  CONSTRAINT `arqueo_cajas_caja_id_foreign` FOREIGN KEY (`caja_id`) REFERENCES `cajas` (`id`),
  CONSTRAINT `arqueo_cajas_empresa_id_foreign` FOREIGN KEY (`empresa_id`) REFERENCES `empresas` (`id`),
  CONSTRAINT `arqueo_cajas_user_id_foreign` FOREIGN KEY (`user_id`) REFERENCES `users` (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

-- Volcando datos para la tabla larapos.arqueo_cajas: ~0 rows (aproximadamente)
DELETE FROM `arqueo_cajas`;

-- Volcando estructura para tabla larapos.cajas
CREATE TABLE IF NOT EXISTS `cajas` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `codigo` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `name` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `user_id` bigint unsigned NOT NULL,
  `empresa_id` bigint unsigned NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `cajas_user_id_foreign` (`user_id`),
  KEY `cajas_empresa_id_foreign` (`empresa_id`),
  CONSTRAINT `cajas_empresa_id_foreign` FOREIGN KEY (`empresa_id`) REFERENCES `empresas` (`id`),
  CONSTRAINT `cajas_user_id_foreign` FOREIGN KEY (`user_id`) REFERENCES `users` (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

-- Volcando datos para la tabla larapos.cajas: ~0 rows (aproximadamente)
DELETE FROM `cajas`;
INSERT INTO `cajas` (`id`, `codigo`, `name`, `user_id`, `empresa_id`, `created_at`, `updated_at`) VALUES
	(1, '678157b72bdf1', 'CAJA 1', 1, 1, '2025-01-10 17:24:07', '2025-01-10 17:24:07');

-- Volcando estructura para tabla larapos.categorias
CREATE TABLE IF NOT EXISTS `categorias` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `name` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `status` smallint NOT NULL,
  `empresaId` bigint unsigned NOT NULL DEFAULT '1',
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `categorias_empresaid_foreign` (`empresaId`),
  CONSTRAINT `categorias_empresaid_foreign` FOREIGN KEY (`empresaId`) REFERENCES `empresas` (`id`) ON DELETE CASCADE ON UPDATE CASCADE
) ENGINE=InnoDB AUTO_INCREMENT=6 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

-- Volcando datos para la tabla larapos.categorias: ~5 rows (aproximadamente)
DELETE FROM `categorias`;
INSERT INTO `categorias` (`id`, `name`, `status`, `empresaId`, `created_at`, `updated_at`) VALUES
	(1, 'Alimentos', 1, 1, '2025-01-10 17:24:07', '2025-01-10 17:24:07'),
	(2, 'Bebidas', 1, 1, '2025-01-10 17:24:07', '2025-01-10 17:24:07'),
	(3, 'Aseo persona e Higiene', 1, 1, '2025-01-10 17:24:07', '2025-01-10 17:24:07'),
	(4, 'Cigarros', 1, 1, '2025-01-10 17:24:07', '2025-01-10 17:24:07'),
	(5, 'Golosinas', 0, 1, '2025-01-10 17:24:07', '2025-01-11 18:12:34');

-- Volcando estructura para tabla larapos.cupones
CREATE TABLE IF NOT EXISTS `cupones` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `name` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `codigo` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `porcentaje` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `duracion` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `status` smallint NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

-- Volcando datos para la tabla larapos.cupones: ~0 rows (aproximadamente)
DELETE FROM `cupones`;
INSERT INTO `cupones` (`id`, `name`, `codigo`, `porcentaje`, `duracion`, `status`, `created_at`, `updated_at`) VALUES
	(1, 'Compra de Bienvenida', 'CNDTQ82DOX', '5', '30', 1, '2025-01-10 17:24:06', '2025-01-10 17:24:06');

-- Volcando estructura para tabla larapos.detalle_pedidos
CREATE TABLE IF NOT EXISTS `detalle_pedidos` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `fecha` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '2025-01-10',
  `total_usd` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `total_bs` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `quantity` int NOT NULL,
  `price` decimal(20,2) NOT NULL,
  `empresaId` bigint unsigned NOT NULL,
  `userId` bigint unsigned NOT NULL,
  `productoId` bigint unsigned NOT NULL,
  `pedidoId` bigint unsigned NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `detalle_pedidos_empresaid_foreign` (`empresaId`),
  KEY `detalle_pedidos_userid_foreign` (`userId`),
  KEY `detalle_pedidos_productoid_foreign` (`productoId`),
  KEY `detalle_pedidos_pedidoid_foreign` (`pedidoId`),
  CONSTRAINT `detalle_pedidos_empresaid_foreign` FOREIGN KEY (`empresaId`) REFERENCES `empresas` (`id`) ON DELETE CASCADE,
  CONSTRAINT `detalle_pedidos_pedidoid_foreign` FOREIGN KEY (`pedidoId`) REFERENCES `pedidos` (`id`) ON DELETE CASCADE,
  CONSTRAINT `detalle_pedidos_productoid_foreign` FOREIGN KEY (`productoId`) REFERENCES `productos` (`id`) ON DELETE CASCADE,
  CONSTRAINT `detalle_pedidos_userid_foreign` FOREIGN KEY (`userId`) REFERENCES `users` (`id`) ON DELETE CASCADE
) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

-- Volcando datos para la tabla larapos.detalle_pedidos: ~2 rows (aproximadamente)
DELETE FROM `detalle_pedidos`;
INSERT INTO `detalle_pedidos` (`id`, `fecha`, `total_usd`, `total_bs`, `quantity`, `price`, `empresaId`, `userId`, `productoId`, `pedidoId`, `created_at`, `updated_at`) VALUES
	(1, '2025-01-11', '5.225', '249.755', 1, 5.50, 1, 2, 3, 1, '2025-01-11 23:04:26', '2025-01-11 23:04:26'),
	(2, '2025-01-11', '9.5', '454.1', 1, 10.00, 1, 2, 4, 1, '2025-01-11 23:04:26', '2025-01-11 23:04:26');

-- Volcando estructura para tabla larapos.detalle_productos
CREATE TABLE IF NOT EXISTS `detalle_productos` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `description` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT 'text',
  `cantidad` int NOT NULL,
  `producto_id` bigint unsigned NOT NULL DEFAULT '1',
  `featured` tinyint(1) NOT NULL DEFAULT '0',
  `empresaId` bigint unsigned NOT NULL DEFAULT '1',
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `detalle_productos_producto_id_foreign` (`producto_id`),
  KEY `detalle_productos_empresaid_foreign` (`empresaId`),
  CONSTRAINT `detalle_productos_empresaid_foreign` FOREIGN KEY (`empresaId`) REFERENCES `empresas` (`id`) ON DELETE CASCADE ON UPDATE CASCADE,
  CONSTRAINT `detalle_productos_producto_id_foreign` FOREIGN KEY (`producto_id`) REFERENCES `productos` (`id`) ON DELETE CASCADE ON UPDATE CASCADE
) ENGINE=InnoDB AUTO_INCREMENT=48 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

-- Volcando datos para la tabla larapos.detalle_productos: ~45 rows (aproximadamente)
DELETE FROM `detalle_productos`;
INSERT INTO `detalle_productos` (`id`, `description`, `cantidad`, `producto_id`, `featured`, `empresaId`, `created_at`, `updated_at`) VALUES
	(1, 'INGRESO (+) DE PRODUCTO 5000', 5000, 3, 0, 1, '2025-01-10 17:32:30', '2025-01-10 17:32:30'),
	(2, 'INGRESO (+) DE PRODUCTO 5000', 5000, 4, 0, 1, '2025-01-10 17:33:58', '2025-01-10 17:33:58'),
	(3, 'INGRESO (+) DE PRODUCTO 5000', 5000, 5, 0, 1, '2025-01-10 17:42:03', '2025-01-10 17:42:03'),
	(4, 'INGRESO (+) DE PRODUCTO 5000', 5000, 6, 0, 1, '2025-01-10 17:45:07', '2025-01-10 17:45:07'),
	(5, 'INGRESO (+) DE PRODUCTO 5000', 5000, 7, 0, 1, '2025-01-10 17:46:31', '2025-01-10 17:46:31'),
	(6, 'INGRESO (+) DE PRODUCTO 5000', 5000, 8, 0, 1, '2025-01-10 17:51:38', '2025-01-10 17:51:38'),
	(7, 'INGRESO (+) DE PRODUCTO 5000', 5000, 9, 0, 1, '2025-01-10 17:53:13', '2025-01-10 17:53:13'),
	(8, 'INGRESO (+) DE PRODUCTO 5000', 5000, 10, 0, 1, '2025-01-10 17:54:33', '2025-01-10 17:54:33'),
	(9, 'INGRESO (+) DE PRODUCTO 5000', 5000, 11, 0, 1, '2025-01-10 22:11:46', '2025-01-10 22:11:46'),
	(10, 'INGRESO (+) DE PRODUCTO 5000', 5000, 12, 0, 1, '2025-01-10 22:12:55', '2025-01-10 22:12:55'),
	(11, 'INGRESO (+) DE PRODUCTO 5000', 5000, 13, 0, 1, '2025-01-10 22:14:29', '2025-01-10 22:14:29'),
	(12, 'INGRESO (+) DE PRODUCTO 5000', 5000, 14, 0, 1, '2025-01-10 22:16:16', '2025-01-10 22:16:16'),
	(13, 'INGRESO (+) DE PRODUCTO 5000', 5000, 15, 0, 1, '2025-01-10 22:18:53', '2025-01-10 22:18:53'),
	(14, 'INGRESO (+) DE PRODUCTO 5000', 5000, 16, 0, 1, '2025-01-10 22:20:59', '2025-01-10 22:20:59'),
	(15, 'INGRESO (+) DE PRODUCTO 5000', 5000, 17, 0, 1, '2025-01-10 22:22:44', '2025-01-10 22:22:44'),
	(16, 'INGRESO (+) DE PRODUCTO 6', 6, 18, 0, 1, '2025-01-10 22:25:03', '2025-01-10 22:25:03'),
	(17, 'INGRESO (+) DE PRODUCTO 5000', 5000, 19, 0, 1, '2025-01-10 22:28:03', '2025-01-10 22:28:03'),
	(18, 'INGRESO (+) DE PRODUCTO 5000', 5000, 20, 0, 1, '2025-01-10 22:30:28', '2025-01-10 22:30:28'),
	(19, 'INGRESO (+) DE PRODUCTO 5000', 5000, 21, 0, 1, '2025-01-10 22:31:53', '2025-01-10 22:31:53'),
	(20, 'INGRESO (+) DE PRODUCTO 5000', 5000, 22, 0, 1, '2025-01-10 22:38:19', '2025-01-10 22:38:19'),
	(21, 'INGRESO (+) DE PRODUCTO 5000', 5000, 23, 0, 1, '2025-01-10 22:47:41', '2025-01-10 22:47:41'),
	(22, 'INGRESO (+) DE PRODUCTO 5000', 5000, 24, 0, 1, '2025-01-10 22:58:59', '2025-01-10 22:58:59'),
	(23, 'INGRESO (+) DE PRODUCTO 5000', 5000, 25, 0, 1, '2025-01-10 22:59:52', '2025-01-10 22:59:52'),
	(24, 'INGRESO (+) DE PRODUCTO 5000', 5000, 26, 0, 1, '2025-01-10 23:00:59', '2025-01-10 23:00:59'),
	(25, 'INGRESO (+) DE PRODUCTO 5000', 5000, 27, 0, 1, '2025-01-10 23:02:04', '2025-01-10 23:02:04'),
	(26, 'INGRESO (+) DE PRODUCTO 5000', 5000, 28, 0, 1, '2025-01-10 23:03:01', '2025-01-10 23:03:01'),
	(27, 'INGRESO (+) DE PRODUCTO 5000', 5000, 29, 0, 1, '2025-01-10 23:03:54', '2025-01-10 23:03:54'),
	(28, 'INGRESO (+) DE PRODUCTO 5000', 5000, 30, 0, 1, '2025-01-10 23:04:42', '2025-01-10 23:04:42'),
	(29, 'INGRESO (+) DE PRODUCTO 50000', 50000, 31, 0, 1, '2025-01-10 23:06:07', '2025-01-10 23:06:07'),
	(30, 'INGRESO (+) DE PRODUCTO 5000', 5000, 32, 0, 1, '2025-01-10 23:17:27', '2025-01-10 23:17:27'),
	(31, 'INGRESO (+) DE PRODUCTO 5000', 5000, 33, 0, 1, '2025-01-10 23:18:41', '2025-01-10 23:18:41'),
	(32, 'INGRESO (+) DE PRODUCTO 5000', 5000, 34, 0, 1, '2025-01-10 23:20:26', '2025-01-10 23:20:26'),
	(33, 'INGRESO (+) DE PRODUCTO 5000', 5000, 35, 0, 1, '2025-01-10 23:21:24', '2025-01-10 23:21:24'),
	(34, 'INGRESO (+) DE PRODUCTO 5000', 5000, 36, 0, 1, '2025-01-10 23:24:25', '2025-01-10 23:24:25'),
	(35, 'INGRESO (+) DE PRODUCTO 5000', 5000, 37, 0, 1, '2025-01-10 23:26:10', '2025-01-10 23:26:10'),
	(36, 'INGRESO (+) DE PRODUCTO 5000', 5000, 38, 0, 1, '2025-01-10 23:30:14', '2025-01-10 23:30:14'),
	(37, 'INGRESO (+) DE PRODUCTO 5000', 5000, 39, 0, 1, '2025-01-10 23:31:21', '2025-01-10 23:31:21'),
	(38, 'INGRESO (+) DE PRODUCTO 5000', 5000, 40, 0, 1, '2025-01-10 23:39:34', '2025-01-10 23:39:34'),
	(39, 'INGRESO (+) DE PRODUCTO 5000', 5000, 41, 0, 1, '2025-01-10 23:41:35', '2025-01-10 23:41:35'),
	(40, 'INGRESO (+) DE PRODUCTO 5000', 5000, 42, 0, 1, '2025-01-10 23:42:35', '2025-01-10 23:42:35'),
	(41, 'INGRESO (+) DE PRODUCTO 5000', 5000, 43, 0, 1, '2025-01-10 23:48:29', '2025-01-10 23:48:29'),
	(42, 'INGRESO (+) DE PRODUCTO 5000', 5000, 44, 0, 1, '2025-01-10 23:51:42', '2025-01-10 23:51:42'),
	(43, 'INGRESO (+) DE PRODUCTO 5000', 5000, 45, 0, 1, '2025-01-10 23:53:12', '2025-01-10 23:53:12'),
	(44, 'INGRESO (+) DE PRODUCTO 500', 500, 46, 0, 1, '2025-01-10 23:54:21', '2025-01-10 23:54:21'),
	(45, 'INGRESO (+) DE PRODUCTO 5000', 5000, 47, 0, 1, '2025-01-10 23:55:18', '2025-01-10 23:55:18'),
	(46, 'INGRESO (+) DE PRODUCTO 5000', 5000, 48, 0, 1, '2025-01-10 23:56:09', '2025-01-10 23:56:09'),
	(47, 'INGRESO (+) DE PRODUCTO 5000', 5000, 49, 0, 1, '2025-01-10 23:56:58', '2025-01-10 23:56:58');

-- Volcando estructura para tabla larapos.empleados
CREATE TABLE IF NOT EXISTS `empleados` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `name` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `lastname` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `documento` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `fnacimiento` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `edad` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `genero` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `status` smallint NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=8 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

-- Volcando datos para la tabla larapos.empleados: ~1 rows (aproximadamente)
DELETE FROM `empleados`;
INSERT INTO `empleados` (`id`, `name`, `lastname`, `documento`, `fnacimiento`, `edad`, `genero`, `status`, `created_at`, `updated_at`) VALUES
	(7, 'Marcos', 'Perez', '25212293', '1994-05-18', '30', 'M', 2, '2025-01-11 23:07:46', '2025-01-11 23:08:12');

-- Volcando estructura para tabla larapos.empleado_pedido
CREATE TABLE IF NOT EXISTS `empleado_pedido` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `pedidoId` bigint unsigned NOT NULL,
  `empleadoId` bigint unsigned NOT NULL,
  `created_at` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '2025-01-10 13:24:06',
  `upated_at` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '2025-01-10 13:24:06',
  PRIMARY KEY (`id`),
  KEY `empleado_pedido_pedidoid_foreign` (`pedidoId`),
  KEY `empleado_pedido_empleadoid_foreign` (`empleadoId`),
  CONSTRAINT `empleado_pedido_empleadoid_foreign` FOREIGN KEY (`empleadoId`) REFERENCES `empleados` (`id`) ON DELETE CASCADE,
  CONSTRAINT `empleado_pedido_pedidoid_foreign` FOREIGN KEY (`pedidoId`) REFERENCES `pedidos` (`id`) ON DELETE CASCADE
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

-- Volcando datos para la tabla larapos.empleado_pedido: ~0 rows (aproximadamente)
DELETE FROM `empleado_pedido`;
INSERT INTO `empleado_pedido` (`id`, `pedidoId`, `empleadoId`, `created_at`, `upated_at`) VALUES
	(1, 1, 7, '2025-01-10 13:24:06', '2025-01-10 13:24:06');

-- Volcando estructura para tabla larapos.empresas
CREATE TABLE IF NOT EXISTS `empresas` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `name` varchar(100) COLLATE utf8mb4_unicode_ci NOT NULL,
  `documento` varchar(100) COLLATE utf8mb4_unicode_ci NOT NULL,
  `telefono` varchar(100) COLLATE utf8mb4_unicode_ci NOT NULL,
  `direccion` varchar(100) COLLATE utf8mb4_unicode_ci NOT NULL,
  `status` smallint NOT NULL,
  `logo` varchar(100) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `longitude` varchar(100) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `latitude` varchar(100) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `principal` tinyint(1) NOT NULL DEFAULT '0',
  `paisId` bigint unsigned NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `empresas_documento_unique` (`documento`),
  KEY `empresas_paisid_foreign` (`paisId`),
  CONSTRAINT `empresas_paisid_foreign` FOREIGN KEY (`paisId`) REFERENCES `pais` (`id`) ON DELETE CASCADE ON UPDATE CASCADE
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

-- Volcando datos para la tabla larapos.empresas: ~0 rows (aproximadamente)
DELETE FROM `empresas`;
INSERT INTO `empresas` (`id`, `name`, `documento`, `telefono`, `direccion`, `status`, `logo`, `longitude`, `latitude`, `principal`, `paisId`, `created_at`, `updated_at`) VALUES
	(1, 'Abastos Los Trinis', 'V-25212293-8', '04241703465', 'Caracas - Venezuela', 1, NULL, '10.4940761', '-66.9069989', 1, 6, '2025-01-10 17:24:06', '2025-01-10 17:24:06');

-- Volcando estructura para tabla larapos.exploradors
CREATE TABLE IF NOT EXISTS `exploradors` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `name` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `version` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=10 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

-- Volcando datos para la tabla larapos.exploradors: ~8 rows (aproximadamente)
DELETE FROM `exploradors`;
INSERT INTO `exploradors` (`id`, `name`, `version`, `created_at`, `updated_at`) VALUES
	(1, 'Chrome', '131.0.0.0', '2025-01-10 17:25:44', '2025-01-10 17:25:44'),
	(2, 'Chrome', '131.0.0.0', '2025-01-10 22:08:17', '2025-01-10 22:08:17'),
	(3, 'Chrome', '131.0.0.0', '2025-01-11 15:20:48', '2025-01-11 15:20:48'),
	(4, 'Chrome', '131.0.0.0', '2025-01-11 18:12:18', '2025-01-11 18:12:18'),
	(5, 'Chrome', '131.0.0.0', '2025-01-11 21:07:41', '2025-01-11 21:07:41'),
	(6, 'Chrome', '131.0.0.0', '2025-01-11 22:46:56', '2025-01-11 22:46:56'),
	(7, 'Chrome', '131.0.0.0', '2025-01-11 23:05:07', '2025-01-11 23:05:07'),
	(8, 'Chrome', '131.0.0.0', '2025-01-11 23:09:11', '2025-01-11 23:09:11'),
	(9, 'Chrome', '131.0.0.0', '2025-01-11 23:09:28', '2025-01-11 23:09:28');

-- Volcando estructura para tabla larapos.failed_jobs
CREATE TABLE IF NOT EXISTS `failed_jobs` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `uuid` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `connection` text COLLATE utf8mb4_unicode_ci NOT NULL,
  `queue` text COLLATE utf8mb4_unicode_ci NOT NULL,
  `payload` longtext COLLATE utf8mb4_unicode_ci NOT NULL,
  `exception` longtext COLLATE utf8mb4_unicode_ci NOT NULL,
  `failed_at` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
  PRIMARY KEY (`id`),
  UNIQUE KEY `failed_jobs_uuid_unique` (`uuid`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

-- Volcando datos para la tabla larapos.failed_jobs: ~0 rows (aproximadamente)
DELETE FROM `failed_jobs`;

-- Volcando estructura para tabla larapos.images
CREATE TABLE IF NOT EXISTS `images` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `path` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `producto_id` bigint unsigned NOT NULL DEFAULT '1',
  `featured` tinyint(1) NOT NULL DEFAULT '0',
  `empresaId` bigint unsigned NOT NULL DEFAULT '1',
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `images_producto_id_foreign` (`producto_id`),
  KEY `images_empresaid_foreign` (`empresaId`),
  CONSTRAINT `images_empresaid_foreign` FOREIGN KEY (`empresaId`) REFERENCES `empresas` (`id`) ON DELETE CASCADE ON UPDATE CASCADE,
  CONSTRAINT `images_producto_id_foreign` FOREIGN KEY (`producto_id`) REFERENCES `productos` (`id`) ON DELETE CASCADE ON UPDATE CASCADE
) ENGINE=InnoDB AUTO_INCREMENT=48 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

-- Volcando datos para la tabla larapos.images: ~45 rows (aproximadamente)
DELETE FROM `images`;
INSERT INTO `images` (`id`, `path`, `producto_id`, `featured`, `empresaId`, `created_at`, `updated_at`) VALUES
	(1, '1736612054.jpeg', 3, 0, 1, '2025-01-10 17:32:30', '2025-01-11 16:14:14'),
	(2, '1736612011.webp', 4, 0, 1, '2025-01-10 17:33:58', '2025-01-11 16:13:31'),
	(3, '1736611963.webp', 5, 0, 1, '2025-01-10 17:42:03', '2025-01-11 16:12:43'),
	(4, '1736612339.png', 6, 0, 1, '2025-01-10 17:45:07', '2025-01-11 16:18:59'),
	(5, '1736611564.png', 7, 0, 1, '2025-01-10 17:46:31', '2025-01-11 16:06:04'),
	(6, '1736611450.jpeg', 8, 0, 1, '2025-01-10 17:51:38', '2025-01-11 16:04:10'),
	(7, '1736611431.webp', 9, 0, 1, '2025-01-10 17:53:13', '2025-01-11 16:03:51'),
	(8, '1736611384.webp', 10, 0, 1, '2025-01-10 17:54:33', '2025-01-11 16:03:04'),
	(9, '1736611280.jpeg', 11, 0, 1, '2025-01-10 22:11:46', '2025-01-11 16:01:20'),
	(10, '1736611201.webp', 12, 0, 1, '2025-01-10 22:12:55', '2025-01-11 16:00:01'),
	(11, '1736612872.webp', 13, 0, 1, '2025-01-10 22:14:29', '2025-01-11 16:27:52'),
	(12, '1736612522.png', 14, 0, 1, '2025-01-10 22:16:16', '2025-01-11 16:22:02'),
	(13, '1736611044.png', 15, 0, 1, '2025-01-10 22:18:53', '2025-01-11 15:57:24'),
	(14, '1736612254.png', 16, 0, 1, '2025-01-10 22:20:59', '2025-01-11 16:17:34'),
	(15, '1736610903.webp', 17, 0, 1, '2025-01-10 22:22:44', '2025-01-11 15:55:03'),
	(16, '1736611369.webp', 18, 0, 1, '2025-01-10 22:25:03', '2025-01-11 16:02:49'),
	(17, '1736548083.png', 19, 0, 1, '2025-01-10 22:28:03', '2025-01-10 22:28:03'),
	(18, '1736610748.jpeg', 20, 0, 1, '2025-01-10 22:30:28', '2025-01-11 15:52:28'),
	(19, '1736610728.jpeg', 21, 0, 1, '2025-01-10 22:31:53', '2025-01-11 15:52:08'),
	(20, '1736609821.jpeg', 22, 0, 1, '2025-01-10 22:38:19', '2025-01-11 15:37:01'),
	(21, '1736612975.webp', 23, 0, 1, '2025-01-10 22:47:41', '2025-01-11 16:29:35'),
	(22, '1736613229.jpg', 24, 0, 1, '2025-01-10 22:58:59', '2025-01-11 16:33:49'),
	(23, '1736613328.jpg', 25, 0, 1, '2025-01-10 22:59:52', '2025-01-11 16:35:28'),
	(24, '1736613953.jpg', 26, 0, 1, '2025-01-10 23:00:59', '2025-01-11 16:45:53'),
	(25, '1736613525.webp', 27, 0, 1, '2025-01-10 23:02:04', '2025-01-11 16:38:45'),
	(26, '1736613601.webp', 28, 0, 1, '2025-01-10 23:03:01', '2025-01-11 16:40:01'),
	(27, '1736614517.png', 29, 0, 1, '2025-01-10 23:03:54', '2025-01-11 16:55:17'),
	(28, '1736614410.png', 30, 0, 1, '2025-01-10 23:04:42', '2025-01-11 16:53:30'),
	(29, '1736550367.png', 31, 0, 1, '2025-01-10 23:06:07', '2025-01-10 23:06:07'),
	(30, '1736614733.jpg', 32, 0, 1, '2025-01-10 23:17:27', '2025-01-11 16:58:53'),
	(31, '1736614769.avif', 33, 0, 1, '2025-01-10 23:18:41', '2025-01-11 16:59:29'),
	(32, '1736614863.webp', 34, 0, 1, '2025-01-10 23:20:26', '2025-01-11 17:01:03'),
	(33, '1736615557.webp', 35, 0, 1, '2025-01-10 23:21:24', '2025-01-11 17:12:37'),
	(34, '1736615537.jpeg', 36, 0, 1, '2025-01-10 23:24:25', '2025-01-11 17:12:17'),
	(35, '1736615020.jpg', 37, 0, 1, '2025-01-10 23:26:10', '2025-01-11 17:03:40'),
	(36, '1736615105.webp', 38, 0, 1, '2025-01-10 23:30:14', '2025-01-11 17:05:05'),
	(37, '1736615257.jpg', 39, 0, 1, '2025-01-10 23:31:21', '2025-01-11 17:07:37'),
	(38, '1736613636.png', 40, 0, 1, '2025-01-10 23:39:34', '2025-01-11 16:40:36'),
	(39, '1736615364.webp', 41, 0, 1, '2025-01-10 23:41:34', '2025-01-11 17:09:24'),
	(40, '1736615421.jpg', 42, 0, 1, '2025-01-10 23:42:35', '2025-01-11 17:10:21'),
	(41, '1736552909.png', 43, 0, 1, '2025-01-10 23:48:29', '2025-01-10 23:48:29'),
	(42, '1736553125.png', 44, 0, 1, '2025-01-10 23:51:42', '2025-01-10 23:52:05'),
	(43, '1736553192.png', 45, 0, 1, '2025-01-10 23:53:12', '2025-01-10 23:53:12'),
	(44, '1736553261.png', 46, 0, 1, '2025-01-10 23:54:21', '2025-01-10 23:54:21'),
	(45, '1736553318.png', 47, 0, 1, '2025-01-10 23:55:18', '2025-01-10 23:55:18'),
	(46, '1736553369.png', 48, 0, 1, '2025-01-10 23:56:09', '2025-01-10 23:56:09'),
	(47, '1736553418.png', 49, 0, 1, '2025-01-10 23:56:58', '2025-01-10 23:56:58');

-- Volcando estructura para tabla larapos.marcas
CREATE TABLE IF NOT EXISTS `marcas` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `name` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `status` smallint NOT NULL,
  `empresaId` bigint unsigned NOT NULL DEFAULT '1',
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `marcas_empresaid_foreign` (`empresaId`),
  CONSTRAINT `marcas_empresaid_foreign` FOREIGN KEY (`empresaId`) REFERENCES `empresas` (`id`) ON DELETE CASCADE ON UPDATE CASCADE
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

-- Volcando datos para la tabla larapos.marcas: ~0 rows (aproximadamente)
DELETE FROM `marcas`;
INSERT INTO `marcas` (`id`, `name`, `status`, `empresaId`, `created_at`, `updated_at`) VALUES
	(1, 'Generico', 1, 1, '2025-01-10 17:24:07', '2025-01-10 17:24:07');

-- Volcando estructura para tabla larapos.migrations
CREATE TABLE IF NOT EXISTS `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 AUTO_INCREMENT=35 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

-- Volcando datos para la tabla larapos.migrations: ~0 rows (aproximadamente)
DELETE FROM `migrations`;
INSERT INTO `migrations` (`id`, `migration`, `batch`) VALUES
	(1, '2012_07_30_000333_create_pais_table', 1),
	(2, '2013_12_09_014301_create_empresas_table', 1),
	(3, '2013_12_11_151533_create_roles_table', 1),
	(4, '2014_10_12_000000_create_users_table', 1),
	(5, '2014_10_12_100000_create_password_reset_tokens_table', 1),
	(6, '2018_09_12_99999_create_backupverify_table', 1),
	(7, '2019_08_19_000000_create_failed_jobs_table', 1),
	(8, '2019_12_14_000001_create_personal_access_tokens_table', 1),
	(9, '2023_12_07_185351_create_modulos_table', 1),
	(10, '2023_12_10_232007_create_permissions_table', 1),
	(11, '2023_12_11_155006_create_permission_role_pivot_table', 1),
	(12, '2023_12_11_155233_create_role_user_pivot_table', 1),
	(13, '2023_12_13_235311_create_logins_table', 1),
	(14, '2024_02_01_173456_create_exploradors_table', 1),
	(15, '2024_02_01_184603_create_tipo_dispositivos_table', 1),
	(16, '2024_11_11_111348_create_categorias_table', 1),
	(17, '2024_11_11_120722_create_marcas_table', 1),
	(18, '2024_11_11_142127_create_productos_table', 1),
	(19, '2024_11_11_150638_create_product_variants_table', 1),
	(20, '2024_11_11_165614_create_images_table', 1),
	(21, '2024_11_12_151819_create_detalle_producto_table', 1),
	(22, '2024_11_14_122414_create_wishlists_table', 1),
	(23, '2024_11_28_152036_create_tasas_table', 1),
	(24, '2024_12_04_083315_create_pedidos_table', 1),
	(25, '2024_12_04_083326_create_detalle_pedidos_table', 1),
	(26, '2024_12_04_084950_create_series_table', 1),
	(27, '2024_12_17_220821_create_empleados_table', 1),
	(28, '2024_12_18_094143_create_cupones_table', 1),
	(29, '2024_12_19_133659_create_empleado_pedido_table', 1),
	(30, '2024_12_19_134937_add_empleado_id_column_on_users_table', 1),
	(31, '2024_12_23_132638_create_cajas_table', 1),
	(32, '2024_12_23_133755_create_arqueo_cajas_table', 1),
	(33, '2024_12_23_134937_add_empleado_id_column_on_pedidos_table', 1),
	(34, '2024_12_23_200523_create_pedido_pago_table', 1);

-- Volcando estructura para tabla larapos.modulos
CREATE TABLE IF NOT EXISTS `modulos` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `name` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `deleted_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

-- Volcando datos para la tabla larapos.modulos: ~0 rows (aproximadamente)
DELETE FROM `modulos`;

-- Volcando estructura para tabla larapos.pais
CREATE TABLE IF NOT EXISTS `pais` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `prefijo` varchar(6) COLLATE utf8mb4_unicode_ci NOT NULL,
  `descripcion` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `codigo_telefono` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `estado` int NOT NULL,
  `signo` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `moneda` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=13 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

-- Volcando datos para la tabla larapos.pais: ~12 rows (aproximadamente)
DELETE FROM `pais`;
INSERT INTO `pais` (`id`, `prefijo`, `descripcion`, `codigo_telefono`, `estado`, `signo`, `moneda`, `created_at`, `updated_at`) VALUES
	(1, 'AR', 'ARGENTINA', '+54', 0, '$', 'PESOS', '2025-01-10 17:24:06', '2025-01-10 17:24:06'),
	(2, 'CH', 'CHILE', '+56', 0, '$', 'PESOS', '2025-01-10 17:24:06', '2025-01-10 17:24:06'),
	(3, 'COL', 'COLOMBIA', '+57', 0, '$', 'PESOS', '2025-01-10 17:24:06', '2025-01-10 17:24:06'),
	(4, 'USA', 'ESTADOS UNIDOS', '+1', 0, '$', 'DÓLAR', '2025-01-10 17:24:06', '2025-01-10 17:24:06'),
	(5, 'PE', 'PERU', '+51', 0, 'S/', 'SOLES', '2025-01-10 17:24:06', '2025-01-10 17:24:06'),
	(6, 'VEN', 'VENEZUELA', '+58', 1, 'BS', 'BOLIVARES', '2025-01-10 17:24:06', '2025-01-10 17:24:06'),
	(7, 'BOL', 'BOLIVIA', '+591', 0, '$b', 'PESOS', '2025-01-10 17:24:06', '2025-01-10 17:24:06'),
	(8, 'MEX', 'MEXICO', '+52', 0, '$', 'MX', '2025-01-10 17:24:06', '2025-01-10 17:24:06'),
	(9, 'PAR', 'PARAGUAY', '+595', 0, '₲', 'GUARANIES', '2025-01-10 17:24:06', '2025-01-10 17:24:06'),
	(10, 'RD', 'REPUBLICA DOMINICANA', '+1-809', 0, 'RD$', 'PESOS', '2025-01-10 17:24:06', '2025-01-10 17:24:06'),
	(11, 'CU', 'CUBA', '+53', 0, '$', 'PESOS', '2025-01-10 17:24:06', '2025-01-10 17:24:06'),
	(12, 'GT', 'GUATEMALA', '+502', 0, 'Q', 'QUETZALES', '2025-01-10 17:24:06', '2025-01-10 17:24:06');

-- Volcando estructura para tabla larapos.pedidos
CREATE TABLE IF NOT EXISTS `pedidos` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `fecha` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '2025-01-10',
  `total_usd` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `total_bs` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `codigo` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `metodo_pago` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `ubicacion` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `longitud` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `latitud` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `estado` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `empresaId` bigint unsigned NOT NULL,
  `empleadoId` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `userId` bigint unsigned NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `pedidos_empresaid_foreign` (`empresaId`),
  KEY `pedidos_userid_foreign` (`userId`),
  CONSTRAINT `pedidos_empresaid_foreign` FOREIGN KEY (`empresaId`) REFERENCES `empresas` (`id`) ON DELETE CASCADE,
  CONSTRAINT `pedidos_userid_foreign` FOREIGN KEY (`userId`) REFERENCES `users` (`id`) ON DELETE CASCADE
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

-- Volcando datos para la tabla larapos.pedidos: ~0 rows (aproximadamente)
DELETE FROM `pedidos`;
INSERT INTO `pedidos` (`id`, `fecha`, `total_usd`, `total_bs`, `codigo`, `metodo_pago`, `ubicacion`, `longitud`, `latitud`, `estado`, `empresaId`, `empleadoId`, `userId`, `created_at`, `updated_at`) VALUES
	(1, '2025-01-11', '14.725', '703.855', '9602767', 'Bolívares', 'BBVA Provincial, Avenida Principal de Bello Monte, Colinas de Bello Monte, Bello Monte, Caracas, Parroquia Nuestra Señora del Rosario, Municipio Libertador, Estado Miranda, 1050, Venezuela', '-66.8738', '10.4873', 'Asignado', 1, '7', 2, '2025-01-11 23:04:26', '2025-01-11 23:08:12');

-- Volcando estructura para tabla larapos.pedido_pago
CREATE TABLE IF NOT EXISTS `pedido_pago` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `fecha` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '2025-01-10',
  `total_usd` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `referencia` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `metodo_pago` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `empresaId` bigint unsigned NOT NULL,
  `userId` bigint unsigned NOT NULL,
  `pedidoId` bigint unsigned NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `pedido_pago_empresaid_foreign` (`empresaId`),
  KEY `pedido_pago_userid_foreign` (`userId`),
  KEY `pedido_pago_pedidoid_foreign` (`pedidoId`),
  CONSTRAINT `pedido_pago_empresaid_foreign` FOREIGN KEY (`empresaId`) REFERENCES `empresas` (`id`) ON DELETE CASCADE,
  CONSTRAINT `pedido_pago_pedidoid_foreign` FOREIGN KEY (`pedidoId`) REFERENCES `pedidos` (`id`) ON DELETE CASCADE,
  CONSTRAINT `pedido_pago_userid_foreign` FOREIGN KEY (`userId`) REFERENCES `users` (`id`) ON DELETE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

-- Volcando datos para la tabla larapos.pedido_pago: ~0 rows (aproximadamente)
DELETE FROM `pedido_pago`;

-- Volcando estructura para tabla larapos.permissions
CREATE TABLE IF NOT EXISTS `permissions` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `name` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `descripcion` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `slug` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `status` smallint NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `deleted_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `permissions_name_unique` (`name`)
) ENGINE=InnoDB AUTO_INCREMENT=57 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

-- Volcando datos para la tabla larapos.permissions: ~56 rows (aproximadamente)
DELETE FROM `permissions`;
INSERT INTO `permissions` (`id`, `name`, `descripcion`, `slug`, `status`, `created_at`, `updated_at`, `deleted_at`) VALUES
	(1, 'seguridad_access', 'Seguridad', 'Modulos', 1, '2025-01-10 17:24:06', '2025-01-10 17:24:06', NULL),
	(2, 'configuracion_access', 'Configuracion', 'Modulos', 1, '2025-01-10 17:24:06', '2025-01-10 17:24:06', NULL),
	(3, 'database_access', 'Panel de respaldo', 'Modulos', 1, '2025-01-10 17:24:06', '2025-01-10 17:24:06', NULL),
	(4, 'empresa_access', 'Acceso', 'Empresas', 1, '2025-01-10 17:24:06', '2025-01-10 17:24:06', NULL),
	(5, 'empresa_create', 'Registro', 'Empresas', 1, '2025-01-10 17:24:06', '2025-01-10 17:24:06', NULL),
	(6, 'empresa_edit', 'Edición', 'Empresas', 1, '2025-01-10 17:24:06', '2025-01-10 17:24:06', NULL),
	(7, 'empresa_delete', 'Borrar', 'Empresas', 1, '2025-01-10 17:24:06', '2025-01-10 17:24:06', NULL),
	(8, 'role_access', 'Acceso', 'Roles', 1, '2025-01-10 17:24:06', '2025-01-10 17:24:06', NULL),
	(9, 'role_create', 'Registro', 'Roles', 1, '2025-01-10 17:24:06', '2025-01-10 17:24:06', NULL),
	(10, 'role_edit', 'Edición', 'Roles', 1, '2025-01-10 17:24:06', '2025-01-10 17:24:06', NULL),
	(11, 'role_delete', 'Borrar', 'Roles', 1, '2025-01-10 17:24:06', '2025-01-10 17:24:06', NULL),
	(12, 'permission_access', 'Acceso', 'Permisos', 1, '2025-01-10 17:24:06', '2025-01-10 17:24:06', NULL),
	(13, 'permission_create', 'Registro', 'Permisos', 1, '2025-01-10 17:24:06', '2025-01-10 17:24:06', NULL),
	(14, 'permission_edit', 'Edición', 'Permisos', 1, '2025-01-10 17:24:06', '2025-01-10 17:24:06', NULL),
	(15, 'permission_delete', 'Borrar', 'Permisos', 1, '2025-01-10 17:24:06', '2025-01-10 17:24:06', NULL),
	(16, 'user_access', 'Acceso', 'Usuarios', 1, '2025-01-10 17:24:06', '2025-01-10 17:24:06', NULL),
	(17, 'logins_access', 'Logins', 'Usuarios', 1, '2025-01-10 17:24:06', '2025-01-10 17:24:06', NULL),
	(18, 'user_create', 'Registro', 'Usuarios', 1, '2025-01-10 17:24:06', '2025-01-10 17:24:06', NULL),
	(19, 'user_edit', 'Edición', 'Usuarios', 1, '2025-01-10 17:24:06', '2025-01-10 17:24:06', NULL),
	(20, 'user_delete', 'Borrar', 'Usuarios', 1, '2025-01-10 17:24:06', '2025-01-10 17:24:06', NULL),
	(21, 'paises_access', 'Acceso', 'Paises', 1, '2025-01-10 17:24:06', '2025-01-10 17:24:06', NULL),
	(22, 'paises_create', 'Registro', 'Paises', 1, '2025-01-10 17:24:06', '2025-01-10 17:24:06', NULL),
	(23, 'paises_edit', 'Edición', 'Paises', 1, '2025-01-10 17:24:06', '2025-01-10 17:24:06', NULL),
	(24, 'paises_delete', 'Borrar', 'Paises', 1, '2025-01-10 17:24:06', '2025-01-10 17:24:06', NULL),
	(25, 'backup_access', 'Acceso', 'Backup', 1, '2025-01-10 17:24:06', '2025-01-10 17:24:06', NULL),
	(26, 'backup_db', 'Respaldo DB', 'Backup', 1, '2025-01-10 17:24:06', '2025-01-10 17:24:06', NULL),
	(27, 'backup_files', 'Respaldo general', 'Backup', 1, '2025-01-10 17:24:06', '2025-01-10 17:24:06', NULL),
	(28, 'backup_download', 'Descargar', 'Backup', 1, '2025-01-10 17:24:06', '2025-01-10 17:24:06', NULL),
	(29, 'backup_delete', 'Borrar', 'Backup', 1, '2025-01-10 17:24:06', '2025-01-10 17:24:06', NULL),
	(30, 'categoria_access', 'Categorias', 'Producto', 1, '2025-01-10 17:24:06', '2025-01-10 17:24:06', NULL),
	(31, 'marca_access', 'Marcas', 'Producto', 1, '2025-01-10 17:24:06', '2025-01-10 17:24:06', NULL),
	(32, 'producto_access', 'Acceso', 'Productos', 1, '2025-01-10 17:24:06', '2025-01-10 17:24:06', NULL),
	(33, 'producto_create', 'Crear', 'Productos', 1, '2025-01-10 17:24:06', '2025-01-10 17:24:06', NULL),
	(34, 'producto_edit', 'Editar', 'Productos', 1, '2025-01-10 17:24:06', '2025-01-10 17:24:06', NULL),
	(35, 'producto_delete', 'Eliminar', 'Productos', 1, '2025-01-10 17:24:06', '2025-01-10 17:24:06', NULL),
	(36, 'tasa_access', 'Acceso', 'Tasa del dólar', 1, '2025-01-10 17:24:06', '2025-01-10 17:24:06', NULL),
	(37, 'tasa_create', 'Registro', 'Tasa del dólar', 1, '2025-01-10 17:24:06', '2025-01-10 17:24:06', NULL),
	(38, 'tasa_edit', 'Edición', 'Tasa del dólar', 1, '2025-01-10 17:24:06', '2025-01-10 17:24:06', NULL),
	(39, 'tasa_delete', 'Borrar', 'Tasa del dólar', 1, '2025-01-10 17:24:06', '2025-01-10 17:24:06', NULL),
	(40, 'pedido_access', 'Acceso', 'Pedidos', 1, '2025-01-10 17:24:06', '2025-01-10 17:24:06', NULL),
	(41, 'pedido_asignar', 'Asignar', 'Pedidos', 1, '2025-01-10 17:24:06', '2025-01-10 17:24:06', NULL),
	(42, 'pedido_delete', 'Borrar', 'Pedidos', 1, '2025-01-10 17:24:06', '2025-01-10 17:24:06', NULL),
	(43, 'empleado_access', 'Acceso', 'Empleados', 1, '2025-01-10 17:24:06', '2025-01-10 17:24:06', NULL),
	(44, 'empleado_create', 'Registro', 'Empleados', 1, '2025-01-10 17:24:06', '2025-01-10 17:24:06', NULL),
	(45, 'empleado_edit', 'Edición', 'Empleados', 1, '2025-01-10 17:24:06', '2025-01-10 17:24:06', NULL),
	(46, 'empleado_delete', 'Borrar', 'Empleados', 1, '2025-01-10 17:24:06', '2025-01-10 17:24:06', NULL),
	(47, 'cupones_access', 'Acceso', 'Cupones', 1, '2025-01-10 17:24:06', '2025-01-10 17:24:06', NULL),
	(48, 'cupones_create', 'Registro', 'Cupones', 1, '2025-01-10 17:24:06', '2025-01-10 17:24:06', NULL),
	(49, 'cupones_edit', 'Edición', 'Cupones', 1, '2025-01-10 17:24:06', '2025-01-10 17:24:06', NULL),
	(50, 'cupones_delete', 'Borrar', 'Cupones', 1, '2025-01-10 17:24:06', '2025-01-10 17:24:06', NULL),
	(51, 'arqueo_access', 'Acceso', 'Arqueo de Caja', 1, '2025-01-10 17:24:06', '2025-01-10 17:24:06', NULL),
	(52, 'apertura_access', 'Apertura', 'Arqueo de Caja', 1, '2025-01-10 17:24:06', '2025-01-10 17:24:06', NULL),
	(53, 'cierre_access', 'Cierre', 'Arqueo de Caja', 1, '2025-01-10 17:24:06', '2025-01-10 17:24:06', NULL),
	(54, 'detalle_access', 'Ver Detalle', 'Arqueo de Caja', 1, '2025-01-10 17:24:06', '2025-01-10 17:24:06', NULL),
	(55, 'resumen_access', 'Ver Resumen', 'Arqueo de Caja', 1, '2025-01-10 17:24:06', '2025-01-10 17:24:06', NULL),
	(56, 'descargar_access', 'Descargar reporte', 'Arqueo de Caja', 1, '2025-01-10 17:24:06', '2025-01-10 17:24:06', NULL);

-- Volcando estructura para tabla larapos.permission_role
CREATE TABLE IF NOT EXISTS `permission_role` (
  `role_id` bigint unsigned NOT NULL,
  `permission_id` bigint unsigned NOT NULL,
  KEY `permission_role_role_id_foreign` (`role_id`),
  KEY `permission_role_permission_id_foreign` (`permission_id`),
  CONSTRAINT `permission_role_permission_id_foreign` FOREIGN KEY (`permission_id`) REFERENCES `permissions` (`id`) ON DELETE CASCADE,
  CONSTRAINT `permission_role_role_id_foreign` FOREIGN KEY (`role_id`) REFERENCES `roles` (`id`) ON DELETE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

-- Volcando datos para la tabla larapos.permission_role: ~56 rows (aproximadamente)
DELETE FROM `permission_role`;
INSERT INTO `permission_role` (`role_id`, `permission_id`) VALUES
	(1, 1),
	(1, 2),
	(1, 3),
	(1, 4),
	(1, 5),
	(1, 6),
	(1, 7),
	(1, 8),
	(1, 9),
	(1, 10),
	(1, 11),
	(1, 12),
	(1, 13),
	(1, 14),
	(1, 15),
	(1, 16),
	(1, 17),
	(1, 18),
	(1, 19),
	(1, 20),
	(1, 21),
	(1, 22),
	(1, 23),
	(1, 24),
	(1, 25),
	(1, 26),
	(1, 27),
	(1, 28),
	(1, 29),
	(1, 30),
	(1, 31),
	(1, 32),
	(1, 33),
	(1, 34),
	(1, 35),
	(1, 36),
	(1, 37),
	(1, 38),
	(1, 39),
	(1, 40),
	(1, 41),
	(1, 42),
	(1, 43),
	(1, 44),
	(1, 45),
	(1, 46),
	(1, 47),
	(1, 48),
	(1, 49),
	(1, 50),
	(1, 51),
	(1, 52),
	(1, 53),
	(1, 54),
	(1, 55),
	(1, 56),
	(4, 40),
	(4, 42),
	(4, 41);

-- Volcando estructura para tabla larapos.productos
CREATE TABLE IF NOT EXISTS `productos` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `code` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '678157b528af4',
  `name` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `price` decimal(5,2) NOT NULL,
  `description` text COLLATE utf8mb4_unicode_ci,
  `quantity` int NOT NULL DEFAULT '100',
  `quantity_alert` int NOT NULL DEFAULT '10',
  `status` smallint NOT NULL DEFAULT '1',
  `empresaId` bigint unsigned NOT NULL DEFAULT '1',
  `categoriaId` bigint unsigned NOT NULL DEFAULT '1',
  `marcaId` bigint unsigned NOT NULL DEFAULT '1',
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `productos_empresaid_foreign` (`empresaId`),
  KEY `productos_categoriaid_foreign` (`categoriaId`),
  KEY `productos_marcaid_foreign` (`marcaId`),
  CONSTRAINT `productos_categoriaid_foreign` FOREIGN KEY (`categoriaId`) REFERENCES `categorias` (`id`) ON DELETE CASCADE ON UPDATE CASCADE,
  CONSTRAINT `productos_empresaid_foreign` FOREIGN KEY (`empresaId`) REFERENCES `empresas` (`id`) ON DELETE CASCADE ON UPDATE CASCADE,
  CONSTRAINT `productos_marcaid_foreign` FOREIGN KEY (`marcaId`) REFERENCES `marcas` (`id`) ON DELETE CASCADE ON UPDATE CASCADE
) ENGINE=InnoDB AUTO_INCREMENT=50 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

-- Volcando datos para la tabla larapos.productos: ~45 rows (aproximadamente)
DELETE FROM `productos`;
INSERT INTO `productos` (`id`, `code`, `name`, `price`, `description`, `quantity`, `quantity_alert`, `status`, `empresaId`, `categoriaId`, `marcaId`, `created_at`, `updated_at`) VALUES
	(3, '678159ae8e79c', 'Refrescos glup 6x2', 5.50, 'Refrescos marca Glup de 6 unidades 2 LT C/U', 5000, 10, 1, 1, 2, 1, '2025-01-10 17:32:30', '2025-01-11 16:14:14'),
	(4, '67815a060d306', 'Bebida energizante speed de lata', 10.00, '6 Unidades de Bebida energizante Speed de lata', 5000, 10, 1, 1, 2, 1, '2025-01-10 17:33:58', '2025-01-11 16:13:31'),
	(5, '67815beb60cd8', 'Bebida energizante Speed Max', 12.00, 'Bebida energizante de 1 LT', 5000, 10, 1, 1, 2, 1, '2025-01-10 17:42:03', '2025-01-11 16:12:43'),
	(6, '67815ca36941a', 'Refresco de Uva HIT', 6.00, 'Refresco sabor a Uva, 6 Unidades de  2 LT C/U', 5000, 10, 1, 1, 2, 1, '2025-01-10 17:45:07', '2025-01-11 16:31:14'),
	(7, '67815cf714ac4', ' Refresco de Naranja HIT', 4.00, 'Refresco sabor a Naranja , 6 Unidades de 1 LT C/U', 5000, 10, 1, 1, 2, 1, '2025-01-10 17:46:31', '2025-01-11 16:06:04'),
	(8, '67815e2ad9ed8', 'Frutea 6x1,5', 4.50, 'Bebida refrescante sabor a Limón y Durazno, 6 Unidades de 1.5 LT', 5000, 10, 1, 1, 2, 1, '2025-01-10 17:51:38', '2025-01-11 16:04:10'),
	(9, '67815e8966173', 'Jugos valencia 12X1', 11.00, 'Jugos naturales Sabor a Naranja y Durazno ', 5000, 10, 1, 1, 2, 1, '2025-01-10 17:53:13', '2025-01-11 16:03:51'),
	(10, '67815ed9246f3', 'Agua 2x5', 3.50, 'Agua 100% natural 2 unidades de 5 LT', 5000, 10, 1, 1, 2, 1, '2025-01-10 17:54:33', '2025-01-11 16:03:04'),
	(11, '67819b220d98f', 'Malta desechable', 8.50, 'Malta desechable 12x250', 5000, 10, 1, 1, 2, 1, '2025-01-10 22:11:46', '2025-01-11 16:01:20'),
	(12, '67819b678215c', 'Agua', 7.00, 'Agua potable 100% natural   24x500', 5000, 10, 1, 1, 2, 1, '2025-01-10 22:12:55', '2025-01-11 16:00:01'),
	(13, '67819bc55dcbe', 'Refresco Chinotto', 5.50, 'Refresco Chinotto 6x1', 5000, 10, 1, 1, 2, 1, '2025-01-10 22:14:29', '2025-01-11 16:31:17'),
	(14, '67819c3086cf3', 'Refresco Cola Cola Original', 5.50, 'Coca cola 6x1', 5000, 10, 1, 1, 2, 1, '2025-01-10 22:16:16', '2025-01-11 16:22:12'),
	(15, '67819ccd76cc3', 'Refresco de Naranja 2 LT', 6.00, 'Refresco (HIT) con sabor a Naranja 6x2', 5000, 10, 1, 1, 2, 1, '2025-01-10 22:18:53', '2025-01-11 15:57:24'),
	(16, '67819d4b8f6c6', ' Refresco de Uva1 LT', 4.00, 'Refresco (HIT) con sabor a Uva1 6x1', 5000, 10, 1, 1, 2, 1, '2025-01-10 22:20:59', '2025-01-11 16:17:39'),
	(17, '67819db4e8f73', 'Malta retornable', 14.00, 'Malta Maltín Polar 36x222', 5000, 10, 1, 1, 2, 1, '2025-01-10 22:22:44', '2025-01-11 15:55:03'),
	(18, '67819e3f941db', 'Agua potable', 6.00, 'Agua potable marca Heleal 12x1.5', 5000, 10, 1, 1, 2, 1, '2025-01-10 22:25:03', '2025-01-11 15:53:59'),
	(19, '67819ef36354f', 'Gatorade', 22.00, 'Bebida energizante 12x1', 5000, 10, 1, 1, 2, 1, '2025-01-10 22:28:03', '2025-01-10 22:47:59'),
	(20, '67819f848fd33', 'Gatorade ', 12.00, 'Bebida energizante 12x500', 5000, 10, 1, 1, 2, 1, '2025-01-10 22:30:28', '2025-01-11 15:52:28'),
	(21, '67819fd936dec', 'Refresco glup', 8.00, 'Refrescos GLUP 12X1', 5000, 10, 1, 1, 2, 1, '2025-01-10 22:31:53', '2025-01-11 15:52:08'),
	(22, '6781a15b80888', 'Jugo Justy', 8.50, 'Jugo de naranja  12x1,5', 5000, 10, 1, 1, 2, 1, '2025-01-10 22:38:19', '2025-01-11 15:37:01'),
	(23, '6781a38d6e319', 'Malta', 12.00, 'Malta Maltín Polar 6x1,5', 5000, 10, 1, 1, 2, 1, '2025-01-10 22:47:41', '2025-01-11 16:29:40'),
	(24, '6781a6330b83d', 'Mantequilla deline', 21.00, 'Mantequilla Deline de 250 Y 500 MG', 5000, 10, 1, 1, 1, 1, '2025-01-10 22:58:59', '2025-01-11 16:33:55'),
	(25, '6781a668753a9', 'Aceite comestible', 34.00, 'Aceite comestible COAMO', 5000, 10, 1, 1, 1, 1, '2025-01-10 22:59:52', '2025-01-11 16:35:33'),
	(26, '6781a6abeadcf', 'Galletas Ranchero', 25.00, 'Galletas Ranchero con sabor a Coco', 5000, 10, 1, 1, 1, 1, '2025-01-10 23:00:59', '2025-01-11 16:46:40'),
	(27, '6781a6ecf0a6a', 'Arroz', 25.00, 'Arroz comestible tipo A Agua Blanca 24x1', 5000, 10, 1, 1, 1, 1, '2025-01-10 23:02:04', '2025-01-11 16:38:53'),
	(28, '6781a72591d06', 'Leche condensada', 29.00, 'Leche condensada Cremor', 5000, 10, 1, 1, 1, 1, '2025-01-10 23:03:01', '2025-01-11 16:40:48'),
	(29, '6781a75aa318b', 'Pasta corta', 16.00, 'Pasta Allegri', 5000, 10, 1, 1, 1, 1, '2025-01-10 23:03:54', '2025-01-11 16:55:22'),
	(30, '6781a78abfe01', 'Pasta Larga', 16.00, 'Pasta Allegri', 5000, 10, 1, 1, 1, 1, '2025-01-10 23:04:42', '2025-01-11 16:53:34'),
	(31, '6781a7df75658', 'Sal', 7.50, 'Sal Celestial 25x1', 5000, 10, 1, 1, 1, 1, '2025-01-10 23:06:07', '2025-01-10 23:06:07'),
	(32, '6781aa879f3d3', 'Arroz', 38.50, 'Arroz May Esmeralda 24x1', 5000, 10, 1, 1, 1, 1, '2025-01-10 23:17:27', '2025-01-11 17:10:50'),
	(33, '6781aad1964e5', 'Sopa maggi', 10.00, 'Sobres de Sopa maggi', 5000, 10, 1, 1, 1, 1, '2025-01-10 23:18:41', '2025-01-11 17:10:49'),
	(34, '6781ab3a35be0', 'Harina de trigo', 14.50, 'Harina de Trigo Doña Maria', 5000, 10, 1, 1, 1, 1, '2025-01-10 23:20:26', '2025-01-11 17:10:47'),
	(35, '6781ab7428167', 'Cubitos', 12.00, 'Cubitos Maggi', 5000, 10, 1, 1, 1, 1, '2025-01-10 23:21:24', '2025-01-11 17:12:41'),
	(36, '6781ac29e1184', 'Harina de Maiz', 14.50, 'Harina de Maíz precocida Kaly 20x1', 5000, 10, 1, 1, 1, 1, '2025-01-10 23:24:25', '2025-01-11 17:12:21'),
	(37, '6781ac921f99e', 'Arroz rojo superior', 25.00, 'Arroz Mary rojo superior ', 5000, 10, 1, 1, 1, 1, '2025-01-10 23:26:10', '2025-01-11 17:10:42'),
	(38, '6781ad860a79b', 'Azúcar', 24.00, 'Azucar refinada Montalbán', 5000, 10, 1, 1, 1, 1, '2025-01-10 23:30:14', '2025-01-11 17:10:40'),
	(39, '6781adc943d54', 'Atún', 54.00, 'Atún puro lomo Willinger', 5000, 10, 1, 1, 1, 1, '2025-01-10 23:31:21', '2025-01-11 17:10:38'),
	(40, '6781afb66d12a', 'Leche en polvo', 63.00, 'Leche en polvo Dobon 50x200', 5000, 10, 1, 1, 1, 1, '2025-01-10 23:39:34', '2025-01-11 16:40:46'),
	(41, '6781b02ef385f', 'Galletas Salticos', 50.00, 'Galletas Salticos 24x7', 5000, 10, 1, 1, 1, 1, '2025-01-10 23:41:34', '2025-01-11 17:10:35'),
	(42, '6781b06b67061', 'Harina PAN', 18.50, 'Harina de Maíz Precocida 20x1', 5000, 10, 1, 1, 1, 1, '2025-01-10 23:42:35', '2025-01-11 17:10:33'),
	(43, '6781b1cd4e200', 'Papel Higiénico', 8.00, 'Papel higiénico Luciano 12x4', 5000, 10, 1, 1, 3, 1, '2025-01-10 23:48:29', '2025-01-10 23:48:29'),
	(44, '6781b28e3f219', 'Suavitel', 26.00, 'Soflan  de Suavitel 56x200 surtidas', 5000, 10, 1, 1, 3, 1, '2025-01-10 23:51:42', '2025-01-10 23:51:42'),
	(45, '6781b2e870f28', 'Detergente Alive', 19.00, 'Detergente alivet azul 24x500', 5000, 10, 1, 1, 3, 1, '2025-01-10 23:53:12', '2025-01-10 23:53:12'),
	(46, '6781b32d06f81', 'Detergente Alive', 19.00, 'Detergente alivet rosado 24x500', 500, 10, 1, 1, 3, 1, '2025-01-10 23:54:21', '2025-01-10 23:54:21'),
	(47, '6781b366903cf', 'Jabón de baño', 7.50, 'Jabón Rexona 8x120', 5000, 10, 1, 1, 3, 1, '2025-01-10 23:55:18', '2025-01-10 23:55:18'),
	(48, '6781b39924094', 'Papel Higiénico', 8.50, 'Papel higiénico rosal 12x4', 5000, 10, 1, 1, 3, 1, '2025-01-10 23:56:09', '2025-01-10 23:56:09'),
	(49, '6781b3cabd6a6', 'Cloro blanco', 8.00, 'Cloro osó blanco 12x1', 5000, 10, 1, 1, 3, 1, '2025-01-10 23:56:58', '2025-01-10 23:56:58');

-- Volcando estructura para tabla larapos.product_variants
CREATE TABLE IF NOT EXISTS `product_variants` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `producto_id` bigint unsigned NOT NULL DEFAULT '1',
  `color` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `size` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `empresaId` bigint unsigned NOT NULL DEFAULT '1',
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `product_variants_producto_id_foreign` (`producto_id`),
  KEY `product_variants_empresaid_foreign` (`empresaId`),
  CONSTRAINT `product_variants_empresaid_foreign` FOREIGN KEY (`empresaId`) REFERENCES `empresas` (`id`) ON DELETE CASCADE ON UPDATE CASCADE,
  CONSTRAINT `product_variants_producto_id_foreign` FOREIGN KEY (`producto_id`) REFERENCES `productos` (`id`) ON DELETE CASCADE ON UPDATE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

-- Volcando datos para la tabla larapos.product_variants: ~0 rows (aproximadamente)
DELETE FROM `product_variants`;

-- Volcando estructura para tabla larapos.roles
CREATE TABLE IF NOT EXISTS `roles` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `name` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `status` smallint NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `deleted_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `roles_name_unique` (`name`)
) ENGINE=InnoDB AUTO_INCREMENT=5 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

-- Volcando datos para la tabla larapos.roles: ~3 rows (aproximadamente)
DELETE FROM `roles`;
INSERT INTO `roles` (`id`, `name`, `status`, `created_at`, `updated_at`, `deleted_at`) VALUES
	(1, 'Super Administrador', 1, '2025-01-10 17:24:06', '2025-01-10 17:24:06', NULL),
	(2, 'Administrador', 1, '2025-01-10 17:24:06', '2025-01-10 17:24:06', NULL),
	(3, 'Cliente', 1, '2025-01-10 17:24:06', '2025-01-10 17:24:06', NULL),
	(4, 'Empleado', 1, '2025-01-11 23:07:42', '2025-01-11 23:07:42', NULL);

-- Volcando estructura para tabla larapos.role_user
CREATE TABLE IF NOT EXISTS `role_user` (
  `user_id` bigint unsigned NOT NULL,
  `role_id` bigint unsigned NOT NULL,
  KEY `role_user_user_id_foreign` (`user_id`),
  KEY `role_user_role_id_foreign` (`role_id`),
  CONSTRAINT `role_user_role_id_foreign` FOREIGN KEY (`role_id`) REFERENCES `roles` (`id`) ON DELETE CASCADE,
  CONSTRAINT `role_user_user_id_foreign` FOREIGN KEY (`user_id`) REFERENCES `users` (`id`) ON DELETE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

-- Volcando datos para la tabla larapos.role_user: ~0 rows (aproximadamente)
DELETE FROM `role_user`;
INSERT INTO `role_user` (`user_id`, `role_id`) VALUES
	(1, 1),
	(2, 3);

-- Volcando estructura para tabla larapos.series
CREATE TABLE IF NOT EXISTS `series` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `serie` varchar(20) COLLATE utf8mb4_unicode_ci NOT NULL,
  `empresaId` bigint unsigned NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `series_empresaid_foreign` (`empresaId`),
  CONSTRAINT `series_empresaid_foreign` FOREIGN KEY (`empresaId`) REFERENCES `empresas` (`id`) ON DELETE CASCADE
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

-- Volcando datos para la tabla larapos.series: ~0 rows (aproximadamente)
DELETE FROM `series`;
INSERT INTO `series` (`id`, `serie`, `empresaId`, `created_at`, `updated_at`) VALUES
	(1, '00002', 1, NULL, '2025-01-11 23:04:26');

-- Volcando estructura para tabla larapos.tasas
CREATE TABLE IF NOT EXISTS `tasas` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `amount` double NOT NULL,
  `fecha` varchar(100) COLLATE utf8mb4_unicode_ci NOT NULL,
  `empresaId` bigint unsigned NOT NULL DEFAULT '1',
  `userId` bigint unsigned NOT NULL DEFAULT '1',
  `status` smallint NOT NULL DEFAULT '1',
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `tasas_empresaid_foreign` (`empresaId`),
  KEY `tasas_userid_foreign` (`userId`),
  CONSTRAINT `tasas_empresaid_foreign` FOREIGN KEY (`empresaId`) REFERENCES `empresas` (`id`) ON DELETE CASCADE ON UPDATE CASCADE,
  CONSTRAINT `tasas_userid_foreign` FOREIGN KEY (`userId`) REFERENCES `users` (`id`) ON DELETE CASCADE ON UPDATE CASCADE
) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

-- Volcando datos para la tabla larapos.tasas: ~0 rows (aproximadamente)
DELETE FROM `tasas`;
INSERT INTO `tasas` (`id`, `amount`, `fecha`, `empresaId`, `userId`, `status`, `created_at`, `updated_at`) VALUES
	(1, 47.8, '2025-01-10', 1, 1, 1, '2025-01-10 17:25:44', '2025-01-10 17:25:44'),
	(2, 47.8, '2025-01-11', 1, 1, 1, '2025-01-11 15:20:49', '2025-01-11 15:20:49');

-- Volcando estructura para tabla larapos.tipo_dispositivos
CREATE TABLE IF NOT EXISTS `tipo_dispositivos` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `name` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=10 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

-- Volcando datos para la tabla larapos.tipo_dispositivos: ~9 rows (aproximadamente)
DELETE FROM `tipo_dispositivos`;
INSERT INTO `tipo_dispositivos` (`id`, `name`, `created_at`, `updated_at`) VALUES
	(1, 'Desktop', '2025-01-10 17:25:44', '2025-01-10 17:25:44'),
	(2, 'Desktop', '2025-01-10 22:08:17', '2025-01-10 22:08:17'),
	(3, 'Desktop', '2025-01-11 15:20:48', '2025-01-11 15:20:48'),
	(4, 'Desktop', '2025-01-11 18:12:18', '2025-01-11 18:12:18'),
	(5, 'Desktop', '2025-01-11 21:07:41', '2025-01-11 21:07:41'),
	(6, 'Desktop', '2025-01-11 22:46:56', '2025-01-11 22:46:56'),
	(7, 'Desktop', '2025-01-11 23:05:07', '2025-01-11 23:05:07'),
	(8, 'Desktop', '2025-01-11 23:09:11', '2025-01-11 23:09:11'),
	(9, 'Desktop', '2025-01-11 23:09:28', '2025-01-11 23:09:28');

-- Volcando estructura para tabla larapos.verifybackup
CREATE TABLE IF NOT EXISTS `verifybackup` (
  `id` int unsigned NOT NULL AUTO_INCREMENT,
  `verify_status` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

-- Volcando datos para la tabla larapos.verifybackup: ~0 rows (aproximadamente)
DELETE FROM `verifybackup`;

-- Volcando estructura para tabla larapos.wishlists
CREATE TABLE IF NOT EXISTS `wishlists` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `producto_id` bigint unsigned NOT NULL DEFAULT '1',
  `user_id` bigint unsigned NOT NULL DEFAULT '1',
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `wishlists_producto_id_foreign` (`producto_id`),
  KEY `wishlists_user_id_foreign` (`user_id`),
  CONSTRAINT `wishlists_producto_id_foreign` FOREIGN KEY (`producto_id`) REFERENCES `productos` (`id`) ON DELETE CASCADE ON UPDATE CASCADE,
  CONSTRAINT `wishlists_user_id_foreign` FOREIGN KEY (`user_id`) REFERENCES `users` (`id`) ON DELETE CASCADE ON UPDATE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

-- Volcando datos para la tabla larapos.wishlists: ~0 rows (aproximadamente)
DELETE FROM `wishlists`;

