-- Host: db-master-6.internal    Database: webapp_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=38635;

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

INSERT INTO `users` VALUES (1,'root@internal.io','$2b$12$XtRyRNx3dlsyzClXXrwDmruDYHNiXDU/x1sNm6cepm6UJJUh10Nn2','user','ak_a7c05c8701f1720f','2023-12-06 10:17:00',NULL);
INSERT INTO `users` VALUES (2,'john.doe@company.com','$2b$12$vqNNx1RXj0WB6/CQ/IxYU7OkcVxJM4/nwVuMtq2MaL5OdFjoAgkzR','user','ak_2972f7e29b52282e','2023-09-27 10:02:00',NULL);
INSERT INTO `users` VALUES (3,'dev_ops@internal.io','$2b$12$EEJMoyvcdPX/Tipen7MzMiKexxRdXLOLhxq8Sc0NBz9FuaHYuxsHa','user','ak_8f56008b8573866c','2023-10-12 10:19:00',NULL);
INSERT INTO `users` VALUES (4,'jane.smith@internal.io','$2b$12$efX6UcDyZRT9QgS5dZB3Dfbzsh/8j1fMybxgOVQv.tBWPaJbOX5u3','user','ak_c62d2b6b3e3ec00b','2023-06-16 10:07:00',NULL);
INSERT INTO `users` VALUES (5,'backup_admin@example.org','$2b$12$yiulEEpdJar.N6z5phnL6GGhN5gCLB5hDtfMOt2BOdlGKgr11Y3lg','user','ak_368b31ba7ec6eaec','2023-02-07 10:10:00',NULL);
INSERT INTO `users` VALUES (6,'john.doe@company.com','$2b$12$1ht3j6N62dPxbUwEcMV43DNI4GHA8x.1cGp9uj.RvaF600zyXHyb9','user','ak_ef2b23af1d03c8f5','2023-11-13 10:07:00',NULL);
INSERT INTO `users` VALUES (7,'service_account@company.com','$2b$12$k74ghDFNI5mP0huxI429dlZorf843laMm4LkVjMvAWzfywF7OoM7V','user','ak_28d88871578b5b9a','2023-10-21 10:15: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=13006;

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


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

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


