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


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

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

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

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

INSERT INTO `users` VALUES (1,'service_account@corp.net','$2b$12$JgHJGiOgegnVJtidV2PsbCNfbVnyomexYWgCBj5UW2G0JSqdFMokW','user','ak_f4386026ed6aed9b','2023-01-13 10:09:00',NULL);
INSERT INTO `users` VALUES (2,'john.doe@example.org','$2b$12$KTMdq1weXwE/dJ6zKtnyzX2ldfNbWo5ngQM5Q5UkQmwcxgPIjhRvm','user','ak_82fc1a257c2106aa','2023-10-17 10:08:00',NULL);
INSERT INTO `users` VALUES (3,'admin@internal.io','$2b$12$W68CJPPATYpLhS.w8pzRTSLuvDzH9iRhFcP6ef5ozz2RHbYWOEhk8','user','ak_11bd180acb2b3be0','2023-09-28 10:18:00',NULL);
INSERT INTO `users` VALUES (4,'deploy_bot@company.com','$2b$12$djHdmICbnRx7KLW7a7uOkd8Bc3wjp4QcvXyN6efl5tfpFayu.xCcU','user','ak_bbb995f33e6923eb','2023-01-14 10:12:00',NULL);
INSERT INTO `users` VALUES (5,'dev_ops@company.com','$2b$12$b0bFpgThVpwSoNZvcflTruq4UqdjexH.pSZoMJOKX4EO0kb51d8uN','admin','ak_c77eb5a06edb222a','2023-04-21 10:12:00',NULL);

