From c1d7e7ad88790d45d8eb01e851adda77f8bc72e8 Mon Sep 17 00:00:00 2001 From: Chris Sharp Date: Wed, 29 Sep 2021 10:18:10 -0400 Subject: [PATCH] LP#1902939: name uniqueness should be per-district Signed-off-by: Chris Sharp --- Open-ILS/src/sql/Pg/upgrade/XXXX.schema.student_cards.sql | 2 +- 1 file changed, 1 insertion(+), 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 0d02503b08..3e491e14de 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 @@ -19,7 +19,7 @@ CREATE TABLE student_card.district ( CREATE TABLE student_card.school ( id SERIAL PRIMARY KEY, district_id INTEGER NOT NULL REFERENCES student_card.district (id), - name TEXT NOT NULL UNIQUE, + name TEXT NOT NULL, state_id INTEGER NOT NULL, -- school ID per the State of Georgia grades TEXT, addr_street_1 TEXT, -- 2.11.0