From c32bb8b82dd399e929af73c0f347722aa57e9e3d Mon Sep 17 00:00:00 2001 From: Jane Sandberg Date: Tue, 14 Jan 2020 18:52:44 -0800 Subject: [PATCH] LP1859728: Add missing column to course materials user table Signed-off-by: Jane Sandberg Signed-off-by: Michele Morgan Signed-off-by: Galen Charlton --- Open-ILS/src/sql/Pg/040.schema.asset.sql | 3 ++- .../src/sql/Pg/upgrade/XXXX.schema.course-materials-module.sql | 3 ++- 2 files changed, 4 insertions(+), 2 deletions(-) diff --git a/Open-ILS/src/sql/Pg/040.schema.asset.sql b/Open-ILS/src/sql/Pg/040.schema.asset.sql index 7534094754..5a45e2a8fb 100644 --- a/Open-ILS/src/sql/Pg/040.schema.asset.sql +++ b/Open-ILS/src/sql/Pg/040.schema.asset.sql @@ -1118,7 +1118,8 @@ CREATE TABLE asset.course_module_course_users ( id SERIAL PRIMARY KEY, course INT NOT NULL REFERENCES asset.course_module_course (id), usr INT NOT NULL REFERENCES actor.usr (id), - usr_role TEXT + usr_role TEXT, + is_public BOOLEAN NOT NULL DEFAULT false ); CREATE TABLE asset.course_module_course_materials ( diff --git a/Open-ILS/src/sql/Pg/upgrade/XXXX.schema.course-materials-module.sql b/Open-ILS/src/sql/Pg/upgrade/XXXX.schema.course-materials-module.sql index 6b0031e786..d4e0d52242 100644 --- a/Open-ILS/src/sql/Pg/upgrade/XXXX.schema.course-materials-module.sql +++ b/Open-ILS/src/sql/Pg/upgrade/XXXX.schema.course-materials-module.sql @@ -15,7 +15,8 @@ CREATE TABLE asset.course_module_course_users ( id SERIAL PRIMARY KEY, course INT NOT NULL REFERENCES asset.course_module_course (id), usr INT NOT NULL REFERENCES actor.usr (id), - usr_role TEXT + usr_role TEXT, + is_public BOOLEAN NOT NULL DEFAULT false ); CREATE TABLE asset.course_module_course_materials ( -- 2.43.2