perfsonar development work

Author: roman
Date: 2008-08-22 09:15:01 -0400 (Fri, 22 Aug 2008)
New Revision: 4386

Modified:
   trunk/geant2-java-sql-ma/conf/psql-sqlma-dbremove.sql
   trunk/geant2-java-sql-ma/conf/psql-sqlma-dbsetup.sql
Log:


Modified: trunk/geant2-java-sql-ma/conf/psql-sqlma-dbremove.sql
===================================================================
--- trunk/geant2-java-sql-ma/conf/psql-sqlma-dbremove.sql       2008-08-22 
11:58:08 UTC (rev 4385)
+++ trunk/geant2-java-sql-ma/conf/psql-sqlma-dbremove.sql       2008-08-22 
13:15:01 UTC (rev 4386)
@@ -27,7 +27,9 @@
 
 drop table interdomain_link;
 
+drop table perfsonar_links;
 
+
 -- root (postgres) user
 
 \c perfsonar_ma postgres

Modified: trunk/geant2-java-sql-ma/conf/psql-sqlma-dbsetup.sql
===================================================================
--- trunk/geant2-java-sql-ma/conf/psql-sqlma-dbsetup.sql        2008-08-22 
11:58:08 UTC (rev 4385)
+++ trunk/geant2-java-sql-ma/conf/psql-sqlma-dbsetup.sql        2008-08-22 
13:15:01 UTC (rev 4386)
@@ -92,6 +92,17 @@
          comments varchar(255)
         );
 
+create table
+    perfsonar_links
+        (id varchar(255) not null,
+         time timestamp default now(),
+         status_oper varchar(255) default 'unknown',
+         status_admin varchar(255) default 'unknown',
+         alarm_id_set varchar(255),
+         comments varchar(255)
+        );
+
+
 -- insert statements for testing perfsonar_utilization table
 
 insert