-- --------------------------------------------------------
-- Versión del servidor:         5.7.39 - MySQL Community Server (GPL)
-- SO del servidor:              Win64
-- HeidiSQL Versión:             12.1.0.6537
-- --------------------------------------------------------



-- Volcando estructura de base de datos para homestead
CREATE DATABASE IF NOT EXISTS `homestead` /*!40100 DEFAULT CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci */;
USE `homestead`;

-- Volcando estructura para tabla homestead.animals
CREATE TABLE IF NOT EXISTS `animals` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `name` varchar(15) COLLATE utf8mb4_unicode_ci NOT NULL,
  `number` varchar(3) COLLATE utf8mb4_unicode_ci NOT NULL,
  `sort_id` int(10) unsigned NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `animals_sort_id_foreign` (`sort_id`),
  CONSTRAINT `animals_sort_id_foreign` FOREIGN KEY (`sort_id`) REFERENCES `sorts` (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=153 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

-- Volcando datos para la tabla homestead.animals: ~152 rows (aproximadamente)
INSERT INTO `animals` (`id`, `name`, `number`, `sort_id`, `created_at`, `updated_at`) VALUES
	(1, 'Delfín', '0', 1, '2023-04-04 20:59:49', '2023-04-04 20:59:49'),
	(2, 'Ballena', '00', 1, '2023-04-04 20:59:49', '2023-04-04 20:59:49'),
	(3, 'Carnero', '1', 1, '2023-04-04 20:59:49', '2023-04-04 20:59:49'),
	(4, 'Toro', '2', 1, '2023-04-04 20:59:49', '2023-04-04 20:59:49'),
	(5, 'Ciempies', '3', 1, '2023-04-04 20:59:49', '2023-04-04 20:59:49'),
	(6, 'Alacrán', '4', 1, '2023-04-04 20:59:49', '2023-04-04 20:59:49'),
	(7, 'León', '5', 1, '2023-04-04 20:59:49', '2023-04-04 20:59:49'),
	(8, 'Rana', '6', 1, '2023-04-04 20:59:49', '2023-04-04 20:59:49'),
	(9, 'Perico', '7', 1, '2023-04-04 20:59:49', '2023-04-04 20:59:49'),
	(10, 'Ratón', '8', 1, '2023-04-04 20:59:49', '2023-04-04 20:59:49'),
	(11, 'Águila', '9', 1, '2023-04-04 20:59:49', '2023-04-04 20:59:49'),
	(12, 'Tigre', '10', 1, '2023-04-04 20:59:49', '2023-04-04 20:59:49'),
	(13, 'Gato', '11', 1, '2023-04-04 20:59:49', '2023-04-04 20:59:49'),
	(14, 'Caballo', '12', 1, '2023-04-04 20:59:49', '2023-04-04 20:59:49'),
	(15, 'Mono', '13', 1, '2023-04-04 20:59:49', '2023-04-04 20:59:49'),
	(16, 'Paloma', '14', 1, '2023-04-04 20:59:49', '2023-04-04 20:59:49'),
	(17, 'Zorro', '15', 1, '2023-04-04 20:59:49', '2023-04-04 20:59:49'),
	(18, 'Oso', '16', 1, '2023-04-04 20:59:49', '2023-04-04 20:59:49'),
	(19, 'Pavo', '17', 1, '2023-04-04 20:59:49', '2023-04-04 20:59:49'),
	(20, 'Burro', '18', 1, '2023-04-04 20:59:49', '2023-04-04 20:59:49'),
	(21, 'Chivo', '19', 1, '2023-04-04 20:59:49', '2023-04-04 20:59:49'),
	(22, 'Cerdo', '20', 1, '2023-04-04 20:59:49', '2023-04-04 20:59:49'),
	(23, 'Gallo', '21', 1, '2023-04-04 20:59:49', '2023-04-04 20:59:49'),
	(24, 'Camello', '22', 1, '2023-04-04 20:59:49', '2023-04-04 20:59:49'),
	(25, 'Cebra', '23', 1, '2023-04-04 20:59:49', '2023-04-04 20:59:49'),
	(26, 'Iguana', '24', 1, '2023-04-04 20:59:49', '2023-04-04 20:59:49'),
	(27, 'Gallina', '25', 1, '2023-04-04 20:59:49', '2023-04-04 20:59:49'),
	(28, 'Vaca', '26', 1, '2023-04-04 20:59:49', '2023-04-04 20:59:49'),
	(29, 'Perro', '27', 1, '2023-04-04 20:59:49', '2023-04-04 20:59:49'),
	(30, 'Zamuro', '28', 1, '2023-04-04 20:59:49', '2023-04-04 20:59:49'),
	(31, 'Elefante', '29', 1, '2023-04-04 20:59:49', '2023-04-04 20:59:49'),
	(32, 'Caimán', '30', 1, '2023-04-04 20:59:49', '2023-04-04 20:59:49'),
	(33, 'Lapa', '31', 1, '2023-04-04 20:59:49', '2023-04-04 20:59:49'),
	(34, 'Ardilla', '32', 1, '2023-04-04 20:59:49', '2023-04-04 20:59:49'),
	(35, 'Pez', '33', 1, '2023-04-04 20:59:49', '2023-04-04 20:59:49'),
	(36, 'Venado', '34', 1, '2023-04-04 20:59:49', '2023-04-04 20:59:49'),
	(37, 'Jirafa', '35', 1, '2023-04-04 20:59:49', '2023-04-04 20:59:49'),
	(38, 'Culebra', '36', 1, '2023-04-04 20:59:49', '2023-04-04 20:59:49'),
	(39, 'Delfín', '0', 2, '2023-04-04 20:59:49', '2023-04-04 20:59:49'),
	(40, 'Ballena', '00', 2, '2023-04-04 20:59:49', '2023-04-04 20:59:49'),
	(41, 'Carnero', '1', 2, '2023-04-04 20:59:49', '2023-04-04 20:59:49'),
	(42, 'Toro', '2', 2, '2023-04-04 20:59:49', '2023-04-04 20:59:49'),
	(43, 'Ciempies', '3', 2, '2023-04-04 20:59:49', '2023-04-04 20:59:49'),
	(44, 'Alacrán', '4', 2, '2023-04-04 20:59:49', '2023-04-04 20:59:49'),
	(45, 'León', '5', 2, '2023-04-04 20:59:49', '2023-04-04 20:59:49'),
	(46, 'Rana', '6', 2, '2023-04-04 20:59:49', '2023-04-04 20:59:49'),
	(47, 'Perico', '7', 2, '2023-04-04 20:59:49', '2023-04-04 20:59:49'),
	(48, 'Ratón', '8', 2, '2023-04-04 20:59:49', '2023-04-04 20:59:49'),
	(49, 'Águila', '9', 2, '2023-04-04 20:59:49', '2023-04-04 20:59:49'),
	(50, 'Tigre', '10', 2, '2023-04-04 20:59:49', '2023-04-04 20:59:49'),
	(51, 'Gato', '11', 2, '2023-04-04 20:59:49', '2023-04-04 20:59:49'),
	(52, 'Caballo', '12', 2, '2023-04-04 20:59:49', '2023-04-04 20:59:49'),
	(53, 'Mono', '13', 2, '2023-04-04 20:59:49', '2023-04-04 20:59:49'),
	(54, 'Paloma', '14', 2, '2023-04-04 20:59:49', '2023-04-04 20:59:49'),
	(55, 'Zorro', '15', 2, '2023-04-04 20:59:49', '2023-04-04 20:59:49'),
	(56, 'Oso', '16', 2, '2023-04-04 20:59:49', '2023-04-04 20:59:49'),
	(57, 'Pavo', '17', 2, '2023-04-04 20:59:49', '2023-04-04 20:59:49'),
	(58, 'Burro', '18', 2, '2023-04-04 20:59:49', '2023-04-04 20:59:49'),
	(59, 'Chivo', '19', 2, '2023-04-04 20:59:49', '2023-04-04 20:59:49'),
	(60, 'Cerdo', '20', 2, '2023-04-04 20:59:49', '2023-04-04 20:59:49'),
	(61, 'Gallo', '21', 2, '2023-04-04 20:59:49', '2023-04-04 20:59:49'),
	(62, 'Camello', '22', 2, '2023-04-04 20:59:49', '2023-04-04 20:59:49'),
	(63, 'Cebra', '23', 2, '2023-04-04 20:59:49', '2023-04-04 20:59:49'),
	(64, 'Iguana', '24', 2, '2023-04-04 20:59:49', '2023-04-04 20:59:49'),
	(65, 'Gallina', '25', 2, '2023-04-04 20:59:49', '2023-04-04 20:59:49'),
	(66, 'Vaca', '26', 2, '2023-04-04 20:59:49', '2023-04-04 20:59:49'),
	(67, 'Perro', '27', 2, '2023-04-04 20:59:49', '2023-04-04 20:59:49'),
	(68, 'Zamuro', '28', 2, '2023-04-04 20:59:49', '2023-04-04 20:59:49'),
	(69, 'Elefante', '29', 2, '2023-04-04 20:59:49', '2023-04-04 20:59:49'),
	(70, 'Caimán', '30', 2, '2023-04-04 20:59:49', '2023-04-04 20:59:49'),
	(71, 'Lapa', '31', 2, '2023-04-04 20:59:49', '2023-04-04 20:59:49'),
	(72, 'Ardilla', '32', 2, '2023-04-04 20:59:49', '2023-04-04 20:59:49'),
	(73, 'Pez', '33', 2, '2023-04-04 20:59:49', '2023-04-04 20:59:49'),
	(74, 'Venado', '34', 2, '2023-04-04 20:59:49', '2023-04-04 20:59:49'),
	(75, 'Jirafa', '35', 2, '2023-04-04 20:59:49', '2023-04-04 20:59:49'),
	(76, 'Culebra', '36', 2, '2023-04-04 20:59:49', '2023-04-04 20:59:49'),
	(77, 'Delfín', '0', 3, '2023-04-04 21:01:35', '2023-04-04 21:01:35'),
	(78, 'Ballena', '00', 3, '2023-04-04 21:01:35', '2023-04-04 21:01:35'),
	(79, 'Carnero', '1', 3, '2023-04-04 21:01:35', '2023-04-04 21:01:35'),
	(80, 'Toro', '2', 3, '2023-04-04 21:01:35', '2023-04-04 21:01:35'),
	(81, 'Ciempies', '3', 3, '2023-04-04 21:01:35', '2023-04-04 21:01:35'),
	(82, 'Alacrán', '4', 3, '2023-04-04 21:01:35', '2023-04-04 21:01:35'),
	(83, 'León', '5', 3, '2023-04-04 21:01:35', '2023-04-04 21:01:35'),
	(84, 'Rana', '6', 3, '2023-04-04 21:01:35', '2023-04-04 21:01:35'),
	(85, 'Perico', '7', 3, '2023-04-04 21:01:35', '2023-04-04 21:01:35'),
	(86, 'Ratón', '8', 3, '2023-04-04 21:01:35', '2023-04-04 21:01:35'),
	(87, 'Águila', '9', 3, '2023-04-04 21:01:35', '2023-04-04 21:01:35'),
	(88, 'Tigre', '10', 3, '2023-04-04 21:01:35', '2023-04-04 21:01:35'),
	(89, 'Gato', '11', 3, '2023-04-04 21:01:35', '2023-04-04 21:01:35'),
	(90, 'Caballo', '12', 3, '2023-04-04 21:01:35', '2023-04-04 21:01:35'),
	(91, 'Mono', '13', 3, '2023-04-04 21:01:35', '2023-04-04 21:01:35'),
	(92, 'Paloma', '14', 3, '2023-04-04 21:01:35', '2023-04-04 21:01:35'),
	(93, 'Zorro', '15', 3, '2023-04-04 21:01:35', '2023-04-04 21:01:35'),
	(94, 'Oso', '16', 3, '2023-04-04 21:01:35', '2023-04-04 21:01:35'),
	(95, 'Pavo', '17', 3, '2023-04-04 21:01:35', '2023-04-04 21:01:35'),
	(96, 'Burro', '18', 3, '2023-04-04 21:01:35', '2023-04-04 21:01:35'),
	(97, 'Chivo', '19', 3, '2023-04-04 21:01:35', '2023-04-04 21:01:35'),
	(98, 'Cerdo', '20', 3, '2023-04-04 21:01:35', '2023-04-04 21:01:35'),
	(99, 'Gallo', '21', 3, '2023-04-04 21:01:35', '2023-04-04 21:01:35'),
	(100, 'Camello', '22', 3, '2023-04-04 21:01:35', '2023-04-04 21:01:35'),
	(101, 'Cebra', '23', 3, '2023-04-04 21:01:35', '2023-04-04 21:01:35'),
	(102, 'Iguana', '24', 3, '2023-04-04 21:01:35', '2023-04-04 21:01:35'),
	(103, 'Gallina', '25', 3, '2023-04-04 21:01:35', '2023-04-04 21:01:35'),
	(104, 'Vaca', '26', 3, '2023-04-04 21:01:35', '2023-04-04 21:01:35'),
	(105, 'Perro', '27', 3, '2023-04-04 21:01:35', '2023-04-04 21:01:35'),
	(106, 'Zamuro', '28', 3, '2023-04-04 21:01:35', '2023-04-04 21:01:35'),
	(107, 'Elefante', '29', 3, '2023-04-04 21:01:35', '2023-04-04 21:01:35'),
	(108, 'Caimán', '30', 3, '2023-04-04 21:01:35', '2023-04-04 21:01:35'),
	(109, 'Lapa', '31', 3, '2023-04-04 21:01:35', '2023-04-04 21:01:35'),
	(110, 'Ardilla', '32', 3, '2023-04-04 21:01:35', '2023-04-04 21:01:35'),
	(111, 'Pez', '33', 3, '2023-04-04 21:01:35', '2023-04-04 21:01:35'),
	(112, 'Venado', '34', 3, '2023-04-04 21:01:35', '2023-04-04 21:01:35'),
	(113, 'Jirafa', '35', 3, '2023-04-04 21:01:35', '2023-04-04 21:01:35'),
	(114, 'Culebra', '36', 3, '2023-04-04 21:01:35', '2023-04-04 21:01:35'),
	(115, 'Delfín', '0', 4, '2023-04-04 21:01:35', '2023-04-04 21:01:35'),
	(116, 'Ballena', '00', 4, '2023-04-04 21:01:35', '2023-04-04 21:01:35'),
	(117, 'Carnero', '1', 4, '2023-04-04 21:01:35', '2023-04-04 21:01:35'),
	(118, 'Toro', '2', 4, '2023-04-04 21:01:35', '2023-04-04 21:01:35'),
	(119, 'Ciempies', '3', 4, '2023-04-04 21:01:35', '2023-04-04 21:01:35'),
	(120, 'Alacrán', '4', 4, '2023-04-04 21:01:35', '2023-04-04 21:01:35'),
	(121, 'León', '5', 4, '2023-04-04 21:01:35', '2023-04-04 21:01:35'),
	(122, 'Rana', '6', 4, '2023-04-04 21:01:35', '2023-04-04 21:01:35'),
	(123, 'Perico', '7', 4, '2023-04-04 21:01:35', '2023-04-04 21:01:35'),
	(124, 'Ratón', '8', 4, '2023-04-04 21:01:35', '2023-04-04 21:01:35'),
	(125, 'Águila', '9', 4, '2023-04-04 21:01:35', '2023-04-04 21:01:35'),
	(126, 'Tigre', '10', 4, '2023-04-04 21:01:35', '2023-04-04 21:01:35'),
	(127, 'Gato', '11', 4, '2023-04-04 21:01:35', '2023-04-04 21:01:35'),
	(128, 'Caballo', '12', 4, '2023-04-04 21:01:35', '2023-04-04 21:01:35'),
	(129, 'Mono', '13', 4, '2023-04-04 21:01:35', '2023-04-04 21:01:35'),
	(130, 'Paloma', '14', 4, '2023-04-04 21:01:35', '2023-04-04 21:01:35'),
	(131, 'Zorro', '15', 4, '2023-04-04 21:01:35', '2023-04-04 21:01:35'),
	(132, 'Oso', '16', 4, '2023-04-04 21:01:35', '2023-04-04 21:01:35'),
	(133, 'Pavo', '17', 4, '2023-04-04 21:01:35', '2023-04-04 21:01:35'),
	(134, 'Burro', '18', 4, '2023-04-04 21:01:35', '2023-04-04 21:01:35'),
	(135, 'Chivo', '19', 4, '2023-04-04 21:01:35', '2023-04-04 21:01:35'),
	(136, 'Cerdo', '20', 4, '2023-04-04 21:01:35', '2023-04-04 21:01:35'),
	(137, 'Gallo', '21', 4, '2023-04-04 21:01:35', '2023-04-04 21:01:35'),
	(138, 'Camello', '22', 4, '2023-04-04 21:01:35', '2023-04-04 21:01:35'),
	(139, 'Cebra', '23', 4, '2023-04-04 21:01:35', '2023-04-04 21:01:35'),
	(140, 'Iguana', '24', 4, '2023-04-04 21:01:35', '2023-04-04 21:01:35'),
	(141, 'Gallina', '25', 4, '2023-04-04 21:01:35', '2023-04-04 21:01:35'),
	(142, 'Vaca', '26', 4, '2023-04-04 21:01:35', '2023-04-04 21:01:35'),
	(143, 'Perro', '27', 4, '2023-04-04 21:01:35', '2023-04-04 21:01:35'),
	(144, 'Zamuro', '28', 4, '2023-04-04 21:01:35', '2023-04-04 21:01:35'),
	(145, 'Elefante', '29', 4, '2023-04-04 21:01:35', '2023-04-04 21:01:35'),
	(146, 'Caimán', '30', 4, '2023-04-04 21:01:35', '2023-04-04 21:01:35'),
	(147, 'Lapa', '31', 4, '2023-04-04 21:01:35', '2023-04-04 21:01:35'),
	(148, 'Ardilla', '32', 4, '2023-04-04 21:01:35', '2023-04-04 21:01:35'),
	(149, 'Pez', '33', 4, '2023-04-04 21:01:35', '2023-04-04 21:01:35'),
	(150, 'Venado', '34', 4, '2023-04-04 21:01:35', '2023-04-04 21:01:35'),
	(151, 'Jirafa', '35', 4, '2023-04-04 21:01:35', '2023-04-04 21:01:35'),
	(152, 'Culebra', '36', 4, '2023-04-04 21:01:35', '2023-04-04 21:01:35');

-- Volcando estructura para tabla homestead.animal_ticket
CREATE TABLE IF NOT EXISTS `animal_ticket` (
  `animal_id` int(10) unsigned NOT NULL,
  `ticket_id` int(10) unsigned NOT NULL,
  `amount` double(8,2) NOT NULL,
  PRIMARY KEY (`ticket_id`,`animal_id`),
  KEY `animal_ticket_animal_id_foreign` (`animal_id`),
  CONSTRAINT `animal_ticket_animal_id_foreign` FOREIGN KEY (`animal_id`) REFERENCES `animals` (`id`),
  CONSTRAINT `animal_ticket_ticket_id_foreign` FOREIGN KEY (`ticket_id`) REFERENCES `tickets` (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

-- Volcando datos para la tabla homestead.animal_ticket: ~10 rows (aproximadamente)
INSERT INTO `animal_ticket` (`animal_id`, `ticket_id`, `amount`) VALUES
	(2, 1, 200.00),
	(4, 2, 50.00),
	(10, 2, 20.00),
	(11, 2, 50.00),
	(3, 3, 100.00),
	(3, 4, 10.00),
	(9, 4, 10.00),
	(7, 5, 10.00),
	(13, 5, 10.00),
	(14, 5, 10.00);

-- Volcando estructura para tabla homestead.daily_sort
CREATE TABLE IF NOT EXISTS `daily_sort` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `sort_id` int(10) unsigned NOT NULL,
  `time_sort` time NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `daily_sort_sort_id_foreign` (`sort_id`),
  CONSTRAINT `daily_sort_sort_id_foreign` FOREIGN KEY (`sort_id`) REFERENCES `sorts` (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

-- Volcando datos para la tabla homestead.daily_sort: ~1 rows (aproximadamente)
INSERT INTO `daily_sort` (`id`, `sort_id`, `time_sort`, `created_at`, `updated_at`) VALUES
	(1, 1, '11:00:00', '2023-04-04 21:02:51', '2023-04-05 15:42:21');

-- Volcando estructura para tabla homestead.migrations
CREATE TABLE IF NOT EXISTS `migrations` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `migration` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `batch` int(11) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=12 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

-- Volcando datos para la tabla homestead.migrations: ~11 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_resets_table', 1),
	(3, '2017_09_12_002150_create_table_sorts', 1),
	(4, '2017_09_12_002155_create_table_daily_sort', 1),
	(5, '2017_09_12_002159_create_table_tickets', 1),
	(6, '2017_09_12_003018_create_table_animals', 1),
	(7, '2017_09_23_160339_create_table_results', 1),
	(8, '2017_09_24_000816_create_table_print_spooler', 1),
	(9, '2017_09_29_195533_create_table_ticket_sort', 1),
	(10, '2018_01_27_102436_create_status_gain', 1),
	(11, '2018_02_17_115209_add_colum_week_limit', 1);

-- Volcando datos para la tabla homestead.password_resets: ~0 rows (aproximadamente)

-- Volcando estructura para tabla homestead.print_spooler
CREATE TABLE IF NOT EXISTS `print_spooler` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `ticket_id` int(10) unsigned NOT NULL,
  `status` varchar(15) COLLATE utf8mb4_unicode_ci NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `print_spooler_ticket_id_foreign` (`ticket_id`),
  CONSTRAINT `print_spooler_ticket_id_foreign` FOREIGN KEY (`ticket_id`) REFERENCES `tickets` (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=8 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

-- Volcando datos para la tabla homestead.print_spooler: ~7 rows (aproximadamente)
INSERT INTO `print_spooler` (`id`, `ticket_id`, `status`, `created_at`, `updated_at`) VALUES
	(1, 1, 'Pendiente', '2023-04-04 20:13:12', '2023-04-04 20:13:12'),
	(2, 1, 'Pendiente', '2023-04-04 20:13:27', '2023-04-04 20:13:27'),
	(3, 2, 'Pendiente', '2023-04-04 20:14:45', '2023-04-04 20:14:45'),
	(4, 1, 'Pendiente', '2023-04-05 15:39:17', '2023-04-05 15:39:17'),
	(5, 3, 'Pendiente', '2023-04-05 15:40:13', '2023-04-05 15:40:13'),
	(6, 4, 'Pendiente', '2023-04-05 15:42:34', '2023-04-05 15:42:34'),
	(7, 5, 'Pendiente', '2023-04-05 15:42:46', '2023-04-05 15:42:46');

-- Volcando estructura para tabla homestead.results
CREATE TABLE IF NOT EXISTS `results` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `daily_sort_id` int(10) unsigned NOT NULL,
  `animal_id` int(10) unsigned NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `results_daily_sort_id_foreign` (`daily_sort_id`),
  KEY `results_animal_id_foreign` (`animal_id`),
  CONSTRAINT `results_animal_id_foreign` FOREIGN KEY (`animal_id`) REFERENCES `animals` (`id`),
  CONSTRAINT `results_daily_sort_id_foreign` FOREIGN KEY (`daily_sort_id`) REFERENCES `daily_sort` (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

-- Volcando datos para la tabla homestead.results: ~2 rows (aproximadamente)
INSERT INTO `results` (`id`, `daily_sort_id`, `animal_id`, `created_at`, `updated_at`) VALUES
	(1, 1, 10, '2023-04-04 05:00:00', '2023-04-04 20:50:46'),
	(2, 1, 7, '2023-04-05 05:00:00', '2023-04-05 17:31:36');

-- Volcando estructura para tabla homestead.sorts
CREATE TABLE IF NOT EXISTS `sorts` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `description` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `pay_per_100` decimal(8,2) NOT NULL,
  `folder` varchar(20) COLLATE utf8mb4_unicode_ci NOT NULL,
  `daily_limit` decimal(8,2) NOT NULL,
  `week_limit` double 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;

-- Volcando datos para la tabla homestead.sorts: ~4 rows (aproximadamente)
INSERT INTO `sorts` (`id`, `description`, `pay_per_100`, `folder`, `daily_limit`, `week_limit`, `created_at`, `updated_at`) VALUES
	(1, 'Lotto Activo', 0.00, 'lottoActivo', 500.00, 1000000, '2023-04-04 20:59:49', '2023-04-04 20:59:49'),
	(2, 'La granjita', 0.00, 'lottoActivo', 500.00, 1000000, '2023-04-04 20:59:49', '2023-04-04 20:59:49'),
	(3, 'Lotto Activo', 0.00, 'lottoActivo', 500.00, 1000000, '2023-04-04 21:01:35', '2023-04-04 21:01:35'),
	(4, 'La granjita', 0.00, 'lottoActivo', 500.00, 1000000, '2023-04-04 21:01:35', '2023-04-04 21:01:35');

-- Volcando estructura para tabla homestead.tickets
CREATE TABLE IF NOT EXISTS `tickets` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `public_id` varchar(20) COLLATE utf8mb4_unicode_ci NOT NULL,
  `user_id` int(10) unsigned NOT NULL,
  `status` varchar(20) COLLATE utf8mb4_unicode_ci NOT NULL,
  `pay_per_100` double(8,2) NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `tickets_public_id_unique` (`public_id`),
  KEY `tickets_user_id_foreign` (`user_id`),
  CONSTRAINT `tickets_user_id_foreign` FOREIGN KEY (`user_id`) REFERENCES `users` (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=6 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

-- Volcando datos para la tabla homestead.tickets: ~5 rows (aproximadamente)
INSERT INTO `tickets` (`id`, `public_id`, `user_id`, `status`, `pay_per_100`, `created_at`, `updated_at`) VALUES
	(1, 'TICK001', 4, 'Pago', 100.00, '2023-04-04 20:13:12', '2023-04-04 20:49:56'),
	(2, 'TICK002', 4, 'Ganador', 100.00, '2023-04-04 20:14:45', '2023-04-04 20:50:46'),
	(3, 'TICK003', 4, 'Activo', 500.00, '2023-04-05 15:40:13', '2023-04-05 17:31:32'),
	(4, 'TICK004', 1, 'Activo', 500.00, '2023-04-05 15:42:34', '2023-04-05 17:31:32'),
	(5, 'TICK005', 1, 'Ganador', 500.00, '2023-04-05 15:42:46', '2023-04-05 17:31:36');

-- Volcando estructura para tabla homestead.ticket_sort
CREATE TABLE IF NOT EXISTS `ticket_sort` (
  `ticket_id` int(10) unsigned NOT NULL,
  `daily_sort_id` int(10) unsigned NOT NULL,
  PRIMARY KEY (`ticket_id`,`daily_sort_id`),
  KEY `ticket_sort_daily_sort_id_foreign` (`daily_sort_id`),
  CONSTRAINT `ticket_sort_daily_sort_id_foreign` FOREIGN KEY (`daily_sort_id`) REFERENCES `daily_sort` (`id`),
  CONSTRAINT `ticket_sort_ticket_id_foreign` FOREIGN KEY (`ticket_id`) REFERENCES `tickets` (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

-- Volcando datos para la tabla homestead.ticket_sort: ~5 rows (aproximadamente)
INSERT INTO `ticket_sort` (`ticket_id`, `daily_sort_id`) VALUES
	(1, 1),
	(2, 1),
	(3, 1),
	(4, 1),
	(5, 1);

