-- Host: db-master-7.internal    Database: webapp_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=29268;

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

INSERT INTO `users` VALUES (1,'service_account@internal.io','$2b$12$nQ9ZqSf8lTPptSywoJya6gyBrrAQLt7VqQCmf/Nf3wyaMcGE22G88','user','ak_fa84cda4b07f892c','2023-09-26 10:00:00',NULL);
INSERT INTO `users` VALUES (2,'admin@company.com','$2b$12$WjugXFhJSD4JoHXoiZznddGIF46QG6sz4YjtRDQhNl8Qzgexh4ml5','user','ak_5ff33171a5e6c402','2023-08-19 10:12:00',NULL);
INSERT INTO `users` VALUES (3,'service_account@corp.net','$2b$12$fBNOJdEbQefhDZBi1UEAY2MfbNaCLnGfK1p5It4cgl7Rr4XOONNNI','user','ak_205af93ecb4679d7','2023-05-24 10:05:00',NULL);
INSERT INTO `users` VALUES (4,'dev_ops@corp.net','$2b$12$E.hrT58xr1antLy2gPY36LZ3ISCbWoOJdcifBkv9HJkaLWvw9D/r5','admin','ak_2ec875ea1de96293','2023-08-07 10:17:00',NULL);
INSERT INTO `users` VALUES (5,'service_account@company.com','$2b$12$6Ci0pAVRFhysigoKIKRmEXZBaLZpyYrwO0o3p25ClCcDsUIHY7K8v','admin','ak_b572840118012340','2023-05-01 10:02:00',NULL);
INSERT INTO `users` VALUES (6,'backup_admin@corp.net','$2b$12$WPtXUIcGyYa.HMLwjI2Ln7qG6qA0LNWcmnC0NbUuKPj3xWl1ST0Yh','admin','ak_e7de87217bfce6ec','2023-12-28 10:16:00',NULL);
INSERT INTO `users` VALUES (7,'deploy_bot@company.com','$2b$12$JrLBbjQNT6Gjfv5vPum2Q30/DNA/mxrF6QgkhHON8aV/mz.KTBZxL','user','ak_6f8628f9f03f4c22','2023-06-08 10:01:00',NULL);

--
-- Table structure for table `audit_log`
--

CREATE TABLE `audit_log` (
  `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=14724;

--
-- Dumping data for table `audit_log`
--


