Sha256: f9c4112ad8b63c4f235301b39cf168bc389bcd8941fb7f9f6bdd926c960cd48b

Contents?: true

Size: 437 Bytes

Versions: 131

Compression:

Stored size: 437 Bytes

Contents

-- Create the trigger which will call out function every time a row in pathology_observations
-- is inserted or updated
DROP TRIGGER IF EXISTS update_research_study_participants_trigger ON renalware.research_study_participants;
CREATE TRIGGER update_research_study_participants_trigger
  BEFORE INSERT ON renalware.research_study_participants FOR EACH ROW
  EXECUTE PROCEDURE renalware.update_research_study_participants_from_trigger();

Version data entries

131 entries across 131 versions & 1 rubygems

Version Path
renalware-core-2.0.127 db/triggers/update_research_study_participants_trigger_v01.sql
renalware-core-2.0.126 db/triggers/update_research_study_participants_trigger_v01.sql
renalware-core-2.0.125 db/triggers/update_research_study_participants_trigger_v01.sql
renalware-core-2.0.124 db/triggers/update_research_study_participants_trigger_v01.sql
renalware-core-2.0.123 db/triggers/update_research_study_participants_trigger_v01.sql
renalware-core-2.0.121 db/triggers/update_research_study_participants_trigger_v01.sql
renalware-core-2.0.120 db/triggers/update_research_study_participants_trigger_v01.sql
renalware-core-2.0.119 db/triggers/update_research_study_participants_trigger_v01.sql
renalware-core-2.0.118 db/triggers/update_research_study_participants_trigger_v01.sql
renalware-core-2.0.117 db/triggers/update_research_study_participants_trigger_v01.sql
renalware-core-2.0.116 db/triggers/update_research_study_participants_trigger_v01.sql
renalware-core-2.0.115 db/triggers/update_research_study_participants_trigger_v01.sql
renalware-core-2.0.113 db/triggers/update_research_study_participants_trigger_v01.sql
renalware-core-2.0.112 db/triggers/update_research_study_participants_trigger_v01.sql
renalware-core-2.0.111 db/triggers/update_research_study_participants_trigger_v01.sql
renalware-core-2.0.110 db/triggers/update_research_study_participants_trigger_v01.sql
renalware-core-2.0.109 db/triggers/update_research_study_participants_trigger_v01.sql
renalware-core-2.0.108 db/triggers/update_research_study_participants_trigger_v01.sql
renalware-core-2.0.106 db/triggers/update_research_study_participants_trigger_v01.sql
renalware-core-2.0.105 db/triggers/update_research_study_participants_trigger_v01.sql