Index: lams_contentrepository/db/sql/insert_test_data.sql
===================================================================
diff -u -rc09165f93c5627a041f4d07c194340857ecef5aa -r0f88631f5d36987fbe373480331e7e10d11ec166
--- lams_contentrepository/db/sql/insert_test_data.sql	(.../insert_test_data.sql)	(revision c09165f93c5627a041f4d07c194340857ecef5aa)
+++ lams_contentrepository/db/sql/insert_test_data.sql	(.../insert_test_data.sql)	(revision 0f88631f5d36987fbe373480331e7e10d11ec166)
@@ -19,13 +19,21 @@
 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 ('2', '1', 'FILENODE', 20050106103100, "/test");
+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 (2,2,"MIMETYPE","application/octet-stream","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,"MIMETYPE","application/octet-stream","STRING");
-INSERT INTO lams_cr_node_version_property( id, nv_id, name, value, type) VALUES (5,3,"VERSIONDESC","The second version.","STRING");
\ No newline at end of file
+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 (3,2,"VERSIONDESC","Initial Version.","STRING");
+INSERT INTO lams_cr_node_version_property( id, nv_id, name, value, type) VALUES (3,2,"FILENAME","nofile.txt","STRING");
+INSERT INTO lams_cr_node_version_property( id, nv_id, name, value, type) VALUES (3,2,"MIMETYPE","unknown/unknown","STRING");
\ No newline at end of file