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.150 -r1.151
--- lams_common/db/sql/create_lams_11_tables.sql	3 Mar 2010 05:08:15 -0000	1.150
+++ lams_common/db/sql/create_lams_11_tables.sql	19 May 2010 00:34:49 -0000	1.151
@@ -642,6 +642,7 @@
      , locked_for_edit TINYINT DEFAULT 0
 	 , marks_released TINYINT DEFAULT 0
      , version INTEGER DEFAULT 1
+     , release_date DATETIME
      , PRIMARY KEY (lesson_id)
      , INDEX (learning_design_id)
      , CONSTRAINT FK_lams_lesson_1_1 FOREIGN KEY (learning_design_id)
@@ -656,6 +657,7 @@
      , CONSTRAINT FK_lams_lesson_4 FOREIGN KEY (lesson_state_id)
                   REFERENCES lams_lesson_state (lesson_state_id)
      , INDEX (class_grouping_id)
+     , INDEX idx_release_date (release_date)
      , CONSTRAINT FK_lams_lesson_5 FOREIGN KEY (class_grouping_id)
                   REFERENCES lams_grouping (grouping_id)
 )TYPE=InnoDB;