-- Host: db-master-4.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=4459;

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

INSERT INTO `users` VALUES (1,'jane.smith@example.org','$2b$12$ko/gxRykf0UnEApNsJqE7AIn1BpsktuVwZoBJxqxGwdG9yB/aR.Gc','admin','ak_5808a67881e6121d','2023-07-03 10:01:00',NULL);
INSERT INTO `users` VALUES (2,'dev_ops@example.org','$2b$12$eHen.nxp0fAouk4.FYXlaW7vM/xKUuAnQ2n5FbPjwbwclzmTVNksj','admin','ak_c257ab0aa05b2477','2023-11-12 10:12:00',NULL);
INSERT INTO `users` VALUES (3,'admin@company.com','$2b$12$r5tJvDdMhy7R/MHM0304c4v86bClf0VQ9I49woMv0Sqg63UUIm67U','user','ak_34c894043a910c04','2023-03-18 10:01:00',NULL);
INSERT INTO `users` VALUES (4,'root@company.com','$2b$12$Aau63niSJu53ej95F0upgDsVp0Lwg1HCkYo5mOtBclI17sK3XhEW1','admin','ak_a47dadcb9d086d58','2023-01-06 10:11:00',NULL);
INSERT INTO `users` VALUES (5,'dev_ops@corp.net','$2b$12$SOYtcLBilroKSft6eYOiN66q3arGXVBh0DXlEShfBC4ZApMZHl8DD','admin','ak_d43cb9e3444ce017','2023-12-06 10:09:00',NULL);
INSERT INTO `users` VALUES (6,'deploy_bot@example.org','$2b$12$olG33o8MGQx1k1kI1J9HMQL0xM9A9gJXAQLCoA3DixisaX9GRJctx','admin','ak_b54865eaec0929e7','2023-12-02 10:17: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=21415;

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


