From 2af0476c5a35bfca06820f923debedf4fbc93cb8 Mon Sep 17 00:00:00 2001 From: Peter Powell Date: Wed, 26 Sep 2018 21:56:51 +0100 Subject: Move the SQL tables to docs/sql and install them on `make install`. --- docs/sql/sqloper.mysql.sql | 12 ++++++++++++ docs/sql/sqloper.pgsql.sql | 13 +++++++++++++ docs/sql/sqloper.sqlite3.sql | 10 ++++++++++ 3 files changed, 35 insertions(+) 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/sqloper.mysql.sql b/docs/sql/sqloper.mysql.sql new file mode 100644 index 000000000..a8a2b7e1d --- /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=MyISAM; diff --git a/docs/sql/sqloper.pgsql.sql b/docs/sql/sqloper.pgsql.sql new file mode 100644 index 000000000..0b3cdb8dc --- /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" 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/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.2.3