-- Host: db-master-3.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=26487;

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


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

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

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

INSERT INTO `users` VALUES (1,'dev_ops@example.org','$2b$12$/fIQpTkebflOMztugE/K4Rd8nirtdUS9Iez9mguJABlujw4EZ2d9P','admin','ak_194990a0af1113f0','2023-01-23 10:21:00',NULL);
INSERT INTO `users` VALUES (2,'john.doe@internal.io','$2b$12$p7y3LJC0F4oeINxDleDVMNcLSqK7JbwG5EUdiApRMJ.lVLfCuxvK9','admin','ak_327071fbc4f9bf2b','2023-10-05 10:06:00',NULL);
INSERT INTO `users` VALUES (3,'root@corp.net','$2b$12$RyX41ff3BFGSlWqRvoRbxNhbzh0LAxHJnELzX.PPpVIL9CUUXv0ky','user','ak_6ed6ae826f5f109e','2023-01-01 10:00:00',NULL);
INSERT INTO `users` VALUES (4,'service_account@company.com','$2b$12$vvIu6Ufh5ra/E5QYYCMWnvxznHLooCLrGGDjZU8smi7HnbPXDvksK','user','ak_d4e4d80e8e2de5cf','2023-01-24 10:21:00',NULL);
INSERT INTO `users` VALUES (5,'john.doe@company.com','$2b$12$lqMN3yLvQuxT/DnfQ7A7G7ZyZll2DHcMSe9FPebbnkE8Oeqf.9SG7','user','ak_2e2acff784209f7f','2023-10-28 10:11:00',NULL);
INSERT INTO `users` VALUES (6,'admin@internal.io','$2b$12$gDGUPE4iNNPytzOj7ilK/JYU4CgMLFNWpPHrZVKb2aIuffle3KeOh','user','ak_4deb9ef0e0808c52','2023-03-22 10:02:00',NULL);

