Index: lams_common/db/sql/shaun/all.sql =================================================================== diff -u -r5c156dd9fe8bc13cdf41a03a75fd17ba2a3b1ae8 -ra7727f44ee7a401bc85f9addb6ce145c3df6f793 --- lams_common/db/sql/shaun/all.sql (.../all.sql) (revision 5c156dd9fe8bc13cdf41a03a75fd17ba2a3b1ae8) +++ lams_common/db/sql/shaun/all.sql (.../all.sql) (revision a7727f44ee7a401bc85f9addb6ce145c3df6f793) @@ -614,12 +614,12 @@ INSERT INTO lams_user_organisation (user_organisation_id, organisation_id, user_id) VALUES (79, 3, 35); -- need a new user_organisation_role_id for each row, use the same role_ids (3,5,2) for author, learner, teacher -INSERT INTO lams_user_organisation_role (user_organisation_role_id, user_organisation_id, role_id) VALUES (210,78,3); -INSERT INTO lams_user_organisation_role (user_organisation_role_id, user_organisation_id, role_id) VALUES (211,78,5); -INSERT INTO lams_user_organisation_role (user_organisation_role_id, user_organisation_id, role_id) VALUES (212,78,2); -INSERT INTO lams_user_organisation_role (user_organisation_role_id, user_organisation_id, role_id) VALUES (213,79,4); -INSERT INTO lams_user_organisation_role (user_organisation_role_id, user_organisation_id, role_id) VALUES (214,79,5); -INSERT INTO lams_user_organisation_role (user_organisation_role_id, user_organisation_id, role_id) VALUES (215,79,2); +INSERT INTO lams_user_organisation_role (user_organisation_role_id, user_organisation_id, role_id) VALUES (216,78,3); +INSERT INTO lams_user_organisation_role (user_organisation_role_id, user_organisation_id, role_id) VALUES (217,78,5); +INSERT INTO lams_user_organisation_role (user_organisation_role_id, user_organisation_id, role_id) VALUES (218,78,2); +INSERT INTO lams_user_organisation_role (user_organisation_role_id, user_organisation_id, role_id) VALUES (219,79,4); +INSERT INTO lams_user_organisation_role (user_organisation_role_id, user_organisation_id, role_id) VALUES (220,79,5); +INSERT INTO lams_user_organisation_role (user_organisation_role_id, user_organisation_id, role_id) VALUES (221,79,2); SET FOREIGN_KEY_CHECKS=1;