summaryrefslogtreecommitdiff
path: root/util/sql
diff options
context:
space:
mode:
authormorkt <>2015-01-02 10:22:25 +0100
committerYorhel <git@yorhel.nl>2015-01-02 10:22:25 +0100
commit228cb96969a33a60c40dd4991a394460652010af (patch)
tree9d69e00562ae545b79ca8a899d2439c4800133d7 /util/sql
parent03585d77637a7052d0af2cdb1e4be66358412b6a (diff)
staff: Fix deleting of staff + use JSON to pass data + minor fixes
Diffstat (limited to 'util/sql')
-rw-r--r--util/sql/staff.sql2
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();