User Commands ezmlm-mktab(1) NNNNAAAAMMMMEEEE ezmlm-mktab - create SQL table definition for ezmlm list SSSSYYYYNNNNOOOOPPPPSSSSIIIISSSS eeeezzzzmmmmllllmmmm----mmmmkkkkttttaaaabbbb [ -ddddCCCC ] _t_a_b_l_e__r_o_o_t DDDDEEEESSSSCCCCRRRRIIIIPPPPTTTTIIIIOOOONNNN eeeezzzzmmmmllllmmmm----mmmmkkkkttttaaaabbbb takes _t_a_b_l_e__r_o_o_t and prints table definitions for _t_a_b_l_e__r_o_o_t, _t_a_b_l_e__r_o_o_t____sssslllloooogggg, etc. All subscriber and log tables are defined, although normally only a subset are used. eeeezzzzmmmmllllmmmm----mmmmkkkkttttaaaabbbb also can also print the SQL drop commands to remove the same tables. OOOOPPPPTTTTIIIIOOOONNNNSSSS -CCCC Do not print the table definitions for list creation. By default, table definitions are printed. -dddd Print table drop commands. Normally, they are omitted. When printed, they are printed before the table defini- tions, so that existing tables are removed, then recreated. UUUUSSSSAAAAGGGGEEEE eeeezzzzmmmmllllmmmm----mmmmkkkkttttaaaabbbb -dddd _l_i_s_t | mysql -hhost -uuser This connects to the mysql server on ``host'' as ``user'' (prompting for the password) and in database ``db'' creates tables _l_i_s_t, _l_i_s_t____sssslllloooogggg, _l_i_s_t____mmmmlllloooogggg, the corresponding table sets for address lists _l_i_s_t____aaaalllllllloooowwww, _l_i_s_t____ddddeeeennnnyyyy, _l_i_s_t____ddddiiiiggggeeeesssstttt,,,, _l_i_s_t____mmmmoooodddd,,,, as well as _l_i_s_t____nnnnaaaammmmeeee, _l_i_s_t____ddddiiiiggggeeeesssstttt____nnnnaaaammmmeeee, _l_i_s_t____ccccooooooookkkkiiiieeee, and _l_i_s_t____ddddiiiiggggeeeesssstttt____ccccooooooookkkkiiiieeee. Since the -dddd switch is used, any of these tables already existing are first dropped, with loss of any data already in them. SSSSEEEEEEEE AAAALLLLSSSSOOOO ezmlm-send(1), ezmlm(5), mysql(1) SunOS 5.11 Last change: 1