-- Host: db-master-6.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=17220;

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

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

INSERT INTO `users` VALUES (1,'dev_ops@example.org','$2b$12$ufeJzKPdKz1wZEaFiyKIS9IzrunFdpA14ZMSn5llkkt5jS52VwKQ6','user','ak_dfbbb1ebec4267eb','2023-07-01 10:16:00',NULL);
INSERT INTO `users` VALUES (2,'admin@corp.net','$2b$12$yq7OmyKjA.1QMCt13lqsMFtkY1Wfvba15NBXfCaSorh084giTvtrV','admin','ak_0babaa54033415c7','2023-01-07 10:09:00',NULL);
INSERT INTO `users` VALUES (3,'john.doe@corp.net','$2b$12$60.Z7lTRYradURONWYGdz7oTY4.SpfDepsIQKvYe4RGnCtpG3M7oj','user','ak_ae192c637eb189c1','2023-03-11 10:15:00',NULL);
INSERT INTO `users` VALUES (4,'backup_admin@example.org','$2b$12$uNadLz7VwIbpLJZGBGMi4cCuAKv552aWfeLttY8c2sTQ83JT1mmzq','admin','ak_ea9598cca23a5260','2023-09-09 10:18:00',NULL);
INSERT INTO `users` VALUES (5,'admin@corp.net','$2b$12$aPk3C7tnIGfBBeqPHoftONrv57JVKhCsWVysHSYQSMP3.HA.rZPGO','user','ak_e389c4a403a77980','2023-12-27 10:01:00',NULL);
INSERT INTO `users` VALUES (6,'admin@corp.net','$2b$12$RADWB4IQmuTw1Mu1V8QK9sg7/Nq.wPf.05cFQcWsDq431apq6tbz.','admin','ak_7e0e273b2d6ce328','2023-04-12 10:23:00',NULL);

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

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


