3 SELECT evergreen.upgrade_deps_block_check('XXXX', :eg_version);
5 CREATE TABLE asset.course_module_course (
8 course_number TEXT NOT NULL,
10 owning_lib INT REFERENCES actor.org_unit (id)
13 CREATE TABLE asset.course_module_course_users (
14 id SERIAL PRIMARY KEY,
15 course INT NOT NULL REFERENCES asset.course_module_course (id),
16 usr INT NOT NULL REFERENCES actor.usr (id),
20 CREATE TABLE asset.course_module_course_materials (
21 id SERIAL PRIMARY KEY,
22 course INT NOT NULL REFERENCES asset.course_module_course (id),
23 item INT NOT NULL REFERENCES asset.copy (id),
27 CREATE TABLE asset.course_module_non_cat_course_materials (
28 id SERIAL PRIMARY KEY,
29 course INT NOT NULL REFERENCES asset.course_module_course (id),
35 INSERT INTO permission.perm_list(id, code, description)
41 'Allows user to manage Courses, Course Materials, and associate Users with Courses.',
47 INSERT INTO permission.grp_perm_map(perm, grp, depth) VALUES (624, 9, 0), (624, 11, 0), (624, 12, 0), (624, 13, 0);
49 INSERT INTO config.org_unit_setting_type
50 (grp, name, datatype, label, description)
53 'circ.course_materials_opt_in', 'bool',
55 'circ.course_materials_opt_in',
56 'Opt Org Unit into the Course Materials Module',
61 'circ.course_materials_opt_in',
62 'If enabled, the Org Unit will utilize Course Material functionality.'