summaryrefslogtreecommitdiff
path: root/extras/m_sqloper.postgresql.sql
blob: 4244abc22ca668dc4cc54f82fcc6ff06a6e6ff0a (plain)
1
2
3
4
5
6
7
8
9
10
CREATE TABLE ircd_opers (
    id serial NOT NULL,
    username text,
    "password" text,
    hostname text,
    "type" text,
    active boolean NOT NULL DEFAULT 1
);
ALTER TABLE ONLY ircd_opers
    ADD CONSTRAINT ircd_opers_pkey PRIMARY KEY (id);