Shuffle the sql schemas around a bit.

3 files changed, 35 insertions, 0 deletions

diff --git a/docs/sql/sqloper/mysql.sql b/docs/sql/sqloper/mysql.sql
new file mode 100644
index 000000000..83dfa68a6
--- /dev/null
+++ b/docs/sql/sqloper/mysql.sql
@@ -0,0 +1,12 @@
+CREATE TABLE ircd_opers (
+  id bigint(20) NOT NULL auto_increment,
+  name text NOT NULL,
+  password text NOT NULL,
+  hash text,
+  host text NOT NULL,
+  type text NOT NULL,
+  fingerprint text,
+  autologin tinyint(1) NOT NULL DEFAULT 0,
+  active tinyint(1) NOT NULL DEFAULT 1,
+  PRIMARY KEY  (id)
+) ENGINE=InnoDB;
diff --git a/docs/sql/sqloper/pgsql.sql b/docs/sql/sqloper/pgsql.sql
new file mode 100644
index 000000000..954bc84fa
--- /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" smallint NOT NULL DEFAULT 0,
+    "active" smallint NOT NULL DEFAULT 1
+);
+ALTER TABLE ONLY ircd_opers
+    ADD CONSTRAINT ircd_opers_pkey PRIMARY KEY (id);
diff --git a/docs/sql/sqloper/sqlite3.sql b/docs/sql/sqloper/sqlite3.sql
new file mode 100644
index 000000000..6aec5a118
--- /dev/null
+++ b/docs/sql/sqloper/sqlite3.sql
@@ -0,0 +1,10 @@
+CREATE TABLE ircd_opers (
+id integer primary key,
+name text NOT NULL,
+password text NOT NULL,
+hash text,
+host text NOT NULL,
+type text NOT NULL,
+fingerprint text,
+autologin integer NOT NULL DEFAULT 0,
+active integer NOT NULL DEFAULT 1);