Open-ILS/tests/datasets/sql/concerto_enhanced/load_all.sql

   1 BEGIN;
   2
   3 -- stop on error
   4 \set ON_ERROR_STOP on
   5
   6 -- Ignore constraints until we're done
   7 SET CONSTRAINTS ALL DEFERRED;
   8
   9 \echo loading actor.org_unit
  10 \i actor.org_unit.sql
  11
  12 \echo loading actor.usr
  13 \i actor.usr.sql
  14
  15 \echo loading acq.fund
  16 \i acq.fund.sql
  17
  18 \echo loading acq.provider
  19 \i acq.provider.sql
  20
  21 \echo loading asset.call_number
  22 \i asset.call_number.sql
  23
  24 \echo loading asset.uri
  25 \i asset.uri.sql
  26
  27 \echo loading asset.uri_call_number_map
  28 \i asset.uri_call_number_map.sql
  29
  30 \echo loading biblio.record_entry
  31 \i biblio.record_entry.sql
  32
  33 \echo loading biblio.monograph_part
  34 \i biblio.monograph_part.sql
  35
  36 \echo loading acq.edi_account
  37 \i acq.edi_account.sql
  38
  39 \echo loading acq.purchase_order
  40 \i acq.purchase_order.sql
  41
  42 \echo loading acq.lineitem
  43 \i acq.lineitem.sql
  44
  45 \echo loading acq.lineitem_detail
  46 \i acq.lineitem_detail.sql
  47
  48 \echo loading acq.invoice
  49 \i acq.invoice.sql
  50
  51 \echo loading acq.invoice_entry
  52 \i acq.invoice_entry.sql
  53
  54 \echo loading asset.copy_location
  55 \i asset.copy_location.sql
  56
  57 \echo loading asset.copy
  58 \i asset.copy.sql
  59
  60 \echo loading biblio.peer_type
  61 \i biblio.peer_type.sql
  62
  63 \echo loading authority.record_entry
  64 \i authority.record_entry.sql
  65
  66 \echo loading money.grocery
  67 \i money.grocery.sql
  68
  69 \echo loading money.billing
  70 \i money.billing.sql
  71
  72 \echo loading acq.acq_lineitem_history
  73 \i acq.acq_lineitem_history.sql
  74
  75 \echo loading acq.acq_purchase_order_history
  76 \i acq.acq_purchase_order_history.sql
  77
  78 \echo loading acq.fund_allocation
  79 \i acq.fund_allocation.sql
  80
  81 \echo loading acq.fund_debit
  82 \i acq.fund_debit.sql
  83
  84 \echo loading acq.fund_transfer
  85 \i acq.fund_transfer.sql
  86
  87 \echo loading acq.funding_source
  88 \i acq.funding_source.sql
  89
  90 \echo loading acq.funding_source_credit
  91 \i acq.funding_source_credit.sql
  92
  93 \echo loading acq.invoice_item
  94 \i acq.invoice_item.sql
  95
  96 \echo loading acq.po_item
  97 \i acq.po_item.sql
  98
  99 \echo loading acq.provider_holding_subfield_map
 100 \i acq.provider_holding_subfield_map.sql
 101
 102 \echo loading action.circulation
 103 \i action.circulation.sql
 104
 105 \echo loading action.hold_copy_map
 106 \i action.hold_copy_map.sql
 107
 108 \echo loading action.hold_request
 109 \i action.hold_request.sql
 110
 111 \echo loading action.hold_request_note
 112 \i action.hold_request_note.sql
 113
 114 \echo loading action.survey
 115 \i action.survey.sql
 116
 117 \echo loading action.survey_answer
 118 \i action.survey_answer.sql
 119
 120 \echo loading action.survey_question
 121 \i action.survey_question.sql
 122
 123 \echo loading action.survey_response
 124 \i action.survey_response.sql
 125
 126 \echo loading action.unfulfilled_hold_list
 127 \i action.unfulfilled_hold_list.sql
 128
 129 \echo loading actor.card
 130 \i actor.card.sql
 131
 132 \echo loading actor.hours_of_operation
 133 \i actor.hours_of_operation.sql
 134
 135 \echo loading actor.org_address
 136 \i actor.org_address.sql
 137
 138 \echo loading actor.org_unit_closed
 139 \i actor.org_unit_closed.sql
 140
 141 \echo loading actor.org_unit_setting
 142 \i actor.org_unit_setting.sql
 143
 144 \echo loading actor.passwd
 145 \i actor.passwd.sql
 146
 147 \echo loading actor.stat_cat
 148 \i actor.stat_cat.sql
 149
 150 \echo loading actor.stat_cat_entry
 151 \i actor.stat_cat_entry.sql
 152
 153 \echo loading actor.stat_cat_entry_default
 154 \i actor.stat_cat_entry_default.sql
 155
 156 \echo loading actor.stat_cat_entry_usr_map
 157 \i actor.stat_cat_entry_usr_map.sql
 158
 159 \echo loading actor.usr_activity
 160 \i actor.usr_activity.sql
 161
 162 \echo loading actor.usr_address
 163 \i actor.usr_address.sql
 164
 165 \echo loading actor.usr_setting
 166 \i actor.usr_setting.sql
 167
 168 \echo loading actor.usr_standing_penalty
 169 \i actor.usr_standing_penalty.sql
 170
 171 \echo loading actor.workstation
 172 \i actor.workstation.sql
 173
 174 \echo loading asset.call_number_prefix
 175 \i asset.call_number_prefix.sql
 176
 177 \echo loading asset.call_number_suffix
 178 \i asset.call_number_suffix.sql
 179
 180 \echo loading asset.copy_location_group
 181 \i asset.copy_location_group.sql
 182
 183 \echo loading asset.copy_location_group_map
 184 \i asset.copy_location_group_map.sql
 185
 186 \echo loading asset.copy_note
 187 \i asset.copy_note.sql
 188
 189 \echo loading asset.copy_part_map
 190 \i asset.copy_part_map.sql
 191
 192 \echo loading asset.copy_template
 193 \i asset.copy_template.sql
 194
 195 \echo loading asset.course_module_course
 196 \i asset.course_module_course.sql
 197
 198 \echo loading asset.course_module_course_materials
 199 \i asset.course_module_course_materials.sql
 200
 201 \echo loading asset.stat_cat
 202 \i asset.stat_cat.sql
 203
 204 \echo loading asset.stat_cat_entry
 205 \i asset.stat_cat_entry.sql
 206
 207 \echo loading authority.bib_linking
 208 \i authority.bib_linking.sql
 209
 210 \echo loading biblio.peer_bib_copy_map
 211 \i biblio.peer_bib_copy_map.sql
 212
 213 \echo loading booking.reservation
 214 \i booking.reservation.sql
 215
 216 \echo loading booking.reservation_attr_value_map
 217 \i booking.reservation_attr_value_map.sql
 218
 219 \echo loading booking.resource
 220 \i booking.resource.sql
 221
 222 \echo loading booking.resource_attr
 223 \i booking.resource_attr.sql
 224
 225 \echo loading booking.resource_attr_map
 226 \i booking.resource_attr_map.sql
 227
 228 \echo loading booking.resource_attr_value
 229 \i booking.resource_attr_value.sql
 230
 231 \echo loading booking.resource_type
 232 \i booking.resource_type.sql
 233
 234 \echo loading config.billing_type
 235 \i config.billing_type.sql
 236
 237 \echo loading config.circ_limit_set
 238 \i config.circ_limit_set.sql
 239
 240 \echo loading config.circ_limit_set_circ_mod_map
 241 \i config.circ_limit_set_circ_mod_map.sql
 242
 243 \echo loading config.circ_limit_set_copy_loc_map
 244 \i config.circ_limit_set_copy_loc_map.sql
 245
 246 \echo loading config.circ_matrix_matchpoint
 247 \i config.circ_matrix_matchpoint.sql
 248
 249 \echo loading config.circ_modifier
 250 \i config.circ_modifier.sql
 251
 252 \echo loading config.copy_tag_type
 253 \i config.copy_tag_type.sql
 254
 255 \echo loading config.floating_group
 256 \i config.floating_group.sql
 257
 258 \echo loading config.floating_group_member
 259 \i config.floating_group_member.sql
 260
 261 \echo loading config.hold_matrix_matchpoint
 262 \i config.hold_matrix_matchpoint.sql
 263
 264 \echo loading config.remoteauth_profile
 265 \i config.remoteauth_profile.sql
 266
 267 \echo loading config.rule_circ_duration
 268 \i config.rule_circ_duration.sql
 269
 270 \echo loading config.rule_max_fine
 271 \i config.rule_max_fine.sql
 272
 273 \echo loading config.rule_recurring_fine
 274 \i config.rule_recurring_fine.sql
 275
 276 \echo loading config.usr_activity_type
 277 \i config.usr_activity_type.sql
 278
 279 \echo loading container.biblio_record_entry_bucket
 280 \i container.biblio_record_entry_bucket.sql
 281
 282 \echo loading container.biblio_record_entry_bucket_item
 283 \i container.biblio_record_entry_bucket_item.sql
 284
 285 \echo loading container.carousel
 286 \i container.carousel.sql
 287
 288 \echo loading container.carousel_org_unit
 289 \i container.carousel_org_unit.sql
 290
 291 \echo loading container.user_bucket
 292 \i container.user_bucket.sql
 293
 294 \echo loading container.user_bucket_item
 295 \i container.user_bucket_item.sql
 296
 297 \echo loading money.account_adjustment
 298 \i money.account_adjustment.sql
 299
 300 \echo loading money.cash_payment
 301 \i money.cash_payment.sql
 302
 303 \echo loading money.check_payment
 304 \i money.check_payment.sql
 305
 306 \echo loading money.credit_card_payment
 307 \i money.credit_card_payment.sql
 308
 309 \echo loading money.debit_card_payment
 310 \i money.debit_card_payment.sql
 311
 312 \echo loading money.forgive_payment
 313 \i money.forgive_payment.sql
 314
 315 \echo loading money.goods_payment
 316 \i money.goods_payment.sql
 317
 318 \echo loading money.work_payment
 319 \i money.work_payment.sql
 320
 321 \echo loading permission.grp_penalty_threshold
 322 \i permission.grp_penalty_threshold.sql
 323
 324 \echo loading permission.grp_tree
 325 \i permission.grp_tree.sql
 326
 327 \echo loading permission.perm_list
 328 \i permission.perm_list.sql
 329
 330 \echo loading permission.usr_work_ou_map
 331 \i permission.usr_work_ou_map.sql
 332
 333 \echo loading serial.basic_summary
 334 \i serial.basic_summary.sql
 335
 336 \echo loading serial.caption_and_pattern
 337 \i serial.caption_and_pattern.sql
 338
 339 \echo loading serial.distribution
 340 \i serial.distribution.sql
 341
 342 \echo loading serial.issuance
 343 \i serial.issuance.sql
 344
 345 \echo loading serial.item
 346 \i serial.item.sql
 347
 348 \echo loading serial.pattern_template
 349 \i serial.pattern_template.sql
 350
 351 \echo loading serial.stream
 352 \i serial.stream.sql
 353
 354 \echo loading serial.subscription
 355 \i serial.subscription.sql
 356
 357 \echo loading serial.unit
 358 \i serial.unit.sql
 359
 360 \echo loading vandelay.authority_queue
 361 \i vandelay.authority_queue.sql
 362
 363 \echo loading vandelay.bib_match
 364 \i vandelay.bib_match.sql
 365
 366 \echo loading vandelay.bib_queue
 367 \i vandelay.bib_queue.sql
 368
 369 \echo loading vandelay.match_set
 370 \i vandelay.match_set.sql
 371
 372 \echo loading vandelay.match_set_point
 373 \i vandelay.match_set_point.sql
 374
 375 \echo loading vandelay.queued_authority_record
 376 \i vandelay.queued_authority_record.sql
 377
 378 \echo loading vandelay.queued_authority_record_attr
 379 \i vandelay.queued_authority_record_attr.sql
 380
 381 \echo loading vandelay.queued_bib_record
 382 \i vandelay.queued_bib_record.sql
 383
 384 \echo loading vandelay.session_tracker
 385 \i vandelay.session_tracker.sql
 386
 387 SELECT SETVAL('money.billable_xact_id_seq', (SELECT MAX(id) FROM money.billing));
 388 SELECT SETVAL('config.remote_account_id_seq', (SELECT MAX(id) FROM config.remote_account));
 389 SELECT SETVAL('money.payment_id_seq', (SELECT MAX(id) FROM money.payment));
 390 SELECT SETVAL('asset.copy_id_seq', (SELECT MAX(id) FROM asset.copy));
 391 SELECT SETVAL('vandelay.queue_id_seq', (SELECT MAX(id) FROM vandelay.queue));
 392 SELECT SETVAL('vandelay.queued_record_id_seq', (SELECT MAX(id) FROM vandelay.queued_record));
 393
 394 COMMIT;