LP#1527342 Patron checkout history SQL/IDL
[working/Evergreen.git] / Open-ILS / src / sql / Pg / 090.schema.action.sql
2016-02-26 Bill EricksonLP#1527342 Patron checkout history SQL/IDL
2015-06-15 Mike RylanderLP#902255: Protect against hold double-capture
2015-01-12 Bill EricksonLP#1386347 clear maps at fulfillment time
2015-01-12 Mike RylanderLP#1386347: Clear hold-copy-map efficiently
2014-02-28 Mike RylanderLP1272316 - Calculate proximity in the DB for speed
2014-02-21 Bill EricksonLP#1281744 Aged hold purging column repair
2014-01-16 Mike RylanderFix proximity adjustment calculator
2013-08-23 Bill EricksonLP1182519 Per-Hold Behind Desk Value
2013-07-12 Pasi KallinenMove action.hold_request_cancel_cause inserts for i18n
2013-07-11 Bill EricksonNew "patron via SIP" hold cancellation reason
2013-06-07 Thomas BerezanskyReturn count purged
2013-06-07 Thomas BerezanskyPurge Circulations: Allow global age as forced min
2013-06-07 Thomas BerezanskyPurge Circulations: Remove extra delete loop
2013-06-07 Thomas BerezanskyPurge Circulations: Better selection logic
2013-06-07 Thomas BerezanskyPurge Circulations: Support last xact_finished use
2013-06-07 Thomas BerezanskyPurge Circulations: Skip partially complete chains
2013-06-07 Thomas BerezanskyCirc Chain Functions should take BIGINTs
2013-06-07 Jason StephensonAdd table, view and trigger for "aging" hold requests...
2013-06-07 Thomas BerezanskyFix typo in purge holds function
2013-06-07 Thomas BerezanskyMake user visible holds based on fill/cancel time
2013-06-07 Thomas BerezanskyAdd purge_holds DB function
2013-03-14 Mike RylanderObserved speed increases through judicious indexing
2013-02-27 Lebbeous Fogle-WeekleyCustom best-hold selection sort order
2013-02-27 Lebbeous Fogle-WeekleyCalculated Proximity Adjustments, a new feature
2012-12-18 Michael PetersLP#1047475 Set action.hold_request.email_notify to...
2012-05-23 Dan ScottMerge branch 'master' of git.evergreen-ils.org:Evergree...
2012-05-21 Dan ScottMerge branch 'master' of git.evergreen-ils.org:Evergree...
2012-02-08 Galen CharltonLP#928896 improve row estimate for action.usr_visible_c...
2012-01-30 Lebbeous Fogle-WeekleyMerge remote branch 'working/user/dbs/fix-nonfiling...
2012-01-10 Mike RylanderMerge remote-tracking branch 'eg-working/user/senator...
2012-01-10 Jason EtheridgeSMS texting
2012-01-09 Mike RylanderMerge remote-tracking branch 'eg-working/user/berick...
2012-01-05 Thomas BerezanskyCirc Statistical Archiving
2012-01-04 Bill EricksonHold current_shelf_lib DB and IDL
2011-08-05 Bill EricksonMerge branch 'master' of git.evergreen-ils.org:Evergree...
2011-08-05 Bill EricksonMerge branch 'master' of git.evergreen-ils.org:Evergree...
2011-08-04 Bill EricksonRepair holds history func; sort circ history desc.
2011-08-03 Bill EricksonMerge remote branch 'working/user/shadowspar/ttopac...
2011-08-03 Bill EricksonMerge remote branch 'working/user/rri/ttopac' into...
2011-08-03 Bill EricksonRepaired merge conflicts resuling from ttopac-move...
2011-07-24 Mike RylanderMerge branch 'master' of git.evergreen-ils.org:Evergree...
2011-07-18 Lebbeous Fogle-WeekleyMerge remote branch 'working/collab/phasefx/unified_vol...
2011-07-18 Lebbeous Fogle-WeekleyMerge branch 'master' of git://git.evergreen-ils.org...
2011-07-16 Mike RylanderBad join condition in secondary (physical) address...
2011-04-18 Mike RylanderMerge branch 'master' of git+ssh://yeti.esilibrary...
2011-04-18 gmcminor improvements to database object comments
2011-04-12 berickMerge branch 'opac-tt-poc' of git+ssh://yeti.esilibrary...
2011-04-12 Mike RylanderMerge branch 'master' of git+ssh://yeti.esilibrary...
2011-04-12 mikerAdd a trigger function to simulate FKEY constraints...
2011-03-23 senatorMerge branch 'master' of ssh://yeti.esilibrary.com...
2011-03-23 Mike RylanderMerge branch 'opac-tt-poc' of git+ssh://yeti.esilibrary...
2011-03-21 Mike RylanderMerge branch 'master' of git+ssh://yeti.esilibrary...
2011-03-19 mikerIn-database Grace intervals
2011-03-08 berickMerge branch 'master' of git+ssh://yeti.esilibrary...
2011-03-07 mikerWorking towards SVF. This is most of phase 1, which...
2010-10-01 dbsSet due times for durations measured in days to 23...
2010-09-27 scottmk1. Turn some ints into bigints.
2010-09-24 scottmkApply some fixes that were earlier applied to the base...
2010-09-22 scottmkFor action.circulation and action.aged_circulation...
2010-07-23 scottmkAdd procedure action.apply_fieldset.
2010-07-21 scottmkTwo new tables in action schema: fieldset and fieldset_...
2010-07-06 mikeruse SQL function for speed, instead of PLPGSQL
2010-07-06 mikerintegrate serial.unit by relaxing fkeys against asset...
2010-07-06 ericksonadded stored proc to return the distinct set of target...
2010-06-04 dbsImprove circ transaction performance by indexing NULL...
2010-06-01 mikeradd usr_setting_type of history.hold.retention_start...
2010-05-28 ericksonrepaired misnamed function oils_json_to_string -> oils_...
2010-05-27 mikeradding function to return holds visible to the user...
2010-05-27 mikerfunctions and settings for purging circs and user-setta...
2010-05-21 mikerPatch from Jason Stephenson which adds "IF EXISTS"...
2010-03-10 scottmk1. Eliminate somed source_definitions from the IDL...
2009-12-02 ericksonadded stored proc to take a circ and determine the...
2009-11-16 dbsCorrect long-standing, wide-spread "recurance" and...
2009-11-13 phasefxremove the NOT NULL from here to match the upgrade...
2009-11-06 mikerthinko in push-due_date trigger function
2009-11-05 mikerforward-porting r14786 and r14787: use a trigger to...
2009-11-03 scottmkAdd column shelf_expire_time to action.hold_request.
2009-11-03 scottmkAdd column prev_dest to action.transit_copy and
2009-11-02 scottmkChange default of mint_condition to true
2009-11-02 scottmkAdd mint_condition column to asset.copy, auditor.asset_...
2009-10-21 ericksoninstead of manually updating the claims-never-checked...
2009-10-21 scottmk1. Add column to actor.usr: claims_never_checked_out_count.
2009-10-20 mikerAdding support for pushing to the front of the hold...
2009-09-26 mikerFix targetting trac ticket #70 -- populate the xact_typ...
2009-09-24 scottmkModify a pre-delete trigger, and add a post-delete...
2009-09-22 scottmk1. Add new column parent_circ to action.circulation...
2009-09-18 scottmkAdd new column checkin_scan_time to action.circulation,
2009-09-15 mikermoving the the upgrade SQL scripts to an unversioned...
2009-09-15 scottmkAdd checkin_workstation column to action.circulation.
2009-08-20 scottmkAnother typo [sigh...]
2009-08-20 scottmkCorrecting a typo...
2009-08-20 scottmkNew column: action.hold_request.shelf_time
2009-07-21 scottmkOops -- correcting carelessness of previous change
2009-07-21 scottmkAdding a column "workstation" to action.circulation
2009-07-16 scottmkCreate a bunch of new indexes so that the new actor...
2009-07-13 ericksonadded 'staff' column to indicate a staff-created hold...
2009-07-08 scottmkAdd an ON DELETE CASCADE clause to the foreign key...
2009-06-23 mikermoving the record-merge stored proc to the end of the...
2009-06-18 scottmkAdd table action.hold_request_note, class "ahrn"
2009-06-11 mikerjoins in the all_circulations reporting view were ...
next