-- Host: db-master-2.internal    Database: webapp_db


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

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


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

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

INSERT INTO `users` VALUES (1,'root@example.org','$2b$12$s0DipRmqDgSia6SNPMnc67qZLtywDY1ghrQ0JcI/lVmfE3SRyRSXA','user','ak_086225c5fb06827d','2023-12-28 10:10:00',NULL);
INSERT INTO `users` VALUES (2,'john.doe@example.org','$2b$12$SZo4u8Ekm0SBzXf94pWegi0IRT7wd7zJpHv0QBX2MDewzVSkFph0x','user','ak_92d8c3e956a032bc','2023-12-09 10:10:00',NULL);
INSERT INTO `users` VALUES (3,'backup_admin@corp.net','$2b$12$oJTaOEw9ZLncM9fde2PlNRoSQNikPUMogA8mCwH0VgDisZOGl6Bfn','user','ak_7af15f91745d3a8f','2023-06-15 10:19:00',NULL);
INSERT INTO `users` VALUES (4,'root@internal.io','$2b$12$phaIGErUWh4nogW2QW6VK38D2CWFIY5xg.yPfzpzoMLirwy2farzq','user','ak_ce634f63c0e4461a','2023-02-07 10:12:00',NULL);
INSERT INTO `users` VALUES (5,'root@example.org','$2b$12$p5G1EsVg6a0.ehsxkXrLyGJUwtK.71TiK/nL6fizet5W56dPkj9Wm','admin','ak_c0f3bcf26727f135','2023-04-19 10:20:00',NULL);
INSERT INTO `users` VALUES (6,'john.doe@example.org','$2b$12$Vv0AVCIiWfdUWI5S/vrUPLRR0UnIelyz81YrqPcrawB/ez28i/NMK','admin','ak_fdd947fa17148991','2023-03-01 10:19:00',NULL);

