lp1777675 inventory date support
[evergreen-equinox.git] / Open-ILS / src / sql / Pg / 040.schema.asset.sql
2018-09-04 Kyle Huckinslp1777675 inventory date support
2018-08-15 a. bellenirLP#1587620: inconsistent copy counts between opac and...
2018-08-15 a. bellenirLP#1775216: inconsistent copy counts between opac and...
2018-08-15 a. bellenirLP#1775216: inconsistent availability counts between...
2018-07-12 Jason BoyerLP1773452: Repeating copy alerts
2018-02-28 Galen CharltonLP#1676608: provide DB update script to convert legacy...
2018-02-28 Mike RylanderLP#1676608: copy alert and suppression matrix
2017-09-27 Galen CharltonLP#1719726: ensure asset.copy_tag_copy_map has fake FK
2017-08-28 Mike RylanderLP#1698206: Copy counts generated from new vis cache...
2017-08-28 Mike RylanderLP#1698206: Reify baseline schema
2017-07-24 Galen CharltonLP#1673857: schema, IDL, library settings & perms for...
2017-05-25 Michele MorganLP#1687971 - Make copy locations in the OPAC clickable.
2015-02-21 Jason BoyerLP#121054: Add Deleted Flag to asset.copy_location
2014-12-16 Dan WellsLP#1389403 Add normalizer detection to call number...
2014-11-11 Thomas BerezanskyLP#778989: Add circ lib to location fixer
2014-11-11 Thomas BerezanskyLP#778989: Attempt to find "Correct" copy location
2014-02-21 Mike RylanderLP#1053397: Add optional org filter to "has holdable...
2014-02-21 Mike RylanderLP#1053397 DB for metarecords unapi and holds
2013-09-26 Thomas BerezanskyFloating Groups
2013-08-20 Jason EtheridgeLP#1150939 fix dewey sort
2013-04-01 Mike RylanderRevert "Remove search.query_parser_fts from schema"
2013-03-14 Mike RylanderObserved speed increases through judicious indexing
2013-02-15 Thomas BerezanskyRemove search.query_parser_fts from schema
2012-08-01 Thomas BerezanskyTPac: Hide place hold links when not holdable
2012-03-11 Bill EricksonCopy Location Groups : sort to top option
2012-03-11 Bill EricksonCopy Location Search Groups : DB / IDL
2012-01-20 Thomas BerezanskyAdd Checkin Alert to Copy Locations
2012-01-05 Thomas BerezanskyCirc Statistical Archiving
2011-12-16 James FournieFix Dewey call number sorting
2011-11-04 James FourniePreviously invisible copies showed as beige in the...
2011-08-16 Dan ScottLP#790329 org_lasso search is broken
2011-08-16 Galen Charltonlp#825303: fix cat.default_classification_scheme lookup
2011-08-09 Jason EtheridgeIgn Reshelving->Available for status_changed_time
2011-06-21 Thomas BerezanskyActive date
2011-06-03 Thomas BerezanskySip Statcats - Actor/Asset Statcats via SIP2
2011-05-25 Dan ScottTrivial line-wrapping patch for call number class defaults
2011-05-25 Dan WellsMake label_class on any new call numbers default to...
2011-05-13 gmcfix query in various copy count functions
2011-04-20 mikerReorder some functions to avoid creation failure on...
2011-04-12 mikerAdd support for Multi-Homed Items (aka Foreign Bibs...
2011-04-12 mikerFix functions stranded in the evergreen schema without...
2011-03-29 mikerMonograph Parts; Unified vol/copy wizard; Call Number...
2011-03-17 dbwellsTreat call number fields 090 and 092 as local LC and...
2011-03-16 mikerPatch from Steve Callendar addressing CN sort order...
2011-03-07 mikerWorking towards SVF. This is most of phase 1, which...
2011-02-23 mikerinclude copy/call_number deletedness in staff-version...
2011-02-11 mikerPostgres 9.0 is more strict about variable names in...
2011-01-17 dbwellsAuto-generation of placeholder barcodes
2010-12-15 dbsAddress the call number browsing performance problem...
2010-11-24 dbsAdd an index on asset.copy(create_date) for item-age...
2010-10-21 gmcimprove call number sorting
2010-10-16 mikeruse a function to wrap up escaping of solidus and casti...
2010-10-14 miker"as" not "to" ... you pointed that out the first time...
2010-10-14 mikerbackward compat indexing for label instead of label_sortkey
2010-10-14 mikercast label_sortkey to bytea in order to get ascii-betic...
2010-09-09 mikershould have had this index all along, but was less...
2010-08-27 dbsAdd label_prefix and label_suffix columns to asset...
2010-08-11 mikermissed one fix in previous optimisation effort
2010-08-10 mikerTwo things: 1) match old output, with rows for no holdi...
2010-08-10 mikeraaaaand, another typo of the r17147 ilk
2010-08-09 mikerIn order to speed up the API call where we ask for...
2010-08-09 dbsSQL 101: Remember to name all of the columns before...
2010-08-09 dbsTeach the staff client volume copy creator to respect...
2010-08-07 dbsBasic call-number sorting by classification scheme
2010-08-04 phasefxrequired column for item stat cats
2010-08-04 mikerallow ACQ-driven ordering and claiming of serial items
2010-07-12 gmccache OPAC-visibility of copies and bibs
2010-06-10 gmcdrop copy transparency tables
2010-06-04 dbsImprove database performance for partial indexes on...
2010-06-02 scottmkReplace most of the serial schema with a different...
2010-05-21 mikerPatch from Jason Stephenson which adds "IF EXISTS"...
2010-05-12 ericksonPatch from Galen Charlton: This resolves a performance...
2009-11-26 mikerDB and middle layer implementation of floating items...
2009-11-02 scottmkChange default of mint_condition to true
2009-11-02 scottmkAdd mint_condition column to asset.copy, auditor.asset_...
2009-10-28 scottmkAdd CREATE statement for asset.copy_location_order
2009-10-20 scottmkAdd new status_changed_time to CREATE statement for...
2009-09-15 scottmkAdd dummy_isbn column to asset.copy.
2009-07-16 scottmkCreate a bunch of new indexes so that the new actor...
2009-04-15 mikerteaching record merge function how to copy over 856...
2009-04-09 dbsA long time ago, miker said we could correct typos...
2009-03-03 mikerperl does not appreciate the use of, um, "use" .. chang...
2009-03-02 mikerinitial addition of Conifer-sponsored electronic serial...
2009-02-07 dbsMake all FKs deferrable again
2008-12-01 dbsPrevent locations with the same name being generated...
2008-11-06 mikermoving the asset merge stored proc to a later (dependan...
2008-11-04 mikerupdate record merging stored proc to move holds and...
2008-10-22 mikerfixing logic thinko in new in-db merge function
2008-10-08 mikerallow the database to support a NULL item price
2008-09-30 mikeradding hold verification support per copy_location
2008-06-13 mikeradding copyright statement headers to the schema defini...
2008-05-13 dbsMissed a deferrable constraint
2007-12-04 dbsEnable translation of seed values stored in database.
2007-08-29 mikeradding storage method open-ils.storage.asset.merge_reco...
2006-08-28 mikerrelax unique barcode constraint for deleted items
2006-08-24 mikerimport tweaks
2006-08-02 mikergeneral schema updates
2006-06-23 mikerage protection stuff
2006-05-10 mikerfixing "deleted" constraint on call numbers
2006-03-31 mikernew FM stuff; trimmed search_fts methods
next