I am working with the SOAP-API and added some functionality around customers, server-ips and vhosts. The examples and the code in remoting.inc.php are very helpful. Thanks for that. The database ist rather complex. Is there some detailed documentation about tables, foreign keys, database Structure, ... You see, I ask for a sort of ER-Diagram (Entity Relationship). Thanks!
I'am sorry, we dont have a ER diagram. I explained some relations here in the dev forum some time ago, maybe you can dig them up
Today I did a little reverse engineering and created a first draft ERD for the database of ISPConfig 3.0.5.4p5. Since it seems there are no relations in "dbispconfig" defined, I tried to put it together via common sense and looking at the data. However it comes without any guarantee of completion nor correctness. At least one thing regarding table "mail_backup" - I could not figured out if the data is related towards mail_domain or domain table. The file "ISPConfig-3_0_5_4p5_ERD.pdf.zip" contains one big sheet with all tables. In the other file "ISPConfig-3_0_5_4p5_ERD-single.zip" I selected some sections and showed them in detail but left out the commonly used tables sys_user, sys_group and server I used the free tool MySQL Workbench and would love to upload the model, but unfortunately the forum does only allow me to upload ca. 150k of zip, but the model-zip is about 180k. There is much room for improvement - comments are welcome...
