Add fund column to acq.invoice_item.
[working/Evergreen.git] / Open-ILS / src / sql / Pg / 200.schema.acq.sql
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
2010-02-16 mikerinitial invoicing schema
2010-02-15 phasefxmissing underscore in column name
2010-02-15 scottmkIn acq.lineitem_alert_text: add owning_lib column....
2010-02-12 scottmk1. New table, acq.lineitem_alert_text.
2010-02-10 mikerbackend to support collection of patron purchase reques...
2010-02-09 ericksonlineitem item_count was changed to a virtual field...
2010-02-09 senatorRecord applications of distribution formulas to lineite...
2010-02-08 scottmkAdd "active" column to acq.provider; bool not null...
2010-02-05 scottmkNew columns to acq.fund: balance_wqarning_percent and...
2010-02-05 scottmk1. Add two new columns to actor.org_unit: spend_warning...
2010-02-04 scottmkAdd a function acq.attribute_debits() to attribute...
2010-02-03 scottmk1. Back off the function acq.attribute_debits, along...
2010-02-02 scottmkAdd a function acq.transfer_fund to transfer money...
2010-02-02 scottmkAdd the acq.fund_allocation_percent table.
2010-02-02 scottmkAdd active flag to acq.fund table. If a fund is not...
2010-01-29 mikerthis papers over the transitional differences in XML...
2010-01-29 scottmkAdd machinery for attributing debits to funding source...
2010-01-28 scottmkOops: need to coalesce before summing, not after.
2010-01-27 scottmkRedefine the view acq.fund_debit_total:
2010-01-15 ericksonPatch from Joe Atzberger, with some IDL additions,...
2010-01-11 scottmkAdd a boolean "propagate" column to acq.fund, to denote...
2010-01-04 scottmkAdd a new column funding_source_credit to the acq.fund_...
2009-12-28 scottmkAdd new view acq.ordered_funding_source_credit, to...
2009-12-28 scottmkAdd an effective_date column to acq.funding_source_credit.
2009-12-23 scottmkAdd a boolean "rollover" column to acq.fund, to denote
2009-12-21 scottmkAdd new table acq.fund_transfer
2009-12-16 scottmkAdd a deadline_date column to acq.funding_source_credit
2009-12-15 scottmk1. Create a default entry in acq.fiscal_calendar.
2009-11-02 ericksonremoved reference to 'percent' on fund allocation....
2009-10-30 ericksonPatch from J. Atzberger to change SAN datatype to TEXT
2009-10-29 scottmkRemove the percent column from acq.fund_allocation...
2009-10-28 ericksonpatch from Joe Atzberger to add a SAN (Standard Address...
2009-08-27 scottmkCreate tables acq.fiscal_calendar and acq.fiscal_year.
2009-08-24 scottmkChange constraint on acq.provider. Instead of making...
2009-08-24 scottmkAdd columns to acq.purchase_order: order_date and name.
2009-08-21 scottmkChange uniqueness constraint on acq.fund.code so as to
2009-07-16 scottmkCreate a bunch of new indexes so that the new actor...
2009-06-15 dbsThe ever-popular/feared typo: Lanuage -> Language
2009-05-05 ericksonadding collection_code field to lineitem_detail.
2009-04-30 ericksonwe need a local attr def for price out of the box
2009-04-21 scottmkAdded create_time columns to acq.fund_debit and acq...
2009-04-17 scottmkAdd CREATE TABLE statements, and the associated IDL...
2009-04-08 mikeradding note and circ_modifier to acq.lineitem_detail...
2009-04-07 mikerteach acq to extract holding-related data from a named...
2009-03-20 scottmkAdd ON DELETE CASCADE to distribution_formula_entry...
2009-03-20 scottmkCreate two new tables: acq.distribution_formula
2009-03-16 mikerprovide for a editing audit trail on picklists, POs...
2009-02-08 ericksonmore provider data. address, contact, and contact...
2009-02-07 dbsMake all FKs deferrable again
2008-10-20 ericksonMerging acq-experiment to trunk, since rel_1_4 has...