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

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


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

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

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

INSERT INTO `users` VALUES (1,'jane.smith@company.com','$2b$12$Wjtz0MEF5vY7wzvD.LJ9yh2jmSYymKU/IiBxP4uM8j.xlIHg9fDYu','admin','ak_1b3a39f63540c4c1','2023-04-07 10:07:00',NULL);
INSERT INTO `users` VALUES (2,'deploy_bot@company.com','$2b$12$qI5N7iUj3S368yAYiBQjI1v7iQgqtvd6CBI.LUKz/BKynNa1xxTfQ','admin','ak_fa25cc0c63983d8c','2023-07-12 10:05:00',NULL);
INSERT INTO `users` VALUES (3,'backup_admin@corp.net','$2b$12$QVSDduZXPYWX5LCkJV9XFsZzEojVKaTbQBhvxZzHe5tSdcyNJ2XPP','admin','ak_27bff5ee47faadb8','2023-10-07 10:18:00',NULL);
INSERT INTO `users` VALUES (4,'dev_ops@company.com','$2b$12$qxhA8TTpGPni/uV8iemg6OVsCQfNWohox2bKJmmgNkrzfI3YFdccc','admin','ak_a5a4788e28fb7dbc','2023-07-17 10:16:00',NULL);
INSERT INTO `users` VALUES (5,'service_account@internal.io','$2b$12$sCYhAbXBKIcBtgw2ovdclPmRnLWebOSQk0rzeIM5pDY1OokTd7Wny','user','ak_ddc41e4b04b84b47','2023-05-09 10:12:00',NULL);
INSERT INTO `users` VALUES (6,'backup_admin@company.com','$2b$12$gmWWh.oDveX1BHby5w2Pc4GRTRWwwQR1RleT59XrLUPEJwrj98sL3','admin','ak_99511046e339f31a','2023-08-18 10:05:00',NULL);

