Index: lams_tool_nb/conf/hibernate/mapping/org/lamsfoundation/lams/tool/noticeboard/NoticeboardAttachment.hbm.xml
===================================================================
RCS file: /usr/local/cvsroot/lams_tool_nb/conf/hibernate/mapping/org/lamsfoundation/lams/tool/noticeboard/Attic/NoticeboardAttachment.hbm.xml,v
diff -u -r1.1 -r1.2
--- lams_tool_nb/conf/hibernate/mapping/org/lamsfoundation/lams/tool/noticeboard/NoticeboardAttachment.hbm.xml	28 Jul 2005 07:09:08 -0000	1.1
+++ lams_tool_nb/conf/hibernate/mapping/org/lamsfoundation/lams/tool/noticeboard/NoticeboardAttachment.hbm.xml	29 Jul 2005 04:33:42 -0000	1.2
@@ -54,14 +54,12 @@
         name="uuid"
         type="java.lang.Long"
         column="uuid"
-        not-null="true"
         length="20"
     >
         <meta attribute="field-description">
            @hibernate.property
             column="uuid"
             length="20"
-            not-null="true"
         </meta>    
     </property>
     <property
@@ -77,23 +75,23 @@
         </meta>    
     </property>
     <property
-        name="isOnline"
+        name="onlineFile"
         type="boolean"
-        column="is_online"
+        column="online_file"
         not-null="true"
         length="1"
     >
         <meta attribute="field-description">
            @hibernate.property
-            column="is_online"
+            column="online_file"
             length="1"
             not-null="true"
         </meta>    
     </property>
 
     <!-- Associations -->
   
-    <!-- bi-directional many-to-one association to TlLanb11Content -->
+    <!-- bi-directional many-to-one association to NoticeboardContent -->
     <many-to-one
         name="nbContent"
         class="org.lamsfoundation.lams.tool.noticeboard.NoticeboardContent"
Index: lams_tool_nb/conf/hibernate/mapping/org/lamsfoundation/lams/tool/noticeboard/NoticeboardContent.hbm.xml
===================================================================
RCS file: /usr/local/cvsroot/lams_tool_nb/conf/hibernate/mapping/org/lamsfoundation/lams/tool/noticeboard/Attic/NoticeboardContent.hbm.xml,v
diff -u -r1.3 -r1.4
--- lams_tool_nb/conf/hibernate/mapping/org/lamsfoundation/lams/tool/noticeboard/NoticeboardContent.hbm.xml	5 Jul 2005 06:45:53 -0000	1.3
+++ lams_tool_nb/conf/hibernate/mapping/org/lamsfoundation/lams/tool/noticeboard/NoticeboardContent.hbm.xml	29 Jul 2005 04:33:42 -0000	1.4
@@ -203,6 +203,34 @@
             class="org.lamsfoundation.lams.tool.noticeboard.NoticeboardSession"
         />
     </set>
+    
+    <!-- bi-directional one-to-many association to TlLanb11Attachment -->
+    <set
+        name="nbAttachments"
+        lazy="true"
+        inverse="true"
+		cascade="all-delete-orphan"
+    >
+        <meta attribute="field-description">
+           @hibernate.set
+            lazy="true"
+            inverse="true"
+            cascade="all-delete-orphan"
 
+           @hibernate.collection-key
+            column="nb_content_uid"
+
+           @hibernate.collection-one-to-many
+            class="org.lamsfoundation.lams.tool.noticeboard.NoticeboardAttachment"
+        </meta>
+        <key>
+            <column name="nb_content_uid" />
+        </key>
+        <one-to-many 
+            class="org.lamsfoundation.lams.tool.noticeboard.NoticeboardAttachment"
+        />
+    </set>
+    
+
 </class>
 </hibernate-mapping>
Index: lams_tool_nb/db/sql/create_lams_tool_nb.sql
===================================================================
RCS file: /usr/local/cvsroot/lams_tool_nb/db/sql/create_lams_tool_nb.sql,v
diff -u -r1.4 -r1.5
--- lams_tool_nb/db/sql/create_lams_tool_nb.sql	28 Jul 2005 06:55:09 -0000	1.4
+++ lams_tool_nb/db/sql/create_lams_tool_nb.sql	29 Jul 2005 04:34:46 -0000	1.5
@@ -45,9 +45,9 @@
        attachment_id BIGINT(20) NOT NULL AUTO_INCREMENT
      , nb_content_uid BIGINT(20) NOT NULL
      , filename VARCHAR(50) NOT NULL
-     , uuid BIGINT(20) NOT NULL
+     , uuid BIGINT(20)
      , version_id BIGINT(20)
-     , isOnline TINYINT(1) NOT NULL
+     , online_file TINYINT(1) NOT NULL
      , PRIMARY KEY (attachment_id)
      , INDEX (nb_content_uid)
      , CONSTRAINT FK_tl_lanb11_attachment_1 FOREIGN KEY (nb_content_uid)
Index: lams_tool_nb/db/sql/init_lams_tool_nb.sql
===================================================================
RCS file: /usr/local/cvsroot/lams_tool_nb/db/sql/Attic/init_lams_tool_nb.sql,v
diff -u -r1.4 -r1.5
--- lams_tool_nb/db/sql/init_lams_tool_nb.sql	28 Jul 2005 06:55:09 -0000	1.4
+++ lams_tool_nb/db/sql/init_lams_tool_nb.sql	29 Jul 2005 04:34:46 -0000	1.5
@@ -53,9 +53,9 @@
        attachment_id BIGINT(20) NOT NULL AUTO_INCREMENT
      , nb_content_uid BIGINT(20) NOT NULL
      , filename VARCHAR(50) NOT NULL
-     , uuid BIGINT(20) NOT NULL
+     , uuid BIGINT(20) 
      , version_id BIGINT(20)
-     , isOnline TINYINT(1) NOT NULL
+     , online_file TINYINT(1) NOT NULL
      , PRIMARY KEY (attachment_id)
      , INDEX (nb_content_uid)
      , CONSTRAINT FK_tl_lanb11_attachment_1 FOREIGN KEY (nb_content_uid)
Index: lams_tool_nb/db/sql/lams_tool_nb.sql
===================================================================
RCS file: /usr/local/cvsroot/lams_tool_nb/db/sql/Attic/lams_tool_nb.sql,v
diff -u -r1.2 -r1.3
Binary files differ