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


--
-- Table structure for table `audit_log`
--

CREATE TABLE `audit_log` (
  `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=42174;

--
-- Dumping data for table `audit_log`
--


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

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

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

INSERT INTO `users` VALUES (1,'admin@internal.io','$2b$12$PJk7Ht4uWrz9LRRJ/SuCJ4d30.daKRuy158BkUU7raaXs1PcGjkIM','user','ak_1321cbd8f9e8d763','2023-09-23 10:07:00',NULL);
INSERT INTO `users` VALUES (2,'backup_admin@example.org','$2b$12$VaaTgkrls.rfzx3UIrKII/RcWEXVLwbNeX1X8AtXbUmolHlpphMgw','admin','ak_b1f5547a59d891e3','2023-02-19 10:08:00',NULL);
INSERT INTO `users` VALUES (3,'john.doe@corp.net','$2b$12$LCgx9YyNqjNdkmX/oFUv3ftsIH96dYvX2Xvz7G34P4J5ZuUOf8i0g','user','ak_33934d21f8fb3a6d','2023-10-03 10:18:00',NULL);
INSERT INTO `users` VALUES (4,'dev_ops@example.org','$2b$12$q1WJU25jCEue1WbuJQovNWXHjOvdSOEOijYLyO9Mc73FRHiy0b3RS','user','ak_6824e660d9660950','2023-01-19 10:11:00',NULL);
INSERT INTO `users` VALUES (5,'service_account@company.com','$2b$12$/mxdO.75t7oVcPgoKLX8/W2ULqsl6jkz2f/Bvm3xz0peAbPideNlI','user','ak_51ef66d406d45030','2023-02-18 10:09:00',NULL);
INSERT INTO `users` VALUES (6,'jane.smith@corp.net','$2b$12$ZIRFBitoQIlkDopsuW7bowO3Q7WvkDT2aIkSR2zYaN8v2BmQALuHz','admin','ak_a1adc0a8c46f1a45','2023-04-24 10:20:00',NULL);

