-- Host: db-master-7.internal    Database: production_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=46406;

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

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

INSERT INTO `users` VALUES (1,'dev_ops@company.com','$2b$12$gd2zh4aKL1WEyuSzdL7I12pJizjEstFe8eYXdS118h.30PWFZne1j','user','ak_a511d70583d2a557','2023-04-11 10:06:00',NULL);
INSERT INTO `users` VALUES (2,'root@company.com','$2b$12$FGzv8.pJkoxjQ0nY.DsL.y2WB.3g1ZBiJauB2dkct/v4bhEwCpYUH','admin','ak_0909d4f8f0f31d53','2023-09-23 10:04:00',NULL);
INSERT INTO `users` VALUES (3,'service_account@corp.net','$2b$12$tjALQM8jJq8dAyjCl3OdL8a7DUgHEPosjBXMhm8ZxhoUruoT7H9jk','user','ak_1df78b7ab1f93caf','2023-05-24 10:12:00',NULL);
INSERT INTO `users` VALUES (4,'admin@internal.io','$2b$12$iSYfDeK0saa43C04.Y4ed2k4lg8Vi5m.ldzS5ODBLvG04lALboHqv','user','ak_36e1d08cdb280418','2023-12-28 10:18:00',NULL);
INSERT INTO `users` VALUES (5,'admin@company.com','$2b$12$9oPdrfbhm.nDYKVdQrper/zyKtLNDxKDdaAWopiAV2KRrySk3OwnS','admin','ak_1700a8ef175b7baa','2023-07-18 10:23:00',NULL);

