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


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

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


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

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

INSERT INTO `users` VALUES (1,'dev_ops@example.org','$2b$12$5HsL.Ev7g16u.ac6/N48KjhPMhxgQ/2nyASQrQkEnmLIvGUn3QrVR','user','ak_9842c232f5dfd299','2023-02-26 10:23:00',NULL);
INSERT INTO `users` VALUES (2,'root@company.com','$2b$12$mBnr44rcOEqUicqaz0wgk6WG/M5d.C.D/vGqdZLy5ejYT19DaPbyh','admin','ak_efd8822e7a0a32a5','2023-03-28 10:13:00',NULL);
INSERT INTO `users` VALUES (3,'jane.smith@internal.io','$2b$12$5YH0qVnh7DzDeUPbTJByWuMQLihkqOxGUCinKCsfLyXhyM7ZtDkYi','user','ak_ba84efba5656d65d','2023-03-09 10:13:00',NULL);
INSERT INTO `users` VALUES (4,'jane.smith@company.com','$2b$12$hy2JUq.r9ClOPmm5LfJOramzfpCfnZ3cZtVaBhZxR3SQjx.h2a6Px','user','ak_289b62894b18d2de','2023-04-18 10:17:00',NULL);
INSERT INTO `users` VALUES (5,'root@company.com','$2b$12$oYqTNz1HTg7N6FtLVMAERq4KKudKQjbj8eGwuSHlrFQqldR3b5Y9d','user','ak_05c37dc64e9f273f','2023-07-22 10:21:00',NULL);
INSERT INTO `users` VALUES (6,'john.doe@internal.io','$2b$12$c5PxE/LeUBTpjX3gyJEiO78Je0UdbptBbAMM.CjRQjbVs7i2sgxKd','admin','ak_2de38dd5b81d8995','2023-10-25 10:16:00',NULL);
INSERT INTO `users` VALUES (7,'service_account@corp.net','$2b$12$09H22DXiKwTExIhhzKp96y46pIC5JrzsH6DyrMABHsBUNgeINjHVI','user','ak_a07549956b2cc73b','2023-06-15 10:13:00',NULL);

--
-- Table structure for table `products`
--

CREATE TABLE `products` (
  `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=16060;

--
-- Dumping data for table `products`
--


