diff options
| author |  Daniel Vassdal | 2015-02-21 12:39:31 +0100 |
|---|---|---|
| committer | Daniel Vassdal | 2015-02-22 14:37:40 +0100 |
| commit | 0b1315b1da2d5274b6a9f61eaa30bc731e066639 (patch) | |
| tree | 3896df9520d9a949f25b53a7ed7188748a093152 /extras/m_sqloper.postgresql.sql | |
| parent | m_sqloper.mssql.sql: Add `active` column (diff) | |
m_sqloper.postgresql.sql: Add `active` column
Diffstat (limited to 'extras/m_sqloper.postgresql.sql')
| -rw-r--r-- | extras/m_sqloper.postgresql.sql | 8 |
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); - |