From 7199e375d2e5f6ef43c834582d8251f3e0fe7567 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 --- Open-ILS/src/sql/Pg/040.schema.asset.sql | 3 ++- Open-ILS/src/sql/Pg/upgrade/XXXX.schema.course-materials-module.sql | 5 +++-- 2 files changed, 5 insertions(+), 3 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 48d36935f0..73eed26aab 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 ( @@ -72,4 +73,4 @@ VALUES ( ) ); -COMMIT; \ No newline at end of file +COMMIT; -- 2.11.0