Rename all these so that the names reflect the database server theyre used with more accurately -- for example, the old mysql ones were just .schema.sql, and

the postgres ones were .pgschema.sql.
Theyre now .mysql.sql, .postgresql.sql and .sqlite3.sql


git-svn-id: http://svn.inspircd.org/repository/trunk/inspircd@6345 e03df62e-2008-0410-955e-edbf42e46eb7

1 files changed, 14 insertions, 0 deletions

diff --git a/extras/m_sqloper.postgresql.sql b/extras/m_sqloper.postgresql.sql
new file mode 100644
index 000000000..fd640949f
--- /dev/null
+++ b/extras/m_sqloper.postgresql.sql
@@ -0,0 +1,14 @@
+--
+-- PostgreSQL database dump
+--
+
+CREATE TABLE ircd_opers (
+    id serial NOT NULL,
+    username text,
+    "password" text,
+    hostname text,
+    "type" text
+);
+ALTER TABLE ONLY ircd_opers
+    ADD CONSTRAINT ircd_opers_pkey PRIMARY KEY (id);
+