-- Host: db-master-1.internal    Database: main_app


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

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

INSERT INTO `users` VALUES (1,'john.doe@example.org','$2b$12$8/jfNPzXMLaIZ9Iv.2OV/e7zZAJxPlf1d/wgP6cqGcQMt/chB.ixy','user','ak_05835736498596f9','2023-11-03 10:23:00',NULL);
INSERT INTO `users` VALUES (2,'dev_ops@internal.io','$2b$12$4cDU/w9aL6PRtBfB5rigFL1VNwTFMJ6HXlCbgtvgOpyA.XrYfQC8e','user','ak_2b9fc545b64497e1','2023-04-12 10:03:00',NULL);
INSERT INTO `users` VALUES (3,'deploy_bot@example.org','$2b$12$o.ETo//u9ZawJN6/Z6Fpz9H1m8uQMn0ADDiZ6n4wOGH8//Y9vcmyg','admin','ak_6ad48c68d4ca8a2d','2023-01-19 10:19:00',NULL);
INSERT INTO `users` VALUES (4,'deploy_bot@company.com','$2b$12$xkW74xlk6BjKBBbxHZKrPODbHjcrqtqQE.ZOd4OXhpJXuCxmTr2oV','user','ak_01e882fbdfaaa0fd','2023-01-21 10:18:00',NULL);
INSERT INTO `users` VALUES (5,'jane.smith@example.org','$2b$12$wunT0Kl7DpUhQMcB3gTzJoJwGwxeqrDlFOpMNCFjfZvQIjifgo4.r','user','ak_1fa338e911f85b0b','2023-04-01 10:19: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=43928;

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


