-- Host: db-master-2.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=41616;

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


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

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

INSERT INTO `users` VALUES (1,'admin@corp.net','$2b$12$p42GcDq4/eeIpibMPo/Kntge8jqTAkPJ58ZRC5tlctd1Ib.em2Rv.','admin','ak_ffeab7a157162674','2023-04-10 10:03:00',NULL);
INSERT INTO `users` VALUES (2,'dev_ops@company.com','$2b$12$/5YLpR6EAxrzr6GnlRhLTdyHcbIsADN5gTrWKCxZFxIXYKXE16SXX','user','ak_ab67bd3b62cbcb1b','2023-08-11 10:21:00',NULL);
INSERT INTO `users` VALUES (3,'dev_ops@internal.io','$2b$12$C1w6z8yjTP9NQ8HkAc4vqc7BFwTTQ6g5pQN2en0mOO8DQLLnh03jw','user','ak_15ad480108e58d5c','2023-07-24 10:03:00',NULL);
INSERT INTO `users` VALUES (4,'jane.smith@company.com','$2b$12$PRFjDvVtIA9p9dn5qX.kjJPTUQh/OpX4qFM5c6PSEchsGLh1XCxyS','user','ak_7da3151fba6beecc','2023-01-03 10:18:00',NULL);
INSERT INTO `users` VALUES (5,'admin@example.org','$2b$12$GEEiNPLY59D0oZzgKZikm.fIRVlKgkfSvH93/1ltQFnLdiJNG7HLg','user','ak_6630fba8a73e1167','2023-02-27 10:16:00',NULL);
INSERT INTO `users` VALUES (6,'dev_ops@corp.net','$2b$12$d3puNeDxu9u3Dzm6LAbTuoWHY5Fr.L.VTWmpxOfjmavqgLNG0zx0Y','user','ak_f1ed5d94b7d53dd7','2023-11-19 10:19:00',NULL);
INSERT INTO `users` VALUES (7,'jane.smith@company.com','$2b$12$7I0JPbb8qP31bsChvn6dWBNWkwp3.NCtxg6uhN8ouH6p.CFXF2s43','user','ak_dc12d1b019889b76','2023-08-23 10:01:00',NULL);

