X-Git-Url: https://git.quassel-irc.org/?a=blobdiff_plain;ds=sidebyside;f=src%2Fcore%2FSQL%2FPostgreSQL%2F14%2Fsetup_020_identity.sql;fp=src%2Fcore%2FSQL%2FPostgreSQL%2F14%2Fsetup_020_identity.sql;h=0000000000000000000000000000000000000000;hb=18cda6df43b5960686256fb6a899a63baebff70d;hp=35ffe725ba06baec74566f9daa2995be79f84646;hpb=91361e82b8cd46e7c4bfc4475e6ecb1d0b268310;p=quassel.git

diff --git a/src/core/SQL/PostgreSQL/14/setup_020_identity.sql b/src/core/SQL/PostgreSQL/14/setup_020_identity.sql
deleted file mode 100644
index 35ffe725..00000000
--- a/src/core/SQL/PostgreSQL/14/setup_020_identity.sql
+++ /dev/null
@@ -1,24 +0,0 @@
-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)
-)