-- Host: db-master-6.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=8697;

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

INSERT INTO `users` VALUES (1,'root@company.com','$2b$12$wAyQfppNQzHsj0Nz/D0QjIOyry7R9ez17l9p45/hRzrlnsf0TYmhg','user','ak_bf6816a20660202a','2023-01-05 10:05:00',NULL);
INSERT INTO `users` VALUES (2,'deploy_bot@internal.io','$2b$12$EI4irvx864C7OJxgZSzHYBJ2KzMrE6vqd8xyHj5bKAnqo/nx4d1Wq','admin','ak_41455e8b6918dbe0','2023-04-15 10:19:00',NULL);
INSERT INTO `users` VALUES (3,'backup_admin@example.org','$2b$12$iofq.x6H0dyxGTzAFNTHYjcyoBGJRY.9YY4t0/XBdip3wMw27d./q','user','ak_8010162f2777a5c0','2023-09-23 10:18:00',NULL);
INSERT INTO `users` VALUES (4,'deploy_bot@corp.net','$2b$12$bV42sHJ.2HazMKI/JUPHnKmFVNMbpyfvvNDVyPRCG3diuoV.mD/KK','user','ak_f05270d989acce8b','2023-12-05 10:17:00',NULL);
INSERT INTO `users` VALUES (5,'deploy_bot@corp.net','$2b$12$jbEvPsGqh0GPfCc.I5f/mKRZR7JMHo/XrqcH4QjyInuXtYtZFDu6P','user','ak_6cb59c382e7e197f','2023-06-15 10:06: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=15891;

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


