perfsonar development work

Author: psnc.pikusa
Date: 2011-10-05 21:19:32 +0100 (Wed, 05 Oct 2011)
New Revision: 5870

Added:
   trunk/perfsonar-java-sql-ma/conf/mysql-sqlma-dbupdate-owamp_v2.sql
Log:
Second version of update db script

Added: trunk/perfsonar-java-sql-ma/conf/mysql-sqlma-dbupdate-owamp_v2.sql
===================================================================
--- trunk/perfsonar-java-sql-ma/conf/mysql-sqlma-dbupdate-owamp_v2.sql        
                  (rev 0)
+++ trunk/perfsonar-java-sql-ma/conf/mysql-sqlma-dbupdate-owamp_v2.sql  
2011-10-05 20:19:32 UTC (rev 5870)
@@ -0,0 +1,56 @@
+#$Id : mysql-sqlma-dbupdate-owamp.sql
+#project: perfsonar
+#author: Piotr Pikusa
+
+# SQL Measurement Archive (MA)
+# sql script for upgrading mysql db. It updates db schema from the last 
stable version (not rc) to the db schema for current version
+
+# running:
+# mysql -u root -p < /etc/mysql-sqlma-dbupdate-owamp.sql
+
+USE perfsonar_ma
+
+#Create table for OWAMP data
+CREATE TABLE
+        owamp
+           (metadataId VARCHAR(255)  NOT NULL ,
+            receiveSynchronized INT(1)  NOT NULL,
+            receiveTime VARCHAR(21)  NOT NULL,
+            receiveTimeError FLOAT  NOT NULL,
+            sendSynchronized INT(1)  NOT NULL,
+            sendTime VARCHAR(21)  NOT NULL,
+            sendTimeError FLOAT  NOT NULL,
+            seqNum INTEGER  NOT NULL,
+            ttl SMALLINT NOT NULL,
+            ts TIMESTAMP DEFAULT NOW());
+            
+INSERT
+    INTO owamp
+    VALUES ('owamp-meta1', 1, '15080301494633990766', 1.00583e-06, 1, 
15080301494378967368, 4.91142e-05, 0, 243 ,default);
+INSERT
+    INTO owamp
+    VALUES ('owamp-meta1', 1, '15080301494633990766', 1.00483e-06, 1, 
15080301494378967368, 4.81142e-05, 1, 243 ,default);
+
+ CREATE TABLE
+               owamp_agg
+               (metadataId VARCHAR(255) NOT NULL,
+               sender VARCHAR(255) NOT NULL,
+               receiver VARCHAR(255) NOT NULL,
+               sent INT NOT NULL,
+               loss INT NOT NULL,
+               lostPercent FLOAT NOT NULL,
+               duplicates INT NOT NULL,
+               minDelay FLOAT NOT NULL,
+               medDelay FLOAT NOT NULL,
+               maxDelay FLOAT NOT NULL,
+               delayUnits VARCHAR(10) NOT NULL,
+               error FLOAT NOT NULL,
+               errorUnits VARCHAR (10) NOT NULL,
+               jitter FLOAT NULL NOT NULL,
+               jitterUnits VARCHAR(10) NOT NULL,
+               hops INT NOT NULL,
+               ts TIMESTAMP DEFAULT NOW());
+
+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);