Merge branch 'master' of git.esilibrary.com:migration-tools
[migration-tools.git] / sql / base / base.sql
2017-12-15 Rogan HambyMerge branch 'master' of git.esilibrary.com:migration...
2017-12-15 Rogan Hambyadding some basic copy tag and serial tables to the...
2017-12-06 Jason Etheridgeget_marc_leader()
2017-11-29 Rogan Hambyfunction for setting passwords in actor.passwd quickly
2017-11-08 Jason Etheridgeoverzealous heuristic
2017-10-11 Jason Etheridgetoward better name parsing (handles names like "Van...
2017-10-11 Jason Etheridgetoward better name parsing (handles names like "Van...
2017-10-03 Jason Etheridgecomment
2017-10-03 Jason Etheridgepush bib sequence and return starting value for reserve...
2017-09-26 Rogan Hambyadding actor.usr_setting to production tables
2017-09-11 Jason Etheridgemigration_tools.attempt_sierra_timestamp
2017-09-11 Jason Etheridgemore address parsing helpers
2017-04-11 Jason EtheridgeASSERT not supported until PG 9.5
2017-03-30 Jason Etheridgethird variant of migration_tools.assert with success...
2017-03-30 Jason Etheridgeassert tool for use with \set ON_ERROR_STOP on
2017-03-14 Jason Etheridgeuse UNLOGGED tables for the base staging tables
2016-05-27 Jason Etheridgesyntax in INHERIT example
2016-04-11 Jason Etheridgetweaks to name parser
2016-03-11 Jason Etheridgeacq.fund_tag_map
2016-03-11 Jason Etheridgeadd acq.provider_contact and acq.provider_contact_addre...
2016-02-29 Jason Etheridgeadd action.transit_copy and action.hold_transit_copy...
2016-02-29 Jason Etheridgeadd action.hold_request_note to the list of base tables
2016-02-19 Ben Ostrowskymigration_tools.attempt_hz_date
2016-02-19 Jason Etheridgetweak for case when just last name
2016-02-19 Jason Etheridgemigration_tools.name_parse_out_last_first_middle_and_ra...
2016-01-28 Jason Etheridgemigration_tools.find_hold_matrix_matchpoint2
2015-09-24 Jason Etheridgeremove config fig.circ_matrix_circ_mod_test
2015-08-10 Jason Etheridgemore money converters
2015-08-06 Jason Etheridgeduplicate_template_but_change_delay
2015-04-20 Jason Etheridgetweak migration_tools.insert_856_9
2015-03-24 Jason Etheridgehandle dates like 051980
2015-03-18 Jason Etheridgeadd some in-db matchpoint tables, for potential ease...
2015-03-16 Jason Etheridgeconvenience wrappers for finding in-db rules
2015-03-16 Jason Etheridgemake migration_tools.apply_circ_matrix_to_specific_circ...
2015-02-25 Jason Etheridgeadd a delimiter paramater, and a variant that returns...
2015-02-21 Jason Etheridge.get_marc_tag
2015-02-05 Jason EtheridgeMerge branch 'master' of git.esilibrary.com:migration...
2015-02-05 Jason Etheridgemigration_tools.apply_circ_matrix_to_specific_circ
2015-02-03 Jason Etheridgeproc to clone a/t event definitions
2015-01-14 Jason Etheridgelet's strip commas as well with attempt_money
2015-01-14 Jason Etheridgean attempt_money method for a smaller numeric, given...
2015-01-14 Jason Etheridgelet migration_tools.attempt_money strip dollar signs...
2014-11-20 Jason Etheridgeinclude affixes with _callnum_label_once_per_lib index
2014-11-20 Jason Etheridgeadd tables for call number affixes
2014-09-22 Galen Charltonadd routine to calculate Code 39 mod 43 barcode checkdigits
2013-03-08 Galen Charltonwhen parsing state from city, anchor pattern on right
2012-12-26 Galen Charltonrework attempt_cast function
2012-10-19 Galen Charltonimprove marc_parses() test
2012-10-03 Galen Charltonstart work on a function for creating staff users in...
2012-09-10 Galen Charltonnew function to set indicators in MARC fields
2012-08-30 Galen Charltoncreate base staging tables for acquisitions
2012-08-29 Galen Charltontypo fix
2012-08-29 Galen Charltonteach migration_tools.change_call_number() about label...
2012-08-17 Jason Etheridgeswitch from action.find_circ_matrix_matchpoint to actio...
2012-08-17 Galen Charltonnew function - migration_tools.make_stub_bib()
2012-08-08 Galen Charltonadd actor.usr_standing_penalty to default production...
2012-08-07 Galen Charltonfor logging of field-level merges, look for record...
2012-08-06 Galen Charltonsimple function to merge fields from one MARCXML record...
2012-08-06 Galen Charltonanother typo fix
2012-08-06 Galen Charltonadd pgt to config import/export
2012-08-06 Galen Charltonfix typo
2012-08-06 Galen Charltonadd config import/export logic to add new rows for...
2012-08-06 Galen Charltonadd a couple more tables to the config export
2012-08-06 Galen Charltonadd the corresponding simple library config import...
2012-08-06 Galen Charltonadd another table to the configuration export
2012-08-06 Galen Charltonstart working on functions to export and import library...
2012-08-01 Galen Charltonalso set grace period when applying circ policies
2012-07-24 Galen Charltonuse PL/PerlU rather than PL/Perl
2012-07-24 Galen Charltonsimple stored function to check parseability of MARCXML...
2012-07-16 Galen Charltonadd copyright statement and GPL2+ license statement
2012-07-16 Ben OstrowskyThree variations on apply_circ_matrix: _before_20 spell...
2012-07-16 Ben OstrowskyAdded ContentReserve to the list of providers in insert...
2012-07-16 Ben OstrowskyAdded two related functions for updating a copy's ownin...
2012-07-16 Ben OstrowskyAvoid collisions while refreshing OPAC visibility
2012-07-16 Ben OstrowskyReplaced TRUNCATE with DELETE FROM in migration_tools...
2012-07-16 Ben OstrowskyReplaced TRUNCATE with DELETE FROM
2012-07-16 Ben OstrowskyAdded new helper utility: migration_tools.refresh_opac...
2012-07-16 Ben OstrowskyImproved check_ou_type
2012-07-16 Ben OstrowskyAdded new function: check_ou_depth
2012-07-16 Ben Ostrowskyinsert_856_9: more accurate detection of incumbent...
2012-07-16 Ben OstrowskyAdded migration_tools.zip_to_city_state_county
2012-07-16 Ben OstrowskyHandle percents in apply_circ_matrix
2012-07-16 Ben OstrowskyAdded attempt_timestamptz
2012-07-16 Ben OstrowskyMunging ind2 in insert_856_9
2012-07-16 Ben OstrowskyNew function: migration_tools.change_call_number (copy_...
2012-07-16 Ben OstrowskyUpdated field names (recuring->recurring) in one functi...
2012-07-16 Ben OstrowskyRoutine to create cards in a migration schema
2012-07-16 Ben OstrowskyFunction for assigning standing penalties
2012-07-16 Ben OstrowskyAdding metarecord spells as functions for convenience
2012-07-16 Ben Ostrowskymigration_tools.stage_not_applicable_asset_stat_cats
2012-07-16 Ben OstrowskyNew function: apply_circ_matrix('m_foo.action_circulati...
2012-07-16 Ben OstrowskyMore precise deduping for insert_tags
2012-07-16 Ben OstrowskyAdded function: insert_tags (marc, '<datafield tag...
2012-07-16 Ben Ostrowskyattempt_phone can take '' as second argument to refrain...
2012-07-16 Ben OstrowskyNew function: migration_tools.is_staff_profile(actor...
2012-07-16 Ben OstrowskyAdded two MARC-manipulating functions from Galen
2010-04-12 Ben OstrowskyWill leave 'unlisted' alone
2010-04-12 Ben OstrowskyHandling a few more exceptions...
2010-04-12 Ben OstrowskyAdded logic to attempt_phone for handling a few more...
2010-04-12 Ben OstrowskyAdded function attempt_phone (TEXT,TEXT) RETURNS TEXT...
next