Index: lams_common/conf/hibernate/mappings/org/lamsfoundation/lams/usermanagement/Organisation.hbm.xml
===================================================================
RCS file: /usr/local/cvsroot/lams_common/conf/hibernate/mappings/org/lamsfoundation/lams/usermanagement/Organisation.hbm.xml,v
diff -u -r1.8 -r1.9
--- lams_common/conf/hibernate/mappings/org/lamsfoundation/lams/usermanagement/Organisation.hbm.xml	15 Jun 2006 06:10:51 -0000	1.8
+++ lams_common/conf/hibernate/mappings/org/lamsfoundation/lams/usermanagement/Organisation.hbm.xml	19 Jun 2006 23:42:31 -0000	1.9
@@ -134,11 +134,13 @@
     <many-to-one
         name="workspace"
         class="org.lamsfoundation.lams.usermanagement.Workspace"
-        not-null="true"
+        cascade="all"
+        not-null="false"
     >
         <meta attribute="field-description">
            @hibernate.many-to-one
-            not-null="true"
+			cascade="all"
+            not-null="false"
            @hibernate.column name="workspace_id"         
         </meta>
         <column name="workspace_id" />
Index: lams_common/conf/hibernate/mappings/org/lamsfoundation/lams/usermanagement/Workspace.hbm.xml
===================================================================
RCS file: /usr/local/cvsroot/lams_common/conf/hibernate/mappings/org/lamsfoundation/lams/usermanagement/Attic/Workspace.hbm.xml,v
diff -u -r1.7 -r1.8
--- lams_common/conf/hibernate/mappings/org/lamsfoundation/lams/usermanagement/Workspace.hbm.xml	18 Jun 2006 18:20:46 -0000	1.7
+++ lams_common/conf/hibernate/mappings/org/lamsfoundation/lams/usermanagement/Workspace.hbm.xml	19 Jun 2006 23:42:31 -0000	1.8
@@ -102,14 +102,12 @@
         name="rootFolder"
         class="org.lamsfoundation.lams.usermanagement.WorkspaceFolder"
         not-null="true"
-        cascade="all"
         lazy="false"
     >
         <meta attribute="field-description">
            @hibernate.many-to-one
             not-null="true"
 	        lazy="false"
-	        cascade="all"
            @hibernate.column name="root_folder_id"         
         </meta>
         <column name="root_folder_id" />
Index: lams_common/conf/hibernate/mappings/org/lamsfoundation/lams/usermanagement/WorkspaceFolder.hbm.xml
===================================================================
RCS file: /usr/local/cvsroot/lams_common/conf/hibernate/mappings/org/lamsfoundation/lams/usermanagement/WorkspaceFolder.hbm.xml,v
diff -u -r1.6 -r1.7
--- lams_common/conf/hibernate/mappings/org/lamsfoundation/lams/usermanagement/WorkspaceFolder.hbm.xml	3 Apr 2006 05:50:18 -0000	1.6
+++ lams_common/conf/hibernate/mappings/org/lamsfoundation/lams/usermanagement/WorkspaceFolder.hbm.xml	19 Jun 2006 23:42:31 -0000	1.7
@@ -84,7 +84,7 @@
   
     <!-- bi-directional one-to-many association to Workspace -->
     <set
-        name="workspaces"
+        name="workspacesByRootFolder"
         lazy="true"
         inverse="true"
 		cascade="none"
@@ -108,6 +108,32 @@
             class="org.lamsfoundation.lams.usermanagement.Workspace"
         />
     </set>
+    <!-- bi-directional one-to-many association to Workspace -->
+    <set
+        name="workspacesBySequenceFolder"
+        lazy="true"
+        inverse="true"
+		cascade="none"
+    >
+        <meta attribute="field-description">
+           @hibernate.set
+            lazy="true"
+            inverse="true"
+            cascade="none"
+
+           @hibernate.collection-key
+            column="def_run_seq_fld_id"
+
+           @hibernate.collection-one-to-many
+            class="org.lamsfoundation.lams.usermanagement.Workspace"
+        </meta>
+        <key>
+            <column name="def_run_seq_fld_id" />
+        </key>
+        <one-to-many 
+            class="org.lamsfoundation.lams.usermanagement.Workspace"
+        />
+    </set>
     <!-- bi-directional one-to-many association to WorkspaceFolder -->
     <set
         name="childWorkspaceFolders"
Index: lams_common/src/java/org/lamsfoundation/lams/usermanagement/Organisation.java
===================================================================
RCS file: /usr/local/cvsroot/lams_common/src/java/org/lamsfoundation/lams/usermanagement/Organisation.java,v
diff -u -r1.9 -r1.10
--- lams_common/src/java/org/lamsfoundation/lams/usermanagement/Organisation.java	2 Jun 2006 04:09:56 -0000	1.9
+++ lams_common/src/java/org/lamsfoundation/lams/usermanagement/Organisation.java	19 Jun 2006 23:42:31 -0000	1.10
@@ -201,7 +201,8 @@
 
     /** 
      *            @hibernate.many-to-one
-     *             not-null="true"
+     *             cascade="all"
+     *             not-null="false"
      *            @hibernate.column name="workspace_id"         
      *         
      */
@@ -216,7 +217,6 @@
     /** 
      *            @hibernate.many-to-one
      *             not-null="true"
-     *            @hibernate.column name="organisation_type_id"         
      *         
      */
     public OrganisationType getOrganisationType() {
Index: lams_common/src/java/org/lamsfoundation/lams/usermanagement/Workspace.java
===================================================================
RCS file: /usr/local/cvsroot/lams_common/src/java/org/lamsfoundation/lams/usermanagement/Attic/Workspace.java,v
diff -u -r1.10 -r1.11
--- lams_common/src/java/org/lamsfoundation/lams/usermanagement/Workspace.java	18 Jun 2006 18:20:46 -0000	1.10
+++ lams_common/src/java/org/lamsfoundation/lams/usermanagement/Workspace.java	19 Jun 2006 23:42:31 -0000	1.11
@@ -91,7 +91,6 @@
      *            @hibernate.many-to-one
      *             not-null="true"
      *			   lazy="false"
-     *             cascade="all"
      *            @hibernate.column name="root_folder_id"         
      *         
      */
Index: lams_common/src/java/org/lamsfoundation/lams/usermanagement/WorkspaceFolder.java
===================================================================
RCS file: /usr/local/cvsroot/lams_common/src/java/org/lamsfoundation/lams/usermanagement/WorkspaceFolder.java,v
diff -u -r1.11 -r1.12
--- lams_common/src/java/org/lamsfoundation/lams/usermanagement/WorkspaceFolder.java	12 May 2006 05:39:40 -0000	1.11
+++ lams_common/src/java/org/lamsfoundation/lams/usermanagement/WorkspaceFolder.java	19 Jun 2006 23:42:31 -0000	1.12
@@ -68,9 +68,12 @@
     private WorkspaceFolder parentWorkspaceFolder;
 
     /** persistent field */
-    private Set workspaces;
+    private Set workspacesByRootFolder;
 
     /** persistent field */
+    private Set workspacesBySequenceFolder;
+
+    /** persistent field */
     private Set childWorkspaceFolders;
     
     private Set learningDesigns;
@@ -143,10 +146,10 @@
 		this.learningDesigns = learningDesigns;
 	}
     /** full constructor */
-    public WorkspaceFolder(String name, WorkspaceFolder parentWorkspaceFolder, Set workspaces, Set childWorkspaceFolders) {
+    public WorkspaceFolder(String name, WorkspaceFolder parentWorkspaceFolder, Set workspacesByRootFolder, Set childWorkspaceFolders) {
         this.name = name;    
         this.parentWorkspaceFolder = parentWorkspaceFolder;
-        this.workspaces = workspaces;
+        this.workspacesByRootFolder = workspacesByRootFolder;
         this.childWorkspaceFolders = childWorkspaceFolders;
     }
 
@@ -207,12 +210,12 @@
      *             class="org.lamsfoundation.lams.usermanagement.Workspace"
      *         
      */
-    public Set getWorkspaces() {
-        return this.workspaces;
+    public Set getWorkspacesByRootFolder() {
+        return this.workspacesByRootFolder;
     }
 
-    public void setWorkspaces(Set workspaces) {
-        this.workspaces = workspaces;
+    public void setWorkspacesByRootFolder(Set workspacesByRootFolder) {
+        this.workspacesByRootFolder = workspacesByRootFolder;
     }
 
     /** 
@@ -221,6 +224,25 @@
      *             inverse="true"
      *             cascade="none"
      *            @hibernate.collection-key
+     *             column="def_run_seq_fld_id"
+     *            @hibernate.collection-one-to-many
+     *             class="org.lamsfoundation.lams.usermanagement.Workspace"
+     *         
+     */
+    public Set getWorkspacesBySequenceFolder() {
+		return workspacesBySequenceFolder;
+	}
+
+	public void setWorkspacesBySequenceFolder(Set workspacesBySequenceFolder) {
+		this.workspacesBySequenceFolder = workspacesBySequenceFolder;
+	}
+
+	/** 
+     *            @hibernate.set
+     *             lazy="true"
+     *             inverse="true"
+     *             cascade="none"
+     *            @hibernate.collection-key
      *             column="parent_folder_id"
      *            @hibernate.collection-one-to-many
      *             class="org.lamsfoundation.lams.usermanagement.WorkspaceFolder"