Quote from: BobRay at Dec 11, 2008, 11:30 PM
Still wonding about this -- especially XPDO_TRANSPORT_PRESERVE_KEYS. I notice that XPDO_TRANSPORT_PRESERVE_KEYS is set to false in the Captcha package and UNIQUE_KEY is set to ’key’. I’m not sure if I did that or if splittingred did when he edited it.
I did that, for the System Settings you are adding in - because the unique identifier for the system settings table isn’t ’name’, it’s ’key’ (there is no name field).
Also, PRESERVE_KEYS is false in the actual plugin, because you don’t want to preserve the PK there...the PK is ’id’, and is an auto-increment SQL field. PRESERVE_KEYS should always be false when dealing with objects that use auto-increment fields. It’s true on the System Settings because we want those PKs (key) to stay the same as in the build.
Looking in SVN, I see that many components use the defaults, so XPDO_TRANSPORT_PRESERVE_KEYS is set to true, but a number of them have PRESERVE_KEYS set to false (e.g. ditto, weblogin). I have no idea why.
Most all the snippets use PRESERVE_KEYS set to false on their snippet or plugin objects; if they don’t, they’re wrong.