X-Git-Url: https://git.quassel-irc.org/?p=quassel.git;a=blobdiff_plain;f=src%2Fcore%2FSQL%2FPostgreSQL%2F17%2Fsetup_000_quasseluser.sql;h=9c99376936c4e10bb700009c4c29f9623c77de43;hp=cd8292c469c8f60f351023c7934dbb1509d729b4;hb=eca82d7b86b2968a411ff30b97b60ea55c72ca04;hpb=e71216ed2c31ea6fde6986b26faecd87a3723aa6 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 )