From 9d3b50b5acc49d03347325ff52c0c975e82dfac4 Mon Sep 17 00:00:00 2001 From: Terran McCanna Date: Thu, 8 Jul 2021 16:56:05 -0400 Subject: [PATCH] LP1902939 Add internet access level - upgrade script Add new field to upgrade script Signed-off-by: Terran McCanna --- Open-ILS/src/sql/Pg/upgrade/XXXX.schema.student_cards.sql | 3 ++- 1 file changed, 2 insertions(+), 1 deletion(-) diff --git a/Open-ILS/src/sql/Pg/upgrade/XXXX.schema.student_cards.sql b/Open-ILS/src/sql/Pg/upgrade/XXXX.schema.student_cards.sql index 6dc5aa1bff..6361a36a57 100644 --- a/Open-ILS/src/sql/Pg/upgrade/XXXX.schema.student_cards.sql +++ b/Open-ILS/src/sql/Pg/upgrade/XXXX.schema.student_cards.sql @@ -29,7 +29,8 @@ CREATE TABLE student_card.school ( addr_state TEXT, addr_post_code TEXT, eg_perm_group INTEGER NOT NULL REFERENCES permission.grp_tree (id), - home_ou INTEGER NOT NULL REFERENCES actor.org_unit (id) + home_ou INTEGER NOT NULL REFERENCES actor.org_unit (id), + net_access INTEGER NOT NULL REFERENCES config.net_access_level (id) ); CREATE UNIQUE INDEX student_card_school_state_id_idx ON student_card.school (district_id, state_id); -- 2.11.0