Index: openacs-4/packages/forums/sql/postgresql/forums-reading-info-create.sql =================================================================== RCS file: /usr/local/cvsroot/openacs-4/packages/forums/sql/postgresql/forums-reading-info-create.sql,v diff -u -r1.1 -r1.2 --- openacs-4/packages/forums/sql/postgresql/forums-reading-info-create.sql 22 May 2007 09:43:45 -0000 1.1 +++ openacs-4/packages/forums/sql/postgresql/forums-reading-info-create.sql 4 Jun 2007 12:43:47 -0000 1.2 @@ -12,8 +12,9 @@ default current_timestamp constraint forum_read_datetime_nn not null, - primary key forums_reading_info_pk (root_message_id,user_id), + constraint forums_reading_info_pk primary key (root_message_id,user_id) ); + create index forums_reading_info_user_index on forums_reading_info (user_id); create index forums_reading_info_forum_message_index on forums_reading_info (root_message_id); @@ -29,7 +30,7 @@ threads_read integer default 0 not null, - primary key forums_reading_info_user_pk (forum_id,user_id), + constraint forums_reading_info_user_pk primary key (forum_id,user_id) ); @@ -222,4 +223,4 @@ (v_users.forum_id,v_users.user_id,v_users.threads_read); end loop; return 1; -end;' language 'plpgsql'; \ No newline at end of file +end;' language 'plpgsql';