Index: lams_common/db/sql/insert_lams_users.sql =================================================================== RCS file: /usr/local/cvsroot/lams_common/db/sql/insert_lams_users.sql,v diff -u -r1.6.2.4 -r1.6.2.5 --- lams_common/db/sql/insert_lams_users.sql 25 Nov 2016 00:48:13 -0000 1.6.2.4 +++ lams_common/db/sql/insert_lams_users.sql 27 Feb 2017 14:00:08 -0000 1.6.2.5 @@ -3,178 +3,138 @@ SET FOREIGN_KEY_CHECKS=0; -- themes and styles -INSERT INTO lams_theme (theme_id, name, description, image_directory, theme_type) VALUES (1, "default", "Default Flash style", null, 2); -INSERT INTO lams_theme (theme_id, name, description, image_directory, theme_type) VALUES (2, "defaultHTML", "Default HTML style", "css", 1); +INSERT INTO lams_theme (theme_id, name, description, image_directory) VALUES (1, "defaultHTML", "Default HTML style", "css"); --- new high contrast theme LDEV-2419 -INSERT INTO lams_theme (theme_id, name, description, image_directory, theme_type) VALUES (3, "highContrast", "High Contrast HTML style", "css", 1); +insert into lams_workspace_folder (workspace_folder_id,parent_folder_id,name,user_id,organisation_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,user_id,organisation_id,create_date_time,last_modified_date_time,lams_workspace_folder_type_id) +values(2,1,'Developers Playpen',1,2,'20041223','20041223',1); -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 (workspace_id, name, default_fld_id) values(52,'Public Folder',46); +insert into lams_workspace_folder (workspace_folder_id,parent_folder_id,name,user_id,organisation_id,create_date_time,last_modified_date_time,lams_workspace_folder_type_id) +values(22,2,'Lesson Sequence Folder',1,2,'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(1,null,'ROOT',1,'20041223','20041223',1); +insert into lams_workspace_folder (workspace_folder_id,parent_folder_id,name,user_id,organisation_id,create_date_time,last_modified_date_time,lams_workspace_folder_type_id) +values(3,1,'MATH111',1,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(2,1,'Developers Playpen',1,'20041223','20041223',1); +insert into lams_workspace_folder (workspace_folder_id,parent_folder_id,name,user_id,organisation_id,create_date_time,last_modified_date_time,lams_workspace_folder_type_id) +values(23,3,'Lesson Sequence Folder',1,4,'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(22,2,'Lesson Sequence Folder',1,'20041223','20041223',2); +insert into lams_workspace_folder (workspace_folder_id,parent_folder_id,name,user_id,organisation_id,create_date_time,last_modified_date_time,lams_workspace_folder_type_id) +values(4,null,'Mary Morgan',4,NULL,'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(3,1,'MATH111',1,'20041223','20041223',1); +insert into lams_workspace_folder (workspace_folder_id,parent_folder_id,name,user_id,organisation_id,create_date_time,last_modified_date_time,lams_workspace_folder_type_id) +values(5,null,'One Test',5,NULL,'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,organisation_id,create_date_time,last_modified_date_time,lams_workspace_folder_type_id) +values(6,null,'Two Test',6,NULL,'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(4,null,'Mary Morgan',4,'20041223','20041223',1); +insert into lams_workspace_folder (workspace_folder_id,parent_folder_id,name,user_id,organisation_id,create_date_time,last_modified_date_time,lams_workspace_folder_type_id) +values(7,null,'Three Test',7,NULL,'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,organisation_id,create_date_time,last_modified_date_time,lams_workspace_folder_type_id) +values(8,null,'Four Test',8,NULL,'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,organisation_id,create_date_time,last_modified_date_time,lams_workspace_folder_type_id) +values(40,1,'Moodle Test',1,7,'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(7,null,'Three Test',7,'20041223','20041223',1); +insert into lams_workspace_folder (workspace_folder_id,parent_folder_id,name,user_id,organisation_id,create_date_time,last_modified_date_time,lams_workspace_folder_type_id) +values(41,40,'Lesson Sequence Folder',1,7,'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(8,null,'Four Test',8,'20041223','20041223',1); +insert into lams_workspace_folder (workspace_folder_id,parent_folder_id,name,user_id,organisation_id,create_date_time,last_modified_date_time,lams_workspace_folder_type_id) +values(45,null,'System Administrator',1,NULL,'20061101','20061101',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,organisation_id,create_date_time,last_modified_date_time,lams_workspace_folder_type_id) +values(46,1,'Public Folder',1,NULL,'20041223','20041223',3); -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_workspace_folder (workspace_folder_id,parent_folder_id,name,user_id,create_date_time,last_modified_date_time,lams_workspace_folder_type_id) -values(46,1,'Public Folder',1,'20041223','20041223',3); - -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_wkspc_wkspc_folder (id, workspace_id, workspace_folder_id) values (13, 52,46); - -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, enable_course_notifications, enable_monitor_gradebook, enable_learner_gradebook) - VALUES (2, 'Playpen', 'PP101', 'Developers Playpen',1,2,NOW(),1,2,1,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 (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, enable_course_notifications, enable_monitor_gradebook, enable_learner_gradebook) - VALUES (4, 'Mathematics 1', 'MATH111', 'Mathematics 1',1,2,NOW(),1,3,2,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 (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); +INSERT INTO lams_organisation (organisation_id, name, code, description, parent_organisation_id, organisation_type_id, create_date, created_by, locale_id, organisation_state_id) + VALUES (1, 'Root', null, 'Root Organisation',null,1,NOW(),1,1,1); +INSERT INTO lams_organisation (organisation_id, name, code, description, parent_organisation_id, organisation_type_id, create_date, created_by, locale_id, organisation_state_id, enable_course_notifications, enable_monitor_gradebook, enable_learner_gradebook) + VALUES (2, 'Playpen', 'PP101', 'Developers Playpen',1,2,NOW(),1,2,1,1,1,1); +INSERT INTO lams_organisation (organisation_id, name, code, description, parent_organisation_id, organisation_type_id, create_date, created_by, locale_id, organisation_state_id) + VALUES (3, 'Everybody', null, 'All People In Course',2,3,NOW(),1,1,1); +INSERT INTO lams_organisation (organisation_id, name, code, description, parent_organisation_id, organisation_type_id, create_date, created_by, locale_id, organisation_state_id, enable_course_notifications, enable_monitor_gradebook, enable_learner_gradebook) + VALUES (4, 'Mathematics 1', 'MATH111', 'Mathematics 1',1,2,NOW(),1,2,1,1,1,1); +INSERT INTO lams_organisation (organisation_id, name, code, description, parent_organisation_id, organisation_type_id, create_date, created_by, locale_id, organisation_state_id) + VALUES (5, 'Tutorial Group A', 'TUTA', 'Tutorial Group A',4,3,NOW(),1,2,1); +INSERT INTO lams_organisation (organisation_id, name, code, description, parent_organisation_id, organisation_type_id, create_date, created_by, locale_id, organisation_state_id) + VALUES (6, 'Tutorial Group B', 'TUTB', 'Tutorial Group B',4,3,NOW(),1,2,1); +INSERT INTO lams_organisation (organisation_id, name, code, description, parent_organisation_id, organisation_type_id, create_date, created_by, locale_id, organisation_state_id) + VALUES (7, 'Moodle', 'Moodle', 'Moodle Test',1,2,NOW(),1,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, timezone) +disabled_flag,create_date,authentication_method_id,workspace_folder_id, +locale_id, theme_id, timezone) 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,'Etc/GMT'); +0,NOW(),1,45, +1,1,'Etc/GMT'); 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, timezone) +disabled_flag,create_date,authentication_method_id,workspace_folder_id, +locale_id, theme_id, timezone) 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,'Etc/GMT'); +3,1,'Etc/GMT'); -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, timezone) -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,'Etc/GMT'); - 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, timezone) +disabled_flag,create_date,authentication_method_id,workspace_folder_id, +locale_id, theme_id, timezone) 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,'Etc/GMT'); +0,'20041223',1,4,1,1,'Etc/GMT'); 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, timezone) +disabled_flag,create_date,authentication_method_id,workspace_folder_id, +locale_id, theme_id, timezone) 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,'Etc/GMT'); +0,'20041223',1,5,1,1,'Etc/GMT'); 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, timezone) +disabled_flag,create_date,authentication_method_id,workspace_folder_id, +locale_id, theme_id, timezone) 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,'Etc/GMT'); +0,'20041223',1,6,1,1,'Etc/GMT'); 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, timezone) +disabled_flag,create_date,authentication_method_id,workspace_folder_id, +locale_id, theme_id, timezone) 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,'Etc/GMT'); +0,'20041223',1,7,1,1,'Etc/GMT'); 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, timezone) +disabled_flag,create_date,authentication_method_id,workspace_folder_id, +locale_id, theme_id, timezone) 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,'Etc/GMT'); +0,'20041223',1,8,1,1,'Etc/GMT'); --- sysadmin only belongs to root and public INSERT INTO lams_user_organisation (user_organisation_id, organisation_id, user_id) VALUES (1, 1, 1);