@echo off
echo Please wait...Intializing database.
echo This window will close automatically.
echo .
echo .
rem ##################################################################################
rem # This is the batch file used to set up automated install of PostgreSQL on Windows
rem ##################################################################################
rem

rem Create database administrator (CREATE USER) and the database (CREATE DATABASE)
psql template1 -U ADNSDB < database_setup.txt

rem Create tables
psql adns -U ADNSDB < adnsdb_init.sql
psql adns -U ADNSDB < alarm.sql
psql adns -U ADNSDB < asid.sql
psql adns -U ADNSDB < bw.sql
psql adns -U ADNSDB < config.sql
psql adns -U ADNSDB < dataevents.sql
psql adns -U ADNSDB < email.sql
psql adns -U ADNSDB < link_type.sql
psql adns -U ADNSDB < log.sql
psql adns -U ADNSDB < monitor_non-plugin.sql
psql adns -U ADNSDB < monitor_plugin.sql
psql adns -U ADNSDB < report.sql
psql adns -U ADNSDB < rtg.sql
psql adns -U ADNSDB < user.sql
psql adns -U ADNSDB < version.sql

rem Create functions
psql adns -U ADNSDB < functions_plsql.txt
psql adns -U ADNSDB < functions_sql.txt

rem Create views
psql adns -U ADNSDB < views.sql

rem Create triggers
psql adns -U ADNSDB < triggers.txt
