I’ve started to put together a diagram using the excellent MySQL Workbench (from Sun). The ERD does need splitting up into functional units, but here is what I have done so far:
The complete model: phplist-2109.mwb
The ERD as a PDF: model2.pdf
Hope this is of some help. I will post updates when I get around to them, depending on feedback.
Responses
Outstanding effort. I am kicking around some ideas centered on either:
SOAP service, or OO tools for PHP list. Do you know if there is a detailed commentary of the fields in the table anywhere? If not I would be willing to devote some time to starting one.
In any case, impressive, most impressive.
John – have a look here:
http://docs.phplist.com/PhplistHacks
There are a number of classes and APIs that people have written, all that interact directly with the database (which is an unfortunate result of the way in which phplist has developed over the years, but a necessary way of doing it).
You may be able to build SOAP or some other services on top of one of those classes or hacks.