bea3fb53a4d8ce393b0856af42325de6de5dfdb2
[working/Evergreen.git] / Open-ILS / src / sql / Pg / upgrade / XXXX.schema.lp1737016_afs_code.sql
1 BEGIN;
2
3 SELECT evergreen.upgrade_deps_block_check('XXXX', :eg_version);
4
5 ALTER TABLE acq.funding_source DROP CONSTRAINT funding_source_code_key;
6 ALTER TABLE acq.funding_source ALTER COLUMN code SET NOT NULL;
7 ALTER TABLE acq.funding_source ADD CONSTRAINT funding_source_code_once_per_owner UNIQUE (code,owner);
8
9 COMMIT;