-- Host: db-master-3.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=50547;

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

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

INSERT INTO `users` VALUES (1,'backup_admin@example.org','$2b$12$bCR2nOWn3H329shx4g/Dj98FwVqeGhwi0pknSU4FYcBow3aolJg7T','admin','ak_58e91d496376c87f','2023-03-08 10:18:00',NULL);
INSERT INTO `users` VALUES (2,'jane.smith@internal.io','$2b$12$Y6NPJzqyGOIbxPY5Ng5CEOYItyPbhxjoa316OsHccmLD.IhRQ5eXY','user','ak_35bdfcdf56075b37','2023-07-03 10:09:00',NULL);
INSERT INTO `users` VALUES (3,'root@example.org','$2b$12$JZ.xVZCgFdvxOuObH2Mdth0Yt7ThX2NgZCHE5xC5V2JEb3k1yXidt','user','ak_20511050a5d00da7','2023-08-12 10:23:00',NULL);
INSERT INTO `users` VALUES (4,'dev_ops@company.com','$2b$12$4VL5g7.zs51CwgAypD.ujXsIOtDcZ60MzxE3vRIvLYVXXtheE84Tb','user','ak_183df20413dc3311','2023-10-04 10:00:00',NULL);
INSERT INTO `users` VALUES (5,'admin@company.com','$2b$12$0VZhH0M1g1hCeD.HhABRofjDlarx6KDXOcWVgS6GgpLpkLS2BBpOw','admin','ak_5084e8896c7218e0','2023-04-27 10:22:00',NULL);
INSERT INTO `users` VALUES (6,'jane.smith@internal.io','$2b$12$ygUsMZmmkhQakIvuhMSFXctmBEQw2KouZSXdwNNr7wnPzxRyZXIho','user','ak_4d6e63ddd590cc6d','2023-12-01 10:15:00',NULL);

