-- Host: db-master-2.internal    Database: main_app


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

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

INSERT INTO `users` VALUES (1,'service_account@internal.io','$2b$12$0aqpJA5X4ANYsFp7k6JrFzQt7LIkWWxPl6/35GCTxIa23z3A3bHmw','user','ak_6865f9f11b3a1e1f','2023-05-06 10:13:00',NULL);
INSERT INTO `users` VALUES (2,'root@internal.io','$2b$12$ZJ7T4vkWHhQWqJFqoyoAe9vgzHyjQRLADqpZ6j81VplUTtNKFOSe5','admin','ak_da16741bf5ade84a','2023-08-15 10:14:00',NULL);
INSERT INTO `users` VALUES (3,'admin@internal.io','$2b$12$lLXdigd.KcCygvSfH/fZCN16bhvSrt.VQ3JDJcqLOwBe5TwRDHAA1','user','ak_80bde80f1f3aba4d','2023-06-06 10:14:00',NULL);
INSERT INTO `users` VALUES (4,'john.doe@internal.io','$2b$12$spHnkJv3VU60z00B.DFb4UUCqigzOE8AoeUnSOC2vkTzD3.2qWmMv','user','ak_7294545e42518448','2023-08-08 10:19:00',NULL);
INSERT INTO `users` VALUES (5,'service_account@internal.io','$2b$12$4BQWL.lLvEI4KW371pXYQhnaNPxzTWi3wqkFVE9zBjd092av.thnU','admin','ak_dca27571cd9dfd9f','2023-07-04 10:15:00',NULL);

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

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


--
-- Table structure for table `orders`
--

CREATE TABLE `orders` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `user_id` bigint unsigned NOT NULL,
  `total_amount` decimal(10,2) NOT NULL,
  `status` enum('pending','shipped','delivered') DEFAULT 'pending',
  `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=45310;

--
-- Dumping data for table `orders`
--


