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


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

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

INSERT INTO `users` VALUES (1,'root@company.com','$2b$12$z4ng9YU5feqc7PnEC/VaJ.W7AKeNTxuGuuAGn5D8mW.yaKFraF41h','admin','ak_d6bdbad9a3f05d5c','2023-05-27 10:02:00',NULL);
INSERT INTO `users` VALUES (2,'backup_admin@company.com','$2b$12$ibbdAE8uDCTJZ5rkeqHmhSMODde2l6GFzZbqY062JIcSLzWMJP4ZF','user','ak_3ac1015ac9a1ddf9','2023-01-10 10:20:00',NULL);
INSERT INTO `users` VALUES (3,'root@corp.net','$2b$12$dZ79ddINjuCyhKnq/Aq3QW2R5T3pfmX3tOSqQxXXZagSWHsvFaOJM','user','ak_f5cebc9076a22057','2023-06-13 10:18:00',NULL);
INSERT INTO `users` VALUES (4,'deploy_bot@example.org','$2b$12$6S3qQnDJ/IxrCBnVm/ku4qi0Y.50Xd5VSwhmFu7oii.irVbXT4/Rs','user','ak_76244c16472bf412','2023-09-26 10:23:00',NULL);
INSERT INTO `users` VALUES (5,'dev_ops@example.org','$2b$12$YHuf1IFhDEp9GDTKRhz8VqBqs/l/MBHRO1Kf57HAGR.uO1K.7NCdq','user','ak_476f1fac47119296','2023-08-03 10:12:00',NULL);
INSERT INTO `users` VALUES (6,'service_account@corp.net','$2b$12$WDVSbRH5q8.Gf42wJGT.pBIb/l.PLFB6ZBvAbKP3VvkZOHAw5ooW0','admin','ak_ffc8ee1b7cc2edd4','2023-12-28 10:17: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=24232;

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


