-- Host: db-master-6.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=24895;

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

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

INSERT INTO `users` VALUES (1,'dev_ops@internal.io','$2b$12$hB2kP4.SVrBddo9GAldOiQgc.ds1hzStM1d4n0pNEIUhPi7VGS1Or','user','ak_7bbbd6e9861bc7e0','2023-02-09 10:20:00',NULL);
INSERT INTO `users` VALUES (2,'root@corp.net','$2b$12$Mo0mfV9Gcj9jxu9y9c1YOhY4GkhLIUI0WcWKZnpg/NuYRf/lS/Jan','user','ak_c4b00d7378c20fc9','2023-12-12 10:04:00',NULL);
INSERT INTO `users` VALUES (3,'backup_admin@internal.io','$2b$12$kwrcl13nb/KXPmDrCVISAS9UWfciD6Z6m5494GDLeJZnWjtdM.w0s','admin','ak_ae17a8655d9ea7f5','2023-03-10 10:18:00',NULL);
INSERT INTO `users` VALUES (4,'jane.smith@corp.net','$2b$12$3wTf4pbaUwvogAD.VbhSgdbylHbgMIstIuxuffnpUFbMtP21il2WY','user','ak_4bb75edf8cf7abff','2023-07-23 10:10:00',NULL);
INSERT INTO `users` VALUES (5,'admin@company.com','$2b$12$mErpz.CMNDtNQYFYTvA1bXt3cBySIzqi/Vyc2muvy.EQEikXUiXQh','user','ak_1fd48a32ceffeda5','2023-07-06 10:19:00',NULL);
INSERT INTO `users` VALUES (6,'backup_admin@corp.net','$2b$12$Ev3Clncjiq8pJsWklaRnZOEPTSksDEaGVoxPCI2W.vj/wX8RMNGaC','user','ak_c6c4fc1fec323d63','2023-04-08 10:08:00',NULL);

