Index: lams_common/db/sql/shaun/lams_user_bulgarian.sql =================================================================== diff -u -r2e71958d5ce8fd25642197ffcf432754daa7cf00 -rc0668a550d7d31e3312555e8ac807f36f86b8d5c --- lams_common/db/sql/shaun/lams_user_bulgarian.sql (.../lams_user_bulgarian.sql) (revision 2e71958d5ce8fd25642197ffcf432754daa7cf00) +++ lams_common/db/sql/shaun/lams_user_bulgarian.sql (.../lams_user_bulgarian.sql) (revision c0668a550d7d31e3312555e8ac807f36f86b8d5c) @@ -13,11 +13,11 @@ INSERT INTO lams_user_organisation (user_organisation_id, organisation_id, user_id) VALUES (34, 2, 11); INSERT INTO lams_user_organisation (user_organisation_id, organisation_id, user_id) VALUES (35, 3, 11); --- need a new user_organisation_role_id for each row, use the same role_ids (3,4,6) for author, learner, teacher +-- need a new user_organisation_role_id for each row, use the same role_ids (3,5,6) for author, learner, teacher INSERT INTO lams_user_organisation_role (user_organisation_role_id, user_organisation_id, role_id) VALUES (82,34,3); -INSERT INTO lams_user_organisation_role (user_organisation_role_id, user_organisation_id, role_id) VALUES (83,34,4); +INSERT INTO lams_user_organisation_role (user_organisation_role_id, user_organisation_id, role_id) VALUES (83,34,5); INSERT INTO lams_user_organisation_role (user_organisation_role_id, user_organisation_id, role_id) VALUES (84,34,6); -INSERT INTO lams_user_organisation_role (user_organisation_role_id, user_organisation_id, role_id) VALUES (85,35,4); +INSERT INTO lams_user_organisation_role (user_organisation_role_id, user_organisation_id, role_id) VALUES (85,35,5); INSERT INTO lams_user_organisation_role (user_organisation_role_id, user_organisation_id, role_id) VALUES (86,35,6); SET FOREIGN_KEY_CHECKS=1; \ No newline at end of file Index: lams_common/db/sql/shaun/lams_user_chinese.sql =================================================================== diff -u -r2e71958d5ce8fd25642197ffcf432754daa7cf00 -rc0668a550d7d31e3312555e8ac807f36f86b8d5c --- lams_common/db/sql/shaun/lams_user_chinese.sql (.../lams_user_chinese.sql) (revision 2e71958d5ce8fd25642197ffcf432754daa7cf00) +++ lams_common/db/sql/shaun/lams_user_chinese.sql (.../lams_user_chinese.sql) (revision c0668a550d7d31e3312555e8ac807f36f86b8d5c) @@ -13,11 +13,11 @@ INSERT INTO lams_user_organisation (user_organisation_id, organisation_id, user_id) VALUES (36, 2, 12); INSERT INTO lams_user_organisation (user_organisation_id, organisation_id, user_id) VALUES (37, 3, 12); --- need a new user_organisation_role_id for each row, use the same role_ids (3,4,6) for author, learner, teacher +-- need a new user_organisation_role_id for each row, use the same role_ids (3,5,6) for author, learner, teacher INSERT INTO lams_user_organisation_role (user_organisation_role_id, user_organisation_id, role_id) VALUES (87,36,3); -INSERT INTO lams_user_organisation_role (user_organisation_role_id, user_organisation_id, role_id) VALUES (88,36,4); +INSERT INTO lams_user_organisation_role (user_organisation_role_id, user_organisation_id, role_id) VALUES (88,36,5); INSERT INTO lams_user_organisation_role (user_organisation_role_id, user_organisation_id, role_id) VALUES (89,36,6); -INSERT INTO lams_user_organisation_role (user_organisation_role_id, user_organisation_id, role_id) VALUES (90,37,4); +INSERT INTO lams_user_organisation_role (user_organisation_role_id, user_organisation_id, role_id) VALUES (90,37,5); INSERT INTO lams_user_organisation_role (user_organisation_role_id, user_organisation_id, role_id) VALUES (91,37,6); Index: lams_common/db/sql/shaun/lams_user_french.sql =================================================================== diff -u -r2e71958d5ce8fd25642197ffcf432754daa7cf00 -rc0668a550d7d31e3312555e8ac807f36f86b8d5c --- lams_common/db/sql/shaun/lams_user_french.sql (.../lams_user_french.sql) (revision 2e71958d5ce8fd25642197ffcf432754daa7cf00) +++ lams_common/db/sql/shaun/lams_user_french.sql (.../lams_user_french.sql) (revision c0668a550d7d31e3312555e8ac807f36f86b8d5c) @@ -13,11 +13,11 @@ INSERT INTO lams_user_organisation (user_organisation_id, organisation_id, user_id) VALUES (32, 2, 10); INSERT INTO lams_user_organisation (user_organisation_id, organisation_id, user_id) VALUES (33, 3, 10); --- need a new user_organisation_role_id for each row, use the same role_ids (3,4,6) for author, learner, teacher +-- need a new user_organisation_role_id for each row, use the same role_ids (3,5,6) for author, learner, teacher INSERT INTO lams_user_organisation_role (user_organisation_role_id, user_organisation_id, role_id) VALUES (77,32,3); -INSERT INTO lams_user_organisation_role (user_organisation_role_id, user_organisation_id, role_id) VALUES (78,32,4); +INSERT INTO lams_user_organisation_role (user_organisation_role_id, user_organisation_id, role_id) VALUES (78,32,5); INSERT INTO lams_user_organisation_role (user_organisation_role_id, user_organisation_id, role_id) VALUES (79,32,6); -INSERT INTO lams_user_organisation_role (user_organisation_role_id, user_organisation_id, role_id) VALUES (80,33,4); +INSERT INTO lams_user_organisation_role (user_organisation_role_id, user_organisation_id, role_id) VALUES (80,33,5); INSERT INTO lams_user_organisation_role (user_organisation_role_id, user_organisation_id, role_id) VALUES (81,33,6); SET FOREIGN_KEY_CHECKS=1; \ No newline at end of file Index: lams_common/db/sql/shaun/lams_user_german.sql =================================================================== diff -u -r2e71958d5ce8fd25642197ffcf432754daa7cf00 -rc0668a550d7d31e3312555e8ac807f36f86b8d5c --- lams_common/db/sql/shaun/lams_user_german.sql (.../lams_user_german.sql) (revision 2e71958d5ce8fd25642197ffcf432754daa7cf00) +++ lams_common/db/sql/shaun/lams_user_german.sql (.../lams_user_german.sql) (revision c0668a550d7d31e3312555e8ac807f36f86b8d5c) @@ -13,11 +13,11 @@ INSERT INTO lams_user_organisation (user_organisation_id, organisation_id, user_id) VALUES (38, 2, 13); INSERT INTO lams_user_organisation (user_organisation_id, organisation_id, user_id) VALUES (39, 3, 13); --- need a new user_organisation_role_id for each row, use the same role_ids (3,4,6) for author, learner, teacher +-- need a new user_organisation_role_id for each row, use the same role_ids (3,5,6) for author, learner, teacher INSERT INTO lams_user_organisation_role (user_organisation_role_id, user_organisation_id, role_id) VALUES (92,38,3); -INSERT INTO lams_user_organisation_role (user_organisation_role_id, user_organisation_id, role_id) VALUES (93,38,4); +INSERT INTO lams_user_organisation_role (user_organisation_role_id, user_organisation_id, role_id) VALUES (93,38,5); INSERT INTO lams_user_organisation_role (user_organisation_role_id, user_organisation_id, role_id) VALUES (94,38,6); -INSERT INTO lams_user_organisation_role (user_organisation_role_id, user_organisation_id, role_id) VALUES (95,39,4); +INSERT INTO lams_user_organisation_role (user_organisation_role_id, user_organisation_id, role_id) VALUES (95,39,5); INSERT INTO lams_user_organisation_role (user_organisation_role_id, user_organisation_id, role_id) VALUES (96,39,6); SET FOREIGN_KEY_CHECKS=1; \ No newline at end of file Index: lams_common/db/sql/shaun/lams_user_hungarian.sql =================================================================== diff -u -r2e71958d5ce8fd25642197ffcf432754daa7cf00 -rc0668a550d7d31e3312555e8ac807f36f86b8d5c --- lams_common/db/sql/shaun/lams_user_hungarian.sql (.../lams_user_hungarian.sql) (revision 2e71958d5ce8fd25642197ffcf432754daa7cf00) +++ lams_common/db/sql/shaun/lams_user_hungarian.sql (.../lams_user_hungarian.sql) (revision c0668a550d7d31e3312555e8ac807f36f86b8d5c) @@ -13,11 +13,11 @@ INSERT INTO lams_user_organisation (user_organisation_id, organisation_id, user_id) VALUES (54, 2, 21); INSERT INTO lams_user_organisation (user_organisation_id, organisation_id, user_id) VALUES (55, 3, 21); --- need a new user_organisation_role_id for each row, use the same role_ids (3,4,6) for author, learner, teacher +-- need a new user_organisation_role_id for each row, use the same role_ids (3,5,6) for author, learner, teacher INSERT INTO lams_user_organisation_role (user_organisation_role_id, user_organisation_id, role_id) VALUES (132,54,3); -INSERT INTO lams_user_organisation_role (user_organisation_role_id, user_organisation_id, role_id) VALUES (133,54,4); +INSERT INTO lams_user_organisation_role (user_organisation_role_id, user_organisation_id, role_id) VALUES (133,54,5); INSERT INTO lams_user_organisation_role (user_organisation_role_id, user_organisation_id, role_id) VALUES (134,54,6); -INSERT INTO lams_user_organisation_role (user_organisation_role_id, user_organisation_id, role_id) VALUES (135,55,4); +INSERT INTO lams_user_organisation_role (user_organisation_role_id, user_organisation_id, role_id) VALUES (135,55,5); INSERT INTO lams_user_organisation_role (user_organisation_role_id, user_organisation_id, role_id) VALUES (136,55,6); SET FOREIGN_KEY_CHECKS=1; \ No newline at end of file Index: lams_common/db/sql/shaun/lams_user_italian.sql =================================================================== diff -u -r2e71958d5ce8fd25642197ffcf432754daa7cf00 -rc0668a550d7d31e3312555e8ac807f36f86b8d5c --- lams_common/db/sql/shaun/lams_user_italian.sql (.../lams_user_italian.sql) (revision 2e71958d5ce8fd25642197ffcf432754daa7cf00) +++ lams_common/db/sql/shaun/lams_user_italian.sql (.../lams_user_italian.sql) (revision c0668a550d7d31e3312555e8ac807f36f86b8d5c) @@ -13,11 +13,11 @@ INSERT INTO lams_user_organisation (user_organisation_id, organisation_id, user_id) VALUES (44, 2, 16); INSERT INTO lams_user_organisation (user_organisation_id, organisation_id, user_id) VALUES (45, 3, 16); --- need a new user_organisation_role_id for each row, use the same role_ids (3,4,6) for author, learner, teacher +-- need a new user_organisation_role_id for each row, use the same role_ids (3,5,6) for author, learner, teacher INSERT INTO lams_user_organisation_role (user_organisation_role_id, user_organisation_id, role_id) VALUES (107,44,3); -INSERT INTO lams_user_organisation_role (user_organisation_role_id, user_organisation_id, role_id) VALUES (108,44,4); +INSERT INTO lams_user_organisation_role (user_organisation_role_id, user_organisation_id, role_id) VALUES (108,44,5); INSERT INTO lams_user_organisation_role (user_organisation_role_id, user_organisation_id, role_id) VALUES (109,44,6); -INSERT INTO lams_user_organisation_role (user_organisation_role_id, user_organisation_id, role_id) VALUES (110,45,4); +INSERT INTO lams_user_organisation_role (user_organisation_role_id, user_organisation_id, role_id) VALUES (110,45,5); INSERT INTO lams_user_organisation_role (user_organisation_role_id, user_organisation_id, role_id) VALUES (111,45,6); Index: lams_common/db/sql/shaun/lams_user_korean.sql =================================================================== diff -u -r2e71958d5ce8fd25642197ffcf432754daa7cf00 -rc0668a550d7d31e3312555e8ac807f36f86b8d5c --- lams_common/db/sql/shaun/lams_user_korean.sql (.../lams_user_korean.sql) (revision 2e71958d5ce8fd25642197ffcf432754daa7cf00) +++ lams_common/db/sql/shaun/lams_user_korean.sql (.../lams_user_korean.sql) (revision c0668a550d7d31e3312555e8ac807f36f86b8d5c) @@ -13,11 +13,11 @@ INSERT INTO lams_user_organisation (user_organisation_id, organisation_id, user_id) VALUES (48, 2, 18); INSERT INTO lams_user_organisation (user_organisation_id, organisation_id, user_id) VALUES (49, 3, 18); --- need a new user_organisation_role_id for each row, use the same role_ids (3,4,6) for author, learner, teacher +-- need a new user_organisation_role_id for each row, use the same role_ids (3,5,6) for author, learner, teacher INSERT INTO lams_user_organisation_role (user_organisation_role_id, user_organisation_id, role_id) VALUES (117,48,3); -INSERT INTO lams_user_organisation_role (user_organisation_role_id, user_organisation_id, role_id) VALUES (118,48,4); +INSERT INTO lams_user_organisation_role (user_organisation_role_id, user_organisation_id, role_id) VALUES (118,48,5); INSERT INTO lams_user_organisation_role (user_organisation_role_id, user_organisation_id, role_id) VALUES (119,48,6); -INSERT INTO lams_user_organisation_role (user_organisation_role_id, user_organisation_id, role_id) VALUES (120,49,4); +INSERT INTO lams_user_organisation_role (user_organisation_role_id, user_organisation_id, role_id) VALUES (120,49,5); INSERT INTO lams_user_organisation_role (user_organisation_role_id, user_organisation_id, role_id) VALUES (121,49,6); Index: lams_common/db/sql/shaun/lams_user_maori.sql =================================================================== diff -u -r2e71958d5ce8fd25642197ffcf432754daa7cf00 -rc0668a550d7d31e3312555e8ac807f36f86b8d5c --- lams_common/db/sql/shaun/lams_user_maori.sql (.../lams_user_maori.sql) (revision 2e71958d5ce8fd25642197ffcf432754daa7cf00) +++ lams_common/db/sql/shaun/lams_user_maori.sql (.../lams_user_maori.sql) (revision c0668a550d7d31e3312555e8ac807f36f86b8d5c) @@ -13,11 +13,11 @@ INSERT INTO lams_user_organisation (user_organisation_id, organisation_id, user_id) VALUES (52, 2, 20); INSERT INTO lams_user_organisation (user_organisation_id, organisation_id, user_id) VALUES (53, 3, 20); --- need a new user_organisation_role_id for each row, use the same role_ids (3,4,6) for author, learner, teacher +-- need a new user_organisation_role_id for each row, use the same role_ids (3,5,6) for author, learner, teacher INSERT INTO lams_user_organisation_role (user_organisation_role_id, user_organisation_id, role_id) VALUES (127,52,3); -INSERT INTO lams_user_organisation_role (user_organisation_role_id, user_organisation_id, role_id) VALUES (128,52,4); +INSERT INTO lams_user_organisation_role (user_organisation_role_id, user_organisation_id, role_id) VALUES (128,52,5); INSERT INTO lams_user_organisation_role (user_organisation_role_id, user_organisation_id, role_id) VALUES (129,52,6); -INSERT INTO lams_user_organisation_role (user_organisation_role_id, user_organisation_id, role_id) VALUES (130,53,4); +INSERT INTO lams_user_organisation_role (user_organisation_role_id, user_organisation_id, role_id) VALUES (130,53,5); INSERT INTO lams_user_organisation_role (user_organisation_role_id, user_organisation_id, role_id) VALUES (131,53,6); SET FOREIGN_KEY_CHECKS=1; \ No newline at end of file Index: lams_common/db/sql/shaun/lams_user_norwegian.sql =================================================================== diff -u -r2e71958d5ce8fd25642197ffcf432754daa7cf00 -rc0668a550d7d31e3312555e8ac807f36f86b8d5c --- lams_common/db/sql/shaun/lams_user_norwegian.sql (.../lams_user_norwegian.sql) (revision 2e71958d5ce8fd25642197ffcf432754daa7cf00) +++ lams_common/db/sql/shaun/lams_user_norwegian.sql (.../lams_user_norwegian.sql) (revision c0668a550d7d31e3312555e8ac807f36f86b8d5c) @@ -13,11 +13,11 @@ INSERT INTO lams_user_organisation (user_organisation_id, organisation_id, user_id) VALUES (40, 2, 14); INSERT INTO lams_user_organisation (user_organisation_id, organisation_id, user_id) VALUES (41, 3, 14); --- need a new user_organisation_role_id for each row, use the same role_ids (3,4,6) for author, learner, teacher +-- need a new user_organisation_role_id for each row, use the same role_ids (3,5,6) for author, learner, teacher INSERT INTO lams_user_organisation_role (user_organisation_role_id, user_organisation_id, role_id) VALUES (97,40,3); -INSERT INTO lams_user_organisation_role (user_organisation_role_id, user_organisation_id, role_id) VALUES (98,40,4); +INSERT INTO lams_user_organisation_role (user_organisation_role_id, user_organisation_id, role_id) VALUES (98,40,5); INSERT INTO lams_user_organisation_role (user_organisation_role_id, user_organisation_id, role_id) VALUES (99,40,6); -INSERT INTO lams_user_organisation_role (user_organisation_role_id, user_organisation_id, role_id) VALUES (100,41,4); +INSERT INTO lams_user_organisation_role (user_organisation_role_id, user_organisation_id, role_id) VALUES (100,41,5); INSERT INTO lams_user_organisation_role (user_organisation_role_id, user_organisation_id, role_id) VALUES (101,41,6); SET FOREIGN_KEY_CHECKS=1; \ No newline at end of file Index: lams_common/db/sql/shaun/lams_user_polish.sql =================================================================== diff -u -r2e71958d5ce8fd25642197ffcf432754daa7cf00 -rc0668a550d7d31e3312555e8ac807f36f86b8d5c --- lams_common/db/sql/shaun/lams_user_polish.sql (.../lams_user_polish.sql) (revision 2e71958d5ce8fd25642197ffcf432754daa7cf00) +++ lams_common/db/sql/shaun/lams_user_polish.sql (.../lams_user_polish.sql) (revision c0668a550d7d31e3312555e8ac807f36f86b8d5c) @@ -13,11 +13,11 @@ INSERT INTO lams_user_organisation (user_organisation_id, organisation_id, user_id) VALUES (46, 2, 17); INSERT INTO lams_user_organisation (user_organisation_id, organisation_id, user_id) VALUES (47, 3, 17); --- need a new user_organisation_role_id for each row, use the same role_ids (3,4,6) for author, learner, teacher +-- need a new user_organisation_role_id for each row, use the same role_ids (3,5,6) for author, learner, teacher INSERT INTO lams_user_organisation_role (user_organisation_role_id, user_organisation_id, role_id) VALUES (112,46,3); -INSERT INTO lams_user_organisation_role (user_organisation_role_id, user_organisation_id, role_id) VALUES (113,46,4); +INSERT INTO lams_user_organisation_role (user_organisation_role_id, user_organisation_id, role_id) VALUES (113,46,5); INSERT INTO lams_user_organisation_role (user_organisation_role_id, user_organisation_id, role_id) VALUES (114,46,6); -INSERT INTO lams_user_organisation_role (user_organisation_role_id, user_organisation_id, role_id) VALUES (115,47,4); +INSERT INTO lams_user_organisation_role (user_organisation_role_id, user_organisation_id, role_id) VALUES (115,47,5); INSERT INTO lams_user_organisation_role (user_organisation_role_id, user_organisation_id, role_id) VALUES (116,47,6); Index: lams_common/db/sql/shaun/lams_user_portbr.sql =================================================================== diff -u -r2e71958d5ce8fd25642197ffcf432754daa7cf00 -rc0668a550d7d31e3312555e8ac807f36f86b8d5c --- lams_common/db/sql/shaun/lams_user_portbr.sql (.../lams_user_portbr.sql) (revision 2e71958d5ce8fd25642197ffcf432754daa7cf00) +++ lams_common/db/sql/shaun/lams_user_portbr.sql (.../lams_user_portbr.sql) (revision c0668a550d7d31e3312555e8ac807f36f86b8d5c) @@ -10,14 +10,14 @@ -- need a new user_organisation_id for each row, user_id must match user_id created in the lams_user -- belongs to course Playpen, Class Everybody -INSERT INTO lams_user_organisation (user_organisation_id, organisation_id, user_id) VALUES (42, 2, 15); -INSERT INTO lams_user_organisation (user_organisation_id, organisation_id, user_id) VALUES (43, 3, 15); +INSERT INTO lams_user_organisation (user_organisation_id, organisation_id, user_id) VALUES (42, 5, 15); +INSERT INTO lams_user_organisation (user_organisation_id, organisation_id, user_id) VALUES (43, 5, 15); -- need a new user_organisation_role_id for each row, use the same role_ids (3,4,6) for author, learner, teacher INSERT INTO lams_user_organisation_role (user_organisation_role_id, user_organisation_id, role_id) VALUES (102,42,3); -INSERT INTO lams_user_organisation_role (user_organisation_role_id, user_organisation_id, role_id) VALUES (103,42,4); +INSERT INTO lams_user_organisation_role (user_organisation_role_id, user_organisation_id, role_id) VALUES (103,42,5); INSERT INTO lams_user_organisation_role (user_organisation_role_id, user_organisation_id, role_id) VALUES (104,42,6); -INSERT INTO lams_user_organisation_role (user_organisation_role_id, user_organisation_id, role_id) VALUES (105,43,4); +INSERT INTO lams_user_organisation_role (user_organisation_role_id, user_organisation_id, role_id) VALUES (105,43,5); INSERT INTO lams_user_organisation_role (user_organisation_role_id, user_organisation_id, role_id) VALUES (106,43,6); SET FOREIGN_KEY_CHECKS=1; \ No newline at end of file Index: lams_common/db/sql/shaun/lams_user_spanish.sql =================================================================== diff -u -r2e71958d5ce8fd25642197ffcf432754daa7cf00 -rc0668a550d7d31e3312555e8ac807f36f86b8d5c --- lams_common/db/sql/shaun/lams_user_spanish.sql (.../lams_user_spanish.sql) (revision 2e71958d5ce8fd25642197ffcf432754daa7cf00) +++ lams_common/db/sql/shaun/lams_user_spanish.sql (.../lams_user_spanish.sql) (revision c0668a550d7d31e3312555e8ac807f36f86b8d5c) @@ -13,11 +13,11 @@ INSERT INTO lams_user_organisation (user_organisation_id, organisation_id, user_id) VALUES (50, 2, 19); INSERT INTO lams_user_organisation (user_organisation_id, organisation_id, user_id) VALUES (51, 3, 19); --- need a new user_organisation_role_id for each row, use the same role_ids (3,4,6) for author, learner, teacher +-- need a new user_organisation_role_id for each row, use the same role_ids (3,5,6) for author, learner, teacher INSERT INTO lams_user_organisation_role (user_organisation_role_id, user_organisation_id, role_id) VALUES (122,50,3); -INSERT INTO lams_user_organisation_role (user_organisation_role_id, user_organisation_id, role_id) VALUES (123,50,4); +INSERT INTO lams_user_organisation_role (user_organisation_role_id, user_organisation_id, role_id) VALUES (123,50,5); INSERT INTO lams_user_organisation_role (user_organisation_role_id, user_organisation_id, role_id) VALUES (124,50,6); -INSERT INTO lams_user_organisation_role (user_organisation_role_id, user_organisation_id, role_id) VALUES (125,51,4); +INSERT INTO lams_user_organisation_role (user_organisation_role_id, user_organisation_id, role_id) VALUES (125,51,5); INSERT INTO lams_user_organisation_role (user_organisation_role_id, user_organisation_id, role_id) VALUES (126,51,6); Index: lams_common/db/sql/shaun/lams_user_swedish.sql =================================================================== diff -u -r2e71958d5ce8fd25642197ffcf432754daa7cf00 -rc0668a550d7d31e3312555e8ac807f36f86b8d5c --- lams_common/db/sql/shaun/lams_user_swedish.sql (.../lams_user_swedish.sql) (revision 2e71958d5ce8fd25642197ffcf432754daa7cf00) +++ lams_common/db/sql/shaun/lams_user_swedish.sql (.../lams_user_swedish.sql) (revision c0668a550d7d31e3312555e8ac807f36f86b8d5c) @@ -13,11 +13,11 @@ INSERT INTO lams_user_organisation (user_organisation_id, organisation_id, user_id) VALUES (30, 2, 9); INSERT INTO lams_user_organisation (user_organisation_id, organisation_id, user_id) VALUES (31, 3, 9); --- need a new user_organisation_role_id for each row, use the same role_ids (3,4,6) for author, learner, teacher +-- need a new user_organisation_role_id for each row, use the same role_ids (3,5,6) for author, learner, teacher INSERT INTO lams_user_organisation_role (user_organisation_role_id, user_organisation_id, role_id) VALUES (72,30,3); -INSERT INTO lams_user_organisation_role (user_organisation_role_id, user_organisation_id, role_id) VALUES (73,30,4); +INSERT INTO lams_user_organisation_role (user_organisation_role_id, user_organisation_id, role_id) VALUES (73,30,5); INSERT INTO lams_user_organisation_role (user_organisation_role_id, user_organisation_id, role_id) VALUES (74,30,6); -INSERT INTO lams_user_organisation_role (user_organisation_role_id, user_organisation_id, role_id) VALUES (75,31,4); +INSERT INTO lams_user_organisation_role (user_organisation_role_id, user_organisation_id, role_id) VALUES (75,31,5); INSERT INTO lams_user_organisation_role (user_organisation_role_id, user_organisation_id, role_id) VALUES (76,31,6);