Index: lams_common/src/java/org/lamsfoundation/lams/dbupdates/patch0015_updateFrom22.sql
===================================================================
RCS file: /usr/local/cvsroot/lams_common/src/java/org/lamsfoundation/lams/dbupdates/patch0015_updateFrom22.sql,v
diff -u -r1.13 -r1.13.2.1
--- lams_common/src/java/org/lamsfoundation/lams/dbupdates/patch0015_updateFrom22.sql	7 Apr 2009 05:23:52 -0000	1.13
+++ lams_common/src/java/org/lamsfoundation/lams/dbupdates/patch0015_updateFrom22.sql	14 Apr 2009 06:46:11 -0000	1.13.2.1
@@ -82,6 +82,40 @@
 ALTER TABLE lams_organisation ADD COLUMN enable_monitor_gradebook TINYINT(1) NOT NULL DEFAULT 0;
 ALTER TABLE lams_organisation ADD COLUMN enable_learner_gradebook TINYINT(1) NOT NULL DEFAULT 0;
 
+-- LDEV-2173 ------------ Gradebook stuff
+
+CREATE TABLE lams_gradebook_user_activity (
+	  uid BIGINT(20) NOT NULL auto_increment
+	, activity_id BIGINT(20) NOT NULL
+	, user_id BIGINT (20) NOT NULL
+	, mark DOUBLE PRECISION 
+	, feedback TEXT
+	, INDEX (activity_id, user_id)
+	, CONSTRAINT FK_lams_gradebook_user_activity_1 FOREIGN KEY (activity_id)
+                  REFERENCES lams_learning_activity (activity_id) ON DELETE CASCADE ON UPDATE CASCADE
+	, CONSTRAINT FK_lams_gradebook_user_activity_2 FOREIGN KEY (user_id)
+                  REFERENCES lams_user (user_id) ON DELETE CASCADE ON UPDATE CASCADE
+	, PRIMARY KEY (uid)
+)TYPE=InnoDB;
+
+CREATE TABLE lams_gradebook_user_lesson (
+	  uid BIGINT(20) NOT NULL auto_increment
+	, lesson_id BIGINT(20) NOT NULL
+	, user_id BIGINT (20) NOT NULL
+	, mark DOUBLE PRECISION
+	, feedback TEXT
+	, INDEX (lesson_id, user_id)
+	, CONSTRAINT FK_lams_gradebook_user_lesson_1 FOREIGN KEY (lesson_id)
+                  REFERENCES lams_lesson (lesson_id)
+	, CONSTRAINT FK_lams_gradebook_user_lesson_2 FOREIGN KEY (user_id)
+                  REFERENCES lams_user (user_id) ON DELETE CASCADE ON UPDATE CASCADE
+	, PRIMARY KEY (uid)
+)TYPE=InnoDB;
+
+
+
+
+
 ----------------------Put all sql statements above here-------------------------
 
 -- If there were no errors, commit and restore autocommit to on