summaryrefslogtreecommitdiff
path: root/docs/sql/sqloper.pgsql.sql
diff options
context:
space:
mode:
Diffstat (limited to 'docs/sql/sqloper.pgsql.sql')
-rw-r--r--docs/sql/sqloper.pgsql.sql13
1 files changed, 13 insertions, 0 deletions
diff --git a/docs/sql/sqloper.pgsql.sql b/docs/sql/sqloper.pgsql.sql
new file mode 100644
index 000000000..0b3cdb8dc
--- /dev/null
+++ b/docs/sql/sqloper.pgsql.sql
@@ -0,0 +1,13 @@
+CREATE TABLE ircd_opers (
+ "id" serial NOT NULL,
+ "name" text NOT NULL,
+ "password" text NOT NULL,
+ "hash" text,
+ "host" text NOT NULL,
+ "type" text NOT NULL,
+ "fingerprint" text,
+ "autologin" boolean NOT NULL DEFAULT 0,
+ "active" boolean NOT NULL DEFAULT 1
+);
+ALTER TABLE ONLY ircd_opers
+ ADD CONSTRAINT ircd_opers_pkey PRIMARY KEY (id);