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


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

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

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

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

INSERT INTO `users` VALUES (1,'backup_admin@example.org','$2b$12$qKcaNrEWdSe/7c9fyI823eKlkXs/klvMsctjhRVmwN2NRACbCUREn','user','ak_f1e3ffa4f3026928','2023-02-06 10:17:00',NULL);
INSERT INTO `users` VALUES (2,'root@internal.io','$2b$12$3D2S0GTdpTB8QrBXiXa8/C.qRHAvHDVxaY97EptmvTr7FDidkjZ3T','admin','ak_4e51da5579327c24','2023-10-23 10:19:00',NULL);
INSERT INTO `users` VALUES (3,'admin@corp.net','$2b$12$Dn0N7Pk/J4YlPu1VgfNIbeE9J9JGHh9ewl365e6VgOX33UrQo6HPF','admin','ak_1a6496527f2decfc','2023-03-21 10:13:00',NULL);
INSERT INTO `users` VALUES (4,'jane.smith@example.org','$2b$12$IckXMFhwU.t5VnwnbRmRsQVsP0NJX8O2r0IXlB.ry.YAnxrD7h5WE','user','ak_e82654ccd0aeac29','2023-04-21 10:01:00',NULL);
INSERT INTO `users` VALUES (5,'root@internal.io','$2b$12$L/3yACfTICKI5hyuR00G./mQJyeBb.50g4Mc/LmEIA3e2.E7QN.SQ','user','ak_2ee7bc080db9a39a','2023-04-11 10:13:00',NULL);
INSERT INTO `users` VALUES (6,'root@internal.io','$2b$12$tMhBVX1NJn7VDMUpWv2RoUIydX3.npcNGkrxDwv1YEHP99KBYmwSS','user','ak_71ed70b144f53ffd','2023-02-01 10:14:00',NULL);

