summaryrefslogtreecommitdiff
path: root/extras/m_sqloper.postgresql.sql
diff options
context:
space:
mode:
Diffstat (limited to 'extras/m_sqloper.postgresql.sql')
-rw-r--r--extras/m_sqloper.postgresql.sql8
1 files changed, 2 insertions, 6 deletions
diff --git a/extras/m_sqloper.postgresql.sql b/extras/m_sqloper.postgresql.sql
index fd640949f..4244abc22 100644
--- a/extras/m_sqloper.postgresql.sql
+++ b/extras/m_sqloper.postgresql.sql
@@ -1,14 +1,10 @@
---
--- PostgreSQL database dump
---
-
CREATE TABLE ircd_opers (
id serial NOT NULL,
username text,
"password" text,
hostname text,
- "type" text
+ "type" text,
+ active boolean NOT NULL DEFAULT 1
);
ALTER TABLE ONLY ircd_opers
ADD CONSTRAINT ircd_opers_pkey PRIMARY KEY (id);
-