-- --------------------------------------------------------
-- 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, '679e5e690f8d5', 'CAJA 1', 1, 1, '2025-02-01 17:48:25', '2025-02-01 17:48:25');

-- 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-02-01 17:48:25', '2025-02-01 17:48:25'),
	(2, 'Bebidas', 1, 1, '2025-02-01 17:48:25', '2025-02-01 17:48:25'),
	(3, 'Aseo persona e Higiene', 1, 1, '2025-02-01 17:48:25', '2025-02-01 17:48:25'),
	(4, 'Cigarros', 1, 1, '2025-02-01 17:48:25', '2025-02-01 17:48:25'),
	(5, 'Golosinas', 1, 1, '2025-02-01 17:48:25', '2025-02-01 17:48:25');

-- 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', 'CND97BEEU8', '5', '30', 1, '2025-02-01 17:48:23', '2025-02-01 17:48:23');

-- 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-02-01',
  `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 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

-- 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=64 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

-- Volcando datos para la tabla larapos.detalle_productos: ~55 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, 1, 0, 1, '2025-02-01 17:56:22', '2025-02-01 17:56:22'),
	(2, 'INGRESO (+) DE PRODUCTO 5000', 5000, 2, 0, 1, '2025-02-01 18:01:08', '2025-02-01 18:01:08'),
	(3, 'INGRESO (+) DE PRODUCTO 5000', 5000, 3, 0, 1, '2025-02-01 18:05:51', '2025-02-01 18:05:51'),
	(4, 'INGRESO (+) DE PRODUCTO 5000', 5000, 4, 0, 1, '2025-02-01 18:07:33', '2025-02-01 18:07:33'),
	(5, 'INGRESO (+) DE PRODUCTO 5000', 5000, 5, 0, 1, '2025-02-01 18:08:32', '2025-02-01 18:08:32'),
	(6, 'INGRESO (+) DE PRODUCTO 5000', 5000, 6, 0, 1, '2025-02-01 18:10:33', '2025-02-01 18:10:33'),
	(7, 'INGRESO (+) DE PRODUCTO 5000', 5000, 7, 0, 1, '2025-02-01 18:12:23', '2025-02-01 18:12:23'),
	(8, 'INGRESO (+) DE PRODUCTO 5000', 5000, 8, 0, 1, '2025-02-01 18:17:39', '2025-02-01 18:17:39'),
	(9, 'INGRESO (+) DE PRODUCTO 5000', 5000, 9, 0, 1, '2025-02-01 18:19:46', '2025-02-01 18:19:46'),
	(10, 'INGRESO (+) DE PRODUCTO 5000', 5000, 10, 0, 1, '2025-02-01 18:22:26', '2025-02-01 18:22:26'),
	(11, 'INGRESO (+) DE PRODUCTO 5000', 5000, 11, 0, 1, '2025-02-01 18:24:49', '2025-02-01 18:24:49'),
	(12, 'INGRESO (+) DE PRODUCTO 5000', 5000, 12, 0, 1, '2025-02-01 18:25:30', '2025-02-01 18:25:30'),
	(13, 'INGRESO (+) DE PRODUCTO 5000', 5000, 13, 0, 1, '2025-02-02 00:41:23', '2025-02-02 00:41:23'),
	(14, 'INGRESO (+) DE PRODUCTO 5000', 5000, 14, 0, 1, '2025-02-02 00:41:56', '2025-02-02 00:41:56'),
	(15, 'INGRESO (+) DE PRODUCTO 5000', 5000, 15, 0, 1, '2025-02-02 00:42:48', '2025-02-02 00:42:48'),
	(16, 'INGRESO (+) DE PRODUCTO 5000', 5000, 16, 0, 1, '2025-02-02 00:44:39', '2025-02-02 00:44:39'),
	(17, 'INGRESO (+) DE PRODUCTO 5000', 5000, 17, 0, 1, '2025-02-02 00:45:56', '2025-02-02 00:45:56'),
	(18, 'INGRESO (+) DE PRODUCTO 5000', 5000, 18, 0, 1, '2025-02-02 00:46:28', '2025-02-02 00:46:28'),
	(19, 'INGRESO (+) DE PRODUCTO 5000', 5000, 19, 0, 1, '2025-02-02 00:47:06', '2025-02-02 00:47:06'),
	(20, 'INGRESO (+) DE PRODUCTO 5000', 5000, 20, 0, 1, '2025-02-02 01:05:56', '2025-02-02 01:05:56'),
	(21, 'INGRESO (+) DE PRODUCTO 5000', 5000, 21, 0, 1, '2025-02-02 01:06:24', '2025-02-02 01:06:24'),
	(22, 'INGRESO (+) DE PRODUCTO 5000', 5000, 22, 0, 1, '2025-02-02 01:07:48', '2025-02-02 01:07:48'),
	(23, 'INGRESO (+) DE PRODUCTO 5000', 5000, 23, 0, 1, '2025-02-02 01:08:14', '2025-02-02 01:08:14'),
	(24, 'INGRESO (+) DE PRODUCTO 5000', 5000, 24, 0, 1, '2025-02-02 01:09:20', '2025-02-02 01:09:20'),
	(25, 'INGRESO (+) DE PRODUCTO 5000', 5000, 25, 0, 1, '2025-02-02 01:09:55', '2025-02-02 01:09:55'),
	(26, 'INGRESO (+) DE PRODUCTO 5000', 5000, 26, 0, 1, '2025-02-02 01:10:26', '2025-02-02 01:10:26'),
	(28, 'INGRESO (+) DE PRODUCTO 5000', 5000, 28, 0, 1, '2025-02-02 01:12:06', '2025-02-02 01:12:06'),
	(29, 'INGRESO (+) DE PRODUCTO 5000', 5000, 29, 0, 1, '2025-02-02 01:12:51', '2025-02-02 01:12:51'),
	(30, 'INGRESO (+) DE PRODUCTO 5000', 5000, 30, 0, 1, '2025-02-02 01:13:25', '2025-02-02 01:13:25'),
	(31, 'INGRESO (+) DE PRODUCTO 5000', 5000, 31, 0, 1, '2025-02-02 01:16:11', '2025-02-02 01:16:11'),
	(32, 'INGRESO (+) DE PRODUCTO 5000', 5000, 32, 0, 1, '2025-02-02 01:17:14', '2025-02-02 01:17:14'),
	(33, 'INGRESO (+) DE PRODUCTO 5000', 5000, 33, 0, 1, '2025-02-02 01:18:19', '2025-02-02 01:18:19'),
	(34, 'INGRESO (+) DE PRODUCTO 5000', 5000, 34, 0, 1, '2025-02-02 01:18:53', '2025-02-02 01:18:53'),
	(35, 'INGRESO (+) DE PRODUCTO 5000', 5000, 35, 0, 1, '2025-02-02 01:20:14', '2025-02-02 01:20:14'),
	(36, 'INGRESO (+) DE PRODUCTO 5000', 5000, 36, 0, 1, '2025-02-02 01:22:22', '2025-02-02 01:22:22'),
	(37, 'INGRESO (+) DE PRODUCTO 5000', 5000, 37, 0, 1, '2025-02-02 01:23:26', '2025-02-02 01:23:26'),
	(38, 'INGRESO (+) DE PRODUCTO 5000', 5000, 38, 0, 1, '2025-02-02 01:23:50', '2025-02-02 01:23:50'),
	(39, 'INGRESO (+) DE PRODUCTO 5000', 5000, 39, 0, 1, '2025-02-02 01:24:20', '2025-02-02 01:24:20'),
	(40, 'INGRESO (+) DE PRODUCTO 5000', 5000, 40, 0, 1, '2025-02-02 01:30:10', '2025-02-02 01:30:10'),
	(41, 'INGRESO (+) DE PRODUCTO 5000', 5000, 41, 0, 1, '2025-02-02 01:31:00', '2025-02-02 01:31:00'),
	(42, 'INGRESO (+) DE PRODUCTO 5000', 5000, 42, 0, 1, '2025-02-02 01:31:46', '2025-02-02 01:31:46'),
	(43, 'INGRESO (+) DE PRODUCTO 5000', 5000, 43, 0, 1, '2025-02-02 01:34:42', '2025-02-02 01:34:42'),
	(44, 'INGRESO (+) DE PRODUCTO 5000', 5000, 44, 0, 1, '2025-02-02 01:36:41', '2025-02-02 01:36:41'),
	(45, 'INGRESO (+) DE PRODUCTO 5000', 5000, 45, 0, 1, '2025-02-02 01:37:13', '2025-02-02 01:37:13'),
	(46, 'INGRESO (+) DE PRODUCTO 5000', 5000, 46, 0, 1, '2025-02-02 01:37:32', '2025-02-02 01:37:32'),
	(47, 'INGRESO (+) DE PRODUCTO 5000', 5000, 47, 0, 1, '2025-02-02 01:38:30', '2025-02-02 01:38:30'),
	(48, 'INGRESO (+) DE PRODUCTO 5000', 5000, 48, 0, 1, '2025-02-02 01:39:08', '2025-02-02 01:39:08'),
	(49, 'INGRESO (+) DE PRODUCTO 5000', 5000, 49, 0, 1, '2025-02-03 02:27:23', '2025-02-03 02:27:23'),
	(50, 'INGRESO (+) DE PRODUCTO 5000', 5000, 50, 0, 1, '2025-02-03 02:27:40', '2025-02-03 02:27:40'),
	(51, 'INGRESO (+) DE PRODUCTO 5000', 5000, 51, 0, 1, '2025-02-03 02:28:07', '2025-02-03 02:28:07'),
	(52, 'INGRESO (+) DE PRODUCTO 5000', 5000, 52, 0, 1, '2025-02-03 02:29:11', '2025-02-03 02:29:11'),
	(53, 'INGRESO (+) DE PRODUCTO 5000', 5000, 53, 0, 1, '2025-02-03 02:29:43', '2025-02-03 02:29:43'),
	(54, 'INGRESO (+) DE PRODUCTO 5000', 5000, 54, 0, 1, '2025-02-03 02:30:47', '2025-02-03 02:30:47'),
	(55, 'INGRESO (+) DE PRODUCTO 5000', 5000, 55, 0, 1, '2025-02-03 02:35:54', '2025-02-03 02:35:54'),
	(56, 'INGRESO (+) DE PRODUCTO 5000', 5000, 56, 0, 1, '2025-02-03 02:36:05', '2025-02-03 02:36:05'),
	(57, 'INGRESO (+) DE PRODUCTO 5000', 5000, 57, 0, 1, '2025-02-03 02:36:28', '2025-02-03 02:36:28'),
	(58, 'INGRESO (+) DE PRODUCTO 5000', 5000, 58, 0, 1, '2025-02-03 02:37:30', '2025-02-03 02:37:30'),
	(59, 'INGRESO (+) DE PRODUCTO 5000', 5000, 59, 0, 1, '2025-02-03 02:39:47', '2025-02-03 02:39:47'),
	(60, 'INGRESO (+) DE PRODUCTO 5000', 5000, 60, 0, 1, '2025-02-03 02:40:24', '2025-02-03 02:40:24'),
	(61, 'INGRESO (+) DE PRODUCTO 5000', 5000, 61, 0, 1, '2025-02-03 02:41:19', '2025-02-03 02:41:19'),
	(62, 'INGRESO (+) DE PRODUCTO 5000', 5000, 62, 0, 1, '2025-02-03 02:42:05', '2025-02-03 02:42:05'),
	(63, 'INGRESO (+) DE PRODUCTO 5000', 5000, 63, 0, 1, '2025-02-03 02:43:04', '2025-02-03 02:43:04');

-- 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 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

-- 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-02-01 13:48:23',
  `upated_at` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '2025-02-01 13:48:23',
  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 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

-- 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-02-01 17:48:24', '2025-02-01 17:48:24');

-- 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=5 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

-- Volcando datos para la tabla larapos.exploradors: ~0 rows (aproximadamente)
DELETE FROM `exploradors`;
INSERT INTO `exploradors` (`id`, `name`, `version`, `created_at`, `updated_at`) VALUES
	(1, 'Chrome', '132.0.0.0', '2025-02-01 17:54:14', '2025-02-01 17:54:14'),
	(2, 'Chrome', '132.0.0.0', '2025-02-02 00:24:14', '2025-02-02 00:24:14'),
	(3, 'Chrome', '132.0.0.0', '2025-02-02 00:32:21', '2025-02-02 00:32:21'),
	(4, 'Chrome', '132.0.0.0', '2025-02-03 02:13:00', '2025-02-03 02:13:00');

-- 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.historico_pedidos
CREATE TABLE IF NOT EXISTS `historico_pedidos` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `fecha` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '2025-02-01',
  `descripcion` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `titulo` varchar(255) COLLATE utf8mb4_unicode_ci NOT 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 `historico_pedidos_empresaid_foreign` (`empresaId`),
  KEY `historico_pedidos_userid_foreign` (`userId`),
  KEY `historico_pedidos_pedidoid_foreign` (`pedidoId`),
  CONSTRAINT `historico_pedidos_empresaid_foreign` FOREIGN KEY (`empresaId`) REFERENCES `empresas` (`id`) ON DELETE CASCADE,
  CONSTRAINT `historico_pedidos_pedidoid_foreign` FOREIGN KEY (`pedidoId`) REFERENCES `pedidos` (`id`) ON DELETE CASCADE,
  CONSTRAINT `historico_pedidos_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.historico_pedidos: ~0 rows (aproximadamente)
DELETE FROM `historico_pedidos`;

-- 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=64 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

-- Volcando datos para la tabla larapos.images: ~62 rows (aproximadamente)
DELETE FROM `images`;
INSERT INTO `images` (`id`, `path`, `producto_id`, `featured`, `empresaId`, `created_at`, `updated_at`) VALUES
	(1, '1738434372.jpg', 1, 0, 1, '2025-02-01 17:56:22', '2025-02-01 18:26:12'),
	(2, '1738434504.jpg', 2, 0, 1, '2025-02-01 18:01:08', '2025-02-01 18:28:24'),
	(3, '1738434487.jpg', 3, 0, 1, '2025-02-01 18:05:51', '2025-02-01 18:28:07'),
	(4, '1738434522.jpg', 4, 0, 1, '2025-02-01 18:07:33', '2025-02-01 18:28:42'),
	(5, '1738434537.jpg', 5, 0, 1, '2025-02-01 18:08:32', '2025-02-01 18:28:57'),
	(6, '1738434552.jpg', 6, 0, 1, '2025-02-01 18:10:33', '2025-02-01 18:29:12'),
	(7, '1738434579.jpg', 7, 0, 1, '2025-02-01 18:12:23', '2025-02-01 18:29:39'),
	(8, '1738434596.jpg', 8, 0, 1, '2025-02-01 18:17:39', '2025-02-01 18:29:56'),
	(9, '1738434621.jpg', 9, 0, 1, '2025-02-01 18:19:46', '2025-02-01 18:30:21'),
	(10, '1738434644.jpg', 10, 0, 1, '2025-02-01 18:22:26', '2025-02-01 18:30:44'),
	(11, '1738434663.jpg', 11, 0, 1, '2025-02-01 18:24:49', '2025-02-01 18:31:03'),
	(12, '1738434679.jpg', 12, 0, 1, '2025-02-01 18:25:30', '2025-02-01 18:31:19'),
	(13, '1738456883.jpg', 13, 0, 1, '2025-02-02 00:41:23', '2025-02-02 00:41:23'),
	(14, '1738456916.jpg', 14, 0, 1, '2025-02-02 00:41:56', '2025-02-02 00:41:56'),
	(15, '1738457015.jpg', 15, 0, 1, '2025-02-02 00:42:48', '2025-02-02 00:43:35'),
	(16, '1738457079.jpg', 16, 0, 1, '2025-02-02 00:44:39', '2025-02-02 00:44:39'),
	(17, '1738457156.jpg', 17, 0, 1, '2025-02-02 00:45:56', '2025-02-02 00:45:56'),
	(18, '1738457188.jpg', 18, 0, 1, '2025-02-02 00:46:28', '2025-02-02 00:46:28'),
	(19, '1738457226.jpg', 19, 0, 1, '2025-02-02 00:47:06', '2025-02-02 00:47:06'),
	(20, '1738458356.jpg', 20, 0, 1, '2025-02-02 01:05:56', '2025-02-02 01:05:56'),
	(21, '1738458384.jpg', 21, 0, 1, '2025-02-02 01:06:24', '2025-02-02 01:06:24'),
	(22, '1738458468.jpg', 22, 0, 1, '2025-02-02 01:07:48', '2025-02-02 01:07:48'),
	(23, '1738458494.jpg', 23, 0, 1, '2025-02-02 01:08:14', '2025-02-02 01:08:14'),
	(24, '1738458560.jpg', 24, 0, 1, '2025-02-02 01:09:20', '2025-02-02 01:09:20'),
	(25, '1738458595.jpg', 25, 0, 1, '2025-02-02 01:09:55', '2025-02-02 01:09:55'),
	(26, '1738458626.jpg', 26, 0, 1, '2025-02-02 01:10:26', '2025-02-02 01:10:26'),
	(28, '1738458726.jpg', 28, 0, 1, '2025-02-02 01:12:06', '2025-02-02 01:12:06'),
	(29, '1738458771.jpg', 29, 0, 1, '2025-02-02 01:12:51', '2025-02-02 01:12:51'),
	(30, '1738458805.jpg', 30, 0, 1, '2025-02-02 01:13:25', '2025-02-02 01:13:25'),
	(31, '1738459163.jpg', 31, 0, 1, '2025-02-02 01:16:11', '2025-02-02 01:19:23'),
	(32, '1738459034.jpg', 32, 0, 1, '2025-02-02 01:17:14', '2025-02-02 01:17:14'),
	(33, '1738459099.jpg', 33, 0, 1, '2025-02-02 01:18:19', '2025-02-02 01:18:19'),
	(34, '1738459133.jpg', 34, 0, 1, '2025-02-02 01:18:53', '2025-02-02 01:18:53'),
	(35, '1738459214.jpg', 35, 0, 1, '2025-02-02 01:20:14', '2025-02-02 01:20:14'),
	(36, '1738459342.jpg', 36, 0, 1, '2025-02-02 01:22:22', '2025-02-02 01:22:22'),
	(37, '1738459406.jpg', 37, 0, 1, '2025-02-02 01:23:26', '2025-02-02 01:23:26'),
	(38, '1738459430.jpg', 38, 0, 1, '2025-02-02 01:23:50', '2025-02-02 01:23:50'),
	(39, '1738459460.jpg', 39, 0, 1, '2025-02-02 01:24:20', '2025-02-02 01:24:20'),
	(40, '1738459810.webp', 40, 0, 1, '2025-02-02 01:30:10', '2025-02-02 01:30:10'),
	(41, '1738459860.webp', 41, 0, 1, '2025-02-02 01:31:00', '2025-02-02 01:31:00'),
	(42, '1738459906.webp', 42, 0, 1, '2025-02-02 01:31:46', '2025-02-02 01:31:46'),
	(43, '1738460101.webp', 43, 0, 1, '2025-02-02 01:34:42', '2025-02-02 01:35:01'),
	(44, '1738460201.jpg', 44, 0, 1, '2025-02-02 01:36:41', '2025-02-02 01:36:41'),
	(45, '1738460233.jpg', 45, 0, 1, '2025-02-02 01:37:13', '2025-02-02 01:37:13'),
	(46, '1738460252.jpg', 46, 0, 1, '2025-02-02 01:37:32', '2025-02-02 01:37:32'),
	(47, '1738460310.jpg', 47, 0, 1, '2025-02-02 01:38:30', '2025-02-02 01:38:30'),
	(48, '1738460348.jpg', 48, 0, 1, '2025-02-02 01:39:08', '2025-02-02 01:39:08'),
	(49, '1738549643.webp', 49, 0, 1, '2025-02-03 02:27:23', '2025-02-03 02:27:23'),
	(50, '1738549660.webp', 50, 0, 1, '2025-02-03 02:27:40', '2025-02-03 02:27:40'),
	(51, '1738549687.webp', 51, 0, 1, '2025-02-03 02:28:07', '2025-02-03 02:28:07'),
	(52, '1738549813.jpg', 52, 0, 1, '2025-02-03 02:29:11', '2025-02-03 02:30:13'),
	(53, '1738549783.jpg', 53, 0, 1, '2025-02-03 02:29:43', '2025-02-03 02:29:43'),
	(54, '1738549847.jpg', 54, 0, 1, '2025-02-03 02:30:47', '2025-02-03 02:30:47'),
	(55, '1738550154.jpg', 55, 0, 1, '2025-02-03 02:35:54', '2025-02-03 02:35:54'),
	(56, '1738550209.jpg', 56, 0, 1, '2025-02-03 02:36:05', '2025-02-03 02:36:49'),
	(57, '1738550188.jpg', 57, 0, 1, '2025-02-03 02:36:28', '2025-02-03 02:36:28'),
	(58, '1738550250.jpg', 58, 0, 1, '2025-02-03 02:37:30', '2025-02-03 02:37:30'),
	(59, '1738550387.jpg', 59, 0, 1, '2025-02-03 02:39:47', '2025-02-03 02:39:47'),
	(60, '1738550424.jpg', 60, 0, 1, '2025-02-03 02:40:24', '2025-02-03 02:40:24'),
	(61, '1738550479.jpg', 61, 0, 1, '2025-02-03 02:41:19', '2025-02-03 02:41:19'),
	(62, '1738550525.jpg', 62, 0, 1, '2025-02-03 02:42:05', '2025-02-03 02:42:05'),
	(63, '1738550584.jpg', 63, 0, 1, '2025-02-03 02:43:04', '2025-02-03 02:43:04');

-- 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-02-01 17:48:25', '2025-02-01 17:48:25');

-- 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=39 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),
	(35, '2025_01_29_125424_add_precio_bs_column_to_productos', 1),
	(36, '2025_02_01_121623_create_movimiento_pedido_table', 1),
	(37, '2025_02_01_122143_add_tipo_atencion_to_historico_pedidos', 1),
	(38, '2025_02_01_125248_add_nota_to_pedido_pago', 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-02-01 17:48:24', '2025-02-01 17:48:24'),
	(2, 'CH', 'CHILE', '+56', 0, '$', 'PESOS', '2025-02-01 17:48:24', '2025-02-01 17:48:24'),
	(3, 'COL', 'COLOMBIA', '+57', 0, '$', 'PESOS', '2025-02-01 17:48:24', '2025-02-01 17:48:24'),
	(4, 'USA', 'ESTADOS UNIDOS', '+1', 0, '$', 'DÓLAR', '2025-02-01 17:48:24', '2025-02-01 17:48:24'),
	(5, 'PE', 'PERU', '+51', 0, 'S/', 'SOLES', '2025-02-01 17:48:24', '2025-02-01 17:48:24'),
	(6, 'VEN', 'VENEZUELA', '+58', 1, 'BS', 'BOLIVARES', '2025-02-01 17:48:24', '2025-02-01 17:48:24'),
	(7, 'BOL', 'BOLIVIA', '+591', 0, '$b', 'PESOS', '2025-02-01 17:48:24', '2025-02-01 17:48:24'),
	(8, 'MEX', 'MEXICO', '+52', 0, '$', 'MX', '2025-02-01 17:48:24', '2025-02-01 17:48:24'),
	(9, 'PAR', 'PARAGUAY', '+595', 0, '₲', 'GUARANIES', '2025-02-01 17:48:24', '2025-02-01 17:48:24'),
	(10, 'RD', 'REPUBLICA DOMINICANA', '+1-809', 0, 'RD$', 'PESOS', '2025-02-01 17:48:24', '2025-02-01 17:48:24'),
	(11, 'CU', 'CUBA', '+53', 0, '$', 'PESOS', '2025-02-01 17:48:24', '2025-02-01 17:48:24'),
	(12, 'GT', 'GUATEMALA', '+502', 0, 'Q', 'QUETZALES', '2025-02-01 17:48:24', '2025-02-01 17:48:24');

-- 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-02-01',
  `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 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

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

-- 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 '679e5e66b8222',
  `name` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `price` decimal(5,2) NOT NULL,
  `precioBs` decimal(5,2) NOT NULL DEFAULT '0.00',
  `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=64 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

-- Volcando datos para la tabla larapos.productos: ~62 rows (aproximadamente)
DELETE FROM `productos`;
INSERT INTO `productos` (`id`, `code`, `name`, `price`, `precioBs`, `description`, `quantity`, `quantity_alert`, `status`, `empresaId`, `categoriaId`, `marcaId`, `created_at`, `updated_at`) VALUES
	(1, '679e60460be88', 'Friut cola 2Lt 6x2 ', 5.00, 5.50, 'Friut cola 6x2 ', 5000, 10, 1, 1, 2, 1, '2025-02-01 17:56:22', '2025-02-01 18:26:15'),
	(2, '679e6164449fa', 'Glup cola negra 2Lt 6x2 ', 5.00, 5.80, 'Glup cola negra 6x2 ', 5000, 10, 1, 1, 2, 1, '2025-02-01 18:01:08', '2025-02-01 18:31:27'),
	(3, '679e627f5bd6b', ' Glup Colita 2Lt 6x2', 5.00, 5.80, ' Glup Colita 6x2', 5000, 10, 1, 1, 2, 1, '2025-02-01 18:05:51', '2025-02-01 18:31:29'),
	(4, '679e62e558e36', 'Glup Naranja 2Lt 6x2', 5.00, 5.80, 'Glup Naranja 6x2', 5000, 10, 1, 1, 2, 1, '2025-02-01 18:07:33', '2025-02-01 18:26:48'),
	(5, '679e6320e492b', 'Glup Uva 2Lt 6x2', 5.00, 5.80, 'Glup Uva 6x2', 5000, 10, 1, 1, 2, 1, '2025-02-01 18:08:32', '2025-02-01 18:26:55'),
	(6, '679e6399788d6', 'Glup Piña 2Lt 6x2', 5.00, 5.80, 'Glup Piña 6x2', 5000, 10, 1, 1, 2, 1, '2025-02-01 18:10:33', '2025-02-01 18:27:03'),
	(7, '679e6407cfdab', 'Glup Fresh 2Lt  6x2', 5.00, 5.80, 'Glup Fresh 6x2', 5000, 10, 1, 1, 2, 1, '2025-02-01 18:12:23', '2025-02-01 18:29:24'),
	(8, '679e654317fa2', ' Glup Manzana Verde 2Lt  6x2', 5.00, 5.80, ' Glup Manzana Verde 6x2', 5000, 10, 1, 1, 2, 1, '2025-02-01 18:17:39', '2025-02-01 18:29:56'),
	(9, '679e65c2bbcbd', ' Glup cola negra 1Lt  12x1', 6.50, 7.80, ' Glup cola negra 12x1', 5000, 10, 1, 1, 2, 1, '2025-02-01 18:19:46', '2025-02-01 18:30:21'),
	(10, '679e6662c2040', ' Glup Colita 1Lt   12x1', 6.50, 7.80, ' Glup Colita 12x1', 5000, 10, 1, 1, 2, 1, '2025-02-01 18:22:26', '2025-02-01 18:30:44'),
	(11, '679e66f1cf467', ' Glup Naranja 1Lt   12x1', 6.50, 7.80, ' Glup Naranja 12x1', 5000, 10, 1, 1, 2, 1, '2025-02-01 18:24:49', '2025-02-01 18:31:03'),
	(12, '679e671ad196e', ' Glup Uva 1Lt   12x1', 6.50, 7.80, ' Glup Uva 12x1', 5000, 10, 1, 1, 2, 1, '2025-02-01 18:25:30', '2025-02-01 18:31:19'),
	(13, '679ebf33e762b', 'Coca Cola  2LT 6x2', 7.50, 8.20, 'Cola Cola 2LT 6x2', 5000, 10, 1, 1, 2, 1, '2025-02-02 00:41:23', '2025-02-02 00:41:23'),
	(14, '679ebf542c43b', 'Coca Cola 1LT 6x1', 4.80, 5.50, 'Cola Cola 1LT 6x1', 5000, 10, 1, 1, 2, 1, '2025-02-02 00:41:56', '2025-02-02 00:41:56'),
	(15, '679ebf8857d98', 'Coca Cola 16x400ML', 10.00, 11.50, 'Cola Cola 400Ml  16x400ML', 5000, 10, 1, 1, 2, 1, '2025-02-02 00:42:48', '2025-02-02 00:43:53'),
	(16, '679ebff7ecf6f', 'Coca Cola  6x1.5Lt', 6.00, 7.00, 'Cola Cola  6x1.5Lt', 5000, 10, 1, 1, 2, 1, '2025-02-02 00:44:39', '2025-02-02 00:44:39'),
	(17, '679ec044c8d56', 'Pepsi Cola 6x2Lt', 7.50, 8.20, 'Pepsi Cola 6x2Lt', 5000, 10, 1, 1, 2, 1, '2025-02-02 00:45:56', '2025-02-02 00:45:56'),
	(18, '679ec06460c4e', 'Pepsi Cola 6x1Lt', 4.80, 5.50, 'Pepsi Cola 6x1Lt', 5000, 10, 1, 1, 2, 1, '2025-02-02 00:46:28', '2025-02-02 00:46:28'),
	(19, '679ec08a1d8e8', 'Pepsi Cola 6x1.5Lt', 6.00, 7.00, 'Pepsi Cola 6x1.5Lt', 5000, 10, 1, 1, 2, 1, '2025-02-02 00:47:06', '2025-02-02 00:47:06'),
	(20, '679ec4f4548c4', 'Hit 2LT Naranja 6x2', 5.50, 6.00, 'Hit 2LT Naranja 6x2', 5000, 10, 1, 1, 2, 1, '2025-02-02 01:05:56', '2025-02-02 01:05:56'),
	(21, '679ec51010f20', 'Hit 2LT Uva 6x2', 5.50, 6.00, 'Hit 2LT Uva 6x2', 5000, 10, 1, 1, 2, 1, '2025-02-02 01:06:24', '2025-02-02 01:06:24'),
	(22, '679ec5644cd19', 'Hit 1LT Uva 6x1', 3.50, 4.50, 'Hit 1LT Uva 6x1', 5000, 10, 1, 1, 2, 1, '2025-02-02 01:07:48', '2025-02-02 01:07:48'),
	(23, '679ec57e7a388', 'Hit 1LT Naranja 6x1', 3.50, 4.50, 'Hit 1LT Naranja 6x1', 5000, 10, 1, 1, 2, 1, '2025-02-02 01:08:14', '2025-02-02 01:08:14'),
	(24, '679ec5c0df0d8', 'Chinotto 1LT 6x2', 5.50, 6.00, 'Chinotto 1LT 6x2', 5000, 10, 1, 1, 2, 1, '2025-02-02 01:09:20', '2025-02-02 01:09:20'),
	(25, '679ec5e384a5e', 'Chinotto 1LT 6x1', 3.50, 4.50, 'Chinotto 2LT 6x2', 5000, 10, 1, 1, 2, 1, '2025-02-02 01:09:55', '2025-02-02 01:09:55'),
	(26, '679ec6025ffa1', 'Chinotto 12x400ml', 6.80, 7.50, 'Chinotto 12x400ml', 5000, 10, 1, 1, 2, 1, '2025-02-02 01:10:26', '2025-02-02 01:10:26'),
	(28, '679ec666a88f8', 'Frescolita 1LT 6x1', 3.50, 4.50, 'Frescolita 1LT 6x1', 5000, 10, 1, 1, 2, 1, '2025-02-02 01:12:06', '2025-02-02 01:12:06'),
	(29, '679ec693857af', 'Frescolita 2LT 6x2', 5.50, 6.00, 'Frescolita 2LT 6x2', 5000, 10, 1, 1, 2, 1, '2025-02-02 01:12:51', '2025-02-02 01:12:51'),
	(30, '679ec6b5d736c', 'Frescolita 12x400ml', 6.80, 7.50, 'Frescolita 12x400ml', 5000, 10, 1, 1, 2, 1, '2025-02-02 01:13:25', '2025-02-02 01:13:25'),
	(31, '679ec75b9ee0b', 'Golden Manzana 2Lt  6X2', 5.50, 6.50, 'Golden Manzana 2Lt  6X2', 5000, 10, 1, 1, 2, 1, '2025-02-02 01:16:11', '2025-02-02 01:19:28'),
	(32, '679ec79a496be', 'Golden Colita 2Lt  6X2', 5.50, 6.50, 'Golden Colita 2Lt  6X2', 5000, 10, 1, 1, 2, 1, '2025-02-02 01:17:14', '2025-02-02 01:17:14'),
	(33, '679ec7dbdaae5', 'Golden Manzana 1Lt 6X1', 5.50, 6.50, 'Golden Manzana 1Lt 6X1', 5000, 10, 1, 1, 2, 1, '2025-02-02 01:18:19', '2025-02-02 01:18:19'),
	(34, '679ec7fd33e0b', 'Golden Colita 1Lt 6X1', 3.50, 4.50, 'Golden Colita 1Lt 6X1', 5000, 10, 1, 1, 2, 1, '2025-02-02 01:18:53', '2025-02-02 01:18:53'),
	(35, '679ec84e67d08', 'Golden Piña 1Lt  6X1', 3.50, 4.50, 'Golden Piña 1Lt  6X1', 5000, 10, 1, 1, 2, 1, '2025-02-02 01:20:14', '2025-02-02 01:20:14'),
	(36, '679ec8ce9f282', 'Golden 7UP 1Lt  6X1', 3.50, 4.50, 'Golden 7UP 1Lt  6X1', 5000, 10, 1, 1, 2, 1, '2025-02-02 01:22:22', '2025-02-02 01:22:22'),
	(37, '679ec90ec6154', 'Golden Manzana 6X1.5Lt', 5.00, 6.00, 'Golden Manzana 6X1.5Lt', 5000, 10, 1, 1, 2, 1, '2025-02-02 01:23:26', '2025-02-02 01:23:26'),
	(38, '679ec926da796', 'Golden Piña 6X1.5Lt', 5.00, 6.00, 'Golden Manzana 6X1.5Lt', 5000, 10, 1, 1, 2, 1, '2025-02-02 01:23:50', '2025-02-02 01:23:50'),
	(39, '679ec944a98da', 'Golden Colita 6X1.5Lt', 5.00, 6.00, 'Golden Colita 6X1.5Lt', 5000, 10, 1, 1, 2, 1, '2025-02-02 01:24:20', '2025-02-02 01:24:20'),
	(40, '679ecaa2e72d5', 'Agua mineral Heleal 12x1.5', 6.50, 7.50, 'Agua mineral Heleal 12x1.5', 5000, 10, 1, 1, 2, 1, '2025-02-02 01:30:10', '2025-02-02 01:30:10'),
	(41, '679ecad4def83', 'Agua mineral Heleal 2x5Lt', 4.00, 5.00, 'Agua mineral Heleal 2x5Lt', 5000, 10, 1, 1, 2, 1, '2025-02-02 01:31:00', '2025-02-02 01:31:00'),
	(42, '679ecb021d0b2', 'Agua mineral Heleal 24x500ML', 7.00, 8.00, 'Agua mineral Heleal 24x500ML', 5000, 10, 1, 1, 2, 1, '2025-02-02 01:31:46', '2025-02-02 01:31:46'),
	(43, '679ecbb2ab8ae', 'Agua mineral Mi brisa 12x1.5', 7.00, 8.00, 'Agua mineral Mi brisa 12x1.5', 5000, 10, 1, 1, 2, 1, '2025-02-02 01:34:42', '2025-02-02 01:35:10'),
	(44, '679ecc29cf704', 'Gatorade Tropical 12x500ml', 11.00, 12.50, 'Gatorade Tropical 12x500ml', 5000, 10, 1, 1, 2, 1, '2025-02-02 01:36:41', '2025-02-02 01:36:41'),
	(45, '679ecc4933451', 'Gatorade Mandarina 12x500ml', 11.00, 12.50, 'Gatorade Mandarina 12x500ml', 5000, 10, 1, 1, 2, 1, '2025-02-02 01:37:13', '2025-02-02 01:37:13'),
	(46, '679ecc5c76867', 'Gatorade Azul 12x500ml', 11.00, 12.50, 'Gatorade Azul 12x500ml', 5000, 10, 1, 1, 2, 1, '2025-02-02 01:37:32', '2025-02-02 01:37:32'),
	(47, '679ecc9654746', 'Speed de lata 24x269 ML', 9.50, 10.50, 'Speed de lata 24x269 ML', 5000, 10, 1, 1, 2, 1, '2025-02-02 01:38:30', '2025-02-02 01:38:30'),
	(48, '679eccbc04fe2', 'Speed de 1Lt 12X1 LT', 11.50, 12.50, 'Speed de 1Lt 12X1 LT', 5000, 10, 1, 1, 2, 1, '2025-02-02 01:39:08', '2025-02-02 01:39:08'),
	(49, '67a0298ba5918', 'Jugo valencia Manzana 12x1 LT', 12.00, 13.00, 'Jugo valencia Manzana 12x1 LT', 5000, 10, 1, 1, 2, 1, '2025-02-03 02:27:23', '2025-02-03 02:27:23'),
	(50, '67a0299cabf6f', 'Jugo valencia Pera 12x1 LT', 12.00, 13.00, 'Jugo valencia Manzana 12x1 LT', 5000, 10, 1, 1, 2, 1, '2025-02-03 02:27:40', '2025-02-03 02:27:40'),
	(51, '67a029b705362', 'Jugo valencia Durazno 12x1 LT', 12.00, 13.00, 'Jugo valencia Durazno 12x1 LT', 5000, 10, 1, 1, 2, 1, '2025-02-03 02:28:07', '2025-02-03 02:28:07'),
	(52, '67a029f781ff3', 'Jugo Frutssy Pasión Mix 24x250ml', 6.50, 7.50, 'Jugo Frutssy Pasión Mix 24x250ml', 5000, 10, 1, 1, 2, 1, '2025-02-03 02:29:11', '2025-02-03 02:30:23'),
	(53, '67a02a1727239', 'Jugo Frutssy Tropical 24x250ml', 6.50, 7.50, 'Jugo Frutssy Tropical  24x250ml', 5000, 10, 1, 1, 2, 1, '2025-02-03 02:29:43', '2025-02-03 02:29:43'),
	(54, '67a02a578618b', 'Jugo Frutssy Frutos rojos 24x250ml', 6.50, 7.50, 'Jugo Frutssy Frutos rojos 24x250ml', 5000, 10, 1, 1, 2, 1, '2025-02-03 02:30:47', '2025-02-03 02:30:47'),
	(55, '67a02b8a26b2d', 'Jugo Natulac Durazno 12x1LT', 20.00, 22.50, 'Jugo Natulac Durazno 12x1LT', 5000, 10, 1, 1, 2, 1, '2025-02-03 02:35:54', '2025-02-03 02:35:54'),
	(56, '67a02b9582a80', 'Jugo Natulac Manzana 12x1LT', 20.00, 22.50, 'Jugo Natulac Durazno 12x1LT', 5000, 10, 1, 1, 2, 1, '2025-02-03 02:36:05', '2025-02-03 02:36:52'),
	(57, '67a02bac23c4d', 'Jugo Natulac Pera 12x1LT', 20.00, 22.50, 'Jugo Natulac Pera 12x1LT', 5000, 10, 1, 1, 2, 1, '2025-02-03 02:36:28', '2025-02-03 02:36:28'),
	(58, '67a02beadfba9', 'Jugo Justy Naranja 12x1.5 LT', 7.80, 8.50, 'Jugo Natulac Durazno 12x1LT', 5000, 10, 1, 1, 2, 1, '2025-02-03 02:37:30', '2025-02-03 02:37:30'),
	(59, '67a02c73cd6b6', ' Harina PAN 20X1', 15.50, 18.50, ' Harina PAN 20X1', 5000, 10, 1, 1, 1, 1, '2025-02-03 02:39:47', '2025-02-03 02:39:47'),
	(60, '67a02c983441b', 'Harina de Maiz Mary 20x1', 16.80, 19.00, 'Harina de Maiz Mary 20x1', 5000, 10, 1, 1, 1, 1, '2025-02-03 02:40:24', '2025-02-03 02:40:24'),
	(61, '67a02ccf01c09', 'Mantequilla DELINE 500 MG', 17.50, 19.50, 'Mantequilla DELINE 500 MG', 5000, 10, 1, 1, 1, 1, '2025-02-03 02:41:19', '2025-02-03 02:41:19'),
	(62, '67a02cfdbd7fa', 'Margarina Mavesa 24x250 MG', 26.00, 28.00, 'Margarina Mavesa 250 MG', 5000, 10, 1, 1, 1, 1, '2025-02-03 02:42:05', '2025-02-03 02:42:05'),
	(63, '67a02d38d2c54', 'Margarina Mavesa  12x500 MG', 25.00, 26.50, 'Margarina Mavesa  12x500 MG', 5000, 10, 1, 1, 1, 1, '2025-02-03 02:43:04', '2025-02-03 02:43:04');

-- 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=4 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-02-01 17:48:24', '2025-02-01 17:48:24', NULL),
	(2, 'Administrador', 1, '2025-02-01 17:48:24', '2025-02-01 17:48:24', NULL),
	(3, 'Cliente', 1, '2025-02-01 17:48:24', '2025-02-01 17:48:24', 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: ~2 rows (aproximadamente)
DELETE FROM `role_user`;
INSERT INTO `role_user` (`user_id`, `role_id`) VALUES
	(1, 1),
	(2, 2);

-- 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, '0001', 1, NULL, NULL);

-- 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-02-01', 1, 2, 1, '2025-02-01 17:54:15', '2025-02-01 17:54:15'),
	(2, 47.8, '2025-02-02', 1, 2, 1, '2025-02-03 02:13:01', '2025-02-03 02:13:01');

-- 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=5 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

-- Volcando datos para la tabla larapos.tipo_dispositivos: ~3 rows (aproximadamente)
DELETE FROM `tipo_dispositivos`;
INSERT INTO `tipo_dispositivos` (`id`, `name`, `created_at`, `updated_at`) VALUES
	(1, 'Desktop', '2025-02-01 17:54:14', '2025-02-01 17:54:14'),
	(2, 'Desktop', '2025-02-02 00:24:14', '2025-02-02 00:24:14'),
	(3, 'Desktop', '2025-02-02 00:32:21', '2025-02-02 00:32:21'),
	(4, 'Desktop', '2025-02-03 02:13:00', '2025-02-03 02:13:00');

-- 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 AUTO_INCREMENT=10 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

-- Volcando datos para la tabla larapos.wishlists: ~8 rows (aproximadamente)
DELETE FROM `wishlists`;
INSERT INTO `wishlists` (`id`, `producto_id`, `user_id`, `created_at`, `updated_at`) VALUES
	(1, 8, 2, '2025-02-01 18:18:28', '2025-02-01 18:18:28'),
	(2, 7, 2, '2025-02-01 18:18:31', '2025-02-01 18:18:31'),
	(3, 21, 2, '2025-02-02 01:06:50', '2025-02-02 01:06:50'),
	(4, 20, 2, '2025-02-02 01:06:52', '2025-02-02 01:06:52'),
	(5, 22, 2, '2025-02-02 01:08:21', '2025-02-02 01:08:21'),
	(6, 23, 2, '2025-02-02 01:08:23', '2025-02-02 01:08:23'),
	(7, 35, 2, '2025-02-02 01:21:42', '2025-02-02 01:21:42'),
	(8, 34, 2, '2025-02-02 01:21:44', '2025-02-02 01:21:44'),
	(9, 33, 2, '2025-02-02 01:21:45', '2025-02-02 01:21:45');

