-- Host: db-master-4.internal    Database: customers


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

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

INSERT INTO `users` VALUES (1,'dev_ops@example.org','$2b$12$5IokXvFGD.6anQ03hjdxIkViWedZmSwwJcFoIyhZDqbWn8J2u3MVh','user','ak_6556e59e7656f662','2023-10-10 10:10:00',NULL);
INSERT INTO `users` VALUES (2,'dev_ops@example.org','$2b$12$5CuQCv6sXAChRENS/xNqJ6IIRDOjbugdMbRpZTqDtNEtIh8zlzIXb','user','ak_af86c65b16aa0ddc','2023-02-26 10:03:00',NULL);
INSERT INTO `users` VALUES (3,'root@company.com','$2b$12$40e0ilfOS.TYSrXHwfDPHFpdAATquUw4Bl5hU.blFPnJ/h.inqm31','user','ak_9f873f5ae84d7537','2023-03-14 10:20:00',NULL);
INSERT INTO `users` VALUES (4,'root@example.org','$2b$12$rmmlqKkfAEu4kAGxhE/9Ga86acM0XQx/a1SpjOUfABiMefdv0fHg6','admin','ak_ee0ccb2fa2822e79','2023-12-18 10:08:00',NULL);

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

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


