Commit | Line | Data |
---|---|---|
f8beb284 MW |
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) |