Update the schema creation DDL for the new password hashing
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
)
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
)
-
-