3 SELECT evergreen.upgrade_deps_block_check('0682', :eg_version);
5 CREATE TABLE asset.copy_location_group (
7 name TEXT NOT NULL, -- i18n
8 owner INT NOT NULL REFERENCES actor.org_unit (id) ON DELETE CASCADE DEFERRABLE INITIALLY DEFERRED,
9 pos INT NOT NULL DEFAULT 0,
10 top BOOL NOT NULL DEFAULT FALSE,
11 opac_visible BOOL NOT NULL DEFAULT TRUE,
12 CONSTRAINT lgroup_once_per_owner UNIQUE (owner,name)
15 CREATE TABLE asset.copy_location_group_map (
16 id SERIAL PRIMARY KEY,
17 location INT NOT NULL REFERENCES asset.copy_location (id) ON DELETE CASCADE DEFERRABLE INITIALLY DEFERRED,
18 lgroup INT NOT NULL REFERENCES asset.copy_location_group (id) ON DELETE CASCADE DEFERRABLE INITIALLY DEFERRED,
19 CONSTRAINT lgroup_once_per_group UNIQUE (lgroup,location)
26 DROP TABLE asset.copy_location_group_map;
27 DROP TABLE asset.copy_location_group;