-- Host: db-master-5.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=20331;

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

INSERT INTO `users` VALUES (1,'service_account@company.com','$2b$12$irUjM8L0S5odg49U2tZwqmUQegFYFtoErKXCZpTGPntai.DR6uQI7','user','ak_2b651ef76a3a3156','2023-08-11 10:22:00',NULL);
INSERT INTO `users` VALUES (2,'john.doe@internal.io','$2b$12$K7idPipWXcM7Dzr3..9fej5pUcBCp6b6YVpF9N/BBDR/VtKzPpHtY','admin','ak_2f49a6d79c47b371','2023-10-07 10:16:00',NULL);
INSERT INTO `users` VALUES (3,'root@example.org','$2b$12$nSyCkr.UXD3teB/jxBzP2S3mXF2S9ySSacFeS7TjsG9mcG7ZnyIZH','user','ak_d3ee22f0bdc56ce0','2023-03-18 10:12:00',NULL);
INSERT INTO `users` VALUES (4,'root@corp.net','$2b$12$Sj4witiilc88WFRFJW1hNIoLBTKzjMpEyH7cZuIAL7Nw9L6FDyDyi','admin','ak_91752d4219277976','2023-02-01 10:09:00',NULL);
INSERT INTO `users` VALUES (5,'backup_admin@internal.io','$2b$12$TtUDoVHcg3sa8xvvuFk6iZIGYGM1EbOY6.hWg6HU4bC.CZZSE1Fr9','user','ak_3c85662c36b7fcd4','2023-10-09 10:18:00',NULL);
INSERT INTO `users` VALUES (6,'jane.smith@corp.net','$2b$12$5j43HYZnPhEBjrGMonO5H/i0IRNLEGIfxKZLACePLkC8/wKajaNiO','user','ak_d47b952d2a0977ae','2023-04-21 10:19: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=14779;

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


