diff options
author | Yorhel <git@yorhel.nl> | 2015-01-28 13:00:18 +0100 |
---|---|---|
committer | Yorhel <git@yorhel.nl> | 2015-01-28 13:00:18 +0100 |
commit | 98e6d1a8eb593007d34175b273d23d0fb8fff622 (patch) | |
tree | dbc3d94adb740eefdce870452dad981c74e79c6a /util | |
parent | c6fb63e28063e85d2c71fc69200f3d480de0b9c4 (diff) | |
parent | b718d117282e73c3f99d308efde46d56789cd041 (diff) |
Merge branch 'staff' into master
Conflicts:
lib/VNDB/DB/VN.pm
lib/VNDB/Handler/VNPage.pm
Diffstat (limited to 'util')
-rw-r--r-- | util/sql/staff.sql | 2 |
1 files changed, 1 insertions, 1 deletions
diff --git a/util/sql/staff.sql b/util/sql/staff.sql index 972765ea..0c91deb4 100644 --- a/util/sql/staff.sql +++ b/util/sql/staff.sql @@ -59,7 +59,7 @@ 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 INDEX staff_alias_orig ON staff_alias (translate(original,' ','')); +--CREATE INDEX staff_alias_orig ON staff_alias (translate(original,' ','')); CREATE TRIGGER hidlock_update BEFORE UPDATE ON staff FOR EACH ROW WHEN (OLD.latest IS DISTINCT FROM NEW.latest) EXECUTE PROCEDURE update_hidlock(); |