diff options
author | Yorhel <git@yorhel.nl> | 2022-08-04 10:03:01 +0200 |
---|---|---|
committer | Yorhel <git@yorhel.nl> | 2022-08-04 10:03:01 +0200 |
commit | b2190a32a4c4fe967ac226df23c8692184f35132 (patch) | |
tree | 7526d0e4d48ac645edca06823b4e6bfd6603798e /sql | |
parent | a74aef240cd270047730cd7931f5d7f35f3701a8 (diff) |
AdvSearch: Also add option to not match child traits
Diffstat (limited to 'sql')
-rw-r--r-- | sql/tableattrs.sql | 1 |
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); |