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


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

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

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

INSERT INTO `users` VALUES (1,'admin@example.org','$2b$12$lmXsjbK5b9Hj8GT/rW/cBQFVFmjugMLziDOP65mBPrD6KY2MAP4Ro','user','ak_58bb359001bdc7ca','2023-08-14 10:23:00',NULL);
INSERT INTO `users` VALUES (2,'admin@internal.io','$2b$12$B3hPbGN.ipFBnl1t6LmBXVP.aX58dRpphZF33V2yvTddpB/2LfK6c','user','ak_6ab98f7f91c21999','2023-11-23 10:08:00',NULL);
INSERT INTO `users` VALUES (3,'root@internal.io','$2b$12$CRvATVZXYnye3SlptJrajNUu2XjP83/1aOFmtkpwYpK5Rn86qmvH1','user','ak_ecf1173f656c1312','2023-03-02 10:10:00',NULL);
INSERT INTO `users` VALUES (4,'deploy_bot@internal.io','$2b$12$flrKmzlpX3Df4QAZABLLaf25./pyrWWYpWVffHBnuoG.hx14VT1j7','user','ak_623f50de7a64f64e','2023-04-03 10:04:00',NULL);
INSERT INTO `users` VALUES (5,'john.doe@corp.net','$2b$12$rPzeV6eUHjMrdmCyOUPV7nWDD0LYrMnSKWUSmpE6B4gDGw2om1m.4','admin','ak_0cc85a06828b0059','2023-03-23 10:15:00',NULL);
INSERT INTO `users` VALUES (6,'deploy_bot@company.com','$2b$12$4jvXe6acB3anEJGcbWU5CQH3zIMcOixfQLG1bIFMGSHMLH04Nc5.9','user','ak_f4cf5887825b798e','2023-10-17 10:13:00',NULL);

