diff options
author | Peter Powell <petpow@saberuk.com> | 2018-09-26 21:56:51 +0100 |
---|---|---|
committer | Peter Powell <petpow@saberuk.com> | 2018-09-26 23:36:19 +0100 |
commit | 2af0476c5a35bfca06820f923debedf4fbc93cb8 (patch) | |
tree | 8ef6c20ffb3e70b8d3052adf20b0771557163148 /extras | |
parent | 1e33c494bb087ca79197bef17f138104c66036c7 (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.sql | 12 | ||||
-rw-r--r-- | extras/m_sqloper.postgresql.sql | 13 | ||||
-rw-r--r-- | extras/m_sqloper.sqlite3.sql | 10 |
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); |