extras/m_sqloper.postgresql.sql


1
2
3
4
5
6
7
8
9
10
11
12
13

CREATE TABLE ircd_opers (
    "id" serial NOT NULL,
    "name" text NOT NULL,
    "password" text NOT NULL,
    "hash" text,
    "host" text NOT NULL,
    "type" text NOT NULL,
    "fingerprint" text,
    "autologin" boolean NOT NULL DEFAULT 0,
    "active" boolean NOT NULL DEFAULT 1
);
ALTER TABLE ONLY ircd_opers
    ADD CONSTRAINT ircd_opers_pkey PRIMARY KEY (id);