plateaultd Posted June 26, 2009 Share Posted June 26, 2009 Is there a database schema for WHMCS available anywhere? I was hoping for something along the lines of: http://www.zen-cart.com/wiki/index.php/Developers_-_Database_Schema 0 Quote Link to comment Share on other sites More sharing options...
bear Posted June 26, 2009 Share Posted June 26, 2009 You can get the schema by exporting it from mysql, can't you? 0 Quote Link to comment Share on other sites More sharing options...
othellotech Posted June 27, 2009 Share Posted June 27, 2009 show tables; desc (tablename) ; 0 Quote Link to comment Share on other sites More sharing options...
plateaultd Posted July 1, 2009 Author Share Posted July 1, 2009 Actually the schemas in the above link show the relations ships between tables. Example: http://commons.wikimedia.org/wiki/File:ZenCart_DB_Schema.jpg which is what I am looking for. Some schemas will show if it is a 1:1 or 1:many relationship as well. I am going to make our site database driven with regards to pricing. Thus we only have to change it in WHMCS and have the change automatically reflected. Having a good overview of the structures also leads to "a-ha" moments where one sees other things that can be done. 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.