#28 ezmlm and mysql -- automatically create/delete tables

[Anonymous]

Hi,
- when I want to use ezmlm with mysql support,
qmailadmin does nor create necessary tables (for
example by ezmlm-mktab). I ahve to v¨crate tham by
hand.
- and the same problem is when I want to drop a mailing
list. I also have to drop the tables manualy.

Thank you for answer. Radim

uchacr@x-base.cz

[Tom Collins]

Logged In: YES
user_id=117662

Here are some thoughts on how to do the UI once we get around to adding
the code to actually create/delete the tables. We would most likely call
ezmlm-mktab to handle the creation, and I guess we would have to link to
MySQL to handle the deletion.

Anyway, my thoughts on the interface.

On the Add/Modify screen, have one checkbox labeled "create this table" in
the MySQL settings, and another labeled something like "don't complain if
this table doesn't exist". If the "create" box is checked, and the table
already exists, come back with an error. If the table doesn't exist, and the
"complain" box isn't checked, return an error.

When deleting the list, if it has a table associated with it, include a checkbox
labeled, "Remove table xyz, used to store subscribers for list pdq."

[Richard A. Secor]

Logged In: YES
user_id=557797
Originator: NO

Can't ezmlm-mktab be called the same way ezmlm-sub is called?
Or should this be a request for ezmlm to create the tables if they don't exist on the fly (much like vpopmail does now)?