1 INSERT INTO config.upgrade_log (version) VALUES ('0052');
3 CREATE TABLE asset.copy_location_order
7 REFERENCES asset.copy_location
9 DEFERRABLE INITIALLY DEFERRED,
11 REFERENCES actor.org_unit
13 DEFERRABLE INITIALLY DEFERRED,
14 position INT NOT NULL DEFAULT 0,
15 CONSTRAINT acplo_once_per_org UNIQUE ( location, org )
18 INSERT INTO permission.perm_list VALUES
19 (350, 'ADMIN_COPY_LOCATION_ORDER', oils_i18n_gettext(350, 'Allow a user to create/view/update/delete a copy location order', 'ppl', 'description'));