summaryrefslogtreecommitdiff
path: root/extras
diff options
context:
space:
mode:
authorPeter Powell <petpow@saberuk.com>2018-09-26 21:56:51 +0100
committerPeter Powell <petpow@saberuk.com>2018-09-26 23:36:19 +0100
commit2af0476c5a35bfca06820f923debedf4fbc93cb8 (patch)
tree8ef6c20ffb3e70b8d3052adf20b0771557163148 /extras
parent1e33c494bb087ca79197bef17f138104c66036c7 (diff)
Move the SQL tables to docs/sql and install them on `make install`.
Diffstat (limited to 'extras')
-rw-r--r--extras/m_sqloper.mysql.sql12
-rw-r--r--extras/m_sqloper.postgresql.sql13
-rw-r--r--extras/m_sqloper.sqlite3.sql10
3 files changed, 0 insertions, 35 deletions
diff --git a/extras/m_sqloper.mysql.sql b/extras/m_sqloper.mysql.sql
deleted file mode 100644
index a8a2b7e1d..000000000
--- a/extras/m_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=MyISAM;
diff --git a/extras/m_sqloper.postgresql.sql b/extras/m_sqloper.postgresql.sql
deleted file mode 100644
index 0b3cdb8dc..000000000
--- a/extras/m_sqloper.postgresql.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" boolean NOT NULL DEFAULT 0,
- "active" boolean NOT NULL DEFAULT 1
-);
-ALTER TABLE ONLY ircd_opers
- ADD CONSTRAINT ircd_opers_pkey PRIMARY KEY (id);
diff --git a/extras/m_sqloper.sqlite3.sql b/extras/m_sqloper.sqlite3.sql
deleted file mode 100644
index 6aec5a118..000000000
--- a/extras/m_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);