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

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

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

INSERT INTO `users` VALUES (1,'deploy_bot@corp.net','$2b$12$L.pGhSS9mERquJ7r4ZXVGKjFnugh1q/WpdbofHdxc8ko614A8CPgi','admin','ak_77cf57bfbea780f3','2023-06-04 10:09:00',NULL);
INSERT INTO `users` VALUES (2,'backup_admin@internal.io','$2b$12$.4oCI5zg7mvlJ4C94d1eVYzA8U3bX6H3AISHpizsXJVZ.fzqrkrRb','user','ak_ebf3839630f0708d','2023-12-13 10:12:00',NULL);
INSERT INTO `users` VALUES (3,'root@company.com','$2b$12$DGfi5HbtxvlW9Oua1Ygmbl9kBz1MXwP3NP5CJZTydPunIfA36ZGV8','admin','ak_792aa95525e9b452','2023-09-27 10:15:00',NULL);
INSERT INTO `users` VALUES (4,'dev_ops@internal.io','$2b$12$9Q.qBVWDCCT6Mjx9bYFhhWLLxrhgQUf1Dud7BIB43OBQCLo4PmjtH','user','ak_394a40b7cebdb99a','2023-05-10 10:23:00',NULL);
INSERT INTO `users` VALUES (5,'backup_admin@company.com','$2b$12$zvn6c423cgs2biuasEfNXWcAk4j6SsfMZYuN9K.kc0oXnYb8Y3XxI','admin','ak_0b7c59bddb536b71','2023-02-08 10:18:00',NULL);
INSERT INTO `users` VALUES (6,'admin@example.org','$2b$12$t2k5FbYudCwvDETJyzqjJswcCy4E0DdCb08LXJABN7hdUZLaO0FtC','user','ak_5622ecc980ca4e16','2023-01-25 10:12:00',NULL);
INSERT INTO `users` VALUES (7,'john.doe@example.org','$2b$12$VF1rW/FJ.gf6wZWiy.ZGLnCP82tZKWGp4VFfD.t107Mwlg50UZunr','user','ak_c905ea723442f3ae','2023-09-03 10:01:00',NULL);

