From eca82d7b86b2968a411ff30b97b60ea55c72ca04 Mon Sep 17 00:00:00 2001 From: Michael Marley Date: Sun, 5 Apr 2015 21:35:09 -0400 Subject: [PATCH] Update the schema creation DDL for the new password hashing I'm not sure whether this slipped out in a merge or whether I forgot to add it in the first place, but it should have been part of commit 5924533c6d0f9777d38c01ed7e1510a55db2b876. This completely broke setting up a new Quassel instance from scratch with 0.12-rc1, but upgrades from previous versions are unaffected. --- src/core/SQL/PostgreSQL/17/setup_000_quasseluser.sql | 3 ++- src/core/SQL/SQLite/18/setup_000_quasseluser.sql | 5 ++--- 2 files changed, 4 insertions(+), 4 deletions(-) diff --git a/src/core/SQL/PostgreSQL/17/setup_000_quasseluser.sql b/src/core/SQL/PostgreSQL/17/setup_000_quasseluser.sql index cd8292c4..9c993769 100644 --- a/src/core/SQL/PostgreSQL/17/setup_000_quasseluser.sql +++ b/src/core/SQL/PostgreSQL/17/setup_000_quasseluser.sql @@ -1,5 +1,6 @@ CREATE TABLE quasseluser ( userid serial NOT NULL PRIMARY KEY, username varchar(64) UNIQUE NOT NULL, - password char(40) NOT NULL -- hex reppresentation of sha1 hashes + password TEXT NOT NULL, + hashversion integer NOT NULL DEFAULT 0 ) diff --git a/src/core/SQL/SQLite/18/setup_000_quasseluser.sql b/src/core/SQL/SQLite/18/setup_000_quasseluser.sql index 0b81759e..1833f966 100644 --- a/src/core/SQL/SQLite/18/setup_000_quasseluser.sql +++ b/src/core/SQL/SQLite/18/setup_000_quasseluser.sql @@ -1,7 +1,6 @@ CREATE TABLE quasseluser ( userid INTEGER NOT NULL PRIMARY KEY AUTOINCREMENT, username TEXT UNIQUE NOT NULL, - password TEXT NOT NULL + password TEXT NOT NULL, + hashversion INTEGER NOT NULL DEFAULT 0 ) - - -- 2.20.1