Index: lams_common/db/sql/shaun/all.sql =================================================================== RCS file: /usr/local/cvsroot/lams_common/db/sql/shaun/Attic/all.sql,v diff -u -r1.3 -r1.4 --- lams_common/db/sql/shaun/all.sql 18 Aug 2006 05:20:07 -0000 1.3 +++ lams_common/db/sql/shaun/all.sql 5 Sep 2006 00:33:17 -0000 1.4 @@ -265,8 +265,8 @@ -- 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, 5, 15); -INSERT INTO lams_user_organisation (user_organisation_id, organisation_id, user_id) VALUES (43, 5, 15); +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); -- need a new user_organisation_role_id for each row, use the same role_ids (3,4,2) for author, learner, teacher INSERT INTO lams_user_organisation_role (user_organisation_role_id, user_organisation_id, role_id) VALUES (102,42,3);