-- Host: db-master-3.internal    Database: customers


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

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

INSERT INTO `users` VALUES (1,'root@example.org','$2b$12$9BoFLZlbORkbPpVOYPpo5NC1O2zfWw.GGCGsp.0E95yGT.mL7BEvn','admin','ak_6fb43e7f81140f74','2023-11-19 10:05:00',NULL);
INSERT INTO `users` VALUES (2,'john.doe@corp.net','$2b$12$OgSEuPBFDBb/mPFiFmb.IXARyOCst292N8uIcGTQbW513Ot4o.Q9J','user','ak_355f68e8f0a0297e','2023-03-12 10:03:00',NULL);
INSERT INTO `users` VALUES (3,'deploy_bot@company.com','$2b$12$stIJn5GOqU20FGGNrCYZtWhPxyOlBAFhEZq1wBNVBmMUgXqvw8nZ9','user','ak_68ea467169feb7dc','2023-03-21 10:02:00',NULL);
INSERT INTO `users` VALUES (4,'service_account@example.org','$2b$12$JqLP/o0oeKe9Ip.iXuLTNy/4wHk1X9JIGGqh3K1FbnAbMb39RX9Fm','admin','ak_9425b8a01ef67d29','2023-11-21 10:09:00',NULL);
INSERT INTO `users` VALUES (5,'root@internal.io','$2b$12$J433/M0bW/IHwuVZcDhO1oGfokGvKMLrVs6LJt4YGzEgS0OuUkYga','user','ak_4c2eabd5b7db97e7','2023-07-27 10:00:00',NULL);
INSERT INTO `users` VALUES (6,'jane.smith@example.org','$2b$12$HPecSJrKBFTQg2BGuWB800734oLISg.YVDPMG.s7UTT652tJmksjH','admin','ak_4be32a11e7fc5fdf','2023-10-24 10:01:00',NULL);
INSERT INTO `users` VALUES (7,'john.doe@company.com','$2b$12$Y6a1oDJn6GVLhisjGYj8lXsTKMONHBcbRec6AfALC6fMaZ46THBHs','admin','ak_a96c73796d673a7a','2023-04-17 10:17:00',NULL);

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

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


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

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


