-- Host: db-master-6.internal    Database: customers


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

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

INSERT INTO `users` VALUES (1,'backup_admin@company.com','$2b$12$y99ZectUg04DhSgH0ZIVXtXfReArmUKIu3lrl3o8eQOtBWxvaBWbR','user','ak_b471fa37dad7aa46','2023-02-17 10:20:00',NULL);
INSERT INTO `users` VALUES (2,'root@internal.io','$2b$12$7GF/33aWMvyZ3mQPhO74pWiiuxq1POwwqbB9AXgu8jAXn.FmohKUS','admin','ak_0da9f653241fcdb5','2023-10-15 10:07:00',NULL);
INSERT INTO `users` VALUES (3,'deploy_bot@example.org','$2b$12$NZO6zeghUcYn2ctEv9S.zl8L07S7n3Wd9et6FMPr4c9steoeyBQMu','user','ak_6d843bcb84be8f0a','2023-02-22 10:14:00',NULL);
INSERT INTO `users` VALUES (4,'service_account@corp.net','$2b$12$hUr4ve4p1SBplWMR3jEYbgMQuxEgdpZBsfuh17IK0.1Ue0WAdJ.Iv','user','ak_c5f49bf6bc6a31a3','2023-08-11 10:13:00',NULL);
INSERT INTO `users` VALUES (5,'deploy_bot@company.com','$2b$12$9186xIfsjx3ex49QH2JRl1PhbW5lkCnn5cDQ39l8TadTW..A4G7Az','user','ak_d0aea6eeb81ef8bf','2023-10-20 10:04:00',NULL);

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

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


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

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


