Index: lams_admin/web/federation/federation.jsp
===================================================================
RCS file: /usr/local/cvsroot/lams_admin/web/federation/Attic/federation.jsp,v
diff -u -r1.1.2.6 -r1.1.2.7
--- lams_admin/web/federation/federation.jsp	3 Jul 2007 01:18:15 -0000	1.1.2.6
+++ lams_admin/web/federation/federation.jsp	4 Jul 2007 06:10:23 -0000	1.1.2.7
@@ -100,6 +100,7 @@
 		<th>org_id</th>
 		<th>ext_lesson_id</th>
 		<th>ext_lesson_name</th>
+		<th>lesson_state_id</th>
 	</tr>
 	<logic:notEmpty name="lessonsFromFedServers">
 	<logic:iterate name="lessonsFromFedServers" id="lesson">
@@ -109,6 +110,7 @@
 			<td><bean:write name="lesson" property="org.organisationId"/></td>
 			<td><bean:write name="lesson" property="extLessonId"/></td>
 			<td><bean:write name="lesson" property="extLessonName"/></td>
+			<td><bean:write name="lesson" property="lessonStateId"/></td>
 		</tr>
 	</logic:iterate>
 	</logic:notEmpty>
Index: lams_common/conf/hibernate/mappings/org/lamsfoundation/lams/federation/LessonFederation.hbm.xml
===================================================================
RCS file: /usr/local/cvsroot/lams_common/conf/hibernate/mappings/org/lamsfoundation/lams/federation/Attic/LessonFederation.hbm.xml,v
diff -u -r1.1.2.1 -r1.1.2.2
--- lams_common/conf/hibernate/mappings/org/lamsfoundation/lams/federation/LessonFederation.hbm.xml	29 Jun 2007 06:55:31 -0000	1.1.2.1
+++ lams_common/conf/hibernate/mappings/org/lamsfoundation/lams/federation/LessonFederation.hbm.xml	4 Jul 2007 06:10:24 -0000	1.1.2.2
@@ -71,6 +71,16 @@
             not-null="true"
         />
 
+        <property
+            name="lessonStateId"
+            type="java.lang.Integer"
+            update="true"
+            insert="true"
+            column="lesson_state_id"
+            length="3"
+            not-null="true"
+        />
+
         <!--
             To add non XDoclet property mappings, create a file named
                 hibernate-properties-LessonFederation.xml
Index: lams_common/db/sql/create_sharedlesson_tables.sql
===================================================================
RCS file: /usr/local/cvsroot/lams_common/db/sql/Attic/create_sharedlesson_tables.sql,v
diff -u -r1.1.2.3 -r1.1.2.4
--- lams_common/db/sql/create_sharedlesson_tables.sql	29 Jun 2007 06:55:30 -0000	1.1.2.3
+++ lams_common/db/sql/create_sharedlesson_tables.sql	4 Jul 2007 06:10:24 -0000	1.1.2.4
@@ -35,5 +35,6 @@
   `org_id` bigint(20) NOT NULL,
   `ext_lesson_id` bigint(20) NOT NULL,
   `ext_lesson_name` varchar(255) NOT NULL,
+  `lesson_state_id` int(3) NOT NULL,
   PRIMARY KEY  (`sid`)
 ) TYPE=InnoDB;
Index: lams_common/src/java/org/lamsfoundation/lams/federation/LessonFederation.java
===================================================================
RCS file: /usr/local/cvsroot/lams_common/src/java/org/lamsfoundation/lams/federation/Attic/LessonFederation.java,v
diff -u -r1.1.2.1 -r1.1.2.2
--- lams_common/src/java/org/lamsfoundation/lams/federation/LessonFederation.java	29 Jun 2007 06:55:31 -0000	1.1.2.1
+++ lams_common/src/java/org/lamsfoundation/lams/federation/LessonFederation.java	4 Jul 2007 06:10:24 -0000	1.1.2.2
@@ -32,16 +32,20 @@
 	/** persistent field */
 	private String extLessonName;
 	
+	/** persistent field */
+	private Integer lessonStateId;
+	
 	/** default constructor */
 	public LessonFederation() {
 	}
 	
 	/** full constructor */
-	public LessonFederation(FederationServer fedServer, Organisation org, Long extLessonId, String extLessonName) {
+	public LessonFederation(FederationServer fedServer, Organisation org, Long extLessonId, String extLessonName, Integer lessonStateId) {
 		this.fedServer = fedServer;
 		this.org = org;
 		this.extLessonId = extLessonId;
 		this.extLessonName = extLessonName;
+		this.lessonStateId = lessonStateId;
 	}
 	
 	/**
@@ -113,4 +117,18 @@
 	public void setExtLessonName(String extLessonName) {
 		this.extLessonName = extLessonName;
 	}
+	
+	/**
+	 * @hibernate.property
+	 * 	column="lesson_state_id"
+	 * 	length="3"
+	 * 	not-null="true"
+	 */
+	public Integer getLessonStateId() {
+		return lessonStateId;
+	}
+	
+	public void setLessonStateId(Integer lessonStateId) {
+		this.lessonStateId = lessonStateId;
+	}
 }