Bukkit

What steps will reproduce the problem?
1.When using MySQL, if you make a request for items or items with enchantments you get a sql exception caused ty the foreign keys created by the plugin.  this happens when requesting items or items with enchantments.
2. Within mysql you can change the  on update and on delete columns to cascade and it fixes the problem for requesting standard items; however if you do the same steps of changing the on update and on delete settings for the foreign keys to cascade instead of restrict it resets these settings on the reload of the plugin.

Also, everytime you reload the plugin it creates another foreign key on the enchantment table within the database.
3.

What is the expected output? What do you see instead?

What version of the product are you using?
I am using the newest version of the plugin made for 1.5.2

Do you have an error log of what happened?
13:21:44 [WARNING] [JobSuite] An SQLException occurred: Cannot delete or update
a parent row: a foreign key constraint fails (`resin_jobsuitedata`.`jobsuite_en
hantments`, CONSTRAINT `jobsuite_enchantments_ibfk_4` FOREIGN KEY (`item_entry`
`enchantment_entry`) REFERENCES `jobsuite_items` (`item_entry`, `enchantment_)

Please provide any additional information below.