2 -- PostgreSQL database dump
5 SET client_encoding = 'UTF8';
6 SET standard_conforming_strings = off;
7 SET check_function_bodies = false;
8 SET client_min_messages = warning;
9 SET escape_string_warning = off;
11 SET search_path = query, pg_catalog;
14 -- Name: case_branch_id_seq; Type: SEQUENCE SET; Schema: query; Owner: evergreen
17 SELECT pg_catalog.setval('case_branch_id_seq', 3, true);
21 -- Name: expression_id_seq; Type: SEQUENCE SET; Schema: query; Owner: evergreen
24 SELECT pg_catalog.setval('expression_id_seq', 60, true);
28 -- Name: from_relation_id_seq; Type: SEQUENCE SET; Schema: query; Owner: evergreen
31 SELECT pg_catalog.setval('from_relation_id_seq', 10, true);
35 -- Name: function_param_def_id_seq; Type: SEQUENCE SET; Schema: query; Owner: evergreen
38 SELECT pg_catalog.setval('function_param_def_id_seq', 1, false);
42 -- Name: function_sig_id_seq; Type: SEQUENCE SET; Schema: query; Owner: evergreen
45 SELECT pg_catalog.setval('function_sig_id_seq', 6, true);
49 -- Name: order_by_item_id_seq; Type: SEQUENCE SET; Schema: query; Owner: evergreen
52 SELECT pg_catalog.setval('order_by_item_id_seq', 4, true);
56 -- Name: query_sequence_id_seq; Type: SEQUENCE SET; Schema: query; Owner: evergreen
59 SELECT pg_catalog.setval('query_sequence_id_seq', 4, true);
63 -- Name: record_column_id_seq; Type: SEQUENCE SET; Schema: query; Owner: evergreen
66 SELECT pg_catalog.setval('record_column_id_seq', 1, false);
70 -- Name: select_item_id_seq; Type: SEQUENCE SET; Schema: query; Owner: evergreen
73 SELECT pg_catalog.setval('select_item_id_seq', 47, true);
77 -- Name: stored_query_id_seq; Type: SEQUENCE SET; Schema: query; Owner: evergreen
80 SELECT pg_catalog.setval('stored_query_id_seq', 25, true);
84 -- Name: subfield_id_seq; Type: SEQUENCE SET; Schema: query; Owner: evergreen
87 SELECT pg_catalog.setval('subfield_id_seq', 1, false);
91 -- Data for Name: bind_variable; Type: TABLE DATA; Schema: query; Owner: evergreen
94 ALTER TABLE bind_variable DISABLE TRIGGER ALL;
96 COPY bind_variable (name, type, description, default_value, label) FROM stdin;
97 shortname string org unit shortname "BR3" lib shortname
98 O'Leary string Ireland's kind of name "O'Bryan" nom d'Eire
99 ou number org unit \N lib
103 ALTER TABLE bind_variable ENABLE TRIGGER ALL;
106 -- Data for Name: case_branch; Type: TABLE DATA; Schema: query; Owner: evergreen
109 ALTER TABLE case_branch DISABLE TRIGGER ALL;
111 COPY case_branch (id, parent_expr, seq_no, condition, result) FROM stdin;
118 ALTER TABLE case_branch ENABLE TRIGGER ALL;
121 -- Data for Name: expression; Type: TABLE DATA; Schema: query; Owner: evergreen
124 ALTER TABLE expression DISABLE TRIGGER ALL;
126 COPY expression (id, type, parenthesize, parent_expr, seq_no, literal, table_alias, column_name, left_operand, operator, right_operand, function_id, subquery, cast_type, negate, bind_variable) FROM stdin;
127 1 xbool f \N 1 TRUE \N \N \N \N \N \N \N \N f \N
128 2 xcol f \N 1 \N aou id \N \N \N \N \N \N f \N
129 3 xcol f \N 1 \N aou name \N \N \N \N \N \N f \N
130 4 xcol f \N 1 \N aou shortname \N \N \N \N \N \N f \N
131 5 xcol f \N 1 \N aou parent_ou \N \N \N \N \N \N f \N
132 6 xnum f \N 1 3 \N \N \N \N \N \N \N \N f \N
133 7 xop f \N 1 \N \N \N 5 > 6 \N \N \N f \N
134 8 xop f \N 1 \N \N \N 2 = 6 \N \N \N f \N
135 9 xsubq f \N 1 \N \N \N \N \N \N \N 3 \N f \N
136 10 xcol f \N 1 \N aout id \N \N \N \N \N \N f \N
137 11 xin f \N 1 \N \N \N 10 \N \N \N 3 \N f \N
138 12 xcol f \N 1 \N aou ou_type \N \N \N \N \N \N f \N
139 13 xcol f \N 1 \N au id \N \N \N \N \N \N f \N
140 14 xop f \N 1 \N \N \N 13 = 12 \N \N \N f \N
141 15 xex f \N 1 \N \N \N \N \N \N \N 3 \N f \N
142 16 xcol f \N 1 \N aou \N \N \N \N \N \N \N f \N
143 17 xbind f \N 1 \N \N \N \N \N \N \N \N \N f ou
144 18 xop f \N 1 \N \N \N 2 = 17 \N \N \N f \N
145 19 xcol f \N 1 \N aou opac_visible \N \N \N \N \N \N f \N
146 20 xbind f \N 1 \N \N \N \N \N \N \N \N \N f shortname
147 21 xop f \N 1 \N \N \N 4 = 20 \N \N \N f \N
148 23 xcol f \N 1 \N aou email \N \N \N \N \N \N f \N
149 24 xcol f \N 1 \N aou holds_address \N \N \N \N \N \N f \N
150 27 xser f \N 1 \N \N \N \N OR \N \N \N \N f \N
151 22 xisnull f 27 1 \N \N \N 5 \N \N \N \N \N f \N
152 25 xisnull f 27 2 \N \N \N 23 \N \N \N \N \N f \N
153 26 xisnull f 27 3 \N \N \N 24 \N \N \N \N \N f \N
154 32 xin f \N 1 \N \N \N 5 \N \N \N \N \N f \N
155 29 xnum f 32 1 1 \N \N \N \N \N \N \N \N f \N
156 30 xnum f 32 2 3 \N \N \N \N \N \N \N \N f \N
157 31 xnum f 32 3 6 \N \N \N \N \N \N \N \N f \N
158 33 xfunc f \N 1 \N \N \N \N \N \N 1 \N \N f \N
159 34 xcol f 33 1 \N aou name \N \N \N \N \N \N f \N
160 35 xop f \N 1 \N \N \N 2 = 6 \N \N \N f \N
161 36 xfunc f \N 1 \N \N name \N \N \N 2 \N \N f \N
162 37 xcol f 36 1 \N aou id \N \N \N \N \N \N f \N
163 38 xbet f \N 1 \N \N \N 5 \N \N \N \N \N f \N
164 39 xnum f 38 1 1 \N \N \N \N \N \N \N \N f \N
165 40 xnum f 38 2 4 \N \N \N \N \N \N \N \N f \N
166 41 xfunc f \N 1 \N \N \N \N \N \N 3 \N \N f \N
167 42 xstr f 41 1 DOW \N \N \N \N \N \N \N \N f \N
168 43 xcol f 41 2 \N au create_date \N \N \N \N \N \N f \N
169 44 xfunc f \N 1 \N \N \N \N \N \N 4 \N \N f \N
170 45 xnum f 44 1 1 \N \N \N \N \N \N \N \N f \N
171 46 xfunc f \N 1 \N \N \N \N \N \N 1 \N \N f \N
172 47 xstr f 46 1 goober \N \N \N \N \N \N \N \N f \N
173 48 xcol f \N 1 \N \N \N \N \N \N \N \N \N f \N
174 49 xfunc f \N 1 \N \N \N \N \N \N 5 \N \N f \N
175 50 xfunc f \N 1 \N \N \N \N \N \N 6 \N \N f \N
176 51 xstr f 50 1 both \N \N \N \N \N \N \N \N f \N
177 52 xcol f 50 2 \N au usrname \N \N \N \N \N \N f \N
178 54 xnum f \N 1 2 \N \N \N \N \N \N \N \N f \N
179 55 xstr f \N 1 First \N \N \N \N \N \N \N \N f \N
180 56 xstr f \N 1 Second \N \N \N \N \N \N \N \N f \N
181 57 xstr f \N 1 Other \N \N \N \N \N \N \N \N f \N
182 53 xcase f \N 1 \N \N \N 2 \N \N \N \N \N f \N
183 58 xnum f \N 1 1 \N \N \N \N \N \N \N \N f \N
184 59 xcast f \N 1 \N \N \N 2 \N \N \N \N 13 f \N
185 60 xnum f \N 1 100 \N \N \N \N \N \N \N \N f \N
189 ALTER TABLE expression ENABLE TRIGGER ALL;
192 -- Data for Name: from_relation; Type: TABLE DATA; Schema: query; Owner: evergreen
195 ALTER TABLE from_relation DISABLE TRIGGER ALL;
197 COPY from_relation (id, type, table_name, class_name, subquery, function_call, table_alias, parent_relation, seq_no, join_type, on_clause) FROM stdin;
198 1 RELATION actor.org_unit aou \N \N aou \N 1 \N \N
199 2 RELATION actor.org_unit_type aout \N \N aout 1 1 INNER 1
200 3 RELATION actor.org_unit aou \N \N aou \N 1 \N \N
201 4 RELATION actor.org_unit_type aout \N \N aout \N 1 \N \N
202 5 SUBQUERY \N \N 3 \N aou \N 1 \N \N
203 6 RELATION actor.usr au \N \N au \N 1 \N \N
204 7 SUBQUERY \N \N 3 \N aou 6 1 INNER 14
205 8 RELATION \N aou \N \N aou \N 1 \N \N
206 9 RELATION actor.usr au \N \N au \N 1 \N \N
207 10 FUNCTION \N \N \N 46 \N \N 1 \N \N
211 ALTER TABLE from_relation ENABLE TRIGGER ALL;
214 -- Data for Name: function_param_def; Type: TABLE DATA; Schema: query; Owner: evergreen
217 ALTER TABLE function_param_def DISABLE TRIGGER ALL;
219 COPY function_param_def (id, function_id, seq_no, datatype) FROM stdin;
223 ALTER TABLE function_param_def ENABLE TRIGGER ALL;
226 -- Data for Name: function_sig; Type: TABLE DATA; Schema: query; Owner: evergreen
229 ALTER TABLE function_sig DISABLE TRIGGER ALL;
231 COPY function_sig (id, function_name, return_type, is_aggregate) FROM stdin;
233 2 actor.org_unit_ancestors \N f
241 ALTER TABLE function_sig ENABLE TRIGGER ALL;
244 -- Data for Name: order_by_item; Type: TABLE DATA; Schema: query; Owner: evergreen
247 ALTER TABLE order_by_item DISABLE TRIGGER ALL;
249 COPY order_by_item (id, stored_query, seq_no, expression) FROM stdin;
255 ALTER TABLE order_by_item ENABLE TRIGGER ALL;
258 -- Data for Name: query_sequence; Type: TABLE DATA; Schema: query; Owner: evergreen
261 ALTER TABLE query_sequence DISABLE TRIGGER ALL;
263 COPY query_sequence (id, parent_query, seq_no, child_query) FROM stdin;
269 ALTER TABLE query_sequence ENABLE TRIGGER ALL;
272 -- Data for Name: record_column; Type: TABLE DATA; Schema: query; Owner: evergreen
275 ALTER TABLE record_column DISABLE TRIGGER ALL;
277 COPY record_column (id, from_relation, seq_no, column_name, column_type) FROM stdin;
281 ALTER TABLE record_column ENABLE TRIGGER ALL;
284 -- Data for Name: select_item; Type: TABLE DATA; Schema: query; Owner: evergreen
287 ALTER TABLE select_item DISABLE TRIGGER ALL;
289 COPY select_item (id, stored_query, seq_no, expression, column_alias, grouped_by) FROM stdin;
303 14 10 3 4 short_name f
323 34 18 4 36 root_name f
326 37 20 2 41 create_day f
327 39 21 2 44 how_many f
330 41 22 1 44 how_many f
333 45 24 2 53 Branch sequence f
335 47 25 1 59 cast_text f
339 ALTER TABLE select_item ENABLE TRIGGER ALL;
342 -- Data for Name: stored_query; Type: TABLE DATA; Schema: query; Owner: evergreen
345 ALTER TABLE stored_query DISABLE TRIGGER ALL;
347 COPY stored_query (id, type, use_all, use_distinct, from_clause, where_clause, having_clause, limit_count, offset_count) FROM stdin;
348 1 SELECT f f 1 7 \N \N \N
349 2 UNION f f \N \N \N \N \N
350 3 SELECT f f 3 8 \N \N \N
351 4 SELECT f f 4 \N \N \N \N
352 5 SELECT f f 4 11 \N \N \N
353 6 SELECT f f 5 \N \N \N \N
354 7 SELECT f f 6 \N \N \N \N
355 8 SELECT f f 4 15 \N \N \N
356 9 SELECT f f 3 \N \N \N \N
357 10 SELECT f f 3 \N \N \N \N
358 13 SELECT f f 8 21 \N \N \N
359 14 SELECT f f 3 22 \N \N \N
360 15 SELECT f f 3 27 \N \N \N
361 16 SELECT f f 3 32 \N \N \N
362 17 SELECT f f 3 32 \N \N \N
363 18 SELECT f f 3 35 \N \N \N
364 19 SELECT f f 3 38 \N \N \N
365 20 SELECT f f 9 \N \N \N \N
366 21 SELECT f f 3 \N \N \N \N
367 23 SELECT f f 10 \N \N \N \N
368 22 SELECT f f 3 \N \N \N \N
369 24 SELECT f f 3 \N \N \N \N
370 25 SELECT f f 3 \N \N \N \N
371 12 SELECT f f 8 18 \N \N \N
372 11 SELECT f f 8 \N \N 60 58
376 ALTER TABLE stored_query ENABLE TRIGGER ALL;
379 -- Data for Name: subfield; Type: TABLE DATA; Schema: query; Owner: evergreen
382 ALTER TABLE subfield DISABLE TRIGGER ALL;
384 COPY subfield (id, composite_type, seq_no, subfield_type) FROM stdin;
388 ALTER TABLE subfield ENABLE TRIGGER ALL;
391 -- PostgreSQL database dump complete