mirror of
https://github.com/ajayyy/SponsorBlockServer.git
synced 2024-09-19 20:51:19 +02:00
26 lines
No EOL
1 KiB
SQL
26 lines
No EOL
1 KiB
SQL
-- sponsorTimes
|
|
|
|
CREATE INDEX IF NOT EXISTS "privateDB_sponsorTimes_v4"
|
|
ON public."sponsorTimes" USING btree
|
|
("videoID" ASC NULLS LAST, service COLLATE pg_catalog."default" ASC NULLS LAST, "timeSubmitted" ASC NULLS LAST);
|
|
|
|
-- votes
|
|
|
|
CREATE INDEX IF NOT EXISTS "votes_userID"
|
|
ON public.votes USING btree
|
|
("UUID" COLLATE pg_catalog."default" ASC NULLS LAST)
|
|
TABLESPACE pg_default;
|
|
|
|
-- categoryVotes
|
|
|
|
CREATE INDEX IF NOT EXISTS "categoryVotes_UUID"
|
|
ON public."categoryVotes" USING btree
|
|
("UUID" COLLATE pg_catalog."default" ASC NULLS LAST, "userID" COLLATE pg_catalog."default" ASC NULLS LAST, "hashedIP" COLLATE pg_catalog."default" ASC NULLS LAST, category COLLATE pg_catalog."default" ASC NULLS LAST)
|
|
TABLESPACE pg_default;
|
|
|
|
-- ratings
|
|
|
|
CREATE INDEX IF NOT EXISTS "ratings_videoID"
|
|
ON public."ratings" USING btree
|
|
("videoID" COLLATE pg_catalog."default" ASC NULLS LAST, service COLLATE pg_catalog."default" ASC NULLS LAST, "userID" COLLATE pg_catalog."default" ASC NULLS LAST, "timeSubmitted" ASC NULLS LAST)
|
|
TABLESPACE pg_default; |