Separate persistency for marker line (backend only)

[quassel.git] / src / core / SQL / PostgreSQL / 14 / setup_020_identity.sql

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 (file)
index 35ffe72..0000000
--- 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)
-)