Index: openacs-4/packages/acs-kernel/sql/oracle/community-core-create.sql
===================================================================
RCS file: /usr/local/cvsroot/openacs-4/packages/acs-kernel/sql/oracle/community-core-create.sql,v
diff -u -r1.5 -r1.6
--- openacs-4/packages/acs-kernel/sql/oracle/community-core-create.sql	15 Aug 2003 14:35:50 -0000	1.5
+++ openacs-4/packages/acs-kernel/sql/oracle/community-core-create.sql	22 Aug 2003 11:38:08 -0000	1.6
@@ -512,9 +512,13 @@
 				constraint users_user_id_fk
 				references persons (person_id)
 				constraint users_pk primary key,
-	password		char(40),
-	salt			char(40),
-	screen_name		varchar2(100)
+        authority_id            integer
+                                constraint users_auth_authorities_fk
+                                references auth_authorities(authority_id),
+        username                varchar2(100) 
+                                constraint users_username_nn 
+                                not null,
+    	screen_name		varchar2(100)
 				constraint users_screen_name_un
 				unique,
 	priv_name		integer default 0 not null,
@@ -529,8 +533,14 @@
 	last_visit		date,
 	second_to_last_visit	date,
 	n_sessions		integer default 1 not null,
+        -- local authentication information
+	password		char(40),
+	salt			char(40),
 	password_question	varchar2(1000),
-	password_answer		varchar2(1000)
+	password_answer		varchar2(1000),
+        -- table constraints
+        constraint users_authority_username_un
+        unique (authority_id, username)
 );
 
 create index users_email_verified_idx on users (email_verified_p);