From e90053fe8400893190f6b91bb4b78abe481f2e7f Mon Sep 17 00:00:00 2001 From: Andrew Dolgov Date: Sun, 22 Jan 2012 11:48:08 +0400 Subject: improve password storage (use sha256 and long random salt) bump schema --- schema/versions/pgsql/88.sql | 10 ++++++++++ 1 file changed, 10 insertions(+) create mode 100644 schema/versions/pgsql/88.sql (limited to 'schema/versions/pgsql') diff --git a/schema/versions/pgsql/88.sql b/schema/versions/pgsql/88.sql new file mode 100644 index 000000000..df6ec8fb7 --- /dev/null +++ b/schema/versions/pgsql/88.sql @@ -0,0 +1,10 @@ +begin; + +alter table ttrss_users add column salt varchar(250); +update ttrss_users set salt = ''; +alter table ttrss_users alter column salt set not null; +alter table ttrss_users alter column salt set default ''; + +update ttrss_version set schema_version = 88; + +commit; -- cgit v1.2.3