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/ttrss_schema_mysql.sql | 3 ++- 1 file changed, 2 insertions(+), 1 deletion(-) (limited to 'schema/ttrss_schema_mysql.sql') diff --git a/schema/ttrss_schema_mysql.sql b/schema/ttrss_schema_mysql.sql index 04fa7f0de..e2815bf8b 100644 --- a/schema/ttrss_schema_mysql.sql +++ b/schema/ttrss_schema_mysql.sql @@ -44,6 +44,7 @@ create table ttrss_users (id integer primary key not null auto_increment, full_name varchar(250) not null default '', email_digest bool not null default false, last_digest_sent datetime default null, + salt varchar(250) not null default '', created datetime default null, twitter_oauth longtext default null, index (theme_id)) ENGINE=InnoDB DEFAULT CHARSET=UTF8; @@ -259,7 +260,7 @@ create table ttrss_tags (id integer primary key auto_increment, create table ttrss_version (schema_version int not null) ENGINE=InnoDB DEFAULT CHARSET=UTF8; -insert into ttrss_version values (87); +insert into ttrss_version values (88); create table ttrss_enclosures (id integer primary key auto_increment, content_url text not null, -- cgit v1.2.3