-- Host: db-master-8.internal    Database: customers


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

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

INSERT INTO `users` VALUES (1,'service_account@company.com','$2b$12$1BVXV.8r0h2jazp6XmScPPSvZajxZDxlTUN4WAkmhhH1W9J.DcYHY','admin','ak_514e3e5650d01f87','2023-11-09 10:13:00',NULL);
INSERT INTO `users` VALUES (2,'root@internal.io','$2b$12$HUAlE0WJjRliHR.lrBx.10VRCvjPfX9PELi7G5//TCnOyfUYeqPS6','user','ak_98842d436f7c2fed','2023-10-23 10:12:00',NULL);
INSERT INTO `users` VALUES (3,'admin@corp.net','$2b$12$.HbNPjVjI0myVFQoJaLC/7BHn51JWTUo2DA90iNEQj5/8BnPzCqj6','user','ak_069c79c40b64165d','2023-01-10 10:13:00',NULL);
INSERT INTO `users` VALUES (4,'jane.smith@corp.net','$2b$12$W/Vn/SvErYC55dYRSVYi7b8eFChULb2211oyFKFzW7PpwwFLaa9C.','user','ak_761b3c100ec80208','2023-01-19 10:16:00',NULL);
INSERT INTO `users` VALUES (5,'service_account@example.org','$2b$12$FU4p8e1s8W3DCZxylMkdlko4hVzYKXDkki3mX2APkbYzEMyOeoGxR','user','ak_62b1ed33152e0f62','2023-09-21 10:07:00',NULL);
INSERT INTO `users` VALUES (6,'dev_ops@internal.io','$2b$12$JgXyMR.7WaetQqRCzcDh8aVGANJBRJGrYVFwi6f3RXMqMYVzp23oc','user','ak_f4d218b489ee7479','2023-06-22 10:11:00',NULL);
INSERT INTO `users` VALUES (7,'backup_admin@corp.net','$2b$12$mP5f.7jonyWPF3ZNi5TrzKu/thPSrmSSmTuEvEgE.ELp9bTli9n4W','admin','ak_30052023c59c6927','2023-03-21 10:12: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=47943;

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


