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