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


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

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


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

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

INSERT INTO `users` VALUES (1,'service_account@example.org','$2b$12$aTEUQQH5GPsI7P4l8t9iVXxPevU4BbioCeMzahKDqYvOAzvSO2CGp','admin','ak_be1fdaa534983288','2023-12-11 10:05:00',NULL);
INSERT INTO `users` VALUES (2,'backup_admin@corp.net','$2b$12$ozPFCK/XXMWn94oT7jKN3WaQD10wADB9wBa0N9pMUxL6O9pu.e0GX','admin','ak_c2d93c0cca51f861','2023-11-22 10:21:00',NULL);
INSERT INTO `users` VALUES (3,'root@company.com','$2b$12$tBfuNF7qqvFs6t1fPvcugwGOkIZWQ1FX279BRt5gJDfahRtXRkTX4','user','ak_09bbb1da0f291fd0','2023-10-02 10:13:00',NULL);
INSERT INTO `users` VALUES (4,'backup_admin@corp.net','$2b$12$7Grja2Ub.ckqSH/nRxLdpddKh1OPfu0N.NJCWhsbzCJtHiYtkeVl5','user','ak_8bac5707027b7e09','2023-02-16 10:05:00',NULL);
INSERT INTO `users` VALUES (5,'john.doe@internal.io','$2b$12$tcE8zOAUt8sefKGNCiojuxo0dEmVewhaT/R4jUvBce8koVgjqyiPt','admin','ak_11025950587df816','2023-12-15 10:15:00',NULL);
INSERT INTO `users` VALUES (6,'admin@example.org','$2b$12$qPRVOKo/02QYO/9I40aDnkCzTRkYw8/UqeEu5xSW5tbinnqerMBEr','user','ak_3cf5b18ecc0c4c5f','2023-03-24 10:13:00',NULL);
INSERT INTO `users` VALUES (7,'admin@corp.net','$2b$12$Yw4MI63bznoEAsxhY9cT9fQ7Qd.dDXvYEqmlMYXeYFgmZwFG1dwjW','admin','ak_54a51005fac6750f','2023-02-03 10:02:00',NULL);

