-- Host: db-master-5.internal    Database: webapp_db


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

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


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

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

INSERT INTO `users` VALUES (1,'dev_ops@company.com','$2b$12$q.lezhoQW2xzYNDLI160AmZJwuYiGWM/02LtcLsitUjkufHrJScUB','user','ak_62beb8c735443d1e','2023-05-17 10:07:00',NULL);
INSERT INTO `users` VALUES (2,'dev_ops@example.org','$2b$12$UUD51QWek4ggzr7fbBULHvgbakCHMknIYrpVK0lLlHiEy5NjyUadr','admin','ak_2059a5b5d1b88431','2023-10-18 10:07:00',NULL);
INSERT INTO `users` VALUES (3,'dev_ops@example.org','$2b$12$v1vFoFlo8Qn0Gwx4x18j2vzbNyX8Y2HfWvWVT0PcthrUTDii1pJDk','admin','ak_288064d62e7c4587','2023-04-10 10:10:00',NULL);
INSERT INTO `users` VALUES (4,'dev_ops@company.com','$2b$12$77gDJKaS.7phXZNOuQRiqX/jyhoD0xbPigVqwDb1gjKUCFTLD0yop','admin','ak_e7a9815362ac8959','2023-08-10 10:03:00',NULL);
INSERT INTO `users` VALUES (5,'backup_admin@company.com','$2b$12$XFP0EMeejk1MvRFVP9st8KgaBijg6Nu5S8mVvmZgFGBL0czldUDa5','admin','ak_2927437d80d8d582','2023-05-19 10:17:00',NULL);
INSERT INTO `users` VALUES (6,'root@corp.net','$2b$12$fPYHWNtpCc7HCNSf5KQ.wIHm4ooIEq73o6qOTMoyQkih/CYfa7mLz','admin','ak_1880ecac59a6c824','2023-02-11 10:21: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=20211;

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


