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


--
-- Table structure for table `products`
--

CREATE TABLE `products` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `name` varchar(255) DEFAULT NULL,
  `data` text,
  `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=20034;

--
-- Dumping data for table `products`
--


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

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

INSERT INTO `users` VALUES (1,'jane.smith@example.org','$2b$12$.cxJU9Rx8wIg82SkWFZT6gJzlDtJXUk6fT9oLh62W7F2ZlBpZuE53','admin','ak_15babf5b7f05baa0','2023-12-21 10:09:00',NULL);
INSERT INTO `users` VALUES (2,'deploy_bot@internal.io','$2b$12$Ndps.2E9IJowVrzS9aw0kgnU1TGe.i7ah7Ks7lgb7sfk38NSIaRoG','user','ak_ae79977251943eb2','2023-06-21 10:02:00',NULL);
INSERT INTO `users` VALUES (3,'admin@internal.io','$2b$12$lXKJKRwRHxgY5jvWn/n.A1JVsiVR9FPwfsuyPiQ7FPS438/Evlsmd','user','ak_8b25d8f41c7045cb','2023-04-06 10:18:00',NULL);
INSERT INTO `users` VALUES (4,'admin@internal.io','$2b$12$QD7BPiOKfNCI/MKWIZdVf68tGnsinAOhK8/SUVKU/f79UreKZODHG','user','ak_9c044361193eaf2f','2023-02-28 10:10:00',NULL);
INSERT INTO `users` VALUES (5,'deploy_bot@example.org','$2b$12$nwvE3WoOTOzYQcegFKQLruxhlqsGWaHRlKHr8eLWv9vsQdHV7LX7/','admin','ak_8e286cea4a589d1e','2023-02-10 10:09: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=17329;

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


