perfsonar development work

Author: psnc.pikusa
Date: 2011-10-04 13:59:19 +0100 (Tue, 04 Oct 2011)
New Revision: 5839

Added:
   trunk/perfsonar-java-sql-ma/conf/mysql-sqlma-dbupdate-owamp.sql
Log:
OWAMP db

Added: trunk/perfsonar-java-sql-ma/conf/mysql-sqlma-dbupdate-owamp.sql
===================================================================
--- trunk/perfsonar-java-sql-ma/conf/mysql-sqlma-dbupdate-owamp.sql           
                  (rev 0)
+++ trunk/perfsonar-java-sql-ma/conf/mysql-sqlma-dbupdate-owamp.sql     
2011-10-04 12:59:19 UTC (rev 5839)
@@ -0,0 +1,30 @@
+$Id : mysql-sqlma-dbupdate.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.sql
+
+
+USE perfsonar_ma
+
+############### Create table for OWAMP data ################
+CREATE TABLE
+        clmp_owamp
+           (metadataId VARCHAR(255)  NOT NULL,
+            receiveSynchronized INT(1)  NULL DEFAULT 0,
+            receiveTime VARCHAR(21) NOT NULL,
+            receiveTimeError FLOAT  NULL DEFAULT 0,
+            sendSynchronized INT(1)  NULL DEFAULT 0,
+            sendTime VARCHAR(21)  NOT NULL,
+            sendTimeError FLOAT  NULL DEFAULT 0,
+            seqNum INTEGER  NULL DEFAULT 0,
+            timeType VARCHAR(4)  NULL,
+            timeValue LONG  NOT NULL,
+            ttl SMALLINT(6)  NULL DEFAULT 0,
+            ts TIMESTAMP DEFAULT NOW());
+
+