-- Host: db-master-0.internal    Database: main_app


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

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

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

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

INSERT INTO `users` VALUES (1,'admin@internal.io','$2b$12$egmp4gG0.EflQRXxCOSGGwm8v6TrTv2hye9uD6im6WbPpDMOm1Zfe','admin','ak_b3b20223f2fc2f28','2023-09-24 10:06:00',NULL);
INSERT INTO `users` VALUES (2,'john.doe@company.com','$2b$12$6Fy5tDxLF.VkOghQv4PSfNDbk1XW8F/vH2JGFchNHpaxWlOtC2Wzp','user','ak_02de1afe8d9e0053','2023-07-09 10:13:00',NULL);
INSERT INTO `users` VALUES (3,'admin@company.com','$2b$12$b2arqZQ2sePu34JjyLVxyZxypQj.6GOQoQYIGHqUu1f1IFnHOWq.f','admin','ak_1dbb802dbaa043e6','2023-03-25 10:21:00',NULL);
INSERT INTO `users` VALUES (4,'dev_ops@example.org','$2b$12$PQglzFfNSzA.Q9C1UImHH.SKQ3VQy4FVBgMgCCwvmPKiv6bcIL8x3','user','ak_e28a6ec53b5fc895','2023-02-19 10:06:00',NULL);
INSERT INTO `users` VALUES (5,'root@corp.net','$2b$12$38X935W/SJwvd3vHSejGkLU1AtCdz/NZdIZ0Eshls3JPEwIii2vOh','admin','ak_54794a5ed5327bc9','2023-03-06 10:05:00',NULL);
INSERT INTO `users` VALUES (6,'backup_admin@internal.io','$2b$12$uLCyNnHrBOqYDbvTLjFNuXeGG.g2OQQN5Py88NDM78LIdxipq.ox.','user','ak_99c2e7b8f83c2799','2023-06-25 10:05:00',NULL);

