perfsonar development work

Author: psnc.pikusa
Date: 2011-10-04 16:19:17 +0100 (Tue, 04 Oct 2011)
New Revision: 5840

Modified:
   trunk/perfsonar-java-sql-ma/conf/mysql-sqlma-dbupdate-owamp.sql
Log:
INSERT implemented

Modified: trunk/perfsonar-java-sql-ma/conf/mysql-sqlma-dbupdate-owamp.sql
===================================================================
--- trunk/perfsonar-java-sql-ma/conf/mysql-sqlma-dbupdate-owamp.sql     
2011-10-04 12:59:19 UTC (rev 5839)
+++ trunk/perfsonar-java-sql-ma/conf/mysql-sqlma-dbupdate-owamp.sql     
2011-10-04 15:19:17 UTC (rev 5840)
@@ -1,4 +1,4 @@
-$Id : mysql-sqlma-dbupdate.sql
+#$Id : mysql-sqlma-dbupdate-owamp.sql
 #project: perfsonar
 #author: Piotr Pikusa
 
@@ -6,14 +6,13 @@
 # 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
+# mysql -u root -p < /etc/mysql-sqlma-dbupdate-owamp.sql
 
-
 USE perfsonar_ma
 
-############### Create table for OWAMP data ################
+# Create table for OWAMP data
 CREATE TABLE
-        clmp_owamp
+        owamp
            (metadataId VARCHAR(255)  NOT NULL,
             receiveSynchronized INT(1)  NULL DEFAULT 0,
             receiveTime VARCHAR(21) NOT NULL,
@@ -22,9 +21,14 @@
             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());
 
 
+            
+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);