aboutsummaryrefslogtreecommitdiff
path: root/docs/sql/sqloper/pgsql.sql
blob: a572fe4a8f5cee303edc37faaca10d41cc933e7f (about) (plain) (blame)
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
CREATE TYPE "autologin" AS ENUM (
  'strict',
  'relaxed',
  'never'
);

CREATE TABLE "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
);