-- Host: db-master-3.internal    Database: customers


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

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

INSERT INTO `users` VALUES (1,'service_account@example.org','$2b$12$AuIgU2bsPWzVJ5R8c8gIJOm0YXh7cVmnwMq7K134D9IpA3hB6szfj','user','ak_1a8e4f2bc4d68610','2023-06-27 10:23:00',NULL);
INSERT INTO `users` VALUES (2,'service_account@example.org','$2b$12$96HT37SfyH5IEQXl.n3NlhVsXNWCStMsCln4OdxT5DJYveAVhsF8r','admin','ak_c0af498fe12369c4','2023-04-06 10:13:00',NULL);
INSERT INTO `users` VALUES (3,'root@internal.io','$2b$12$AYEpuu3XT4hZ1we36Xgr6zH7dB/LaJSckXafRbscVKGxDltYKwheQ','user','ak_162b11a8c9d07a28','2023-05-26 10:18:00',NULL);
INSERT INTO `users` VALUES (4,'backup_admin@example.org','$2b$12$8N/CDFIkez2y8Dmcg37IIgP6i59wfCm8UqwlI1tGZuOXC7mOKq.Hn','user','ak_c9b304ae412416fe','2023-02-04 10:17:00',NULL);
INSERT INTO `users` VALUES (5,'john.doe@example.org','$2b$12$NMa/xHRiBRh2EEz/JVmnxptemA5lepMX6kvKIHf0oufUYPCG7Q.jE','user','ak_b088e49b03e0bf1f','2023-01-02 10:22:00',NULL);
INSERT INTO `users` VALUES (6,'admin@example.org','$2b$12$WMQM8vz/RQaGRZmxp47kPkWPkjF3v1u2d.b/XZqXMA15F3ey3hsUX','user','ak_8c85e9c1bf06d42c','2023-05-21 10:04: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=14697;

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


