--
-- Host: localhost    Database: tenant63e25a97-091f-432f-87ab-e1e13ef1b3b9
-- ------------------------------------------------------


--
-- Table structure for table `affiliate_links`
--

CREATE TABLE `affiliate_links` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `name` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `slug` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `destination_url` text COLLATE utf8mb4_unicode_ci NOT NULL,
  `redirect_type` enum('301','302','307') COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '302',
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `affiliate_links_slug_unique` (`slug`)
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `affiliate_links`
--

INSERT INTO `affiliate_links` VALUES (1,'test link','test-link','https://google.de','301','2024-10-30 10:03:48','2024-10-30 10:03:48');

--
-- Table structure for table `migrations`
--

CREATE TABLE `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=4 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `migrations`
--

INSERT INTO `migrations` VALUES (1,'0001_01_01_000000_create_users_table',1),(2,'0001_01_01_000001_create_cache_table',1),(3,'2024_08_13_103746_create_affiliate_links_table',1);

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

CREATE TABLE `sessions` (
  `id` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `user_id` bigint unsigned DEFAULT NULL,
  `ip_address` varchar(45) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `user_agent` text COLLATE utf8mb4_unicode_ci,
  `payload` longtext 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 ('3Yb7wFfOXU2YOWL01yLluhmOE9BMl1JZLjEQsKRR',NULL,'89.205.63.102','Mozilla/5.0 (X11; Linux x86_64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/128.0.0.0 Safari/537.36','YTozOntzOjY6Il90b2tlbiI7czo0MDoid0xkbXpUUjR3M2JhUHNzSUdVMnl4NWVhVUJNMVFXUVFQNkJ4N202bCI7czo5OiJfcHJldmlvdXMiO2E6MTp7czozOiJ1cmwiO3M6NDI6Imh0dHBzOi8vbm9jdHVhbWVkaWEubGlua3MtbWFuYWdlci54Z2F0ZS5pbyI7fXM6NjoiX2ZsYXNoIjthOjI6e3M6Mzoib2xkIjthOjA6e31zOjM6Im5ldyI7YTowOnt9fX0=',1730304461),('8glsoX2rn11UQoDIA9gRQL9TjNidI2jCTKjHVT3O',NULL,'89.205.63.102','Mozilla/5.0 (X11; Linux x86_64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/128.0.0.0 Safari/537.36','YTozOntzOjY6Il90b2tlbiI7czo0MDoidThsVVVNcFNGdFdack1wVkxVSWxLd1VER0RTRnRPQXlrczQ0U3VoYyI7czo5OiJfcHJldmlvdXMiO2E6MTp7czozOiJ1cmwiO3M6NDI6Imh0dHBzOi8vbm9jdHVhbWVkaWEubGlua3MtbWFuYWdlci54Z2F0ZS5pbyI7fXM6NjoiX2ZsYXNoIjthOjI6e3M6Mzoib2xkIjthOjA6e31zOjM6Im5ldyI7YTowOnt9fX0=',1730379795),('dNAn0qW1KkVlAROMjz5UjDxvtKlqBQiJ6UEfiOzd',NULL,'89.205.63.102','Mozilla/5.0 (X11; Linux x86_64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/128.0.0.0 Safari/537.36','YTozOntzOjY6Il90b2tlbiI7czo0MDoiZnU2TmtPNHY1c3lLcHJ5aDdmQnZMVVJFYVVab3ZnNFo5ZWhrWUVoSiI7czo5OiJfcHJldmlvdXMiO2E6MTp7czozOiJ1cmwiO3M6NDg6Imh0dHBzOi8vbm9jdHVhbWVkaWEubGlua3MtbWFuYWdlci54Z2F0ZS5pby9sb2dpbiI7fXM6NjoiX2ZsYXNoIjthOjI6e3M6Mzoib2xkIjthOjA6e31zOjM6Im5ldyI7YTowOnt9fX0=',1730299740),('EuE506WqZ2DQMqMXtvajn81FlqgAUvjZgF6SnTN0',NULL,'18.233.111.44','Slackbot-LinkExpanding 1.0 (+https://api.slack.com/robots)','YTozOntzOjY6Il90b2tlbiI7czo0MDoiY0NteE43aW9IMUFNQWVEWXZOclFIaGR2V1JtVHVhS2JOSmJweDFiOCI7czo5OiJfcHJldmlvdXMiO2E6MTp7czozOiJ1cmwiO3M6NDI6Imh0dHBzOi8vbm9jdHVhbWVkaWEubGlua3MtbWFuYWdlci54Z2F0ZS5pbyI7fXM6NjoiX2ZsYXNoIjthOjI6e3M6Mzoib2xkIjthOjA6e31zOjM6Im5ldyI7YTowOnt9fX0=',1730303478),('JD7rbWP4QTOYalgsqkyuHxmVWKDq6qdcQMIzvqHN',NULL,'174.129.48.209','Slackbot-LinkExpanding 1.0 (+https://api.slack.com/robots)','YTozOntzOjY6Il90b2tlbiI7czo0MDoiV1ZVTGM3cmVrNFl6cnJuaFFCUkRZQ1QzR3V0aVd4bHM4VzFvVEFGUyI7czo5OiJfcHJldmlvdXMiO2E6MTp7czozOiJ1cmwiO3M6NDI6Imh0dHBzOi8vbm9jdHVhbWVkaWEubGlua3MtbWFuYWdlci54Z2F0ZS5pbyI7fXM6NjoiX2ZsYXNoIjthOjI6e3M6Mzoib2xkIjthOjA6e31zOjM6Im5ldyI7YTowOnt9fX0=',1730304387),('Jo0lYEos2GjoPqBUlGNd9dTqVpgqvDuy8fSM92fy',1,'109.104.32.2','Mozilla/5.0 (Macintosh; Intel Mac OS X 10_15_7) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/128.0.0.0 Safari/537.36','YTo0OntzOjY6Il90b2tlbiI7czo0MDoiT3dFY3Y5UTNHS1BXaHRjRzRMbHNKb2lZWmJ3eGdONTN3QmlwS004byI7czo5OiJfcHJldmlvdXMiO2E6MTp7czozOiJ1cmwiO3M6NTg6Imh0dHBzOi8vbm9jdHVhbWVkaWEubGlua3MtbWFuYWdlci54Z2F0ZS5pby9hZmZpbGlhdGUtbGlua3MiO31zOjY6Il9mbGFzaCI7YToyOntzOjM6Im9sZCI7YTowOnt9czozOiJuZXciO2E6MDp7fX1zOjUwOiJsb2dpbl93ZWJfNTliYTM2YWRkYzJiMmY5NDAxNTgwZjAxNGM3ZjU4ZWE0ZTMwOTg5ZCI7aToxO30=',1730304583),('MhfLgDuctGfjasHJ82Qe2TFIiG2hKZo0q3JQajal',NULL,'3.239.191.40','Slackbot-LinkExpanding 1.0 (+https://api.slack.com/robots)','YTozOntzOjY6Il90b2tlbiI7czo0MDoiV2c1WUVrcmw3Smw1WDZ3MmNXUUR4ZGtDZEI2QmVzUFBkdUp4aVNjTCI7czo5OiJfcHJldmlvdXMiO2E6MTp7czozOiJ1cmwiO3M6NDI6Imh0dHBzOi8vbm9jdHVhbWVkaWEubGlua3MtbWFuYWdlci54Z2F0ZS5pbyI7fXM6NjoiX2ZsYXNoIjthOjI6e3M6Mzoib2xkIjthOjA6e31zOjM6Im5ldyI7YTowOnt9fX0=',1730303478),('Q8dRXNzEyBMePZyts4QU5d0SSYqGPjVZFKehqZts',NULL,'34.235.115.52','Slackbot-LinkExpanding 1.0 (+https://api.slack.com/robots)','YTozOntzOjY6Il90b2tlbiI7czo0MDoibEJhSEV2TEswSzk0elpXdjBPRFVnaHphVDV0SkhWcGZ4U1oyY040WiI7czo5OiJfcHJldmlvdXMiO2E6MTp7czozOiJ1cmwiO3M6NDI6Imh0dHBzOi8vbm9jdHVhbWVkaWEubGlua3MtbWFuYWdlci54Z2F0ZS5pbyI7fXM6NjoiX2ZsYXNoIjthOjI6e3M6Mzoib2xkIjthOjA6e31zOjM6Im5ldyI7YTowOnt9fX0=',1730304386);


