
--
-- Table structure for table `providers`
--

CREATE TABLE `providers` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `code` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `description` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `created` date NOT NULL,
  `updated` date NOT NULL,
  `is_active` tinyint(1) NOT NULL DEFAULT '1',
  `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;

--
-- Dumping data for table `providers`
--

INSERT INTO `providers` VALUES (1,'PROV001','Proveedor A','Proveedor de bebidas','2024-08-21','2024-08-21',1,'2024-08-21 18:53:19','2024-08-21 18:53:19'),(2,'PROV002','Proveedor B','Proveedor de snacks','2024-08-21','2024-08-21',1,'2024-08-21 18:53:19','2024-08-21 18:53:19'),(3,'PROV003','Proveedor C','Proveedor de botellas','2024-08-21','2024-08-21',1,'2024-08-21 18:53:19','2024-08-21 18:53:19');

--
-- Table structure for table `proxies`
--

CREATE TABLE `proxies` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `proxies`
--


--
-- Table structure for table `sale_order_details`
--

CREATE TABLE `sale_order_details` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `sale_order_id` bigint unsigned NOT NULL,
  `line` int NOT NULL,
  `product_id` bigint unsigned NOT NULL,
  `qty` decimal(10,2) NOT NULL,
  `subtotal` decimal(10,2) NOT NULL,
  `total` decimal(10,2) NOT NULL,
  `iva` decimal(10,2) NOT NULL,
  `discount` decimal(10,2) NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `sale_order_details_sale_order_id_foreign` (`sale_order_id`),
  KEY `sale_order_details_product_id_foreign` (`product_id`),
  CONSTRAINT `sale_order_details_product_id_foreign` FOREIGN KEY (`product_id`) REFERENCES `products` (`id`) ON DELETE CASCADE,
  CONSTRAINT `sale_order_details_sale_order_id_foreign` FOREIGN KEY (`sale_order_id`) REFERENCES `sale_orders` (`id`) ON DELETE CASCADE
) ENGINE=InnoDB AUTO_INCREMENT=134 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `sale_order_details`
--

INSERT INTO `sale_order_details` VALUES (1,1,1,1,2.00,200.00,240.00,40.00,0.00,'2024-07-13 18:14:26','2024-07-13 18:14:26'),(2,1,2,2,1.00,300.00,360.00,60.00,0.00,'2024-07-13 18:14:26','2024-07-13 18:14:26'),(3,2,1,3,3.00,450.00,540.00,90.00,0.00,'2024-07-13 18:14:26','2024-07-13 18:14:26'),(4,3,1,4,1.00,180.00,216.00,36.00,0.00,'2024-07-13 18:14:26','2024-07-13 18:14:26'),(5,3,2,5,2.00,400.00,480.00,80.00,0.00,'2024-07-13 18:14:26','2024-07-13 18:14:26'),(6,9,2,2,26.00,1027.52,2716.80,1689.28,0.00,'2024-08-05 13:28:50','2024-08-05 13:28:50'),(7,10,2,2,26.00,1027.52,2716.80,1689.28,0.00,'2024-08-05 13:31:40','2024-08-05 13:31:40'),(8,11,2,2,26.00,1027.52,2716.80,1689.28,0.00,'2024-08-05 13:31:53','2024-08-05 13:31:53'),(9,12,2,2,26.00,1027.52,2716.80,1689.28,0.00,'2024-08-05 13:57:39','2024-08-05 13:57:39'),(10,13,2,2,26.00,1027.52,2716.80,1689.28,0.00,'2024-08-05 13:58:26','2024-08-05 13:58:26'),(11,14,2,2,26.00,1027.52,2716.80,1689.28,0.00,'2024-08-05 14:07:30','2024-08-05 14:07:30'),(12,15,2,2,26.00,1027.52,2716.80,1689.28,0.00,'2024-08-05 14:08:04','2024-08-05 14:08:04'),(13,16,2,2,1.00,39.52,42.02,2.50,0.00,'2024-08-05 14:17:25','2024-08-05 14:17:25'),(14,17,2,1,1.00,39.52,42.02,2.50,0.00,'2024-08-07 03:23:47','2024-08-07 03:23:47'),(15,18,2,1,1.00,39.52,42.02,2.50,0.00,'2024-08-07 03:24:15','2024-08-07 03:24:15'),(16,19,2,1,1.00,39.52,42.02,2.50,0.00,'2024-08-07 03:25:51','2024-08-07 03:25:51'),(17,20,2,1,1.00,39.52,42.02,2.50,0.00,'2024-08-07 03:27:05','2024-08-07 03:27:05'),(18,21,2,1,1.00,39.52,42.02,2.50,0.00,'2024-08-07 03:30:00','2024-08-07 03:30:00'),(19,22,2,1,2.00,79.04,89.04,10.00,0.00,'2024-08-07 03:31:14','2024-08-07 03:31:14'),(20,23,2,1,2.00,79.04,89.04,10.00,0.00,'2024-08-07 03:31:56','2024-08-07 03:31:56'),(21,24,2,1,101.00,3268.36,20359.84,17091.48,0.00,'2024-08-07 03:36:12','2024-08-07 03:36:12'),(22,25,2,1,101.00,3268.36,20359.84,17091.48,0.00,'2024-08-07 03:49:08','2024-08-07 03:49:08'),(23,26,2,1,101.00,3268.36,20359.84,17091.48,0.00,'2024-08-07 03:49:44','2024-08-07 03:49:44'),(24,27,2,1,101.00,3268.36,20359.84,17091.48,0.00,'2024-08-07 03:51:04','2024-08-07 03:51:04'),(25,28,2,1,101.00,3268.36,20359.84,17091.48,0.00,'2024-08-07 03:51:09','2024-08-07 03:51:09'),(26,29,2,1,101.00,3268.36,20359.84,17091.48,0.00,'2024-08-07 03:51:13','2024-08-07 03:51:13'),(27,30,2,1,101.00,3268.36,20359.84,17091.48,0.00,'2024-08-07 03:53:08','2024-08-07 03:53:08'),(28,31,2,1,1.00,39.52,42.02,2.50,0.00,'2024-08-07 04:40:14','2024-08-07 04:40:14'),(29,32,2,1,1.00,39.52,42.02,2.50,0.00,'2024-08-07 04:40:56','2024-08-07 04:40:56'),(30,33,2,1,1.00,39.52,42.02,2.50,0.00,'2024-08-07 04:42:48','2024-08-07 04:42:48'),(31,34,3,2,1.00,44.85,48.07,3.22,0.00,'2024-08-07 04:45:44','2024-08-07 04:45:44'),(32,35,3,2,1.00,44.85,48.07,3.22,0.00,'2024-08-07 04:46:43','2024-08-07 04:46:43'),(33,36,3,2,1.00,44.85,48.07,3.22,0.00,'2024-08-07 04:53:04','2024-08-07 04:53:04'),(34,37,3,2,1.00,44.85,48.07,3.22,0.00,'2024-08-07 04:55:38','2024-08-07 04:55:38'),(35,38,3,2,1.00,44.85,48.07,3.22,0.00,'2024-08-07 04:57:35','2024-08-07 04:57:35'),(36,39,3,2,1.00,44.85,48.07,3.22,0.00,'2024-08-07 05:08:15','2024-08-07 05:08:15'),(37,40,3,2,1.00,44.85,48.07,3.22,0.00,'2024-08-07 05:45:00','2024-08-07 05:45:00'),(38,41,3,2,1.00,44.85,48.07,3.22,0.00,'2024-08-07 05:47:55','2024-08-07 05:47:55'),(39,42,3,2,1.00,44.85,48.07,3.22,0.00,'2024-08-07 05:54:00','2024-08-07 05:54:00'),(40,43,2,1,10.00,395.20,645.09,249.89,0.00,'2024-08-07 23:00:25','2024-08-07 23:00:25'),(41,44,2,1,10.00,395.20,645.09,249.89,0.00,'2024-08-07 23:01:06','2024-08-07 23:01:06'),(42,45,2,1,10.00,395.20,645.09,249.89,0.00,'2024-08-07 23:08:54','2024-08-07 23:08:54'),(43,46,2,1,10.00,395.20,645.09,249.89,0.00,'2024-08-07 23:09:32','2024-08-07 23:09:32'),(44,47,2,1,10.00,395.20,645.09,249.89,0.00,'2024-08-07 23:14:08','2024-08-07 23:14:08'),(45,48,2,1,10.00,395.20,645.09,249.89,0.00,'2024-08-07 23:22:31','2024-08-07 23:22:31'),(46,49,2,1,10.00,395.20,645.09,249.89,0.00,'2024-08-07 23:23:00','2024-08-07 23:23:00'),(47,50,2,1,2.00,79.04,89.04,10.00,0.00,'2024-08-07 23:23:57','2024-08-07 23:23:57'),(48,51,2,1,2.00,79.04,89.04,10.00,0.00,'2024-08-07 23:24:15','2024-08-07 23:24:15'),(49,52,2,1,12.00,474.24,834.09,359.85,0.00,'2024-08-09 00:01:32','2024-08-09 00:01:32'),(50,53,2,1,12.00,474.24,834.09,359.85,0.00,'2024-08-09 00:02:35','2024-08-09 00:02:35'),(51,54,2,1,12.00,474.24,834.09,359.85,0.00,'2024-08-09 00:04:58','2024-08-09 00:04:58'),(52,55,2,1,12.00,474.24,834.09,359.85,0.00,'2024-08-09 00:05:44','2024-08-09 00:05:44'),(53,56,2,1,12.00,474.24,834.09,359.85,0.00,'2024-08-09 00:06:51','2024-08-09 00:06:51'),(54,57,2,1,12.00,474.24,834.09,359.85,0.00,'2024-08-09 00:08:03','2024-08-09 00:08:03'),(55,58,2,1,12.00,474.24,834.09,359.85,0.00,'2024-08-09 00:28:54','2024-08-09 00:28:54'),(56,59,2,1,12.00,474.24,834.09,359.85,0.00,'2024-08-09 00:29:25','2024-08-09 00:29:25'),(57,60,2,1,24.00,948.48,2387.86,1439.38,0.00,'2024-08-09 00:29:57','2024-08-09 00:29:57'),(58,61,2,1,12.00,474.24,834.09,359.85,0.00,'2024-08-09 00:42:09','2024-08-09 00:42:09'),(59,62,2,1,12.00,474.24,834.09,359.85,0.00,'2024-08-09 00:51:18','2024-08-09 00:51:18'),(60,63,2,1,12.00,474.24,834.09,359.85,0.00,'2024-08-09 00:51:50','2024-08-09 00:51:50'),(61,64,2,1,1.00,39.52,42.02,2.50,0.00,'2024-08-09 22:10:36','2024-08-09 22:10:36'),(62,65,2,1,1.00,39.52,42.02,2.50,0.00,'2024-08-09 22:11:37','2024-08-09 22:11:37'),(63,66,2,1,102.00,3300.72,20732.32,17431.60,0.00,'2024-08-09 22:54:22','2024-08-09 22:54:22'),(64,67,2,1,1.00,39.52,42.02,2.50,0.00,'2024-08-17 04:11:59','2024-08-17 04:11:59'),(65,68,2,1,1.00,39.52,42.02,2.50,0.00,'2024-08-17 04:30:18','2024-08-17 04:30:18'),(66,69,2,1,2.00,79.04,89.04,10.00,0.00,'2024-08-17 05:03:50','2024-08-17 05:03:50'),(67,70,2,1,2.00,79.04,89.04,10.00,0.00,'2024-08-17 05:05:23','2024-08-17 05:05:23'),(68,71,2,1,2.00,79.04,89.04,10.00,0.00,'2024-08-17 05:12:18','2024-08-17 05:12:18'),(69,72,2,1,14.00,553.28,1043.07,489.79,0.00,'2024-08-20 00:24:13','2024-08-20 00:24:13'),(70,73,2,1,14.00,553.28,1043.07,489.79,0.00,'2024-08-20 00:36:48','2024-08-20 00:36:48'),(71,74,2,1,14.00,553.28,1043.07,489.79,0.00,'2024-08-20 00:36:53','2024-08-20 00:36:53'),(72,75,2,1,14.00,553.28,1043.07,489.79,0.00,'2024-08-20 00:37:03','2024-08-20 00:37:03'),(73,76,2,1,14.00,553.28,1043.07,489.79,0.00,'2024-08-20 00:37:08','2024-08-20 00:37:08'),(74,77,2,1,1.00,39.52,42.02,2.50,0.00,'2024-08-20 00:41:19','2024-08-20 00:41:19'),(75,78,2,1,10.00,395.20,645.09,249.89,0.00,'2024-08-20 00:51:04','2024-08-20 00:51:04'),(76,79,2,1,10.00,395.20,645.09,249.89,0.00,'2024-08-20 01:02:20','2024-08-20 01:02:20'),(77,80,2,1,10.00,395.20,645.09,249.89,0.00,'2024-08-20 01:03:14','2024-08-20 01:03:14'),(78,81,2,1,10.00,395.20,645.09,249.89,0.00,'2024-08-20 01:03:50','2024-08-20 01:03:50'),(79,82,2,1,10.00,395.20,645.09,249.89,0.00,'2024-08-20 01:05:22','2024-08-20 01:05:22'),(80,83,2,1,10.00,395.20,645.09,249.89,0.00,'2024-08-20 01:06:44','2024-08-20 01:06:44'),(81,84,2,1,10.00,395.20,645.09,249.89,0.00,'2024-08-20 01:06:52','2024-08-20 01:06:52'),(82,85,2,1,1.00,39.52,42.02,2.50,0.00,'2024-08-20 01:10:29','2024-08-20 01:10:29'),(83,86,2,1,1.00,39.52,42.02,2.50,0.00,'2024-08-20 01:15:16','2024-08-20 01:15:16'),(84,87,2,1,1.00,39.52,42.02,2.50,0.00,'2024-08-20 01:36:28','2024-08-20 01:36:28'),(85,88,2,1,1.00,39.52,42.02,2.50,0.00,'2024-08-20 01:55:05','2024-08-20 01:55:05'),(86,89,2,1,1.00,39.52,42.02,2.50,0.00,'2024-08-20 01:55:19','2024-08-20 01:55:19'),(87,90,2,1,1.00,39.52,42.02,2.50,0.00,'2024-08-20 01:55:28','2024-08-20 01:55:28'),(88,91,2,1,1.00,39.52,42.02,2.50,0.00,'2024-08-20 01:59:33','2024-08-20 01:59:33'),(89,92,2,1,15.00,592.80,1155.06,562.26,0.00,'2024-08-20 21:16:10','2024-08-20 21:16:10'),(90,93,2,1,15.00,592.80,1155.06,562.26,0.00,'2024-08-20 21:16:20','2024-08-20 21:16:20'),(91,94,2,1,15.00,592.80,1155.06,562.26,0.00,'2024-08-20 21:16:34','2024-08-20 21:16:34'),(92,95,2,1,15.00,592.80,1155.06,562.26,0.00,'2024-08-20 21:24:08','2024-08-20 21:24:08'),(93,96,2,1,15.00,592.80,1155.06,562.26,0.00,'2024-08-20 21:29:28','2024-08-20 21:29:28'),(94,97,2,1,15.00,592.80,1155.06,562.26,0.00,'2024-08-20 21:30:54','2024-08-20 21:30:54'),(95,98,2,1,15.00,592.80,1155.06,562.26,0.00,'2024-08-20 21:32:38','2024-08-20 21:32:38'),(96,99,2,1,1.00,39.52,42.02,2.50,0.00,'2024-08-20 21:40:35','2024-08-20 21:40:35'),(97,100,2,1,1.00,39.52,42.02,2.50,0.00,'2024-08-20 21:40:59','2024-08-20 21:40:59'),(98,101,2,1,1.00,39.52,42.02,2.50,0.00,'2024-08-20 21:42:04','2024-08-20 21:42:04'),(99,102,2,1,14.00,553.28,1043.07,489.79,0.00,'2024-08-20 21:43:07','2024-08-20 21:43:07'),(100,103,2,1,14.00,553.28,1043.07,489.79,0.00,'2024-08-20 21:44:38','2024-08-20 21:44:38'),(101,104,2,1,14.00,553.28,1043.07,489.79,0.00,'2024-08-20 21:46:00','2024-08-20 21:46:00'),(102,105,2,1,14.00,553.28,1043.07,489.79,0.00,'2024-08-20 21:50:32','2024-08-20 21:50:32'),(103,106,2,1,14.00,553.28,1043.07,489.79,0.00,'2024-08-20 21:50:46','2024-08-20 21:50:46'),(104,107,2,1,14.00,553.28,1043.07,489.79,0.00,'2024-08-20 21:52:02','2024-08-20 21:52:02'),(105,108,2,1,14.00,553.28,1043.07,489.79,0.00,'2024-08-20 21:54:12','2024-08-20 21:54:12'),(106,109,2,1,14.00,553.28,1043.07,489.79,0.00,'2024-08-20 21:54:38','2024-08-20 21:54:38'),(107,110,2,1,14.00,553.28,1043.07,489.79,0.00,'2024-08-20 22:30:26','2024-08-20 22:30:26'),(108,111,2,1,14.00,553.28,1043.07,489.79,0.00,'2024-08-20 22:30:50','2024-08-20 22:30:50'),(109,112,2,1,14.00,553.28,1043.07,489.79,0.00,'2024-08-20 22:57:30','2024-08-20 22:57:30'),(110,113,2,1,14.00,553.28,1043.07,489.79,0.00,'2024-08-20 22:58:51','2024-08-20 22:58:51'),(111,114,2,1,14.00,553.28,1043.07,489.79,0.00,'2024-08-20 23:17:54','2024-08-20 23:17:54'),(112,115,2,1,14.00,553.28,1043.07,489.79,0.00,'2024-08-20 23:18:19','2024-08-20 23:18:19'),(113,116,2,1,14.00,553.28,1043.07,489.79,0.00,'2024-08-20 23:18:45','2024-08-20 23:18:45'),(114,117,2,1,14.00,553.28,1043.07,489.79,0.00,'2024-08-20 23:18:52','2024-08-20 23:18:52'),(115,118,2,1,14.00,553.28,1043.07,489.79,0.00,'2024-08-20 23:41:24','2024-08-20 23:41:24'),(116,119,2,1,14.00,553.28,1043.07,489.79,0.00,'2024-08-20 23:47:09','2024-08-20 23:47:09'),(117,120,2,1,14.00,553.28,1043.07,489.79,0.00,'2024-08-20 23:47:21','2024-08-20 23:47:21'),(118,121,2,1,14.00,553.28,1043.07,489.79,0.00,'2024-08-20 23:47:30','2024-08-20 23:47:30'),(119,122,2,1,14.00,553.28,1043.07,489.79,0.00,'2024-08-20 23:47:40','2024-08-20 23:47:40'),(120,123,2,1,14.00,553.28,1043.07,489.79,0.00,'2024-08-20 23:47:45','2024-08-20 23:47:45'),(121,124,2,1,14.00,553.28,1043.07,489.79,0.00,'2024-08-20 23:47:47','2024-08-20 23:47:47'),(122,125,2,25,14.00,553.28,1043.07,489.79,0.00,'2024-08-20 23:47:57','2024-08-20 23:47:57'),(123,126,2,25,14.00,553.28,1043.07,489.79,0.00,'2024-08-20 23:49:59','2024-08-20 23:49:59'),(124,127,2,25,14.00,553.28,1043.07,489.79,0.00,'2024-08-20 23:53:05','2024-08-20 23:53:05'),(125,128,2,25,14.00,553.28,1043.07,489.79,0.00,'2024-08-20 23:53:11','2024-08-20 23:53:11'),(126,129,2,15,14.00,553.28,1043.07,489.79,0.00,'2024-08-20 23:53:52','2024-08-20 23:53:52'),(127,130,2,15,14.00,553.28,1043.07,489.79,0.00,'2024-08-21 00:07:00','2024-08-21 00:07:00'),(128,131,2,15,14.00,553.28,1043.07,489.79,0.00,'2024-08-21 00:07:32','2024-08-21 00:07:32'),(129,132,2,15,14.00,553.28,1043.07,489.79,0.00,'2024-08-21 00:11:20','2024-08-21 00:11:20'),(130,133,2,15,14.00,553.28,1043.07,489.79,0.00,'2024-08-21 00:15:18','2024-08-21 00:15:18'),(131,134,2,15,14.00,553.28,1043.07,489.79,0.00,'2024-08-21 00:43:43','2024-08-21 00:43:43'),(132,135,26,25,1.00,13.05,13.32,0.27,0.00,'2024-11-06 04:55:42','2024-11-06 04:55:42'),(133,136,26,25,1.00,13.05,13.32,0.27,0.00,'2024-11-06 04:55:55','2024-11-06 04:55:55');

--
-- Table structure for table `sale_orders`
--

CREATE TABLE `sale_orders` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `prefix` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `folio` int NOT NULL,
  `client_id` bigint unsigned NOT NULL,
  `status` enum('POSTED','CLOSED','CANCELED','PENDING','ACTIVE') CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `sale_person_id` bigint unsigned NOT NULL,
  `subtotal` decimal(10,2) NOT NULL,
  `total` decimal(10,2) NOT NULL,
  `iva` decimal(10,2) NOT NULL,
  `discount` decimal(10,2) NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `sale_orders_client_id_foreign` (`client_id`),
  KEY `sale_orders_sale_person_id_foreign` (`sale_person_id`),
  CONSTRAINT `sale_orders_client_id_foreign` FOREIGN KEY (`client_id`) REFERENCES `clients` (`id`) ON DELETE CASCADE,
  CONSTRAINT `sale_orders_sale_person_id_foreign` FOREIGN KEY (`sale_person_id`) REFERENCES `sales_persons` (`id`) ON DELETE CASCADE
) ENGINE=InnoDB AUTO_INCREMENT=137 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `sale_orders`
--

INSERT INTO `sale_orders` VALUES (1,'SO',1001,1,'POSTED',1,500.00,600.00,100.00,0.00,'2024-07-13 18:11:55','2024-07-13 18:11:55'),(2,'SO',1002,2,'CLOSED',2,800.00,920.00,120.00,0.00,'2024-07-13 18:11:55','2024-07-13 18:11:55'),(3,'SO',1003,3,'CANCELED',3,1200.00,1400.00,200.00,0.00,'2024-07-13 18:11:55','2024-07-13 18:11:55'),(4,'SO',1004,4,'PENDING',4,1500.00,1750.00,250.00,0.00,'2024-07-13 18:11:55','2024-07-13 18:11:55'),(5,'SO',1005,1,'POSTED',1,1027.52,1191.92,164.40,0.00,'2024-08-05 13:07:46','2024-08-05 13:07:46'),(6,'SO',1006,1,'POSTED',1,1027.52,1191.92,164.40,0.00,'2024-08-05 13:14:59','2024-08-05 13:14:59'),(7,'SO',1007,1,'POSTED',1,1027.52,1191.92,164.40,0.00,'2024-08-05 13:16:18','2024-08-05 13:16:18'),(8,'SO',1008,1,'POSTED',1,1027.52,1191.92,164.40,0.00,'2024-08-05 13:19:06','2024-08-05 13:19:06'),(9,'SO',1009,1,'POSTED',1,1027.52,1191.92,164.40,0.00,'2024-08-05 13:28:50','2024-08-05 13:28:50'),(10,'SO',1010,1,'POSTED',1,1027.52,1191.92,164.40,0.00,'2024-08-05 13:31:40','2024-08-05 13:31:40'),(11,'SO',1011,1,'POSTED',1,1027.52,1191.92,164.40,0.00,'2024-08-05 13:31:53','2024-08-05 13:31:53'),(12,'SO',1012,1,'POSTED',1,1027.52,1191.92,164.40,0.00,'2024-08-05 13:57:39','2024-08-05 13:57:39'),(13,'SO',1013,1,'POSTED',1,1027.52,1191.92,164.40,0.00,'2024-08-05 13:58:26','2024-08-05 13:58:26'),(14,'SO',1014,1,'POSTED',1,1027.52,1191.92,164.40,0.00,'2024-08-05 14:07:30','2024-08-05 14:07:30'),(15,'SO',1015,1,'POSTED',1,1027.52,1191.92,164.40,0.00,'2024-08-05 14:08:04','2024-08-05 14:08:04'),(16,'SO',1016,1,'POSTED',1,39.52,45.84,6.32,0.00,'2024-08-05 14:17:25','2024-08-05 14:17:25'),(17,'SO',1017,1,'POSTED',1,39.52,45.84,6.32,0.00,'2024-08-07 03:23:47','2024-08-07 03:23:47'),(18,'SO',1018,1,'POSTED',1,39.52,45.84,6.32,0.00,'2024-08-07 03:24:15','2024-08-07 03:24:15'),(19,'SO',1019,1,'POSTED',1,39.52,45.84,6.32,0.00,'2024-08-07 03:25:51','2024-08-07 03:25:51'),(20,'SO',1020,1,'POSTED',1,39.52,45.84,6.32,0.00,'2024-08-07 03:27:05','2024-08-07 03:27:05'),(21,'SO',1021,1,'POSTED',1,39.52,45.84,6.32,0.00,'2024-08-07 03:30:00','2024-08-07 03:30:00'),(22,'SO',1022,1,'POSTED',1,79.04,91.69,12.65,0.00,'2024-08-07 03:31:14','2024-08-07 03:31:14'),(23,'SO',1023,1,'POSTED',1,79.04,91.69,12.65,0.00,'2024-08-07 03:31:56','2024-08-07 03:31:56'),(24,'SO',1024,1,'POSTED',1,3268.36,3791.30,522.94,0.00,'2024-08-07 03:36:12','2024-08-07 03:36:12'),(25,'SO',1025,1,'POSTED',1,3268.36,3791.30,522.94,0.00,'2024-08-07 03:49:08','2024-08-07 03:49:08'),(26,'SO',1026,1,'POSTED',1,3268.36,3791.30,522.94,0.00,'2024-08-07 03:49:44','2024-08-07 03:49:44'),(27,'SO',1027,1,'POSTED',1,3268.36,3791.30,522.94,0.00,'2024-08-07 03:51:04','2024-08-07 03:51:04'),(28,'SO',1028,1,'POSTED',1,3268.36,3791.30,522.94,0.00,'2024-08-07 03:51:09','2024-08-07 03:51:09'),(29,'SO',1029,1,'POSTED',1,3268.36,3791.30,522.94,0.00,'2024-08-07 03:51:13','2024-08-07 03:51:13'),(30,'SO',1030,1,'POSTED',1,3268.36,3791.30,522.94,0.00,'2024-08-07 03:53:08','2024-08-07 03:53:08'),(31,'SO',1031,1,'POSTED',1,39.52,45.84,6.32,0.00,'2024-08-07 04:40:14','2024-08-07 04:40:14'),(32,'SO',1032,1,'POSTED',1,39.52,45.84,6.32,0.00,'2024-08-07 04:40:56','2024-08-07 04:40:56'),(33,'SO',1033,1,'POSTED',1,39.52,45.84,6.32,0.00,'2024-08-07 04:42:48','2024-08-07 04:42:48'),(34,'SO',1034,1,'POSTED',1,44.85,52.03,7.18,0.00,'2024-08-07 04:45:44','2024-08-07 04:45:44'),(35,'SO',1035,1,'POSTED',1,44.85,52.03,7.18,0.00,'2024-08-07 04:46:43','2024-08-07 04:46:43'),(36,'SO',1036,1,'POSTED',1,44.85,52.03,7.18,0.00,'2024-08-07 04:53:04','2024-08-07 04:53:04'),(37,'SO',1037,1,'POSTED',1,44.85,52.03,7.18,0.00,'2024-08-07 04:55:38','2024-08-07 04:55:38'),(38,'SO',1038,1,'POSTED',1,44.85,52.03,7.18,0.00,'2024-08-07 04:57:35','2024-08-07 04:57:35'),(39,'SO',1039,1,'POSTED',1,44.85,52.03,7.18,0.00,'2024-08-07 05:08:15','2024-08-07 05:08:15'),(40,'SO',1040,1,'POSTED',1,44.85,52.03,7.18,0.00,'2024-08-07 05:45:00','2024-08-07 05:45:00'),(41,'SO',1041,1,'POSTED',1,44.85,52.03,7.18,0.00,'2024-08-07 05:47:55','2024-08-07 05:47:55'),(42,'SO',1042,1,'POSTED',1,44.85,52.03,7.18,0.00,'2024-08-07 05:54:00','2024-08-07 05:54:00'),(43,'SO',1043,1,'POSTED',1,395.20,458.43,63.23,0.00,'2024-08-07 23:00:25','2024-08-07 23:00:25'),(44,'SO',1044,1,'POSTED',1,395.20,458.43,63.23,0.00,'2024-08-07 23:01:06','2024-08-07 23:01:06'),(45,'SO',1045,1,'POSTED',1,395.20,458.43,63.23,0.00,'2024-08-07 23:08:54','2024-08-07 23:08:54'),(46,'SO',1046,1,'POSTED',1,395.20,458.43,63.23,0.00,'2024-08-07 23:09:32','2024-08-07 23:09:32'),(47,'SO',1047,1,'POSTED',1,395.20,458.43,63.23,0.00,'2024-08-07 23:14:08','2024-08-07 23:14:08'),(48,'SO',1048,1,'POSTED',1,395.20,458.43,63.23,0.00,'2024-08-07 23:22:31','2024-08-07 23:22:31'),(49,'SO',1049,1,'POSTED',1,395.20,458.43,63.23,0.00,'2024-08-07 23:23:00','2024-08-07 23:23:00'),(50,'SO',1050,1,'POSTED',1,79.04,91.69,12.65,0.00,'2024-08-07 23:23:57','2024-08-07 23:23:57'),(51,'SO',1051,1,'POSTED',1,79.04,91.69,12.65,0.00,'2024-08-07 23:24:15','2024-08-07 23:24:15'),(52,'SO',1052,1,'POSTED',1,474.24,550.12,75.88,0.00,'2024-08-09 00:01:32','2024-08-09 00:01:32'),(53,'SO',1053,1,'POSTED',1,474.24,550.12,75.88,0.00,'2024-08-09 00:02:35','2024-08-09 00:02:35'),(54,'SO',1054,1,'POSTED',1,474.24,550.12,75.88,0.00,'2024-08-09 00:04:58','2024-08-09 00:04:58'),(55,'SO',1055,1,'POSTED',1,474.24,550.12,75.88,0.00,'2024-08-09 00:05:44','2024-08-09 00:05:44'),(56,'SO',1056,1,'POSTED',1,474.24,550.12,75.88,0.00,'2024-08-09 00:06:51','2024-08-09 00:06:51'),(57,'SO',1057,1,'POSTED',1,474.24,550.12,75.88,0.00,'2024-08-09 00:08:03','2024-08-09 00:08:03'),(58,'SO',1058,1,'POSTED',1,474.24,550.12,75.88,0.00,'2024-08-09 00:28:54','2024-08-09 00:28:54'),(59,'SO',1059,1,'POSTED',1,474.24,550.12,75.88,0.00,'2024-08-09 00:29:25','2024-08-09 00:29:25'),(60,'SO',1060,1,'POSTED',1,948.48,1100.24,151.76,0.00,'2024-08-09 00:29:57','2024-08-09 00:29:57'),(61,'SO',1061,1,'POSTED',1,474.24,550.12,75.88,0.00,'2024-08-09 00:42:09','2024-08-09 00:42:09'),(62,'SO',1062,1,'POSTED',1,474.24,550.12,75.88,0.00,'2024-08-09 00:51:18','2024-08-09 00:51:18'),(63,'SO',1063,1,'POSTED',1,474.24,550.12,75.88,0.00,'2024-08-09 00:51:50','2024-08-09 00:51:50'),(64,'SO',1064,1,'POSTED',1,39.52,45.84,6.32,0.00,'2024-08-09 22:10:36','2024-08-09 22:10:36'),(65,'SO',1065,1,'POSTED',1,39.52,45.84,6.32,0.00,'2024-08-09 22:11:37','2024-08-09 22:11:37'),(66,'SO',1066,1,'POSTED',1,3300.72,3828.84,528.12,0.00,'2024-08-09 22:54:22','2024-08-09 22:54:22'),(67,'SO',1067,1,'POSTED',1,39.52,45.84,6.32,0.00,'2024-08-17 04:11:59','2024-08-17 04:11:59'),(68,'SO',1068,1,'POSTED',1,39.52,45.84,6.32,0.00,'2024-08-17 04:30:18','2024-08-17 04:30:18'),(69,'SO',1069,1,'POSTED',1,79.04,91.69,12.65,0.00,'2024-08-17 05:03:50','2024-08-17 05:03:50'),(70,'SO',1070,1,'POSTED',1,79.04,91.69,12.65,0.00,'2024-08-17 05:05:23','2024-08-17 05:05:23'),(71,'SO',1071,1,'POSTED',1,79.04,91.69,12.65,0.00,'2024-08-17 05:12:18','2024-08-17 05:12:18'),(72,'SO',1072,1,'POSTED',1,553.28,641.80,88.52,0.00,'2024-08-20 00:24:13','2024-08-20 00:24:13'),(73,'SO',1073,1,'POSTED',1,553.28,641.80,88.52,0.00,'2024-08-20 00:36:48','2024-08-20 00:36:48'),(74,'SO',1074,1,'POSTED',1,553.28,641.80,88.52,0.00,'2024-08-20 00:36:53','2024-08-20 00:36:53'),(75,'SO',1075,1,'POSTED',1,553.28,641.80,88.52,0.00,'2024-08-20 00:37:03','2024-08-20 00:37:03'),(76,'SO',1076,1,'POSTED',1,553.28,641.80,88.52,0.00,'2024-08-20 00:37:08','2024-08-20 00:37:08'),(77,'SO',1077,1,'POSTED',1,39.52,45.84,6.32,0.00,'2024-08-20 00:41:19','2024-08-20 00:41:19'),(78,'SO',1078,1,'POSTED',1,395.20,458.43,63.23,0.00,'2024-08-20 00:51:04','2024-08-20 00:51:04'),(79,'SO',1079,1,'POSTED',1,395.20,458.43,63.23,0.00,'2024-08-20 01:02:20','2024-08-20 01:02:20'),(80,'SO',1080,1,'POSTED',1,395.20,458.43,63.23,0.00,'2024-08-20 01:03:14','2024-08-20 01:03:14'),(81,'SO',1081,1,'POSTED',1,395.20,458.43,63.23,0.00,'2024-08-20 01:03:50','2024-08-20 01:03:50'),(82,'SO',1082,1,'POSTED',1,395.20,458.43,63.23,0.00,'2024-08-20 01:05:22','2024-08-20 01:05:22'),(83,'SO',1083,1,'POSTED',1,395.20,458.43,63.23,0.00,'2024-08-20 01:06:44','2024-08-20 01:06:44'),(84,'SO',1084,1,'POSTED',1,395.20,458.43,63.23,0.00,'2024-08-20 01:06:52','2024-08-20 01:06:52'),(85,'SO',1085,1,'POSTED',1,39.52,45.84,6.32,0.00,'2024-08-20 01:10:29','2024-08-20 01:10:29'),(86,'SO',1086,1,'POSTED',1,39.52,45.84,6.32,0.00,'2024-08-20 01:15:16','2024-08-20 01:15:16'),(87,'SO',1087,1,'POSTED',1,39.52,45.84,6.32,0.00,'2024-08-20 01:36:28','2024-08-20 01:36:28'),(88,'SO',1088,1,'POSTED',1,39.52,45.84,6.32,0.00,'2024-08-20 01:55:05','2024-08-20 01:55:05'),(89,'SO',1089,1,'POSTED',1,39.52,45.84,6.32,0.00,'2024-08-20 01:55:19','2024-08-20 01:55:19'),(90,'SO',1090,1,'POSTED',1,39.52,45.84,6.32,0.00,'2024-08-20 01:55:28','2024-08-20 01:55:28'),(91,'SO',1091,1,'POSTED',1,39.52,45.84,6.32,0.00,'2024-08-20 01:59:33','2024-08-20 01:59:33'),(92,'SO',1092,1,'POSTED',1,592.80,687.65,94.85,0.00,'2024-08-20 21:16:10','2024-08-20 21:16:10'),(93,'SO',1093,1,'POSTED',1,592.80,687.65,94.85,0.00,'2024-08-20 21:16:20','2024-08-20 21:16:20'),(94,'SO',1094,1,'POSTED',1,592.80,687.65,94.85,0.00,'2024-08-20 21:16:34','2024-08-20 21:16:34'),(95,'SO',1095,1,'POSTED',1,592.80,687.65,94.85,0.00,'2024-08-20 21:24:08','2024-08-20 21:24:08'),(96,'SO',1096,1,'POSTED',1,592.80,687.65,94.85,0.00,'2024-08-20 21:29:28','2024-08-20 21:29:28'),(97,'SO',1097,1,'POSTED',1,592.80,687.65,94.85,0.00,'2024-08-20 21:30:54','2024-08-20 21:30:54'),(98,'SO',1098,1,'POSTED',1,592.80,687.65,94.85,0.00,'2024-08-20 21:32:37','2024-08-20 21:32:37'),(99,'SO',1099,1,'POSTED',1,39.52,45.84,6.32,0.00,'2024-08-20 21:40:35','2024-08-20 21:40:35'),(100,'SO',1100,1,'POSTED',1,39.52,45.84,6.32,0.00,'2024-08-20 21:40:59','2024-08-20 21:40:59'),(101,'SO',1101,1,'POSTED',1,39.52,45.84,6.32,0.00,'2024-08-20 21:42:04','2024-08-20 21:42:04'),(102,'SO',1102,1,'POSTED',1,553.28,641.80,88.52,0.00,'2024-08-20 21:43:07','2024-08-20 21:43:07'),(103,'SO',1103,1,'POSTED',1,553.28,641.80,88.52,0.00,'2024-08-20 21:44:38','2024-08-20 21:44:38'),(104,'SO',1104,1,'POSTED',1,553.28,641.80,88.52,0.00,'2024-08-20 21:46:00','2024-08-20 21:46:00'),(105,'SO',1105,1,'POSTED',1,553.28,641.80,88.52,0.00,'2024-08-20 21:50:32','2024-08-20 21:50:32'),(106,'SO',1106,1,'POSTED',1,553.28,641.80,88.52,0.00,'2024-08-20 21:50:46','2024-08-20 21:50:46'),(107,'SO',1107,1,'POSTED',1,553.28,641.80,88.52,0.00,'2024-08-20 21:52:02','2024-08-20 21:52:02'),(108,'SO',1108,1,'POSTED',1,553.28,641.80,88.52,0.00,'2024-08-20 21:54:12','2024-08-20 21:54:12'),(109,'SO',1109,1,'POSTED',1,553.28,641.80,88.52,0.00,'2024-08-20 21:54:38','2024-08-20 21:54:38'),(110,'SO',1110,1,'POSTED',1,553.28,641.80,88.52,0.00,'2024-08-20 22:30:26','2024-08-20 22:30:26'),(111,'SO',1111,1,'POSTED',1,553.28,641.80,88.52,0.00,'2024-08-20 22:30:50','2024-08-20 22:30:50'),(112,'SO',1112,1,'POSTED',1,553.28,641.80,88.52,0.00,'2024-08-20 22:57:30','2024-08-20 22:57:30'),(113,'SO',1113,1,'POSTED',1,553.28,641.80,88.52,0.00,'2024-08-20 22:58:51','2024-08-20 22:58:51'),(114,'SO',1114,1,'POSTED',1,553.28,641.80,88.52,0.00,'2024-08-20 23:17:54','2024-08-20 23:17:54'),(115,'SO',1115,1,'POSTED',1,553.28,641.80,88.52,0.00,'2024-08-20 23:18:19','2024-08-20 23:18:19'),(116,'SO',1116,1,'POSTED',1,553.28,641.80,88.52,0.00,'2024-08-20 23:18:45','2024-08-20 23:18:45'),(117,'SO',1117,1,'POSTED',1,553.28,641.80,88.52,0.00,'2024-08-20 23:18:52','2024-08-20 23:18:52'),(118,'SO',1118,1,'POSTED',1,553.28,641.80,88.52,0.00,'2024-08-20 23:41:24','2024-08-20 23:41:24'),(119,'SO',1119,1,'POSTED',1,553.28,641.80,88.52,0.00,'2024-08-20 23:47:09','2024-08-20 23:47:09'),(120,'SO',1120,1,'POSTED',1,553.28,641.80,88.52,0.00,'2024-08-20 23:47:21','2024-08-20 23:47:21'),(121,'SO',1121,1,'POSTED',1,553.28,641.80,88.52,0.00,'2024-08-20 23:47:30','2024-08-20 23:47:30'),(122,'SO',1122,1,'POSTED',1,553.28,641.80,88.52,0.00,'2024-08-20 23:47:40','2024-08-20 23:47:40'),(123,'SO',1123,1,'POSTED',1,553.28,641.80,88.52,0.00,'2024-08-20 23:47:45','2024-08-20 23:47:45'),(124,'SO',1124,1,'POSTED',1,553.28,641.80,88.52,0.00,'2024-08-20 23:47:47','2024-08-20 23:47:47'),(125,'SO',1125,1,'POSTED',1,553.28,641.80,88.52,0.00,'2024-08-20 23:47:57','2024-08-20 23:47:57'),(126,'SO',1126,1,'POSTED',1,553.28,641.80,88.52,0.00,'2024-08-20 23:49:59','2024-08-20 23:49:59'),(127,'SO',1127,1,'POSTED',1,553.28,641.80,88.52,0.00,'2024-08-20 23:53:05','2024-08-20 23:53:05'),(128,'SO',1128,1,'POSTED',1,553.28,641.80,88.52,0.00,'2024-08-20 23:53:11','2024-08-20 23:53:11'),(129,'SO',1129,1,'POSTED',1,553.28,641.80,88.52,0.00,'2024-08-20 23:53:52','2024-08-20 23:53:52'),(130,'SO',1130,1,'POSTED',1,553.28,641.80,88.52,0.00,'2024-08-21 00:07:00','2024-08-21 00:07:00'),(131,'SO',1131,1,'POSTED',1,553.28,641.80,88.52,0.00,'2024-08-21 00:07:32','2024-08-21 00:07:32'),(132,'SO',1132,1,'POSTED',1,553.28,641.80,88.52,0.00,'2024-08-21 00:11:20','2024-08-21 00:11:20'),(133,'SO',1133,1,'POSTED',1,553.28,641.80,88.52,0.00,'2024-08-21 00:15:18','2024-08-21 00:15:18'),(134,'SO',1134,1,'POSTED',1,553.28,641.80,88.52,0.00,'2024-08-21 00:43:43','2024-08-21 00:43:43'),(135,'SO',1135,1,'POSTED',1,13.05,15.14,2.09,0.00,'2024-11-06 04:55:42','2024-11-06 04:55:42'),(136,'SO',1136,1,'POSTED',1,13.05,15.14,2.09,0.00,'2024-11-06 04:55:55','2024-11-06 04:55:55');

--
-- Table structure for table `sales_persons`
--

CREATE TABLE `sales_persons` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `description` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT 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;

--
-- Dumping data for table `sales_persons`
--

INSERT INTO `sales_persons` VALUES (1,'Kevin Pena','',NULL,NULL),(2,'Jane Smith','',NULL,NULL),(3,'Michael Johnson','',NULL,NULL),(4,'Emily Davis','',NULL,NULL);

--
-- Table structure for table `seasons`
--

CREATE TABLE `seasons` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `description` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `is_active` tinyint(1) NOT NULL DEFAULT '1',
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=6 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `seasons`
--

INSERT INTO `seasons` VALUES (1,'Ninguna','NONE',1,'2024-07-11 21:55:16','2024-07-11 21:55:16'),(2,'Verano','VERA',1,'2024-07-11 21:55:16','2024-07-11 21:55:16'),(3,'Invierno','INVI',1,'2024-07-11 21:55:16','2024-07-11 21:55:16'),(4,'Otoño','OTOÑ',1,'2024-07-11 21:55:16','2024-07-11 21:55:16'),(5,'Primavera','PRIM',1,'2024-07-11 21:55:16','2024-07-11 21:55:16');

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

CREATE TABLE `sessions` (
  `id` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `user_id` bigint unsigned DEFAULT NULL,
  `ip_address` varchar(45) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `user_agent` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
  `payload` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `last_activity` int NOT NULL,
  PRIMARY KEY (`id`),
  KEY `sessions_user_id_index` (`user_id`),
  KEY `sessions_last_activity_index` (`last_activity`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

INSERT INTO `sessions` VALUES ('1PUJYsxxKscXcXYjjvvgzrwgUgmqJfgzZqDXQNlQ',NULL,'192.168.1.31','Mozilla/5.0','YTozOntzOjY6Il90b2tlbiI7czo0MDoiYUF2dHF4S09mNTlJUTFGWkJ0UHdYa3d5YlM1VkU0eUU0N2ZpdDRYcCI7czo5OiJfcHJldmlvdXMiO2E6MTp7czozOiJ1cmwiO3M6MjI6Imh0dHA6Ly9kZXNrdG9wLTN0OTQyaDkiO31zOjY6Il9mbGFzaCI7YToyOntzOjM6Im9sZCI7YTowOnt9czozOiJuZXciO2E6MDp7fX19',1733240980),('5LixEb80WdzyX3Xb8yBnqfheseb4Bj3QeWbvW0SK',NULL,'::1','Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/131.0.0.0 Safari/537.36','YTozOntzOjY6Il90b2tlbiI7czo0MDoiZFVLV055MEJ2OHpSZ0VJVG5ReXM5N2xvc1RLaEs1aTJlS3dXd3VJZSI7czo5OiJfcHJldmlvdXMiO2E6MTp7czozOiJ1cmwiO3M6MzM6Imh0dHA6Ly9sb2NhbGhvc3Qvc2l6ZXMvYnJhbmRpbmctMyI7fXM6NjoiX2ZsYXNoIjthOjI6e3M6Mzoib2xkIjthOjA6e31zOjM6Im5ldyI7YTowOnt9fX0=',1732912584),('6goRTZ4nzKw42LxErEt61esvwVlPqnNHwPw2F479',NULL,'::1','Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/131.0.0.0 Safari/537.36','YToyOntzOjY6Il90b2tlbiI7czo0MDoicWp2ZldTYjRJVTh0NGdmQllocEg3ZWRrT0JmcFk2RExBYVF4a0dyYiI7czo2OiJfZmxhc2giO2E6Mjp7czozOiJvbGQiO2E6MDp7fXM6MzoibmV3IjthOjA6e319fQ==',1733853824),('70Bx0XS04vAe2sC5k7Sd5CNV62YvnwLIC428cDgX',1,'::1','Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/131.0.0.0 Safari/537.36','YTo0OntzOjY6Il90b2tlbiI7czo0MDoib3U4aDRvbU1LQ1lFSWNHTUx6U1lRVmI2N2lCdU53bUREMVh6a1hScyI7czo5OiJfcHJldmlvdXMiO2E6MTp7czozOiJ1cmwiO3M6NDA6Imh0dHA6Ly9sb2NhbGhvc3QvcHJvZHVjdHMvMTAzNT9jb21wYW55PTEiO31zOjY6Il9mbGFzaCI7YToyOntzOjM6Im9sZCI7YTowOnt9czozOiJuZXciO2E6MDp7fX1zOjUwOiJsb2dpbl93ZWJfNTliYTM2YWRkYzJiMmY5NDAxNTgwZjAxNGM3ZjU4ZWE0ZTMwOTg5ZCI7aToxO30=',1732924566),('ayuyqvLKl8Lms2WvYvIzwp0pFo4qz5AFgG9CcKOX',NULL,'::1','Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/131.0.0.0 Safari/537.36','YTozOntzOjY6Il90b2tlbiI7czo0MDoicFFwazdoNDV6bDRqWjl5Y2g3QzRNSXliTWlFMUR2ZVRIWThJSEVSeSI7czo2OiJfZmxhc2giO2E6Mjp7czozOiJuZXciO2E6MDp7fXM6Mzoib2xkIjthOjA6e319czo5OiJfcHJldmlvdXMiO2E6MTp7czozOiJ1cmwiO3M6MjI6Imh0dHA6Ly9sb2NhbGhvc3QvbG9naW4iO319',1732935733),('BBQQzHnZQcRGCpWJ09eprJDhWp6HS1q3iA0ab95K',NULL,'::1','Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/131.0.0.0 Safari/537.36','YTozOntzOjY6Il90b2tlbiI7czo0MDoiSkxjTXJjSUR2ZEk3bVR3Mk9zZVFEWEMweWc2NGZoN3E3Q3pDR01TNiI7czo5OiJfcHJldmlvdXMiO2E6MTp7czozOiJ1cmwiO3M6MjI6Imh0dHA6Ly9sb2NhbGhvc3QvbG9naW4iO31zOjY6Il9mbGFzaCI7YToyOntzOjM6Im9sZCI7YTowOnt9czozOiJuZXciO2E6MDp7fX19',1733198036),('CNNRBQxgyN5xVx5inEB1ZF5UpUBOihJqMa0BqlsM',NULL,'::1','Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/131.0.0.0 Safari/537.36','YToyOntzOjY6Il90b2tlbiI7czo0MDoiWDdmcFp6M2Z4R21vUExQblFGZG93RnpudWNmQ1NxQlFHeUszeVYyeSI7czo2OiJfZmxhc2giO2E6Mjp7czozOiJvbGQiO2E6MDp7fXM6MzoibmV3IjthOjA6e319fQ==',1733238428),('hNVhMKTE2qY5GpXjOGUcOiwkMwQs7Fu0IHdcCg6s',NULL,'::1','Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/131.0.0.0 Safari/537.36','YTo0OntzOjY6Il90b2tlbiI7czo0MDoiNVRJVDF0d2huTDlRN1FteDR2UGpTaWJ0SHVNVnFDOXZUVk8wZ000dyI7czo1OiJlcnJvciI7czo1OToiVHUgc2VzacOzbiBoYSBleHBpcmFkby4gUG9yIGZhdm9yLCBpbmljaWEgc2VzacOzbiBkZSBudWV2by4iO3M6NjoiX2ZsYXNoIjthOjI6e3M6MzoibmV3IjthOjA6e31zOjM6Im9sZCI7YToxOntpOjA7czo1OiJlcnJvciI7fX1zOjk6Il9wcmV2aW91cyI7YToxOntzOjM6InVybCI7czozODoiaHR0cDovL2xvY2FsaG9zdC9wcm9kdWN0cy8xNT9jb21wYW55PTEiO319',1732912583),('nTwgu2hGvWd65aSQTQ4eVPeGrn9hrHFJxnoHL3DW',NULL,'::1','Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/131.0.0.0 Safari/537.36','YTozOntzOjY6Il90b2tlbiI7czo0MDoiY3VPaTZSbkVnNHRyZVZrMnd3d2dyOHNoYkpqTjdqS1dZV1Zib1JRdSI7czo2OiJfZmxhc2giO2E6Mjp7czozOiJuZXciO2E6MDp7fXM6Mzoib2xkIjthOjA6e319czo5OiJfcHJldmlvdXMiO2E6MTp7czozOiJ1cmwiO3M6MjI6Imh0dHA6Ly9sb2NhbGhvc3QvbG9naW4iO319',1733189674),('sXc4APIVLEhOnHJVSFpma11kiJuatXhboJqjC9Mj',NULL,'::1','Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/131.0.0.0 Safari/537.36','YTozOntzOjY6Il90b2tlbiI7czo0MDoibEtWcExzT3drVkd6MGt0Y1JnQzBIQ3JvUjdHbmsxbU5EdkFWSjN6cCI7czo5OiJfcHJldmlvdXMiO2E6MTp7czozOiJ1cmwiO3M6MjI6Imh0dHA6Ly9sb2NhbGhvc3QvbG9naW4iO31zOjY6Il9mbGFzaCI7YToyOntzOjM6Im9sZCI7YTowOnt9czozOiJuZXciO2E6MDp7fX19',1732982536),('ur611VvFsichfZjofAdeQKKqNrMXv92v22sKwOmW',1,'::1','Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/132.0.0.0 Safari/537.36','YTo0OntzOjY6Il90b2tlbiI7czo0MDoiN1FuWGZ1bEFiSnRnTThCQjlHZWFIMG1FZlNrWDJNRmY1WkFwM3MyaSI7czo5OiJfcHJldmlvdXMiO2E6MTp7czozOiJ1cmwiO3M6Mzc6Imh0dHA6Ly9sb2NhbGhvc3QvcHJvZHVjdHMvMT9jb21wYW55PTEiO31zOjY6Il9mbGFzaCI7YToyOntzOjM6Im9sZCI7YTowOnt9czozOiJuZXciO2E6MDp7fX1zOjUwOiJsb2dpbl93ZWJfNTliYTM2YWRkYzJiMmY5NDAxNTgwZjAxNGM3ZjU4ZWE0ZTMwOTg5ZCI7aToxO30=',1737742985),('YjlOJT0L52aeu5LLDJtgYWCEzkDzndtqdO0xUTxW',NULL,'::1','Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/131.0.0.0 Safari/537.36','YTozOntzOjY6Il90b2tlbiI7czo0MDoicHJxTW5oQkFuaWJsbTJjZGxVQWZtNVVQenZ3bnBQazZlMkh0c2h4USI7czo2OiJfZmxhc2giO2E6Mjp7czozOiJvbGQiO2E6MDp7fXM6MzoibmV3IjthOjA6e319czo5OiJfcHJldmlvdXMiO2E6MTp7czozOiJ1cmwiO3M6MTY6Imh0dHA6Ly9sb2NhbGhvc3QiO319',1733854165),('yYL8JYgzQSnkVjU1WjK6srKbp6HjUXywyhiOwZqZ',1,'::1','Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/131.0.0.0 Safari/537.36','YTo0OntzOjY6Il90b2tlbiI7czo0MDoiSkZ5NGhCbnJwSWswOGJJbjh0clNlMHJJZUJDY29aSlRKNmpuU2hPZSI7czo5OiJfcHJldmlvdXMiO2E6MTp7czozOiJ1cmwiO3M6MzY6Imh0dHA6Ly9sb2NhbGhvc3QvZGFzaGJvYXJkP2NvbXBhbnk9MSI7fXM6NjoiX2ZsYXNoIjthOjI6e3M6Mzoib2xkIjthOjA6e31zOjM6Im5ldyI7YTowOnt9fXM6NTA6ImxvZ2luX3dlYl81OWJhMzZhZGRjMmIyZjk0MDE1ODBmMDE0YzdmNThlYTRlMzA5ODlkIjtpOjE7fQ==',1733152989),('ZJRWAAIW4Tnuzpo6YYwIIfDYCWwYdiMOiy9Xsgai',NULL,'::1','Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/131.0.0.0 Safari/537.36','YTozOntzOjY6Il90b2tlbiI7czo0MDoiWTNlRUU1YXg1b2c0T2pVS3J4ajhBUlh3YVdBMmc5cmJEYzh6NEo3eSI7czo5OiJfcHJldmlvdXMiO2E6MTp7czozOiJ1cmwiO3M6MzM6Imh0dHA6Ly9sb2NhbGhvc3Qvc2l6ZXMvYnJhbmRpbmctNSI7fXM6NjoiX2ZsYXNoIjthOjI6e3M6Mzoib2xkIjthOjA6e31zOjM6Im5ldyI7YTowOnt9fX0=',1732912583),('zWmDSA8sGWbvA9xwGN81alq1KKjWspupWCDHp6Op',NULL,'::1','Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/131.0.0.0 Safari/537.36','YTozOntzOjY6Il90b2tlbiI7czo0MDoidUNIRFBsa1ZiUzBIVHpiTm5ia1RaVHpJenlzclJsMlgwWVpMR3ZsNCI7czo5OiJfcHJldmlvdXMiO2E6MTp7czozOiJ1cmwiO3M6MjI6Imh0dHA6Ly9sb2NhbGhvc3QvbG9naW4iO31zOjY6Il9mbGFzaCI7YToyOntzOjM6Im9sZCI7YTowOnt9czozOiJuZXciO2E6MDp7fX19',1733853824);

--
-- Table structure for table `sizes`
--

CREATE TABLE `sizes` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `short_name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `description` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `is_active` tinyint(1) NOT NULL DEFAULT '1',
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=23 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `sizes`
--

INSERT INTO `sizes` VALUES (1,'10 cm','5','',1,NULL,NULL),(2,'15 cm','5','',1,NULL,NULL),(3,'20 cm','5','',1,NULL,NULL),(4,'30 cm','5','',1,NULL,NULL),(5,'40 cm','5','',1,NULL,NULL),(6,'15 cm','2','',1,NULL,NULL),(7,'20 cm','2','',1,NULL,NULL),(8,'30 cm','2','',1,NULL,NULL),(9,'Completo','2','',1,NULL,NULL),(10,'10 cm','6','',1,NULL,NULL),(11,'15 cm','6','',1,NULL,NULL),(12,'20 cm','6','',1,NULL,NULL),(13,'30 cm','6','',1,NULL,NULL),(14,'40 cm','6','',1,NULL,NULL),(15,'10 cm','7','',1,NULL,NULL),(16,'20 cm','7','',1,NULL,NULL),(17,'30 cm','7','',1,NULL,NULL),(18,'10 cm','3','',1,NULL,NULL),(19,'15 cm','3','',1,NULL,NULL),(20,'20 cm','3','',1,NULL,NULL),(21,'30 cm','3','',1,NULL,NULL),(22,'40 cm','3','',1,NULL,NULL);

--
-- Table structure for table `slides`
--

CREATE TABLE `slides` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `img` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `frase` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci 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;

--
-- Dumping data for table `slides`
--


--
-- Table structure for table `states`
--

CREATE TABLE `states` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `description` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `country_id` bigint unsigned NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `states_country_id_foreign` (`country_id`),
  CONSTRAINT `states_country_id_foreign` FOREIGN KEY (`country_id`) REFERENCES `countries` (`id`) ON DELETE CASCADE
) ENGINE=InnoDB AUTO_INCREMENT=11 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `states`
--

INSERT INTO `states` VALUES (1,'Ciudad de México','Estado en México',1,'2024-07-13 16:07:38','2024-07-13 16:07:38'),(2,'Jalisco','Estado en México',1,'2024-07-13 16:07:38','2024-07-13 16:07:38'),(3,'Nuevo León','Estado en México',1,'2024-07-13 16:07:38','2024-07-13 16:07:38'),(4,'California','Estado en Estados Unidos',2,'2024-07-13 16:07:38','2024-07-13 16:07:38'),(5,'Texas','Estado en Estados Unidos',2,'2024-07-13 16:07:38','2024-07-13 16:07:38'),(6,'Quebec','Estado en Canadá',3,'2024-07-13 16:07:38','2024-07-13 16:07:38'),(7,'São Paulo','Estado en Brasil',4,'2024-07-13 16:07:38','2024-07-13 16:07:38'),(8,'Buenos Aires','Estado en Argentina',5,'2024-07-13 16:07:38','2024-07-13 16:07:38'),(9,'Santiago','Estado en Chile',6,'2024-07-13 16:07:38','2024-07-13 16:07:38'),(10,'Cataluña','Estado en España',7,'2024-07-13 16:07:38','2024-07-13 16:07:38');

--
-- Table structure for table `sub_categorias_promocionales`
--

CREATE TABLE `sub_categorias_promocionales` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `nombre` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `descripcion` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
  `categoria_id` bigint unsigned NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `sub_categorias_promocionales_categoria_id_foreign` (`categoria_id`),
  CONSTRAINT `sub_categorias_promocionales_categoria_id_foreign` FOREIGN KEY (`categoria_id`) REFERENCES `categorias_promocionales` (`id`) ON DELETE CASCADE
) ENGINE=InnoDB AUTO_INCREMENT=85 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `sub_categorias_promocionales`
--

INSERT INTO `sub_categorias_promocionales` VALUES (1,'Accesorios de Cocina',NULL,1,'2024-09-12 23:40:32','2024-09-12 23:40:32'),(2,'Accesorios de Smartphone y Tablet',NULL,1,'2024-09-12 23:40:32','2024-09-12 23:40:32'),(3,'Accesorios Deportivos',NULL,1,'2024-09-12 23:40:32','2024-09-12 23:40:32'),(4,'Accesorios para Playa',NULL,1,'2024-09-12 23:40:32','2024-09-12 23:40:32'),(5,'Accesorios para Auto',NULL,1,'2024-09-12 23:40:32','2024-09-12 23:40:32'),(6,'Belleza',NULL,2,'2024-09-12 23:40:32','2024-09-12 23:40:32'),(7,'Espejos y Cepillos',NULL,2,'2024-09-12 23:40:32','2024-09-12 23:40:32'),(8,'Higiene y Cuidado Personal',NULL,2,'2024-09-12 23:40:32','2024-09-12 23:40:32'),(9,'Cosméticas y Alhajeros',NULL,2,'2024-09-12 23:40:32','2024-09-12 23:40:32'),(10,'Sets de Brochas y Manicure',NULL,2,'2024-09-12 23:40:32','2024-09-12 23:40:32'),(11,'Set Skincare',NULL,2,'2024-09-12 23:40:32','2024-09-12 23:40:32'),(12,'Audífonos',NULL,3,'2024-09-12 23:40:32','2024-09-12 23:40:32'),(13,'Bocinas',NULL,3,'2024-09-12 23:40:32','2024-09-12 23:40:32'),(14,'USB',NULL,3,'2024-09-12 23:40:32','2024-09-12 23:40:32'),(15,'Cómputo',NULL,3,'2024-09-12 23:40:32','2024-09-12 23:40:32'),(16,'Artículos Escolares',NULL,4,'2024-09-12 23:40:32','2024-09-12 23:40:32'),(17,'Artículos de Oficina',NULL,4,'2024-09-12 23:40:32','2024-09-12 23:40:32'),(18,'Calculadoras',NULL,4,'2024-09-12 23:40:32','2024-09-12 23:40:32'),(19,'Carpetas',NULL,4,'2024-09-12 23:40:32','2024-09-12 23:40:32'),(20,'Libretas de Bolsillo',NULL,4,'2024-09-12 23:40:32','2024-09-12 23:40:32'),(21,'Libretas de Escritorio',NULL,4,'2024-09-12 23:40:32','2024-09-12 23:40:32'),(22,'Libretas Ecológicas',NULL,4,'2024-09-12 23:40:32','2024-09-12 23:40:32'),(23,'Porta Notas',NULL,4,'2024-09-12 23:40:32','2024-09-12 23:40:32'),(24,'Sets para Escritorio y Organizadores',NULL,4,'2024-09-12 23:40:32','2024-09-12 23:40:32'),(25,'Bolsas',NULL,5,'2024-09-12 23:40:32','2024-09-12 23:40:32'),(26,'Mochilas',NULL,5,'2024-09-12 23:40:32','2024-09-12 23:40:32'),(27,'Mochilas Casuales',NULL,5,'2024-09-12 23:40:32','2024-09-12 23:40:32'),(28,'Mochilas Ejecutivas',NULL,5,'2024-09-12 23:40:32','2024-09-12 23:40:32'),(29,'Mochilas Escolares',NULL,5,'2024-09-12 23:40:32','2024-09-12 23:40:32'),(30,'Maletas',NULL,5,'2024-09-12 23:40:32','2024-09-12 23:40:32'),(31,'Maletas de Viaje',NULL,5,'2024-09-12 23:40:32','2024-09-12 23:40:32'),(32,'Maletas Sport',NULL,5,'2024-09-12 23:40:32','2024-09-12 23:40:32'),(33,'Complementos de Equipaje',NULL,5,'2024-09-12 23:40:32','2024-09-12 23:40:32'),(34,'Cosmetiqueras y Alhajeros',NULL,5,'2024-09-12 23:40:32','2024-09-12 23:40:32'),(35,'Desarmadores y Flexómetros',NULL,6,'2024-09-12 23:40:32','2024-09-12 23:40:32'),(36,'Herramientas',NULL,6,'2024-09-12 23:40:32','2024-09-12 23:40:32'),(37,'Navajas',NULL,6,'2024-09-12 23:40:32','2024-09-12 23:40:32'),(38,'Decoración',NULL,6,'2024-09-12 23:40:32','2024-09-12 23:40:32'),(39,'Hogar',NULL,6,'2024-09-12 23:40:32','2024-09-12 23:40:32'),(40,'Jardinería',NULL,6,'2024-09-12 23:40:32','2024-09-12 23:40:32'),(41,'Chamarras y Chalecos',NULL,7,'2024-09-12 23:40:32','2024-09-12 23:40:32'),(42,'Playeras',NULL,7,'2024-09-12 23:40:32','2024-09-12 23:40:32'),(43,'Cilindros de Plástico',NULL,8,'2024-09-12 23:40:32','2024-09-12 23:40:32'),(44,'Cilindros de Vidrio',NULL,8,'2024-09-12 23:40:32','2024-09-12 23:40:32'),(45,'Cilindros Metálicos',NULL,8,'2024-09-12 23:40:32','2024-09-12 23:40:32'),(46,'Termos',NULL,8,'2024-09-12 23:40:32','2024-09-12 23:40:32'),(47,'Termos de Plástico',NULL,8,'2024-09-12 23:40:32','2024-09-12 23:40:32'),(48,'Termos de Vidrio',NULL,8,'2024-09-12 23:40:32','2024-09-12 23:40:32'),(49,'Termos Metálicos',NULL,8,'2024-09-12 23:40:32','2024-09-12 23:40:32'),(50,'Tazas',NULL,8,'2024-09-12 23:40:32','2024-09-12 23:40:32'),(51,'Vasos',NULL,8,'2024-09-12 23:40:32','2024-09-12 23:40:32'),(52,'Bar',NULL,8,'2024-09-12 23:40:32','2024-09-12 23:40:32'),(53,'BBQ',NULL,8,'2024-09-12 23:40:32','2024-09-12 23:40:32'),(54,'Hieleras y Loncheras',NULL,8,'2024-09-12 23:40:32','2024-09-12 23:40:32'),(55,'Juguetes',NULL,9,'2024-09-12 23:40:32','2024-09-12 23:40:32'),(56,'Entretenimiento',NULL,9,'2024-09-12 23:40:32','2024-09-12 23:40:32'),(57,'Golf',NULL,9,'2024-09-12 23:40:32','2024-09-12 23:40:32'),(58,'Soccer',NULL,9,'2024-09-12 23:40:32','2024-09-12 23:40:32'),(59,'Antiestrés',NULL,9,'2024-09-12 23:40:32','2024-09-12 23:40:32'),(60,'Gorras y Sombreros',NULL,10,'2024-09-12 23:40:32','2024-09-12 23:40:32'),(61,'Carteras y Porta Documentos',NULL,10,'2024-09-12 23:40:32','2024-09-12 23:40:32'),(62,'Portafolios',NULL,10,'2024-09-12 23:40:32','2024-09-12 23:40:32'),(63,'Tarjeteros',NULL,10,'2024-09-12 23:40:32','2024-09-12 23:40:32'),(64,'Llaveros',NULL,10,'2024-09-12 23:40:32','2024-09-12 23:40:32'),(65,'Llaveros Funciones',NULL,10,'2024-09-12 23:40:32','2024-09-12 23:40:32'),(66,'Llaveros Metálicos',NULL,10,'2024-09-12 23:40:32','2024-09-12 23:40:32'),(67,'Pastilleros',NULL,11,'2024-09-12 23:40:32','2024-09-12 23:40:32'),(68,'Artículos Médicos',NULL,11,'2024-09-12 23:40:32','2024-09-12 23:40:32'),(69,'Prevención',NULL,11,'2024-09-12 23:40:32','2024-09-12 23:40:32'),(70,'Alcancías',NULL,12,'2024-09-12 23:40:32','2024-09-12 23:40:32'),(71,'Sets',NULL,12,'2024-09-12 23:40:32','2024-09-12 23:40:32'),(72,'Clásicas',NULL,12,'2024-09-12 23:40:32','2024-09-12 23:40:32'),(73,'Especiales',NULL,12,'2024-09-12 23:40:32','2024-09-12 23:40:32'),(74,'Mini',NULL,12,'2024-09-12 23:40:32','2024-09-12 23:40:32'),(75,'Relojes de Escritorio',NULL,13,'2024-09-12 23:40:32','2024-09-12 23:40:32'),(76,'Relojes de Pared',NULL,13,'2024-09-12 23:40:32','2024-09-12 23:40:32'),(77,'Semanal',NULL,13,'2024-09-12 23:40:32','2024-09-12 23:40:32'),(78,'Diaria',NULL,13,'2024-09-12 23:40:32','2024-09-12 23:40:32'),(79,'Ejecutiva',NULL,13,'2024-09-12 23:40:32','2024-09-12 23:40:32'),(80,'Auto',NULL,14,'2024-09-12 23:40:32','2024-09-12 23:40:32'),(81,'Lámparas',NULL,14,'2024-09-12 23:40:32','2024-09-12 23:40:32'),(82,'Portarretratos',NULL,14,'2024-09-12 23:40:32','2024-09-12 23:40:32'),(83,'Costureros',NULL,14,'2024-09-12 23:40:32','2024-09-12 23:40:32'),(84,'Proyectos especiales',NULL,15,NULL,NULL);

--
-- Table structure for table `subtypes`
--

CREATE TABLE `subtypes` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `description` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `is_active` tinyint(1) NOT NULL DEFAULT '1',
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `type_id` bigint unsigned DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `subtypes_type_id_foreign` (`type_id`),
  CONSTRAINT `subtypes_type_id_foreign` FOREIGN KEY (`type_id`) REFERENCES `types` (`id`) ON DELETE CASCADE
) ENGINE=InnoDB AUTO_INCREMENT=72 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `subtypes`
--

INSERT INTO `subtypes` VALUES (1,'Playeras Cuello Redondo',NULL,1,'2024-07-15 15:48:05','2024-07-15 15:48:05',1),(2,'Playeras Cuello V',NULL,1,'2024-07-15 15:48:05','2024-07-15 15:48:05',1),(3,'Playeras Tipo Polo',NULL,1,'2024-07-15 15:48:05','2024-07-15 15:48:05',1),(4,'Playeras Dry Fit',NULL,1,'2024-07-15 15:48:05','2024-07-15 15:48:05',1),(5,'Camisas & Blusas Oxford',NULL,1,'2024-07-15 15:48:05','2024-07-15 15:48:05',3),(6,'Camisas & Blusas Gabardina',NULL,1,'2024-07-15 15:48:05','2024-07-15 15:48:05',3),(7,'Sudadera Básica Cuello Redondo',NULL,1,'2024-07-15 15:48:05','2024-07-15 15:48:05',3),(8,'Sudadera Capucha',NULL,1,'2024-07-15 15:48:05','2024-07-15 15:48:05',4),(9,'Sudadera Zipper',NULL,1,'2024-07-15 15:48:05','2024-07-15 15:48:05',4),(10,'Chamarras Nylon',NULL,1,'2024-07-15 15:48:05','2024-07-15 15:48:05',5),(11,'Chamarras Shell',NULL,1,'2024-07-15 15:48:05','2024-07-15 15:48:05',5),(12,'Chaleco Nylon',NULL,1,'2024-07-15 15:48:05','2024-07-15 15:48:05',5),(13,'Chaleco Shell',NULL,1,'2024-07-15 15:48:05','2024-07-15 15:48:05',5),(14,'Chaleco de Seguridad',NULL,1,'2024-07-15 15:48:05','2024-07-15 15:48:05',5),(15,'Gorra Algodón',NULL,1,'2024-07-15 15:48:05','2024-07-15 15:48:05',2),(16,'Gorra Acrilico',NULL,1,'2024-07-15 15:48:05','2024-07-15 15:48:05',2),(17,'Gorra Malla',NULL,1,'2024-07-15 15:48:05','2024-07-15 15:48:05',2),(18,'Gorra Deportiva',NULL,1,'2024-07-15 15:48:05','2024-07-15 15:48:05',2),(19,'Gorra Fit Cap',NULL,1,'2024-07-15 15:48:05','2024-07-15 15:48:05',2),(20,'Toalla Microfibra',NULL,1,'2024-07-15 15:48:05','2024-07-15 15:48:05',6),(21,'Toalla Algodón',NULL,1,'2024-07-15 15:48:05','2024-07-15 15:48:05',6),(22,'Trucker',NULL,1,NULL,NULL,2),(23,'Mandil Completo',NULL,1,'2024-07-15 16:38:41','2024-07-15 16:38:41',7),(24,'Medio Mandil',NULL,1,'2024-07-15 16:38:41','2024-07-15 16:38:41',7),(25,'VASO 20 OZ',NULL,1,'2024-07-15 16:38:41','2024-07-15 16:38:41',8),(26,'VASO 30 OZ',NULL,1,'2024-07-15 16:38:41','2024-07-15 16:38:41',8),(27,'VASO TIPO STANLEY',NULL,1,'2024-07-15 16:38:41','2024-07-15 16:38:41',8),(28,'VASO 12 OZ',NULL,1,'2024-07-15 16:38:41','2024-07-15 16:38:41',8),(29,'BOLSA ECOLOGICA',NULL,1,'2024-07-15 16:38:41','2024-07-15 16:38:41',9);

--
-- Table structure for table `type_users`
--

CREATE TABLE `type_users` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `name` varchar(255) CHARACTER SET utf8mb4 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;

--
-- Dumping data for table `type_users`
--

INSERT INTO `type_users` VALUES (1,'ADMIN','2024-09-03 15:43:58','2024-09-03 15:43:58'),(2,'CLIENT','2024-09-03 15:43:58','2024-09-03 15:43:58'),(3,'PROVIDER','2024-09-03 15:43:58','2024-09-03 15:43:58');

--
-- Table structure for table `types`
--

CREATE TABLE `types` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `description` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `is_active` tinyint(1) NOT NULL DEFAULT '1',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=14 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `types`
--

INSERT INTO `types` VALUES (1,'PLAYERAS','NA','2024-07-15 15:42:45','2024-07-15 15:42:45',1),(2,'GORRAS','PLAY','2024-07-15 15:42:45','2024-07-15 15:42:45',1),(3,'CAMISAS','POLO','2024-07-15 15:42:45','2024-07-15 15:42:45',1),(4,'SUDADERAS','GRRA','2024-07-15 15:42:45','2024-07-15 15:42:45',1),(5,'CHAMARRA & CHALECO','CAMI','2024-07-15 15:42:45','2024-07-15 15:42:45',1),(6,'TOALLAS','SUDA','2024-07-15 15:42:45','2024-07-15 15:42:45',1),(7,'COCINA','CHAM','2024-07-15 15:42:45','2024-07-15 15:42:45',1),(8,'TERMOS','CHAL','2024-07-15 15:42:45','2024-07-15 15:42:45',1),(9,'BOLSAS ECOLOGICAS','PROMOCIONAL','2024-07-15 15:42:45','2024-07-15 15:42:45',1),(10,'PROMOS','','2024-07-15 15:42:45','2024-07-15 15:42:45',1);


