X-Git-Url: https://git.quassel-irc.org/?p=quassel.git;a=blobdiff_plain;f=src%2Fcore%2FSQL%2FPostgreSQL%2Fsetup_000_quasseluser.sql;h=0f4c782a4135e4a7b2f8037d280a81461f79b80c;hp=9c99376936c4e10bb700009c4c29f9623c77de43;hb=7fb88a023ef8e4658b39d22c2d88c0d8bd6709f8;hpb=3cf5c49e7753be48a994917fe898730add4292b1 diff --git a/src/core/SQL/PostgreSQL/setup_000_quasseluser.sql b/src/core/SQL/PostgreSQL/setup_000_quasseluser.sql index 9c993769..0f4c782a 100644 --- a/src/core/SQL/PostgreSQL/setup_000_quasseluser.sql +++ b/src/core/SQL/PostgreSQL/setup_000_quasseluser.sql @@ -2,5 +2,6 @@ CREATE TABLE quasseluser ( userid serial NOT NULL PRIMARY KEY, username varchar(64) UNIQUE NOT NULL, password TEXT NOT NULL, - hashversion integer NOT NULL DEFAULT 0 + hashversion integer NOT NULL DEFAULT 0, + authenticator varchar(64) UNIQUE NOT NULL )