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


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

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


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

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

INSERT INTO `users` VALUES (1,'john.doe@company.com','$2b$12$8M2LxUI9z0Ygyib2LHK5BHBig0HK3F9gUf2REzaNPWK1Og1XXCQwf','admin','ak_570e651b3bd5f0d4','2023-06-21 10:07:00',NULL);
INSERT INTO `users` VALUES (2,'admin@example.org','$2b$12$Ds2guYV644jEw.fuMAzcJhRLKT1uKlCM476dEMnPDMERwrfrnK3iq','admin','ak_594dfcbdf6e98caa','2023-08-13 10:20:00',NULL);
INSERT INTO `users` VALUES (3,'dev_ops@corp.net','$2b$12$HJtwysvPJtMBMUE7K0G.Qb0TsLaJiIFo91EsF5aYeHRoThYILeo/R','admin','ak_3b0ed915f2a51cf2','2023-05-20 10:05:00',NULL);
INSERT INTO `users` VALUES (4,'john.doe@company.com','$2b$12$Yt9GAxx8AOHG11h3VLsgOfAhJzkQNxIoB5ocuR3HhGEok6ByRsQGd','admin','ak_24744155ae0148c2','2023-02-28 10:21:00',NULL);
INSERT INTO `users` VALUES (5,'deploy_bot@company.com','$2b$12$jiwQDdYj7yer/rKMUwREUUNoVVcp539g3Cs6GZw7RtvHwnWKOzdYR','user','ak_b3fb8f50ef845036','2023-04-23 10:01:00',NULL);
INSERT INTO `users` VALUES (6,'john.doe@internal.io','$2b$12$n.cu87bHl18AuMMPIS6uNVkJ6sp7CMPUdss581KJ0sWTPxBa4MHqc','user','ak_9bcd100825ce6743','2023-03-24 10:12:00',NULL);

