Index: openacs-4/packages/proctoring-support/sql/postgresql/proctoring-support-create.sql =================================================================== RCS file: /usr/local/cvsroot/openacs-4/packages/proctoring-support/sql/postgresql/Attic/proctoring-support-create.sql,v diff -u -r1.1.2.3 -r1.1.2.4 --- openacs-4/packages/proctoring-support/sql/postgresql/proctoring-support-create.sql 20 Jan 2021 16:21:54 -0000 1.1.2.3 +++ openacs-4/packages/proctoring-support/sql/postgresql/proctoring-support-create.sql 9 Jun 2021 15:55:53 -0000 1.1.2.4 @@ -52,3 +52,19 @@ create index proctoring_examination_statement_acceptance_user_id_idx on proctoring_examination_statement_acceptance(user_id); + +create table proctoring_safe_exam_browser_conf ( + object_id integer primary key + references acs_objects(object_id) on delete cascade, + seb_file text not null -- the file created via the SEB + -- exam configuration that will + -- configure the clients + -- accessing this proctored + -- object + key text not null, -- the keys generated during the SEB + -- configuration that have been allowed + -- access to this exam +); + +create index proctoring_safe_exam_browser_conf_object_id_idx on + proctoring_safe_exam_browser_conf(object_id);