Zen Cart and InnoDB

[starslab]

Hello,

I'm looking at adding a few tables to the Zen Cart database, and writing a little bit of my own code for manipulating them. I know that Zen Cart does all it's integrity checking at the PHP end of things, and therefore uses all MyISAM tables. My code will be totally separate, and just needs to reach in and make tiny tweaks to the zen cart records now and then.

I'd like to have the database do some referential enforcement for me with my new tables, so they're all InnoDB tables. One of these tables needs to have a relationship to the [prefix]products table. The relationship will be used to update or delete rows in one of my tables, not to block updates.

Obviously, you guys don't certify Zen Cart for use with InnoDB tables, and I'm not asking you to. What I am asking, is are you AWARE of any problems with Zen Cart and having the products table stored on InnoDB? Or are there reasons I haven't thought of that might make this a very Bad Idea(tm)? I've used an

"ALTER TABLE zen_products ENGINE = InnoDB;"

command on my test server, and the store still seems to be functioning okay.

I'd also like to add an extra field to the products table. Assuming I choose a name for this field that doesen't conflict with future changes to the table structure, I expect this won't cause problems? This field will only ever be touched by my own code.

[IGD]

I don't see any problem as long as you keep track of your changes if future upgrades are necessary to products table. I have often fed a few of my clients sites from distributer product databases that get published on a weekly basis. although none of them have been InnoDb. Ive done it with access, postgre, and mssql.