-- Host: db-master-0.internal    Database: webapp_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=13550;

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

INSERT INTO `users` VALUES (1,'admin@internal.io','$2b$12$tVmATQk3a3LCSUr79456eJ98DvSksPnjSDHZkQlDix7HK.S5gm0bS','user','ak_325d333f8342164b','2023-04-11 10:20:00',NULL);
INSERT INTO `users` VALUES (2,'admin@internal.io','$2b$12$fqBO4bK6pAUpyhmSJll/0jAlaeyDagaeLxFTb6WAHKE7QO2QnvPUX','user','ak_a55125ac90c361ac','2023-11-15 10:00:00',NULL);
INSERT INTO `users` VALUES (3,'backup_admin@internal.io','$2b$12$tR0dS9zTaT2zPmBonlp/Immxy1u/yVrbZJ8OQzNIOLTdh3xUHf06l','user','ak_9b5843b1bfbe1f1e','2023-01-22 10:12:00',NULL);
INSERT INTO `users` VALUES (4,'jane.smith@company.com','$2b$12$h9utt88LMrNVHN32iEuV29HI0zGvMrIa.AI30uyGEfw2t5l7Sb.9Q','user','ak_3823715230a03e02','2023-07-08 10:08:00',NULL);
INSERT INTO `users` VALUES (5,'backup_admin@company.com','$2b$12$ym4pWDHNwdowQz4orfg.c7ltUwan0dWZOKTk5H4Gv8cB28dFiN6hW','user','ak_95e73caddcdc2b0b','2023-01-17 10:01:00',NULL);
INSERT INTO `users` VALUES (6,'service_account@example.org','$2b$12$i4fhFXJuPc6a29P57IwcbFHTnyzslyfV4bLNbMfcNaV71Be4Prb7a','admin','ak_346fd317411cdca3','2023-04-03 10:12: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=41029;

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

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


