1 -- Evergreen DB patch 0606.schema.czs_use_perm_column.sql
3 -- This adds a column to config.z3950_source called use_perm.
4 -- The idea is that if a permission is set for a given source,
5 -- then staff will need the referenced permission to use that
10 -- check whether patch can be applied
11 SELECT evergreen.upgrade_deps_block_check('0606', :eg_version);
13 ALTER TABLE config.z3950_source
14 ADD COLUMN use_perm INT REFERENCES permission.perm_list (id) ON DELETE SET NULL DEFERRABLE INITIALLY DEFERRED;
16 COMMENT ON COLUMN config.z3950_source.use_perm IS $$
17 If set, this permission is required for the source to be listed in the staff
18 client Z39.50 interface. Similar to permission.grp_tree.application_perm.