Danila KhodjaefandCursor
acc4a91a08
Public GET /api/search over artists, movements, and paintings with a debounced header bar on the timeline; Back to Timeline resets zoom and gallery session. Co-authored-by: Cursor <cursoragent@cursor.com>
7 lines
498 B
SQL
7 lines
498 B
SQL
-- Indexes for catalog search (ILIKE on name/title)
|
|
CREATE INDEX IF NOT EXISTS artists_name_lower_idx ON artists (lower(name));
|
|
CREATE INDEX IF NOT EXISTS artists_wikipedia_title_lower_idx ON artists (lower(wikipedia_title));
|
|
CREATE INDEX IF NOT EXISTS paintings_title_lower_idx ON paintings (lower(title));
|
|
CREATE INDEX IF NOT EXISTS paintings_wikipedia_title_lower_idx ON paintings (lower(wikipedia_title));
|
|
CREATE INDEX IF NOT EXISTS art_movements_name_lower_idx ON art_movements (lower(name));
|