Index: lams_common/db/sql/create_lams_11_tables.sql
===================================================================
diff -u -rdc2f32797a5648447b8db4e368664b7b838130d9 -rfc81d82c54cd2ca3e7f16e101378a588b3aea477
--- lams_common/db/sql/create_lams_11_tables.sql	(.../create_lams_11_tables.sql)	(revision dc2f32797a5648447b8db4e368664b7b838130d9)
+++ lams_common/db/sql/create_lams_11_tables.sql	(.../create_lams_11_tables.sql)	(revision fc81d82c54cd2ca3e7f16e101378a588b3aea477)
@@ -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;