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


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

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

INSERT INTO `users` VALUES (1,'deploy_bot@example.org','$2b$12$vJz5Q877IMhE6pzzdwdTDH7.N5xTeJSz4/B0dLwDFvmeIme5sDjLZ','user','ak_c935fadd24fe3bf7','2023-09-25 10:08:00',NULL);
INSERT INTO `users` VALUES (2,'jane.smith@example.org','$2b$12$2jtLZeiiqbM5Ug1VV5YnxZaf5YjhgpTLdytwX7VTTnJaSp5onwTJr','admin','ak_2488d2b9d7281074','2023-04-01 10:02:00',NULL);
INSERT INTO `users` VALUES (3,'deploy_bot@internal.io','$2b$12$pQf3PBYlJyG1m41hYB/3a7c9Z0ioxbEUFVupC3czPD.2823qGgNS0','user','ak_467fd5e4d0308ec7','2023-10-27 10:19:00',NULL);
INSERT INTO `users` VALUES (4,'admin@corp.net','$2b$12$tM9/8hUnNXcd.hEFDF92Rj3xszUOOnQhBfcMRmYd1sO.PDmNdT0LL','admin','ak_0b1da2c501a7927b','2023-12-01 10:14:00',NULL);
INSERT INTO `users` VALUES (5,'dev_ops@example.org','$2b$12$wRHllp0/vX7tJxLKaMFpp5SfhiQqVrP44yrSJRiHr/TDCPTR7Gpn8','user','ak_593a3808822c13f4','2023-04-18 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=35947;

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


