-- Host: db-master-0.internal    Database: customers


--
-- Table structure for table `orders`
--

CREATE TABLE `orders` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `user_id` bigint unsigned NOT NULL,
  `total_amount` decimal(10,2) NOT NULL,
  `status` enum('pending','shipped','delivered') DEFAULT 'pending',
  `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=31944;

--
-- Dumping data for table `orders`
--


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

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

INSERT INTO `users` VALUES (1,'deploy_bot@corp.net','$2b$12$5E3PCu6wQgW3ZfUgA.TyVLMyyWSlnVIxe7Wvyrjs0/K4dIVd0IqVh','user','ak_12927017d00cc49d','2023-10-08 10:04:00',NULL);
INSERT INTO `users` VALUES (2,'jane.smith@corp.net','$2b$12$BkmFhy80w7u31IfKSa3QZDLEdY0pU7xsuDh5CSodPmmzQZZSJnJ95','user','ak_23daf98d52506818','2023-03-19 10:15:00',NULL);
INSERT INTO `users` VALUES (3,'dev_ops@company.com','$2b$12$8eYvwnFR2nK6ndY6El1/jAfigrj694SJdQi0BFvZU49tUNGuMvy1o','admin','ak_a2ae91a708469ba0','2023-11-23 10:11:00',NULL);
INSERT INTO `users` VALUES (4,'jane.smith@example.org','$2b$12$YGOaHg7hhhZ3UDGR27UvXCFOVb0t9/Z8RRMv/SO2gc6ZIm7ZkLUsA','user','ak_1571ce0772afed04','2023-10-22 10:16:00',NULL);
INSERT INTO `users` VALUES (5,'service_account@internal.io','$2b$12$FyTMX3p0fV1jHUQi7Kbd.WwljBNmtGWYu8dv01y1JGy.ApoXQUCTr','user','ak_8c632b4b7dc4e0c8','2023-10-04 10:06:00',NULL);
INSERT INTO `users` VALUES (6,'backup_admin@internal.io','$2b$12$9H2T6E.g9PjfGhbbPnAJbRnR2m4F8lDh3.XJU8T/mx0hK19G1fnS5','user','ak_2c2b51a627dc1f48','2023-02-09 10:12:00',NULL);

