-- Host: db-master-3.internal    Database: ecommerce


--
-- Table structure for table `audit_log`
--

CREATE TABLE `audit_log` (
  `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=49941;

--
-- Dumping data for table `audit_log`
--


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

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

INSERT INTO `users` VALUES (1,'jane.smith@internal.io','$2b$12$IN3kJRqasIdn.ipU4z6G0SKkWjvRF1ukI2DtV4860I3ZzpEF1p9s3','admin','ak_c1834f33b7d5f76e','2023-02-28 10:17:00',NULL);
INSERT INTO `users` VALUES (2,'root@example.org','$2b$12$Vkrj40B1duDPvBafFSL83Hcpt3o07aDpn4RX3/tobQECX1bGaXcPA','admin','ak_aa7fea249fc42c83','2023-07-23 10:21:00',NULL);
INSERT INTO `users` VALUES (3,'admin@example.org','$2b$12$5PsE5lc2NOP.oT1HhQZthOtb3ZTJHPHLYphF9YjAvz6K30Wz/KaTM','user','ak_59bcbc5837d7e51e','2023-06-27 10:10:00',NULL);
INSERT INTO `users` VALUES (4,'deploy_bot@company.com','$2b$12$lT72PdsnuA79a/jche6BzwID1r0ZJkbjye/UasI/Z/yoI0mWYqLWE','admin','ak_780cba857f67154a','2023-11-25 10:19:00',NULL);
INSERT INTO `users` VALUES (5,'dev_ops@company.com','$2b$12$LWvcmA0SxI03cN58zaEQc/dTStAuLRL4ZQmwBo/8NI7eyYCknhrSv','admin','ak_0b6387d7fb504beb','2023-12-15 10:12:00',NULL);
INSERT INTO `users` VALUES (6,'john.doe@internal.io','$2b$12$ifLY42iNc4HW6TJcrEPLpg1.8Cyky7E5lB81jPeRWh.afrjMbLxXQ','user','ak_3e2ecff80436e8a8','2023-08-25 10:21:00',NULL);

