NotAShelf
6a73d11c4b
Signed-off-by: NotAShelf <raf@notashelf.dev> Change-Id: I4a6b498153eccd5407510dd541b7f4816a6a6964
8 lines
630 B
SQL
8 lines
630 B
SQL
CREATE INDEX IF NOT EXISTS idx_audit_media_id ON audit_log(media_id);
|
|
CREATE INDEX IF NOT EXISTS idx_audit_timestamp ON audit_log(timestamp);
|
|
CREATE INDEX IF NOT EXISTS idx_audit_action ON audit_log(action);
|
|
CREATE INDEX IF NOT EXISTS idx_media_content_hash ON media_items(content_hash);
|
|
CREATE INDEX IF NOT EXISTS idx_media_media_type ON media_items(media_type);
|
|
CREATE INDEX IF NOT EXISTS idx_media_created_at ON media_items(created_at);
|
|
CREATE INDEX IF NOT EXISTS idx_media_title_trgm ON media_items USING GIN(title gin_trgm_ops);
|
|
CREATE INDEX IF NOT EXISTS idx_media_artist_trgm ON media_items USING GIN(artist gin_trgm_ops);
|