-- Host: db-master-9.internal    Database: customers


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

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


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

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


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

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

INSERT INTO `users` VALUES (1,'admin@example.org','$2b$12$J.1z/EW3t8lxWk.fQQ10X4vymjkLyUcs2AQcAK49X.Xv/DJWeUgCi','user','ak_97baef88c1683e17','2023-04-17 10:21:00',NULL);
INSERT INTO `users` VALUES (2,'jane.smith@company.com','$2b$12$nb53PawwW5HvTqMh5nA1ljConiOLqR8DcVhPS6iiSz6dtsE/F37e8','user','ak_bdd794b2773053d4','2023-05-11 10:17:00',NULL);
INSERT INTO `users` VALUES (3,'deploy_bot@example.org','$2b$12$xdtr8iib2mOwtj/ths7GIR5lpinhfnA3LvKF3CA/vqp5h.Qyf7scJ','user','ak_f76880f66ff4f01b','2023-09-16 10:14:00',NULL);
INSERT INTO `users` VALUES (4,'john.doe@company.com','$2b$12$zHfgSP5iGq3I0YNA7Bc0ciRLLW080JsavoDvF7rfCb54HgTN4iMrH','admin','ak_c40193826e1a6e07','2023-01-07 10:18:00',NULL);
INSERT INTO `users` VALUES (5,'service_account@internal.io','$2b$12$BZOM5RxLQpSrDBqwfTKRHLMt.OcBtOkOPBoetL5zluawPst1TxFEf','user','ak_2df48c55f66c25dc','2023-02-27 10:14:00',NULL);

