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/sqloper/mysql.sql | 12 ++++++++++++ 1 file changed, 12 insertions(+) create mode 100644 docs/sql/sqloper/mysql.sql (limited to 'docs/sql/sqloper/mysql.sql') 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; -- cgit v1.3.1-10-gc9f91