Steve, SteveNelson (sent by Nabble.com) wrote: > i'm still very much a newbie to farcry, but after going through the database > i'm immediately noticing that almost all of the tables are missing primary > keys. While I still don't know much about farcry, i do know that's a bad > idea with a data design.
The FarCry installer makes no effort to generate PK's, indices or other relationships. It's up to the dev team deploying the app to optimise the database. We make some suggestions here: http://docs.farcrycms.org:8080/confluence/display/FCDEV30/Database+Indexing+Strategies+for+FarCry > I imagine the tough part of this is making the updater script work across > databases. Who do i talk to about the 3.02 update? I'll throw in some time > to add support for PKs for MS SQL server. It's been on the to-do list for some time -- ie. update the installer to improve database integrity, but until we tackle the central issue of a relatively nasty install/update mechanism its probably easier to document the need to do this better. That said, any help is much appreciated ;) -- geoff http://www.daemon.com.au/ --~--~---------~--~----~------------~-------~--~----~ You received this message because you are subscribed to the Google Groups "farcry-dev" group. To post to this group, send email to [email protected] To unsubscribe from this group, send email to [EMAIL PROTECTED] For more options, visit this group at http://groups.google.com/group/farcry-dev -~----------~----~----~----~------~----~------~--~---
