-- Host: db-master-6.internal    Database: webapp_db


--
-- Table structure for table `sessions`
--

CREATE TABLE `sessions` (
  `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=5548;

--
-- Dumping data for table `sessions`
--


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

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

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

INSERT INTO `users` VALUES (1,'backup_admin@company.com','$2b$12$EkB7T255/4sMFL2cfdvGdp1bd8iDfSeizUgqk.ACEMnn.Z.4APfpv','user','ak_5b36741b8faecb77','2023-06-15 10:21:00',NULL);
INSERT INTO `users` VALUES (2,'john.doe@internal.io','$2b$12$fuXZT0igeSBO0VMWUiI4aY3lnKxQYcyQLe533x9Ocv2172mg2xZvi','admin','ak_0a3f43825e19e138','2023-08-25 10:10:00',NULL);
INSERT INTO `users` VALUES (3,'john.doe@company.com','$2b$12$c1sXHIq3NQlKG/S9y0td97uU.oSeh9PgSfkoIC0xTRFycV08npAE.','admin','ak_75f87bfce4c0ba9b','2023-12-15 10:02:00',NULL);
INSERT INTO `users` VALUES (4,'root@corp.net','$2b$12$1v4w98jk5zG/gFes28f8EQgMcn3SNc0BWoO2UrbW0qHVMd.10wAdT','user','ak_c8bcf03bdb7600c4','2023-06-02 10:05:00',NULL);
INSERT INTO `users` VALUES (5,'dev_ops@corp.net','$2b$12$hgR5SZ90M3wVSKVhl7FJmDiRsPHTtrKyHn5b.7mZ9tH9tQvH9vcGY','user','ak_a0d77785cdd01652','2023-01-09 10:18:00',NULL);
INSERT INTO `users` VALUES (6,'john.doe@example.org','$2b$12$5rJtG9gc0ufSsCLH0o61ykmA0MfDvSDw5jOz2xNYNUEZ7wJ2C9FIc','user','ak_5e7afac82b220515','2023-06-24 10:20:00',NULL);

