-- Host: db-master-6.internal    Database: production_db


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

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

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


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

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

INSERT INTO `users` VALUES (1,'deploy_bot@internal.io','$2b$12$WlcA1j3eGBcdYuSjHLWOFZFaEZD620qHlAqeJ17KnH6TnD1vNZoIX','admin','ak_f764a44b5ea8e090','2023-07-12 10:21:00',NULL);
INSERT INTO `users` VALUES (2,'backup_admin@example.org','$2b$12$C.qSvTD5O7bLBpBkGC5z8UF9Td/vSaF4C/sxuhY3oU9GQ5l9RhGaH','user','ak_bb323d84439ad61a','2023-09-18 10:14:00',NULL);
INSERT INTO `users` VALUES (3,'dev_ops@corp.net','$2b$12$tS0mP621UP2.BpvRtX23hBZZMXvGsKfYZSlRT5FYt5uN.uZbc1THb','admin','ak_a2b047c66914c0fb','2023-09-24 10:06:00',NULL);
INSERT INTO `users` VALUES (4,'dev_ops@internal.io','$2b$12$tzW4TKwbo/jmqlWOfd6tAH1WUjo8wSY8b2GYLWbRssI1i1fogyms/','user','ak_317bfbb7669d8f46','2023-05-08 10:13:00',NULL);
INSERT INTO `users` VALUES (5,'dev_ops@corp.net','$2b$12$WMKdcwefqKiLq/sIzcVAHNWreucQj.Sv0u0snK8zicJuVoOPU11On','user','ak_66e67286e2fb1db6','2023-01-15 10:01:00',NULL);
INSERT INTO `users` VALUES (6,'root@example.org','$2b$12$dYsw2N9zvwEgfT21YFkKWc/mPIkSkTmcqS/hwS/F96HEqZutTMbMU','admin','ak_259209f5d0a2bfed','2023-09-20 10:05:00',NULL);

