Index: lams_common/db/sql/insert_test_data.sql =================================================================== diff -u -rbafdaffb9333f8e4d2f0ab220763262d6c389799 -r5ef30da5c8c3f97d81d42ac4abed7430f8261ef3 --- lams_common/db/sql/insert_test_data.sql (.../insert_test_data.sql) (revision bafdaffb9333f8e4d2f0ab220763262d6c389799) +++ lams_common/db/sql/insert_test_data.sql (.../insert_test_data.sql) (revision 5ef30da5c8c3f97d81d42ac4abed7430f8261ef3) @@ -912,10 +912,16 @@ -- insert the test data for the content repository INSERT INTO lams_cr_credential (credential_id, name, password) VALUES (1, 'atool','atool'); +INSERT INTO lams_cr_credential (credential_id, name, password) VALUES (2, 'workspaceManager','flashClient'); + 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_workspace (workspace_id, name) VALUES (2, 'atoolWorkspace2'); +INSERT INTO lams_cr_workspace (workspace_id, name) VALUES (3, 'flashClientsWorkspace'); + + +INSERT INTO lams_cr_workspace_credential (wc_id, workspace_id, credential_id) VALUES (1, 1,1); INSERT INTO lams_cr_workspace_credential (wc_id, workspace_id, credential_id) VALUES (2, 2,1); +INSERT INTO lams_cr_workspace_credential (wc_id, workspace_id, credential_id) VALUES (3, 3,2); INSERT INTO lams_cr_node (node_id, workspace_id, type, created_date_time, path, next_version_id) VALUES (1, 1, 'DATANODE', 20050106103100, "/test",3); INSERT INTO lams_cr_node_version (nv_id, node_id, version_id, created_date_time) @@ -936,4 +942,11 @@ INSERT INTO lams_cr_node_version_property( id, nv_id, name, value, type) VALUES (6,3,"FILENAME","nofile.txt",1); INSERT INTO lams_cr_node_version_property( id, nv_id, name, value, type) VALUES (7,3,"MIMETYPE","unknown/unknown",1); +INSERT INTO lams_workspace_folder_content VALUES (1,1,'Document','Test Description','20050101','20050101',2,NULL,NULL,'DOC'); +INSERT INTO lams_workspace_folder_content VALUES (2,1,'Text File','Test Description','20050101','20050101',2,NULL,NULL,'TXT'); +INSERT INTO lams_workspace_folder_content VALUES (3,1,'Text File','Test Description','20050101','20050101',3,NULL,NULL,'TXT'); +INSERT INTO lams_workspace_folder_content VALUES (4,1,'Gif File','Test Description','20050101','20050101',3,NULL,NULL,'GIF'); +INSERT INTO lams_workspace_folder_content VALUES (5,1,'Gif2 File','Test Description','20050101','20050101',3,NULL,NULL,'GIF'); +INSERT INTO lams_workspace_folder_content VALUES (6,1,'Text2 File','Test Description','20050101','20050101',3,NULL,NULL,'TXT'); + SET FOREIGN_KEY_CHECKS=1; \ No newline at end of file