Change constraint on acq.provider. Instead of making
authorscottmk <scottmk@dcc99617-32d9-48b4-a31d-7c20da2025e4>
Mon, 24 Aug 2009 17:53:14 +0000 (17:53 +0000)
committerscottmk <scottmk@dcc99617-32d9-48b4-a31d-7c20da2025e4>
Mon, 24 Aug 2009 17:53:14 +0000 (17:53 +0000)
commit6524371487c1dcf7da584741a2029b86c62126c9
tree5e07f99d100ee1e85b95a17d5aa5cef36e330489
parentcadd91dd342a6ed3423fb88cefe41783814ef222
Change constraint on acq.provider.  Instead of making
code unique by itself, make code + owner unique.

For changing an existing table:

ALTER TABLE acq.provider
DROP CONSTRAINT provider_code_key;

ALTER TABLE acq.provider
ALTER COLUMN code SET NOT NULL;

ALTER TABLE acq.provider
ADD CONSTRAINT code_once_per_owner
UNIQUE (code, owner);

git-svn-id: svn://svn.open-ils.org/ILS/branches/rel_1_6@13927 dcc99617-32d9-48b4-a31d-7c20da2025e4
Open-ILS/src/sql/Pg/200.schema.acq.sql