This change corrects the effect of a typo (NULL NULL instead of NOT NULL).
M Open-ILS/src/sql/Pg/200.schema.acq.sql
M Open-ILS/src/sql/Pg/1.6.1-2.0-upgrade-db.sql
A Open-ILS/src/sql/Pg/upgrade/0404.schema.acq-provider-contact-null-null.sql
This needs to be the same in 2.0 as trunk, and the changes to this script need to make it into the 1.6-2.0 upgrade script as well, if not there already
This needs to be the same in 2.0 as trunk, and the changes to this script need to make it into the 1.6-2.0 upgrade script as well, if not there already
Drop the arn_value / arn_source columns on authority.record_entry and create an index instead
The authority record number (ARN) was problematic when trying to generate
local authorities because the number had no correlation to the content of
the authority heading. By creating an index on authority records based on
their heading, thesaurus, and heading text, we can do a better job of
controlling the actual content of the authority records.
In a future release, we may convert this index to a unique index. 2.0
will give sites an opportunity to begin cleaning up their authorities
by identifying duplicate and problematic records through the
authority.normalize_heading(TEXT) database function.
senator [Thu, 16 Sep 2010 02:39:56 +0000 (02:39 +0000)]
Backport IDL-chunking work for interfaces under web/templates, as well as
AutoWidget/AutoFieldWidget improvements to deal with some cases of not having
an IDL class preloaded.
a) Renumber the permissions so that predefined permissions and
non-predefined permissions are in separate ranges. That was
always the intent but the intent has not always been followed.
b) Add permissions that are referenced in the IDL but not
defined in the database.
c) Where the description is NULL, apply the code as a description;
that's better than nothing.
2. Incorporate miscellaneous recent changes from individual upgrade
scripts.
* updated bibliographic tooltips; now current as of LC MARC21 Bibliographic
Update 11, including the RDA tags. Along the way, enhanced the bib tooltips to:
* include definitions for embedded holdings tags (84X, 853-855, 863-868, 876-878)
* expand dropdown for nonfiling indicator values
* added tooltip files for authority records and MFHDs
* taught MARC editor how to choose the correct tooltip file
Caveat: if you localize the authority and MFHD tooltips for a locale other than
en-US, you must edit marcedit.js, either to take your translation into account
or to make it smarter about checking for available translations of the tooltips.
Backport r17644 from trunk: Integrate authority browse and creation support into the MARC editor
This commit changes the contextual authority menu to be based on
the authority browse interface; this should result in better
matching behavior. The browse axis (author, subject, title, topic)
is based on the context tag.
The browse interface has enabled the contextual menu to grow
"Next page" / "Previous page" menu items to enable cataloguers
to wade through long lists of similar authority entries.
The browse interface has also grown a "Create new authority record"
menu with two submenu items:
* "Create immediately" takes the field in context and creates a new authority
record based on that field, with matching indicators and subfields.
* "Create and edit..." displays the MARCXML for the authority record in
a MARC editor window before saving the record to the database.
TODO: Make the "Create..." contextual options add the $0 linking subfield
to the newly controlled field.
TODO: Address some of the flaky UI behaviour, such as having to right-click
three times on an authority-controllable field to display the authority menu.
back-port: 17658 =>additional issuance holds supporting code; in this case, hold_to_mvr func which is used by the uber hold details method; commit also includes a small speed tweak for fetching details for copy holds (1 less cstore call)
Merge r17574, r17575, r17584, r17585, r17628, r17639 from trunk to delete deprecated cgi-bin configuration interfaces
The CGI interfaces have not been maintained; the interfaces available through
the Admin -> Server Administration menu in the staff client are the recommended
method for setting up new libraries in the organizational hierarchy,
permissions, copy statuses, and circulation rules.
Note that an adjustment to eg.conf is recommended to point to the
offline.pl script, which is the only remaining CGI script in use; this
should avoid conflicting Apache definitions for the /cgi-bin/ alias.
Most modern systems will install Class::DBI::Frozen::301 to avoid
conflicts with incompatible Class::DBI packages. We need to teach
offline.pl how to use Class::DBI::Frozen::301 if it is available.
Note that we're using "use parent" instead of "use base" per the
recommendation of "perldoc base"; accordingly, we're adding the
system prerequisite for the parent pragma.
fix retrieval of cat.default_classification_scheme
Fixes bug where the cat.default_classification_scheme OU
setting was effectively ignored in bib call # display
in bib overlay and list of default call numbers during volume
creation.
Backport r17629 and r17630 from trunk: teach fielder to cache (off by default), with a default timeout of 5min; have fielder cache some frequently used data
Backporting r17605 and r17606 from trunk: Method for retrieving received issuances attached to a bib, optionally scoped by location, holding type or item status, with paging and ordering support
Backporting 17856, 17587, 17593, 17601 and 17603 from trunk: mod_deflate support; improved and expanded dojo layers; support for limiting facet retrieval in IE to just the initially displayed set (IE is terrible with large data sets)
back-porting: 17553 17554 => support for viewing and editing existing issuance-level holds to the default opac skin; alternate issuance flesh call that only fleshes the subscription; used for public/opac display
back-port: 17535 => for consistency, use 'issuanceid' as the issuance ID param for holds possibility testing; removed some crusty, old hold create code
Backport 17516, 17517, 17522, 17523: Allows us to create an /openils/var/web/css/skin/default/register_custom.css file containing local CSS for styling the patron editor. Example:
TR[fmfield=ident_type] { display: none; } /* be sure to set the ui.patron.default_ident_type setting */
TR[fmfield=ident_value2] { border: solid thick red; font-size: x-large; }
TR[fmfield=barred] { display: none; }
TR[fmfield=country] { display: none; } /* be sure to set the ui.patron.default_country setting */
TR[fmfield=master_account] { display: none; }
TR[fmfield=alert_message] { display: none; }
TR[fmfield=ident_value] { z-index: -1; }
TR[stat_cat_id='1'] { border: solid thick red; font-size: x-large; }
Backport r17518 from trunk: install Library::CallNumber::LC from CPAN
We briefly had to grab Library::CallNumber::LC from the SVN repo, but
that broke on systems without subversion installed (argh). Thankfully
the maintainer moved Library::CallNumber::LC to CPAN so our job becomes
routine.
back-porting: 17502 17503 => cache the SIP login session to determine 'where' a transaction is occuring in case the caller does not indicate the location; compare hold pickup lib to physical location to determine alert type; small logging and format tweaks
Move some operations out of the transaction so that they can
fail without killing the script. The affected objects do
not necessarily exist -- i.e. the reporter schema, the
extend_reporter schema, and the auditor.action_hold_request_history
table.
1. Inserts and other changes to permission.perm_list and
permission.grp_perm_map. These can't be derived in a simple way from
the individual upgrade scripts, and will have to be hand-crafted to
fit what's already in the seed data.
2. Operations on optional schemas need to be moved out of the
transaction so that the script will work in a database that
doesn't have them.