summaryrefslogtreecommitdiff
path: root/extras/m_sqloper.postgresql.sql
diff options
context:
space:
mode:
authorAttila Molnar <attilamolnar@hush.com>2015-02-22 17:12:06 +0100
committerAttila Molnar <attilamolnar@hush.com>2015-02-22 17:12:06 +0100
commit21e25f7aa9091821e24447784d08d8fdd905f1c3 (patch)
tree055430ead556f6ec6326543124df87ec79e91dba /extras/m_sqloper.postgresql.sql
parent2d97be1d32cb518b104583239c9483410b268fac (diff)
parent75e7eaceba5031927445d5fc9861c8c107fdaa8f (diff)
Merge pull request #1000 from ShutterQuick/master+281
m_sqloper: Add `active` column
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);
-