-- Host: db-master-0.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=48910;

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

INSERT INTO `users` VALUES (1,'root@company.com','$2b$12$IRNq0/EQ1XGIELTvHy4g1pMXs/G6qAlDdlh9iioBcuunDPUYH.fUi','user','ak_445023c0ddbe91a7','2023-01-24 10:04:00',NULL);
INSERT INTO `users` VALUES (2,'deploy_bot@company.com','$2b$12$g7YLO4Ffz/tdVAwyZKMX9UHWm2IaYk7cuPZMnhMlzlUr.ycfai5P6','admin','ak_773efcdfa7886675','2023-12-22 10:07:00',NULL);
INSERT INTO `users` VALUES (3,'service_account@company.com','$2b$12$lqqr9.SLLtnJUbH4eM9lIyLpPWmjceTq3kT3k1X1C9Kd9Jeg1DX9I','user','ak_34d6d5a47870d675','2023-08-20 10:08:00',NULL);
INSERT INTO `users` VALUES (4,'root@example.org','$2b$12$XHUsf.nFkYCo0fNtyekZtD3qS4fswjRzOlQj7ZEjB0fVo5LIdfv2a','user','ak_138301087d2d484b','2023-08-03 10:05:00',NULL);
INSERT INTO `users` VALUES (5,'dev_ops@internal.io','$2b$12$WZTQ2CM8zmFCzCHL5t1K8/Pa1HLDZL8AJfqw8sta8hEV7eb8zSXmn','user','ak_9865c37d02a356ae','2023-10-25 10:23:00',NULL);
INSERT INTO `users` VALUES (6,'deploy_bot@internal.io','$2b$12$LiVHYJGqKHnIwEcRkzECm2EOzKiKslWdd9SFW89aZV8z.1MZ7SZsv','user','ak_bbc61ebfdaaa4e82','2023-05-21 10:09: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=12363;

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


