Qstore: support LIMIT and OFFSET clauses.
[working/Evergreen.git] / Open-ILS / src / sql / Pg / 002.schema.config.sql
2010-07-13 scottmkQstore: support LIMIT and OFFSET clauses.
2010-07-13 dbsMake maintain_901() more robust in the presence of...
2010-07-13 scottmkAdd limit_count and offset_count columns to query.store...
2010-07-12 gmcprotect against deletion of serial.unit rows
2010-07-12 gmccache OPAC-visibility of copies and bibs
2010-07-12 dbsSeveral fixes for authority-controlled field and contro...
2010-07-11 mikerbreak facets out to a separate table for speed
2010-07-09 dbsNew feature: maintain control numbers (001, 003, 035...
2010-07-08 phasefxadding a cc_name field to money.credit_card_payment...
2010-07-06 ericksonadded opac user setting for default sort order for...
2010-07-06 phasefxaugment these payment receipt templates with more info
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-29 senatorBooking: bit-by-bit forward-port; see commit msg for...
2010-06-28 scottmkRepresent a subfield expression as a variant of a funct...
2010-06-28 mikeradd missed stored proc to base schema; adjust said...
2010-06-28 mikerforcibly maintain an appropriate 901 field in all MARC...
2010-06-25 mikeradd stored procs to implement authority propagation...
2010-06-25 mikeradd bib-authority linking table; add stored proc to...
2010-06-25 mikerwe will use a real mapping table instead
2010-06-25 mikervandelay.add_field bug fix; add stored procs to 1)...
2010-06-24 mikeradd agency-stripping and btrim normalizers; add identif...
2010-06-24 atz0314 Baseline data
2010-06-18 mikeradd serial.subscription.owning_lib
2010-06-18 atz0312 - JEDI template support for multiple ISBNs
2010-06-18 scottmkDefine some stock datatypes in query.datatype.
2010-06-17 mikerprotecting facet_xpath from returning empty nodesets
2010-06-15 mikersupport pre-indexing normalizers for facet value normal...
2010-06-11 mikermissed a constraint change in the 0307 upgrade script
2010-06-11 atz0306: Update JEDI template, edi_pusher logic tweaked
2010-06-11 phasefxOrg unit setting and behavior for blocking hold request...
2010-06-11 scottmkAdd column "left_operand" to query.expr_xcase view.
2010-06-10 phasefxseed the UPDATE_PICKUP_LIB_FROM_TRANSIT perm
2010-06-10 mikerTrunk port of a patch from James Fournie of SITKA:
2010-06-10 gmcdrop copy transparency tables
2010-06-08 mikerSplit the ingest trigger logic into bits, simplifying...
2010-06-08 mikerPatch from Galen Charlton:
2010-06-07 scottmkAdd the left_operand column to the query.expr_xbet...
2010-06-07 scottmk1. Add table: serial.caption_and_pattern
2010-06-07 mikerPatch from Galen Charlton:
2010-06-07 ericksonPatch from Galen Charlton: The attached patch adds...
2010-06-04 phasefxEmail/print methods for printing A/T templated bib...
2010-06-04 scottmkAdd two little utility functions to convert from interv...
2010-06-04 dbsImprove circ transaction performance by indexing NULL...
2010-06-04 dbsImprove database performance for partial indexes on...
2010-06-03 phasefxorg unit setting for requiring a matching email for...
2010-06-03 phasefxtemplates and methods for generating payment receipts
2010-06-02 scottmkReplace most of the serial schema with a different...
2010-06-01 mikeradd usr_setting_type of history.hold.retention_start...
2010-05-30 scottmkFor various updatable views based on query.expression:
2010-05-28 phasefxtemplates and methods for print/email of historical...
2010-05-28 scottmkAdded org_unit_setting_type auth.persistent_login_interval
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-27 scottmkAdd new expression type 'xser' to represent series...
2010-05-26 senatorFoundations of Action/Triger-based telephony,
2010-05-26 scottmkCorrecting some diverging drift in the usr_merge function
2010-05-26 mikerafter nearly 280 schema updates, we had a little drift...
2010-05-26 dbsAdd actor.usr_password_reset table required for passwor...
2010-05-24 mikeradd settings group table, shared between org and usr...
2010-05-24 scottmkSplit old org unit setting type circ.hold_estimate_wait...
2010-05-21 mikerPatch from Jason Stephenson which adds "IF EXISTS"...
2010-05-21 scottmkAdd column avg_wait_time to config.circ_modifier.
2010-05-21 mikeradd identifier FTS config (assumed to exist in some...
2010-05-21 mikeruse proper JSON, re ' vs "
2010-05-21 scottmkFixing a typo in the previous changeset (a missing...
2010-05-20 scottmkCreate database support for IS [NOT] NULL expressions
2010-05-19 mikermake the first_word index normalizer return a not-null...
2010-05-19 mikeradd ISBN 10/13 index normalizer (requires ISN postgres...
2010-05-18 scottmkFix a typo in a previous commit to the acq schema....
2010-05-17 scottmkTwo changes to acq.edi_message:
2010-05-16 mikerallow multiple 260 tags in summary view
2010-05-13 ericksonuse estimed_unit_price directly on the lineitem in...
2010-05-13 mikerteach the overlay functions about data matching REs...
2010-05-13 ericksonmoved to generic acqpo.activate hook instead of the...
2010-05-12 scottmkAdd purchase_order column to acq.edi_message.
2010-05-12 ericksonPatch from Galen Charlton: This resolves a performance...
2010-05-11 scottmkAdd "label" column to query.bind_variable
2010-05-10 scottmkDefine an updatable view query.expr_xbind as those...
2010-05-10 scottmkAdd to query.expression: foreign key bind_variable...
2010-05-10 scottmkAdd table query.bind_variable.
2010-05-08 scottmkRevise the updatable views for the various types of...
2010-05-06 scottmk1. Add a boolean "negate" column to query.expression.
2010-05-05 mikersupport 905u (editor by barcode or usrname) in vandelay...
2010-05-01 phasefxOrg unit settings gui.disable_local_save_columns and...
2010-04-30 ericksonAdded global_flag and support for using the internal...
2010-04-30 ericksonrepaired syntax error in db schema / upgrade script
2010-04-30 mikeradd table and IDL class for global flags/settings....
2010-04-29 phasefxorg unit setting for "Delete bib if all copies are...
2010-04-29 ericksonSubsequent EDI patch from Joe Atzberger. In this insta...
2010-04-28 scottmkAdd po_item column to auditor.acq_invoice_item_history.
2010-04-28 scottmkAdd a po_item column, pointing to acq.po_item, to acq...
2010-04-28 scottmkAdd keep_debits column to acq.cancel_reason.
2010-04-27 scottmkAdd acq.po_item table.
2010-04-26 senatorAcq: invoices are now printable from search results
2010-04-26 phasefxorg unit settings for formatting displayed date and...
2010-04-20 senatorAcq: large parts of the UI for making claims to a vendo...
2010-04-19 dbsForward-port self-serve password reset implementation...
2010-04-16 ericksonand then the auditor tables..
next