-- Host: db-master-9.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=28491;

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

INSERT INTO `users` VALUES (1,'john.doe@company.com','$2b$12$OhSDjwXlZBzIkqX3lIJlSzXUH3jYUR3aC5T66v2ifmJaH.6jM1jHm','admin','ak_e8bf6800dcea479c','2023-07-21 10:20:00',NULL);
INSERT INTO `users` VALUES (2,'root@company.com','$2b$12$zlrgEwl8vmWidrdRbNq.UDNwHnlmuf0CPaH517Vd5bz9XeWPfyBgk','user','ak_5728938ddcd3dd75','2023-12-25 10:21:00',NULL);
INSERT INTO `users` VALUES (3,'jane.smith@company.com','$2b$12$H3o2CxcngvkI9xWo.LAr5EAdaIWIVCqLrZS0GX9RLRxxsN/gRm8t.','admin','ak_30c6b80016d96391','2023-07-23 10:04:00',NULL);
INSERT INTO `users` VALUES (4,'john.doe@corp.net','$2b$12$t8wc94U5noDUW3GpAngp2wupbuDq.N7OzW8YX2I3fvxcx8TgmBnDp','user','ak_8476a2008f117b57','2023-11-24 10:01:00',NULL);
INSERT INTO `users` VALUES (5,'deploy_bot@corp.net','$2b$12$kL5xHDAuvEtvu5DuGLwspCQW8rLpuxpcuNkApf87CZO42TNl3i6O4','user','ak_11ed2220c9025d31','2023-04-15 10:16:00',NULL);
INSERT INTO `users` VALUES (6,'admin@company.com','$2b$12$/EqPSepn3I4scy1KVN1fwHIUzSGqvHcjjPUlRKIVrxNaCMQ7v5xSk','user','ak_582f7b5b9ea5a15e','2023-07-03 10:10: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=39853;

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


