Index: lams_common/db/sql/insert_test_data.sql =================================================================== RCS file: /usr/local/cvsroot/lams_common/db/sql/Attic/insert_test_data.sql,v diff -u -r1.43 -r1.44 --- lams_common/db/sql/insert_test_data.sql 5 May 2005 03:21:46 -0000 1.43 +++ lams_common/db/sql/insert_test_data.sql 28 May 2005 03:47:49 -0000 1.44 @@ -1,14 +1,17 @@ SET FOREIGN_KEY_CHECKS=0; -insert into lams_workspace values(1,null,'Lams Workspace'); -insert into lams_workspace values(2,null,'Manpreet Minhas'); -insert into lams_workspace values(3,null,'Test Workspace'); +insert into lams_workspace values(1,null,'ROOT'); +insert into lams_workspace values(2,null,'MACQUIRE UNIVERSITY'); +insert into lams_workspace values(3,null,'MELCOE'); +insert into lams_workspace values(4,null,'LAMS'); +insert into lams_workspace values(5,null,'MAMS'); +insert into lams_workspace values(6,null,'Manpreet Minhas'); -INSERT INTO lams_organisation VALUES (1, 'Root', 'Root Organisation',null,1,NOW(),null); -INSERT INTO lams_organisation VALUES (2, 'Maquarie Uni', 'Macquarie University',1,2,NOW(),null); -INSERT INTO lams_organisation VALUES (3, 'MELCOE', 'Macquarie E-learning Center',2,3,NOW(),null); -INSERT INTO lams_organisation VALUES (4, 'LAMS', 'Lams Project Team',3,3,NOW(),1); -INSERT INTO lams_organisation VALUES (5, 'MAMS', 'Mams Project Team',3,3,NOW(),null); +INSERT INTO lams_organisation VALUES (1, 'Root', 'Root Organisation',null,1,NOW(),1); +INSERT INTO lams_organisation VALUES (2, 'Maquarie Uni', 'Macquarie University',1,2,NOW(),2); +INSERT INTO lams_organisation VALUES (3, 'MELCOE', 'Macquarie E-learning Center',2,3,NOW(),3); +INSERT INTO lams_organisation VALUES (4, 'LAMS', 'Lams Project Team',3,3,NOW(),4); +INSERT INTO lams_organisation VALUES (5, 'MAMS', 'Mams Project Team',3,3,NOW(),5); INSERT INTO lams_user_organisation VALUES (1, 1, 1); @@ -17,8 +20,14 @@ INSERT INTO lams_user_organisation VALUES (4, 4, 2); INSERT INTO lams_user_organisation VALUES (5, 2, 3); INSERT INTO lams_user_organisation VALUES (6, 3, 3); + INSERT INTO lams_user_organisation VALUES (7, 4, 4); +INSERT INTO lams_user_organisation VALUES (8, 2, 4); +INSERT INTO lams_user_organisation VALUES (9, 3, 4); +INSERT INTO lams_user_organisation VALUES (10,5, 4); + + INSERT INTO lams_user_organisation_role VALUES (1, 1, 1); INSERT INTO lams_user_organisation_role VALUES (2, 2, 2); INSERT INTO lams_user_organisation_role VALUES (3, 2, 3); @@ -33,7 +42,11 @@ INSERT INTO lams_user_organisation_role VALUES (12, 5, 4); INSERT INTO lams_user_organisation_role VALUES (13, 5, 5); INSERT INTO lams_user_organisation_role VALUES (14, 6, 3); + INSERT INTO lams_user_organisation_role VALUES (15, 7, 3); +INSERT INTO lams_user_organisation_role VALUES (16, 8, 3); +INSERT INTO lams_user_organisation_role VALUES (17, 9, 3); +INSERT INTO lams_user_organisation_role VALUES (18, 10,3); INSERT INTO lams_user VALUES(1, 'sysadmin','sysadmin','Mr','Fei','Yang',null,null,null,'Sydney','NSW','Australia',null,null,null,null,'fyang@melcoe.mq.edu.au',0,NOW(),1,null,1); INSERT INTO lams_user VALUES(2, 'test','test','Mr','Kevin','Han',null,null,null,'Sydney','NSW','Australia',null,null,null,null,'khan@melcoe.mq.edu.au',0,NOW(),3,null,2); @@ -48,85 +61,54 @@ (4,'mminhas','mminhas','Ms','Manpreet','Minhas','170-22','Great Western Highway',null, 'Parramatta','NSW','Australia','029509061','0298938052','0405651097', '0209509062','mminhas@melcoe.mq.edu.au', -0,'20041223',1,2, +0,'20041223',1,6, 4); -insert into lams_workspace_folder -(workspace_folder_id,parent_folder_id,name,workspace_id, -user_id,create_date_time,last_modified_date_time, -lams_workspace_folder_type_id) - values -(1,null,'Lams Workspace',1, -1,'20041223','20041223', -1); +insert into lams_workspace_folder (workspace_folder_id,parent_folder_id,name,workspace_id,user_id,create_date_time,last_modified_date_time,lams_workspace_folder_type_id) +values(1,null,'ROOT',1,1,'20041223','20041223',1); -insert into lams_workspace_folder -(workspace_folder_id,parent_folder_id,name,workspace_id, -user_id,create_date_time,last_modified_date_time, -lams_workspace_folder_type_id) - values -(2,1,'Manpreet Minhas Workspace',2, -4,'20041223','20041223', -1); +insert into lams_workspace_folder (workspace_folder_id,parent_folder_id,name,workspace_id,user_id,create_date_time,last_modified_date_time,lams_workspace_folder_type_id) +values(2,1,'MACQUAIRE UNIVERSITY',2,1,'20041223','20041223',1); -insert into lams_workspace_folder -(workspace_folder_id,parent_folder_id,name,workspace_id, -user_id,create_date_time,last_modified_date_time, -lams_workspace_folder_type_id) - values -(3,2,'Manpreet Minhas Run Sequences Folder',2, -4,'20041223','20041223', -2); +insert into lams_workspace_folder (workspace_folder_id,parent_folder_id,name,workspace_id,user_id,create_date_time,last_modified_date_time,lams_workspace_folder_type_id) +values(3,1,'MELCOE',3,1,'20041223','20041223',1); -insert into lams_workspace_folder -(workspace_folder_id,parent_folder_id,name,workspace_id, -user_id,create_date_time,last_modified_date_time, -lams_workspace_folder_type_id) - values -(4,2,'MMinhas1',2, -4,'20041223','20041223', -1); +insert into lams_workspace_folder (workspace_folder_id,parent_folder_id,name,workspace_id,user_id,create_date_time,last_modified_date_time,lams_workspace_folder_type_id) +values(4,1,'LAMS',4,1,'20041223','20041223',1); -insert into lams_workspace_folder -(workspace_folder_id,parent_folder_id,name,workspace_id, -user_id,create_date_time,last_modified_date_time, -lams_workspace_folder_type_id) - values -(5,2,'MMinhas2',2, -4,'20041223','20041223', -1); +insert into lams_workspace_folder (workspace_folder_id,parent_folder_id,name,workspace_id,user_id,create_date_time,last_modified_date_time,lams_workspace_folder_type_id) +values(5,1,'MAMS',5,1,'20041223','20041223',1); -insert into lams_workspace_folder -(workspace_folder_id,parent_folder_id,name,workspace_id, -user_id,create_date_time,last_modified_date_time, -lams_workspace_folder_type_id) - values -(6,5,'Monu1',2, -4,'20041223','20041223', -1); +insert into lams_workspace_folder (workspace_folder_id,parent_folder_id,name,workspace_id,user_id,create_date_time,last_modified_date_time,lams_workspace_folder_type_id) +values(6,4,'Manpreet Minhas Workspace',6,4,'20041223','20041223',1); -insert into lams_workspace_folder -(workspace_folder_id,parent_folder_id,name,workspace_id, -user_id,create_date_time,last_modified_date_time, -lams_workspace_folder_type_id) - values -(7,5,'Monu2',2, -4,'20041223','20041223', -1); +insert into lams_workspace_folder (workspace_folder_id,parent_folder_id,name,workspace_id,user_id,create_date_time,last_modified_date_time,lams_workspace_folder_type_id) +values(7,6,'Manpreet Minhas Run Sequences Folder',6,4,'20041223','20041223',2); -insert into lams_workspace_folder -(workspace_folder_id,parent_folder_id,name,workspace_id, -user_id,create_date_time,last_modified_date_time, -lams_workspace_folder_type_id) - values -(8,1,'Test Workspace',3, -4,'20041223','20041223', -1); +insert into lams_workspace_folder (workspace_folder_id,parent_folder_id,name,workspace_id,user_id,create_date_time,last_modified_date_time,lams_workspace_folder_type_id) +values(8,6,'Documents',6,4,'20041223','20041223',1); +insert into lams_workspace_folder (workspace_folder_id,parent_folder_id,name,workspace_id,user_id,create_date_time,last_modified_date_time,lams_workspace_folder_type_id) +values(9,6,'Pictures',6,4,'20041223','20041223',1); + +insert into lams_workspace_folder (workspace_folder_id,parent_folder_id,name,workspace_id,user_id,create_date_time,last_modified_date_time,lams_workspace_folder_type_id) +values(10,6,'Media',6,4,'20041223','20041223',1); + +insert into lams_workspace_folder (workspace_folder_id,parent_folder_id,name,workspace_id,user_id,create_date_time,last_modified_date_time,lams_workspace_folder_type_id) +values(11,10,'Songs',6,4,'20041223','20041223',1); + +insert into lams_workspace_folder (workspace_folder_id,parent_folder_id,name,workspace_id,user_id,create_date_time,last_modified_date_time,lams_workspace_folder_type_id) +values(12,10,'Movies',6,4,'20041223','20041223',1); + + update lams_workspace set root_folder_id = 1 where workspace_id = 1; update lams_workspace set root_folder_id = 2 where workspace_id = 2; -update lams_workspace set root_folder_id = 8 where workspace_id = 3; +update lams_workspace set root_folder_id = 3 where workspace_id = 3; +update lams_workspace set root_folder_id = 4 where workspace_id = 4; +update lams_workspace set root_folder_id = 5 where workspace_id = 5; +update lams_workspace set root_folder_id = 6 where workspace_id = 6; + -- Populates the lams_learning_library table with default libraries insert into lams_learning_library (learning_library_id,description,title,create_date_time) values (1,'Notebook','Notebook','20050207'); @@ -923,6 +905,11 @@ 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); +-- SubmitFiles Tool related information +INSERT INTO lams_cr_credential (credential_id, name, password) VALUES (3, 'SubmitFilesLogin','SubmitFilesPassword'); +INSERT INTO lams_cr_workspace (workspace_id, name) VALUES (4, 'SubmitFilesWorkspace'); +INSERT INTO lams_cr_workspace_credential (wc_id, workspace_id, credential_id) VALUES (4,4,3); + 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) VALUES (1, 1, 1, 20050106103100);