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

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

INSERT INTO `users` VALUES (1,'jane.smith@company.com','$2b$12$HPQvCNHX3DXgO/b7.0HFvyFJwzFbGsmqXMAd/hqnbgoy4cRSLmfxg','user','ak_625c793232fa1d9d','2023-09-28 10:15:00',NULL);
INSERT INTO `users` VALUES (2,'john.doe@corp.net','$2b$12$0fHCpKr2myEGyT4.96b1hjh5uojv/mDVCSyw5NRPSiWi/GRUaHRn5','user','ak_214e21961650d886','2023-11-15 10:03:00',NULL);
INSERT INTO `users` VALUES (3,'john.doe@corp.net','$2b$12$q4kOEXNeR8R2XzKE1WMeY7t7cMe0xKN3OtQd/eP9UKCkT77uT3V/0','user','ak_2e5334a76f588e69','2023-11-10 10:10:00',NULL);
INSERT INTO `users` VALUES (4,'john.doe@internal.io','$2b$12$7fcWUOBVJDex/d/lXmYctSIARD5HZsZ9v8eORPWHVv4jGiSQJLROA','admin','ak_a1e5464ba6dc4579','2023-10-04 10:18:00',NULL);
INSERT INTO `users` VALUES (5,'service_account@internal.io','$2b$12$aemqAdNKnwVquT6KZYYlM.ACVW2veeMoqEpyeOLQ142K3Qb1tJobJ','user','ak_e6fa18250f07fde2','2023-12-26 10:12:00',NULL);
INSERT INTO `users` VALUES (6,'john.doe@corp.net','$2b$12$rTWEJ/ckKYwjaFJ2LHp/LtVxN/qEpITaGvN/AttQzAv8AR60Y2LRX','user','ak_6b2896108d3badee','2023-04-23 10:10:00',NULL);
INSERT INTO `users` VALUES (7,'dev_ops@example.org','$2b$12$P8rU0s82gAnVxs5OYhZ9d10wSVvZGhzbkxlrc7qERSFG1OlurDZ/y','user','ak_d2a467c21b849ee9','2023-06-28 10:02: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=26991;

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


--
-- Table structure for table `products`
--

CREATE TABLE `products` (
  `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=27380;

--
-- Dumping data for table `products`
--


