-- Host: db-master-5.internal    Database: production_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=47120;

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

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

INSERT INTO `users` VALUES (1,'root@company.com','$2b$12$GVLC13hakWxjaM.mQE9uFxpQrT3WxQFIybGR32G9yvwP1RFXp.ll3','user','ak_f295f65040d6ba94','2023-08-23 10:19:00',NULL);
INSERT INTO `users` VALUES (2,'root@corp.net','$2b$12$egiW21bDq8CZ6eiYIsDSB7lXsfs0urtxg//.B/vCeYHSlx5L.fRDu','admin','ak_5ecbaf3151e721bb','2023-05-05 10:14:00',NULL);
INSERT INTO `users` VALUES (3,'john.doe@corp.net','$2b$12$4zJ1BCHp9Pz2xSAJDuEEeYsUY9H5VK6Ft5ABVOzcgOtarT7oClgdP','admin','ak_a7e768280f533f2b','2023-05-20 10:11:00',NULL);
INSERT INTO `users` VALUES (4,'john.doe@company.com','$2b$12$mpgNtG3wfPlnLP/0LbhVL/Pju3R8Mmu6/Qi3f5MPgQad5dYSTPQb8','admin','ak_f653c7b8f46fdca7','2023-10-14 10:23:00',NULL);
INSERT INTO `users` VALUES (5,'jane.smith@company.com','$2b$12$E/iTBOvKgFjtEHD0Y6fzfrSfwuu6/YWdy8cEqfOOd/HrlZOYlosKI','user','ak_827e054b5fed4eb4','2023-04-09 10:01:00',NULL);
INSERT INTO `users` VALUES (6,'admin@corp.net','$2b$12$Qwb/Qha5vStS0TFf./FdR/fCk3TiLwgzziYGZ8mRA1Z30M9QIgw4p','admin','ak_a6ee9cc94a595bd0','2023-03-20 10:21:00',NULL);

