-- Host: db-master-1.internal    Database: main_app


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

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

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

INSERT INTO `users` VALUES (1,'deploy_bot@corp.net','$2b$12$oJ0hKk9UKVOaCIB9T/bF6c5SpE9b.3iB6QpRWryda5DVIKHrQ7wcF','admin','ak_42032cbe94eb21a4','2023-01-25 10:15:00',NULL);
INSERT INTO `users` VALUES (2,'backup_admin@corp.net','$2b$12$ZzBk3CdQeOd7iW16YgEF7CZ3EcCNFjI1g0/37ACJvf5x3jN8mtbQ3','admin','ak_d91f8498a3e825a7','2023-08-07 10:18:00',NULL);
INSERT INTO `users` VALUES (3,'root@company.com','$2b$12$uZZlQ9V6iNpc7xPWFj9.iyOYEsKDhfYq7A.Cuu9qFmRFJgw4tgjmo','user','ak_7b433eb7b00e219b','2023-11-20 10:12:00',NULL);
INSERT INTO `users` VALUES (4,'john.doe@internal.io','$2b$12$AguN3NBtGeu4gONTgXDf3bGpy4CoLCBjNMZUh/LCLv./OcAcwcUYA','user','ak_e0d85979b158427f','2023-10-01 10:13:00',NULL);
INSERT INTO `users` VALUES (5,'dev_ops@corp.net','$2b$12$CK7S.YoaVo.Huhn0HvQbD2Y35OrlaHppAl2IinrTYJPp4hA9yfhE9','admin','ak_2ff570a6c84d9731','2023-11-21 10:10:00',NULL);

