summaryrefslogtreecommitdiff
path: root/deploy/diaries_update_timestamp.sql
blob: c11104fc245e1acc42b1bd8157b94dab69df1824 (about) (plain)
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
-- Deploy photos:diaries_update_timestamp to pg
-- requires: schema
-- requires: diaries
-- requires: update_timestamp

BEGIN;

SET search_path to photos;

CREATE OR REPLACE TRIGGER update_timestamp
  BEFORE UPDATE ON diaries
  FOR EACH ROW
  EXECUTE FUNCTION update_timestamp();

COMMIT;