stash-box/pkg/database/migrations/postgres/2_create_search.down.sql
InfiniteStash 0d9f46c6f1 Omnibus stashdb changes (#19)
* Add fuzzy performer/scene search
* Add frontend support for users
* Add support for tags and fingerprints
* Fingerprint duration and UI updates
* Add image entity for performers/scenes/studios
* Switch frontend to create-react-app and typescript 3.9
* Remove image fields from URL type
* Remove image fields from studio
* Fix bugs, and update frontend config/readme
* Add pg_trgm info
* Fix integration tests
* Create image url resolver and remove unused image fields
* Don't open browser by default
* Fix development auth cookie issues

Co-authored-by: WithoutPants <53250216+WithoutPants@users.noreply.github.com>
2020-06-25 13:40:09 +10:00

13 lines
253 B
SQL

DROP TABLE scene_search;
DROP INDEX name_trgm_idx;
DROP FUNCTION update_performers CASCADE;
DROP FUNCTION update_scene CASCADE;
DROP FUNCTION insert_scene CASCADE;
DROP FUNCTION update_studio CASCADE;
DROP FUNCTION update_scene_performers CASCADE;