[Rt-devel] constraints.mysql ... in use by anyone?

[Otto Hirr]

Is there a reason that the schema creation scripts
do not spec constraints?

Most of the db's seem to have the foreign key constraint
ability, and those that do not, eg sqlite, take it as a no-op,
at least in my understanding.

Would it not be better to move forward with having constraints
defined and be able to drop them for those who don't/can't have them?

There is a file, constraints.mysql, however it is not valid,
ie there are columns that are not defined in all the schemas,
eg EffectiveTicket is defined in schema.Sybase and is used
in constraints.mysql, but is not defined in any of the other
schemas.

If schema.Sybase is old, then it should be dropped or updated.
Is there someone that can "push a button" and generate a
new constraints file?

Regards,

..Otto