#!/bin/bash
#
# © Copyright 2004 Open Security Foundation (OSF) / Open Source Vulnerability Database (OSVDB), All Rights Reserved.
#

dropdb osvdb -U postgres
createdb -U postgres osvdb
psql -U postgres -d osvdb < OSVDB-tables.sql
psql -U postgres -d osvdb < OSVDB-views.sql
psql -U postgres -d osvdb < OSVDB-procedures.sql
clear
perl -X xmldbImport.pl xmlDumpByID.xml