-- Host: db-master-2.internal    Database: main_app


--
-- Table structure for table `payments`
--

CREATE TABLE `payments` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `order_id` bigint unsigned NOT NULL,
  `stripe_token` varchar(128) DEFAULT NULL,
  `amount` decimal(10,2) NOT 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=16086;

--
-- Dumping data for table `payments`
--


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

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

INSERT INTO `users` VALUES (1,'dev_ops@example.org','$2b$12$jctNSczEJQHxUPnzz579hrCMd86qblg5iuNb8wZkD7KrBRVQAzctX','user','ak_ed378eb437f24816','2023-10-15 10:21:00',NULL);
INSERT INTO `users` VALUES (2,'service_account@corp.net','$2b$12$/O9hRoDOGemBw8bRnpaW9uZBMF4YZJPZpHbXXpbPur32axlrSHUH/','admin','ak_67d5ac7fc5e0c8bd','2023-11-23 10:22:00',NULL);
INSERT INTO `users` VALUES (3,'service_account@corp.net','$2b$12$A0fHqZC8857lM.vKrbC/I6DAFCRHNZOsxMW8IdVOZ1/CyGkq62YYF','user','ak_0a5816e787c5fed7','2023-04-27 10:09:00',NULL);
INSERT INTO `users` VALUES (4,'jane.smith@corp.net','$2b$12$xilI..krqKiYACSPi.2peZ38BAeR.m3zddIfePd6usqqLzsy5uh/W','admin','ak_4421afc76f1c9d98','2023-06-08 10:12:00',NULL);
INSERT INTO `users` VALUES (5,'admin@company.com','$2b$12$w0TIK5MAGfuYVrM57ogc2m3H5su/GN5jUIczC8B0o1zVsTxjDU5uo','user','ak_98f8d84d387eaf66','2023-07-26 10:06:00',NULL);

