Sha256: e9ca7ce6c698c437ef79668b9cbe23ef9faf20b830070dca3ecba1a39b366bd2
Contents?: true
Size: 453 Bytes
Versions: 5
Compression:
Stored size: 453 Bytes
Contents
-- Add constraint to make sure o_user_id is set iff obsoleted_dt is
-- not infinity (i.e. object is obsoleted).
ALTER TABLE "%{table}" ADD CONSTRAINT check_o_user
CHECK ((obsoleted_dt = 'Infinity') = (o_user_id IS NULL));
-- obsoleted_dt > created_dt should be enforced -- however, there are
-- many instances of obsoleted_dt=created_dt in our existing apps.
ALTER TABLE "%{table}" ADD CONSTRAINT check_bad_obsolete
CHECK (obsoleted_dt >= created_dt);
Version data entries
5 entries across 5 versions & 1 rubygems