]> git.evergreen-ils.org Git - Evergreen.git/history - Open-ILS/src/sql/Pg/200.schema.acq.sql
LP1615805 No inputs after submit in patron search (AngularJS)
[Evergreen.git] / Open-ILS / src / sql / Pg / 200.schema.acq.sql
2023-11-10 Bill EricksonLP1930753 ACQ provider buyer san override option
2022-10-27 Bill EricksonLP1952931 Support ACQ Advanced Shipment Notices (DESADV...
2021-09-21 Tiffany LittleLP#1737019 Add an active flag to funding sources
2021-08-12 Galen CharltonLP#1904244: schema: add two indexes
2021-08-12 Galen CharltonLP#1904244: schema: make fund.code NOT NULL
2021-08-12 Galen CharltonLP#1904244: change automatically-generated fund allocat...
2020-09-10 Galen CharltonLP#1857150: various schema and IDL changes
2020-09-03 Galen CharltonLP#1850547: add views for PO and LI state labels
2018-09-05 Bill EricksonLP#1635354 Invoice close date/by fields
2018-09-05 Jason Etheridgelp1774277 Improvements to Patron Acquisition Request
2018-07-11 Jason StephensonLP 1478712: Fix acq.fund_rollover_funds_by_org_tree...
2018-02-27 Jason BoyerLP1737016: Ease Constraints on afs.code
2017-09-01 Bill EricksonLP#1373690 EDI 'use_attrs' configuration option
2017-09-01 Bill EricksonLP#1373690 Attribute-based EDI generator
2017-05-17 Galen CharltonLP#1673799: new acqedim index to speed up duplicate...
2016-02-18 Bill EricksonLP#1380709 acq.lineitem_detail.fund_debit INDEX
2016-02-18 Bill EricksonLP#1380709 fund_debit.invoice_entry INDEX
2016-02-18 Bill EricksonLP#1380709 Fund debit links to invoice entry
2015-11-13 Chris SharpLP#1513554 - Prevent deletion of reserved rows.
2015-08-19 Bill EricksonLP#1440114 Direct charge blanket orders
2015-08-19 Dan PearlLP#1204671 Allow fund tags to remain attached to new...
2015-08-06 Jason StephensonLP#1479953: Rename indexes to *_idx and add pgTAP test.
2015-08-06 Jeff DavisLP#1479953: Add indexes to vqbr foreign key references
2014-08-25 Bill EricksonLP#800478 repair logic error in acq fund transfer
2014-08-07 Bill EricksonLP#1270289 Split canceled into delayed vs canceled
2013-08-20 Dan WellsMove exchange_rate seed data to 950 file
2013-08-20 Pasi KallinenMove acq.currency_code entries and wrap for i18n
2013-07-12 Pasi KallinenMove acq.user_request_type data for i18n picking
2013-03-14 Mike RylanderObserved speed increases through judicious indexing
2013-03-13 Bill EricksonDistribution formula fund rollover setting
2013-03-13 Lebbeous Fogle-WeekleyAcq: Line item batch update API method
2013-03-13 Bill EricksonACQ lineitem order identifier SQL/IDL
2013-03-13 Bill EricksonExtract multiple like values from lineitem
2013-03-11 Bill EricksonDefault number of ACQ copies per provider
2012-08-01 Bill EricksonACQ lineitem summary moved to real DB view
2012-07-31 Lebbeous Fogle-WeekleyFinishing off rollover-without-money feature
2012-07-31 Mike RylanderAllow propagation of encumbrances without funds
2012-07-24 Bill EricksonAdd constraint to ACQ PO state value
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-03-23 Lebbeous Fogle-WeekleyAcq: improve General Search's ability to find invoices
2012-03-19 Mike RylanderVandelay-based record matching and import for Acquisitions
2012-03-13 Bill EricksonACQ+Vandelay schema and IDL changes w/ upgrade script
2011-09-22 Bill EricksonStamped upgrade script for ACQ fund view repairs
2011-09-22 James FournieAddresses LP#800477 where some acq views calculate...
2011-08-29 Bill EricksonMerge branch 'master' of git.evergreen-ils.org:Evergree...
2011-08-29 Bill EricksonMerge branch 'template-toolkit-opac' of git.evergreen...
2011-08-25 Bill EricksonMerge branch 'master' of git.evergreen-ils.org:Evergree...
2011-08-25 Bill EricksonColumn to track ACQ copy (lineitem_detail) receiver
2011-04-18 Mike RylanderMerge branch 'master' of git+ssh://yeti.esilibrary...
2011-04-18 gmcminor improvements to database object comments
2011-04-15 Mike RylanderMerge branch 'opac-tt-poc' of git+ssh://yeti.esilibrary...
2011-04-15 Mike RylanderMerge branch 'master' of git+ssh://yeti.esilibrary...
2011-04-14 ericksonrely on search_path to locate the extract_marc_field...
2010-11-02 gmcadd definition for UPC line item attribute
2010-11-02 gmcdon't break up title and author when ingesting acquisit...
2010-11-01 gmclet libraries allow funds to be overcommitted
2010-09-27 scottmk1. Turn some ints into bigints.
2010-09-22 scottmkIn acq.fund_transfer: drop the NOT NULL constraint...
2010-09-16 scottmkMake acq.provider_contact.name NOT NULL.
2010-08-16 atz0372 - acq.edi_message.vendacct
2010-08-04 mikerallow ACQ-driven ordering and claiming of serial items
2010-08-03 dbsCorrect DDL for creating a fresh schema - match upgrade...
2010-08-02 mikercreate correct primary key constraints for some view...
2010-07-06 mikerintegrate serial.unit by relaxing fkeys against asset...
2010-05-26 mikerafter nearly 280 schema updates, we had a little drift...
2010-05-21 mikerPatch from Jason Stephenson which adds "IF EXISTS"...
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-13 phasefxfix syntax
2010-05-12 scottmkAdd purchase_order column to acq.edi_message.
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-16 ericksonadded column to indicate that an invoice is complete...
2010-04-09 senatorAcq: Improved invoice-linking and -viewing features...
2010-04-08 scottmkAdding amount_paid columns to acq.invoice_item, acq...
2010-04-08 scottmkAdd three columns to acq.invoice, plus a
2010-04-07 scottmkAdd fund column to acq.invoice_item.
2010-04-07 scottmkAdd boolean column "prorate" to acq.invoice_item_type.
2010-03-29 phasefxreorder these so that they work
2010-03-29 scottmkWhen propagating funds: propagate the balance_warning_p...
2010-03-25 mikercapture multiple values (on pg 8.4) of an attr def
2010-03-25 scottmkReplace acq.lineitem.claim_interval and acq.provider...
2010-03-25 scottmkCreate two tables in acq schema: claim_policy and claim...
2010-03-17 mikersyntax error in fkey cascade
2010-03-17 scottmkAdd four tables in acq schema: claim, claim_type, claim...
2010-03-11 scottmkAdd boolean column prepayment_required to acq.purchase_...
2010-03-11 scottmkAdded boolean column vendor_public to acq.lineitem_note...
2010-03-10 scottmkAdd "ON DELETE CASCADE" clauses to foreign keys pointing to
2010-03-09 scottmk1. Add estimated_unit_price column to acq.lineitem.
2010-03-08 scottmkAdd a cancel_reason column to acq.user_request, pointin...
2010-03-04 scottmkAdd a cancel_reason column to acq.lineitem_detail,...
2010-03-04 scottmkCreate new table acq.cancel_reason.
2010-03-04 scottmkAdd two columns, both intervals, both nullable:
2010-02-25 scottmkAdded five new views to the acq schema:
2010-02-24 scottmkCreated a new table acq.provider_note, similar to acq...
2010-02-24 scottmkAdd fax number, phone, url, email to certain provider...
2010-02-17 scottmkAdd a boolean column prepayment_required to acq.provider.
2010-02-16 mikerthese have been moved to the seed-data file
next