3 SELECT evergreen.upgrade_deps_block_check('XXXX', :eg_version);
5 DROP VIEW action.all_circulation_combined_types;
7 CREATE OR REPLACE VIEW action.all_circulation_combined_types AS
8 SELECT 'regularcirc'::text || acirc.id AS id,
13 ac_acirc.circ_modifier AS item_type,
14 'regular_circ'::text AS circ_type
15 FROM action.circulation acirc,
17 WHERE acirc.target_copy = ac_acirc.id
19 SELECT 'noncatcirc'::text || ancc.id AS id,
20 ancc.circ_time AS xact_start,
22 ancc.staff AS circ_staff,
23 ancc.circ_time AS create_time,
24 cnct_ancc.name AS item_type,
25 'non-cat_circ'::text AS circ_type
26 FROM action.non_cataloged_circulation ancc,
27 config.non_cataloged_type cnct_ancc
28 WHERE ancc.item_type = cnct_ancc.id
30 SELECT 'inhouseuse'::text || aihu.id AS id,
31 aihu.use_time AS xact_start,
32 aihu.org_unit AS circ_lib,
33 aihu.staff AS circ_staff,
34 aihu.use_time AS create_time,
35 ac_aihu.circ_modifier AS item_type,
36 'in-house_use'::text AS circ_type
37 FROM action.in_house_use aihu,
39 WHERE aihu.item = ac_aihu.id
41 SELECT 'noncatinhouseuse'::text || ancihu.id AS id,
42 ancihu.use_time AS xact_start,
43 ancihu.org_unit AS circ_lib,
44 ancihu.staff AS circ_staff,
45 ancihu.use_time AS create_time,
46 cnct_ancihu.name AS item_type,
47 'non-cat_circ'::text AS circ_type
48 FROM action.non_cat_in_house_use ancihu,
49 config.non_cataloged_type cnct_ancihu
50 WHERE ancihu.item_type = cnct_ancihu.id
52 SELECT 'agedcirc'::text || aacirc.id::text AS id,
57 ac_aacirc.circ_modifier AS item_type,
58 'aged_circ'::text AS circ_type
59 FROM action.aged_circulation aacirc,
61 WHERE aacirc.target_copy = ac_aacirc.id;