LP#1831803: (follow-up) update release notes formatting
[Evergreen.git] / Open-ILS / src / sql / Pg / upgrade / XXXX.schema.staged_search_cleanup.sql
1 BEGIN;
2
3 SELECT evergreen.upgrade_deps_block_check('XXXX', :eg_version);
4
5 DROP FUNCTION search.query_parser_fts (
6     INT,
7     INT,
8     TEXT,
9     INT[],
10     INT[],
11     INT,
12     INT,
13     INT,
14     BOOL,
15     BOOL,
16     BOOL,
17     INT 
18 );
19
20 DROP TABLE asset.opac_visible_copies;
21
22 DROP FUNCTION IF EXISTS asset.refresh_opac_visible_copies_mat_view();
23
24 DROP TYPE search.search_result;
25 DROP TYPE search.search_args;
26
27 COMMIT;