perfsonar development work

Author: psnc.pikusa
Date: 2011-07-29 15:42:38 +0100 (Fri, 29 Jul 2011)
New Revision: 5816

Added:
   trunk/perfsonar-java-rrd-sql-ma/conf/test_rrdma_db.sql
Log:
Data file related to backend transition

Added: trunk/perfsonar-java-rrd-sql-ma/conf/test_rrdma_db.sql
===================================================================
--- trunk/perfsonar-java-rrd-sql-ma/conf/test_rrdma_db.sql                    
          (rev 0)
+++ trunk/perfsonar-java-rrd-sql-ma/conf/test_rrdma_db.sql      2011-07-29 
14:42:38 UTC (rev 5816)
@@ -0,0 +1,55 @@
+# running:
+# mysql -u root -p < test_rrdma_db.sql
+
+DROP  DATABASE IF EXISTS tests2;
+
+CREATE DATABASE
+    tests2;
+
+USE tests2
+
+
+CREATE TABLE
+   interfaces
+   (metadataId INT NOT NULL AUTO_INCREMENT,
+       subjId VARCHAR(20) NOT NULL,
+        hostName VARCHAR(20) NOT NULL,
+        ifAddress VARCHAR(20) NOT NULL,
+        ifAddressType VARCHAR(4) NOT NULL,
+        ifName VARCHAR(100) NOT NULL,
+        ifDescription VARCHAR(255) NOT NULL,
+        direction VARCHAR(20) NOT NULL,
+        capacity VARCHAR(20) NOT NULL,
+        keyword VARCHAR(100),
+        eventType VARCHAR(100) NOT NULL,
+        file VARCHAR(100) NOT NULL,
+        dataSource VARCHAR(20) NOT NULL,
+        valueUnits VARCHAR(20) NOT NULL,
+        dataSourceStep VARCHAR(20),
+        dataSourceType VARCHAR(20),
+        dataSourceHeartbeat VARCHAR(20), 
+        dataSourceMinValue VARCHAR(20),
+        dataSourceMaxValue VARCHAR(20),
+        PRIMARY KEY (metadataId));
+        
+
+
+INSERT
+       INTO interfaces
+       VALUES (NULL, 'subj1',  'test-hostName1', 
'10.1.2.1','ipv4','TenGigabitEthernet1/1', 'test1', 'in',
+'1000BaseT','first', 'http://ggf.org/ns/nmwg/characteristic/utilization/2.0',
+       
'/usr/lib/perfsonar/services/perfsonar-java-rrd-ma/WEB-INF/samples/rrd/test.rrd',
+'inoctets', 'Bps', '300', 'ABSOLUTE','100', '0', '10000000');
+
+INSERT
+       INTO interfaces
+       VALUES (NULL, 'subj1',  'test-hostName2', 
'10.1.2.2','ipv4','TenGigabitEthernet1/1', 'test2', 'in',
+'1000BaseT','', 'http://ggf.org/ns/nmwg/characteristic/utilization/2.0',
+       
'/usr/lib/perfsonar/services/perfsonar-java-rrd-ma/WEB-INF/samples/rrd/test.rrd',
+'inoctets', 'Bps', '300', 'ABSOLUTE','100', '0', '10000000');
+INSERT
+       INTO interfaces
+       VALUES (NULL, 'subj1',  'test-hostName3', '10.1.2.3','ipv4', 
'TenGigabitEthernet1/1','test3', 'in',
+'1000BaseT','', 'http://ggf.org/ns/nmwg/characteristic/errors/2.0',
+       
'/usr/lib/perfsonar/services/perfsonar-java-rrd-ma/WEB-INF/samples/rrd/test.rrd',
+'inoctets', 'Bps', '300', 'ABSOLUTE','100', '0', '10000000');