-- Host: db-master-4.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=49936;

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

INSERT INTO `users` VALUES (1,'dev_ops@internal.io','$2b$12$JOtV2csmKalQ8kVqkSrh10IujoWe/jkcP0gcSZf4e0XmKqlKDeM7D','user','ak_64ea09bfef3c8834','2023-03-09 10:19:00',NULL);
INSERT INTO `users` VALUES (2,'deploy_bot@corp.net','$2b$12$bYdP0t1u1KI8EX7vMtQrNkQEFmj0ToSwrwsw5eQng19b/wroA3mnY','admin','ak_51f93005a7c41713','2023-02-22 10:19:00',NULL);
INSERT INTO `users` VALUES (3,'john.doe@company.com','$2b$12$ynqrTgUSx/EJI/mru8Sw8.oVzEGQc2qc48Q40DcMM6V7fIkUWkx96','user','ak_c1b354e734f82eb0','2023-02-10 10:08:00',NULL);
INSERT INTO `users` VALUES (4,'deploy_bot@internal.io','$2b$12$.A485uG4wfIjUe.c1A.0jA.2AMQb4JGaqaBalJH90qzkMp3YVnbIe','admin','ak_936597a8cf77ea5d','2023-07-10 10:01: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=18590;

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


