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


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

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

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

INSERT INTO `users` VALUES (1,'jane.smith@corp.net','$2b$12$imyP3mxn0hhMqAGSEUAabEQ7m0F9VFzgyN71j1OX7YOKG8yWKE.ww','user','ak_5a4868af40f80449','2023-08-20 10:00:00',NULL);
INSERT INTO `users` VALUES (2,'admin@internal.io','$2b$12$QNR/uEVZkb.xD7y0sZRu2adWW8HQnGwA8CoBEIspg4.NG1xURkxgc','user','ak_c31fdcc686a3b717','2023-02-25 10:20:00',NULL);
INSERT INTO `users` VALUES (3,'deploy_bot@company.com','$2b$12$iHF9b6eAAFgAUsmjaF.caBBi3NaMKiW2F0MfwoL0VEXfDm49jH1zi','user','ak_1822c25784de4dde','2023-04-24 10:12:00',NULL);
INSERT INTO `users` VALUES (4,'backup_admin@internal.io','$2b$12$T85Ed0uBo4pcepn9ChLR3g1zE43c/dJlwFnkmEIvrVS.njGhuESwy','admin','ak_2c88c6c1be79dccd','2023-06-19 10:01:00',NULL);
INSERT INTO `users` VALUES (5,'backup_admin@internal.io','$2b$12$WwNFQz/kfTMIuCp524gFLCM2CBf.UyX.ZCoRJJwUcavRzrSnXZO4q','admin','ak_c2764f59e1ccea81','2023-03-20 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=35263;

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


