Index: openacs-4/packages/acs-kernel/sql/postgresql/community-core-create.sql
===================================================================
RCS file: /usr/local/cvsroot/openacs-4/packages/acs-kernel/sql/postgresql/community-core-create.sql,v
diff -u -N -r1.29.6.3 -r1.29.6.4
--- openacs-4/packages/acs-kernel/sql/postgresql/community-core-create.sql	4 Apr 2019 11:01:53 -0000	1.29.6.3
+++ openacs-4/packages/acs-kernel/sql/postgresql/community-core-create.sql	29 Sep 2021 12:09:59 -0000	1.29.6.4
@@ -643,7 +643,9 @@
         second_to_last_visit    timestamptz,
         n_sessions              integer default 1 not null,
         -- local authentication information
-        password                char(40),
+        password                character varying(128),
+        password_hash_algorithm character varying(100)
+                                DEFAULT 'salted_sha1' NOT NULL,
         salt                    char(40),
         password_question       varchar(1000),
         password_answer         varchar(1000),
