--- /dev/null
+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),
+ awaynickenabled boolean NOT NULL DEFAULT FALSE,
+ awayreason varchar(256),
+ awayreasonenabled boolean NOT NULL DEFAULT FALSE,
+ autoawayenabled boolean NOT NULL DEFAULT FALSE,
+ autoawaytime integer NOT NULL,
+ autoawayreason varchar(256),
+ autoawayreasonenabled boolean NOT NULL DEFAULT FALSE,
+ detachawayenabled boolean NOT NULL DEFAULT FALSE,
+ detachawayreason varchar(256),
+ detachawayreasonenabled boolean NOT NULL DEFAULT FALSE,
+ ident varchar(64),
+ kickreason varchar(256),
+ partreason varchar(256),
+ quitreason varchar(256),
+ sslcert bytea,
+ sslkey bytea,
+ UNIQUE (userid, identityname)
+)