/
hed1ad
/
CloudGuard_API_Security_Platform
Обзор
Документация
Войти
/
hed1ad
/
CloudGuard_API_Security_Platform
Код
Запросы
0
Задачи
Вики
Пакеты
0
Релизы
0
CI/CD
Аналитика
Безопасность
master
database/init.sql
47 строк
2 KB
hed1ad
fixs [bug] Время скана неправильное
29 окт 2025, 22:04
29 окт 2025, 22:04
0cd8474
Код
Авторство
О чём код?
-- API Security Scanner Database Initialization -- Create UUID extension if not exists CREATE EXTENSION IF NOT EXISTS "uuid-ossp"; -- Create enum types DO $$ BEGIN CREATE TYPE scan_status AS ENUM ('queued', 'running', 'completed', 'failed'); EXCEPTION WHEN duplicate_object THEN null; END $$; DO $$ BEGIN CREATE TYPE vulnerability_severity AS ENUM ('CRITICAL', 'HIGH', 'MEDIUM', 'LOW'); EXCEPTION WHEN duplicate_object THEN null; END $$; -- Create scans table CREATE TABLE IF NOT EXISTS scans ( id UUID PRIMARY KEY DEFAULT uuid_generate_v4(), target_url VARCHAR(500) NOT NULL, status scan_status NOT NULL DEFAULT 'queued', created_at TIMESTAMPTZ NOT NULL DEFAULT NOW(), started_at TIMESTAMPTZ, completed_at TIMESTAMPTZ, error_message TEXT ); -- Create vulnerabilities table CREATE TABLE IF NOT EXISTS vulnerabilities ( id UUID PRIMARY KEY DEFAULT uuid_generate_v4(), scan_id UUID NOT NULL REFERENCES scans(id) ON DELETE CASCADE, type VARCHAR(100) NOT NULL, severity vulnerability_severity NOT NULL, endpoint VARCHAR(500) NOT NULL, method VARCHAR(10) NOT NULL DEFAULT 'GET', description TEXT, evidence JSONB, created_at TIMESTAMPTZ NOT NULL DEFAULT NOW() ); -- Create indexes for better performance CREATE INDEX IF NOT EXISTS idx_scans_status ON scans(status); CREATE INDEX IF NOT EXISTS idx_scans_created_at ON scans(created_at DESC); CREATE INDEX IF NOT EXISTS idx_vulnerabilities_scan_id ON vulnerabilities(scan_id); CREATE INDEX IF NOT EXISTS idx_vulnerabilities_severity ON vulnerabilities(severity);