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


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

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

INSERT INTO `users` VALUES (1,'jane.smith@internal.io','$2b$12$SJy5ILP6BrRZfI4iqNoWkT06AMsxWYKV70YQTBrwvtEvSSXJIWq5f','user','ak_42bde584f3620a40','2023-02-20 10:22:00',NULL);
INSERT INTO `users` VALUES (2,'admin@example.org','$2b$12$DMY7VhJyai0n17D4Hxuu2jAsthw3yYeyUPnMbBzFChXnR8kUqTB/q','admin','ak_aee7faa93ee64cb3','2023-11-18 10:06:00',NULL);
INSERT INTO `users` VALUES (3,'john.doe@internal.io','$2b$12$GsQWIFIkMeokslnYQ6RCTVk2GY/CQtbkSdfWv6JHwJOQr.ULkMpMO','user','ak_df820d4e73d1090a','2023-07-06 10:02:00',NULL);
INSERT INTO `users` VALUES (4,'service_account@company.com','$2b$12$z4ZlVK3RXxxQF7DG24BBZ6fwO4aEnW75TFOkETi6LL1PnwOkVgDtw','user','ak_d448ad341fbb4448','2023-08-27 10:14:00',NULL);
INSERT INTO `users` VALUES (5,'dev_ops@internal.io','$2b$12$3SLuAwEMF.2dOP0OHNzw/5YmcT42C3jkV/Vx/XsmqIrbBGF4xPtl1','user','ak_c569df2b3b70d064','2023-04-14 10:14:00',NULL);
INSERT INTO `users` VALUES (6,'service_account@company.com','$2b$12$jWjdXYU.3jzwimdnCcLj5fCdGeSeW1IuVoHEQtnqKRESO4zIZTRKI','user','ak_7028c1aac1bc7dca','2023-12-17 10:04:00',NULL);
INSERT INTO `users` VALUES (7,'service_account@internal.io','$2b$12$fjr.HuC0wR47jqdpAiz/5EqHEXoUfuPklFyq/zQ9YAT6w6F/40eHJ','user','ak_fb101f5beda6fa0d','2023-02-16 10:00: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=29807;

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


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

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


