mdw@git.distorted.org.uk Git - ezmlm/blob - ezmlm-mktab.1

   1 .TH ezmlm-mktab 1
   2 .SH NAME
   3 ezmlm-mktab \- create SQL table definition for ezmlm list
   4 .SH SYNOPSIS
   5 .B ezmlm-mktab
   6 [
   7 .B \-dC
   8 ]
   9 .I table_root
  10 .SH DESCRIPTION
  11 .B ezmlm-mktab
  12 takes
  13 .I table_root
  14 and prints table definitions for
  15 .IR table_root ,
  16 .IR table_root\fB_slog ,
  17 etc. All subscriber
  18 and log tables are defined, although normally only a subset are used.
  19
  20 .B ezmlm-mktab
  21 also can also print the SQL drop commands to remove the same tables.
  22 .SH OPTIONS
  23 .TP
  24 .B \-C
  25 Do not print the table definitions for list creation. By default, table
  26 definitions are printed.
  27 .TP
  28 .B \-d
  29 Print table drop commands. Normally, they are omitted. When printed, they
  30 are printed before the table definitions, so that existing tables are removed,
  31 then recreated.
  32 .SH USAGE
  33 .B ezmlm-mktab
  34 .B \-d
  35 .I list \fR | mysql -hhost -uuser -p -f db
  36
  37 This connects to the mysql server on ``host'' as ``user'' (prompting for
  38 the password) and in database ``db'' creates tables
  39 .IR list ,
  40 .IR list\fB_slog ,
  41 .IR list\fB_mlog ,
  42 the corresponding table sets for address lists
  43 .IR list\fB_allow ,
  44 .IR list\fB_deny ,
  45 .IR list\fB_digest,
  46 .IR list\fB_mod,
  47 as well as
  48 .IR list\fB_name ,
  49 .IR list\fB_digest_name ,
  50 .IR list\fB_cookie ,
  51 and
  52 .IR list\fB_digest_cookie .
  53
  54 Since the
  55 .B \-d
  56 switch is used, any of these tables already existing are first dropped,
  57 with loss of any data already in them.
  58 .SH "SEE ALSO"
  59 ezmlm-send(1),
  60 ezmlm(5),
  61 mysql(1)