git.evergreen-ils.org Git - Evergreen.git/history - Open-ILS/src/sql/Pg/200.schema.acq.sql

]> git.evergreen-ils.org Git - Evergreen.git/history - Open-ILS/src/sql/Pg/200.schema.acq.sql

[Evergreen.git] / Open-ILS / src / sql / Pg / 200.schema.acq.sql

2010-07-06	miker	integrate serial.unit by relaxing fkeys against asset...	blob \| commitdiff \| raw
2010-05-26	miker	after nearly 280 schema updates, we had a little drift...	blob \| commitdiff \| raw \| diff to current
2010-05-21	miker	Patch from Jason Stephenson which adds "IF EXISTS"...	blob \| commitdiff \| raw \| diff to current
2010-05-18	scottmk	Fix a typo in a previous commit to the acq schema....	blob \| commitdiff \| raw \| diff to current
2010-05-17	scottmk	Two changes to acq.edi_message:	blob \| commitdiff \| raw \| diff to current
2010-05-13	phasefx	fix syntax	blob \| commitdiff \| raw \| diff to current
2010-05-12	scottmk	Add purchase_order column to acq.edi_message.	blob \| commitdiff \| raw \| diff to current
2010-04-28	scottmk	Add a po_item column, pointing to acq.po_item, to acq...	blob \| commitdiff \| raw \| diff to current
2010-04-28	scottmk	Add keep_debits column to acq.cancel_reason.	blob \| commitdiff \| raw \| diff to current
2010-04-27	scottmk	Add acq.po_item table.	blob \| commitdiff \| raw \| diff to current
2010-04-16	erickson	added column to indicate that an invoice is complete...	blob \| commitdiff \| raw \| diff to current
2010-04-09	senator	Acq: Improved invoice-linking and -viewing features...	blob \| commitdiff \| raw \| diff to current
2010-04-08	scottmk	Adding amount_paid columns to acq.invoice_item, acq...	blob \| commitdiff \| raw \| diff to current
2010-04-08	scottmk	Add three columns to acq.invoice, plus a	blob \| commitdiff \| raw \| diff to current
2010-04-07	scottmk	Add fund column to acq.invoice_item.	blob \| commitdiff \| raw \| diff to current
2010-04-07	scottmk	Add boolean column "prorate" to acq.invoice_item_type.	blob \| commitdiff \| raw \| diff to current
2010-03-29	phasefx	reorder these so that they work	blob \| commitdiff \| raw \| diff to current
2010-03-29	scottmk	When propagating funds: propagate the balance_warning_p...	blob \| commitdiff \| raw \| diff to current
2010-03-25	miker	capture multiple values (on pg 8.4) of an attr def	blob \| commitdiff \| raw \| diff to current
2010-03-25	scottmk	Replace acq.lineitem.claim_interval and acq.provider...	blob \| commitdiff \| raw \| diff to current
2010-03-25	scottmk	Create two tables in acq schema: claim_policy and claim...	blob \| commitdiff \| raw \| diff to current
2010-03-17	miker	syntax error in fkey cascade	blob \| commitdiff \| raw \| diff to current
2010-03-17	scottmk	Add four tables in acq schema: claim, claim_type, claim...	blob \| commitdiff \| raw \| diff to current
2010-03-11	scottmk	Add boolean column prepayment_required to acq.purchase_...	blob \| commitdiff \| raw \| diff to current
2010-03-11	scottmk	Added boolean column vendor_public to acq.lineitem_note...	blob \| commitdiff \| raw \| diff to current
2010-03-10	scottmk	Add "ON DELETE CASCADE" clauses to foreign keys pointing to	blob \| commitdiff \| raw \| diff to current
2010-03-09	scottmk	1. Add estimated_unit_price column to acq.lineitem.	blob \| commitdiff \| raw \| diff to current
2010-03-08	scottmk	Add a cancel_reason column to acq.user_request, pointin...	blob \| commitdiff \| raw \| diff to current
2010-03-04	scottmk	Add a cancel_reason column to acq.lineitem_detail,...	blob \| commitdiff \| raw \| diff to current
2010-03-04	scottmk	Create new table acq.cancel_reason.	blob \| commitdiff \| raw \| diff to current
2010-03-04	scottmk	Add two columns, both intervals, both nullable:	blob \| commitdiff \| raw \| diff to current
2010-02-25	scottmk	Added five new views to the acq schema:	blob \| commitdiff \| raw \| diff to current
2010-02-24	scottmk	Created a new table acq.provider_note, similar to acq...	blob \| commitdiff \| raw \| diff to current
2010-02-24	scottmk	Add fax number, phone, url, email to certain provider...	blob \| commitdiff \| raw \| diff to current
2010-02-17	scottmk	Add a boolean column prepayment_required to acq.provider.	blob \| commitdiff \| raw \| diff to current
2010-02-16	miker	these have been moved to the seed-data file	blob \| commitdiff \| raw \| diff to current
2010-02-16	miker	initial invoicing schema	blob \| commitdiff \| raw \| diff to current
2010-02-15	phasefx	missing underscore in column name	blob \| commitdiff \| raw \| diff to current
2010-02-15	scottmk	In acq.lineitem_alert_text: add owning_lib column....	blob \| commitdiff \| raw \| diff to current
2010-02-12	scottmk	1. New table, acq.lineitem_alert_text.	blob \| commitdiff \| raw \| diff to current
2010-02-10	miker	backend to support collection of patron purchase reques...	blob \| commitdiff \| raw \| diff to current
2010-02-09	erickson	lineitem item_count was changed to a virtual field...	blob \| commitdiff \| raw \| diff to current
2010-02-09	senator	Record applications of distribution formulas to lineite...	blob \| commitdiff \| raw \| diff to current
2010-02-08	scottmk	Add "active" column to acq.provider; bool not null...	blob \| commitdiff \| raw \| diff to current
2010-02-05	scottmk	New columns to acq.fund: balance_wqarning_percent and...	blob \| commitdiff \| raw \| diff to current
2010-02-05	scottmk	1. Add two new columns to actor.org_unit: spend_warning...	blob \| commitdiff \| raw \| diff to current
2010-02-04	scottmk	Add a function acq.attribute_debits() to attribute...	blob \| commitdiff \| raw \| diff to current
2010-02-03	scottmk	1. Back off the function acq.attribute_debits, along...	blob \| commitdiff \| raw \| diff to current
2010-02-02	scottmk	Add a function acq.transfer_fund to transfer money...	blob \| commitdiff \| raw \| diff to current
2010-02-02	scottmk	Add the acq.fund_allocation_percent table.	blob \| commitdiff \| raw \| diff to current
2010-02-02	scottmk	Add active flag to acq.fund table. If a fund is not...	blob \| commitdiff \| raw \| diff to current
2010-01-29	miker	this papers over the transitional differences in XML...	blob \| commitdiff \| raw \| diff to current
2010-01-29	scottmk	Add machinery for attributing debits to funding source...	blob \| commitdiff \| raw \| diff to current
2010-01-28	scottmk	Oops: need to coalesce before summing, not after.	blob \| commitdiff \| raw \| diff to current
2010-01-27	scottmk	Redefine the view acq.fund_debit_total:	blob \| commitdiff \| raw \| diff to current
2010-01-15	erickson	Patch from Joe Atzberger, with some IDL additions,...	blob \| commitdiff \| raw \| diff to current
2010-01-11	scottmk	Add a boolean "propagate" column to acq.fund, to denote...	blob \| commitdiff \| raw \| diff to current
2010-01-04	scottmk	Add a new column funding_source_credit to the acq.fund_...	blob \| commitdiff \| raw \| diff to current
2009-12-28	scottmk	Add new view acq.ordered_funding_source_credit, to...	blob \| commitdiff \| raw \| diff to current
2009-12-28	scottmk	Add an effective_date column to acq.funding_source_credit.	blob \| commitdiff \| raw \| diff to current
2009-12-23	scottmk	Add a boolean "rollover" column to acq.fund, to denote	blob \| commitdiff \| raw \| diff to current
2009-12-21	scottmk	Add new table acq.fund_transfer	blob \| commitdiff \| raw \| diff to current
2009-12-16	scottmk	Add a deadline_date column to acq.funding_source_credit	blob \| commitdiff \| raw \| diff to current
2009-12-15	scottmk	1. Create a default entry in acq.fiscal_calendar.	blob \| commitdiff \| raw \| diff to current
2009-11-02	erickson	removed reference to 'percent' on fund allocation....	blob \| commitdiff \| raw \| diff to current
2009-10-30	erickson	Patch from J. Atzberger to change SAN datatype to TEXT	blob \| commitdiff \| raw \| diff to current
2009-10-29	scottmk	Remove the percent column from acq.fund_allocation...	blob \| commitdiff \| raw \| diff to current
2009-10-28	erickson	patch from Joe Atzberger to add a SAN (Standard Address...	blob \| commitdiff \| raw \| diff to current
2009-08-27	scottmk	Create tables acq.fiscal_calendar and acq.fiscal_year.	blob \| commitdiff \| raw \| diff to current
2009-08-24	scottmk	Change constraint on acq.provider. Instead of making...	blob \| commitdiff \| raw \| diff to current
2009-08-24	scottmk	Add columns to acq.purchase_order: order_date and name.	blob \| commitdiff \| raw \| diff to current
2009-08-21	scottmk	Change uniqueness constraint on acq.fund.code so as to	blob \| commitdiff \| raw \| diff to current
2009-07-16	scottmk	Create a bunch of new indexes so that the new actor...	blob \| commitdiff \| raw \| diff to current
2009-06-15	dbs	The ever-popular/feared typo: Lanuage -> Language	blob \| commitdiff \| raw \| diff to current
2009-05-05	erickson	adding collection_code field to lineitem_detail.	blob \| commitdiff \| raw \| diff to current
2009-04-30	erickson	we need a local attr def for price out of the box	blob \| commitdiff \| raw \| diff to current
2009-04-21	scottmk	Added create_time columns to acq.fund_debit and acq...	blob \| commitdiff \| raw \| diff to current
2009-04-17	scottmk	Add CREATE TABLE statements, and the associated IDL...	blob \| commitdiff \| raw \| diff to current
2009-04-08	miker	adding note and circ_modifier to acq.lineitem_detail...	blob \| commitdiff \| raw \| diff to current
2009-04-07	miker	teach acq to extract holding-related data from a named...	blob \| commitdiff \| raw \| diff to current
2009-03-20	scottmk	Add ON DELETE CASCADE to distribution_formula_entry...	blob \| commitdiff \| raw \| diff to current
2009-03-20	scottmk	Create two new tables: acq.distribution_formula	blob \| commitdiff \| raw \| diff to current
2009-03-16	miker	provide for a editing audit trail on picklists, POs...	blob \| commitdiff \| raw \| diff to current
2009-02-08	erickson	more provider data. address, contact, and contact...	blob \| commitdiff \| raw \| diff to current
2009-02-07	dbs	Make all FKs deferrable again	blob \| commitdiff \| raw \| diff to current
2008-10-20	erickson	Merging acq-experiment to trunk, since rel_1_4 has...	blob \| commitdiff \| raw \| diff to current

Evergreen ILS

RSS Atom