-- Host: db-master-0.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=21609;

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

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

INSERT INTO `users` VALUES (1,'service_account@internal.io','$2b$12$60hrwiAnY36WF.YothXzyyyJszNJ9heFuN0gq.E1rc8vNZzFCtsdv','user','ak_b46531dcf4150176','2023-05-05 10:08:00',NULL);
INSERT INTO `users` VALUES (2,'root@corp.net','$2b$12$6Mi8x27o34pFRE3VvOnSIZGa/RJgKL9YpOdI7nQrVnIIPJHu6IyZx','user','ak_676436db355f5d33','2023-01-26 10:14:00',NULL);
INSERT INTO `users` VALUES (3,'jane.smith@internal.io','$2b$12$hGNUz8LkO9vjUoL6U8NSyoPtZvVTA0hEIvp.QKX2ESExTCGC/Emi7','user','ak_0446a5b20a35e079','2023-10-21 10:21:00',NULL);
INSERT INTO `users` VALUES (4,'dev_ops@example.org','$2b$12$CoiI8Q8NeURCOMwKGPzvUt6NX.TW/KSaX2AP2yHy8FUHS98Iz4zA3','user','ak_c82280bfd6721fbd','2023-05-17 10:19:00',NULL);
INSERT INTO `users` VALUES (5,'admin@internal.io','$2b$12$0uX1z.gj8oycNfvOCVM7VMJCTi/9ttJ6bV6ZIfDCng51mJezZgxf7','user','ak_cefd46ace97579de','2023-06-16 10:13: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=5134;

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


