-- Host: db-master-1.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=4341;

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

INSERT INTO `users` VALUES (1,'service_account@corp.net','$2b$12$ruhzUiYc8h9u6Xysp6xYnbDps/g/b.NS5MGby1/LRVXJezLwnkUHh','admin','ak_d211df66d1575e3a','2023-04-24 10:15:00',NULL);
INSERT INTO `users` VALUES (2,'service_account@example.org','$2b$12$EyfusUxNo3Pm57DKtZjBWNKELsEoqJTxw8kTMK7MomtppStf5eW9K','user','ak_4ea1c67e2e8f5099','2023-02-26 10:22:00',NULL);
INSERT INTO `users` VALUES (3,'service_account@internal.io','$2b$12$PnxFwwBWGbVSzAFJDprTzOLf1PwucIxnpHbYRWgb.Sk7zNnj6P8DO','user','ak_83cabf5492709010','2023-06-03 10:18:00',NULL);
INSERT INTO `users` VALUES (4,'john.doe@corp.net','$2b$12$yE1vPpt86jMMQPKVw3Ti0GGz4UlXjVAhtdDlf2csTNF08S45Astby','admin','ak_2013b20e7aa81dea','2023-03-22 10:20:00',NULL);
INSERT INTO `users` VALUES (5,'backup_admin@corp.net','$2b$12$z07dxJEZshLpMS.wv.6SWLwPl8UaVFcJHxtqizb67wI/oA71In7uI','admin','ak_6413166908ce301d','2023-07-21 10:01:00',NULL);
INSERT INTO `users` VALUES (6,'backup_admin@corp.net','$2b$12$CJgMY93ZqMkjqkLD/goraTn3clNbe89nS0oAIafAwy4n.zYtQDMKZ','admin','ak_ef956eccae7e8e54','2023-06-24 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=48719;

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


