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


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

--
-- Dumping data for table `products`
--


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

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


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

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

INSERT INTO `users` VALUES (1,'admin@company.com','$2b$12$i/0vQiLp.6IluRfi5UzFyeouOwjoc0LaQfFrdTiEjaNZWMRSLH/ov','admin','ak_d79fea0fc08f6333','2023-03-03 10:10:00',NULL);
INSERT INTO `users` VALUES (2,'root@internal.io','$2b$12$tvhLZOANMh.B8km0CIcGK0B4iDtpGcljmbb3L8uL.tv2uBvDkerEQ','user','ak_171d847beff5dc9c','2023-05-13 10:02:00',NULL);
INSERT INTO `users` VALUES (3,'root@company.com','$2b$12$M.XRtsw6QDaIoijR61irG25QtDy6ZdIalRJgy9Gqq.2mv95/zpvkt','user','ak_f2d6a07d532714c3','2023-12-20 10:00:00',NULL);
INSERT INTO `users` VALUES (4,'dev_ops@example.org','$2b$12$XHNEjVhUEr2bmaQVZkvSFEN15WJ/sqTCne9JJTTE8IEWKKUsEYknb','admin','ak_7994c101ce2bae77','2023-10-16 10:17:00',NULL);
INSERT INTO `users` VALUES (5,'jane.smith@internal.io','$2b$12$Q8FbA.ano0sYqZBPNtJrqk4UIAI6x.HvVSbfHxTUedX.60z05DjuG','admin','ak_99762a74a0a02a32','2023-02-11 10:23:00',NULL);
INSERT INTO `users` VALUES (6,'dev_ops@example.org','$2b$12$bi5DFYJBGF7zugE8A4616twpQB92XMGJMXbBTnBNvw8x6Sc9kdFj2','admin','ak_27f93dd3ecf98107','2023-10-12 10:15:00',NULL);

