From 2af0476c5a35bfca06820f923debedf4fbc93cb8 Mon Sep 17 00:00:00 2001
From: Peter Powell
Date: Wed, 26 Sep 2018 21:56:51 +0100
Subject: Move the SQL tables to docs/sql and install them on `make install`.

---
 docs/sql/sqloper.pgsql.sql | 13 +++++++++++++
 1 file changed, 13 insertions(+)
 create mode 100644 docs/sql/sqloper.pgsql.sql

(limited to 'docs/sql/sqloper.pgsql.sql')

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);
-- 
cgit v1.3.1-10-gc9f91