diff options
Diffstat (limited to 'util')
-rw-r--r-- | util/sql/staff.sql | 2 |
1 files changed, 2 insertions, 0 deletions
diff --git a/util/sql/staff.sql b/util/sql/staff.sql index c4ff41ba..7c99971e 100644 --- a/util/sql/staff.sql +++ b/util/sql/staff.sql @@ -56,3 +56,5 @@ ALTER TABLE vn_seiyuu ADD FOREIGN KEY (vid) REFERENCES vn_rev CREATE INDEX vn_staff_vid ON vn_staff (vid); CREATE INDEX vn_staff_aid ON vn_staff (aid); + +CREATE TRIGGER hidlock_update BEFORE UPDATE ON staff FOR EACH ROW WHEN (OLD.latest IS DISTINCT FROM NEW.latest) EXECUTE PROCEDURE update_hidlock(); |