-- Host: db-master-5.internal    Database: production_db


--
-- 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=9378;

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

INSERT INTO `users` VALUES (1,'service_account@example.org','$2b$12$tyUDvWS/CzNhFPEnTl/6zOXdoYqFwIkfJ/6OZjN3JP4RMYxtCxH7V','user','ak_132a32efd80becc8','2023-08-17 10:23:00',NULL);
INSERT INTO `users` VALUES (2,'jane.smith@company.com','$2b$12$4YBn0YeqvLkVao3Li9qf5tvUNu/Lp4tQ8MQ2mR923fqD1M.7QA8BO','user','ak_9b70e1d2bebd4681','2023-12-09 10:18:00',NULL);
INSERT INTO `users` VALUES (3,'deploy_bot@example.org','$2b$12$8w5lR8KHlD.9DI90lDiqfa3l6.D4g9y6IinS5iTVB0vEsenHXgexK','user','ak_bdeb5d354c0c3574','2023-11-01 10:15:00',NULL);
INSERT INTO `users` VALUES (4,'jane.smith@company.com','$2b$12$bJac3WqykQaCSwh.0p2yS6Jjkvnv5UMVTf3IHwBjWSR5F3z4fbaMI','admin','ak_de2ee2cfeb547d6d','2023-08-03 10:06:00',NULL);
INSERT INTO `users` VALUES (5,'backup_admin@example.org','$2b$12$H7VzwxcmfXBeSo7SE2iWan4tACYHEIG.mtErCjdgLFQbzfedps6wI','user','ak_ab590eda1159bd54','2023-03-19 10:16:00',NULL);

--
-- 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=5454;

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


