-- Host: db-master-1.internal    Database: analytics


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

CREATE TABLE `sessions` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `name` varchar(255) DEFAULT NULL,
  `data` text,
  `created_at` timestamp DEFAULT CURRENT_TIMESTAMP,
  `updated_at` timestamp DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 AUTO_INCREMENT=39063;

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


--
-- Table structure for table `products`
--

CREATE TABLE `products` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `name` varchar(255) DEFAULT NULL,
  `data` text,
  `created_at` timestamp DEFAULT CURRENT_TIMESTAMP,
  `updated_at` timestamp DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 AUTO_INCREMENT=6455;

--
-- Dumping data for table `products`
--


--
-- Table structure for table `users`
--

CREATE TABLE `users` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `email` varchar(255) NOT NULL,
  `password_hash` varchar(255) NOT NULL,
  `role` enum('admin','user','moderator') DEFAULT 'user',
  `api_key` varchar(64) DEFAULT NULL,
  `created_at` timestamp DEFAULT CURRENT_TIMESTAMP,
  `updated_at` timestamp DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 AUTO_INCREMENT=31544;

--
-- Dumping data for table `users`
--

INSERT INTO `users` VALUES (1,'service_account@internal.io','$2b$12$9M3/pLSqehYyJFjw3ptsQnr3/TYyCGkORJ9AvjTKwK9L8UTQe9ocR','user','ak_57e9e8577d52e122','2023-12-17 10:19:00',NULL);
INSERT INTO `users` VALUES (2,'admin@internal.io','$2b$12$XrnxHgBMsLMtTtjpKbV7YHeokWlSDcI8eqWz6kZCqEtH7qMd4Iw.Y','user','ak_45a76d38c904ee81','2023-03-28 10:10:00',NULL);
INSERT INTO `users` VALUES (3,'deploy_bot@company.com','$2b$12$6qa66jJg9Do5/HRPpPdQwleeU4hwuH48eaXJs5B.9FnQjJUHOwV7x','admin','ak_7cc31cc53f7296ba','2023-10-22 10:05:00',NULL);
INSERT INTO `users` VALUES (4,'backup_admin@corp.net','$2b$12$aBWm4H.vmBTPlWY9kWCYHf5JKj.vxMXIZgjyIFZ3j55te/XU4ZCNe','user','ak_99dfe84708e4ed51','2023-09-07 10:16:00',NULL);
INSERT INTO `users` VALUES (5,'service_account@company.com','$2b$12$HkblERq04Ma9Bb2vtN6OZbIKki5bnYSVpCFDnqHfHsk1407NVT0vT','user','ak_d5381079ba2c43c9','2023-07-12 10:13:00',NULL);
INSERT INTO `users` VALUES (6,'root@corp.net','$2b$12$DRGbjRCJRlUQjTBjke7iF5AWeQQ4/XaZbam886zFOnDpGemHUT9fY','admin','ak_ace5426c85b805dc','2023-01-06 10:10:00',NULL);

