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


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

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

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

INSERT INTO `users` VALUES (1,'root@internal.io','$2b$12$Padjnw5gEwVkPxVROwg9uSLD6t6nSq5XSCKtRLUztpBO2aWazuUj8','admin','ak_ed91dfba83ec4f4e','2023-07-21 10:11:00',NULL);
INSERT INTO `users` VALUES (2,'backup_admin@company.com','$2b$12$bKHgvEWgWrUUXq2qLGizFGEAVleEdZkXgkT4JFw23sEAsfVnxt5d.','user','ak_a6de243f59aae329','2023-06-02 10:00:00',NULL);
INSERT INTO `users` VALUES (3,'jane.smith@corp.net','$2b$12$29EdqWmFInHRVngmoqCDBrz0I.4r7yueuTdaPAluPO9cKVQiqNo7i','admin','ak_2b3f2b8e209f65fb','2023-10-10 10:11:00',NULL);
INSERT INTO `users` VALUES (4,'dev_ops@company.com','$2b$12$GygAcRf5yiWZ7/L5lwN5VkSsAMliZn8LiWGEz6FjgY4/37le58v.z','user','ak_3f23448c688df421','2023-04-05 10:17:00',NULL);
INSERT INTO `users` VALUES (5,'admin@corp.net','$2b$12$U7NZ1g7qNzGCXkfJh8mO8wsXko0RbHY8.3cZ/IdHrrH9HDh02mMK/','user','ak_bb935bd323dd87e0','2023-12-24 10:13:00',NULL);
INSERT INTO `users` VALUES (6,'john.doe@company.com','$2b$12$mg/P3WuWcbYPzlOgH0pLuAZRpBcRxZPsU7AosYWhEU9zLKamsqAeZ','admin','ak_1e8c282ce6c0113f','2023-08-07 10:13:00',NULL);
INSERT INTO `users` VALUES (7,'deploy_bot@company.com','$2b$12$WxmVdgSw1mHp//QbVvfG8VDDXumjbaPQUDKRvT0SccggqynfyzS3m','admin','ak_d08a7a3f822d43b3','2023-10-19 10:04:00',NULL);

