X-Git-Url: https://git.distorted.org.uk/~mdw/ezmlm/blobdiff_plain/5b62e993b0af39700031c2875d7f6654e6a02850..f8beb284087c279acfb30506f5bb32baa4949b44:/ezmlm-mktab.1

diff --git a/ezmlm-mktab.1 b/ezmlm-mktab.1
new file mode 100644
index 0000000..e593986
--- /dev/null
+++ b/ezmlm-mktab.1
@@ -0,0 +1,61 @@
+.TH ezmlm-mktab 1
+.SH NAME
+ezmlm-mktab \- create SQL table definition for ezmlm list
+.SH SYNOPSIS
+.B ezmlm-mktab
+[
+.B \-dC
+]
+.I table_root
+.SH DESCRIPTION
+.B ezmlm-mktab
+takes
+.I table_root
+and prints table definitions for
+.IR table_root ,
+.IR table_root\fB_slog ,
+etc. All subscriber
+and log tables are defined, although normally only a subset are used.
+
+.B ezmlm-mktab
+also can also print the SQL drop commands to remove the same tables.
+.SH OPTIONS
+.TP
+.B \-C
+Do not print the table definitions for list creation. By default, table
+definitions are printed.
+.TP
+.B \-d
+Print table drop commands. Normally, they are omitted. When printed, they
+are printed before the table definitions, so that existing tables are removed,
+then recreated.
+.SH USAGE
+.B ezmlm-mktab
+.B \-d
+.I list \fR | mysql -hhost -uuser -p -f db
+
+This connects to the mysql server on ``host'' as ``user'' (prompting for
+the password) and in database ``db'' creates tables
+.IR list ,
+.IR list\fB_slog ,
+.IR list\fB_mlog ,
+the corresponding table sets for address lists
+.IR list\fB_allow ,
+.IR list\fB_deny ,
+.IR list\fB_digest,
+.IR list\fB_mod,
+as well as
+.IR list\fB_name ,
+.IR list\fB_digest_name ,
+.IR list\fB_cookie ,
+and
+.IR list\fB_digest_cookie .
+
+Since the
+.B \-d
+switch is used, any of these tables already existing are first dropped,
+with loss of any data already in them.
+.SH "SEE ALSO"
+ezmlm-send(1),
+ezmlm(5),
+mysql(1)