From 98e2cf6b242461dfec6d5983a5a0b175e69401dc Mon Sep 17 00:00:00 2001
From: Sadie Powell
Date: Sun, 1 May 2022 22:21:53 +0100
Subject: Shuffle the sql schemas around a bit.

---
 docs/sql/log_sql/sqlite.sql  |  6 ------
 docs/sql/log_sql/sqlite3.sql |  6 ++++++
 docs/sql/sqloper.mysql.sql   | 12 ------------
 docs/sql/sqloper.pgsql.sql   | 13 -------------
 docs/sql/sqloper.sqlite3.sql | 10 ----------
 docs/sql/sqloper/mysql.sql   | 12 ++++++++++++
 docs/sql/sqloper/pgsql.sql   | 13 +++++++++++++
 docs/sql/sqloper/sqlite3.sql | 10 ++++++++++
 8 files changed, 41 insertions(+), 41 deletions(-)
 delete mode 100644 docs/sql/log_sql/sqlite.sql
 create mode 100644 docs/sql/log_sql/sqlite3.sql
 delete mode 100644 docs/sql/sqloper.mysql.sql
 delete mode 100644 docs/sql/sqloper.pgsql.sql
 delete mode 100644 docs/sql/sqloper.sqlite3.sql
 create mode 100644 docs/sql/sqloper/mysql.sql
 create mode 100644 docs/sql/sqloper/pgsql.sql
 create mode 100644 docs/sql/sqloper/sqlite3.sql

(limited to 'docs/sql')

diff --git a/docs/sql/log_sql/sqlite.sql b/docs/sql/log_sql/sqlite.sql
deleted file mode 100644
index 791712704..000000000
--- a/docs/sql/log_sql/sqlite.sql
+++ /dev/null
@@ -1,6 +0,0 @@
-CREATE TABLE "ircd_log" (
-  "time" datetime,
-  "type" varchar(50),
-  "message" text
-);
-
diff --git a/docs/sql/log_sql/sqlite3.sql b/docs/sql/log_sql/sqlite3.sql
new file mode 100644
index 000000000..791712704
--- /dev/null
+++ b/docs/sql/log_sql/sqlite3.sql
@@ -0,0 +1,6 @@
+CREATE TABLE "ircd_log" (
+  "time" datetime,
+  "type" varchar(50),
+  "message" text
+);
+
diff --git a/docs/sql/sqloper.mysql.sql b/docs/sql/sqloper.mysql.sql
deleted file mode 100644
index 83dfa68a6..000000000
--- a/docs/sql/sqloper.mysql.sql
+++ /dev/null
@@ -1,12 +0,0 @@
-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
deleted file mode 100644
index 954bc84fa..000000000
--- a/docs/sql/sqloper.pgsql.sql
+++ /dev/null
@@ -1,13 +0,0 @@
-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
deleted file mode 100644
index 6aec5a118..000000000
--- a/docs/sql/sqloper.sqlite3.sql
+++ /dev/null
@@ -1,10 +0,0 @@
-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);
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);
-- 
cgit v1.3.1-10-gc9f91