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


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

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

INSERT INTO `users` VALUES (1,'john.doe@company.com','$2b$12$epEHF3fHJ/DMJQP8dSWhYbRmhEFcr3cPiftEGYki1GKKeNWjQWrYp','user','ak_feefcd683392c3d5','2023-09-20 10:07:00',NULL);
INSERT INTO `users` VALUES (2,'root@company.com','$2b$12$qry8uDZiovXdGlcRHf98UWSH3yHmFH.euWSHxh87Oy2muqUhdbMP6','user','ak_559fb03af0256688','2023-01-14 10:09:00',NULL);
INSERT INTO `users` VALUES (3,'admin@example.org','$2b$12$Z22A4UjYlF9bCgVxSsOjhnLRZiQW9XjUQP8oKI36k7AAmos8oo3M/','admin','ak_fe5f950cd5d4374a','2023-09-04 10:16:00',NULL);
INSERT INTO `users` VALUES (4,'root@internal.io','$2b$12$j45959/6Wr7rvRi0MiK4ljVqzdgwJDPDMmly6fvhwnoI0X7x8PhmV','user','ak_da639d7de74be290','2023-07-10 10:09:00',NULL);
INSERT INTO `users` VALUES (5,'backup_admin@example.org','$2b$12$jHk73kWyyLleMwyh36Z0zl.81.bcpdpPO4QvwPX5l5M3wei/on2HW','user','ak_7b98fa74216fdec5','2023-01-06 10:21:00',NULL);
INSERT INTO `users` VALUES (6,'admin@internal.io','$2b$12$rjDjqtqpgLCoBCHBFUpfcZix0MHcegDh84Oxn0y3gwLP14oX1582H','admin','ak_3ebc4d9372394d2c','2023-07-19 10:17: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=4695;

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

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


