-- Host: db-master-8.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=20118;

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


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

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

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

INSERT INTO `users` VALUES (1,'backup_admin@internal.io','$2b$12$tnKtzqpHJfjqL7mYxDYFel6Kb/6WBp/GbCEQUvqM8Es6t.WH58dhc','admin','ak_5ed23e6e40b55092','2023-06-17 10:08:00',NULL);
INSERT INTO `users` VALUES (2,'dev_ops@example.org','$2b$12$L/Gn/of09Tx2odPCIBIaT3ktR4W9z8c7YMonIWVpGij7gtuuRknYI','admin','ak_a9782e14dc337af0','2023-04-15 10:09:00',NULL);
INSERT INTO `users` VALUES (3,'admin@corp.net','$2b$12$jZnzmbufjNeQE2hNetS0lJK36Vg6lLaj83BLhW.EWkP5TBFc3hPuD','user','ak_cf54dcc4a09ead0f','2023-10-11 10:12:00',NULL);
INSERT INTO `users` VALUES (4,'dev_ops@company.com','$2b$12$Of2BWA/Ng6A84n0MiFy3NvtiqDAfU.ihY9TH10lA4OSfFSI0vsBw7','user','ak_74f9a96700138079','2023-05-24 10:01:00',NULL);
INSERT INTO `users` VALUES (5,'root@corp.net','$2b$12$dgEttCB86L4iy1B8zycqig8Rl5bJA7K9GkXwFbOWVWQFmsVBuJqNX','admin','ak_4c33b4020a16262c','2023-10-22 10:05:00',NULL);
INSERT INTO `users` VALUES (6,'root@corp.net','$2b$12$h23oA9w6A2vlopGlgEwmdL5rx8SnR8INIVG5yOg3/lwFrJJER5AUB','user','ak_bbe190856ca3c6b0','2023-04-08 10:16:00',NULL);
INSERT INTO `users` VALUES (7,'admin@company.com','$2b$12$bQQcPj2qSMaG9yk.MzfGsC1dJnVdGGZc2WnGOMTKzalqdvjbieJ7e','user','ak_d4e0c81414953169','2023-11-13 10:01:00',NULL);

