Index: openacs-4/packages/dotlrn/sql/postgresql/dotlrn-users-create.sql
===================================================================
RCS file: /usr/local/cvsroot/openacs-4/packages/dotlrn/sql/postgresql/Attic/dotlrn-users-create.sql,v
diff -u -r1.3 -r1.4
--- openacs-4/packages/dotlrn/sql/postgresql/dotlrn-users-create.sql	6 Apr 2002 06:27:32 -0000	1.3
+++ openacs-4/packages/dotlrn/sql/postgresql/dotlrn-users-create.sql	2 Jul 2002 18:40:08 -0000	1.4
@@ -24,26 +24,18 @@
 create table dotlrn_user_profile_rels (
     rel_id                      integer
                                 constraint dotlrn_usr_prfl_rels_rel_id_fk
-                                references user_profile_rels (rel_id)
+                                references dotlrn_user_profile_rels (rel_id)
                                 constraint dotlrn_user_profile_rels_pk
                                 primary key,
-    id                          varchar(100)
-);
-
-create table dotlrn_full_user_profile_rels (
-    rel_id                      integer
-                                constraint dotlrn_fup_rels_rel_fk
-                                references dotlrn_user_profile_rels (rel_id)
-                                constraint dotlrn_full_user_prfl_rels_pk
-                                primary key,
     portal_id                   integer
-                                constraint dotlrn_fup_rels_portal_fk
+				constraint dotlrn_user_p_rels_portal_fk
                                 references portals (portal_id)
-                                constraint dotlrn_fup_rels_portal_nn
+                                constraint dotlrn_user_p_rels_portal_nn
                                 not null,
     theme_id                    integer
-                                constraint dotlrn_fup_rels_theme_fk
-                                references portal_element_themes (theme_id)
+				constraint dotlrn_user_p_rels_theme_id_fk
+                                references portal_element_themes (theme_id),
+    id                          varchar(100)
 );
 
 create table dotlrn_user_types (
@@ -58,7 +50,7 @@
                                 not null
 );
 
-create or replace view dotlrn_users
+create view dotlrn_users
 as
     select acs_rels.rel_id,
            dotlrn_user_profile_rels.id,
@@ -81,15 +73,6 @@
     and parties.party_id = users.user_id
     and users.user_id = persons.person_id;
 
-create view dotlrn_full_users
-as
-    select dotlrn_users.*,
-           dotlrn_full_user_profile_rels.portal_id,
-           dotlrn_full_user_profile_rels.theme_id
-    from dotlrn_users,
-         dotlrn_full_user_profile_rels
-    where dotlrn_users.rel_id = dotlrn_full_user_profile_rels.rel_id;
-
 \i dotlrn-user-profile-provider-create.sql
 \i dotlrn-users-init.sql
 \i dotlrn-users-package-create.sql
