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),
