summaryrefslogtreecommitdiff
path: root/docs/sql/sqloper.mysql.sql
diff options
context:
space:
mode:
Diffstat (limited to 'docs/sql/sqloper.mysql.sql')
-rw-r--r--docs/sql/sqloper.mysql.sql12
1 files changed, 12 insertions, 0 deletions
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;