Index: lams_common/db/model/lams_tables.clay
===================================================================
RCS file: /usr/local/cvsroot/lams_common/db/model/Attic/lams_tables.clay,v
diff -u
--- /dev/null 1 Jan 1970 00:00:00 -0000
+++ lams_common/db/model/lams_tables.clay 11 Nov 2004 03:03:32 -0000 1.1
@@ -0,0 +1,4668 @@
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
Index: lams_common/db/model/user_management.clay
===================================================================
RCS file: /usr/local/cvsroot/lams_common/db/model/Attic/user_management.clay,v
diff -u
--- /dev/null 1 Jan 1970 00:00:00 -0000
+++ lams_common/db/model/user_management.clay 11 Nov 2004 03:03:32 -0000 1.1
@@ -0,0 +1,822 @@
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+a user in lams
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+Organisation in LAMS: essentially a grouping of users. This might map to organisational structure, course structure or class structure
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+joins a user to an org with a role
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+Table enumerates the types for organizations:
+current available types:
+root (the root org used by the system administrator)
+base (the base org of a particular LAMS client org: e.g. a university or school).
+sub (child org of a the base org)
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+represents a method of authorization in LAMS
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+enumerates the types of authorization method LAMS supports:
+Current values:
+LAMS (lams DB: compare user/password against user table).
+WEB_AUTH (user is authroized via WebAuth).
+
+Future:
+LDAP (compare user/pawword against an LDAP instance)
+COOKIE (user authorized by a cookie)
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+parameters for an authorization method
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
Index: lams_common/db/sql/add_workspace_tables.sql
===================================================================
RCS file: /usr/local/cvsroot/lams_common/db/sql/Attic/add_workspace_tables.sql,v
diff -u
--- /dev/null 1 Jan 1970 00:00:00 -0000
+++ lams_common/db/sql/add_workspace_tables.sql 11 Nov 2004 03:03:32 -0000 1.1
@@ -0,0 +1,31 @@
+# Connection: ROOT LOCAL
+# Host: localhost
+# Saved: 2004-11-09 16:13:07
+#
+CREATE TABLE lams_workspace_folder (
+ workspace_folder_id INT(11) NOT NULL
+ , parent_folder_id INT(11)
+ , name VARCHAR(64) NOT NULL
+ , workspace_id INT(11) NOT NULL
+ , PRIMARY KEY (workspace_folder_id)
+ , INDEX (parent_folder_id)
+ , CONSTRAINT FK_lams_workspace_folder_2 FOREIGN KEY (parent_folder_id)
+ REFERENCES lams_workspace_folder (workspace_folder_id)
+)TYPE=InnoDB;
+
+CREATE TABLE lams_workspace (
+ workspace_id INT(11) NOT NULL
+ , root_folder_id INT(11) NOT NULL
+ , PRIMARY KEY (workspace_id)
+ , INDEX (root_folder_id)
+ , CONSTRAINT FK_lams_workspace_1 FOREIGN KEY (root_folder_id)
+ REFERENCES lams_workspace_folder (workspace_folder_id)
+)TYPE=InnoDB;
+
+ALTER TABLE lams_user ADD workspace_id INT(11);
+ALTER TABLE lams_user ADD INDEX idx_lams_user_workspace_id (workspace_id);
+ALTER TABLE lams_user ADD FOREIGN KEY (workspace_id) REFERENCES lams_workspace (workspace_id);
+
+ALTER TABLE lams_organisation ADD workspace_id INT(11);
+ALTER TABLE lams_organisation ADD INDEX idx_lams_organisation_workspace_id (workspace_id);
+ALTER TABLE lams_organisation ADD FOREIGN KEY (workspace_id) REFERENCES lams_workspace (workspace_id);
\ No newline at end of file
Index: lams_common/db/sql/create_user_management_tables.sql
===================================================================
RCS file: /usr/local/cvsroot/lams_common/db/sql/Attic/create_user_management_tables.sql,v
diff -u
--- /dev/null 1 Jan 1970 00:00:00 -0000
+++ lams_common/db/sql/create_user_management_tables.sql 11 Nov 2004 03:03:32 -0000 1.1
@@ -0,0 +1,136 @@
+CREATE TABLE lams_organisation_type (
+ organisation_type_id INT(3) NOT NULL
+ , description VARCHAR(64) NOT NULL
+ , PRIMARY KEY (organisation_type_id)
+)TYPE=InnoDB;
+
+CREATE TABLE lams_authentication_method_type (
+ authentication_method_type_id INT(3) NOT NULL
+ , description VARCHAR(64) NOT NULL
+ , PRIMARY KEY (authentication_method_type_id)
+)TYPE=InnoDB;
+
+CREATE TABLE lams_role (
+ role_id INT(6) NOT NULL DEFAULT 0
+ , name VARCHAR(64) NOT NULL
+ , description TEXT
+ , create_date BIGINT(20)
+ , PRIMARY KEY (role_id)
+)TYPE=InnoDB;
+CREATE INDEX gname ON lams_role (name ASC);
+
+CREATE TABLE lams_authentication_method (
+ authentication_method_id INT(11) NOT NULL
+ , authentication_method_type_id INT(3) NOT NULL
+ , PRIMARY KEY (authentication_method_id)
+ , INDEX (authentication_method_type_id)
+ , CONSTRAINT FK_lams_authorization_method_1 FOREIGN KEY (authentication_method_type_id)
+ REFERENCES lams_authentication_method_type (authentication_method_type_id)
+)TYPE=InnoDB;
+
+CREATE TABLE lams_workspace_folder (
+ workspace_folder_id INT(11) NOT NULL
+ , parent_folder_id INT(11)
+ , name VARCHAR(64) NOT NULL
+ , workspace_id INT(11) NOT NULL
+ , PRIMARY KEY (workspace_folder_id)
+ , INDEX (parent_folder_id)
+ , CONSTRAINT FK_lams_workspace_folder_2 FOREIGN KEY (parent_folder_id)
+ REFERENCES lams_workspace_folder (workspace_folder_id)
+)TYPE=InnoDB;
+
+CREATE TABLE lams_workspace (
+ workspace_id INT(11) NOT NULL
+ , root_folder_id INT(11) NOT NULL
+ , PRIMARY KEY (workspace_id)
+ , INDEX (root_folder_id)
+ , CONSTRAINT FK_lams_workspace_1 FOREIGN KEY (root_folder_id)
+ REFERENCES lams_workspace_folder (workspace_folder_id)
+)TYPE=InnoDB;
+
+CREATE TABLE lams_user (
+ user_id INT(11) NOT NULL DEFAULT 0
+ , login VARCHAR(20) NOT NULL
+ , password VARCHAR(50) NOT NULL
+ , title VARCHAR(32)
+ , first_name VARCHAR(64)
+ , last_name VARCHAR(128)
+ , address_line_1 VARCHAR(64)
+ , address_line_2 VARCHAR(64)
+ , address_line_3 VARCHAR(64)
+ , city VARCHAR(64)
+ , state VARCHAR(64)
+ , country VARCHAR(64)
+ , day_phone VARCHAR(64)
+ , evening_phone VARCHAR(64)
+ , mobile_phone VARCHAR(64)
+ , fax VARCHAR(64)
+ , email VARCHAR(128)
+ , disabled_flag BOOL NOT NULL DEFAULT 0
+ , create_date DATETIME NOT NULL
+ , authentication_method_id INT(11) NOT NULL
+ , workspace_id INT(11)
+ , PRIMARY KEY (user_id)
+ , INDEX (authentication_method_id)
+ , CONSTRAINT FK_lams_user_1 FOREIGN KEY (authentication_method_id)
+ REFERENCES lams_authentication_method (authentication_method_id)
+ , INDEX (workspace_id)
+ , CONSTRAINT FK_lams_user_2 FOREIGN KEY (workspace_id)
+ REFERENCES lams_workspace (workspace_id)
+)TYPE=InnoDB;
+CREATE INDEX login ON lams_user (login ASC);
+
+CREATE TABLE lams_organisation (
+ organisation_id INT(11) NOT NULL DEFAULT 0
+ , name VARCHAR(250)
+ , description VARCHAR(250)
+ , parent_organisation_id INT(11)
+ , organisation_type_id INT(3) NOT NULL
+ , create_date DATETIME NOT NULL
+ , workspace_id INT(11)
+ , PRIMARY KEY (organisation_id)
+ , INDEX (organisation_type_id)
+ , CONSTRAINT FK_lams_organisation_1 FOREIGN KEY (organisation_type_id)
+ REFERENCES lams_organisation_type (organisation_type_id)
+ , INDEX (workspace_id)
+ , CONSTRAINT FK_lams_organisation_2 FOREIGN KEY (workspace_id)
+ REFERENCES lams_workspace (workspace_id)
+)TYPE=InnoDB;
+
+CREATE TABLE lams_user_organisation (
+ user_organisation_id INT(11) NOT NULL
+ , organisation_id INT(11) NOT NULL
+ , user_id INT(11) NOT NULL
+ , PRIMARY KEY (user_organisation_id)
+ , INDEX (user_id)
+ , CONSTRAINT u_user_organisation_ibfk_1 FOREIGN KEY (user_id)
+ REFERENCES lams_user (user_id) ON DELETE NO ACTION ON UPDATE NO ACTION
+ , INDEX (organisation_id)
+ , CONSTRAINT u_user_organisation_ibfk_2 FOREIGN KEY (organisation_id)
+ REFERENCES lams_organisation (organisation_id) ON DELETE NO ACTION ON UPDATE NO ACTION
+)TYPE=InnoDB;
+
+CREATE TABLE lams_authentication_method_parameter (
+ authentication_parameter_id INT(11) NOT NULL
+ , authentication_method_id INT(11) NOT NULL
+ , name VARCHAR(128) NOT NULL
+ , value VARCHAR(255)
+ , PRIMARY KEY (authentication_parameter_id)
+ , INDEX (authentication_method_id)
+ , CONSTRAINT FK_lams_authorization_method_parameter_1 FOREIGN KEY (authentication_method_id)
+ REFERENCES lams_authentication_method (authentication_method_id)
+)TYPE=InnoDB;
+
+CREATE TABLE lams_user_organisation_role (
+ user_organisation_role_id INT(11) NOT NULL
+ , user_organisation_id INT(11) NOT NULL
+ , role_id INT(6) NOT NULL DEFAULT 0
+ , PRIMARY KEY (user_organisation_role_id)
+ , INDEX (role_id)
+ , CONSTRAINT FK_lams_user_organisation_role_2 FOREIGN KEY (role_id)
+ REFERENCES lams_role (role_id)
+ , INDEX (user_organisation_id)
+ , CONSTRAINT FK_lams_user_organisation_role_3 FOREIGN KEY (user_organisation_id)
+ REFERENCES lams_user_organisation (user_organisation_id)
+)TYPE=InnoDB;
+
Index: lams_common/db/sql/drop_user_management_tables.sql
===================================================================
RCS file: /usr/local/cvsroot/lams_common/db/sql/Attic/drop_user_management_tables.sql,v
diff -u
--- /dev/null 1 Jan 1970 00:00:00 -0000
+++ lams_common/db/sql/drop_user_management_tables.sql 11 Nov 2004 03:03:32 -0000 1.1
@@ -0,0 +1,31 @@
+DROP INDEX PRIMARY ON lams_role;
+DROP INDEX gname ON lams_role;
+DROP INDEX PRIMARY ON lams_user;
+DROP INDEX login ON lams_user;
+DROP INDEX PRIMARY ON lams_organisation;
+DROP INDEX idx_user_org_org_id ON lams_user_organisation;
+DROP INDEX user_id ON lams_user_organisation;
+
+DROP TABLE lams_user_organisation_role;
+DROP TABLE lams_authentication_method_parameter;
+DROP TABLE lams_user_organisation;
+DROP TABLE lams_organisation;
+DROP TABLE lams_user;
+DROP TABLE lams_workspace;
+DROP TABLE lams_workspace_folder;
+DROP TABLE lams_authentication_method;
+DROP TABLE lams_role;
+DROP TABLE lams_authentication_method_type;
+DROP TABLE lams_organisation_type;
+
+
+
+
+
+
+
+
+
+
+
+
Index: lams_common/db/sql/insert_user_management_data.sql
===================================================================
RCS file: /usr/local/cvsroot/lams_common/db/sql/Attic/insert_user_management_data.sql,v
diff -u
--- /dev/null 1 Jan 1970 00:00:00 -0000
+++ lams_common/db/sql/insert_user_management_data.sql 11 Nov 2004 03:01:56 -0000 1.1
@@ -0,0 +1,22 @@
+# Connection: ROOT LOCAL
+# Host: localhost
+# Saved: 2004-11-09 15:04:37
+#
+# Connection: ROOT LOCAL
+# Host: localhost
+# Saved: 2004-11-09 15:01:18
+#
+INSERT INTO lams_role VALUES (1, 'SYSADMIN', 'LAMS System Adminstrator', NOW());
+INSERT INTO lams_role VALUES (2, 'ADMIN', 'Organization Adminstrator', NOW());
+INSERT INTO lams_role VALUES (3, 'AUTHOR', 'Authors Learning Designs', NOW());
+INSERT INTO lams_role VALUES (4, 'STAFF', 'Member of Staff', NOW());
+INSERT INTO lams_role VALUES (5, 'LEARNER', 'Student', NOW());
+
+INSERT INTO lams_authentication_method_type VALUES(1, 'LAMS');
+INSERT INTO lams_authentication_method_type VALUES(2, 'WEB_AUTH');
+INSERT INTO lams_authentication_method_type VALUES(3, 'LDAP');
+
+INSERT INTO lams_organisation_type VALUES(1, 'ROOT ORGANISATION');
+INSERT INTO lams_organisation_type VALUES(2, 'BASE ORGANISATION');
+INSERT INTO lams_organisation_type VALUES(3, 'SUB-ORGANIZATION');
+
Index: lams_common/design/lams11.mdr
===================================================================
RCS file: /usr/local/cvsroot/lams_common/design/lams11.mdr,v
diff -u
--- /dev/null 1 Jan 1970 00:00:00 -0000
+++ lams_common/design/lams11.mdr 11 Nov 2004 03:03:32 -0000 1.1
@@ -0,0 +1,230 @@
+MagicDrawUML "7.5"
+(RTManager
+ (RTManagerOptions
+ CODE_GENERATION_REVERSE_OPTION 2
+ DELETED_ELEMENT_GENERATION_OPTION 0
+ USE_CLASSPATH_FOR_JAVA_REVERSE TRUE
+ LAUNCH_WIZARD TRUE
+ MERGE_AFTER_REVERSE FALSE
+ CREATE_ATTRIBUTES TRUE
+ DEFAULT_WORKING_DIRECTORY "/opt/MagicDraw_UML"
+ DEFAULT_LANGUAGE "Java"
+ (JavaLanguageOptions
+ mGenEmptyDoc FALSE
+ mBracketInNewLine TRUE
+ mAddSpaces TRUE
+ mUseJavaDoc FALSE
+ mDefaultHeader "@(#) $FILE_NAME"
+ COLLECT_IMPORTS_ON_DEMAND TRUE
+ mGenerateDocumentation TRUE
+ (DocumentationProperties
+ DefaultDocumentationProcessor "STANDARD_PROCESSOR"
+ mCommentStyle 0
+ (Processors
+ (JAVA_DOC_PROCESSOR
+ (mDocumentationTagManager
+ (CLASSIFIER
+ (DocumentationTagProperty
+ mName "DESCRIPTION"
+ mGenerate "true"
+ )
+ )
+ (OPERARTION
+ (DocumentationTagProperty
+ mName "DESCRIPTION"
+ mGenerate "true"
+ )
+ (DocumentationTagProperty
+ mName "@param"
+ mGenerate "true"
+ )
+ (DocumentationTagProperty
+ mName "@return"
+ mGenerate "true"
+ )
+ (DocumentationTagProperty
+ mName "@throws"
+ mGenerate "true"
+ )
+ )
+ (ATTRIBUTE
+ (DocumentationTagProperty
+ mName "DESCRIPTION"
+ mGenerate "true"
+ )
+ )
+ )
+ )
+ )
+ )
+ mUseClassPath TRUE
+ mClassPath "lib/xalan.jar:/usr/java/j2sdk1.4.2_05/jre/lib/rt.jar:/usr/java/j2sdk1.4.2_05/jre/lib/i18n.jar:/usr/java/j2sdk1.4.2_05/jre/lib/sunrsasign.jar:/usr/java/j2sdk1.4.2_05/jre/lib/jsse.jar:/usr/java/j2sdk1.4.2_05/jre/lib/jce.jar:/usr/java/j2sdk1.4.2_05/jre/lib/charsets.jar:/usr/java/j2sdk1.4.2_05/jre/classes"
+ mClassCountForImportOnDemand 10
+ )
+ (CppLanguageOptions
+ mGenEmptyDoc FALSE
+ mBracketInNewLine TRUE
+ mAddSpaces TRUE
+ mUseJavaDoc FALSE
+ mDefaultHeader "@(#) $FILE_NAME"
+ mGenerateDocumentation TRUE
+ (DocumentationProperties
+ DefaultDocumentationProcessor "STANDARD_PROCESSOR"
+ mCommentStyle 0
+ (Processors
+ )
+ )
+ mDocumentationOption FALSE
+ mGenerateMethodBodyInClass FALSE
+ mUseIncludePath FALSE
+ mUseMacros TRUE
+ mIncludePath ""
+ )
+ (DDLLanguageOptions
+ mGenerateDocumentation TRUE
+ mGenEmptyDoc FALSE
+ mBracketInNewLine TRUE
+ mAddSpaces TRUE
+ mUseJavaDoc FALSE
+ mDefaultHeader "@(#) $FILE_NAME"
+ mGenerateDocumentation TRUE
+ (DocumentationProperties
+ DefaultDocumentationProcessor "STANDARD_PROCESSOR"
+ mCommentStyle 0
+ (Processors
+ )
+ )
+ )
+ DEFAULT_WORKING_DIRECTORY "/opt/MagicDraw_UML"
+ TEMP_DIRECTORY "Active Directory"
+ (C#LanguageOptions
+ mGenEmptyDoc FALSE
+ mBracketInNewLine TRUE
+ mAddSpaces TRUE
+ mUseJavaDoc FALSE
+ mDefaultHeader "@(#) $FILE_NAME"
+ mGenerateDocumentation TRUE
+ CSH_CONCAT_NAMESPACE_NAMES TRUE
+ (DocumentationProperties
+ DefaultDocumentationProcessor "STANDARD_PROCESSOR"
+ mCommentStyle 0
+ (Processors
+ (CSH_XML_PROCESSOR
+ (mDocumentationTagManager
+ (CLASSIFIER
+ (DocumentationTagProperty
+ mName "summary"
+ mGenerate "true"
+ )
+ (DocumentationTagProperty
+ mName "remarks"
+ mGenerate "true"
+ )
+ (DocumentationTagProperty
+ mName "permission"
+ mGenerate "true"
+ )
+ (DocumentationTagProperty
+ mName "example"
+ mGenerate "true"
+ )
+ (DocumentationTagProperty
+ mName "seealso"
+ mGenerate "true"
+ )
+ (DocumentationTagProperty
+ mName "include"
+ mGenerate "true"
+ )
+ )
+ (OPERARTION
+ (DocumentationTagProperty
+ mName "summary"
+ mGenerate "true"
+ )
+ (DocumentationTagProperty
+ mName "value"
+ mGenerate "true"
+ )
+ (DocumentationTagProperty
+ mName "param"
+ mGenerate "true"
+ )
+ (DocumentationTagProperty
+ mName "returns"
+ mGenerate "true"
+ )
+ (DocumentationTagProperty
+ mName "exception"
+ mGenerate "true"
+ )
+ (DocumentationTagProperty
+ mName "permission"
+ mGenerate "true"
+ )
+ (DocumentationTagProperty
+ mName "example"
+ mGenerate "true"
+ )
+ (DocumentationTagProperty
+ mName "seealso"
+ mGenerate "true"
+ )
+ (DocumentationTagProperty
+ mName "include"
+ mGenerate "true"
+ )
+ )
+ (ATTRIBUTE
+ (DocumentationTagProperty
+ mName "summary"
+ mGenerate "true"
+ )
+ (DocumentationTagProperty
+ mName "permission"
+ mGenerate "true"
+ )
+ (DocumentationTagProperty
+ mName "example"
+ mGenerate "true"
+ )
+ (DocumentationTagProperty
+ mName "seealso"
+ mGenerate "true"
+ )
+ (DocumentationTagProperty
+ mName "include"
+ mGenerate "true"
+ )
+ )
+ )
+ )
+ )
+ )
+ CSH_COLLECT_USINGS TRUE
+ mDefines( list
+ )
+ )
+ mResultToDiagram 2
+ (CORBAIDLLanguageOptions
+ mGenEmptyDoc FALSE
+ mBracketInNewLine TRUE
+ mAddSpaces TRUE
+ mUseJavaDoc FALSE
+ mDefaultHeader "@(#) $FILE_NAME"
+ mGenerateDocumentation TRUE
+ (DocumentationProperties
+ DefaultDocumentationProcessor "STANDARD_PROCESSOR"
+ mCommentStyle 0
+ (Processors
+ )
+ )
+ mUseIncludePath TRUE
+ mGenerateImports FALSE
+ )
+ )
+ (RTProjectGroupObject
+ mID "_62f021a_1100063226645_358511_82"
+ mName "Code engineering sets"
+ )
+)
Index: lams_common/design/lams11.xml.zip
===================================================================
RCS file: /usr/local/cvsroot/lams_common/design/lams11.xml.zip,v
diff -u
Binary files differ