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



-- Volcando estructura de base de datos para ventavui
CREATE DATABASE IF NOT EXISTS `ventavui` /*!40100 DEFAULT CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci */ /*!80016 DEFAULT ENCRYPTION='N' */;
USE `ventavui`;

-- Volcando estructura para tabla ventavui.categories
CREATE TABLE IF NOT EXISTS `categories` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `name` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `status` 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=54 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

-- Volcando datos para la tabla ventavui.categories: ~16 rows (aproximadamente)
INSERT INTO `categories` (`id`, `name`, `status`, `created_at`, `updated_at`) VALUES
	(1, 'BEBIDAS Y REFRIGERADOS	', 'activo', '2024-05-01 04:05:25', '2024-05-01 04:05:35'),
	(2, 'GALLETAS', 'activo', '2024-05-01 04:19:38', '2024-05-04 07:44:35'),
	(3, 'COMIDAS', 'activo', '2024-05-01 04:05:25', '2024-05-01 04:05:25'),
	(4, 'ELECTRODOMESTICOS', 'activo', '2023-01-25 19:41:14', '2024-05-01 04:05:25'),
	(5, 'AGUNA MINERAL', 'activo', '2023-01-25 19:43:06', '2024-05-17 21:01:16'),
	(6, 'MEDICAMENTOS', 'activo', '2023-01-25 19:44:51', '2024-05-17 21:00:32'),
	(8, 'AUDIFONOS', 'activo', '2023-01-25 22:49:21', '2024-05-17 21:00:50'),
	(9, 'PARLANTES', 'activo', '2023-01-25 22:54:06', '2024-05-17 21:01:03'),
	(11, 'REGALOS', 'activo', '2023-01-30 04:01:42', '2024-05-17 21:01:42'),
	(12, 'ACCESORIOS INFORMATICOS', 'activo', '2024-01-19 16:23:08', '2024-05-17 21:02:06'),
	(13, 'VINOS', 'activo', '2024-01-25 07:01:17', '2024-05-01 04:05:25'),
	(14, 'PISCO', 'activo', '2024-01-25 07:01:34', '2024-05-01 04:05:25'),
	(49, 'ENERGIZANTES', 'activo', '2024-05-10 11:08:50', '2024-05-17 21:02:31'),
	(50, 'VOTKA', 'activo', '2024-05-17 21:02:55', '2024-05-17 21:02:55'),
	(51, 'RON', 'activo', '2024-05-17 21:03:06', '2024-05-17 21:03:06'),
	(52, 'WHISKY', 'activo', '2024-05-17 21:03:31', '2024-05-17 21:03:31'),
	(53, 'TEKILA', 'activo', '2024-05-17 21:03:49', '2024-05-17 21:03:49');

-- Volcando estructura para tabla ventavui.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 ventavui.failed_jobs: ~0 rows (aproximadamente)

-- Volcando estructura para tabla ventavui.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=11 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

-- Volcando datos para la tabla ventavui.migrations: ~10 rows (aproximadamente)
INSERT INTO `migrations` (`id`, `migration`, `batch`) VALUES
	(1, '2014_10_12_000000_create_users_table', 1),
	(2, '2014_10_12_100000_create_password_reset_tokens_table', 1),
	(3, '2019_08_19_000000_create_failed_jobs_table', 1),
	(4, '2019_12_14_000001_create_personal_access_tokens_table', 1),
	(5, '2024_05_01_032505_create_categories_table', 2),
	(6, '2024_05_09_160345_create_product_table', 3),
	(7, '2024_05_09_161253_create_product_table', 4),
	(8, '2024_05_10_174613_create_shoppings_table', 5),
	(9, '2024_05_14_161328_create_suppliers_table', 6),
	(10, '2024_05_17_025014_create_sales_table', 7);

-- Volcando datos para la tabla ventavui.personal_access_tokens: ~0 rows (aproximadamente)

-- Volcando estructura para tabla ventavui.product
CREATE TABLE IF NOT EXISTS `product` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `code_barra` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `name` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `description` text COLLATE utf8mb4_unicode_ci,
  `stock` int DEFAULT NULL,
  `minimum_stock` int DEFAULT NULL,
  `maximum_stock` int DEFAULT NULL,
  `purchase_price` decimal(10,2) DEFAULT NULL,
  `sale_price` decimal(10,2) DEFAULT NULL,
  `admission_date` date DEFAULT NULL,
  `image` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `unit_id` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `user_id` bigint unsigned DEFAULT NULL,
  `category_id` bigint unsigned DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `status` varchar(120) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `product_code_barra_unique` (`code_barra`),
  UNIQUE KEY `code_barra` (`code_barra`),
  KEY `product_user_id_foreign` (`user_id`),
  KEY `product_category_id_foreign` (`category_id`),
  CONSTRAINT `product_category_id_foreign` FOREIGN KEY (`category_id`) REFERENCES `categories` (`id`) ON DELETE CASCADE,
  CONSTRAINT `product_user_id_foreign` FOREIGN KEY (`user_id`) REFERENCES `users` (`id`) ON DELETE CASCADE
) ENGINE=InnoDB AUTO_INCREMENT=172 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

-- Volcando datos para la tabla ventavui.product: ~145 rows (aproximadamente)
INSERT INTO `product` (`id`, `code_barra`, `name`, `description`, `stock`, `minimum_stock`, `maximum_stock`, `purchase_price`, `sale_price`, `admission_date`, `image`, `unit_id`, `user_id`, `category_id`, `created_at`, `updated_at`, `status`) VALUES
	(6, '6239569089087', 'smarwach', NULL, 97, 1, 50, 30.00, 43.00, '2024-01-23', 'images/product/1728881044.png', NULL, 1, 1, '2024-01-23 06:33:50', '2024-10-14 09:44:04', 'activo'),
	(9, '7750533001786', 'Tabernero gran rosé tuyo 750 LG', 'Tabernero gran rosé tuyo 750', 14, 1, 12, 13.00, 18.00, '2024-01-29', 'images/product/1715322506.png', NULL, 1, 13, NULL, '2025-02-25 10:29:00', 'activo'),
	(10, '7758218195959', 'Santiago queirolo borgoña semiseco 750', 'Santiago queirolo borgoña semiseco 750', 40, 6, 12, 12.00, 17.00, '2024-01-29', 'images/product/1715322774.png', NULL, 1, 13, NULL, '2025-02-25 10:18:39', 'inactivo'),
	(14, '7', 'Tabernero gran rose semiseco afrutado 750', NULL, 3, 0, 0, 13.00, 18.00, '2024-01-30', 'images/product/1728881114.png', NULL, 1, 13, NULL, '2025-02-25 10:29:00', 'activo'),
	(15, '8', 'Tabernero borgoña vino tinto semi seco 750', NULL, 0, 0, 0, 13.00, 18.00, '2024-01-30', 'images/product/1728881177.png', NULL, 1, 13, NULL, '2024-10-14 09:49:08', 'activo'),
	(17, '10', 'Mistela vino dulce don salvatore 750', NULL, 0, 0, 0, 8.33, 15.00, '2024-01-30', 'images/product/1728881326.png', NULL, 1, 13, NULL, '2024-10-14 09:48:46', 'activo'),
	(18, '11', 'Borgoña semiseco don salvatore 750', '', 0, 0, 0, 8.33, 15.00, '2024-01-30', '2024-01-30-01-25-21__9.png', NULL, 1, 1, NULL, '2024-01-30 06:25:21', 'activo'),
	(19, '12', 'Baileti vino con sabor a higo 750', NULL, 0, 0, 0, 8.33, 15.00, '2024-01-30', 'images/product/1728881420.png', NULL, 1, 13, NULL, '2024-10-14 09:50:20', 'activo'),
	(20, '13', 'Baileti mistela vino dulce', NULL, 12, 0, 0, 8.33, 15.00, '2024-01-30', 'images/product/1728881492.png', NULL, 1, 13, NULL, '2024-10-15 09:52:54', 'activo'),
	(21, '14', 'Viña el paraiso rose semiseco 750', NULL, 0, NULL, NULL, 7.08, 11.00, NULL, 'images/product/1728881807.png', NULL, 1, 13, NULL, '2024-10-14 09:56:47', 'activo'),
	(23, '16', 'La finkana vino', NULL, 0, NULL, NULL, 8.00, 13.00, NULL, NULL, NULL, 1, 1, NULL, NULL, 'activo'),
	(24, '17', 'Gran rose afrutado emperador', NULL, 0, NULL, NULL, 8.00, 16.00, NULL, NULL, NULL, 1, 1, NULL, NULL, 'activo'),
	(25, '18', 'Viña vieja gran borgoña semiseco', NULL, 0, NULL, NULL, 8.00, 16.00, NULL, 'images/product/1728965529.png', NULL, 1, 13, NULL, '2024-10-15 09:12:09', 'activo'),
	(26, '19', 'Viña vieja gran rose semi seco', NULL, 0, NULL, NULL, 8.00, 16.00, NULL, 'images/product/1728965598.png', NULL, 1, 13, NULL, '2024-10-15 09:13:18', 'activo'),
	(27, '20', 'Johnnie walker black label 750 whisky', NULL, 0, NULL, NULL, 100.00, 120.00, NULL, 'images/product/1728965667.png', NULL, 1, 52, NULL, '2024-10-15 09:14:27', 'activo'),
	(28, '5000267014005', 'Johnnie walker red label 750 whisky', NULL, 0, NULL, NULL, 46.00, 62.00, NULL, 'images/product/1728965767.png', NULL, 1, 52, NULL, '2024-10-15 09:16:07', 'activo'),
	(29, '7751738001489', 'Old times red 750 whisky Red', NULL, 0, 5, 24, 18.50, 25.00, '2024-05-17', 'images/product/1715994837.jpg', NULL, 1, 52, NULL, '2024-05-18 06:15:16', 'activo'),
	(31, '5010106113073', 'Ballantines 750 whisky', NULL, 0, NULL, NULL, 38.00, 48.00, NULL, 'images/product/1728965900.png', NULL, 1, 52, NULL, '2024-10-15 09:18:20', 'activo'),
	(32, '5000292261115', 'Vat 69 whisky', NULL, 0, NULL, NULL, 22.00, 27.00, NULL, 'images/product/1728965948.png', NULL, 1, 52, NULL, '2024-10-15 09:19:08', 'activo'),
	(33, '5000299210048', 'Passport whisky 759 ml', 'Passport whisky 759 ml', 0, NULL, NULL, 22.00, 27.00, NULL, 'images/product/1728966009.png', NULL, 1, 52, NULL, '2024-10-15 09:20:09', 'activo'),
	(34, '27', 'Jack Danniel 750 whisky', NULL, 0, NULL, NULL, 100.00, 120.00, NULL, 'images/product/1728966063.png', NULL, 1, 52, NULL, '2024-10-15 09:21:03', 'activo'),
	(35, '5000281003160', 'Grand old parr', NULL, 0, NULL, NULL, 85.00, 98.00, NULL, 'images/product/1728966120.png', NULL, 1, 52, NULL, '2024-10-15 09:22:00', 'activo'),
	(36, '7758218000024', 'Santiago queirolo pisco acholado 750', NULL, 0, 6, 50, 2.00, 28.00, '2024-09-16', 'images/product/1726533748.png', NULL, 1, 14, NULL, '2024-09-17 05:42:28', 'activo'),
	(37, '7750533001564', 'Tabernero pisco acholado la botija', NULL, 0, NULL, NULL, 25.00, 33.00, NULL, 'images/product/1728966195.png', NULL, 1, 14, NULL, '2024-10-15 09:23:15', 'activo'),
	(38, '7758645079174', 'Pisco vagas acholado 750', NULL, 0, NULL, NULL, 24.00, 31.00, NULL, 'images/product/1728966243.png', NULL, 1, 14, NULL, '2024-10-15 09:24:03', 'activo'),
	(39, '32', 'Pisco vagas quebranta 750', NULL, 0, NULL, NULL, 24.00, 31.00, NULL, 'images/product/1728966323.png', NULL, 1, 14, NULL, '2024-10-15 09:25:23', 'activo'),
	(40, '7752933001281', 'Pisco ocucaje acholado 750', NULL, 0, NULL, NULL, 26.00, 33.00, NULL, 'images/product/1728966389.png', NULL, 1, 14, NULL, '2024-10-15 09:26:29', 'activo'),
	(41, '34', 'Pisco porto', NULL, 0, NULL, NULL, 74.00, 84.00, NULL, 'images/product/1728966437.png', NULL, 1, 14, NULL, '2024-10-15 09:27:17', 'activo'),
	(43, '7751738002646', 'Ron cabo blanco durazno 1litro', NULL, 0, NULL, NULL, 14.00, 22.00, NULL, 'images/product/1728966535.png', NULL, 1, 51, NULL, '2024-10-15 09:28:55', 'activo'),
	(44, '37', 'Ron cartavio superio 750', NULL, 0, NULL, NULL, 21.00, 26.00, NULL, 'images/product/1728966603.png', NULL, 1, 51, NULL, '2024-10-15 09:30:03', 'activo'),
	(45, '38', 'Ron cartavio black 750', NULL, 0, NULL, NULL, 21.00, 26.00, NULL, 'images/product/1728966658.png', NULL, 1, 51, NULL, '2024-10-15 09:30:58', 'activo'),
	(46, '5000299223017', 'Ron captain morgan 750', NULL, 0, NULL, NULL, 32.00, 38.00, NULL, 'images/product/1728966714.png', NULL, 1, 51, NULL, '2024-10-15 09:31:54', 'activo'),
	(47, '7702049100576', 'Ron medellin 750', NULL, 0, NULL, NULL, 26.00, 33.00, NULL, 'images/product/1728966759.png', NULL, 1, 51, NULL, '2024-10-15 09:32:39', 'activo'),
	(49, '7751738000673', 'Russ kaya 750 vodka', NULL, 0, NULL, NULL, 18.00, 25.00, NULL, NULL, NULL, 1, 1, NULL, NULL, 'activo'),
	(50, '7751738004138', 'Russ kaya  sabores 750 vodka Manzana', NULL, 0, NULL, NULL, 19.00, 26.00, NULL, 'images/product/1728966809.png', NULL, 1, 50, NULL, '2024-10-15 09:33:29', 'activo'),
	(51, '7759665000223', 'Perusnka 750 sabores vodka', NULL, 0, NULL, NULL, 19.00, 26.00, NULL, NULL, NULL, 1, 1, NULL, NULL, 'activo'),
	(52, '45', 'Smirnoff green 750 apple vodka', NULL, 0, NULL, NULL, 32.00, 38.00, NULL, NULL, NULL, 1, 1, NULL, NULL, 'activo'),
	(53, '7759683000274', 'Montana vodka 750 Pink', NULL, 0, NULL, NULL, 11.00, 16.00, NULL, NULL, NULL, 1, 1, NULL, NULL, 'activo'),
	(54, '7750533001397', 'Chilcano bar Limon', NULL, 0, NULL, NULL, 4.50, 6.00, NULL, NULL, NULL, 1, 1, NULL, NULL, 'activo'),
	(55, '48', 'Hits', NULL, 0, NULL, NULL, 4.50, 6.00, NULL, NULL, NULL, 1, 1, NULL, NULL, 'activo'),
	(56, '849806001206', 'Fou loko Zandilla', NULL, 0, NULL, NULL, 8.90, 12.00, NULL, NULL, NULL, 1, 1, NULL, NULL, 'activo'),
	(57, '7503026724859', 'Mikes Limon', NULL, 0, NULL, NULL, 4.50, 6.50, NULL, NULL, NULL, 1, 1, NULL, NULL, 'activo'),
	(58, '75032715', 'Corona 355', NULL, 0, NULL, NULL, 5.00, 6.50, NULL, NULL, NULL, 1, 1, NULL, NULL, 'activo'),
	(59, '7503034941385', 'Corona tropical', NULL, 0, NULL, NULL, 5.00, 6.50, NULL, NULL, NULL, 1, 1, NULL, NULL, 'activo'),
	(60, '7753749002028', 'Pilsen lata six 355 ml', 'Pilsen lata six 355 ml', 0, NULL, NULL, 20.00, 25.00, NULL, NULL, NULL, 1, 1, NULL, '2024-05-10 12:44:35', 'activo'),
	(63, '7750321943625', 'jarabe de goma', NULL, 0, NULL, NULL, 14.00, 18.00, NULL, NULL, NULL, 1, 1, NULL, NULL, 'activo'),
	(64, '57', 'crema mama mia', NULL, 0, NULL, NULL, 18.00, 25.00, NULL, NULL, NULL, 1, 1, NULL, NULL, 'activo'),
	(65, '58', 'Tres montes crema', NULL, 0, NULL, NULL, 18.00, 25.00, NULL, NULL, NULL, 1, 1, NULL, NULL, 'activo'),
	(66, '59', 'Cavas de ica macerado en pisco', NULL, 0, NULL, NULL, 20.00, 25.00, NULL, NULL, NULL, 1, 1, NULL, NULL, 'activo'),
	(67, '60', 'Viña san vicente macerado', NULL, 0, NULL, NULL, 14.00, 20.00, NULL, NULL, NULL, 1, 1, NULL, NULL, 'activo'),
	(69, '166', 'Santiago queirolo rosé semi seco 750', NULL, 0, NULL, NULL, 12.00, 17.00, NULL, NULL, NULL, 1, 1, NULL, NULL, 'activo'),
	(70, '266', 'Tabernero gran rosé semi seco 750', NULL, 0, NULL, NULL, 13.00, 18.00, NULL, NULL, NULL, 1, 1, NULL, NULL, 'activo'),
	(72, '466', 'Borgoña semiseco emperador 750', NULL, 0, NULL, NULL, 11.00, 16.00, NULL, NULL, NULL, 1, 1, NULL, NULL, 'activo'),
	(75, '766', 'Tabernero gran rose semiseco afrutado 750', NULL, 0, NULL, NULL, 13.00, 18.00, NULL, NULL, NULL, 1, 1, NULL, NULL, 'activo'),
	(76, '866', 'Tabernero borgoña vino tinto semi seco 750', NULL, 0, NULL, NULL, 13.00, 18.00, NULL, NULL, NULL, 1, 1, NULL, '2024-05-17 20:35:46', 'activo'),
	(77, '966', 'Dinastia borgoña tinto semi seco 750', NULL, 0, NULL, NULL, 13.00, 17.00, NULL, NULL, NULL, 1, 1, NULL, NULL, 'activo'),
	(78, '109', 'Mistela vino dulce don salvatore 750', NULL, 0, NULL, NULL, 8.33, 15.00, NULL, NULL, NULL, 1, 1, NULL, NULL, 'activo'),
	(79, '119', 'Borgoña semiseco don salvatore 750', NULL, 0, NULL, NULL, 8.33, 15.00, NULL, NULL, NULL, 1, 1, NULL, NULL, 'activo'),
	(80, '129', 'Baileti vino con sabor a higo 750', NULL, 0, NULL, NULL, 8.33, 15.00, NULL, NULL, NULL, 1, 1, NULL, NULL, 'activo'),
	(81, '139', 'Baileti mistela vino dulce', NULL, 0, NULL, NULL, 8.33, 15.00, NULL, NULL, NULL, 1, 1, NULL, NULL, 'activo'),
	(82, '149', 'Viña el paraiso rose semiseco 750', NULL, 0, NULL, NULL, 7.08, 11.00, NULL, NULL, NULL, 1, 1, NULL, NULL, 'activo'),
	(83, '159', 'Viña el paraiso borgoña semiseco  vino tinto 751', NULL, 0, NULL, NULL, 7.08, 11.00, NULL, NULL, NULL, 1, 1, NULL, NULL, 'activo'),
	(85, '1799', 'Gran rose afrutado emperador', NULL, 0, NULL, NULL, 8.00, 16.00, NULL, NULL, NULL, 1, 1, NULL, NULL, 'activo'),
	(86, '189', 'Viña vieja gran borgoña semiseco', NULL, 0, NULL, NULL, 8.00, 16.00, NULL, NULL, NULL, 1, 1, NULL, NULL, 'activo'),
	(87, '199', 'Viña vieja gran rose semi seco', NULL, 0, NULL, NULL, 8.00, 16.00, NULL, NULL, NULL, 1, 1, NULL, NULL, 'activo'),
	(88, '209', 'Johnnie walker black label 750 whisky', NULL, 0, NULL, NULL, 100.00, 120.00, NULL, NULL, NULL, 1, 1, NULL, NULL, 'activo'),
	(89, '50002670140059', 'Johnnie walker red label 750 whisky', NULL, 0, NULL, NULL, 46.00, 62.00, NULL, NULL, NULL, 1, 1, NULL, NULL, 'activo'),
	(91, '239', 'Sir lukas 750 whisky red', NULL, 0, NULL, NULL, 18.50, 25.00, NULL, NULL, NULL, 1, 1, NULL, NULL, 'activo'),
	(92, '50101061130739', 'Ballantines 750 whisky', NULL, 0, NULL, NULL, 38.00, 48.00, NULL, NULL, NULL, 1, 1, NULL, NULL, 'activo'),
	(93, '50002922611159', 'Vat 69 whisky', NULL, 0, NULL, NULL, 22.00, 27.00, NULL, NULL, NULL, 1, 1, NULL, NULL, 'activo'),
	(94, '50002992100489', 'Passport whisky', NULL, 0, NULL, NULL, 22.00, 27.00, NULL, NULL, NULL, 1, 1, NULL, NULL, 'activo'),
	(95, '279', 'Jack Danniel 750 whisky', NULL, 0, NULL, NULL, 100.00, 120.00, NULL, NULL, NULL, 1, 1, NULL, NULL, 'activo'),
	(96, '50002810031609', 'Grand old parr', NULL, 0, NULL, NULL, 85.00, 98.00, NULL, NULL, NULL, 1, 1, NULL, NULL, 'activo'),
	(97, '77582180000249', 'Santiago queirolo pisco Italia 750', NULL, 0, NULL, NULL, 24.00, 30.00, NULL, NULL, NULL, 1, 14, NULL, '2024-09-17 05:40:59', 'activo'),
	(98, '77505330015649', 'Tabernero pisco acholado la botija', NULL, 0, NULL, NULL, 25.00, 33.00, NULL, NULL, NULL, 1, 1, NULL, NULL, 'activo'),
	(99, '77586450791749', 'Pisco vagas acholado 750', NULL, 0, NULL, NULL, 24.00, 31.00, NULL, NULL, NULL, 1, 1, NULL, NULL, 'activo'),
	(100, '329', 'Pisco vagas quebranta 750', NULL, 0, NULL, NULL, 24.00, 31.00, NULL, NULL, NULL, 1, 1, NULL, NULL, 'activo'),
	(101, '77529330012819', 'Pisco ocucaje acholado 750', NULL, 0, NULL, NULL, 26.00, 33.00, NULL, NULL, NULL, 1, 1, NULL, NULL, 'activo'),
	(102, '3499', 'Pisco porto', NULL, 0, NULL, NULL, 74.00, 84.00, NULL, NULL, NULL, 1, 1, NULL, NULL, 'activo'),
	(103, '3599', 'Bailetti puro quebrada 750', NULL, 0, NULL, NULL, 8.00, 15.00, NULL, NULL, NULL, 1, 1, NULL, NULL, 'activo'),
	(104, '77517380026469', 'Ron cabo blanco durazno 1litro', NULL, 0, NULL, NULL, 14.00, 22.00, NULL, NULL, NULL, 1, 1, NULL, NULL, 'activo'),
	(105, '379', 'Ron cartavio superio 750', NULL, 0, NULL, NULL, 21.00, 26.00, NULL, NULL, NULL, 1, 1, NULL, NULL, 'activo'),
	(106, '389', 'Ron cartavio black 750', NULL, 0, NULL, NULL, 21.00, 26.00, NULL, NULL, NULL, 1, 1, NULL, NULL, 'activo'),
	(107, '50002992230179', 'Ron captain morgan 750', NULL, 0, NULL, NULL, 32.00, 38.00, NULL, NULL, NULL, 1, 1, NULL, NULL, 'activo'),
	(108, '770204910057699', 'Ron medellin 750', NULL, 0, NULL, NULL, 26.00, 33.00, NULL, NULL, NULL, 1, 1, NULL, NULL, 'activo'),
	(109, '419', 'Ron tress montes 750', NULL, 0, NULL, NULL, 15.00, 21.00, NULL, NULL, NULL, 1, 1, NULL, '2024-05-10 12:42:55', 'inactivo'),
	(110, '77517380006739', 'Russ kaya 750 vodka', NULL, 0, NULL, NULL, 18.00, 25.00, NULL, NULL, NULL, 1, 1, NULL, NULL, 'activo'),
	(112, '77596650002239', 'Perusnka 750 sabores vodka', NULL, 0, NULL, NULL, 19.00, 26.00, NULL, NULL, NULL, 1, 1, NULL, NULL, 'activo'),
	(113, '459', 'Smirnoff green 750 apple vodka', NULL, 0, NULL, NULL, 32.00, 38.00, NULL, NULL, NULL, 1, 1, NULL, NULL, 'activo'),
	(114, '77596830002749', 'Montana vodka 750 Pink', NULL, 0, NULL, NULL, 11.00, 16.00, NULL, NULL, NULL, 1, 1, NULL, NULL, 'activo'),
	(115, '77505330013979', 'Chilcano bar Limon', NULL, 0, NULL, NULL, 4.50, 6.00, NULL, NULL, NULL, 1, 1, NULL, NULL, 'activo'),
	(116, '489', 'Hits', NULL, 0, NULL, NULL, 4.50, 6.00, NULL, NULL, NULL, 1, 1, NULL, NULL, 'activo'),
	(117, '8498060012069', 'Fou loko Zandilla', NULL, 0, NULL, NULL, 8.90, 12.00, NULL, NULL, NULL, 1, 1, NULL, NULL, 'activo'),
	(118, '75030267248599', 'Mikes Limon', NULL, 0, NULL, NULL, 4.50, 6.50, NULL, NULL, NULL, 1, 1, NULL, NULL, 'activo'),
	(119, '750327159', 'Corona 355', NULL, 0, NULL, NULL, 5.00, 6.50, NULL, NULL, NULL, 1, 1, NULL, NULL, 'activo'),
	(120, '75030349413859', 'Corona tropical', NULL, 0, NULL, NULL, 5.00, 6.50, NULL, NULL, NULL, 1, 1, NULL, NULL, 'activo'),
	(121, '77537490020289', 'Pilsen lata six', NULL, 0, NULL, NULL, 20.00, 25.00, NULL, NULL, NULL, 1, 1, NULL, NULL, 'activo'),
	(122, '77537490033609', 'Cusqueña negra six 355 lm', 'Cusqueña negra six 355 lm', 0, NULL, NULL, 27.00, 27.00, NULL, NULL, NULL, 1, 1, NULL, '2024-05-10 12:42:30', 'activo'),
	(123, '559', 'Golden six pequeño 355 ml', 'Golden six pequeño 355 ml', 0, NULL, NULL, 13.00, 18.50, NULL, NULL, NULL, 1, 1, NULL, '2024-05-10 12:42:11', 'activo'),
	(124, '77503219436259', 'jarabe de goma', NULL, 0, NULL, NULL, 14.00, 18.00, NULL, NULL, NULL, 1, 1, NULL, NULL, 'activo'),
	(125, '579', 'crema mama mia', NULL, 0, NULL, NULL, 18.00, 25.00, NULL, NULL, NULL, 1, 1, NULL, NULL, 'activo'),
	(126, '589', 'Tres montes crema', NULL, 0, NULL, NULL, 18.00, 25.00, NULL, NULL, NULL, 1, 1, NULL, NULL, 'activo'),
	(127, '599', 'Cavas de ica macerado en pisco', NULL, 0, NULL, NULL, 20.00, 25.00, NULL, NULL, NULL, 1, 1, NULL, NULL, 'activo'),
	(128, '609', 'Viña san vicente macerado', NULL, 0, NULL, NULL, 14.00, 20.00, NULL, NULL, NULL, 1, 1, NULL, NULL, 'activo'),
	(129, '40677000153109', 'Jagermeister ', NULL, 0, NULL, NULL, 58.00, 70.00, NULL, NULL, NULL, 1, 1, NULL, NULL, 'activo'),
	(130, '629', 'vogoña chicle', NULL, 0, NULL, NULL, 13.00, 18.00, NULL, NULL, NULL, 1, 1, NULL, NULL, 'activo'),
	(131, '77501820060959', 'Coca Cola Personal 600', NULL, 0, NULL, NULL, 0.00, 3.00, NULL, NULL, NULL, 1, 1, NULL, NULL, 'activo'),
	(132, '2139', 'Coca Cola 1L', NULL, 0, NULL, NULL, 0.00, 6.00, NULL, NULL, NULL, 1, 1, NULL, NULL, 'activo'),
	(133, '77501820016879', 'COCA COLA 2.5L', 'COCA COLA 2.5L', 12, 6, 24, 9.00, 10.00, '2024-05-10', 'images/product/1715323175.png', NULL, 1, 1, NULL, '2024-05-10 11:39:57', 'activo'),
	(134, '2131239', 'INCA KOLA PERSONAL 600', NULL, 0, NULL, NULL, 0.00, 3.00, NULL, NULL, NULL, 1, 1, NULL, NULL, 'activo'),
	(135, '1232349', 'INCA KOLA 2.5 LITROS', NULL, 0, NULL, NULL, 0.00, 9.50, NULL, NULL, NULL, 1, 1, NULL, NULL, 'activo'),
	(136, '1231239', 'PAWER ADER', NULL, 0, NULL, NULL, 0.00, 2.00, NULL, NULL, NULL, 1, 1, NULL, NULL, 'activo'),
	(137, '77517310057369', 'GENERADE GRANDE', NULL, 0, NULL, NULL, 0.00, 3.50, NULL, NULL, NULL, 1, 1, NULL, NULL, 'activo'),
	(138, '77517310034049', 'GENERADE PERSONAL Azul', NULL, 0, NULL, NULL, 0.00, 2.00, NULL, NULL, NULL, 1, 1, NULL, NULL, 'activo'),
	(139, '77517310000699', 'AGUA CIELO 2.5L', NULL, 0, NULL, NULL, 0.00, 4.00, NULL, NULL, NULL, 1, 1, NULL, NULL, 'activo'),
	(140, '77517310007009', 'KRIS 1.5 L', NULL, 0, NULL, NULL, 0.00, 3.50, NULL, NULL, NULL, 1, 1, NULL, NULL, 'activo'),
	(141, '349', 'KRIS 3 LITROS', NULL, 0, NULL, NULL, 0.00, 7.00, NULL, NULL, NULL, 1, 1, NULL, NULL, 'activo'),
	(142, '77517310046309', '360 ENERGY GRANDE', NULL, 0, NULL, NULL, 0.00, 3.50, NULL, NULL, NULL, 1, 1, NULL, NULL, 'activo'),
	(143, '77517310029719', '360 ENERGY PEQUEÑA', NULL, 0, NULL, NULL, 0.00, 2.00, NULL, NULL, NULL, 1, 1, NULL, NULL, 'activo'),
	(144, '4599', '360 LATA', NULL, 0, NULL, NULL, 0.00, 4.50, NULL, NULL, NULL, 1, 1, NULL, '2024-05-10 12:40:13', 'inactivo'),
	(145, '87120009006639', 'Heineken', NULL, 0, NULL, NULL, 0.00, 6.00, NULL, NULL, NULL, 1, 1, NULL, NULL, 'activo'),
	(146, '2239', 'Red Bull', NULL, 0, NULL, NULL, 0.00, 7.50, NULL, NULL, NULL, 1, 1, NULL, NULL, 'activo'),
	(147, '679', 'MONSTER ENERGY DRINK,Monster Energy Drinks', NULL, 0, NULL, NULL, 0.00, 7.50, NULL, NULL, NULL, 1, 1, NULL, NULL, 'activo'),
	(148, '4549', 'PASSPORT  WHISKY 750', 'PASSPORT  WHISKY 750', 0, NULL, NULL, 0.00, 27.00, NULL, NULL, NULL, 1, 1, NULL, '2024-05-10 12:39:53', 'activo'),
	(149, '7759307015349', 'Electrolight Granadilla', NULL, 0, NULL, NULL, 0.00, 2.00, NULL, NULL, NULL, 1, 1, NULL, '2024-05-10 12:39:22', 'inactivo'),
	(150, '7753749001632', 'Guarana 2 Litros', NULL, 15, 6, 24, 5.00, 6.00, '2024-05-10', 'images/product/1715326602.png', NULL, 1, 1, NULL, '2024-05-10 12:36:42', 'activo'),
	(151, '7750533001434', 'Tabernero pisco sour Mango', NULL, 0, NULL, NULL, 0.00, 22.00, NULL, NULL, NULL, 1, 1, NULL, NULL, 'activo'),
	(152, '7753749004961', 'Pilsen Lata Grande 473 ml', 'Pilsen Lata Grande 473 ml', 15, 12, 30, 24.00, 30.00, '2024-05-10', 'images/product/1715326494.png', NULL, 1, 1, NULL, '2024-05-10 12:34:54', 'activo'),
	(153, '2i3', 'WILL EXTREMO,Will extremo', NULL, 0, NULL, NULL, 0.00, 7.00, NULL, NULL, NULL, 1, 1, NULL, NULL, 'activo'),
	(154, '343', 'OLD TIMES RED 750 NE,Old times red 750 negro', NULL, 0, NULL, NULL, 0.00, 27.00, NULL, NULL, NULL, 1, 1, NULL, NULL, 'activo'),
	(155, '721059637503', 'Kkyy vodka infusions', NULL, 0, NULL, NULL, 0.00, 48.00, NULL, NULL, NULL, 1, 1, NULL, NULL, 'activo'),
	(156, '219', 'KR 2L', NULL, 0, NULL, NULL, 0.00, 5.00, NULL, NULL, NULL, 1, 1, NULL, '2024-10-14 09:59:34', 'activo'),
	(157, '77517310024909', 'KR Black', NULL, 0, NULL, NULL, 0.00, 3.50, NULL, NULL, NULL, 1, 1, NULL, '2024-05-10 12:32:13', 'inactivo'),
	(158, '3297', 'BAILEYS,Baileys', NULL, 0, NULL, NULL, 0.00, 70.00, NULL, NULL, NULL, 1, 1, NULL, '2024-05-10 12:32:04', 'inactivo'),
	(159, '2389', 'DE LA VIñA ROSE SEMI,de la viña rose semiseco', NULL, 0, NULL, NULL, 0.00, 25.00, NULL, NULL, NULL, 1, 1, NULL, '2024-05-10 12:31:53', 'inactivo'),
	(160, '2369', 'EMPERADOR BORGOñA SE,Emperador borgoña semiseco', NULL, 0, NULL, NULL, 0.00, 17.00, NULL, NULL, NULL, 1, 1, NULL, '2024-05-10 12:31:45', 'inactivo'),
	(161, '2439', 'EVERVESS GINGER', NULL, 0, NULL, NULL, 0.00, 7.00, NULL, NULL, NULL, 1, 1, NULL, NULL, 'activo'),
	(162, '77501821878489', 'Sprite 2.5', NULL, 0, NULL, NULL, 0.00, 8.50, NULL, NULL, NULL, 1, 1, NULL, NULL, 'activo'),
	(163, '669', 'Sprite Pequeña', NULL, 0, NULL, NULL, 0.00, 3.00, NULL, NULL, NULL, 1, 1, NULL, NULL, 'activo'),
	(164, '889', 'SAN LUIS San Luis', NULL, 0, NULL, NULL, 0.00, 1.50, NULL, NULL, NULL, 1, 1, NULL, NULL, 'activo'),
	(165, '6689', 'Viñedo Las Casuarina', NULL, 0, NULL, NULL, 0.00, 13.00, NULL, NULL, NULL, 1, 1, NULL, NULL, 'activo'),
	(166, '26964177190', 'RON FLOR DE CAÑA 750 4 AÑOS', NULL, 0, NULL, NULL, 0.00, 43.00, NULL, NULL, NULL, 1, 1, NULL, NULL, 'activo'),
	(167, '77537490077649', 'GOLDEN GRANDE', NULL, 0, NULL, NULL, 20.00, 20.00, NULL, NULL, NULL, 1, 1, NULL, NULL, 'activo'),
	(169, '7750670012218', 'Volt 240', 'Volt 240', 5, 6, 20, 2.00, 2.50, '2024-05-10', 'images/product/1715321486.jpg', NULL, 1, 49, '2024-05-10 11:11:26', '2024-05-10 11:11:26', 'activo'),
	(170, '026964177190', 'Ron Flor de Caña 4 años', 'Ron Flor de Caña 4 años', 5, 6, 24, 36.00, 43.00, '2024-05-17', 'images/product/1715994673.jpg', NULL, NULL, 51, '2024-05-18 06:11:13', '2024-05-18 06:11:13', 'activo');

-- Volcando estructura para tabla ventavui.sales
CREATE TABLE IF NOT EXISTS `sales` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `user_id` bigint unsigned NOT NULL,
  `nroventa` varchar(250) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '',
  `totalpaid` decimal(10,2) NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `sales_user_id_foreign` (`user_id`),
  CONSTRAINT `sales_user_id_foreign` FOREIGN KEY (`user_id`) REFERENCES `users` (`id`) ON DELETE CASCADE
) ENGINE=InnoDB AUTO_INCREMENT=29 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

-- Volcando datos para la tabla ventavui.sales: ~14 rows (aproximadamente)
INSERT INTO `sales` (`id`, `user_id`, `nroventa`, `totalpaid`, `created_at`, `updated_at`) VALUES
	(13, 1, '001', 71.00, '2024-10-17 10:53:42', '2024-10-17 10:53:42'),
	(14, 1, '001', 71.00, '2024-10-17 10:57:10', '2024-10-17 10:57:10'),
	(15, 1, '001', 86.00, '2024-10-17 10:57:31', '2024-10-17 10:57:31'),
	(16, 1, '001', 121.00, '2024-10-17 10:57:43', '2024-10-17 10:57:43'),
	(17, 1, '001', 53.00, '2024-10-18 03:16:49', '2024-10-18 03:16:49'),
	(18, 1, '001', 44.00, '2024-10-18 03:17:41', '2024-10-18 03:17:41'),
	(19, 1, '001', 44.00, '2024-10-18 03:17:45', '2024-10-18 03:17:45'),
	(20, 1, '001', 35.00, '2024-10-18 03:18:50', '2024-10-18 03:18:50'),
	(21, 1, '001', 18.00, '2025-04-18 12:35:47', '2025-04-18 12:35:47'),
	(22, 1, '001', 18.00, '2025-04-18 12:53:06', '2025-04-18 12:53:06'),
	(23, 1, '001', 18.00, '2025-04-18 12:53:08', '2025-04-18 12:53:08'),
	(24, 1, '001', 18.00, '2025-04-18 12:59:04', '2025-04-18 12:59:04'),
	(25, 1, '001', 54.00, '2025-04-18 13:03:47', '2025-04-18 13:03:47'),
	(26, 1, '001', 36.00, '2025-04-18 13:08:10', '2025-04-18 13:08:10'),
	(27, 1, '001', 68.00, '2025-04-18 13:08:43', '2025-04-18 13:08:43'),
	(28, 2, '001', 18.00, '2025-04-18 13:22:19', '2025-04-18 13:22:19');

-- Volcando estructura para tabla ventavui.shoppings
CREATE TABLE IF NOT EXISTS `shoppings` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `product_id` bigint unsigned NOT NULL,
  `purchase_number` int NOT NULL,
  `purchase_date` date NOT NULL,
  `supplier_id` bigint unsigned NOT NULL,
  `voucher` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `user_id` bigint unsigned NOT NULL,
  `purchase_price` decimal(10,2) NOT NULL,
  `amount` int NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `shoppings_product_id_foreign` (`product_id`),
  KEY `shoppings_user_id_foreign` (`user_id`),
  CONSTRAINT `shoppings_product_id_foreign` FOREIGN KEY (`product_id`) REFERENCES `product` (`id`) ON DELETE CASCADE,
  CONSTRAINT `shoppings_user_id_foreign` FOREIGN KEY (`user_id`) REFERENCES `users` (`id`) ON DELETE CASCADE
) ENGINE=InnoDB AUTO_INCREMENT=26 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

-- Volcando datos para la tabla ventavui.shoppings: ~9 rows (aproximadamente)
INSERT INTO `shoppings` (`id`, `product_id`, `purchase_number`, `purchase_date`, `supplier_id`, `voucher`, `user_id`, `purchase_price`, `amount`, `created_at`, `updated_at`) VALUES
	(17, 9, 1, '2024-05-17', 1, '001', 1, 13.00, 10, '2024-05-17 17:50:09', '2024-05-17 17:50:09'),
	(18, 10, 1, '2024-10-11', 2, '001', 1, 12.00, 12, '2024-10-11 10:27:54', '2024-10-11 10:27:54'),
	(19, 9, 1, '2024-10-15', 2, '001', 1, 13.00, 1, '2024-10-15 09:51:41', '2024-10-15 09:51:41'),
	(20, 20, 1, '2024-10-15', 2, '001', 1, 8.33, 12, '2024-10-15 09:52:54', '2024-10-15 09:52:54'),
	(21, 10, 1, '2024-10-17', 2, '001', 1, 12.00, 1, '2024-10-17 06:01:06', '2024-10-17 06:01:06'),
	(22, 10, 1, '2025-02-25', 2, '001', 1, 12.00, 27, '2025-02-25 10:18:39', '2025-02-25 10:18:39'),
	(23, 9, 1, '2025-02-25', 2, '001', 1, 13.00, 1, '2025-02-25 10:27:38', '2025-02-25 10:27:38'),
	(24, 9, 1, '2025-02-25', 2, '001', 1, 13.00, 1, '2025-02-25 10:29:00', '2025-02-25 10:29:00'),
	(25, 14, 1, '2025-02-25', 2, '001', 1, 13.00, 3, '2025-02-25 10:29:00', '2025-02-25 10:29:00');

-- Volcando estructura para tabla ventavui.shopping_carts
CREATE TABLE IF NOT EXISTS `shopping_carts` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `amount` int NOT NULL,
  `product_id` int NOT NULL,
  `sales_id` int NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=35 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

-- Volcando datos para la tabla ventavui.shopping_carts: ~31 rows (aproximadamente)
INSERT INTO `shopping_carts` (`id`, `amount`, `product_id`, `sales_id`, `created_at`, `updated_at`) VALUES
	(1, 1, 2, 1, '2024-10-17 01:43:53', '2024-10-17 01:43:57'),
	(2, 1, 10, 14, '2024-10-17 10:57:10', '2024-10-17 10:57:10'),
	(3, 1, 9, 14, '2024-10-17 10:57:10', '2024-10-17 10:57:10'),
	(4, 1, 14, 14, '2024-10-17 10:57:10', '2024-10-17 10:57:10'),
	(5, 1, 15, 14, '2024-10-17 10:57:10', '2024-10-17 10:57:10'),
	(6, 1, 9, 15, '2024-10-17 10:57:31', '2024-10-17 10:57:31'),
	(7, 1, 10, 15, '2024-10-17 10:57:31', '2024-10-17 10:57:31'),
	(8, 1, 14, 15, '2024-10-17 10:57:31', '2024-10-17 10:57:31'),
	(9, 1, 15, 15, '2024-10-17 10:57:31', '2024-10-17 10:57:31'),
	(10, 1, 19, 15, '2024-10-17 10:57:31', '2024-10-17 10:57:31'),
	(11, 5, 10, 16, '2024-10-17 10:57:43', '2024-10-17 10:57:43'),
	(12, 1, 14, 16, '2024-10-17 10:57:43', '2024-10-17 10:57:43'),
	(13, 1, 15, 16, '2024-10-17 10:57:43', '2024-10-17 10:57:43'),
	(14, 1, 9, 17, '2024-10-18 03:16:49', '2024-10-18 03:16:49'),
	(15, 1, 10, 17, '2024-10-18 03:16:49', '2024-10-18 03:16:49'),
	(16, 1, 15, 17, '2024-10-18 03:16:49', '2024-10-18 03:16:49'),
	(17, 1, 9, 18, '2024-10-18 03:17:41', '2024-10-18 03:17:41'),
	(18, 1, 50, 18, '2024-10-18 03:17:41', '2024-10-18 03:17:41'),
	(19, 1, 9, 19, '2024-10-18 03:17:45', '2024-10-18 03:17:45'),
	(20, 1, 50, 19, '2024-10-18 03:17:45', '2024-10-18 03:17:45'),
	(21, 1, 9, 20, '2024-10-18 03:18:50', '2024-10-18 03:18:50'),
	(22, 1, 10, 20, '2024-10-18 03:18:50', '2024-10-18 03:18:50'),
	(23, 1, 9, 21, '2025-04-18 12:35:47', '2025-04-18 12:35:47'),
	(24, 1, 9, 22, '2025-04-18 12:53:06', '2025-04-18 12:53:06'),
	(25, 1, 9, 23, '2025-04-18 12:53:08', '2025-04-18 12:53:08'),
	(26, 1, 9, 24, '2025-04-18 12:59:04', '2025-04-18 12:59:04'),
	(27, 3, 9, 25, '2025-04-18 13:03:47', '2025-04-18 13:03:47'),
	(28, 1, 9, 26, '2025-04-18 13:08:10', '2025-04-18 13:08:10'),
	(29, 1, 14, 26, '2025-04-18 13:08:10', '2025-04-18 13:08:10'),
	(30, 1, 10, 27, '2025-04-18 13:08:43', '2025-04-18 13:08:43'),
	(31, 1, 14, 27, '2025-04-18 13:08:43', '2025-04-18 13:08:43'),
	(32, 1, 15, 27, '2025-04-18 13:08:43', '2025-04-18 13:08:43'),
	(33, 1, 20, 27, '2025-04-18 13:08:43', '2025-04-18 13:08:43'),
	(34, 1, 9, 28, '2025-04-18 13:22:19', '2025-04-18 13:22:19');

-- Volcando estructura para tabla ventavui.suppliers
CREATE TABLE IF NOT EXISTS `suppliers` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `name_provedor` varchar(250) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '',
  `ruc` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `tel` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `companies` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `address` 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=4 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

-- Volcando datos para la tabla ventavui.suppliers: ~2 rows (aproximadamente)
INSERT INTO `suppliers` (`id`, `name_provedor`, `ruc`, `tel`, `companies`, `address`, `created_at`, `updated_at`) VALUES
	(1, 'Huamani Gamarra, Jennyfer', '20563983176', '945773633', 'Dipas Sac', 'Av.Tamburcos', '2024-05-14 22:07:04', '2024-05-17 20:51:02'),
	(2, 'Michael Pimentel Palomino', '72031618', '1231231', 'sddf', 'Av.Tamburcoslll', '2024-05-17 20:51:29', '2024-05-17 20:57:40'),
	(3, 'varios', '0000000000', '000000000', 'venta', 'venta', '2025-04-18 12:52:37', '2025-04-18 12:52:37');

