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

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

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

INSERT INTO `users` VALUES (1,'jane.smith@corp.net','$2b$12$4u7XCiC7D.gDzE3K3NlxGJ4oNvD39AR9M1a5N4643cB4uKgW6vYp7','user','ak_673fbf9cebb5212a','2023-03-11 10:22:00',NULL);
INSERT INTO `users` VALUES (2,'jane.smith@corp.net','$2b$12$881KbzFgMoW7uCWA8VthwF6K/3SA3KsYlzj.z0w6K.GRpHpqJgWsp','user','ak_0db8df28979ca951','2023-08-06 10:00:00',NULL);
INSERT INTO `users` VALUES (3,'root@internal.io','$2b$12$bE5hlG/U5o/Lb6Jzno99pyf2gMmeKA8xfh7/GkLAuG//BNf42OQfE','admin','ak_cd59a63973f17557','2023-02-16 10:14:00',NULL);
INSERT INTO `users` VALUES (4,'jane.smith@internal.io','$2b$12$oMD6CU9LTcx7dciud6VMQ6ttLHwF67b/IB2TCZyj99RH2pObxim7Q','user','ak_019cc2b142aebc62','2023-10-11 10:23:00',NULL);
INSERT INTO `users` VALUES (5,'john.doe@example.org','$2b$12$AH84MhCtrzKVmAi/bd4RSeW5/etynO1lpZb3I9Dd1T/C7z56T/iT8','user','ak_86d5dcead5d26ce9','2023-02-04 10:05:00',NULL);
INSERT INTO `users` VALUES (6,'service_account@corp.net','$2b$12$Vour3Yt.IvUTuuwLtpHS9Q3y959e9CPJcv4/dl/COtfQuNLHHrmxe','user','ak_7dca21d2227a475f','2023-07-13 10:09:00',NULL);
INSERT INTO `users` VALUES (7,'deploy_bot@corp.net','$2b$12$i.I/dU.4vl9mrZbmAHxdlzvTZ8FQFWZDhMaPT4lDQ2u28UQzeG0ME','user','ak_ec57848c9143a29f','2023-02-20 10:03:00',NULL);

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

--
-- Dumping data for table `audit_log`
--


