diff options
Diffstat (limited to 'util/sql/tableattrs.sql')
-rw-r--r-- | util/sql/tableattrs.sql | 1 |
1 files changed, 1 insertions, 0 deletions
diff --git a/util/sql/tableattrs.sql b/util/sql/tableattrs.sql index 05770f83..b3ac137f 100644 --- a/util/sql/tableattrs.sql +++ b/util/sql/tableattrs.sql @@ -102,6 +102,7 @@ CREATE INDEX tags_vn_date ON tags_vn (date); CREATE INDEX tags_vn_vid ON tags_vn (vid); CREATE INDEX threads_posts_ts ON threads_posts USING gin(to_tsvector('english', strip_bb_tags(msg))); CREATE INDEX vn_staff_aid ON vn_staff (aid); +CREATE INDEX vn_seiyuu_aid ON vn_seiyuu (aid); CREATE UNIQUE INDEX changes_itemrev ON changes (type, itemid, rev); CREATE UNIQUE INDEX chars_vns_pkey ON chars_vns (id, vid, COALESCE(rid, 0)); CREATE UNIQUE INDEX chars_vns_hist_pkey ON chars_vns_hist (chid, vid, COALESCE(rid, 0)); |