X-Git-Url: https://git.quassel-irc.org/?a=blobdiff_plain;f=src%2Fcore%2FSQL%2FPostgreSQL%2Fsetup_020_identity.sql;fp=src%2Fcore%2FSQL%2FPostgreSQL%2Fsetup_020_identity.sql;h=d60eb1aefe9a6edfef99aa4d30a7a4cbfe9458da;hb=9fa6f42009ada45e4787972b5e137ba19876c8dd;hp=35ffe725ba06baec74566f9daa2995be79f84646;hpb=f09a86ab1cc01a80aa6fd52a875920e18d1d3a5b;p=quassel.git diff --git a/src/core/SQL/PostgreSQL/setup_020_identity.sql b/src/core/SQL/PostgreSQL/setup_020_identity.sql index 35ffe725..d60eb1ae 100644 --- a/src/core/SQL/PostgreSQL/setup_020_identity.sql +++ b/src/core/SQL/PostgreSQL/setup_020_identity.sql @@ -1,23 +1,23 @@ CREATE TABLE identity ( identityid serial PRIMARY KEY, userid integer NOT NULL REFERENCES quasseluser (userid) ON DELETE CASCADE, - identityname varchar(64) NOT NULL, - realname varchar(128) NOT NULL, - awaynick varchar(64), + identityname TEXT NOT NULL, + realname TEXT NOT NULL, + awaynick TEXT, awaynickenabled boolean NOT NULL DEFAULT FALSE, - awayreason varchar(256), + awayreason TEXT, awayreasonenabled boolean NOT NULL DEFAULT FALSE, autoawayenabled boolean NOT NULL DEFAULT FALSE, autoawaytime integer NOT NULL, - autoawayreason varchar(256), + autoawayreason TEXT, autoawayreasonenabled boolean NOT NULL DEFAULT FALSE, detachawayenabled boolean NOT NULL DEFAULT FALSE, - detachawayreason varchar(256), + detachawayreason TEXT, detachawayreasonenabled boolean NOT NULL DEFAULT FALSE, - ident varchar(64), - kickreason varchar(256), - partreason varchar(256), - quitreason varchar(256), + ident TEXT, + kickreason TEXT, + partreason TEXT, + quitreason TEXT, sslcert bytea, sslkey bytea, UNIQUE (userid, identityname)