Make more config stuff case insensitive.

[user/henk/code/inspircd.git] / extras / m_sqloper.postgresql.sql

diff --git a/extras/m_sqloper.postgresql.sql b/extras/m_sqloper.postgresql.sql
index 199a656f6c639ff5bb56d9bff6f74e4bb47411b1..0b3cdb8dc051a562dd7fc56885d9a0f27d07c908 100644 (file)
--- a/extras/m_sqloper.postgresql.sql
+++ b/extras/m_sqloper.postgresql.sql
@@ -1 +1,13 @@
---\r-- PostgreSQL database dump\r--\r\rCREATE TABLE ircd_opers (\r    id serial NOT NULL,\r    username text,\r    "password" text,\r    hostname text,\r    "type" text\r);\rALTER TABLE ONLY ircd_opers\r    ADD CONSTRAINT ircd_opers_pkey PRIMARY KEY (id);\r\r
\ No newline at end of file
+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);