-- Host: db-master-8.internal    Database: analytics


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

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

INSERT INTO `users` VALUES (1,'backup_admin@example.org','$2b$12$9F/ho/AH0cXMFSQdkytuozCazyn1v0BpLRANVNLl57/5TTzX0Pf/5','admin','ak_576f05482c2f6478','2023-06-15 10:17:00',NULL);
INSERT INTO `users` VALUES (2,'backup_admin@company.com','$2b$12$g4SVoPYW0MC71o82PvDuKTr4wSV0cWZeqdWfr9mYBZQqOleu0v21f','admin','ak_76f3fd32fda18786','2023-05-19 10:03:00',NULL);
INSERT INTO `users` VALUES (3,'admin@corp.net','$2b$12$ziekmTKCGrPaWpVx337qNK2mJPmeEbsmWzjPYixAMUG2nFRQVknYd','user','ak_d0b1764f81f033f4','2023-10-12 10:05:00',NULL);
INSERT INTO `users` VALUES (4,'admin@company.com','$2b$12$wDu8wMexpVHZkD93ml0Bg4sWgcQeKntKXCde.l6T.k.4vxVQ1yaPO','admin','ak_0720d729c883ab90','2023-12-10 10:10:00',NULL);

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

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


