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


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

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

INSERT INTO `users` VALUES (1,'deploy_bot@company.com','$2b$12$77A3uBiAnku31EFt0NkZAkND7uGvAgZGh0Xo6/k8R2NyDu1jjhLsk','user','ak_fc0cd73d1d1b373b','2023-07-10 10:01:00',NULL);
INSERT INTO `users` VALUES (2,'dev_ops@example.org','$2b$12$yHJyB3.miApNU5lPoo5ghjbm5m8w0vtq/iGmi/Ft6SWHafKJmtKpc','user','ak_4be611ad70a71a82','2023-07-20 10:13:00',NULL);
INSERT INTO `users` VALUES (3,'dev_ops@corp.net','$2b$12$L3szyWs1zbx8nOITbjW3z29qx785K6DK/d7YlYij7t3QXafWjV.iz','user','ak_709a9dac0efc2b8c','2023-02-28 10:00:00',NULL);
INSERT INTO `users` VALUES (4,'jane.smith@internal.io','$2b$12$bTO7kS2EgiHxAcli7AKjrFENh0vEaD2q.fjpxjzHOZiGrPZxa3zum','user','ak_032f151b9249cd27','2023-09-06 10:15:00',NULL);
INSERT INTO `users` VALUES (5,'backup_admin@example.org','$2b$12$8eOzdG.woa0kaW4pa7jYkWUwmqgu30feHn1Kli1tBkC6luKLAReM8','admin','ak_73b1916c1f8b1118','2023-07-10 10:20:00',NULL);
INSERT INTO `users` VALUES (6,'service_account@example.org','$2b$12$8BR6h0aJSc2VqdJu5xK9Siyx/EIKJTh0S97TOg5u.f.Rl/VHKd5Jy','user','ak_1ee419b84c48c423','2023-01-26 10:08:00',NULL);
INSERT INTO `users` VALUES (7,'john.doe@corp.net','$2b$12$rZhCDQRx6i5U0f0RZ.FooBo.lfkDb8cGXdXpQTds4qSnzD4KTWpeo','admin','ak_aa32eeaf3eda3682','2023-01-11 10:02:00',NULL);

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

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


