mirror of
https://github.com/inspircd/inspircd.git
synced 2025-03-09 10:39:02 -04:00
f166ef0a70
- Only create the pgsql table if it doesn't exist. - Separate the active column out from others.
39 lines
649 B
SQL
39 lines
649 B
SQL
CREATE TYPE "autologin" AS ENUM (
|
|
'strict',
|
|
'relaxed',
|
|
'never'
|
|
);
|
|
|
|
CREATE TABLE IF NOT EXISTS "ircd_opers" (
|
|
"active" bool NOT NULL DEFAULT true,
|
|
|
|
"name" text NOT NULL,
|
|
"password" text NOT NULL,
|
|
"host" text NOT NULL,
|
|
"type" text NOT NULL,
|
|
|
|
"autologin" autologin,
|
|
"class" text,
|
|
"hash" text,
|
|
"maxchans" bigint,
|
|
"nopassword" bool,
|
|
"vhost" text,
|
|
|
|
"commands" text,
|
|
"privs" text,
|
|
"chanmodes" text,
|
|
"usermodes" text,
|
|
"snomasks" text,
|
|
|
|
"account" text,
|
|
"autojoin" text,
|
|
"automotd" bool,
|
|
"fingerprint" text,
|
|
"level" bigint,
|
|
"modes" text,
|
|
"motd" bool,
|
|
"override" text,
|
|
"sslonly" bool,
|
|
"swhois" text
|
|
);
|