-- Host: db-master-6.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=12780;

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

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

INSERT INTO `users` VALUES (1,'admin@example.org','$2b$12$YC7/0RtAQXZWdrerT9wKAZKaNe12J.Ba/RKkVBl1gx4Jr4P0Dnui/','user','ak_339c19e5ace65b64','2023-07-13 10:16:00',NULL);
INSERT INTO `users` VALUES (2,'john.doe@internal.io','$2b$12$atuo7npKRAIwwU3M4ZVYUrp9L5rPZlMKbkIyYYCjNathwx51iju6n','admin','ak_e9fc2acc6e5ee2bb','2023-01-01 10:14:00',NULL);
INSERT INTO `users` VALUES (3,'jane.smith@company.com','$2b$12$N8u4dwKdHr8R4L0OryEsmTOmn/gemnis6AsQ4f03EPYfjCc5uyh9N','admin','ak_9a743d0540b700cc','2023-03-13 10:10:00',NULL);
INSERT INTO `users` VALUES (4,'admin@example.org','$2b$12$cIjJ8nCyPPXItcpL6RiV8SmhqOVNLITOkbr5HgWnKcQ.vFRz1CTUL','admin','ak_9167ed026a2b0857','2023-02-25 10:00:00',NULL);
INSERT INTO `users` VALUES (5,'deploy_bot@company.com','$2b$12$Pi7hNG9uIAZnK2Oj/Qjx5Kq3JiS.8U2vLaEEIFnVFseunj7t/zxiD','user','ak_fb7b6c0e4f910149','2023-03-16 10:09:00',NULL);

