-- MySQL dump 10.13  Distrib 8.0.33, for Linux (x86_64)
-- Host: node3-db.internal.net    Database: subjects_archive
-- CLASSIFIED - INTERNAL USE ONLY
-- Generated: 1999-04-11 03:17:00

SET SQL_MODE = "NO_AUTO_VALUE_ON_ZERO";
START TRANSACTION;
SET time_zone = "+00:00";

-- Table structure for table `subjects`
CREATE TABLE `subjects` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `subject_id` varchar(20) NOT NULL,
  `name` varchar(255) DEFAULT '[REDACTED]',
  `classification` enum('CONFIDENTIAL','SECRET','TOP_SECRET') NOT NULL,
  `status` enum('ACTIVE','ARCHIVED','TERMINATED','MISSING') NOT NULL,
  `last_observed` datetime DEFAULT NULL,
  `node_id` int(11) DEFAULT 3,
  `notes` text,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;

INSERT INTO `subjects` VALUES
(1, 'SUBJ-0317', '[REDACTED]', 'TOP_SECRET', 'ACTIVE', '2024-03-17 03:17:00', 3, 'Primary subject. Do not approach.'),
(2, 'SUBJ-0042', '[REDACTED]', 'SECRET', 'ARCHIVED', '2023-11-12 14:22:00', 3, 'Relocated to Node 7.'),
(3, 'SUBJ-0891', '[REDACTED]', 'CONFIDENTIAL', 'MISSING', '2024-01-05 03:17:00', 3, 'Last seen near coordinates 43.2965, 5.3698.');

-- Table structure for table `operators`
CREATE TABLE `operators` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `username` varchar(50) NOT NULL,
  `password_hash` varchar(255) NOT NULL,
  `clearance_level` int(11) NOT NULL DEFAULT 1,
  `email` varchar(255) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;

INSERT INTO `operators` VALUES
(1, 'admin', '$2y$10$xK8mNpQ2rV4bC6fH0jLiOsAtUwYzE3nM7kP9q1R5vB8cF', 5, 'admin@node3.internal.net'),
(2, 'morrison', '$2y$10$3nM7kP9q1R5vB8cF0dG2hL4iO6sA8tU0wY2zE4nM6mK', 4, 'morrison@node3.internal.net'),
(3, 'chen', '$2y$10$E2nM6mK8pQ0rV4bC7fH9jL1iOsA3tU5wY7zE9nM1kP3q', 4, 'chen@node3.internal.net');

-- WARNING: This file contains sensitive data and should be secured
-- DO NOT leave database dumps in publicly accessible directories
