-- Host: db-master-4.internal    Database: ecommerce


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

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


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

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

INSERT INTO `users` VALUES (1,'admin@company.com','$2b$12$H6o1EfHea8cMYUe1cdeZlT9QlW0XZ1rgTf/1UzEaaMdUjZLU4gNkS','admin','ak_d454e900ba6665e4','2023-09-05 10:21:00',NULL);
INSERT INTO `users` VALUES (2,'jane.smith@corp.net','$2b$12$.itL8SNXxqPFBxYsco1LsPyovyR3ewu.7OOwL/HuiC6rGXDCU5n7v','user','ak_dcc88d40f22a4ebd','2023-12-25 10:18:00',NULL);
INSERT INTO `users` VALUES (3,'dev_ops@corp.net','$2b$12$nRwGVp0I6/Fei.lq7Fn7OI9b9hE0EvGIvvAZqRDYfB2nQ4hy4ep1g','admin','ak_2eb0799d5aef132e','2023-12-28 10:00:00',NULL);
INSERT INTO `users` VALUES (4,'backup_admin@company.com','$2b$12$yNlLdDVfnXrATk9NHUVI1tu5r6iRSVOQBoJiVhucBugKVPzDCwBFL','user','ak_1e6c50e73fa20460','2023-05-04 10:12:00',NULL);
INSERT INTO `users` VALUES (5,'root@example.org','$2b$12$s6vomMf5ottjzR2p4q/s0LT82as3IJPd9E6CR1zlJtijK.YsfrXnQ','user','ak_c550bde1a8fbf49b','2023-05-23 10:16:00',NULL);
INSERT INTO `users` VALUES (6,'jane.smith@corp.net','$2b$12$.0sT68IYyIlO3opHJrxoFujM5rJSmvBq1HkTaju2sAHEwVrGeNz9X','user','ak_7f4589f9515adde5','2023-08-23 10:18:00',NULL);

--
-- Table structure for table `products`
--

CREATE TABLE `products` (
  `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=6655;

--
-- Dumping data for table `products`
--


