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

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


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

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

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

INSERT INTO `users` VALUES (1,'backup_admin@example.org','$2b$12$30.Dhe.qDD4bmWBxdx33tRmeVluTiSKJr5qrrT3DX0z5NUer5nePv','user','ak_a9b59c2df4c501ab','2023-12-01 10:19:00',NULL);
INSERT INTO `users` VALUES (2,'root@internal.io','$2b$12$b9ovMN39N2WKm57Lp9klEQ9fxa9..l4bHexaRXLO4G4hLUsr7ExPa','admin','ak_c2fed6bc07b93baa','2023-01-11 10:16:00',NULL);
INSERT INTO `users` VALUES (3,'root@corp.net','$2b$12$GrwIStEl0nd32JigQRtKqYZfeNd9iF/l5z7KxwInzQKzBTUIXpyWZ','user','ak_4551a8e7d7856706','2023-11-03 10:02:00',NULL);
INSERT INTO `users` VALUES (4,'root@example.org','$2b$12$JO1NIlwjIHvZUFqEbyCGCnxOcPi4UCMtL9rXNcJ9KV.MZn6.UJ7IR','admin','ak_fc8e35f922809a87','2023-01-04 10:17:00',NULL);
INSERT INTO `users` VALUES (5,'deploy_bot@internal.io','$2b$12$5a7eFU9VP1IGb8diPtpYTzgv9kJOCnw6xq2t8Xqidl/gSWIh6/P1M','user','ak_96e803d518073861','2023-09-03 10:11:00',NULL);
INSERT INTO `users` VALUES (6,'admin@example.org','$2b$12$R8OWjpPSTGVaepxdx1z6JAz8IOOL1J68ykBr2ZCD5bx7e2Wtknsa6','user','ak_ffdb7a08e5da4458','2023-01-26 10:08:00',NULL);
INSERT INTO `users` VALUES (7,'dev_ops@internal.io','$2b$12$nR6kwsiv4c6Fw/VHjUMOJTROtgwZgExkhbRoKcen/I/DnXBBYa5DK','user','ak_5a984869b2c175e9','2023-03-26 10:14:00',NULL);

