📦 EqualifyEverything / database

📄 child_a11yphant.sql · 15 lines
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15-- Post Creation Scripts for A11yphant

-- Import Data
    -- FROM: start_domains TO: targets.domains
    COPY targets.domains(id, domain, active)
    FROM '/var/lib/postgresql/data/start_domains.csv'
    DELIMITER ','
    CSV HEADER;

    -- FROM: start_urls TO: targets.urls
    COPY targets.urls(id, url, domain_id, is_objective)
    FROM '/var/lib/postgresql/data/start_urls.csv'
    DELIMITER ','
    CSV HEADER;