1
CREATE TABLE identity (
2
identityid INTEGER NOT NULL PRIMARY KEY AUTOINCREMENT,
3
userid INTEGER NOT NULL,
4
identityname TEXT NOT NULL,
5
realname TEXT NOT NULL,
7
awaynickenabled INTEGER NOT NULL DEFAULT 0, -- BOOL
9
awayreasonenabled INTEGER NOT NULL DEFAULT 0, -- BOOL
10
autoawayenabled INTEGER NOT NULL DEFAULT 0, -- BOOL
11
autoawaytime INTEGER NOT NULL,
13
autoawayreasonenabled INTEGER NOT NULL DEFAULT 0, -- BOOL
14
detachawayenabled INTEGER NOT NULL DEFAULT 0, -- BOOL
15
detachawayreason TEXT,
16
detachawayreasonenabled INTEGER NOT NULL DEFAULT 0, -- BOOL
23
UNIQUE (userid, identityname)