| 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) |