summaryrefslogtreecommitdiff
path: root/sql
diff options
context:
space:
mode:
authorYorhel <git@yorhel.nl>2022-08-04 10:03:01 +0200
committerYorhel <git@yorhel.nl>2022-08-04 10:03:01 +0200
commitb2190a32a4c4fe967ac226df23c8692184f35132 (patch)
tree7526d0e4d48ac645edca06823b4e6bfd6603798e /sql
parenta74aef240cd270047730cd7931f5d7f35f3701a8 (diff)
AdvSearch: Also add option to not match child traits
Diffstat (limited to 'sql')
-rw-r--r--sql/tableattrs.sql1
1 files changed, 1 insertions, 0 deletions
diff --git a/sql/tableattrs.sql b/sql/tableattrs.sql
index 1fc957c3..176657e8 100644
--- a/sql/tableattrs.sql
+++ b/sql/tableattrs.sql
@@ -3,6 +3,7 @@
CREATE INDEX chars_main ON chars (main) WHERE main IS NOT NULL AND NOT hidden; -- Only used on /c+
CREATE INDEX chars_vns_vid ON chars_vns (vid);
CREATE INDEX chars_image ON chars (image);
+CREATE INDEX chars_traits_tid ON chars_traits (tid);
CREATE UNIQUE INDEX image_votes_pkey ON image_votes (uid, id);
CREATE INDEX image_votes_id ON image_votes (id);
CREATE INDEX notifications_uid_iid ON notifications (uid,iid);