Sha256: 455b527766397fa4e1d4e144ce5370e77ffb9edd398c0d722d07e78fe0996e9e

Contents?: true

Size: 222 Bytes

Versions: 9

Compression:

Stored size: 222 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));

Version data entries

9 entries across 9 versions & 1 rubygems

Version Path
mcfly-0.0.18 lib/mcfly/constraint.sql
mcfly-0.0.17 lib/mcfly/constraint.sql
mcfly-0.0.16 lib/mcfly/constraint.sql
mcfly-0.0.15 lib/mcfly/constraint.sql
mcfly-0.0.14 lib/mcfly/constraint.sql
mcfly-0.0.13 lib/mcfly/constraint.sql
mcfly-0.0.12 lib/mcfly/constraint.sql
mcfly-0.0.11 lib/mcfly/constraint.sql
mcfly-0.0.10 lib/mcfly/constraint.sql