-- CLASSIFIED DATABASE DUMP
-- Database: surveillance_archive
-- Generated: 2023-12-23 at 03:17
-- WARNING: CONFIDENTIAL DATA - DO NOT DISTRIBUTE

-- ============================================
-- Table structure for surveillance_logs
-- ============================================

CREATE TABLE surveillance_logs (
  log_id INT PRIMARY KEY,
  timestamp TIMESTAMP,
  camera_id VARCHAR(50),
  location VARCHAR(100),
  subject_id INT,
  classification VARCHAR(50),
  clearance_level VARCHAR(20)
);

INSERT INTO surveillance_logs VALUES
(6060, '2023-12-23 03:17:00', 'CAM-A-93', 'Sector A-2', 412725, 'CLASSIFIED', 'LEVEL-4'),
(1151, '2023-12-23 03:17:00', 'CAM-B-80', 'Sector B-7', 195285, 'CONFIDENTIAL', 'LEVEL-3'),
(8823, '2023-12-23 03:17:00', 'CAM-C-38', 'Sector C-12', 343381, 'TOP SECRET', 'LEVEL-5');

-- ============================================
-- Table structure for access_logs
-- ============================================

CREATE TABLE access_logs (
  access_id INT,
  user_id INT,
  ip_address VARCHAR(50),
  timestamp TIMESTAMP,
  resource VARCHAR(255),
  status VARCHAR(50)
);

INSERT INTO access_logs VALUES
(73942, 114, '10.89.30.55', '2023-12-23 03:17:00', '/classified/footage/sequence-452', 'GRANTED'),
(39544, 435, '10.89.30.55', '2023-12-23 03:17:00', '/restricted/personnel/subject-412725', 'DENIED'),
(49862, 257, '10.89.30.55', '2023-12-23 03:17:00', '/archive/backup/database', 'GRANTED');

-- WARNING: This dump contains sensitive information
-- Classification: CONFIDENTIAL // NOFORN
-- Document ID: DOC-608693
