From 6462ffa17723ff2f602e981ef4847e47dc0a1e7e Mon Sep 17 00:00:00 2001 From: "Karl O. Pinc kop@karlpinc.com" Date: Fri, 19 Jan 2024 14:25:01 +0000 Subject: [PATCH] Align community code max length with that of the code table --- db/schemas/sokwedb/tables/create/comm_membs.m4 | 2 +- 1 file changed, 1 insertion(+), 1 deletion(-) diff --git a/db/schemas/sokwedb/tables/create/comm_membs.m4 b/db/schemas/sokwedb/tables/create/comm_membs.m4 index 80cca36..82dff65 100644 --- a/db/schemas/sokwedb/tables/create/comm_membs.m4 +++ b/db/schemas/sokwedb/tables/create/comm_membs.m4 @@ -28,7 +28,7 @@ CREATE TABLE comm_membs ( ,animid_column(`animid', `AnimID', `NOT NULL') ,startdate DATE NOT NULL ,enddate DATE NOT NULL - ,commid CHAR(1) NOT NULL + ,commid TEXT NOT NULL CONSTRAINT "CommID must be a COMM_IDS.CommID value" REFERENCES comm_ids (commid) ,startsource TEXT NOT NULL -- 2.34.1