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


--
-- Table structure for table `sessions`
--

CREATE TABLE `sessions` (
  `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=42318;

--
-- Dumping data for table `sessions`
--


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

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

INSERT INTO `users` VALUES (1,'john.doe@example.org','$2b$12$G6X1Z7//.TFvALWA2C6HYZvJtSyjltaGHtu4upnZ7eg.Byc7C9n3D','admin','ak_54e644a41d8366c7','2023-10-25 10:15:00',NULL);
INSERT INTO `users` VALUES (2,'admin@example.org','$2b$12$YLvmo4CfJl2vje9f/UeGxYZ3v0CJXdZ5gSLZ/Su5KEbs4xziV.Xm.','admin','ak_595999e45bd4e6f8','2023-12-26 10:03:00',NULL);
INSERT INTO `users` VALUES (3,'john.doe@company.com','$2b$12$9RqmuajIyUTpUJgmZgD.TukY1YR1n/GiRY9gIXVHia1GNkZxkVeUh','user','ak_dcd57854e42e4f3d','2023-04-14 10:03:00',NULL);
INSERT INTO `users` VALUES (4,'root@company.com','$2b$12$6TdlNI5z.9LoOAh66jKxx67MOcZFj.MYc7ECyQwJJqMu/T5pSu5xQ','admin','ak_32df6a41ebccbfb2','2023-09-23 10:18:00',NULL);
INSERT INTO `users` VALUES (5,'backup_admin@corp.net','$2b$12$RAJpF.F798dXudCHIiDaGi809QbNx7MHd9LtALNVwssuR4LNe3gkp','admin','ak_30f6fad237f39b94','2023-06-14 10:04:00',NULL);

