summaryrefslogtreecommitdiff
diff options
context:
space:
mode:
authorDaniel Vassdal <shutter@canternet.org>2015-02-21 12:39:31 +0100
committerDaniel Vassdal <shutter@canternet.org>2015-02-22 14:37:40 +0100
commit0b1315b1da2d5274b6a9f61eaa30bc731e066639 (patch)
tree3896df9520d9a949f25b53a7ed7188748a093152
parentafaf9495c1f2d5f1ba7b01c3b8a437083d91abb2 (diff)
m_sqloper.postgresql.sql: Add `active` column
-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);
-