summaryrefslogtreecommitdiff
path: root/postgresqleu/confreg/sql/speaker.sql
blob: 26ec7c92113b3a73c9af00b826f846efa1ab70cd (plain)
1
2
3
4
5
6
7
8
9
10
11
12
13
CREATE OR REPLACE FUNCTION speaker_deleted()
RETURNS trigger AS $$
BEGIN
   INSERT INTO confreg_deleteditems (itemid, type, deltime) VALUES (OLD.id, 'spk', CURRENT_TIMESTAMP);
   RETURN NULL;
END;
$$ LANGUAGE 'plpgsql';

DROP TRIGGER IF EXISTS trg_speaker_deleted ON confreg_speaker;
CREATE TRIGGER trg_speaker_deleted
AFTER DELETE ON confreg_speaker
FOR EACH ROW EXECUTE PROCEDURE speaker_deleted();