lp#825303: fix cat.default_classification_scheme lookup
[Evergreen.git] / Open-ILS / src / sql / Pg / 040.schema.asset.sql
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-06 Dan ScottMerge branch 'master' of git.evergreen-ils.org:Evergree...
2011-06-03 Thomas BerezanskySip Statcats - Actor/Asset Statcats via SIP2
2011-05-25 Dan ScottMerge branch 'master' of git.evergreen-ils.org:working...
2011-05-25 Dan ScottMerge branch 'master' of git.evergreen-ils.org:Evergree...
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
2006-03-17 mikeradding "deleted" functionality to CNs
2006-03-17 mikeradding delete protection to copy and bib records
2006-03-17 mikermaking copies psuedo-deletable
2006-03-06 mikeradding pub field to notes tables
2006-01-20 mikercirc corner case support; container "public" flag
2005-12-31 mikersped up page_down by about 20%
2005-12-01 mikertime series reporting and links for said on the wide...
2005-11-17 mikerreporter stuff
2005-11-01 mikeradding function to public schema instead of non-existan...
2005-09-12 mikermisc cleanup
2005-07-26 mikerschema tweaks
2005-07-24 mikermoving sql files to dir matching the Open-ILS driver...