You are viewing a plain text version of this content. The canonical link for it is here.
Posted to commits@airavata.apache.org by ch...@apache.org on 2013/01/23 16:23:38 UTC
svn commit: r1437462 - in /airavata/trunk/modules/registry: airavata-jpa-registry/src/main/resources/ airavata-jpa-registry/src/test/resources/ airavata-registry-test/src/test/resources/

Author: chathuri
Date: Wed Jan 23 15:23:37 2013
New Revision: 1437462

URL: http://svn.apache.org/viewvc?rev=1437462&view=rev
Log:
updating DB scripts

Modified:
    airavata/trunk/modules/registry/airavata-jpa-registry/src/main/resources/data-derby.sql
    airavata/trunk/modules/registry/airavata-jpa-registry/src/main/resources/data-mysql.sql
    airavata/trunk/modules/registry/airavata-jpa-registry/src/test/resources/data-derby.sql
    airavata/trunk/modules/registry/airavata-registry-test/src/test/resources/data-derby.sql

Modified: airavata/trunk/modules/registry/airavata-jpa-registry/src/main/resources/data-derby.sql
URL: http://svn.apache.org/viewvc/airavata/trunk/modules/registry/airavata-jpa-registry/src/main/resources/data-derby.sql?rev=1437462&r1=1437461&r2=1437462&view=diff
==============================================================================
--- airavata/trunk/modules/registry/airavata-jpa-registry/src/main/resources/data-derby.sql (original)
+++ airavata/trunk/modules/registry/airavata-jpa-registry/src/main/resources/data-derby.sql Wed Jan 23 15:23:37 2013
@@ -35,6 +35,8 @@ create table Configuration
         PRIMARY KEY(config_key, config_val, category_id)
 );
 
+INSERT INTO CONFIGURATION (config_key, config_val, expire_date, category_id) VALUES('registry.version', '0.6', CURRENT_TIMESTAMP ,'SYSTEM');
+
 create table Users
 (
         user_name varchar(255),

Modified: airavata/trunk/modules/registry/airavata-jpa-registry/src/main/resources/data-mysql.sql
URL: http://svn.apache.org/viewvc/airavata/trunk/modules/registry/airavata-jpa-registry/src/main/resources/data-mysql.sql?rev=1437462&r1=1437461&r2=1437462&view=diff
==============================================================================
--- airavata/trunk/modules/registry/airavata-jpa-registry/src/main/resources/data-mysql.sql (original)
+++ airavata/trunk/modules/registry/airavata-jpa-registry/src/main/resources/data-mysql.sql Wed Jan 23 15:23:37 2013
@@ -34,6 +34,8 @@ create table Configuration
         PRIMARY KEY(config_key, config_val, category_id)
 );
 
+INSERT INTO CONFIGURATION (config_key, config_val, expire_date, category_id) VALUES('registry.version', '0.6', CURRENT_TIMESTAMP ,'SYSTEM');
+
 create table Users
 (
         user_name varchar(255),

Modified: airavata/trunk/modules/registry/airavata-jpa-registry/src/test/resources/data-derby.sql
URL: http://svn.apache.org/viewvc/airavata/trunk/modules/registry/airavata-jpa-registry/src/test/resources/data-derby.sql?rev=1437462&r1=1437461&r2=1437462&view=diff
==============================================================================
--- airavata/trunk/modules/registry/airavata-jpa-registry/src/test/resources/data-derby.sql (original)
+++ airavata/trunk/modules/registry/airavata-jpa-registry/src/test/resources/data-derby.sql Wed Jan 23 15:23:37 2013
@@ -35,6 +35,8 @@ create table Configuration
         PRIMARY KEY(config_key, config_val, category_id)
 );
 
+CONFIGURATION (config_key, config_val, expire_date, category_id) VALUES('registry.version', '0.6', CURRENT_TIMESTAMP ,'SYSTEM');
+
 create table Users
 (
         user_name varchar(255),

Modified: airavata/trunk/modules/registry/airavata-registry-test/src/test/resources/data-derby.sql
URL: http://svn.apache.org/viewvc/airavata/trunk/modules/registry/airavata-registry-test/src/test/resources/data-derby.sql?rev=1437462&r1=1437461&r2=1437462&view=diff
==============================================================================
--- airavata/trunk/modules/registry/airavata-registry-test/src/test/resources/data-derby.sql (original)
+++ airavata/trunk/modules/registry/airavata-registry-test/src/test/resources/data-derby.sql Wed Jan 23 15:23:37 2013
@@ -35,6 +35,8 @@ create table Configuration
         PRIMARY KEY(config_key, config_val, category_id)
 );
 
+CONFIGURATION (config_key, config_val, expire_date, category_id) VALUES('registry.version', '0.6', CURRENT_TIMESTAMP ,'SYSTEM');
+
 create table Users
 (
         user_name varchar(255),