$PERFSONAR/psql-sqlma-dbremove.sql

From GEANT2-JRA1 Wiki

-- $Id: psql-sqlma-dbremove.sql 1540 2006-08-11 10:19:44 +0000 (Fri, 11 Aug 2006) roman $
-- project: perfSONAR
-- author: romradz
 
-- SQL Measurement Archive (MA)
-- sql script for postgresql db
 
 
-- running:
-- psql -f psql-sqlma-dbremove.conf
 
 
-- perfsonar_ma user
 
\c perfsonar_ma perfsonar_ma
 
DROP TRIGGER trigger1 ON perfsonar_utilization;
 
DROP TABLE perfsonar_utilization;
 
DROP TABLE domain_link;
 
DROP TABLE interdomain_link;
 
 
-- root (postgres) user
 
\c perfsonar_ma postgres
 
DROP FUNCTION fun1();
 
DROP LANGUAGE plpgsql;
 
\c postgres postgres
 
DROP DATABASE perfsonar_ma;
 
DROP role perfsonar_ma;