1 CREATE TABLE identity (
2 identityid serial PRIMARY KEY,
3 userid integer NOT NULL REFERENCES quasseluser (userid) ON DELETE CASCADE,
4 identityname varchar(64) NOT NULL,
5 realname varchar(128) NOT NULL,
7 awaynickenabled boolean NOT NULL DEFAULT FALSE,
8 awayreason varchar(256),
9 awayreasonenabled boolean NOT NULL DEFAULT FALSE,
10 autoawayenabled boolean NOT NULL DEFAULT FALSE,
11 autoawaytime integer NOT NULL,
12 autoawayreason varchar(256),
13 autoawayreasonenabled boolean NOT NULL DEFAULT FALSE,
14 detachawayenabled boolean NOT NULL DEFAULT FALSE,
15 detachawayreason varchar(256),
16 detachawayreasonenabled boolean NOT NULL DEFAULT FALSE,
18 kickreason varchar(256),
19 partreason varchar(256),
20 quitreason varchar(256),
23 UNIQUE (userid, identityname)