---

-- Серверы
INSERT INTO servers (server_name, role, cpu_cores, ram_gb, storage_type) VALUES 
('DB-Primary', 'Database', 32, 128, 'NVMe RAID10'), ('DB-Standby', 'Database', 32, 128, 'NVMe RAID10'),
('App-1', 'Processing', 16, 64, 'SSD'), ('App-2', 'Processing', 16, 64, 'SSD'),
('Web-LB', 'Load Balancer', 8, 16, 'SSD'), ('Auth-Srv', 'Security', 8, 32, 'SSD'),
('Backup-Srv', 'Backup', 16, 32, 'HDD RAID6'), ('Log-Srv', 'Logs', 4, 16, 'HDD'),
('Monitor-Node', 'Monitoring', 4, 8, 'SSD'), ('Dev-Srv', 'Development', 8, 32, 'SSD');

-- Сетевые узлы
INSERT INTO network_nodes (server_id, ip_address, vlan_id, subnet_mask) 
SELECT id, '192.168.10.' || (id + 10), 100, '255.255.255.0' FROM servers;

-- Мониторинг
INSERT INTO monitoring_metrics (server_id, cpu_usage_pct, mem_usage_pct) VALUES 
(1, 40, 65), (2, 5, 12), (3, 55, 48), (4, 52, 50), (5, 20, 15), (6, 15, 25), (7, 5, 5), (8, 12, 30), (9, 10, 15), (10, 30, 40);

-- Трафик
INSERT INTO traffic_stats (source_node_id, bytes_sent, bytes_received) VALUES 
(1, 5000000000, 2000000000), (2, 1000000, 5000000000), (3, 3000000000, 3000000000), (4, 2900000000, 3100000000),
(5, 800000000, 800000000), (6, 400000000, 100000000), (7, 50000000, 4500000000), (8, 200000000, 50000000),
(9, 10000000, 10000000), (10, 500000000, 200000000);

-- Бэкапы
INSERT INTO backup_logs (server_id, backup_status, storage_usage_gb) VALUES 
(1, 'Success', 450.2), (2, 'Success', 450.2), (3, 'Success', 20.5), (4, 'Success', 21.0),
(1, 'Success', 455.0), (6, 'Success', 5.5), (5, 'Success', 2.0), (10, 'Success', 15.0),
(7, 'Success', 2500.0), (1, 'Success', 460.1);