Index: lams_common/db/sql/insert_users.sql
===================================================================
RCS file: /usr/local/cvsroot/lams_common/db/sql/Attic/insert_users.sql,v
diff -u -r1.15 -r1.16
--- lams_common/db/sql/insert_users.sql	19 May 2006 03:37:20 -0000	1.15
+++ lams_common/db/sql/insert_users.sql	23 May 2006 02:09:35 -0000	1.16
@@ -56,18 +56,18 @@
 insert into lams_workspace_folder (workspace_folder_id,parent_folder_id,name,workspace_id,user_id,create_date_time,last_modified_date_time,lams_workspace_folder_type_id)
 values(8,null,'Four Test Workspace',8,8,'20041223','20041223',1);
 
-INSERT INTO lams_organisation (organisation_id, name, description, parent_organisation_id, organisation_type_id, create_date, workspace_id)
-	VALUES (1, 'Root', 'Root Organisation',null,1,NOW(),1);
-INSERT INTO lams_organisation (organisation_id, name, description, parent_organisation_id, organisation_type_id, create_date, workspace_id)
-	VALUES (2, 'Playpen', 'Developers Playpen',1,2,NOW(),2);
-INSERT INTO lams_organisation (organisation_id, name, description, parent_organisation_id, organisation_type_id, create_date, workspace_id)
-	VALUES (3, 'Everybody', 'All People In Course',2,3,NOW(),null);
-INSERT INTO lams_organisation (organisation_id, name, description, parent_organisation_id, organisation_type_id, create_date, workspace_id)
-	VALUES (4, 'MATH111', 'Mathematics 1',1,2,NOW(),3);
-INSERT INTO lams_organisation (organisation_id, name, description, parent_organisation_id, organisation_type_id, create_date, workspace_id)
-	VALUES (5, 'TUTA', 'Tutorial Group A',4,3,NOW(),null);
-INSERT INTO lams_organisation (organisation_id, name, description, parent_organisation_id, organisation_type_id, create_date, workspace_id)
-	VALUES (6, 'TUTB', 'Tutorial Group B',4,3,NOW(),null);
+INSERT INTO lams_organisation (organisation_id, name, code, description, parent_organisation_id, organisation_type_id, create_date, workspace_id)
+	VALUES (1, 'Root', null, 'Root Organisation',null,1,NOW(),1);
+INSERT INTO lams_organisation (organisation_id, name, code, description, parent_organisation_id, organisation_type_id, create_date, workspace_id)
+	VALUES (2, 'Playpen', 'PP101', 'Developers Playpen',1,2,NOW(),2);
+INSERT INTO lams_organisation (organisation_id, name, code, description, parent_organisation_id, organisation_type_id, create_date, workspace_id)
+	VALUES (3, 'Everybody', null, 'All People In Course',2,3,NOW(),null);
+INSERT INTO lams_organisation (organisation_id, name, code, description, parent_organisation_id, organisation_type_id, create_date, workspace_id)
+	VALUES (4, 'Mathematics 1', 'MATH111', 'Mathematics 1',1,2,NOW(),3);
+INSERT INTO lams_organisation (organisation_id, name, code, description, parent_organisation_id, organisation_type_id, create_date, workspace_id)
+	VALUES (5, 'Tutorial Group A', 'TUTA', 'Tutorial Group A',4,3,NOW(),null);
+INSERT INTO lams_organisation (organisation_id, name, code, description, parent_organisation_id, organisation_type_id, create_date, workspace_id)
+	VALUES (6, 'Tutorial Group B', 'TUTB', 'Tutorial Group B',4,3,NOW(),null);
 
 -- users
 INSERT INTO lams_user (user_id,login,password,title,first_name,last_name,address_line_1,address_line_2,address_line_3,