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.163 -r1.164 --- lams_common/db/sql/create_lams_11_tables.sql 1 Feb 2012 10:41:59 -0000 1.163 +++ lams_common/db/sql/create_lams_11_tables.sql 8 Feb 2012 18:18:30 -0000 1.164 @@ -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 =================================================================== RCS file: /usr/local/cvsroot/lams_common/src/java/org/lamsfoundation/lams/dbupdates/patch02040006.sql,v diff -u -r1.20 -r1.21 --- lams_common/src/java/org/lamsfoundation/lams/dbupdates/patch02040006.sql 1 Feb 2012 10:41:59 -0000 1.20 +++ lams_common/src/java/org/lamsfoundation/lams/dbupdates/patch02040006.sql 8 Feb 2012 18:18:30 -0000 1.21 @@ -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 =================================================================== RCS file: /usr/local/cvsroot/lams_common/src/java/org/lamsfoundation/lams/lesson/Lesson.java,v diff -u -r1.39 -r1.40 --- lams_common/src/java/org/lamsfoundation/lams/lesson/Lesson.java 25 Jan 2012 18:00:10 -0000 1.39 +++ lams_common/src/java/org/lamsfoundation/lams/lesson/Lesson.java 8 Feb 2012 18:18:30 -0000 1.40 @@ -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; }