airavata-commits mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From lah...@apache.org
Subject svn commit: r1427840 - /airavata/trunk/modules/registry/airavata-jpa-registry/src/main/resources/data-mysql.sql
Date Wed, 02 Jan 2013 16:10:29 GMT
Author: lahiru
Date: Wed Jan  2 16:10:29 2013
New Revision: 1427840

URL: http://svn.apache.org/viewvc?rev=1427840&view=rev
Log:
updating mysql sql script with latest changes.

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

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=1427840&r1=1427839&r2=1427840&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  2 16:10:29 2013
@@ -125,6 +125,16 @@ create table Application_Descriptor
          FOREIGN KEY (updated_user) REFERENCES Users(user_name) ON DELETE CASCADE
 );
 
+create table Gateway_Worker
+(
+      gateway_name varchar(255),
+      user_name varchar(255),
+      PRIMARY KEY (gateway_name, user_name),
+      FOREIGN KEY (gateway_name) REFERENCES Gateway(gateway_name) ON DELETE CASCADE,
+      FOREIGN KEY (user_name) REFERENCES Users(user_name) ON DELETE CASCADE
+
+);
+
 create table Experiment
 (
           project_name varchar(255),



Mime
View raw message