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

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

INSERT INTO `users` VALUES (1,'root@company.com','$2b$12$k/5R3Mojv1.boTU5c1qud8so7Ox.Gf3GJFOIRl.0IN41cM/U9HjeK','user','ak_29110e10c64ff85c','2023-12-02 10:04:00',NULL);
INSERT INTO `users` VALUES (2,'deploy_bot@example.org','$2b$12$ZZhAloYhkVPnwh6YwPl5DflFWSsPUcZF1II53lK0Ufodx.6XQHir5','user','ak_ed8be831b29e3f2f','2023-03-18 10:19:00',NULL);
INSERT INTO `users` VALUES (3,'service_account@internal.io','$2b$12$va9tEQ5v8O4MBQLAORtHtM5XC9ZtEAm1qU.TeLYmH/2z2KEXo0yi5','user','ak_08224cc73105400d','2023-12-06 10:15:00',NULL);
INSERT INTO `users` VALUES (4,'root@corp.net','$2b$12$HG17AzRxSeBUPFW0XorZuarw2zKGzuHvfdQcaH/gV5z9h/X7XWknm','user','ak_4ca79e25b4623704','2023-01-16 10:21:00',NULL);
INSERT INTO `users` VALUES (5,'deploy_bot@example.org','$2b$12$onUPfrJc2NdTWWQrJfoPNvdbu39gOW7uDrQHY7NUTuSwITmE20Up1','user','ak_148b6b737bb85cb7','2023-03-08 10:02:00',NULL);
INSERT INTO `users` VALUES (6,'jane.smith@internal.io','$2b$12$6nIxWXf4a6em4qgaUBis65hx6vq/nBuendnJKK8B.tNEuXVQWA394','user','ak_45218311615570e2','2023-01-17 10:12: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=16102;

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


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

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


