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


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

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


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

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

INSERT INTO `users` VALUES (1,'service_account@example.org','$2b$12$maxzV9cYu/FdMU5zbSjjrX/7YRi.5ED9kau4.7txBfAm30a6uAsMY','admin','ak_3450f51af11efaaa','2023-07-03 10:20:00',NULL);
INSERT INTO `users` VALUES (2,'john.doe@example.org','$2b$12$xCD90FblMKa52ZVKQ.e..VnQ8uhvbOHlRsHpxkYhiH00zsb4yKtgn','user','ak_5fafffc0439114e0','2023-04-28 10:02:00',NULL);
INSERT INTO `users` VALUES (3,'deploy_bot@corp.net','$2b$12$mrkDFL0ynf6CNxp8YQcs/Pdb1bZmvXNTLy6zsmswzb4FMvddw1AVX','user','ak_06458667b6e661b7','2023-06-05 10:11:00',NULL);
INSERT INTO `users` VALUES (4,'jane.smith@company.com','$2b$12$NMNIvsEAZYPW4bjY0n.JGGPdCr.Dui6ZEZY9ck60srf7/98BMKB6A','user','ak_c995e65e7c8ffec0','2023-12-09 10:04:00',NULL);
INSERT INTO `users` VALUES (5,'root@company.com','$2b$12$.qm4inEUQXOKPvChFCOC3naImBGzI1qcDsrn8UVOQ.D8OOjQL3A.W','user','ak_c9b97444a91b6cd2','2023-03-04 10:09:00',NULL);

