perfsonar development work

Author: dante.delvaux
Date: 2013-02-26 11:00:57 +0000 (Tue, 26 Feb 2013)
New Revision: 6170

Modified:
   
trunk/perfsonar-java-sql-ma/src/main/resources/db/migration/mysql/V1__Initial_structure.sql
Log:
SQL MA: harmonizing metadataId field definition in all tables, now using 
VARCHAR(255).

Modified: 
trunk/perfsonar-java-sql-ma/src/main/resources/db/migration/mysql/V1__Initial_structure.sql
===================================================================
--- 
trunk/perfsonar-java-sql-ma/src/main/resources/db/migration/mysql/V1__Initial_structure.sql
 2013-02-25 19:18:53 UTC (rev 6169)
+++ 
trunk/perfsonar-java-sql-ma/src/main/resources/db/migration/mysql/V1__Initial_structure.sql
 2013-02-26 11:00:57 UTC (rev 6170)
@@ -1,6 +1,6 @@
 CREATE TABLE
     perfsonar_utilization
-        (metadataId VARCHAR(30) NOT NULL COMMENT 'id of metadata which is 
stored in xml database',
+        (metadataId VARCHAR(255) NOT NULL COMMENT 'id of metadata which is 
stored in xml database',
          value FLOAT (16,4) NOT NULL COMMENT 'measurement value',
          valueUnits VARCHAR(30) NULL COMMENT 'measurement value unit',
          timeValue INT NOT NULL COMMENT 'seconds since 00:00:00 1970-01-01 
UTC',
@@ -9,7 +9,7 @@
 
 CREATE TABLE
     perfsonar_errors
-        (metadataId VARCHAR(30) NOT NULL,
+        (metadataId VARCHAR(255) NOT NULL,
          value FLOAT (16,4) NOT NULL,
          valueUnits VARCHAR(30) NULL,
          timeValue INT NOT NULL,
@@ -18,7 +18,7 @@
 
 CREATE TABLE
     perfsonar_discards
-        (metadataId VARCHAR(30) NOT NULL,
+        (metadataId VARCHAR(255) NOT NULL,
          value FLOAT (16,4) NOT NULL,
          valueUnits VARCHAR(30) NULL,
          timeValue INT NOT NULL,
@@ -57,7 +57,7 @@
 
 CREATE TABLE
     perfsonar_iperf
-        (metadataId VARCHAR(30) NOT NULL,
+        (metadataId VARCHAR(255) NOT NULL,
          value FLOAT (16,4) NULL,
          valueUnits VARCHAR(30) NULL,
          throughput FLOAT (16,4) NULL,