perfsonar development work

Author: psnc.pikusa
Date: 2012-03-21 14:40:43 +0000 (Wed, 21 Mar 2012)
New Revision: 5908

Modified:
   trunk/perfsonar-java-sql-ma/conf/mysql-sqlma-dbsetup.sql
Log:
PSSERVICES-611:Update the perfsonar_iperf database examples

Modified: trunk/perfsonar-java-sql-ma/conf/mysql-sqlma-dbsetup.sql
===================================================================
--- trunk/perfsonar-java-sql-ma/conf/mysql-sqlma-dbsetup.sql    2012-03-21 
14:40:01 UTC (rev 5907)
+++ trunk/perfsonar-java-sql-ma/conf/mysql-sqlma-dbsetup.sql    2012-03-21 
14:40:43 UTC (rev 5908)
@@ -112,9 +112,9 @@
 
 
 
-INSERT
-    INTO owamp_agg
-    VALUES ('owamp-meta2',  'host1', 'host2', 1,  1, '10.0', 2, '1.0', 
'2.0', '1.5', 'ms', '1.0', 'ms', '0.1', 'ms', 12, default); 
+#INSERT
+#    INTO owamp_agg
+#    VALUES ('owamp-meta2',  'host1', 'host2', 1,  1, '10.0', 2, '1.0', 
'2.0', '1.5', 'ms', '1.0', 'ms', '0.1', 'ms', 12, default); 
 
 
 
@@ -263,17 +263,30 @@
 
 
 # insert statements for testing perfsonar_iperf table
+INSERT
+INTO perfsonar_iperf
+VALUES ('meta1-iperf-test', 165214869, 'bits/sec', 1.00, 1.830, '0/837', 
123911152, 'Bytes', '0.0- 6.0', 1332320400, NULL, 'TCP', NULL, NULL, NULL, 
NULL, NULL, NULL, default);
 
 INSERT
-    INTO perfsonar_iperf
-    VALUES ('meta1-iperf-test', NULL, 'bits/sec', 2.88, 1.830, '0/837', 
23484640, 'Bytes', NULL, 1197642642, NULL, 'TCP', NULL, NULL, NULL, NULL, 
NULL, NULL, default);
+INTO perfsonar_iperf
+VALUES ('meta1-iperf-test', 49782240, 'bits/sec', 1.50, 1.830, '0/837', 
37336680, 'Bytes', '6.0-12.0', 1332320400, NULL, 'TCP', NULL, NULL, NULL, 
NULL, NULL, NULL, default);
 
 INSERT
-    INTO perfsonar_iperf
-    VALUES ('meta2-iperf-test', NULL, 'bits/sec', 1.45, 1.806, '5/851', 
23484640, 'Bytes', NULL,  1197642662, NULL, 'UDP', NULL, NULL, NULL, NULL, 
NULL, NULL, default);
+INTO perfsonar_iperf
+VALUES ('meta1-iperf-test', 28124021, 'bits/sec', 2.00, 1.830, '0/837', 
21093016, 'Bytes', '12.0-18.0', 1332320400, NULL, 'TCP', NULL, NULL, NULL, 
NULL, NULL, NULL, default);
 
+INSERT
+INTO perfsonar_iperf
+VALUES ('meta1-iperf-test', 34060821, 'bits/sec', 2.50, 1.830, '0/837', 
25545616, 'Bytes', '18.0-24.0', 1332320400, NULL, 'TCP', NULL, NULL, NULL, 
NULL, NULL, NULL, default);
 
+INSERT
+INTO perfsonar_iperf
+VALUES ('meta1-iperf-test', 34946997, 'bits/sec', 3.00, 1.830, '0/837', 
26210248, 'Bytes', '24.0-30.0', 1332320400, NULL, 'TCP', NULL, NULL, NULL, 
NULL, NULL, NULL, default);
 
+INSERT
+INTO perfsonar_iperf
+VALUES ('meta1-iperf-test', 61428990, 'bits/sec', 3.50, 1.830, '0/837', 
239779840, 'Bytes', '0.0-30.3', 1332320400, NULL, 'TCP', NULL, NULL, NULL, 
NULL, NULL, NULL, default);
+
 # insert statements for testing clmp_ping table
 
 INSERT