cascer1 / whmcs-enom-updater

Automatically update domain prices in WHMCS using current eNom prices for your account
MIT License
5 stars 1 forks source link

Improve database relations #20

Open cascer1 opened 7 years ago

cascer1 commented 7 years ago

The module's database tables should use the InnoDB storage engine with references to other tables.

More specifically, the tblcurrencies and tbldomainpricing tables should be referenced, so that all related entries are removed from the database when a domain or currency is removed from WHMCS.

Requires fixing of upgrade function (for version 2.1.0 alpha) and enomPricingUpdater_activate to use new table structure.

Related question on Stack Overflow

cascer1 commented 7 years ago

Related to #15