]> git.evergreen-ils.org Git - Evergreen.git/commit
LP#1857150: various schema and IDL changes
authorGalen Charlton <gmc@equinoxinitiative.org>
Wed, 2 Sep 2020 16:32:25 +0000 (12:32 -0400)
committerJason Etheridge <jason@EquinoxInitiative.org>
Thu, 10 Sep 2020 20:36:12 +0000 (16:36 -0400)
commit97318d8d6929140c82b8c30453fd88d1cb36b579
treee72af5396ebb820c4832a347fce76198729a70d4
parent3b789b13a73a93f851834617bad6c69bdca6586d
LP#1857150: various schema and IDL changes

* Add a primary_contact column to acq.provider. The primary contact,
  when set, signifies the primary point of contact in case a provider
  has multiple contacts. This is displayed on the summary pane in
  the Angular interface.

* Mark various non-NULL fields as required so that the record editor,
  can require them in turn:

  - acqpro.name
  - acqpro.owner
  - acqpro.currency_type
  - acqpro.code
  - acqpa.city
  - acqpa.country
  - acqpa.post_code
  - acqpa.state
  - acqpa.street1
  - acqpc.provider
  - acqpc.name
  - acqpca.city
  - acqpca.country
  - acqpca.post_code
  - acqpca.state
  - acqpca.street
  - acqlipad.code
  - acqlipad.description
  - acqlipad.xpath
  - acqlipad.provider
  - acqphsm.provider
  - acqphsm.name
  - acqphsm.subfield
  - acqedi.label
  - acqedi.host
  - acqedi.owner
  - acqedi.provider
  - acqedi.use_attrs

* Make acqpro.name not be translatable. This appears to have just
  been a case of copy-and-pastitis, as providers don't seem to
  vary their names by locale.

* Add various virtual fields to support more fleshing:

  - acqpro.contacts
  - acqpro.holdings_subfields
  - acqpro.attributes
  - acqpro.edi_accounts
  - acqpc.addresses

This patch includes contributions by Mike Rylander.

Sponsored-by: Evergreen Community Development Initiative
Signed-off-by: Galen Charlton <gmc@equinoxinitiative.org>
Signed-off-by: Ruth Frasur <rfrasur@library.in.gov>
Signed-off-by: Bill Erickson <berickxx@gmail.com>
Signed-off-by: Jason Etheridge <jason@EquinoxInitiative.org>
Open-ILS/examples/fm_IDL.xml
Open-ILS/src/sql/Pg/200.schema.acq.sql
Open-ILS/src/sql/Pg/800.fkeys.sql
Open-ILS/src/sql/Pg/upgrade/AAAA.schema.provider-primary-contact.sql [new file with mode: 0644]