Index: lams_common/src/java/org/lamsfoundation/lams/dbupdates/patch0013_updateFrom21.sql
===================================================================
RCS file: /usr/local/cvsroot/lams_common/src/java/org/lamsfoundation/lams/dbupdates/patch0013_updateFrom21.sql,v
diff -u -r1.1 -r1.2
--- lams_common/src/java/org/lamsfoundation/lams/dbupdates/patch0013_updateFrom21.sql	19 Sep 2008 06:26:43 -0000	1.1
+++ lams_common/src/java/org/lamsfoundation/lams/dbupdates/patch0013_updateFrom21.sql	30 Sep 2008 00:03:06 -0000	1.2
@@ -1 +1,28 @@
--- SQL statements to update from LAMS 2.1/2.1.1
\ No newline at end of file
+-- SQL statements to update from LAMS 2.1/2.1.1
+
+-- LDEV1909 - Competence Editor Update Scripts ---------------------------------
+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