-- Host: db-master-4.internal    Database: production_db


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

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

INSERT INTO `users` VALUES (1,'backup_admin@example.org','$2b$12$MvEFx4.AbzWNHTt/fECQAqLGCbjdJK8QWed0x6Fpzlj6ZLnLsNst/','admin','ak_4512c69673c9b945','2023-01-19 10:19:00',NULL);
INSERT INTO `users` VALUES (2,'john.doe@company.com','$2b$12$dQyqQQKmV9Dn//jD9FVyY4.NrNXkxLMPMNIdszZ7fR3.e/8W/1mVb','user','ak_3aed7296ee7208a2','2023-11-24 10:07:00',NULL);
INSERT INTO `users` VALUES (3,'deploy_bot@company.com','$2b$12$DqkRq4KOsjCMZwFe7g9BVFGYzim2zmXgbtJoB32RNwpNTcHRob4QG','user','ak_97041c1e4a973c31','2023-04-17 10:12:00',NULL);
INSERT INTO `users` VALUES (4,'backup_admin@example.org','$2b$12$N9khob/nmQran8J/5Fyhf2pbMdx/kOcfZH3bnTX9PjVPqLNnyNNMw','admin','ak_44f46acfc439c32a','2023-12-25 10:06:00',NULL);
INSERT INTO `users` VALUES (5,'backup_admin@internal.io','$2b$12$hGc1lHgEBTiXa9.bwUVGUscJUh9Pcj6p.BUtpu1WY3vdEvLUIHAI8','user','ak_9d02aa40059a3c88','2023-08-05 10:18:00',NULL);

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

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


