Index: lams_build/build.xml =================================================================== diff -u -r9b0edc0305d03cc7f20ab6239f6bb4099a17d069 -rd89181efec67506914f57c2449036c85cf01094c --- lams_build/build.xml (.../build.xml) (revision 9b0edc0305d03cc7f20ab6239f6bb4099a17d069) +++ lams_build/build.xml (.../build.xml) (revision d89181efec67506914f57c2449036c85cf01094c) @@ -57,7 +57,7 @@ - @@ -68,8 +68,7 @@ inheritAll="false" /> - + @@ -153,7 +152,6 @@ - @@ -164,6 +162,12 @@ + + + + + + @@ -182,9 +186,8 @@ + - - Index: lams_build/common.properties =================================================================== diff -u -r64a449c7719c941f54599335bed162fa101d56ac -rd89181efec67506914f57c2449036c85cf01094c --- lams_build/common.properties (.../common.properties) (revision 64a449c7719c941f54599335bed162fa101d56ac) +++ lams_build/common.properties (.../common.properties) (revision d89181efec67506914f57c2449036c85cf01094c) @@ -57,6 +57,9 @@ db.schema= db.catalog= +# db scripts +lamsconf.table.sql=insert_${conf.application}_${osPropertiesName}_config_data.sql + #xdoclet version number xdoclet.version=1.2.3 Index: lams_build/unix.properties =================================================================== diff -u -r244ab963236ba838c74c195db70061ef96843c44 -rd89181efec67506914f57c2449036c85cf01094c --- lams_build/unix.properties (.../unix.properties) (revision 244ab963236ba838c74c195db70061ef96843c44) +++ lams_build/unix.properties (.../unix.properties) (revision d89181efec67506914f57c2449036c85cf01094c) @@ -26,7 +26,6 @@ conf.jboss=${conf}/jboss conf.auth=${conf}/authentication -lamsconf.table.sql=insert_unix_config_data.sql contentrepository.directory=/var/opt/lams/repository #JBoss deploy directory (Unix) Index: lams_central/build.xml =================================================================== diff -u -re0a2539ce5874f46001fa6145747a3050fd8548d -rd89181efec67506914f57c2449036c85cf01094c --- lams_central/build.xml (.../build.xml) (revision e0a2539ce5874f46001fa6145747a3050fd8548d) +++ lams_central/build.xml (.../build.xml) (revision d89181efec67506914f57c2449036c85cf01094c) @@ -112,10 +112,37 @@ + + + + + + + + + + + + + isLAMS ${isLAMS} + isRAMS ${isRAMS} + + + + Setting login logo to RAMS + + + + + + + + - + @@ -145,8 +172,12 @@ + + + + Index: lams_common/db/sql/insert_lams_unix_config_data.sql =================================================================== diff -u --- lams_common/db/sql/insert_lams_unix_config_data.sql (revision 0) +++ lams_common/db/sql/insert_lams_unix_config_data.sql (revision d89181efec67506914f57c2449036c85cf01094c) @@ -0,0 +1,32 @@ +insert into lams_configuration (config_key, config_value) values ('ServerURL','http://localhost:8080/lams/'); +insert into lams_configuration (config_key, config_value) values ('Version','2.0.2'); +insert into lams_configuration (config_key, config_value) values ('TempDir','/var/opt/lams/temp'); +insert into lams_configuration (config_key, config_value) values ('DumpDir','/var/opt/lams/dump'); +insert into lams_configuration (config_key, config_value) values ('EARDir','/Users/fiona/development/jboss-4.0.2/server/default/deploy/lams.ear/'); +insert into lams_configuration (config_key, config_value) values ('SMTPServer',''); +insert into lams_configuration (config_key, config_value) values ('LamsSupportEmail','lams_support@melcoe.mq.edu.au'); +insert into lams_configuration (config_key, config_value) values ('ContentRepositoryPath','/var/opt/lams/repository'); +insert into lams_configuration (config_key, config_value) values ('UploadFileMaxSize','1048576'); +insert into lams_configuration (config_key, config_value) values ('UploadLargeFileMaxSize','10485760'); +insert into lams_configuration (config_key, config_value) values ('UploadFileMaxMemorySize','4096'); +insert into lams_configuration (config_key, config_value) values ('ExecutableExtensions','.bat,.bin,.com,.cmd,.exe,.msi,.msp,.ocx,.pif,.scr,.sct,.sh,.shs,.vbs'); +insert into lams_configuration (config_key, config_value) values ('UserInactiveTimeout','86400'); +insert into lams_configuration (config_key, config_value) values ('UseCacheDebugListener','false'); +insert into lams_configuration (config_key, config_value) values ('CleanupPreviewOlderThanDays','7'); +insert into lams_configuration (config_key, config_value) values ('AuthoringActivitiesColour', 'true'); +insert into lams_configuration (config_key, config_value) values ('AuthoringClientVersion','2.0.2.@datetimestamp@'); +insert into lams_configuration (config_key, config_value) values ('MonitorClientVersion','2.0.2.@datetimestamp@'); +insert into lams_configuration (config_key, config_value) values ('LearnerClientVersion','2.0.2.@datetimestamp@'); +insert into lams_configuration (config_key, config_value) values ('ServerVersionNumber','2.0.2.@datetimestamp@'); +insert into lams_configuration (config_key, config_value) values ('ServerLanguage','en_AU'); +insert into lams_configuration (config_key, config_value) values ('ServerPageDirection','LTR'); +insert into lams_configuration (config_key, config_value) values ('DictionaryDateCreated','2007-03-19'); +insert into lams_configuration (config_key, config_value) values ('HelpURL','http://wiki.lamsfoundation.org/display/lamsdocs/'); +insert into lams_configuration (config_key, config_value) values ('XmppDomain','shaun.melcoe.mq.edu.au'); +insert into lams_configuration (config_key, config_value) values ('XmppConference','conference.shaun.melcoe.mq.edu.au'); +insert into lams_configuration (config_key, config_value) values ('XmppAdmin','admin'); +insert into lams_configuration (config_key, config_value) values ('XmppPassword','wildfire'); +insert into lams_configuration (config_key, config_value) values ('DefaultFlashTheme','default'); +insert into lams_configuration (config_key, config_value) values ('DefaultHTMLTheme','defaultHTML'); +insert into lams_configuration (config_key, config_value) values ('AllowDirectLessonLaunch','false'); +insert into lams_configuration (config_key, config_value) values ('LAMS_Community_enable','false'); Index: lams_common/db/sql/insert_lams_users.sql =================================================================== diff -u --- lams_common/db/sql/insert_lams_users.sql (revision 0) +++ lams_common/db/sql/insert_lams_users.sql (revision d89181efec67506914f57c2449036c85cf01094c) @@ -0,0 +1,295 @@ +-- CVS ID: $Id$ + +SET FOREIGN_KEY_CHECKS=0; + +-- themes and styles +INSERT INTO lams_css_theme_ve (theme_ve_id, name, description, parent_id, theme_flag, image_directory) VALUES (1, "default", "Default Flash style", null, 1, null); +INSERT INTO lams_css_theme_ve (theme_ve_id, name, description, parent_id, theme_flag, image_directory) VALUES (2, "defaultHTML", "Default HTML style", null, 1, "css"); +INSERT INTO lams_css_theme_ve (theme_ve_id, name, description, parent_id, theme_flag, image_directory) VALUES (3, "rams", "RAMS Default Flash style", null, 1, null); +INSERT INTO lams_css_theme_ve (theme_ve_id, name, description, parent_id, theme_flag, image_directory) VALUES (4,"ramsthemeHTML", "RAMS Default HTML sty;e", null, 1, "ramsthemecss"); + +insert into lams_workspace (workspace_id, name, default_fld_id) values(1,'ROOT',1); +insert into lams_workspace (workspace_id, name, default_fld_id, def_run_seq_fld_id) values(2,'Developers Playpen',2,22); +insert into lams_workspace (workspace_id, name, default_fld_id, def_run_seq_fld_id) values(3,'MATH111',3,23); +insert into lams_workspace (workspace_id, name, default_fld_id) values(4,'Mary Morgan',4); +insert into lams_workspace (workspace_id, name, default_fld_id) values(5,'One Test',5); +insert into lams_workspace (workspace_id, name, default_fld_id) values(6,'Two Test',6); +insert into lams_workspace (workspace_id, name, default_fld_id) values(7,'Three Test',7); +insert into lams_workspace (workspace_id, name, default_fld_id) values(8,'Four Test',8); +insert into lams_workspace (workspace_id, name, default_fld_id, def_run_seq_fld_id) values(50,'Moodle Test',40,41); +insert into lams_workspace (workspace_id, name, default_fld_id) values(51,'System Administrator',45); + +insert into lams_workspace_folder (workspace_folder_id,parent_folder_id,name,user_id,create_date_time,last_modified_date_time,lams_workspace_folder_type_id) +values(1,null,'ROOT',1,'20041223','20041223',1); + +insert into lams_workspace_folder (workspace_folder_id,parent_folder_id,name,user_id,create_date_time,last_modified_date_time,lams_workspace_folder_type_id) +values(2,1,'Developers Playpen',1,'20041223','20041223',1); + +insert into lams_workspace_folder (workspace_folder_id,parent_folder_id,name,user_id,create_date_time,last_modified_date_time,lams_workspace_folder_type_id) +values(22,2,'Lesson Sequence Folder',1,'20041223','20041223',2); + +insert into lams_workspace_folder (workspace_folder_id,parent_folder_id,name,user_id,create_date_time,last_modified_date_time,lams_workspace_folder_type_id) +values(3,1,'MATH111',1,'20041223','20041223',1); + +insert into lams_workspace_folder (workspace_folder_id,parent_folder_id,name,user_id,create_date_time,last_modified_date_time,lams_workspace_folder_type_id) +values(23,3,'Lesson Sequence Folder',1,'20041223','20041223',2); + +insert into lams_workspace_folder (workspace_folder_id,parent_folder_id,name,user_id,create_date_time,last_modified_date_time,lams_workspace_folder_type_id) +values(4,null,'Mary Morgan',4,'20041223','20041223',1); + +insert into lams_workspace_folder (workspace_folder_id,parent_folder_id,name,user_id,create_date_time,last_modified_date_time,lams_workspace_folder_type_id) +values(5,null,'One Test',5,'20041223','20041223',1); + +insert into lams_workspace_folder (workspace_folder_id,parent_folder_id,name,user_id,create_date_time,last_modified_date_time,lams_workspace_folder_type_id) +values(6,null,'Two Test',6,'20041223','20041223',1); + +insert into lams_workspace_folder (workspace_folder_id,parent_folder_id,name,user_id,create_date_time,last_modified_date_time,lams_workspace_folder_type_id) +values(7,null,'Three Test',7,'20041223','20041223',1); + +insert into lams_workspace_folder (workspace_folder_id,parent_folder_id,name,user_id,create_date_time,last_modified_date_time,lams_workspace_folder_type_id) +values(8,null,'Four Test',8,'20041223','20041223',1); + +insert into lams_workspace_folder (workspace_folder_id,parent_folder_id,name,user_id,create_date_time,last_modified_date_time,lams_workspace_folder_type_id) +values(40,1,'Moodle Test',1,'20041223','20041223',2); + +insert into lams_workspace_folder (workspace_folder_id,parent_folder_id,name,user_id,create_date_time,last_modified_date_time,lams_workspace_folder_type_id) +values(41,40,'Lesson Sequence Folder',1,'20041223','20041223',2); + +insert into lams_workspace_folder (workspace_folder_id,parent_folder_id,name,user_id,create_date_time,last_modified_date_time,lams_workspace_folder_type_id) +values(45,null,'System Administrator',1,'20061101','20061101',1); + +insert into lams_wkspc_wkspc_folder (id, workspace_id, workspace_folder_id) values (1, 1,1); +insert into lams_wkspc_wkspc_folder (id, workspace_id, workspace_folder_id) values (2, 2,2); +insert into lams_wkspc_wkspc_folder (id, workspace_id, workspace_folder_id) values (3, 2,22); +insert into lams_wkspc_wkspc_folder (id, workspace_id, workspace_folder_id) values (4, 3,3); +insert into lams_wkspc_wkspc_folder (id, workspace_id, workspace_folder_id) values (5, 3,23); +insert into lams_wkspc_wkspc_folder (id, workspace_id, workspace_folder_id) values (6, 4,4); +insert into lams_wkspc_wkspc_folder (id, workspace_id, workspace_folder_id) values (7, 5,5); +insert into lams_wkspc_wkspc_folder (id, workspace_id, workspace_folder_id) values (8, 6,6); +insert into lams_wkspc_wkspc_folder (id, workspace_id, workspace_folder_id) values (9, 7,7); +insert into lams_wkspc_wkspc_folder (id, workspace_id, workspace_folder_id) values (10, 8,8); +insert into lams_wkspc_wkspc_folder (id, workspace_id, workspace_folder_id) values (11, 50,40); +insert into lams_wkspc_wkspc_folder (id, workspace_id, workspace_folder_id) values (12, 51,45); + +INSERT INTO lams_organisation (organisation_id, name, code, description, parent_organisation_id, organisation_type_id, create_date, created_by, workspace_id, locale_id, organisation_state_id) + VALUES (1, 'Root', null, 'Root Organisation',null,1,NOW(),1,1,1,1); +INSERT INTO lams_organisation (organisation_id, name, code, description, parent_organisation_id, organisation_type_id, create_date, created_by, workspace_id, locale_id, organisation_state_id) + VALUES (2, 'Playpen', 'PP101', 'Developers Playpen',1,2,NOW(),1,2,1,1); +INSERT INTO lams_organisation (organisation_id, name, code, description, parent_organisation_id, organisation_type_id, create_date, created_by, workspace_id, locale_id, organisation_state_id) + VALUES (3, 'Everybody', null, 'All People In Course',2,3,NOW(),1,null,1,1); +INSERT INTO lams_organisation (organisation_id, name, code, description, parent_organisation_id, organisation_type_id, create_date, created_by, workspace_id, locale_id, organisation_state_id) + VALUES (4, 'Mathematics 1', 'MATH111', 'Mathematics 1',1,2,NOW(),1,3,2,1); +INSERT INTO lams_organisation (organisation_id, name, code, description, parent_organisation_id, organisation_type_id, create_date, created_by, workspace_id, locale_id, organisation_state_id) + VALUES (5, 'Tutorial Group A', 'TUTA', 'Tutorial Group A',4,3,NOW(),1,null,2,1); +INSERT INTO lams_organisation (organisation_id, name, code, description, parent_organisation_id, organisation_type_id, create_date, created_by, workspace_id, locale_id, organisation_state_id) + VALUES (6, 'Tutorial Group B', 'TUTB', 'Tutorial Group B',4,3,NOW(),1,null,2,1); +INSERT INTO lams_organisation (organisation_id, name, code, description, parent_organisation_id, organisation_type_id, create_date, created_by, workspace_id, locale_id, organisation_state_id) + VALUES (7, 'Moodle', 'Moodle', 'Moodle Test',1,2,NOW(),1,50,1,2); + + +-- users +INSERT INTO lams_user (user_id,login,password,title,first_name,last_name,address_line_1,address_line_2,address_line_3, +city,state,country,day_phone,evening_phone,mobile_phone,fax,email, +disabled_flag,create_date,authentication_method_id,workspace_id, +locale_id, flash_theme_id, html_theme_id) +VALUES(1, 'sysadmin',SHA1('sysadmin'),'The','System','Administrator',null,null,null, +'Sydney','NSW','Australia',null,null,null,null,'sysadmin@x.x', +0,NOW(),1,51, +1,1,2); + +INSERT INTO lams_user (user_id,login,password,title,first_name,last_name,address_line_1,address_line_2,address_line_3, +city,state,country,day_phone,evening_phone,mobile_phone,fax,email, +disabled_flag,create_date,authentication_method_id,workspace_id, +locale_id, flash_theme_id, html_theme_id) +VALUES(2, 'test',SHA1('test'),'Dr','Testing','LDAP',null,null,null, +'Sydney','NSW','Australia',null,null,null,null,'test@xx.xx.xx', +0,NOW(),3,null, +3,1,2); + +INSERT INTO lams_user (user_id,login,password,title,first_name,last_name,address_line_1,address_line_2,address_line_3, +city,state,country,day_phone,evening_phone,mobile_phone,fax,email, +disabled_flag,create_date,authentication_method_id,workspace_id, +locale_id, flash_theme_id, html_theme_id) +VALUES(3, 'lamskh01',SHA1('dummy'),'Mr','Jacky','Fang',null,null,null, +'Sydney','NSW','Australia',null,null,null,null,'jfang@melcoe.mq.edu.au', +0,NOW(),2,null, +1,1,2); + +insert into lams_user (user_id,login,password,title,first_name,last_name,address_line_1,address_line_2,address_line_3, +city,state,country,day_phone,evening_phone,mobile_phone, +fax,email, +disabled_flag,create_date,authentication_method_id,workspace_id, +locale_id, flash_theme_id, html_theme_id) +values +(4,'mmm',SHA1('mmm'),'Ms','Mary','Morgan','99','First Ave',null, +'Parramatta','NSW','Australia','0295099999','0298939999','0499999999', +'0299999999','mmmmmmm@xx.os', +0,'20041223',1,4,1,1,2); + +insert into lams_user (user_id,login,password,title,first_name,last_name,address_line_1,address_line_2,address_line_3, +city,state,country,day_phone,evening_phone,mobile_phone, +fax,email, +disabled_flag,create_date,authentication_method_id,workspace_id, +locale_id,flash_theme_id, html_theme_id) +values +(5,'test1',SHA1('test1'),'Dr','One','Test','1','Test Ave',null, +'Nowhere','NSW','Australia','0211111111','0211111112','0411111111', +'0211111113','test1@xx.os', +0,'20041223',1,5,1,1,2); + +insert into lams_user (user_id,login,password,title,first_name,last_name,address_line_1,address_line_2,address_line_3, +city,state,country,day_phone,evening_phone,mobile_phone, +fax,email, +disabled_flag,create_date,authentication_method_id,workspace_id, +locale_id,flash_theme_id, html_theme_id) +values +(6,'test2',SHA1('test2'),'Dr','Two','Test','2','Test Ave',null, +'Nowhere','NSW','Australia','0211111111','0211111112','0411111111', +'0211111113','test2@xx.os', +0,'20041223',1,6,1,1,2); + +insert into lams_user (user_id,login,password,title,first_name,last_name,address_line_1,address_line_2,address_line_3, +city,state,country,day_phone,evening_phone,mobile_phone, +fax,email, +disabled_flag,create_date,authentication_method_id,workspace_id, +locale_id,flash_theme_id, html_theme_id) +values +(7,'test3',SHA1('test3'),'Dr','Three','Test','3','Test Ave',null, +'Nowhere','NSW','Australia','0211111111','0211111112','0411111111', +'0211111113','test3@xx.os', +0,'20041223',1,7,1,1,2); + +insert into lams_user (user_id,login,password,title,first_name,last_name,address_line_1,address_line_2,address_line_3, +city,state,country,day_phone,evening_phone,mobile_phone, +fax,email, +disabled_flag,create_date,authentication_method_id,workspace_id, +locale_id,flash_theme_id, html_theme_id) +values +(8,'test4',SHA1('test4'),'Dr','Four','Test','4','Test Ave',null, +'Nowhere','NSW','Australia','0211111111','0211111112','0411111111', +'0211111113','test4@xx.os', +0,'20041223',1,8,1,1,2); + +--- sysadmin only belongs to root +INSERT INTO lams_user_organisation (user_organisation_id, organisation_id, user_id) VALUES (1, 1, 1); + +--- all other users belong to Playpen +INSERT INTO lams_user_organisation (user_organisation_id, organisation_id, user_id) VALUES (2, 2, 2); +INSERT INTO lams_user_organisation (user_organisation_id, organisation_id, user_id) VALUES (3, 2, 3); +INSERT INTO lams_user_organisation (user_organisation_id, organisation_id, user_id) VALUES (4, 2, 4); +INSERT INTO lams_user_organisation (user_organisation_id, organisation_id, user_id) VALUES (5, 2, 5); +INSERT INTO lams_user_organisation (user_organisation_id, organisation_id, user_id) VALUES (6, 2, 6); +INSERT INTO lams_user_organisation (user_organisation_id, organisation_id, user_id) VALUES (7, 2, 7); +INSERT INTO lams_user_organisation (user_organisation_id, organisation_id, user_id) VALUES (8, 2, 8); +--- all other users belong to Playpen's class Everybody +INSERT INTO lams_user_organisation (user_organisation_id, organisation_id, user_id) VALUES (9, 3, 2); +INSERT INTO lams_user_organisation (user_organisation_id, organisation_id, user_id) VALUES (10, 3, 3); +INSERT INTO lams_user_organisation (user_organisation_id, organisation_id, user_id) VALUES (11, 3, 4); +INSERT INTO lams_user_organisation (user_organisation_id, organisation_id, user_id) VALUES (12, 3, 5); +INSERT INTO lams_user_organisation (user_organisation_id, organisation_id, user_id) VALUES (13, 3, 6); +INSERT INTO lams_user_organisation (user_organisation_id, organisation_id, user_id) VALUES (14, 3, 7); +INSERT INTO lams_user_organisation (user_organisation_id, organisation_id, user_id) VALUES (15, 3, 8); +--- all other users belong to MATH111 +INSERT INTO lams_user_organisation (user_organisation_id, organisation_id, user_id) VALUES (16, 4, 2); +INSERT INTO lams_user_organisation (user_organisation_id, organisation_id, user_id) VALUES (17, 4, 3); +INSERT INTO lams_user_organisation (user_organisation_id, organisation_id, user_id) VALUES (18, 4, 4); +INSERT INTO lams_user_organisation (user_organisation_id, organisation_id, user_id) VALUES (19, 4, 5); +INSERT INTO lams_user_organisation (user_organisation_id, organisation_id, user_id) VALUES (20, 4, 6); +INSERT INTO lams_user_organisation (user_organisation_id, organisation_id, user_id) VALUES (21, 4, 7); +INSERT INTO lams_user_organisation (user_organisation_id, organisation_id, user_id) VALUES (22, 4, 8); +--- all test3, test4 users belong to Tutorial B, the other users belong to Tutorial A +INSERT INTO lams_user_organisation (user_organisation_id, organisation_id, user_id) VALUES (23, 5, 2); +INSERT INTO lams_user_organisation (user_organisation_id, organisation_id, user_id) VALUES (24, 5, 3); +INSERT INTO lams_user_organisation (user_organisation_id, organisation_id, user_id) VALUES (25, 5, 4); +INSERT INTO lams_user_organisation (user_organisation_id, organisation_id, user_id) VALUES (26, 5, 5); +INSERT INTO lams_user_organisation (user_organisation_id, organisation_id, user_id) VALUES (27, 5, 6); +INSERT INTO lams_user_organisation (user_organisation_id, organisation_id, user_id) VALUES (28, 6, 7); +INSERT INTO lams_user_organisation (user_organisation_id, organisation_id, user_id) VALUES (29, 6, 8); + +-- sysadmin has sysadmin role only +INSERT INTO lams_user_organisation_role (user_organisation_role_id, user_organisation_id, role_id) VALUES (1, 1, 1); + +-- test, lamskh01 and mmm are authors, staff and learners in Playpen +-- test1, test2, test3 and test4 are authors, staff and learners in Playpen +INSERT INTO lams_user_organisation_role (user_organisation_role_id, user_organisation_id, role_id) VALUES (2, 2, 3); +INSERT INTO lams_user_organisation_role (user_organisation_role_id, user_organisation_id, role_id) VALUES (3, 3, 3); +INSERT INTO lams_user_organisation_role (user_organisation_role_id, user_organisation_id, role_id) VALUES (4, 4, 3); +INSERT INTO lams_user_organisation_role (user_organisation_role_id, user_organisation_id, role_id) VALUES (5, 5, 3); +INSERT INTO lams_user_organisation_role (user_organisation_role_id, user_organisation_id, role_id) VALUES (6, 6, 3); +INSERT INTO lams_user_organisation_role (user_organisation_role_id, user_organisation_id, role_id) VALUES (7, 7, 3); +INSERT INTO lams_user_organisation_role (user_organisation_role_id, user_organisation_id, role_id) VALUES (8, 8, 3); +INSERT INTO lams_user_organisation_role (user_organisation_role_id, user_organisation_id, role_id) VALUES (9, 2, 4); +INSERT INTO lams_user_organisation_role (user_organisation_role_id, user_organisation_id, role_id) VALUES (10, 3, 4); +INSERT INTO lams_user_organisation_role (user_organisation_role_id, user_organisation_id, role_id) VALUES (11, 4, 4); +INSERT INTO lams_user_organisation_role (user_organisation_role_id, user_organisation_id, role_id) VALUES (12, 5, 4); +INSERT INTO lams_user_organisation_role (user_organisation_role_id, user_organisation_id, role_id) VALUES (13, 6, 4); +INSERT INTO lams_user_organisation_role (user_organisation_role_id, user_organisation_id, role_id) VALUES (14, 7, 4); +INSERT INTO lams_user_organisation_role (user_organisation_role_id, user_organisation_id, role_id) VALUES (15, 8, 4); +INSERT INTO lams_user_organisation_role (user_organisation_role_id, user_organisation_id, role_id) VALUES (16, 2, 5); +INSERT INTO lams_user_organisation_role (user_organisation_role_id, user_organisation_id, role_id) VALUES (17, 3, 5); +INSERT INTO lams_user_organisation_role (user_organisation_role_id, user_organisation_id, role_id) VALUES (18, 4, 5); +INSERT INTO lams_user_organisation_role (user_organisation_role_id, user_organisation_id, role_id) VALUES (19, 5, 5); +INSERT INTO lams_user_organisation_role (user_organisation_role_id, user_organisation_id, role_id) VALUES (20, 6, 5); +INSERT INTO lams_user_organisation_role (user_organisation_role_id, user_organisation_id, role_id) VALUES (21, 7, 5); +INSERT INTO lams_user_organisation_role (user_organisation_role_id, user_organisation_id, role_id) VALUES (22, 8, 5); + +-- test, lamskh01 and mmm are staff and learners in Everybody +-- test1, test2, test3 and test4 are staff and learners in Everybody +INSERT INTO lams_user_organisation_role (user_organisation_role_id, user_organisation_id, role_id) VALUES (23, 9, 4); +INSERT INTO lams_user_organisation_role (user_organisation_role_id, user_organisation_id, role_id) VALUES (24, 10, 4); +INSERT INTO lams_user_organisation_role (user_organisation_role_id, user_organisation_id, role_id) VALUES (25, 11, 4); +INSERT INTO lams_user_organisation_role (user_organisation_role_id, user_organisation_id, role_id) VALUES (26, 12, 4); +INSERT INTO lams_user_organisation_role (user_organisation_role_id, user_organisation_id, role_id) VALUES (27, 13, 4); +INSERT INTO lams_user_organisation_role (user_organisation_role_id, user_organisation_id, role_id) VALUES (28, 14, 4); +INSERT INTO lams_user_organisation_role (user_organisation_role_id, user_organisation_id, role_id) VALUES (29, 16, 4); +INSERT INTO lams_user_organisation_role (user_organisation_role_id, user_organisation_id, role_id) VALUES (30, 9, 5); +INSERT INTO lams_user_organisation_role (user_organisation_role_id, user_organisation_id, role_id) VALUES (31, 10, 5); +INSERT INTO lams_user_organisation_role (user_organisation_role_id, user_organisation_id, role_id) VALUES (32, 11, 5); +INSERT INTO lams_user_organisation_role (user_organisation_role_id, user_organisation_id, role_id) VALUES (33, 12, 5); +INSERT INTO lams_user_organisation_role (user_organisation_role_id, user_organisation_id, role_id) VALUES (34, 13, 5); +INSERT INTO lams_user_organisation_role (user_organisation_role_id, user_organisation_id, role_id) VALUES (35, 14, 5); +INSERT INTO lams_user_organisation_role (user_organisation_role_id, user_organisation_id, role_id) VALUES (36, 15, 5); + +-- test, lamskh01 and mmm are authors, staff and learners in MATH111 +-- test1, test2, test3 and test4 are authors, staff and learners in MATH111 +INSERT INTO lams_user_organisation_role (user_organisation_role_id, user_organisation_id, role_id) VALUES (37, 16, 3); +INSERT INTO lams_user_organisation_role (user_organisation_role_id, user_organisation_id, role_id) VALUES (38, 17, 3); +INSERT INTO lams_user_organisation_role (user_organisation_role_id, user_organisation_id, role_id) VALUES (39, 18, 3); +INSERT INTO lams_user_organisation_role (user_organisation_role_id, user_organisation_id, role_id) VALUES (40, 19, 3); +INSERT INTO lams_user_organisation_role (user_organisation_role_id, user_organisation_id, role_id) VALUES (41, 20, 3); +INSERT INTO lams_user_organisation_role (user_organisation_role_id, user_organisation_id, role_id) VALUES (42, 21, 3); +INSERT INTO lams_user_organisation_role (user_organisation_role_id, user_organisation_id, role_id) VALUES (43, 22, 3); +INSERT INTO lams_user_organisation_role (user_organisation_role_id, user_organisation_id, role_id) VALUES (44, 16, 4); +INSERT INTO lams_user_organisation_role (user_organisation_role_id, user_organisation_id, role_id) VALUES (45, 17, 4); +INSERT INTO lams_user_organisation_role (user_organisation_role_id, user_organisation_id, role_id) VALUES (46, 18, 4); +INSERT INTO lams_user_organisation_role (user_organisation_role_id, user_organisation_id, role_id) VALUES (47, 19, 4); +INSERT INTO lams_user_organisation_role (user_organisation_role_id, user_organisation_id, role_id) VALUES (48, 20, 4); +INSERT INTO lams_user_organisation_role (user_organisation_role_id, user_organisation_id, role_id) VALUES (49, 21, 4); +INSERT INTO lams_user_organisation_role (user_organisation_role_id, user_organisation_id, role_id) VALUES (50, 22, 4); +INSERT INTO lams_user_organisation_role (user_organisation_role_id, user_organisation_id, role_id) VALUES (51, 16, 5); +INSERT INTO lams_user_organisation_role (user_organisation_role_id, user_organisation_id, role_id) VALUES (52, 17, 5); +INSERT INTO lams_user_organisation_role (user_organisation_role_id, user_organisation_id, role_id) VALUES (53, 18, 5); +INSERT INTO lams_user_organisation_role (user_organisation_role_id, user_organisation_id, role_id) VALUES (54, 19, 5); +INSERT INTO lams_user_organisation_role (user_organisation_role_id, user_organisation_id, role_id) VALUES (55, 20, 5); +INSERT INTO lams_user_organisation_role (user_organisation_role_id, user_organisation_id, role_id) VALUES (56, 21, 5); +INSERT INTO lams_user_organisation_role (user_organisation_role_id, user_organisation_id, role_id) VALUES (57, 22, 5); + +-- test, lamskh01 and mmm are staff and learners in Tutorial A +-- test1, test2 are staff and learners in Tutorial A +-- test3 and test4 are staff and learners in Tutorial B +INSERT INTO lams_user_organisation_role (user_organisation_role_id, user_organisation_id, role_id) VALUES (58, 23, 4); +INSERT INTO lams_user_organisation_role (user_organisation_role_id, user_organisation_id, role_id) VALUES (59, 24, 4); +INSERT INTO lams_user_organisation_role (user_organisation_role_id, user_organisation_id, role_id) VALUES (60, 25, 4); +INSERT INTO lams_user_organisation_role (user_organisation_role_id, user_organisation_id, role_id) VALUES (61, 26, 4); +INSERT INTO lams_user_organisation_role (user_organisation_role_id, user_organisation_id, role_id) VALUES (62, 27, 4); +INSERT INTO lams_user_organisation_role (user_organisation_role_id, user_organisation_id, role_id) VALUES (63, 28, 4); +INSERT INTO lams_user_organisation_role (user_organisation_role_id, user_organisation_id, role_id) VALUES (64, 29, 4); +INSERT INTO lams_user_organisation_role (user_organisation_role_id, user_organisation_id, role_id) VALUES (65, 23, 5); +INSERT INTO lams_user_organisation_role (user_organisation_role_id, user_organisation_id, role_id) VALUES (66, 24, 5); +INSERT INTO lams_user_organisation_role (user_organisation_role_id, user_organisation_id, role_id) VALUES (67, 25, 5); +INSERT INTO lams_user_organisation_role (user_organisation_role_id, user_organisation_id, role_id) VALUES (68, 26, 5); +INSERT INTO lams_user_organisation_role (user_organisation_role_id, user_organisation_id, role_id) VALUES (69, 27, 5); +INSERT INTO lams_user_organisation_role (user_organisation_role_id, user_organisation_id, role_id) VALUES (70, 28, 5); +INSERT INTO lams_user_organisation_role (user_organisation_role_id, user_organisation_id, role_id) VALUES (71, 29, 5); + +SET FOREIGN_KEY_CHECKS=1; \ No newline at end of file Index: lams_common/db/sql/insert_lams_windows_config_data.sql =================================================================== diff -u --- lams_common/db/sql/insert_lams_windows_config_data.sql (revision 0) +++ lams_common/db/sql/insert_lams_windows_config_data.sql (revision d89181efec67506914f57c2449036c85cf01094c) @@ -0,0 +1,32 @@ +insert into lams_configuration (config_key, config_value) values ('ServerURL','http://localhost:8080/lams/'); +insert into lams_configuration (config_key, config_value) values ('Version','2.0.2'); +insert into lams_configuration (config_key, config_value) values ('TempDir','C:/lams/temp'); +insert into lams_configuration (config_key, config_value) values ('DumpDir','C:/lams/dump'); +insert into lams_configuration (config_key, config_value) values ('EARDir','C:/jboss-4.0.2/server/default/deploy/lams.ear'); +insert into lams_configuration (config_key, config_value) values ('SMTPServer',''); +insert into lams_configuration (config_key, config_value) values ('LamsSupportEmail','lams_support@melcoe.mq.edu.au'); +insert into lams_configuration (config_key, config_value) values ('ContentRepositoryPath','C:/lams/repository'); +insert into lams_configuration (config_key, config_value) values ('UploadFileMaxSize','1048576'); +insert into lams_configuration (config_key, config_value) values ('UploadLargeFileMaxSize','10485760'); +insert into lams_configuration (config_key, config_value) values ('UploadFileMaxMemorySize','4096'); +insert into lams_configuration (config_key, config_value) values ('ExecutableExtensions','.bat,.bin,.com,.cmd,.exe,.msi,.msp,.ocx,.pif,.scr,.sct,.sh,.shs,.vbs'); +insert into lams_configuration (config_key, config_value) values ('UserInactiveTimeout','86400'); +insert into lams_configuration (config_key, config_value) values ('UseCacheDebugListener','false'); +insert into lams_configuration (config_key, config_value) values ('CleanupPreviewOlderThanDays','7'); +insert into lams_configuration (config_key, config_value) values ('AuthoringActivitiesColour', 'true'); +insert into lams_configuration (config_key, config_value) values ('AuthoringClientVersion','2.0.2.@datetimestamp@'); +insert into lams_configuration (config_key, config_value) values ('MonitorClientVersion','2.0.2.@datetimestamp@'); +insert into lams_configuration (config_key, config_value) values ('LearnerClientVersion','2.0.2.@datetimestamp@'); +insert into lams_configuration (config_key, config_value) values ('ServerVersionNumber','2.0.2.@datetimestamp@'); +insert into lams_configuration (config_key, config_value) values ('ServerLanguage','en_AU'); +insert into lams_configuration (config_key, config_value) values ('ServerPageDirection','LTR'); +insert into lams_configuration (config_key, config_value) values ('DictionaryDateCreated','2007-03-19'); +insert into lams_configuration (config_key, config_value) values ('HelpURL','http://wiki.lamsfoundation.org/display/lamsdocs/'); +insert into lams_configuration (config_key, config_value) values ('XmppDomain','shaun.melcoe.mq.edu.au'); +insert into lams_configuration (config_key, config_value) values ('XmppConference','conference.shaun.melcoe.mq.edu.au'); +insert into lams_configuration (config_key, config_value) values ('XmppAdmin','admin'); +insert into lams_configuration (config_key, config_value) values ('XmppPassword','wildfire'); +insert into lams_configuration (config_key, config_value) values ('DefaultFlashTheme','default'); +insert into lams_configuration (config_key, config_value) values ('DefaultHTMLTheme','defaultHTML'); +insert into lams_configuration (config_key, config_value) values ('AllowDirectLessonLaunch','false'); +insert into lams_configuration (config_key, config_value) values ('LAMS_Community_enable','false'); \ No newline at end of file Index: lams_common/db/sql/insert_rams_unix_config_data.sql =================================================================== diff -u --- lams_common/db/sql/insert_rams_unix_config_data.sql (revision 0) +++ lams_common/db/sql/insert_rams_unix_config_data.sql (revision d89181efec67506914f57c2449036c85cf01094c) @@ -0,0 +1,32 @@ +insert into lams_configuration (config_key, config_value) values ('ServerURL','http://localhost:8080/lams/'); +insert into lams_configuration (config_key, config_value) values ('Version','1.0'); +insert into lams_configuration (config_key, config_value) values ('TempDir','/var/opt/lams/temp'); +insert into lams_configuration (config_key, config_value) values ('DumpDir','/var/opt/lams/dump'); +insert into lams_configuration (config_key, config_value) values ('EARDir','/Users/fiona/development/jboss-4.0.2/server/default/deploy/lams.ear/'); +insert into lams_configuration (config_key, config_value) values ('SMTPServer',''); +insert into lams_configuration (config_key, config_value) values ('LamsSupportEmail','lams_support@melcoe.mq.edu.au'); +insert into lams_configuration (config_key, config_value) values ('ContentRepositoryPath','/var/opt/lams/repository'); +insert into lams_configuration (config_key, config_value) values ('UploadFileMaxSize','1048576'); +insert into lams_configuration (config_key, config_value) values ('UploadLargeFileMaxSize','10485760'); +insert into lams_configuration (config_key, config_value) values ('UploadFileMaxMemorySize','4096'); +insert into lams_configuration (config_key, config_value) values ('ExecutableExtensions','.bat,.bin,.com,.cmd,.exe,.msi,.msp,.ocx,.pif,.scr,.sct,.sh,.shs,.vbs'); +insert into lams_configuration (config_key, config_value) values ('UserInactiveTimeout','86400'); +insert into lams_configuration (config_key, config_value) values ('UseCacheDebugListener','false'); +insert into lams_configuration (config_key, config_value) values ('CleanupPreviewOlderThanDays','7'); +insert into lams_configuration (config_key, config_value) values ('AuthoringActivitiesColour', 'true'); +insert into lams_configuration (config_key, config_value) values ('AuthoringClientVersion','1.0.@datetimestamp@'); +insert into lams_configuration (config_key, config_value) values ('MonitorClientVersion','1.0.@datetimestamp@'); +insert into lams_configuration (config_key, config_value) values ('LearnerClientVersion','1.0.@datetimestamp@'); +insert into lams_configuration (config_key, config_value) values ('ServerVersionNumber','1.0.@datetimestamp@'); +insert into lams_configuration (config_key, config_value) values ('ServerLanguage','en_AU'); +insert into lams_configuration (config_key, config_value) values ('ServerPageDirection','LTR'); +insert into lams_configuration (config_key, config_value) values ('DictionaryDateCreated','2007-04-23'); +insert into lams_configuration (config_key, config_value) values ('HelpURL','http://wiki.lamsfoundation.org/display/lamsdocs/'); +insert into lams_configuration (config_key, config_value) values ('XmppDomain','shaun.melcoe.mq.edu.au'); +insert into lams_configuration (config_key, config_value) values ('XmppConference','conference.shaun.melcoe.mq.edu.au'); +insert into lams_configuration (config_key, config_value) values ('XmppAdmin','admin'); +insert into lams_configuration (config_key, config_value) values ('XmppPassword','wildfire'); +insert into lams_configuration (config_key, config_value) values ('DefaultFlashTheme','rams'); +insert into lams_configuration (config_key, config_value) values ('DefaultHTMLTheme','ramsthemeHTML'); +insert into lams_configuration (config_key, config_value) values ('AllowDirectLessonLaunch','false'); +insert into lams_configuration (config_key, config_value) values ('LAMS_Community_enable','false'); Index: lams_common/db/sql/insert_rams_users.sql =================================================================== diff -u --- lams_common/db/sql/insert_rams_users.sql (revision 0) +++ lams_common/db/sql/insert_rams_users.sql (revision d89181efec67506914f57c2449036c85cf01094c) @@ -0,0 +1,170 @@ +-- CVS ID: $Id$ + +SET FOREIGN_KEY_CHECKS=0; + +-- themes and styles +INSERT INTO lams_css_theme_ve (theme_ve_id, name, description, parent_id, theme_flag, image_directory) VALUES (1, "default", "Default Flash style", null, 1, null); +INSERT INTO lams_css_theme_ve (theme_ve_id, name, description, parent_id, theme_flag, image_directory) VALUES (2, "defaultHTML", "Default HTML style", null, 1, "css"); +INSERT INTO lams_css_theme_ve (theme_ve_id, name, description, parent_id, theme_flag, image_directory) VALUES (3, "rams", "RAMS Default Flash style", null, 1, null); +INSERT INTO lams_css_theme_ve (theme_ve_id, name, description, parent_id, theme_flag, image_directory) VALUES (4,"ramsthemeHTML", "RAMS Default HTML sty;e", null, 1, "ramsthemecss"); + +insert into lams_workspace (workspace_id, name, default_fld_id) values(1,'ROOT',1); +insert into lams_workspace (workspace_id, name, default_fld_id, def_run_seq_fld_id) values(2,'Developers Playpen',2,22); +insert into lams_workspace (workspace_id, name, default_fld_id) values(5,'One Test',5); +insert into lams_workspace (workspace_id, name, default_fld_id) values(6,'Two Test',6); +insert into lams_workspace (workspace_id, name, default_fld_id) values(7,'Three Test',7); +insert into lams_workspace (workspace_id, name, default_fld_id) values(8,'Four Test',8); +insert into lams_workspace (workspace_id, name, default_fld_id, def_run_seq_fld_id) values(50,'Moodle Test',40,41); +insert into lams_workspace (workspace_id, name, default_fld_id) values(51,'System Administrator',45); + +insert into lams_workspace_folder (workspace_folder_id,parent_folder_id,name,user_id,create_date_time,last_modified_date_time,lams_workspace_folder_type_id) +values(1,null,'ROOT',1,'20041223','20041223',1); + +insert into lams_workspace_folder (workspace_folder_id,parent_folder_id,name,user_id,create_date_time,last_modified_date_time,lams_workspace_folder_type_id) +values(2,1,'Developers Playpen',1,'20041223','20041223',1); + +insert into lams_workspace_folder (workspace_folder_id,parent_folder_id,name,user_id,create_date_time,last_modified_date_time,lams_workspace_folder_type_id) +values(22,2,'Lesson Sequence Folder',1,'20041223','20041223',2); + +insert into lams_workspace_folder (workspace_folder_id,parent_folder_id,name,user_id,create_date_time,last_modified_date_time,lams_workspace_folder_type_id) +values(23,3,'Lesson Sequence Folder',1,'20041223','20041223',2); + +insert into lams_workspace_folder (workspace_folder_id,parent_folder_id,name,user_id,create_date_time,last_modified_date_time,lams_workspace_folder_type_id) +values(5,null,'One Test',5,'20041223','20041223',1); + +insert into lams_workspace_folder (workspace_folder_id,parent_folder_id,name,user_id,create_date_time,last_modified_date_time,lams_workspace_folder_type_id) +values(6,null,'Two Test',6,'20041223','20041223',1); + +insert into lams_workspace_folder (workspace_folder_id,parent_folder_id,name,user_id,create_date_time,last_modified_date_time,lams_workspace_folder_type_id) +values(7,null,'Three Test',7,'20041223','20041223',1); + +insert into lams_workspace_folder (workspace_folder_id,parent_folder_id,name,user_id,create_date_time,last_modified_date_time,lams_workspace_folder_type_id) +values(8,null,'Four Test',8,'20041223','20041223',1); + +insert into lams_workspace_folder (workspace_folder_id,parent_folder_id,name,user_id,create_date_time,last_modified_date_time,lams_workspace_folder_type_id) +values(40,1,'Moodle Test',1,'20041223','20041223',2); + +insert into lams_workspace_folder (workspace_folder_id,parent_folder_id,name,user_id,create_date_time,last_modified_date_time,lams_workspace_folder_type_id) +values(41,40,'Lesson Sequence Folder',1,'20041223','20041223',2); + +insert into lams_workspace_folder (workspace_folder_id,parent_folder_id,name,user_id,create_date_time,last_modified_date_time,lams_workspace_folder_type_id) +values(45,null,'System Administrator',1,'20061101','20061101',1); + +insert into lams_wkspc_wkspc_folder (id, workspace_id, workspace_folder_id) values (1, 1,1); +insert into lams_wkspc_wkspc_folder (id, workspace_id, workspace_folder_id) values (2, 2,2); +insert into lams_wkspc_wkspc_folder (id, workspace_id, workspace_folder_id) values (3, 2,22); +--insert into lams_wkspc_wkspc_folder (id, workspace_id, workspace_folder_id) values (5, 3,23); +insert into lams_wkspc_wkspc_folder (id, workspace_id, workspace_folder_id) values (6, 4,4); +insert into lams_wkspc_wkspc_folder (id, workspace_id, workspace_folder_id) values (7, 5,5); +insert into lams_wkspc_wkspc_folder (id, workspace_id, workspace_folder_id) values (8, 6,6); +--insert into lams_wkspc_wkspc_folder (id, workspace_id, workspace_folder_id) values (9, 7,7); +insert into lams_wkspc_wkspc_folder (id, workspace_id, workspace_folder_id) values (10, 8,8); +insert into lams_wkspc_wkspc_folder (id, workspace_id, workspace_folder_id) values (11, 50,40); +insert into lams_wkspc_wkspc_folder (id, workspace_id, workspace_folder_id) values (12, 51,45); + +INSERT INTO lams_organisation (organisation_id, name, code, description, parent_organisation_id, organisation_type_id, create_date, created_by, workspace_id, locale_id, organisation_state_id) + VALUES (1, 'Root', null, 'Root Organisation',null,1,NOW(),1,1,1,1); +INSERT INTO lams_organisation (organisation_id, name, code, description, parent_organisation_id, organisation_type_id, create_date, created_by, workspace_id, locale_id, organisation_state_id) + VALUES (2, 'Playpen', 'PP101', 'Developers Playpen',1,2,NOW(),1,2,1,1); +INSERT INTO lams_organisation (organisation_id, name, code, description, parent_organisation_id, organisation_type_id, create_date, created_by, workspace_id, locale_id, organisation_state_id) + VALUES (3, 'Everybody', null, 'All People In Course',2,3,NOW(),1,null,1,1); +INSERT INTO lams_organisation (organisation_id, name, code, description, parent_organisation_id, organisation_type_id, create_date, created_by, workspace_id, locale_id, organisation_state_id) + VALUES (7, 'Moodle', 'Moodle', 'Moodle Test',1,2,NOW(),1,50,1,2); + + +-- users +INSERT INTO lams_user (user_id,login,password,title,first_name,last_name,address_line_1,address_line_2,address_line_3, +city,state,country,day_phone,evening_phone,mobile_phone,fax,email, +disabled_flag,create_date,authentication_method_id,workspace_id, +locale_id, flash_theme_id, html_theme_id) +VALUES(1, 'sysadmin',SHA1('sysadmin'),'The','System','Administrator',null,null,null, +'Sydney','NSW','Australia',null,null,null,null,'sysadmin@x.x', +0,NOW(),1,51, +1,3,4); + +insert into lams_user (user_id,login,password,title,first_name,last_name,address_line_1,address_line_2,address_line_3, +city,state,country,day_phone,evening_phone,mobile_phone, +fax,email, +disabled_flag,create_date,authentication_method_id,workspace_id, +locale_id,flash_theme_id, html_theme_id) +values +(5,'test1',SHA1('test1'),'Dr','One','Test','1','Test Ave',null, +'Nowhere','NSW','Australia','0211111111','0211111112','0411111111', +'0211111113','test1@xx.os', +0,'20041223',1,5,1,3,4); + +insert into lams_user (user_id,login,password,title,first_name,last_name,address_line_1,address_line_2,address_line_3, +city,state,country,day_phone,evening_phone,mobile_phone, +fax,email, +disabled_flag,create_date,authentication_method_id,workspace_id, +locale_id,flash_theme_id, html_theme_id) +values +(6,'test2',SHA1('test2'),'Dr','Two','Test','2','Test Ave',null, +'Nowhere','NSW','Australia','0211111111','0211111112','0411111111', +'0211111113','test2@xx.os', +0,'20041223',1,6,1,3,4); + +insert into lams_user (user_id,login,password,title,first_name,last_name,address_line_1,address_line_2,address_line_3, +city,state,country,day_phone,evening_phone,mobile_phone, +fax,email, +disabled_flag,create_date,authentication_method_id,workspace_id, +locale_id,flash_theme_id, html_theme_id) +values +(7,'test3',SHA1('test3'),'Dr','Three','Test','3','Test Ave',null, +'Nowhere','NSW','Australia','0211111111','0211111112','0411111111', +'0211111113','test3@xx.os', +0,'20041223',1,7,1,3,4); + +insert into lams_user (user_id,login,password,title,first_name,last_name,address_line_1,address_line_2,address_line_3, +city,state,country,day_phone,evening_phone,mobile_phone, +fax,email, +disabled_flag,create_date,authentication_method_id,workspace_id, +locale_id,flash_theme_id, html_theme_id) +values +(8,'test4',SHA1('test4'),'Dr','Four','Test','4','Test Ave',null, +'Nowhere','NSW','Australia','0211111111','0211111112','0411111111', +'0211111113','test4@xx.os', +0,'20041223',1,8,1,3,4); + +--- sysadmin only belongs to root +INSERT INTO lams_user_organisation (user_organisation_id, organisation_id, user_id) VALUES (1, 1, 1); + +--- all other users belong to Playpen +INSERT INTO lams_user_organisation (user_organisation_id, organisation_id, user_id) VALUES (5, 2, 5); +INSERT INTO lams_user_organisation (user_organisation_id, organisation_id, user_id) VALUES (6, 2, 6); +INSERT INTO lams_user_organisation (user_organisation_id, organisation_id, user_id) VALUES (7, 2, 7); +INSERT INTO lams_user_organisation (user_organisation_id, organisation_id, user_id) VALUES (8, 2, 8); +--- all other users belong to Playpen's class Everybody +INSERT INTO lams_user_organisation (user_organisation_id, organisation_id, user_id) VALUES (12, 3, 5); +INSERT INTO lams_user_organisation (user_organisation_id, organisation_id, user_id) VALUES (13, 3, 6); +INSERT INTO lams_user_organisation (user_organisation_id, organisation_id, user_id) VALUES (14, 3, 7); +INSERT INTO lams_user_organisation (user_organisation_id, organisation_id, user_id) VALUES (15, 3, 8); + +-- sysadmin has sysadmin role only +INSERT INTO lams_user_organisation_role (user_organisation_role_id, user_organisation_id, role_id) VALUES (1, 1, 1); + +-- test1, test2, test3 and test4 are authors, staff and learners in Playpen +INSERT INTO lams_user_organisation_role (user_organisation_role_id, user_organisation_id, role_id) VALUES (5, 5, 3); +INSERT INTO lams_user_organisation_role (user_organisation_role_id, user_organisation_id, role_id) VALUES (6, 6, 3); +INSERT INTO lams_user_organisation_role (user_organisation_role_id, user_organisation_id, role_id) VALUES (7, 7, 3); +INSERT INTO lams_user_organisation_role (user_organisation_role_id, user_organisation_id, role_id) VALUES (8, 8, 3); +INSERT INTO lams_user_organisation_role (user_organisation_role_id, user_organisation_id, role_id) VALUES (12, 5, 4); +INSERT INTO lams_user_organisation_role (user_organisation_role_id, user_organisation_id, role_id) VALUES (13, 6, 4); +INSERT INTO lams_user_organisation_role (user_organisation_role_id, user_organisation_id, role_id) VALUES (14, 7, 4); +INSERT INTO lams_user_organisation_role (user_organisation_role_id, user_organisation_id, role_id) VALUES (15, 8, 4); +INSERT INTO lams_user_organisation_role (user_organisation_role_id, user_organisation_id, role_id) VALUES (19, 5, 5); +INSERT INTO lams_user_organisation_role (user_organisation_role_id, user_organisation_id, role_id) VALUES (20, 6, 5); +INSERT INTO lams_user_organisation_role (user_organisation_role_id, user_organisation_id, role_id) VALUES (21, 7, 5); +INSERT INTO lams_user_organisation_role (user_organisation_role_id, user_organisation_id, role_id) VALUES (22, 8, 5); + +-- test1, test2, test3 and test4 are staff and learners in Everybody +INSERT INTO lams_user_organisation_role (user_organisation_role_id, user_organisation_id, role_id) VALUES (26, 12, 4); +INSERT INTO lams_user_organisation_role (user_organisation_role_id, user_organisation_id, role_id) VALUES (27, 13, 4); +INSERT INTO lams_user_organisation_role (user_organisation_role_id, user_organisation_id, role_id) VALUES (28, 14, 4); +INSERT INTO lams_user_organisation_role (user_organisation_role_id, user_organisation_id, role_id) VALUES (29, 15, 4); +INSERT INTO lams_user_organisation_role (user_organisation_role_id, user_organisation_id, role_id) VALUES (33, 12, 5); +INSERT INTO lams_user_organisation_role (user_organisation_role_id, user_organisation_id, role_id) VALUES (34, 13, 5); +INSERT INTO lams_user_organisation_role (user_organisation_role_id, user_organisation_id, role_id) VALUES (35, 14, 5); +INSERT INTO lams_user_organisation_role (user_organisation_role_id, user_organisation_id, role_id) VALUES (36, 15, 5); + +SET FOREIGN_KEY_CHECKS=1; \ No newline at end of file Index: lams_common/db/sql/insert_rams_windows_config_data.sql =================================================================== diff -u --- lams_common/db/sql/insert_rams_windows_config_data.sql (revision 0) +++ lams_common/db/sql/insert_rams_windows_config_data.sql (revision d89181efec67506914f57c2449036c85cf01094c) @@ -0,0 +1,32 @@ +insert into lams_configuration (config_key, config_value) values ('ServerURL','http://localhost:8080/lams/'); +insert into lams_configuration (config_key, config_value) values ('Version','1.0'); +insert into lams_configuration (config_key, config_value) values ('TempDir','C:/lams/temp'); +insert into lams_configuration (config_key, config_value) values ('DumpDir','C:/lams/dump'); +insert into lams_configuration (config_key, config_value) values ('EARDir','C:/jboss-4.0.2/server/default/deploy/lams.ear'); +insert into lams_configuration (config_key, config_value) values ('SMTPServer',''); +insert into lams_configuration (config_key, config_value) values ('LamsSupportEmail','lams_support@melcoe.mq.edu.au'); +insert into lams_configuration (config_key, config_value) values ('ContentRepositoryPath','C:/lams/repository'); +insert into lams_configuration (config_key, config_value) values ('UploadFileMaxSize','1048576'); +insert into lams_configuration (config_key, config_value) values ('UploadLargeFileMaxSize','10485760'); +insert into lams_configuration (config_key, config_value) values ('UploadFileMaxMemorySize','4096'); +insert into lams_configuration (config_key, config_value) values ('ExecutableExtensions','.bat,.bin,.com,.cmd,.exe,.msi,.msp,.ocx,.pif,.scr,.sct,.sh,.shs,.vbs'); +insert into lams_configuration (config_key, config_value) values ('UserInactiveTimeout','86400'); +insert into lams_configuration (config_key, config_value) values ('UseCacheDebugListener','false'); +insert into lams_configuration (config_key, config_value) values ('CleanupPreviewOlderThanDays','7'); +insert into lams_configuration (config_key, config_value) values ('AuthoringActivitiesColour', 'true'); +insert into lams_configuration (config_key, config_value) values ('AuthoringClientVersion','1.0.@datetimestamp@'); +insert into lams_configuration (config_key, config_value) values ('MonitorClientVersion','1.0.@datetimestamp@'); +insert into lams_configuration (config_key, config_value) values ('LearnerClientVersion','1.0.@datetimestamp@'); +insert into lams_configuration (config_key, config_value) values ('ServerVersionNumber','1.0.@datetimestamp@'); +insert into lams_configuration (config_key, config_value) values ('ServerLanguage','en_AU'); +insert into lams_configuration (config_key, config_value) values ('ServerPageDirection','LTR'); +insert into lams_configuration (config_key, config_value) values ('DictionaryDateCreated','2007-03-19'); +insert into lams_configuration (config_key, config_value) values ('HelpURL','http://wiki.lamsfoundation.org/display/lamsdocs/'); +insert into lams_configuration (config_key, config_value) values ('XmppDomain','shaun.melcoe.mq.edu.au'); +insert into lams_configuration (config_key, config_value) values ('XmppConference','conference.shaun.melcoe.mq.edu.au'); +insert into lams_configuration (config_key, config_value) values ('XmppAdmin','admin'); +insert into lams_configuration (config_key, config_value) values ('XmppPassword','wildfire'); +insert into lams_configuration (config_key, config_value) values ('DefaultFlashTheme','rams'); +insert into lams_configuration (config_key, config_value) values ('DefaultHTMLTheme','ramsthemeHTML'); +insert into lams_configuration (config_key, config_value) values ('AllowDirectLessonLaunch','false'); +insert into lams_configuration (config_key, config_value) values ('LAMS_Community_enable','false'); \ No newline at end of file Fisheye: Tag d89181efec67506914f57c2449036c85cf01094c refers to a dead (removed) revision in file `lams_common/db/sql/insert_unix_config_data.sql'. Fisheye: No comparison available. Pass `N' to diff? Fisheye: Tag d89181efec67506914f57c2449036c85cf01094c refers to a dead (removed) revision in file `lams_common/db/sql/insert_users.sql'. Fisheye: No comparison available. Pass `N' to diff? Fisheye: Tag d89181efec67506914f57c2449036c85cf01094c refers to a dead (removed) revision in file `lams_common/db/sql/insert_windows_config_data.sql'. Fisheye: No comparison available. Pass `N' to diff? Index: lams_common/db/sql/updatescripts/alter_203_rams_theme.sql =================================================================== diff -u --- lams_common/db/sql/updatescripts/alter_203_rams_theme.sql (revision 0) +++ lams_common/db/sql/updatescripts/alter_203_rams_theme.sql (revision d89181efec67506914f57c2449036c85cf01094c) @@ -0,0 +1,4 @@ +-- add the records for the RAMS theme + +INSERT INTO lams_css_theme_ve (name, description, parent_id, theme_flag, image_directory) VALUES ("rams", "RAMS Default Flash style", null, 1, null); +INSERT INTO lams_css_theme_ve (name, description, parent_id, theme_flag, image_directory) VALUES ("ramsthemeHTML", "RAMS Default HTML sty;e", null, 1, "ramsthemecss"); Index: lams_www/build.xml =================================================================== diff -u -r3444b8fd799f3e9fac736cfceed054a7113aecf1 -rd89181efec67506914f57c2449036c85cf01094c --- lams_www/build.xml (.../build.xml) (revision 3444b8fd799f3e9fac736cfceed054a7113aecf1) +++ lams_www/build.xml (.../build.xml) (revision d89181efec67506914f57c2449036c85cf01094c) @@ -80,6 +80,14 @@ + + + + + + + + @@ -102,7 +110,8 @@ - + + Index: lams_www/conf/lams/learner.logo.swf =================================================================== diff -u Binary files differ Index: lams_www/conf/lams/monitor.logo.swf =================================================================== diff -u Binary files differ Index: lams_www/conf/rams/learner.logo.swf =================================================================== diff -u Binary files differ Index: lams_www/conf/rams/monitor.logo.swf =================================================================== diff -u Binary files differ