ffeingol Posted March 10, 2008 Share Posted March 10, 2008 Hello everyone, I'm looking to create some custom reports within WHMCS. Is there an E/R diagram / picture of the database available so I can see the relationships between the tables easier? TIA, Frank 0 Quote Link to comment Share on other sites More sharing options...
robb3369 Posted March 10, 2008 Share Posted March 10, 2008 Not too sure about openly posting it here, but you can grab a copy of SchemaSpy: http://schemaspy.sourceforge.net/ and easily run against your DB... 0 Quote Link to comment Share on other sites More sharing options...
aslam Posted October 1, 2009 Share Posted October 1, 2009 Is there any progress with getting an ER diagram for the WHMCS DB? I tried running the schemaSpy tool noted, but it refused to launch on my OS X machine. However I was able to get MySQL Workbench 5.1 to run. It successfully connected to my WHMCS 4.0.2 DB and, using the reverse engineer function, it created an ER Diagram with all of the WHMCS tables on it, however none of the relationships between tables were represented. Anyone else have any ideas? We want to do some custom reporting and we need a sense of the DB schema and relationships to do this. Thanks, Aslam 0 Quote Link to comment Share on other sites More sharing options...
thehost5968 Posted October 1, 2009 Share Posted October 1, 2009 Not too sure about openly posting it here, but you can grab a copy of SchemaSpy: http://schemaspy.sourceforge.net/ and easily run against your DB... Hi I now this may be silly but does this run on my pc or should I run it on the server? 0 Quote Link to comment Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.