ezmlm-mktab also can also print the SQL drop commands to remove the same tables.

-C

Do not print the table definitions for list creation. By default, table definitions are printed.

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

This connects to the mysql server on ``host'' as ``user'' (prompting for the password) and in database ``db'' creates tables list, list_slog, list_mlog, the corresponding table sets for address lists list_allow, list_deny, list_digest, list_mod, as well as list_name, list_digest_name, list_cookie, and list_digest_cookie.

Since the -d switch is used, any of these tables already existing are first dropped, with loss of any data already in them.