Index: lams_common/db/sql/create_lams_11_tables.sql =================================================================== diff -u -rc989378786b026ab4d78cd8064eaa6d7e63c4db6 -r192608ebab727b612fcc5bff809846856509a2df --- lams_common/db/sql/create_lams_11_tables.sql (.../create_lams_11_tables.sql) (revision c989378786b026ab4d78cd8064eaa6d7e63c4db6) +++ lams_common/db/sql/create_lams_11_tables.sql (.../create_lams_11_tables.sql) (revision 192608ebab727b612fcc5bff809846856509a2df) @@ -656,7 +656,6 @@ , 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) @@ -671,7 +670,6 @@ , 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; Index: lams_common/src/java/org/lamsfoundation/lams/dbupdates/patch02040006.sql =================================================================== diff -u -rc989378786b026ab4d78cd8064eaa6d7e63c4db6 -r192608ebab727b612fcc5bff809846856509a2df --- lams_common/src/java/org/lamsfoundation/lams/dbupdates/patch02040006.sql (.../patch02040006.sql) (revision c989378786b026ab4d78cd8064eaa6d7e63c4db6) +++ lams_common/src/java/org/lamsfoundation/lams/dbupdates/patch02040006.sql (.../patch02040006.sql) (revision 192608ebab727b612fcc5bff809846856509a2df) @@ -121,6 +121,8 @@ , PRIMARY KEY (lesson_id,preceding_lesson_id) )TYPE=InnoDB; +ALTER TABLE lams_lesson DROP COLUMN release_date; + COMMIT; SET AUTOCOMMIT = 1; set FOREIGN_KEY_CHECKS = 1; Index: lams_common/src/java/org/lamsfoundation/lams/lesson/Lesson.java =================================================================== diff -u -r6950295e2d5e90ffae268faeae946718654ddc7b -r192608ebab727b612fcc5bff809846856509a2df --- lams_common/src/java/org/lamsfoundation/lams/lesson/Lesson.java (.../Lesson.java) (revision 6950295e2d5e90ffae268faeae946718654ddc7b) +++ lams_common/src/java/org/lamsfoundation/lams/lesson/Lesson.java (.../Lesson.java) (revision 192608ebab727b612fcc5bff809846856509a2df) @@ -148,8 +148,6 @@ /** Persistent field. Defaults to FALSE if not set to anything by a constructor parameter. */ private Boolean marksReleased; - private Date releaseDate; - /** * For lesson conditional release */ @@ -700,18 +698,6 @@ this.marksReleased = marksReleased; } - /** - * @hibernate.property type="java.util.Date" column="release_date" - * - */ - public Date getReleaseDate() { - return releaseDate; - } - - public void setReleaseDate(Date releaseDate) { - this.releaseDate = releaseDate; - } - public Set getPrecedingLessons() { return precedingLessons; }