Commit these too.
-INSERT INTO quasseluser (userid, username, password, hashversion)
-VALUES (?, ?, ?, ?)
+INSERT INTO quasseluser (userid, username, password, hashversion, authenticator)
+VALUES (?, ?, ?, ?, ?)
-SELECT userid, password, hashversion
+SELECT userid, password, hashversion, authenticator
FROM quasseluser
WHERE username = :username
username varchar(64) UNIQUE NOT NULL,
password TEXT NOT NULL,
hashversion integer NOT NULL DEFAULT 0,
- authenticator varchar(64) UNIQUE NOT NULL
+ authenticator varchar(64) NOT NULL DEFAULT "Database"
)
-SELECT userid, username, password, hashversion
+SELECT userid, username, password, hashversion, authenticator
FROM quasseluser
-SELECT userid, password, hashversion
+SELECT userid, password, hashversion, authenticator
FROM quasseluser
WHERE username = :username
QString username;
QString password;
int hashversion;
+ QString authenticator;
};
struct SenderMO {
bindValue(1, user.username);
bindValue(2, user.password);
bindValue(3, user.hashversion);
+ bindValue(4, user.authenticator);
return exec();
}
user.username = value(1).toString();
user.password = value(2).toString();
user.hashversion = value(3).toInt();
+ user.authenticator = value(4).toString();
return true;
}