Index: lams_common/conf/hibernate/mappings/org/lamsfoundation/lams/learningdesign/Activity.hbm.xml
===================================================================
RCS file: /usr/local/cvsroot/lams_common/conf/hibernate/mappings/org/lamsfoundation/lams/learningdesign/Activity.hbm.xml,v
diff -u -r1.45 -r1.46
--- lams_common/conf/hibernate/mappings/org/lamsfoundation/lams/learningdesign/Activity.hbm.xml	18 Sep 2008 02:30:14 -0000	1.45
+++ lams_common/conf/hibernate/mappings/org/lamsfoundation/lams/learningdesign/Activity.hbm.xml	19 Sep 2008 05:33:47 -0000	1.46
@@ -152,6 +152,16 @@
 				
 				<!-- needs to be lazy because each tool session contains user and
 				lesson -->
+				
+				<set name="competenceMappings" lazy="true" inverse="true" cascade="none" >
+			        <meta attribute="field-description">@hibernate.set lazy="false" inverse="true" cascade="none"
+        												@hibernate.collection-key column="competence_mapping_id"
+        										        @hibernate.collection-one-to-many class="org.lamsfoundation.lams.learningdesign.CompetenceMapping"
+			        </meta>
+			        <key><column name="activity_id" /></key>
+			        <one-to-many class="org.lamsfoundation.lams.learningdesign.CompetenceMapping"/>
+			    </set>
+				
 				<set name="toolSessions" lazy="true" inverse="true" cascade="none" >
 			        <meta attribute="field-description">@hibernate.set lazy="false" inverse="true" cascade="none"
         												@hibernate.collection-key column="tool_session_id"
@@ -160,7 +170,7 @@
 			        <key><column name="activity_id" /></key>
 			        <one-to-many class="org.lamsfoundation.lams.tool.ToolSession"/>
 			    </set>
-                 
+
                  <!-- bi-directional many-to-one association to Tool-->
                  <many-to-one name="tool" class="org.lamsfoundation.lams.tool.Tool" lazy="false" >
                  	<column name="tool_id" not-null="false"/>
Index: lams_common/conf/hibernate/mappings/org/lamsfoundation/lams/learningdesign/Competence.hbm.xml
===================================================================
RCS file: /usr/local/cvsroot/lams_common/conf/hibernate/mappings/org/lamsfoundation/lams/learningdesign/Attic/Competence.hbm.xml,v
diff -u
--- /dev/null	1 Jan 1970 00:00:00 -0000
+++ lams_common/conf/hibernate/mappings/org/lamsfoundation/lams/learningdesign/Competence.hbm.xml	19 Sep 2008 05:33:47 -0000	1.1
@@ -0,0 +1,69 @@
+<?xml version="1.0" encoding="UTF-8"?>
+
+<!DOCTYPE hibernate-mapping PUBLIC
+    "-//Hibernate/Hibernate Mapping DTD 3.0//EN" 
+    "http://hibernate.sourceforge.net/hibernate-mapping-3.0.dtd">
+
+<hibernate-mapping
+>
+    <class
+        name="org.lamsfoundation.lams.learningdesign.Competence"
+        table="lams_competence"
+    >
+
+        <id
+            name="competenceId"
+            column="competence_id"
+            type="java.lang.Long"
+        >
+            <generator class="native">
+              <!--  
+                  To add non XDoclet generator parameters, create a file named 
+                  hibernate-generator-params-Competence.xml 
+                  containing the additional parameters and place it in your merge dir. 
+              --> 
+            </generator>
+        </id>
+
+        <property
+            name="title"
+            type="java.lang.String"
+            update="true"
+            insert="true"
+            column="title"
+            length="255"
+            not-null="true"
+        />
+
+        <property
+            name="description"
+            type="java.lang.String"
+            update="true"
+            insert="true"
+            column="description"
+            length="65535"
+            not-null="false"
+        />
+
+        <many-to-one
+            name="learningDesign"
+            class="org.lamsfoundation.lams.learningdesign.LearningDesign"
+            cascade="none"
+            outer-join="auto"
+            update="true"
+            insert="true"
+        >
+            <column
+                name="learning_design_id" 
+            />
+        </many-to-one>
+
+        <!--
+            To add non XDoclet property mappings, create a file named
+                hibernate-properties-Competence.xml
+            containing the additional properties and place it in your merge dir.
+        -->
+
+    </class>
+
+</hibernate-mapping>
Index: lams_common/conf/hibernate/mappings/org/lamsfoundation/lams/learningdesign/CompetenceMapping.hbm.xml
===================================================================
RCS file: /usr/local/cvsroot/lams_common/conf/hibernate/mappings/org/lamsfoundation/lams/learningdesign/Attic/CompetenceMapping.hbm.xml,v
diff -u
--- /dev/null	1 Jan 1970 00:00:00 -0000
+++ lams_common/conf/hibernate/mappings/org/lamsfoundation/lams/learningdesign/CompetenceMapping.hbm.xml	19 Sep 2008 05:33:47 -0000	1.1
@@ -0,0 +1,62 @@
+<?xml version="1.0" encoding="UTF-8"?>
+
+<!DOCTYPE hibernate-mapping PUBLIC
+    "-//Hibernate/Hibernate Mapping DTD 3.0//EN" 
+    "http://hibernate.sourceforge.net/hibernate-mapping-3.0.dtd">
+
+<hibernate-mapping
+>
+    <class
+        name="org.lamsfoundation.lams.learningdesign.CompetenceMapping"
+        table="lams_competence_mapping"
+    >
+
+        <id
+            name="competenceMappingId"
+            column="competence_mapping_id"
+            type="java.lang.Long"
+        >
+            <generator class="native">
+              <!--  
+                  To add non XDoclet generator parameters, create a file named 
+                  hibernate-generator-params-CompetenceMapping.xml 
+                  containing the additional parameters and place it in your merge dir. 
+              --> 
+            </generator>
+        </id>
+
+        <many-to-one
+            name="competence"
+            class="org.lamsfoundation.lams.learningdesign.Competence"
+            cascade="none"
+            outer-join="auto"
+            update="true"
+            insert="true"
+        >
+            <column
+                name="competence_id" 
+            />
+        </many-to-one>
+
+        <many-to-one
+            name="toolActivity"
+            class="org.lamsfoundation.lams.learningdesign.ToolActivity"
+            cascade="none"
+            outer-join="auto"
+            update="true"
+            insert="true"
+        >
+            <column
+                name="activity_id" 
+            />
+        </many-to-one>
+
+        <!--
+            To add non XDoclet property mappings, create a file named
+                hibernate-properties-CompetenceMapping.xml
+            containing the additional properties and place it in your merge dir.
+        -->
+
+    </class>
+
+</hibernate-mapping>
Index: lams_common/conf/hibernate/mappings/org/lamsfoundation/lams/learningdesign/LearningDesign.hbm.xml
===================================================================
RCS file: /usr/local/cvsroot/lams_common/conf/hibernate/mappings/org/lamsfoundation/lams/learningdesign/LearningDesign.hbm.xml,v
diff -u -r1.17 -r1.18
--- lams_common/conf/hibernate/mappings/org/lamsfoundation/lams/learningdesign/LearningDesign.hbm.xml	9 May 2007 01:09:26 -0000	1.17
+++ lams_common/conf/hibernate/mappings/org/lamsfoundation/lams/learningdesign/LearningDesign.hbm.xml	19 Sep 2008 05:33:47 -0000	1.18
@@ -231,6 +231,11 @@
     	 <key><column name="learning_design_id" /></key>
          <one-to-many class="org.lamsfoundation.lams.learningdesign.Activity"/>
     </set>
+    
+    <set name="competences" lazy="false" inverse="true" cascade="all-delete-orphan" >
+    	 <key><column name="learning_design_id" /></key>
+         <one-to-many class="org.lamsfoundation.lams.learningdesign.Competence"/>
+    </set>
 
     <!-- bi-directional many-to-one association to the user who is editing -->
     <!-- this design as part of edit on fly. Should only be set if editOverrideLock = 1 -->
Index: lams_common/db/sql/create_lams_11_tables.sql
===================================================================
RCS file: /usr/local/cvsroot/lams_common/db/sql/create_lams_11_tables.sql,v
diff -u -r1.118 -r1.119
--- lams_common/db/sql/create_lams_11_tables.sql	16 Sep 2008 03:18:13 -0000	1.118
+++ lams_common/db/sql/create_lams_11_tables.sql	19 Sep 2008 05:33:47 -0000	1.119
@@ -1006,4 +1006,28 @@
                   REFERENCES lams_events (uid) ON DELETE CASCADE ON UPDATE CASCADE
 )TYPE=InnoDB;
 
+CREATE TABLE lams_competence (
+       competence_id BIGINT NOT NULL UNIQUE auto_increment
+     , learning_design_id BIGINT
+     , description TEXT
+     , title VARCHAR(255) 
+	 , UNIQUE KEY (learning_design_id, title)
+     , PRIMARY KEY (competence_id)
+     , CONSTRAINT LearningDesignCompetenceMap FOREIGN KEY (learning_design_id)
+                  REFERENCES lams_learning_design(learning_design_id) ON DELETE CASCADE ON UPDATE CASCADE
+)TYPE=InnoDB;
+
+CREATE TABLE lams_competence_mapping (
+       competence_mapping_id BIGINT NOT NULL UNIQUE auto_increment
+     , competence_id BIGINT
+     , activity_id BIGINT 
+     , PRIMARY KEY (competence_mapping_id)
+	 , INDEX (activity_id)
+	 , UNIQUE KEY (competence_id, activity_id)
+     , CONSTRAINT FK_lams_competence_mapping_1 FOREIGN KEY (activity_id)
+                  REFERENCES lams_learning_activity (activity_id) ON DELETE CASCADE ON UPDATE CASCADE
+	 , CONSTRAINT FK_lams_competence_mapping_2 FOREIGN KEY (competence_id)
+	                  REFERENCES lams_competence (competence_id) ON DELETE CASCADE ON UPDATE CASCADE
+)TYPE=InnoDB;
+
  
\ No newline at end of file