Index: lams_contentrepository/conf/hibernate/mappings/com/lamsinternational/lams/contentrepository/CrWorkspace.hbm.xml
===================================================================
diff -u -r3f80f42891cd062d8d769854a57e7efeec02eb2a -r74b2a31b3cbb7e2d019a2b505a2c3e7f882a19a7
--- lams_contentrepository/conf/hibernate/mappings/com/lamsinternational/lams/contentrepository/CrWorkspace.hbm.xml	(.../CrWorkspace.hbm.xml)	(revision 3f80f42891cd062d8d769854a57e7efeec02eb2a)
+++ lams_contentrepository/conf/hibernate/mappings/com/lamsinternational/lams/contentrepository/CrWorkspace.hbm.xml	(.../CrWorkspace.hbm.xml)	(revision 74b2a31b3cbb7e2d019a2b505a2c3e7f882a19a7)
@@ -57,23 +57,9 @@
             not-null="true"
         </meta>    
     </property>
-    <property
-        name="rootNodeId"
-        type="java.lang.Long"
-        column="root_node_id"
-        length="20"
-    >
-        <meta attribute="use-in-tostring">true</meta>
-        <meta attribute="use-in-equals">true</meta>
-        <meta attribute="field-description">
-           @hibernate.property
-            column="root_node_id"
-            length="20"
-        </meta>    
-    </property>
 
     <!-- Associations -->
-  
+
     <!-- bi-directional one-to-many association to CrWorkspaceCredential -->
     <set
         name="crWorkspaceCredentials"
Index: lams_contentrepository/conf/middlegen/learningdesign-prefs.properties
===================================================================
diff -u -r0a2c5ee66a400c541950f989059eec858b321ac5 -r74b2a31b3cbb7e2d019a2b505a2c3e7f882a19a7
--- lams_contentrepository/conf/middlegen/learningdesign-prefs.properties	(.../learningdesign-prefs.properties)	(revision 0a2c5ee66a400c541950f989059eec858b321ac5)
+++ lams_contentrepository/conf/middlegen/learningdesign-prefs.properties	(.../learningdesign-prefs.properties)	(revision 74b2a31b3cbb7e2d019a2b505a2c3e7f882a19a7)
@@ -154,11 +154,6 @@
 hibernate.tables.lams_cr_workspace.columns.name.inctostring=true
 hibernate.tables.lams_cr_workspace.columns.name.java-name=name
 hibernate.tables.lams_cr_workspace.columns.name.java-type=java.lang.String
-hibernate.tables.lams_cr_workspace.columns.root_node_id.columnspecialty=property
-hibernate.tables.lams_cr_workspace.columns.root_node_id.incequals=true
-hibernate.tables.lams_cr_workspace.columns.root_node_id.inctostring=true
-hibernate.tables.lams_cr_workspace.columns.root_node_id.java-name=rootNodeId
-hibernate.tables.lams_cr_workspace.columns.root_node_id.java-type=java.lang.Long
 hibernate.tables.lams_cr_workspace.columns.workspace_id.columnspecialty=key
 hibernate.tables.lams_cr_workspace.columns.workspace_id.incequals=true
 hibernate.tables.lams_cr_workspace.columns.workspace_id.inctostring=true
Index: lams_contentrepository/db/sql/create_content_repository_tables.sql
===================================================================
diff -u -r0a2c5ee66a400c541950f989059eec858b321ac5 -r74b2a31b3cbb7e2d019a2b505a2c3e7f882a19a7
--- lams_contentrepository/db/sql/create_content_repository_tables.sql	(.../create_content_repository_tables.sql)	(revision 0a2c5ee66a400c541950f989059eec858b321ac5)
+++ lams_contentrepository/db/sql/create_content_repository_tables.sql	(.../create_content_repository_tables.sql)	(revision 74b2a31b3cbb7e2d019a2b505a2c3e7f882a19a7)
@@ -12,15 +12,12 @@
 
 --
 -- Table structure for table 'lams_cr_workspace'
---
 
 CREATE TABLE lams_cr_workspace (
   workspace_id bigint(20) unsigned NOT NULL auto_increment,
   name varchar(255) NOT NULL default '0',
-  root_node_id bigint(20) unsigned,
   PRIMARY KEY  (workspace_id),
-  UNIQUE KEY workspace_id (workspace_id,name),
-  KEY name (name)
+  UNIQUE KEY workspace_id (workspace_id,name)
 ) TYPE=InnoDB COMMENT='Content repository workspace';
 
 --
Index: lams_contentrepository/db/sql/insert_test_data.sql
===================================================================
diff -u -rdb8e037cd274795d0cc5a22fce7af47b79141385 -r74b2a31b3cbb7e2d019a2b505a2c3e7f882a19a7
--- lams_contentrepository/db/sql/insert_test_data.sql	(.../insert_test_data.sql)	(revision db8e037cd274795d0cc5a22fce7af47b79141385)
+++ lams_contentrepository/db/sql/insert_test_data.sql	(.../insert_test_data.sql)	(revision 74b2a31b3cbb7e2d019a2b505a2c3e7f882a19a7)
@@ -14,26 +14,21 @@
 INSERT INTO lams_cr_workspace  (workspace_id, name) VALUES (1, 'atoolWorkspace');
 INSERT INTO lams_cr_workspace_credential  (wc_id, workspace_id, credential_id) VALUES  (1, 1,1);
 
-INSERT INTO lams_cr_node (node_id, workspace_id, type, created_date_time) VALUES ('1', '1', 'ROOTNODE', 20050106103000);
-INSERT INTO lams_cr_node_version (nv_id, node_id, version_id, parent_nv_id, created_date_time)
-VALUES ('1', '1', '1', null, 20050106103000);
-INSERT INTO lams_cr_node_version_property( id, nv_id, name, value, type) VALUES (1,1,"VERSIONDESC","Initial Version","STRING");
+INSERT INTO lams_cr_node (node_id, workspace_id, type, created_date_time, path) VALUES (1, 1, 'DATANODE', 20050106103100, "/test");
+INSERT INTO lams_cr_node_version (nv_id, node_id, version_id, created_date_time)
+VALUES (1, 1, 1, 20050106103100);
+INSERT INTO lams_cr_node_version (nv_id, node_id, version_id, created_date_time)
+VALUES (2, 1, 2, 20050106110000);
 
-INSERT INTO lams_cr_node (node_id, workspace_id, type, created_date_time, path) VALUES ('2', '1', 'DATANODE', 20050106103100, "/test");
-INSERT INTO lams_cr_node_version (nv_id, node_id, version_id, parent_nv_id, created_date_time)
-VALUES ('2', '2', '1', '1', 20050106103100);
-INSERT INTO lams_cr_node_version (nv_id, node_id, version_id, parent_nv_id, created_date_time)
-VALUES ('3', '2', '2', '1', 20050106110000);
+INSERT INTO lams_cr_node_version_property( id, nv_id, name, value, type) VALUES (1,1,"APPSPEC","abcd","STRING");
+INSERT INTO lams_cr_node_version_property( id, nv_id, name, value, type) VALUES (2,1,"VERSIONDESC","Initial Version.","STRING");
+INSERT INTO lams_cr_node_version_property( id, nv_id, name, value, type) VALUES (3,2,"APPSEC","The quick brown fox jumped over the lazy dog.","STRING");
+INSERT INTO lams_cr_node_version_property( id, nv_id, name, value, type) VALUES (4,2,"VERSIONDESC","The second version.","STRING");
 
-INSERT INTO lams_cr_node_version_property( id, nv_id, name, value, type) VALUES (2,2,"APPSPEC","abcd","STRING");
-INSERT INTO lams_cr_node_version_property( id, nv_id, name, value, type) VALUES (3,2,"VERSIONDESC","Initial Version.","STRING");
-INSERT INTO lams_cr_node_version_property( id, nv_id, name, value, type) VALUES (4,3,"APPSEC","The quick brown fox jumped over the lazy dog.","STRING");
-INSERT INTO lams_cr_node_version_property( id, nv_id, name, value, type) VALUES (5,3,"VERSIONDESC","The second version.","STRING");
-
 -- Note : this file node is missing its file as can't setup the repository
-INSERT INTO lams_cr_node (node_id, workspace_id, type, created_date_time, path) VALUES ('3', '1', 'FILENODE', 20050106103100, "");
-INSERT INTO lams_cr_node_version (nv_id, node_id, version_id, parent_nv_id, created_date_time)
-VALUES ('4', '3', '1', '1', 20050106103100);
-INSERT INTO lams_cr_node_version_property( id, nv_id, name, value, type) VALUES (6,4,"VERSIONDESC","Initial Version.","STRING");
-INSERT INTO lams_cr_node_version_property( id, nv_id, name, value, type) VALUES (7,4,"FILENAME","nofile.txt","STRING");
-INSERT INTO lams_cr_node_version_property( id, nv_id, name, value, type) VALUES (8,4,"MIMETYPE","unknown/unknown","STRING");
\ No newline at end of file
+INSERT INTO lams_cr_node (node_id, workspace_id, type, created_date_time, path) VALUES (2, 1, 'FILENODE', 20050106103100, "");
+INSERT INTO lams_cr_node_version (nv_id, node_id, version_id, created_date_time)
+VALUES (3, 2, 1, 20050106103100);
+INSERT INTO lams_cr_node_version_property( id, nv_id, name, value, type) VALUES (5,3,"VERSIONDESC","Initial Version.","STRING");
+INSERT INTO lams_cr_node_version_property( id, nv_id, name, value, type) VALUES (6,3,"FILENAME","nofile.txt","STRING");
+INSERT INTO lams_cr_node_version_property( id, nv_id, name, value, type) VALUES (7,3,"MIMETYPE","unknown/unknown","STRING");
\ No newline at end of file